Changeset 18134
- Timestamp:
- 2009/06/20 18:44:34 (15 years ago)
- Location:
- branches/comu-ver2/data/class
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/helper/SC_Helper_DB.php
r18114 r18134 1759 1759 1760 1760 if ($temp_table) { 1761 $t able = 'dtb_order_temp';1761 $tgt_table = 'dtb_order_temp'; 1762 1762 $sql_where = 'WHERE order_temp_id = ?'; 1763 1763 } else { 1764 $t able = 'dtb_order';1764 $tgt_table = 'dtb_order'; 1765 1765 $sql_where = 'WHERE order_id = ?'; 1766 1766 } … … 1768 1768 $sql = <<< __EOS__ 1769 1769 UPDATE 1770 $table tgt1770 {$tgt_table} 1771 1771 SET 1772 payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = tgt.payment_id)1773 ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = tgt.deliv_time_id AND deliv_id = tgt.deliv_id)1772 payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = {$tgt_table}.payment_id) 1773 ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = {$tgt_table}.deliv_time_id AND deliv_id = {$tgt_table}.deliv_id) 1774 1774 $sql_where 1775 1775 __EOS__; -
branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php
r18076 r18134 96 96 case 'renumber': 97 97 $sql = <<< __EOS__ 98 UPDATE dtb_product_categories tgt98 UPDATE dtb_product_categories 99 99 SET 100 100 rank = … … 102 102 SELECT COUNT(*) 103 103 FROM dtb_product_categories t_in 104 WHERE t_in.category_id = tgt.category_id104 WHERE t_in.category_id = dtb_product_categories.category_id 105 105 AND ( 106 t_in.rank < tgt.rank106 t_in.rank < dtb_product_categories.rank 107 107 OR ( 108 t_in.rank = tgt.rank109 AND t_in.product_id < tgt.product_id108 t_in.rank = dtb_product_categories.rank 109 AND t_in.product_id < dtb_product_categories.product_id 110 110 ) 111 111 ) 112 112 ) + 1 113 WHERE tgt.category_id = ?113 WHERE dtb_product_categories.category_id = ? 114 114 __EOS__; 115 115 $objQuery->query($sql, array($_POST['parent_category_id']));
Note: See TracChangeset
for help on using the changeset viewer.