Changeset 11634 for branches/dev/data

Timestamp:

2007/03/09 00:07:24 (19 years ago)

Author:

uehara

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

@@ -175 +175 @@
                     
                     if($sql_where == "") {
-                        $sql_where .= "(dtb_customer.email NOT ILIKE ? OR dtb_customer.email_maile NOT ILIKE ?) ";
+                        $sql_where .= "(dtb_customer.email NOT ILIKE ? OR dtb_customer.email_mobile NOT ILIKE ?) ";
                     } else {
-                        $sql_where .= "AND (dtb_customer.email NOT ILIKE ? OR dtb_customer.email_maile NOT ILIKE ?) ";
+                        $sql_where .= "AND (dtb_customer.email NOT ILIKE ? OR dtb_customer.email_mobile NOT ILIKE ?) ";
                     }
                     
                 } else {                
                     if($sql_where == "") {
-                        $sql_where .= "(dtb_customer.email ILIKE ? OR dtb_customer.email_maile ILIKE ?) ";
+                        $sql_where .= "(dtb_customer.email ILIKE ? OR dtb_customer.email_mobile ILIKE ?) ";
                     } else {
-                        $sql_where .= "OR (dtb_customer.email ILIKE ? OR dtb_customer.email_maile ILIKE ?)  ";
+                        $sql_where .= "OR (dtb_customer.email ILIKE ? OR dtb_customer.email_mobile ILIKE ?)  ";
                     }
                 }
                 $searchEmail = $this->addSearchStr($val);
+                $this->arrVal[] = $searchEmail;
                 $this->arrVal[] = $searchEmail;
             }