Changeset 21259

Timestamp:

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

Author:

tao

Message:

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

Location:

branches/version-2_11-dev/data/class

Files:

• SC_Customer.php (modified) (1 diff)
• helper/SC_Helper_Purchase.php (modified) (4 diffs)

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));
+    }
 }
 ?>

branches/version-2_11-dev/data/class/helper/SC_Helper_Purchase.php

@@ -84 +84 @@
         $this->registerShipping($orderId, $shippingTemp);
         $objQuery->commit();
+
+        //会員情報の最終購入日、購入合計を更新
+        if($customerId > 0){
+            SC_Customer_Ex::updateOrderSummary($customerId);
+        }
+
         $this->cleanupSession($orderId, $objCartSession, $objCustomer, $cartkey);
 
@@ -804 +810 @@
                           "order_temp_id = ?",
                           array(SC_SiteSession_Ex::getUniqId()));
-
+        
+        
+        
         return $orderParams['order_id'];
     }
@@ -1070 +1078 @@
     function sfUpdateOrderStatus($orderId, $newStatus = null, $newAddPoint = null, $newUsePoint = null, &$sqlval) {
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-
         $arrOrderOld = $objQuery->getRow('status, add_point, use_point, customer_id', 'dtb_order', 'order_id = ?', array($orderId));
 
@@ -1163 +1170 @@
         $objQuery->update('dtb_order', $dest, 'order_id = ?', array($orderId));
         // ▲受注テーブルの更新
+
+        //会員情報の最終購入日、購入合計を更新
+        if($arrOrderOld['customer_id'] > 0 and $arrOrderOld['status'] != $newStatus){
+            SC_Customer_Ex::updateOrderSummary($arrOrderOld['customer_id']);
+        }
     }