Changeset 23517


Ignore:
Timestamp:
2014/06/03 23:18:25 (7 years ago)
Author:
shutta
Message:

#2448 typo修正・ソース整形・ソースコメントの改善 for 2.13.3
1行の文字数が長過ぎるのを調整。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_13-dev/data/class/SC_Customer.php

    r23512 r23517  
    291291    { 
    292292        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    293         $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)); 
     293 
     294        $col = <<< __EOS__ 
     295            SUM( payment_total) AS buy_total, 
     296            COUNT(order_id) AS buy_times, 
     297            MAX( create_date) AS last_buy_date, 
     298            MIN(create_date) AS first_buy_date 
     299__EOS__; 
     300        $table = 'dtb_order'; 
     301        $where = 'customer_id = ? AND del_flg = 0 AND status <> ?'; 
     302        $arrWhereVal = array($customer_id, ORDER_CANCEL); 
     303        $arrOrderSummary = $objQuery->getRow($col, $table, $where, $arrWhereVal); 
     304 
    294305        $objQuery->update('dtb_customer', $arrOrderSummary, 'customer_id = ?', array($customer_id)); 
    295306    } 
Note: See TracChangeset for help on using the changeset viewer.