Changeset 14076

Timestamp:

2007/06/01 12:16:54 (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($this->arrSql['not_domaininc'] == '1') {
                         if($sql_where == "") {
-                            $sql_where .= "dtb_customer.email  ILIKE ? ";
+                            $sql_where .= "dtb_customer.email NOT ILIKE ? ";
                         } else {
-                            $sql_where .= "OR dtb_customer.email  ILIKE ? " ;
+                            $sql_where .= "AND dtb_customer.email NOT ILIKE ? " ;
                         }
                     } else {
                         if($sql_where == "") {
-                            $sql_where .= "dtb_customer.email NOT ILIKE ? ";
+                            $sql_where .= "dtb_customer.email ILIKE ? ";
                         } else {
-                            $sql_where .= "AND dtb_customer.email NOT ILIKE ? " ;
+                            $sql_where .= "OR dtb_customer.email ILIKE ? " ;
                         }
                     }