Changeset 12498

Timestamp:

2007/05/10 19:40:24 (17 years ago)

Author:

matsumoto

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

@@ -209 +209 @@
                       4 => "vodafone.ne.jp"
                   );
-            foreach($arrDomainType as $val) {
-                $domain = ($this->arrSql['domain']);
-                //¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó»ØÄê
-                if($domain==3){
-                    if($this->arrSql['mail_type']==1){
-                        if($sql_where == "") {
-                            $sql_where = "dtb_customer.email ILIKE ? ";
-                        } else {
+            $domain = ($this->arrSql['domain']);
+            //¥É¥á¥¤¥ó»ØÄê»þ
+            if($domain == 2 || $domain == 3) {
+                //PC¥É¥á¥¤¥ó
+                if($domain == 2) {
+                    foreach($arrDomainType as $val) { 
+                        if($this->arrSql['mail_type']==1 ){
+                            if($sql_where == "") {
+                            $sql_where .= "dtb_customer.email NOT ILIKE ? ";
+                            } else {
+                            $sql_where .= "AND dtb_customer.email NOT LIKE ? " ;
+                            }
+                        }elseif($this->arrSql['mail_type']==2){
+                            if($sql_where == "") {
+                            $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
+                            } else {
+                            $sql_where .= "AND dtb_customer.email _mobile NOT LIKE ? " ;
+                            }
+                        }
+                        $searchDomain = $this->addSearchStr($val);
+                        $this->arrVal[] = $searchDomain;
+                    }
+                }
+                //¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó
+                if($domain == 3) {
+                    foreach($arrDomainType as $val) { 
+                        if($this->arrSql['mail_type']==1 ){
+                            if($sql_where == "") {
+                            $sql_where .= "dtb_customer.email ILIKE ? ";
+                            } else {
                             $sql_where .= "OR dtb_customer.email LIKE ? " ;
-                        }
-                    }elseif($this->arrSql['mail_type']==2){
-                           $sql_where .= "OR dtb_customer.email_mobile LIKE ? " ;
-                    }
-                }
-                //£Ð£Ã¥É¥á¥¤¥ó»ØÄê
-                if($domain==2){
-                    if($this->arrSql['mail_type']==1){
-                        $sql_where .= "AND email NOT LIKE ? " ;
-                }elseif($this->arrSql['mail_type']==2){
-                        $sql_where .= "AND email_mobile NOT LIKE ? " ;
-                    }
-                }
-                $searchDomain = $this->addSearchStr($val);
-                $this->arrVal[] = $searchDomain;
-            }
-            print_r($searchDomain);
-            $this->setWhere($sql_where);
-        }
-        
-        
+                            }
+                        }elseif($this->arrSql['mail_type']==2){
+                            if($sql_where == "") {
+                            $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
+                            } else {
+                            $sql_where .= "OR dtb_customer.email _mobile NOT LIKE ? " ;
+                            }
+                        }
+                        $searchDomain = $this->addSearchStr($val);
+                        $this->arrVal[] = $searchDomain;
+                    }
+                }
+                        print_r($searchDomain);
+            }  
 print_r($this->arrSql);
 print_r($this->arrVal);