fix
Hentua
2024-01-24 a371d5a31e0087cfd9a5383b646689eec23ee367
fix
1 files modified
2 ■■■ changed files
src/main/resources/mapper/modules/MallGoodsMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/resources/mapper/modules/MallGoodsMapper.xml
@@ -106,7 +106,7 @@
                </if>
                min(b.id) skuId,
                min(b.present_price) price,
                sum(b.stock) stock,
                ifnull(sum(b.stock), a.stock) stock,
                sum(b.sku_volume) saleVolume
            from mall_goods a
                 left join mall_goods_sku b on a.id=b.goods_id