Changeset 12453

Timestamp:

2007/05/10 13:12:23 (19 years ago)

Author:

matsumoto

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (2 diffs)

branches/dev/data/class/SC_CustomerList.php

@@ -205 +205 @@
             if($val==3){
                 if($this->arrSql['mail_type']==1){
-                $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'" );
+                $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'" );
             }elseif($this->arrSql['mail_type']==2){
-                $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'" );
+                $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'" );
                 }
             }
@@ -213 +219 @@
             if($val==2){
                 if($this->arrSql['mail_type']==1){
-                $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'" );
+                $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'" );
             }elseif($this->arrSql['mail_type']==2){
-                $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'" );
+                $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'" );
                 }
             }