From 9ffc9b4383a2f4ea759747a158765caeac81ec30 Mon Sep 17 00:00:00 2001 From: mrzhssss <pro6@qq.com> Date: 星期三, 15 六月 2022 09:39:25 +0800 Subject: [PATCH] 是大于等于而不是大于 --- src/main/resources/mapper/ViewStockUseMapper.xml | 4 ++-- src/main/resources/mapper/ViewInOutMapper.xml | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/main/resources/mapper/ViewInOutMapper.xml b/src/main/resources/mapper/ViewInOutMapper.xml index 8152776..676e80a 100644 --- a/src/main/resources/mapper/ViewInOutMapper.xml +++ b/src/main/resources/mapper/ViewInOutMapper.xml @@ -63,7 +63,7 @@ </select> <select id="selectWorkCountInSum" resultType="java.lang.Integer"> SELECT SUM(anfme) FROM asr_wrkin_count_view WHERE 1=1 AND - (oneday > #{start} + (oneday >= #{start} AND oneday < #{end}) <if test="matnr != null and matnr !=''"> diff --git a/src/main/resources/mapper/ViewStockUseMapper.xml b/src/main/resources/mapper/ViewStockUseMapper.xml index cb6440b..cc723f6 100644 --- a/src/main/resources/mapper/ViewStockUseMapper.xml +++ b/src/main/resources/mapper/ViewStockUseMapper.xml @@ -60,7 +60,7 @@ SELECT * FROM asr_wrkin_count_view WHERE 1 = 1 AND - (oneday > #{start} + (oneday >= #{start} AND oneday < #{end}) @@ -75,7 +75,7 @@ <select id="selectWorkCountInTotal" resultType="java.lang.Integer"> SELECT COUNT(*) FROM asr_wrkin_count_view WHERE 1= 1 AND - (oneday > #{start} + (oneday >= #{start} AND oneday < #{end}) <if test="matnr != null and matnr !='' "> -- Gitblit v1.9.1