Ignore:
Timestamp:
2010/06/23 12:10:44 (12 years ago)
Author:
nanasess
bzr:base-revision:
ohkouchi@loop-az.jp-20100623022146-0zy5htqn96ust7uf
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php 15568@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcustomer%2FLC_Page_Admin_Customer_Edit.php
data/class/pages/entry/LC_Page_Entry.php 15141@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fentry%2FLC_Page_Entry.php
data/class/pages/mypage/LC_Page_Mypage_Change.php 16070@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Change.php
bzr:mapping-version:
v4
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20100623031040-3rrnq10falxw42u7
bzr:revno:
1978
bzr:revprop:branch-nick:
branches/version-2_4-dev
bzr:root:
branches/version-2_4-dev
bzr:text-parents:

data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php ohkouchi@loop-az.jp-20100614081324-0g78bhcmvqs3d6ts
data/class/pages/entry/LC_Page_Entry.php ohkouchi@loop-az.jp-20100614081324-0g78bhcmvqs3d6ts
data/class/pages/mypage/LC_Page_Mypage_Change.php ohkouchi@loop-az.jp-20100614081324-0g78bhcmvqs3d6ts
bzr:timestamp:
2010-06-23 12:10:40.684999943 +0900
bzr:user-agent:
bzr2.1.2+bzr-svn1.0.2
svn:original-date:
2010-06-23T03:10:40.685000Z
Message:

検索条件を修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_4-dev/data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php

    r18699 r18739  
    290290        if (strlen($array["email"]) > 0) { 
    291291            $array['email'] = strtolower($array['email']); 
    292             $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
     292            $sql = "SELECT customer_id FROM dtb_customer WHERE (email ILIKE ? escape '#' OR email_mobile ILIKE ? escape '#') AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
    293293            $checkMail = ereg_replace( "_", "#_", $array["email"]); 
    294             $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"])); 
     294            $result = $this->objConn->getAll($sql, array($checkMail, $checkMail, $array["customer_id"])); 
    295295            if (count($result) > 0) { 
    296296                $objErr->arrErr["email"] .= "※ すでに登録されているメールアドレスです。"; 
     
    302302        if (strlen($array["email_mobile"]) > 0) { 
    303303            $array['email_mobile'] = strtolower($array['email_mobile']); 
    304             $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 <> ?"; 
     304            $sql = "SELECT customer_id FROM dtb_customer WHERE (email ILIKE ? escape '#' OR email_mobile ILIKE ? escape '#') AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; 
    305305            $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]); 
    306             $result = $this->objConn->getAll($sql, array($checkMail, $array["customer_id"])); 
     306            $result = $this->objConn->getAll($sql, array($checkMail, $checkMail, $array["customer_id"])); 
    307307            if (count($result) > 0) { 
    308308                $objErr->arrErr["email_mobile"] .= "※ すでに登録されているメールアドレス(モバイル)です。"; 
Note: See TracChangeset for help on using the changeset viewer.