Changeset 18023 for branches/comu-ver2/data/class/helper/SC_Helper_DB.php

Timestamp:

2009/05/23 11:23:24 (14 years ago)

Author:

Seasoft

Message:

#472「管理機能の配送業者の追加でエラー」を修正。

File:

• branches/comu-ver2/data/class/helper/SC_Helper_DB.php (modified) (2 diffs)

branches/comu-ver2/data/class/helper/SC_Helper_DB.php

@@ -425 +425 @@
                 $objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid));
             }
+            
+            // 受注_Tempテーブルの名称列を更新
+            $this->sfUpdateOrderNameCol($uniqid, true);
         }
     }
@@ -1712 +1715 @@
     }
 
+    /**
+     * 受注の名称列を更新する
+     *
+     * @param integer $order_id 更新対象の注文番号
+     * @param boolean $temp_table 更新対象は「受注_Temp」か
+     */
+    function sfUpdateOrderNameCol($order_id, $temp_table = false) {
+        $objQuery = new SC_Query();
+        
+        if ($temp_table) {
+            $table = 'dtb_order_temp';
+            $sql_where = 'WHERE order_temp_id = ?';
+        } else {
+            $table = 'dtb_order';
+            $sql_where = 'WHERE order_id = ?';
+        }
+        
+        $sql = <<< __EOS__
+            UPDATE
+                $table tgt
+            SET
+                 payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = tgt.payment_id)
+                ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = tgt.deliv_time_id AND deliv_id = tgt.deliv_id)
+            $sql_where
+__EOS__;
+        
+        $objQuery->query($sql, array($order_id));
+    }
 }
 ?>