liding
7 天以前 53a8551e694f5ecaf41d3b94e43dd495abfe123c
fix:仓储库存查询
已修改1个文件
2 ■■■ 文件已修改
src/main/resources/mapper/stock/StockInventoryMapper.xml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/stock/StockInventoryMapper.xml
@@ -60,7 +60,7 @@
        SELECT * FROM (
        SELECT
        si.id,
        (COALESCE(sir.total_net_weight, 0) - COALESCE(sor.total_net_weight, 0)) AS qualitity,
        si.qualitity as qualitity,
        COALESCE(si.locked_quantity, 0) AS locked_quantity,
        si.product_model_id,
        si.create_time,