From 53a8551e694f5ecaf41d3b94e43dd495abfe123c Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期三, 25 三月 2026 17:53:03 +0800
Subject: [PATCH] fix:仓储库存查询
---
src/main/resources/mapper/stock/StockInventoryMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/stock/StockInventoryMapper.xml b/src/main/resources/mapper/stock/StockInventoryMapper.xml
index 8842aa2..5b8bcab 100644
--- a/src/main/resources/mapper/stock/StockInventoryMapper.xml
+++ b/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,
--
Gitblit v1.9.3