Changeset 23576


Ignore:
Timestamp:
2014/07/18 17:56:06 (10 years ago)
Author:
nanasess
Message:
  • USING 句を ON に修正
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  
    219219            $col = 's_i.*, tax_rate, tax_rule'; 
    220220            $from = 'dtb_shipment_item AS s_i JOIN dtb_order_detail AS o_d 
    221                 USING(order_id, product_class_id)'; 
    222             $where = 'order_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 = ?'; 
    223223            $arrWhereVal = array($order_id, $arrRet[$key]['shipping_id']); 
    224224            $objQuery->setOrder('order_detail_id'); 
  • branches/version-2_13-dev/data/class/helper/SC_Helper_Purchase.php

    r23563 r23576  
    10381038        $arrResults = array(); 
    10391039        $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 = ?', 
    10421045                                      array($order_id, $shipping_id)); 
    10431046 
Note: See TracChangeset for help on using the changeset viewer.