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

Timestamp:

2013/02/26 09:09:44 (11 years ago)

Author:

pineray

Message:

#2162 pageクラスからdtb_best_productsテーブルを直接指定している箇所をなくす

File:

• branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php (modified) (2 diffs)

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

@@ -266 +266 @@
     {
         $objQuery =& SC_Query_Ex::getSingletonInstance();
+        $arrRet = $objQuery->getCol('product_id', "dtb_products", $where, $arrParam);
+        $product_ids = array();
+        foreach ($arrRet as $value) {
+            $product_ids[] = $value['product_id'];
+        }
         $sqlval['del_flg']     = 1;
         $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
@@ -271 +276 @@
         $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);
+
+        $objRecomment = new SC_Helper_Recommend_Ex();
+        $objRecomment->deleteByProductIDs($product_ids);
+
         $objQuery->update('dtb_products', $sqlval, $where, $arrParam);
         $objQuery->commit();