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 | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java b/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java
index 9df47da..b64ada2 100644
--- a/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ManPakOutMapper.java
@@ -23,6 +23,6 @@
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 SUM(anfme) FROM man_pakout WHERE specs >= #{startStr} AND specs < #{endStr}")
+ @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