Ignore:
Timestamp:
2012/04/16 19:53:39 (14 years ago)
Author:
shutta
Message:

#1579 SC_Query::getSingletonInstance()への置き換え

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_12-dev/data/class/SC_Customer.php

    r21684 r21750  
    4343        // 本登録された会員のみ 
    4444        $sql = 'SELECT * FROM dtb_customer WHERE (email = ?' . $sql_mobile . ') AND del_flg = 0 AND status = 2'; 
    45         $objQuery = new SC_Query_Ex(); 
     45        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    4646        $result = $objQuery->getAll($sql, $arrValues); 
    4747        if (empty($result)) { 
    … …  
    123123 
    124124        // 携帯端末IDが一致し、本登録された会員を検索する。 
    125         $objQuery = new SC_Query_Ex(); 
     125        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    126126        $exists = $objQuery->exists('dtb_customer', 'mobile_phone_id = ? AND del_flg = 0 AND status = 2', array($_SESSION['mobile']['phone_id'])); 
    127127        return $exists; 
    … …  
    149149        // 携帯端末IDが一致し、本登録された会員を検索する。 
    150150        $sql = 'SELECT * FROM dtb_customer WHERE mobile_phone_id = ? AND del_flg = 0 AND status = 2'; 
    151         $objQuery = new SC_Query_Ex(); 
     151        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    152152        @list($data) = $objQuery->getAll($sql, array($_SESSION['mobile']['phone_id'])); 
    153153 
    … …  
    175175        } 
    176176 
    177         $objQuery = new SC_Query_Ex(); 
     177        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    178178        $sqlval = array('mobile_phone_id' => $_SESSION['mobile']['phone_id']); 
    179179        $where = 'customer_id = ? AND del_flg = 0 AND status = 2'; 
    … …  
    187187        // 本登録された会員のみ 
    188188        $sql = 'SELECT * FROM dtb_customer WHERE (email = ? OR email_mobile = ?) AND del_flg = 0 AND status = 2'; 
    189         $objQuery = new SC_Query_Ex(); 
     189        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    190190        $result = $objQuery->getAll($sql, array($email, $email)); 
    191191        $data = isset($result[0]) ? $result[0] : ''; 
    … …  
    198198        $sql = 'SELECT * FROM dtb_customer WHERE customer_id = ? AND del_flg = 0'; 
    199199        $customer_id = $this->getValue('customer_id'); 
    200         $objQuery = new SC_Query_Ex(); 
     200        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    201201        $arrRet = $objQuery->getAll($sql, array($customer_id)); 
    202202        $this->customer_data = isset($arrRet[0]) ? $arrRet[0] : ''; 
    … …  
    231231            && SC_Utils_Ex::sfIsInt($_SESSION['customer']['customer_id']) 
    232232        ) { 
    233             $objQuery = new SC_Query_Ex(); 
     233            $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    234234            $email = $objQuery->get('email', 'dtb_customer', 'customer_id = ?', array($_SESSION['customer']['customer_id'])); 
    235235            if ($email == $_SESSION['customer']['email']) { 
    … …  
    307307    //受注関連の会員情報を更新 
    308308    function updateOrderSummary($customer_id) { 
    309         $objQuery = new SC_Query_Ex(); 
     309        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    310310        $arrOrderSummary =  $objQuery->getRow('SUM( payment_total) as buy_total, COUNT(order_id) as buy_times,MAX( create_date) as last_buy_date, MIN(create_date) as first_buy_date','dtb_order','customer_id = ? AND del_flg = 0 AND status <> ?',array($customer_id,ORDER_CANCEL)); 
    311311        $objQuery->update('dtb_customer',$arrOrderSummary,'customer_id = ?',array($customer_id)); 
Note: See TracChangeset for help on using the changeset viewer.