商品编号 |
商品名称 |
CAS号 |
品牌 |
规格型号 |
标准价 |
优惠价 |
库存 |
数量 |
购物车 |
$if(keyword=="")
${set(list=get_goods_list(channelName, querylist ,10, " and StockQuantity>0 ","gsearch"))}
${else}
${set(list=get_goods_list(channelName, querylist ,10, " and StockQuantity>0 and (Title like CONCAT('%','"+keyword+"','%') or GoodsNo like CONCAT('%','"+keyword+"','%') or CAS like CONCAT('%','"+keyword+"','%') ) ","gsearch"))}
${end}