お世話になっております
現在、商品に関連付けたステータスIDによる
検索が出来るようにカスタマイズしております
LC_Page_Products_List.php
//新着順
case 'date':
$col = "DISTINCT create_date, product_id, product_code_min, product_code_max,"
. " name, comment1, comment2, comment3,"
. " main_list_comment, main_image, main_list_image,"
. " price01_min, price01_max, price02_min, price02_max,"
. " stock_min, stock_max, stock_unlimited_min, stock_unlimited_max,"
. " point_rate, sale_limit, sale_unlimited, deliv_date_id, deliv_fee,"
. " status, product_flag, del_flg";
$from = "vw_products_allclass AS T1";
$order = "create_date DESC, product_id";
break;
//オススメ検索
case 'reccomond':
$col = "DISTINCT create_date, product_id, product_code_min, product_code_max,"
. " name, comment1, comment2, comment3,"
. " main_list_comment, main_image, main_list_image,"
. " price01_min, price01_max, price02_min, price02_max,"
. " stock_min, stock_max, stock_unlimited_min, stock_unlimited_max,"
. " point_rate, sale_limit, sale_unlimited, deliv_date_id, deliv_fee,"
. " status, product_flag, del_flg";
$from = "vw_products_allclass AS T1";
$order = "create_date DESC, product_id";
break;
この部分をステータスID2にしてやるだけで問題ないのでしょうか?
list.tpl
<!--{if $orderby != "reccomond"}-->
<a href="java script:fnModeSubmit('', 'orderby', 'reccomond')">オススメ</a>
<!--{else}-->
<strong>オススメ</strong>
<!--{/if}-->
アドバイス宜しくお願いいたします
----------------
------------------------------------------------------------------------------------------
EC-CUBE 3.0.17
DBサーバー mariaDB
WEBサーバー apache (CentOS)
PHP 7.1
-----------------------...