1.VIP订单过期检测-每天凌晨一点执行一次

tj

2025-04-07 75d134dc980ffe6b7607e568fc80b60329999b9e

1.VIP订单过期检测-每天凌晨一点执行一次

 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