From f56e004dac74ebcf6638e0b8dc162062f19dbe34 Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期一, 06 一月 2025 15:50:02 +0800
Subject: [PATCH] #平库入库完成+库存明细+库存统计
---
src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
index 250a289..4eac4f1 100644
--- a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
@@ -42,7 +42,7 @@
List<ManLocDetl> getStockStatisExcel();
- @Select("select sum(a.anfme) as sum from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no where b.loc_sts = 'F' and a.matnr = #{matnr}")
+ @Select("select sum(a.anfme) as sum from man_loc_detl where matnr = #{matnr}")
Double selectSumAnfmeByMatnr(@Param("matnr") String matnr);
List<ManLocDetl> selectPakoutByRule(String matnr);
@@ -60,7 +60,7 @@
List<StockVo> queryStockTotal();
- Integer sum();
+ Double sum();
List<ManLocDetl> unreason();
--
Gitblit v1.9.1