Changeset 16380

Timestamp:

2007/10/11 16:57:39 (17 years ago)

Author:

nanasess

Message:

email の ILIKE 検索を修正

Location:

branches/feature-module-update/data/class

Files:

• SC_Customer.php (modified) (1 diff)
• pages/admin/customer/LC_Page_Admin_Customer_Edit.php (modified) (2 diffs)
• pages/entry/LC_Page_Entry.php (modified) (1 diff)

branches/feature-module-update/data/class/SC_Customer.php

@@ -171 +171 @@
     function setLogin($email) {
         // 本登録された会員のみ
-        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
+        $sql = "SELECT * FROM dtb_customer WHERE email = ? AND del_flg = 0 AND status = 2";
         $result = $this->conn->getAll($sql, array($email));
         $data = isset($result[0]) ? $result[0] : "";

branches/feature-module-update/data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php

@@ -292 +292 @@
         //現会員の判定 →　現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可
         if (strlen($array["email"]) > 0) {
-            $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
+            $array['email'] = strtolower($array['email']);
+            $sql = "SELECT customer_id FROM dtb_customer WHERE email = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
             $checkMail = ereg_replace( "_", "#_", $array["email"]);
             $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"]));
@@ -303 +304 @@
         //現会員の判定 →　現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可
         if (strlen($array["email_mobile"]) > 0) {
-            $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
+            $array['email_mobile'] = strtolower($array['email_mobile']);
+            $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
             $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]);
             $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"]));

branches/feature-module-update/data/class/pages/entry/LC_Page_Entry.php

@@ -787 +787 @@
         //現会員の判定 →　現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可
         if (strlen($array["email"]) > 0) {
+            $array['email'] = strtolower($array['email']);
             $objQuery = new SC_Query();
-            $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? OR email_mobile ILIKE ? ORDER BY del_flg", array($array["email"], $array["email"]));
+            $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email = ? OR email_mobile = ? ORDER BY del_flg", array($array["email"], $array["email"]));
 
             if(count($arrRet) > 0) {