Changeset 11411


Ignore:
Timestamp:
2007/02/08 13:54:58 (17 years ago)
Author:
rebelt
Message:

修正です。

Location:
temp/branches/mobile
Files:
7 edited

Legend:

Unmodified
Added
Removed
  • temp/branches/mobile/data/class/SC_CheckError.php

    r10358 r11411  
    711711        } 
    712712    }    
     713     
     714    /*¡¡·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹¤ÎȽÄê¡¡*/ 
     715    // value[0] = ¹àÌÜ̾ value[1] = ȽÄêÂоݥ᡼¥ë¥¢¥É¥ì¥¹ 
     716    function MOBILE_EMAIL_CHECK( $value ){              //¡¡¥á¡¼¥ë¥¢¥É¥ì¥¹¤òÀµµ¬É½¸½¤ÇȽÄꤹ¤ë 
     717        if(isset($this->arrErr[$value[1]])) { 
     718            return; 
     719        } 
     720        if(strlen($this->arrParam[$value[1]]) > 0 && !gfIsMobileMailAddress($this->arrParam[$value[1]])) { 
     721            $this->arrErr[$value[1]] = "¢¨ " . $value[0] . "¤Ï·ÈÂÓÅÅÏäΤâ¤Î¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£<br />"; 
     722        } 
     723    }        
    713724} 
    714725?> 
  • temp/branches/mobile/data/class/SC_Customer.php

    r11405 r11411  
    5050    } 
    5151     
    52     function getCustomerDataFromEmailPass( $pass, $email ) { 
     52    function getCustomerDataFromEmailPass( $pass, $email, $mobile = false ) { 
     53        $sql_mobile = $mobile ? ' OR email_mobile ILIKE ?' : ''; 
     54        $arrValues = array($email); 
     55        if ($mobile) { 
     56            $arrValues[] = $email; 
     57        } 
    5358        // ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß 
    54         $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2"; 
    55         $result = $this->conn->getAll($sql, array($email)); 
     59        $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2"; 
     60        $result = $this->conn->getAll($sql, $arrValues); 
    5661        $data = $result[0]; 
    5762         
  • temp/branches/mobile/data/class/SC_FormParam.php

    r10373 r11411  
    155155                case 'DOMAIN_CHECK': 
    156156                case 'FILE_NAME_CHECK': 
     157                case 'MOBILE_EMAIL_CHECK': 
    157158                 
    158159                    if(!is_array($this->param[$cnt])) { 
  • temp/branches/mobile/html/mobile/entry/index.php

    r11409 r11411  
    259259    $arrRegist["first_buy_date"] = "";      // ºÇ½é¤Î¹ØÆþÆü 
    260260     
     261    // ·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹ 
     262    $arrRegist['email_mobile'] = $arrRegist['email']; 
     263 
    261264    //-- ²¾ÅÐÏ¿¼Â¹Ô 
    262265    $objConn->query("BEGIN"); 
     
    326329    $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 
    327330    $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 
    328     $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 
     331    $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK")); 
    329332 
    330333    //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉԲĠ
    331334    if (strlen($array["email"]) > 0) { 
    332335        $objQuery = new SC_Query(); 
    333         $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? ORDER BY del_flg", array($array["email"])); 
     336        $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"])); 
    334337                 
    335338        if(count($arrRet) > 0) { 
  • temp/branches/mobile/html/mobile/forgot/index.php

    r11406 r11411  
    3737    //¥á¥¢¥ÉÆþÎÏ»þ 
    3838    $_POST['email'] = strtolower($_POST['email']); 
    39     $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND del_flg = 0"; 
    40     $result = $conn->getAll($sql, array($_POST['email']) ); 
     39    $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ? OR email_mobile ILIKE ?) AND status = 2 AND del_flg = 0"; 
     40    $result = $conn->getAll($sql, array($_POST['email'], $_POST['email']) ); 
    4141     
    4242    if ( $result[0]['reminder'] ){      // Ëܲñ°÷ÅÐÏ¿ºÑ¤ß¤Î¾ì¹ç 
     
    6363        // ¥Ò¥ß¥Ä¤ÎÅú¤¨¤Î²óÅú¤¬Àµ¤·¤¤¤«¥Á¥§¥Ã¥¯ 
    6464         
    65         $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0"; 
    66         $result = $conn->getAll($sql, array($_SESSION['forgot']['email']) ); 
     65        $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ? OR email_mobile ILIKE ?) AND del_flg = 0"; 
     66        $result = $conn->getAll($sql, array($_SESSION['forgot']['email'], $_SESSION['forgot']['email']) ); 
    6767        $data = $result[0]; 
    6868         
  • temp/branches/mobile/html/mobile/regist/index.php

    r11409 r11411  
    4848        $email = $objQuery->get("dtb_customer", "email", "secret_key = ?", array($registSecretKey)); 
    4949        $objCustomer->setLogin($email); 
    50         header("Location: ./complete.php"); 
     50        header("Location: " . gfAddSessionId("./complete.php")); 
    5151        exit; 
    5252    } 
  • temp/branches/mobile/html/mobile/shopping/deliv.php

    r11409 r11411  
    7272        // ¥í¥°¥¤¥óȽÄê 
    7373        if(!$objCustomer->getCustomerDataFromMobilePhoneIdPass($arrForm['login_pass']) && 
    74            !$objCustomer->getCustomerDataFromEmailPass($arrForm['login_pass'], $arrForm['login_email'])) { 
     74           !$objCustomer->getCustomerDataFromEmailPass($arrForm['login_pass'], $arrForm['login_email'], true)) { 
    7575            // ²¾ÅÐÏ¿¤ÎȽÄê 
    7676            $objQuery = new SC_Query; 
Note: See TracChangeset for help on using the changeset viewer.