Changeset 12441
- Timestamp:
- 2007/05/10 12:06:36 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/class/SC_CustomerList.php
r12439 r12441 207 207 $this->setWhere( "email LIKE '%@docomo.ne.jp%' OR email LIKE '%@softbank.ne.jp%' OR email LIKE '%@ezweb.ne.jp%' OR email LIKE '%vodafone.ne.jp'" ); 208 208 }elseif($this->arrSql['mail_type']==2){ 209 $this->setWhere( "email_mobile LIKE '%@docomo.ne.jp%' OR email_mobile LIKE '%@softbank.ne.jp%' OR email_mobile LIKE '%@ezweb.ne.jp%' OR email_mobile LIKE '% @vodafone.ne.jp'" );209 $this->setWhere( "email_mobile LIKE '%@docomo.ne.jp%' OR email_mobile LIKE '%@softbank.ne.jp%' OR email_mobile LIKE '%@ezweb.ne.jp%' OR email_mobile LIKE '%vodafone.ne.jp'" ); 210 210 } 211 211 } … … 213 213 if($val==2){ 214 214 if($this->arrSql['mail_type']==1){ 215 $this->setWhere( "email NOT ILIKE '%@docomo.ne.jp%' AND email NOT ILIKE '%@softbank.ne.jp%' AND email NOT ILIKE '%@ezweb.ne.jp%' AND email NOT ILIKE '% @vodafone.ne.jp'" );215 $this->setWhere( "email NOT ILIKE '%@docomo.ne.jp%' AND email NOT ILIKE '%@softbank.ne.jp%' AND email NOT ILIKE '%@ezweb.ne.jp%' AND email NOT ILIKE '%vodafone.ne.jp'" ); 216 216 }elseif($this->arrSql['mail_type']==2){ 217 $this->setWhere( "email_mobile NOT ILIKE '%@docomo.ne.jp%' AND email_mobile NOT ILIKE '%@softbank.ne.jp%' AND email_mobile NOT ILIKE '%@ezweb.ne.jp%' AND email_mobile NOT ILIKE '% @vodafone.ne.jp'" );217 $this->setWhere( "email_mobile NOT ILIKE '%@docomo.ne.jp%' AND email_mobile NOT ILIKE '%@softbank.ne.jp%' AND email_mobile NOT ILIKE '%@ezweb.ne.jp%' AND email_mobile NOT ILIKE '%vodafone.ne.jp'" ); 218 218 } 219 219 }
Note: See TracChangeset
for help on using the changeset viewer.