From 370ef9917136dc8f53113a4bcb83a1f14976e50a Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期三, 18 六月 2025 15:16:16 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java | 5 +++-- 1 files changed, 3 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 4eac4f1..d89349d 100644 --- a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java @@ -1,6 +1,7 @@ package com.zy.asrs.mapper; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.LocDetl; import com.zy.asrs.entity.ManLocDetl; import com.zy.asrs.entity.result.StockVo; import org.apache.ibatis.annotations.Mapper; @@ -42,7 +43,7 @@ List<ManLocDetl> getStockStatisExcel(); - @Select("select sum(a.anfme) as sum from man_loc_detl where matnr = #{matnr}") + @Select("select sum(anfme) as sum from man_loc_detl where matnr = #{matnr}") Double selectSumAnfmeByMatnr(@Param("matnr") String matnr); List<ManLocDetl> selectPakoutByRule(String matnr); @@ -53,7 +54,7 @@ // ------------------------------------------------- - List<ManLocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos); + List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos, @Param("supp")String supp, @Param("temp1")String temp1, @Param("temp2")String temp2); Double queryStockAnfme(String matnr, String batch); -- Gitblit v1.9.1