Ignore:
Timestamp:
2012/12/07 17:04:44 (11 years ago)
Author:
tokuhiro
Message:

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

Location:
branches/version-2_12-dev/data
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl

    r22119 r22124  
    111111                            <div class="table-detail"> 
    112112                                <div class="detail-name">商品名: <!--{$arrItems[$smarty.section.cnt.iteration].name|h}--></div> 
    113                                 <!--{if $arrItems[$smarty.section.cnt.iteration].p_del_flg == '1'}--> 
    114                                     <div class="attention">※<!--{$arrItems[$smarty.section.cnt.iteration].name|h}-->は販売商品から削除されています。</div> 
    115                                 <!--{/if}--> 
    116113                                    <div class="detail-form"> 
    117114                                        <form name="form<!--{$smarty.section.cnt.iteration}-->" id="form<!--{$smarty.section.cnt.iteration}-->" method="post" action="?"> 
  • branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php

    r22113 r22124  
    175175    function getRecommendProducts() { 
    176176        $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    177         $col = 'dtb_products.name,dtb_products.main_list_image,dtb_products.del_flg as p_del_flg,dtb_best_products.*'; 
     177        $col = 'dtb_products.name,dtb_products.main_list_image,dtb_best_products.*'; 
    178178        $table = 'dtb_best_products INNER JOIN dtb_products ON dtb_best_products.product_id = dtb_products.product_id'; 
    179179        $where = 'dtb_best_products.del_flg = 0'; 
  • branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

    r21867 r22124  
    262262        $objQuery->update('dtb_products_class', $sqlval, "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam); 
    263263        $objQuery->delete('dtb_customer_favorite_products', "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam); 
     264        $objQuery->delete('dtb_best_products', "product_id IN (SELECT product_id FROM dtb_products WHERE $where)", $arrParam); 
    264265        $objQuery->update('dtb_products', $sqlval, $where, $arrParam); 
    265266        $objQuery->commit(); 
  • branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php

    r22113 r22124  
    9494        $col = 'T1.best_id, T1.category_id, T1.rank, T1.product_id, T1.title, T1.comment, T1.create_date, T1.update_date'; 
    9595        $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id'; 
    96         $where = 'T1.del_flg = 0 and T2.status = 1 and T2.del_flg = 0'; 
     96        $where = 'T1.del_flg = 0 and T2.status = 1'; 
    9797        $objQuery->setOrder('T1.rank'); 
    9898        $objQuery->setLimit(RECOMMEND_NUM); 
Note: See TracChangeset for help on using the changeset viewer.