Ignore:
Timestamp:
2012/11/29 15:14:47 (8 years ago)
Author:
tokuhiro
Message:

#1972 フロントに空のおすすめ商品を表示させないように修正、おすすめ商品管理に登録している商品が削除されていた場合、警告を表示するように変更。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php

    r21935 r22113  
    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'; 
     96        $where = 'T1.del_flg = 0 and T2.status = 1 and T2.del_flg = 0'; 
    9797        $objQuery->setOrder('T1.rank'); 
    9898        $objQuery->setLimit(RECOMMEND_NUM); 
Note: See TracChangeset for help on using the changeset viewer.