Changeset 12522
- Timestamp:
- 2007/05/10 20:35:13 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/class/SC_CustomerList.php
r12521 r12522 207 207 //¥É¥á¥¤¥ó»ØÄê»þ 208 208 if($domain == 2 || $domain == 3) { 209 foreach($arrDomainType as $val) { 209 210 //PC¥É¥á¥¤¥ó 210 211 if($domain == 2) { 211 foreach($arrDomainType as $val) { 212 if($this->arrSql['mail_type'] == 1 ){ 213 if($sql_where == "") { 214 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 215 } else { 212 if($this->arrSql['mail_type'] == 1 ){ 213 if($sql_where == "") { 214 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 215 } else { 216 216 $sql_where .= "AND dtb_customer.email NOT LIKE ? " ; 217 218 219 217 } 218 } else { 219 if($sql_where == "") { 220 220 $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? "; 221 221 } else { … … 227 227 } 228 228 $this->setWhere($sql_where); 229 }230 229 //¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó 231 230 if($domain == 3) { 232 foreach($arrDomainType as $val) { 233 if($this->arrSql['mail_type'] == 1 ){ 234 if($sql_where == "") { 231 if($this->arrSql['mail_type'] == 1 ){ 232 if($sql_where == "") { 235 233 $sql_where .= "dtb_customer.email ILIKE ? "; 236 234 } else { 237 235 $sql_where .= "OR dtb_customer.email LIKE ? " ; 238 236 } 239 240 237 }else{ 238 if($sql_where == "") { 241 239 $sql_where .= "dtb_customer.email_mobile ILIKE ? "; 242 240 } else {
Note: See TracChangeset
for help on using the changeset viewer.