Changeset 21551

Timestamp:

2012/02/24 17:15:12 (12 years ago)

Author:

Seasoft

Message:

#1539 (受注情報の deliv_id が冗長)

File:

• branches/version-2_12-dev/data/class/helper/SC_Helper_Purchase.php (modified) (1 diff)

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

@@ -1198 +1198 @@
             $sql_where = 'order_id = ?';
 
+            $sql_sub = <<< __EOS__
+                SELECT deliv_time
+                FROM dtb_delivtime
+                WHERE time_id = dtb_shipping.time_id
+                    AND deliv_id = (SELECT dtb_order.deliv_id FROM dtb_order WHERE order_id = dtb_shipping.order_id)
+__EOS__;
             $objQuery->update('dtb_shipping', array(),
                               $sql_where,
                               array($order_id),
-                              array('shipping_time' =>
-                                    '(SELECT deliv_time FROM dtb_delivtime WHERE time_id = dtb_shipping.time_id AND deliv_id = dtb_shipping.deliv_id)'));
+                              array('shipping_time' => "($sql_sub)"));
 
         }