Changeset 17741 for branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order_Status.php

Timestamp:

2009/01/13 22:41:55 (15 years ago)

Author:

x41

Message:

ステータスを発送にした場合にポイント付与するようにコミットしておりましたが、付与後のキャンセルや新規等に戻した場合にポイントを付与する前のポイント数に戻し、キャンセルの場合は使用したポイントも自動で返還されるにようにしました。キャンセルから新規に戻した場合は使用したポイントは再び自動で差し引きされます。

File:

• branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order_Status.php (modified) (2 diffs)

branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order_Status.php

@@ -160 +160 @@
         $where = 'order_id = ?';
         $arrUpdate = array('update_date' => 'NOW()');
-    $col = 'customer_id, add_point';
+    $col = 'customer_id, add_point, use_point, status';
 
         $delflg  = '1'; // 削除フラグ
@@ -184 +184 @@
                 if ( $val != "" ) {
         if ( $status_id == ORDER_DELIV ) {
-        $arrRet = $objQuery->select($col, $table, $where, array($val));
-        $customer_id = $arrRet[0]['customer_id'];
-        $add_point = $arrRet[0]['add_point'];
-        if($customer_id != "" && $customer_id >= 1) {
-            $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
-            $arrRet[0]['point']+= $add_point;
-            $sqlval['point'] = $arrRet[0]['point'];
-            $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
-           }
-        }
+        $arrRet = $objQuery->select($col, $table, $where, array($val));
+        $customer_id = $arrRet[0]['customer_id'];
+        $add_point = $arrRet[0]['add_point'];
+        $status = $arrRet[0]['status'];
+        if($customer_id != "" && $customer_id >= 1) {
+            $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
+            $arrRet[0]['point']+= $add_point;
+            $sqlval['point'] = $arrRet[0]['point'];
+            $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
+          }
+        }
+         elseif ( $status_id == ORDER_CANCEL ) {
+            $arrRet = $objQuery->select($col, $table, $where, array($val));
+            $customer_id = $arrRet[0]['customer_id'];
+            $add_point = $arrRet[0]['add_point'];
+            $use_point = $arrRet[0]['use_point'];
+            $status = $arrRet[0]['status'];
+            if($customer_id != "" && $customer_id >= 1) {
+               if($status == 5) {
+               $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
+               $arrRet[0]['point']-= $add_point;
+               $arrRet[0]['point']+= $use_point;
+               $sqlval['point'] = $arrRet[0]['point'];
+               $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
+            } else {
+               $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
+               $arrRet[0]['point']+= $use_point;
+               $sqlval['point'] = $arrRet[0]['point'];
+               $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
+            }
+          }
+        }
+        else {
+            $arrRet = $objQuery->select($col, $table, $where, array($val));
+            $customer_id = $arrRet[0]['customer_id'];
+            $add_point = $arrRet[0]['add_point'];
+            $use_point = $arrRet[0]['use_point'];
+            $status = $arrRet[0]['status'];
+            if($customer_id != "" && $customer_id >= 1) {
+               if($status == 5) {
+               $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
+               $arrRet[0]['point']-= $add_point;
+               $sqlval['point'] = $arrRet[0]['point'];
+               $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
+            }
+             elseif($status == 3) {
+               $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
+               $arrRet[0]['point']-= $use_point;
+               $sqlval['point'] = $arrRet[0]['point'];
+               $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
+            }
+            else {
+               $arrRet = $objQuery->select("point", 'dtb_customer', 'customer_id = ?', array($customer_id));
+               $sqlval['point'] = $arrRet[0]['point'];
+               $objQuery->update('dtb_customer', $sqlval, 'customer_id = ?', array($customer_id));
+            }
+          }
+         }
                     $objQuery->update($table, $arrUpdate, $where, array($val));
                 }