Changeset 21551


Ignore:
Timestamp:
2012/02/24 17:15:12 (10 years ago)
Author:
Seasoft
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/helper/SC_Helper_Purchase.php

    r21527 r21551  
    11981198            $sql_where = 'order_id = ?'; 
    11991199 
     1200            $sql_sub = <<< __EOS__ 
     1201                SELECT deliv_time 
     1202                FROM dtb_delivtime 
     1203                WHERE time_id = dtb_shipping.time_id 
     1204                    AND deliv_id = (SELECT dtb_order.deliv_id FROM dtb_order WHERE order_id = dtb_shipping.order_id) 
     1205__EOS__; 
    12001206            $objQuery->update('dtb_shipping', array(), 
    12011207                              $sql_where, 
    12021208                              array($order_id), 
    1203                               array('shipping_time' => 
    1204                                     '(SELECT deliv_time FROM dtb_delivtime WHERE time_id = dtb_shipping.time_id AND deliv_id = dtb_shipping.deliv_id)')); 
     1209                              array('shipping_time' => "($sql_sub)")); 
    12051210 
    12061211        } 
Note: See TracChangeset for help on using the changeset viewer.