Ignore:
Timestamp:
2013/02/26 09:09:44 (8 years ago)
Author:
pineray
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

    r22577 r22582  
    266266    { 
    267267        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
     268        $arrRet = $objQuery->getCol('product_id', "dtb_products", $where, $arrParam); 
     269        $product_ids = array(); 
     270        foreach ($arrRet as $value) { 
     271            $product_ids[] = $value['product_id']; 
     272        } 
    268273        $sqlval['del_flg']     = 1; 
    269274        $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 
     
    271276        $objQuery->update('dtb_products_class', $sqlval, "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam); 
    272277        $objQuery->delete('dtb_customer_favorite_products', "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam); 
    273         $objQuery->delete('dtb_best_products', "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam); 
     278 
     279        $objRecomment = new SC_Helper_Recommend_Ex(); 
     280        $objRecomment->deleteByProductIDs($product_ids); 
     281 
    274282        $objQuery->update('dtb_products', $sqlval, $where, $arrParam); 
    275283        $objQuery->commit(); 
Note: See TracChangeset for help on using the changeset viewer.