Changeset 12460

Timestamp:

2007/05/10 15:33:30 (17 years ago)

Author:

matsumoto

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (1 diff)

branches/dev/data/class/SC_CustomerList.php

@@ -201 +201 @@
         //¥É¥á¥¤¥ó»ØÄê
         if ( $mode == 'magazine' ){
-            $val = ($this->arrSql['domain']);
-            //¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó»ØÄê
-            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'" );
-            }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'" );
+            $sql_where = "";
+            foreach($arrDomainType as $val) {
+                $domain = ($this->arrSql['domain']);
+                //¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó»ØÄê
+                if($domain==3){
+                    if($this->arrSql['mail_type']==1){
+                        $sql_where .= "dtb_customer.email LIKE ? " ;
+                }elseif($this->arrSql['mail_type']==2){
+                        $sql_where .= "dtb_customer.email_mobile LIKE ? " ;
+                    }
                 }
-            }
-            //£Ð£Ã¥É¥á¥¤¥ó»ØÄê
-            if($val==2){
-                if($this->arrSql['mail_type']==1){
-                $this->setWhere( "email NOT LIKE '%@docomo.ne.jp%' " .
-                        "AND email NOT LIKE '%@softbank.ne.jp%' " .
-                        "AND email NOT LIKE '%@ezweb.ne.jp%' " .
-                        "AND email NOT LIKE '%vodafone.ne.jp'" );
-            }elseif($this->arrSql['mail_type']==2){
-                $this->setWhere( "email_mobile NOT LIKE '%@docomo.ne.jp%' " .
-                        "AND email_mobile NOT LIKE '%@softbank.ne.jp%' " .
-                        "AND email_mobile NOT LIKE '%@ezweb.ne.jp%' " .
-                        "AND email_mobile NOT LIKE '%vodafone.ne.jp'" );
+                //£Ð£Ã¥É¥á¥¤¥ó»ØÄê
+                if($domain==2){
+                    if($this->arrSql['mail_type']==1){
+                        $sql_where .= "email NOT LIKE ? " ;
+                }elseif($this->arrSql['mail_type']==2){
+                        $sql_where .= "email_mobile NOT LIKE ? " ;
+                    }
                 }
-            }
+                $searchDomain = $this->addSearchEnd($val);
+                $this->arrVal[] = $searchDomain;
+            }
+            $this->setWhere($sql_where);
         }