Changeset 4847 for temp/trunk

Timestamp:

2006/09/17 13:57:36 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/class/SC_CustomerList.php (modified) (1 diff)
• data/lib/slib.php (modified) (2 diffs)
• html/admin/mail/index.php (modified) (2 diffs)

temp/trunk/data/class/SC_CustomerList.php

@@ -130 +130 @@
                 if($this->arrSql['not_emailinc'] == '1') {
                     if($sql_where == "") {
-                        $sql_where .= "email NOT ILIKE ? ";
+                        $sql_where .= "dtb_customer.email NOT ILIKE ? ";
                     } else {
-                        $sql_where .= "AND email NOT ILIKE ? ";
+                        $sql_where .= "AND dtb_customer.email NOT ILIKE ? ";
                     }
                 } else {                
                     if($sql_where == "") {
-                        $sql_where .= "email ILIKE ? ";
+                        $sql_where .= "dtb_customer.email ILIKE ? ";
                     } else {
-                        $sql_where .= "OR email ILIKE ? ";
+                        $sql_where .= "OR dtb_customer.email ILIKE ? ";
                     }
                 }

temp/trunk/data/lib/slib.php

@@ -2358 +2358 @@
     
     $sql = sfChangeView($sql);      // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
-    $sql = sfChangeILIKE($sql); // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
-    
+    $sql = sfChangeILIKE($sql);     // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
+    $sql = sfChangeLIKE($sql);      // LIKE¸¡º÷¤òLIKE BINARY¸¡º÷¤ËÊÑ´¹¤¹¤ë
+
     return $sql;
 }
@@ -2390 +2391 @@
     return $changesql;
 }
+
+// LIKE¸¡º÷¤òLIKE BINARY¸¡º÷¤ËÊÑ´¹¤¹¤ë
+function sfChangeLIKE($sql){
+    $changesql = eregi_replace("( LIKE )", " LIKE BINARY ", $sql);
+    return $changesql;
+}
+
 
 /* ¥Ç¥Ð¥Ã¥°ÍÑ ------------------------------------------------------------------------------------------------*/

temp/trunk/html/admin/mail/index.php

@@ -135 +135 @@
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
         $objQuery = new SC_Query();
-        $from = "dtb_customer_mail as mail LEFT OUTER JOIN dtb_customer as cus USING(email)";
+        $from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
 
         // ¹Ô¿ô¤Î¼èÆÀ
@@ -151 +151 @@
         $objQuery->setorder("customer_id DESC");
         // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-        $col = "cus.customer_id,cus.name01,cus.name02,cus.kana01,cus.kana02,cus.sex,cus.email,cus.tel01,cus.tel02,cus.tel03,cus.pref,mail.mail_flag";
+        $col = "dtb_customer.customer_id,
+            dtb_customer.name01,
+            dtb_customer.name02,
+            dtb_customer.kana01,
+            dtb_customer.kana02,
+            dtb_customer.sex,
+            dtb_customer.email,
+            dtb_customer.tel01,
+            dtb_customer.tel02,
+            dtb_customer.tel03,
+            dtb_customer.pref,
+            dtb_customer_mail.mail_flag";
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);