Changeset 21445 for branches/version-2_12-dev/data/class/SC_Customer.php
- Timestamp:
- 2012/02/06 21:31:07 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_Customer.php
r21444 r21445 303 303 function updateOrderSummary($customer_id){ 304 304 $objQuery = new SC_Query_Ex(); 305 $arrOrderSummary = $objQuery->getRow("SUM( payment_total 305 $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)); 306 306 $objQuery->update("dtb_customer",$arrOrderSummary,"customer_id = ?",array($customer_id)); 307 307 }
Note: See TracChangeset
for help on using the changeset viewer.