Changeset 17549 for branches/comu-ver2/data/class/helper/SC_Helper_DB.php
- Timestamp:
- 2008/08/21 00:02:54 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/helper/SC_Helper_DB.php
r17509 r17549 928 928 $sql .= " FROM dtb_category AS T1 LEFT JOIN dtb_product_categories AS T2"; 929 929 $sql .= " ON T1.category_id = T2.category_id "; 930 $sql .= " LEFT JOIN vw_products_allclass AS allcls";931 $sql .= " ON T2.product_id = all cls.product_id";932 $sql .= " WHERE all cls.del_flg = 0 AND allcls.status = 1 ";930 $sql .= " LEFT JOIN vw_products_allclass_detail AS alldtl"; 931 $sql .= " ON T2.product_id = alldtl.product_id"; 932 $sql .= " WHERE alldtl.del_flg = 0 AND alldtl.status = 1 "; 933 933 934 934 // 在庫無し商品の非表示 935 935 if (NOSTOCK_HIDDEN === true) { 936 $sql .= ' AND (all cls.stock_max >= 1 OR allcls.stock_unlimited_max = 1)';936 $sql .= ' AND (alldtl.stock_max >= 1 OR alldtl.stock_unlimited_max = 1)'; 937 937 } 938 938
Note: See TracChangeset
for help on using the changeset viewer.