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