Changeset 11411 for temp/branches/mobile/data/class/SC_Customer.php

Timestamp:

2007/02/08 13:54:58 (19 years ago)

Author:

rebelt

Message:

修正です。

File:

• temp/branches/mobile/data/class/SC_Customer.php (modified) (1 diff)

temp/branches/mobile/data/class/SC_Customer.php

@@ -50 +50 @@
     }
     
-    function getCustomerDataFromEmailPass( $pass, $email ) {
+    function getCustomerDataFromEmailPass( $pass, $email, $mobile = false ) {
+        $sql_mobile = $mobile ? ' OR email_mobile ILIKE ?' : '';
+        $arrValues = array($email);
+        if ($mobile) {
+            $arrValues[] = $email;
+        }
         // ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß
-        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
-        $result = $this->conn->getAll($sql, array($email));
+        $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2";
+        $result = $this->conn->getAll($sql, $arrValues);
         $data = $result[0];