Changeset 23576
- Timestamp:
- 2014/07/18 17:56:06 (10 years ago)
- Location:
- branches/version-2_13-dev/data/class/helper
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/helper/SC_Helper_Mail.php
r23574 r23576 219 219 $col = 's_i.*, tax_rate, tax_rule'; 220 220 $from = 'dtb_shipment_item AS s_i JOIN dtb_order_detail AS o_d 221 USING(order_id, product_class_id)';222 $where = 'o rder_id = ? AND shipping_id = ?';221 ON s_i.order_id = o_d.order_id AND s_i.product_class_id = o_d.product_class_id'; 222 $where = 'o_d.order_id = ? AND shipping_id = ?'; 223 223 $arrWhereVal = array($order_id, $arrRet[$key]['shipping_id']); 224 224 $objQuery->setOrder('order_detail_id'); -
branches/version-2_13-dev/data/class/helper/SC_Helper_Purchase.php
r23563 r23576 1038 1038 $arrResults = array(); 1039 1039 $objQuery->setOrder('order_detail_id'); 1040 $arrItems = $objQuery->select('dtb_shipment_item.*', 'dtb_shipment_item join dtb_order_detail USING (product_class_id, order_id)', 1041 'order_id = ? AND shipping_id = ?', 1040 $arrItems = $objQuery->select('dtb_shipment_item.*', 1041 'dtb_shipment_item JOIN dtb_order_detail 1042 ON dtb_shipment_item.product_class_id = dtb_order_detail.product_class_id 1043 AND dtb_shipment_item.order_id = dtb_order_detail.order_id', 1044 'dtb_order_detail.order_id = ? AND shipping_id = ?', 1042 1045 array($order_id, $shipping_id)); 1043 1046
Note: See TracChangeset
for help on using the changeset viewer.