Changeset 12531 for branches/dev/data/class/SC_CustomerList.php
- Timestamp:
- 2007/05/10 22:18:43 (19 years ago)
- File:
-
- 1 edited
-
branches/dev/data/class/SC_CustomerList.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/class/SC_CustomerList.php
r12530 r12531 211 211 if($domain == 2) { 212 212 switch($this->arrSql['mail_type']){ 213 case '1': 214 if($sql_where == "") { 215 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 216 } else { 217 $sql_where .= "AND dtb_customer.email NOT LIKE ? " ; 218 } 219 break; 220 case '2': 221 if($sql_where == "") { 222 $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? "; 223 } else { 224 $sql_where .= "AND dtb_customer.email_mobile NOT LIKE ? " ; 225 } 226 break; 213 //¥Ñ¥½¥³¥óÍÑ 214 case '1': 215 if($sql_where == "") { 216 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 217 } else { 218 $sql_where .= "AND dtb_customer.email NOT LIKE ? " ; 219 } 220 break; 221 //·ÈÂÓÍÑ 222 case '2': 223 if($sql_where == "") { 224 $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? "; 225 } else { 226 $sql_where .= "AND dtb_customer.email_mobile NOT LIKE ? " ; 227 } 228 break; 227 229 } 228 230 } … … 230 232 if($domain == 3) { 231 233 switch($this->arrSql['mail_type']){ 232 case '1': 233 if($sql_where == "") { 234 $sql_where .= "dtb_customer.email ILIKE ? "; 235 } else { 236 $sql_where .= "OR dtb_customer.email LIKE ? " ; 237 } 238 break; 239 case '2': 240 if($sql_where == "") { 241 $sql_where .= "dtb_customer.email_mobile ILIKE ? "; 242 } else { 243 $sql_where .= "OR dtb_customer.email_mobile LIKE ? " ; 244 } 245 break; 234 //¥Ñ¥½¥³¥óÍÑ 235 case '1': 236 if($sql_where == "") { 237 $sql_where .= "dtb_customer.email ILIKE ? "; 238 } else { 239 $sql_where .= "OR dtb_customer.email LIKE ? " ; 240 } 241 break; 242 //·ÈÂÓÍÑ 243 case '2': 244 if($sql_where == "") { 245 $sql_where .= "dtb_customer.email_mobile ILIKE ? "; 246 } else { 247 $sql_where .= "OR dtb_customer.email_mobile LIKE ? " ; 248 } 249 break; 246 250 } 247 251 }
Note: See TracChangeset
for help on using the changeset viewer.
