Changeset 22113
- Timestamp:
- 2012/11/29 15:14:47 (11 years ago)
- Location:
- branches/version-2_12-dev/data
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/Smarty/templates/admin/contents/recommend.tpl
r22112 r22113 111 111 <div class="table-detail"> 112 112 <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}--> 113 116 <div class="detail-form"> 114 117 <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
r21867 r22113 175 175 function getRecommendProducts() { 176 176 $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance(); 177 $col = 'dtb_products.name,dtb_products.main_list_image,dtb_ best_products.*';177 $col = 'dtb_products.name,dtb_products.main_list_image,dtb_products.del_flg as p_del_flg,dtb_best_products.*'; 178 178 $table = 'dtb_best_products INNER JOIN dtb_products ON dtb_best_products.product_id = dtb_products.product_id'; 179 179 $where = 'dtb_best_products.del_flg = 0'; -
branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php
r21935 r22113 94 94 $col = 'T1.best_id, T1.category_id, T1.rank, T1.product_id, T1.title, T1.comment, T1.create_date, T1.update_date'; 95 95 $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'; 97 97 $objQuery->setOrder('T1.rank'); 98 98 $objQuery->setLimit(RECOMMEND_NUM);
Note: See TracChangeset
for help on using the changeset viewer.