需求说明
Bigcommerce系统的AddToCart弹出窗口,会展示0库存的产品。这是不合理的,列表里面应该屏蔽(0库存不可以购买)的产品。
提示
1.AddToCart弹出窗口的产品列表,查找关键字:SuggestedProductListing
2.数据库里,products表的库存字段是:prodcurrentinv
修改步骤
打开:includes/display/SuggestiveCartContent.php文件
查找:$query = $this->getProductQuery(
在他下面添加了:
p.prodcurrentinv !=0 AND
$query = $this->getProductQuery(
'p.prodcurrentinv !=0 AND p.productid IN ('.$suggest_prod_ids.')',
'p.prodnumsold DESC, p.prodratingtotal DESC'
);
修改后,打印出来的 SQL语句如下:
SELECT p.*, pi.*, FLOOR(prodratingtotal/prodnumratings) AS prodavgrating, 0 AS prodgroupdiscount FROM isc_products p LEFT JOIN isc_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND p.prodcurrentinv !=0 AND p.productid IN (25,1,14,15) ORDER BY p.prodnumsold DESC, p.prodratingtotal DESC