Changeset 23576 for branches/version-2_13-dev/data/class/helper/SC_Helper_Mail.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_Mail.php (modified) (1 diff)

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

@@ -219 +219 @@
             $col = 's_i.*, tax_rate, tax_rule';
             $from = 'dtb_shipment_item AS s_i JOIN dtb_order_detail AS o_d
-                USING(order_id, product_class_id)';
-            $where = 'order_id = ? AND shipping_id = ?';
+                ON s_i.order_id = o_d.order_id AND s_i.product_class_id = o_d.product_class_id';
+            $where = 'o_d.order_id = ? AND shipping_id = ?';
             $arrWhereVal = array($order_id, $arrRet[$key]['shipping_id']);
             $objQuery->setOrder('order_detail_id');