Changeset 23503 for branches/version-2_13-dev/data/class/SC_Customer.php
- Timestamp:
- 2014/06/03 14:51:51 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/SC_Customer.php
r23491 r23503 291 291 { 292 292 $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));294 $objQuery->update('dtb_customer', $arrOrderSummary,'customer_id = ?',array($customer_id));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)); 294 $objQuery->update('dtb_customer', $arrOrderSummary, 'customer_id = ?', array($customer_id)); 295 295 } 296 296
Note: See TracChangeset
for help on using the changeset viewer.
