Changeset 16087

Timestamp:

2007/09/27 15:44:53 (16 years ago)

Author:

nanasess

Message:

getCustomerDataFromEmailPass() 修正

File:

• branches/feature-module-update/data/class/SC_Customer.php (modified) (2 diffs)

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

@@ -50 +50 @@
     }
 
-    /*
-     * XXX ILIKE で良い?
-     */
     function getCustomerDataFromEmailPass( $pass, $email, $mobile = false ) {
-        $sql_mobile = $mobile ? ' OR email_mobile ILIKE ?' : '';
+        // 小文字に変換
+        $email = strtolower($email);
+        $sql_mobile = $mobile ? ' OR email_mobile = ?' : '';
         $arrValues = array($email);
         if ($mobile) {
@@ -60 +59 @@
         }
         // 本登録された会員のみ
-        $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2";
+        $sql = "SELECT * FROM dtb_customer WHERE (email = ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2";
         $result = $this->conn->getAll($sql, $arrValues);
         $data = $result[0];