Changeset 12527 for branches/dev/data/class/SC_CustomerList.php

Timestamp:

2007/05/10 20:56:57 (19 years ago)

Author:

matsumoto

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

@@ -210 +210 @@
                 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 ? " ;
-                            }
-                        } else {
-                            if($sql_where == "") {
-                            $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
-                            } else {
-                            $sql_where .= "AND dtb_customer.email_mobile NOT LIKE ? " ;
-                            }
+                        switch($this->arrSql['mail_type']){
+                            case '1':
+                                if($sql_where == "") {
+                                    $sql_where .= "dtb_customer.email NOT ILIKE ? ";
+                                } else {
+                                    $sql_where .= "AND dtb_customer.email NOT LIKE ? " ;
+                                }
+                                break;
+                            case '2':
+                                if($sql_where == "") {
+                                    $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
+                                } else {
+                                    $sql_where .= "AND dtb_customer.email_mobile NOT LIKE ? " ;
+                                }
+                                break;
+                            default:
+                                $sql_where ="";
+//                      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 ? " ;
+//                          }
+//                      } else {
+//                          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);