Changeset 17947

Timestamp:

2009/03/31 12:24:33 (15 years ago)

Author:

kajiwara

Message:

#292 受注管理よりステータスを発送済にした時、エラーが表示されるバグ（postgresqlにて確認）を改修。（最終確認にて発見されたため、コミットします。）

File:

• branches/version-2_4/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php (modified) (4 diffs)

branches/version-2_4/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php

@@ -534 +534 @@
         $where = "order_id = ?";
 
-        // 受注ステータスの判定
-        if ($sqlval['status'] == ODERSTATUS_COMMIT) {
-            // 受注テーブルの発送済み日を更新する
-            $addcol['commit_date'] = "Now()";
-        }
-
         /*
          * XXX 本来なら配列だが, update 関数を string として
@@ -555 +549 @@
         $sql .= "     payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = ?)";
         $sql .= "     ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = ? AND deliv_id = (SELECT deliv_id FROM dtb_payment WHERE payment_id = ? ))";
+        // 受注ステータスの判定
+        if ($sqlval['status'] == ODERSTATUS_COMMIT) {
+            // 受注テーブルの発送済み日を更新する
+            $sql .= "     ,commit_date = 'NOW()'";
+        }
         $sql .= " WHERE order_id = ?";
 
@@ -568 +567 @@
         $arrDetail = $this->objFormParam->getSwapArray(array("product_id", "product_code", "product_name", "price", "quantity", "point_rate", "classcategory_id1", "classcategory_id2", "classcategory_name1", "classcategory_name2"));
         $objQuery->delete("dtb_order_detail", $where, array($order_id));
+
 
         $max = count($arrDetail);
@@ -585 +585 @@
             $objQuery->insert("dtb_order_detail", $sqlval);
         }
+
+
         $objQuery->commit();
     }