Changeset 16380


Ignore:
Timestamp:
2007/10/11 16:57:39 (14 years ago)
Author:
nanasess
Message:

email の ILIKE 検索を修正

Location:
branches/feature-module-update/data/class
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/SC_Customer.php

    r16364 r16380  
    171171    function setLogin($email) { 
    172172        // 本登録された会員のみ 
    173         $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2"; 
     173        $sql = "SELECT * FROM dtb_customer WHERE email = ? AND del_flg = 0 AND status = 2"; 
    174174        $result = $this->conn->getAll($sql, array($email)); 
    175175        $data = isset($result[0]) ? $result[0] : ""; 
  • branches/feature-module-update/data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php

    r16183 r16380  
    292292        //現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 
    293293        if (strlen($array["email"]) > 0) { 
    294             $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
     294            $array['email'] = strtolower($array['email']); 
     295            $sql = "SELECT customer_id FROM dtb_customer WHERE email = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
    295296            $checkMail = ereg_replace( "_", "#_", $array["email"]); 
    296297            $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"])); 
     
    303304        //現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 
    304305        if (strlen($array["email_mobile"]) > 0) { 
    305             $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 <> ?"; 
     306            $array['email_mobile'] = strtolower($array['email_mobile']); 
     307            $sql = "SELECT customer_id FROM dtb_customer WHERE email_mobile = ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
    306308            $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]); 
    307309            $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"])); 
  • branches/feature-module-update/data/class/pages/entry/LC_Page_Entry.php

    r16322 r16380  
    787787        //現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 
    788788        if (strlen($array["email"]) > 0) { 
     789            $array['email'] = strtolower($array['email']); 
    789790            $objQuery = new SC_Query(); 
    790             $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"])); 
     791            $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email = ? OR email_mobile = ? ORDER BY del_flg", array($array["email"], $array["email"])); 
    791792 
    792793            if(count($arrRet) > 0) { 
Note: See TracChangeset for help on using the changeset viewer.