From fe86da92bf703556de6030ec40f3c3bf5b999f91 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Fri, 23 Apr 2021 14:47:02 +0800
Subject: [PATCH] 20210423
---
src/main/resources/mapper/modules/ContractHoldOrderMapper.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/resources/mapper/modules/ContractHoldOrderMapper.xml b/src/main/resources/mapper/modules/ContractHoldOrderMapper.xml
index 25b48a2..73b97af 100644
--- a/src/main/resources/mapper/modules/ContractHoldOrderMapper.xml
+++ b/src/main/resources/mapper/modules/ContractHoldOrderMapper.xml
@@ -18,16 +18,16 @@
and opening_type=#{record.openType}
</if>
<if test='record.timeType=="1"'>
- and TO_DAYS(create_time) = TO_DAYS(NOW())
+ and TO_DAYS(a.create_time) = TO_DAYS(NOW())
</if>
<if test='record.timeType=="2"'>
- and TO_DAYS(NOW()) - TO_DAYS(create_time) = 1
+ and TO_DAYS(NOW()) - TO_DAYS(a.create_time) = 1
</if>
<if test='record.timeType=="3"'>
- and YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now())
+ and YEARWEEK(date_format(a.create_time,'%Y-%m-%d')) = YEARWEEK(now())
</if>
<if test='record.timeType=="4"'>
- and DATE_FORMAT(create_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' )
+ and DATE_FORMAT(a.create_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' )
</if>
</if>
</where>
--
Gitblit v1.9.1