Changeset 22124 for branches/version-2_12-dev/data/class/pages/admin

Timestamp:

2012/12/07 17:04:44 (11 years ago)

Author:

tokuhiro

Message:

#1972 商品を削除した際に、おすすめ商品からも削除される仕様に変更

Location:

branches/version-2_12-dev/data/class/pages/admin

Files:

• contents/LC_Page_Admin_Contents_Recommend.php (modified) (1 diff)
• products/LC_Page_Admin_Products.php (modified) (1 diff)

branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php

@@ -175 +175 @@
     function getRecommendProducts() {
         $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $col = 'dtb_products.name,dtb_products.main_list_image,dtb_products.del_flg as p_del_flg,dtb_best_products.*';
+        $col = 'dtb_products.name,dtb_products.main_list_image,dtb_best_products.*';
         $table = 'dtb_best_products INNER JOIN dtb_products ON dtb_best_products.product_id = dtb_products.product_id';
         $where = 'dtb_best_products.del_flg = 0';

branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -262 +262 @@
         $objQuery->update('dtb_products_class', $sqlval, "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam);
         $objQuery->delete('dtb_customer_favorite_products', "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam);
+        $objQuery->delete('dtb_best_products', "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam);
         $objQuery->update('dtb_products', $sqlval, $where, $arrParam);
         $objQuery->commit();