From 75d134dc980ffe6b7607e568fc80b60329999b9e Mon Sep 17 00:00:00 2001
From: tj <1378534974@qq.com>
Date: 星期一, 07 四月 2025 08:41:04 +0800
Subject: [PATCH] 1.VIP订单过期检测-每天凌晨一点执行一次

---
 src/main/resources/mapper/customer/CustomerMapper.xml |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/mapper/customer/CustomerMapper.xml b/src/main/resources/mapper/customer/CustomerMapper.xml
index dbf189c..8e9c56e 100644
--- a/src/main/resources/mapper/customer/CustomerMapper.xml
+++ b/src/main/resources/mapper/customer/CustomerMapper.xml
@@ -7,7 +7,7 @@
     <update id="checkVipExpireTime">
         update t_customer_info c
         set c.is_member = 0,c.member_overtime = NULL
-        where c.member_overtime < now() and c.is_member = 1
+        where c.member_overtime &lt; now() and c.is_member = 1
     </update>
     <select id="queryCustomer" resultType="com.mzl.flower.dto.response.customer.CustomerDTO">
         SELECT

--
Gitblit v1.9.3