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