Changeset 23576 for branches/version-2_13-dev/data/class/helper/SC_Helper_Purchase.php

Timestamp:

2014/07/18 17:56:06 (12 years ago)

Author:

nanasess

Message:

• USING 句を ON に修正

File:

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

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

@@ -1038 +1038 @@
         $arrResults = array();
         $objQuery->setOrder('order_detail_id');
-        $arrItems = $objQuery->select('dtb_shipment_item.*', 'dtb_shipment_item join dtb_order_detail USING (product_class_id, order_id)',
-                                      'order_id = ? AND shipping_id = ?',
+        $arrItems = $objQuery->select('dtb_shipment_item.*',
+                                      'dtb_shipment_item JOIN dtb_order_detail
+                                           ON dtb_shipment_item.product_class_id = dtb_order_detail.product_class_id
+                                           AND dtb_shipment_item.order_id = dtb_order_detail.order_id',
+                                      'dtb_order_detail.order_id = ? AND shipping_id = ?',
                                       array($order_id, $shipping_id));