Changeset 13910
- Timestamp:
- 2007/05/31 17:01:24 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/class/SC_CustomerList.php
r13511 r13910 206 206 $sql_where = ""; 207 207 $domain = $this->arrSql['domain']; 208 //¥É¥á¥¤¥ó»ØÄê»þ 209 if($domain == 2 || $domain == 3) { 210 foreach($arrDomainType as $val) { 211 //PC¥É¥á¥¤¥ó 212 if($domain == 2) { 213 if($sql_where == "") { 214 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 215 } else { 216 $sql_where .= "AND dtb_customer.email NOT LIKE ? " ; 217 } 218 } 219 //·ÈÂӥɥᥤ¥ó 220 if($domain == 3) { 221 if($sql_where == "") { 222 $sql_where .= "dtb_customer.email ILIKE ? "; 223 } else { 224 $sql_where .= "OR dtb_customer.email LIKE ? " ; 225 } 226 } 227 $this->arrVal[] = $this->addSearchStr($val); 228 } 229 $this->setWhere($sql_where); 230 } 208 foreach($arrDomainType as $val) { 209 //PC¥É¥á¥¤¥ó 210 if($domain == 2) { 211 if($sql_where == "") { 212 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 213 } else { 214 $sql_where .= "AND dtb_customer.email NOT LIKE ? " ; 215 } 216 } 217 //·ÈÂӥɥᥤ¥ó 218 if($domain == 3) { 219 if($sql_where == "") { 220 $sql_where .= "dtb_customer.email ILIKE ? "; 221 } else { 222 $sql_where .= "OR dtb_customer.email LIKE ? " ; 223 } 224 } 225 $this->arrVal[] = $this->addSearchStr($val); 226 } 227 $this->setWhere($sql_where); 231 228 } 232 229
Note: See TracChangeset
for help on using the changeset viewer.