Changeset 21259 for branches/version-2_11-dev/data/class/SC_Customer.php

Timestamp:

2011/09/27 01:04:48 (13 years ago)

Author:

tao

Message:

#1248 会員情報の受注を更新する様に修正

File:

• branches/version-2_11-dev/data/class/SC_Customer.php (modified) (1 diff)

branches/version-2_11-dev/data/class/SC_Customer.php

@@ -300 +300 @@
         }
     }
+    
+    //受注関連の顧客情報を更新
+    function updateOrderSummary($customer_id){
+        $objQuery = new SC_Query_Ex();
+        $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));
+        $objQuery->update("dtb_customer",$arrOrderSummary,"customer_id = ?",array($customer_id));
+    }
 }
 ?>