From 2d876cb5a3b8959f5946bdc225aa668927575de6 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期一, 02 三月 2026 14:43:27 +0800
Subject: [PATCH] 修复小时内发货量为0异常
---
src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java b/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java
index 99ed2bf..b64ada2 100644
--- a/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java
@@ -2,11 +2,27 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.ManPakOut;
+import com.zy.asrs.entity.param.PakOutDTO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
+
+import java.util.Date;
+import java.util.List;
@Mapper
@Repository
public interface ManPakOutMapper extends BaseMapper<ManPakOut> {
+
+
+ List<PakOutDTO> selectPakOut(@Param("docnum") String docnum,@Param("stime") Date stime, @Param("etime") Date etime, @Param("curr") Integer curr, @Param("limit") Integer limit,
+ @Param("userId") Long userId, @Param("custName") String custName, @Param("roleId") Long roleId);
+
+ int selectPakOutCount(@Param("docnum") String docnum,@Param("stime") Date stime, @Param("etime") Date etime,@Param("curr") Integer curr,@Param("limit") Integer limit,
+ @Param("userId") Long userId, @Param("custName") String custName, @Param("roleId") Long roleId);
+
+ @Select("SELECT ISNULL(SUM(anfme), 0) FROM man_pakout WHERE specs >= #{startStr} AND specs < #{endStr}")
+ long maxWeightPerHour(@Param("startStr") String startStr,@Param("endStr") String endStr);
}
--
Gitblit v1.9.1