Changeset 12529

Timestamp:

2007/05/10 21:04:31 (17 years ago)

Author:

matsumoto

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

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