From 158fdad6fa49aedb36e479f6ca70294d34d554e1 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期三, 06 三月 2024 12:03:24 +0800
Subject: [PATCH] 台账查询消除sql错误

---
 mdc-parent/mdc-showdb-mysql/src/main/resources/mapper/MachineAccountMapper.xml |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/mdc-parent/mdc-showdb-mysql/src/main/resources/mapper/MachineAccountMapper.xml b/mdc-parent/mdc-showdb-mysql/src/main/resources/mapper/MachineAccountMapper.xml
index 2cce409..6601001 100644
--- a/mdc-parent/mdc-showdb-mysql/src/main/resources/mapper/MachineAccountMapper.xml
+++ b/mdc-parent/mdc-showdb-mysql/src/main/resources/mapper/MachineAccountMapper.xml
@@ -72,10 +72,10 @@
          </if>
          
          <if test="dto.productionDateBegin != null">
-            and a.a.production_date &gt;= #{dto.productionDateBegin}
+            and a.production_date &gt;= #{dto.productionDateBegin}
          </if>
          <if test="dto.productionDateEnd != null">
-            and a.a.production_date &lt;= #{dto.productionDateEnd}
+            and a.production_date &lt;= #{dto.productionDateEnd}
          </if>
          
          

--
Gitblit v1.9.3