From 4d5f9b2c6177b5018e2c34ade73e53410345d1b5 Mon Sep 17 00:00:00 2001
From: gongzuming <gongzuming>
Date: 星期一, 02 九月 2024 09:22:44 +0800
Subject: [PATCH] 积分过期优化
---
src/main/java/com/mzl/flower/mapper/point/CustomerPointDetailMapper.java | 2 +-
src/main/resources/mapper/point/CustomerPointDetailMapper.xml | 2 +-
src/main/java/com/mzl/flower/schedule/PointScheduleService.java | 4 ++--
3 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/point/CustomerPointDetailMapper.java b/src/main/java/com/mzl/flower/mapper/point/CustomerPointDetailMapper.java
index adadcb3..6482846 100644
--- a/src/main/java/com/mzl/flower/mapper/point/CustomerPointDetailMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/point/CustomerPointDetailMapper.java
@@ -19,5 +19,5 @@
List<CustomerPointDetailVO> queryPage(@Param("dto") CustomerPointDetailQueryDTO dto, Page page);
- List<ExpiredPointDTO> tongjiExpiredPoint(LocalDate lastYear);
+ List<ExpiredPointDTO> tongjiExpiredPoint(@Param("lastYear") LocalDate lastYear);
}
diff --git a/src/main/java/com/mzl/flower/schedule/PointScheduleService.java b/src/main/java/com/mzl/flower/schedule/PointScheduleService.java
index a122c69..ca05ac0 100644
--- a/src/main/java/com/mzl/flower/schedule/PointScheduleService.java
+++ b/src/main/java/com/mzl/flower/schedule/PointScheduleService.java
@@ -39,7 +39,7 @@
/**
* 定时计算用户过期积分
*/
- @Scheduled(cron = "0 0 2 * * ?")
+ @Scheduled(cron = "0 20 9 * * ?")
public void calculatingExpiredPoint() {
log.info("过期积分计算开始：" + DateFormatUtils.format(System.currentTimeMillis(), "yyyy-MM-dd HH:mm:ss"));
LocalDate now = LocalDate.now().minusDays(1);//前一天
@@ -57,7 +57,7 @@
customerPointDetail.setPoint(expiredPoint);
customerPointDetail.setRecordDate(now);
customerPointDetail.create("sys");
- customerPointDetail.setRemarks(DateUtils.toString(lastYear,"yyyy-MM-dd")+"过期积分结算");
+ customerPointDetail.setRemarks(DateUtils.toString(now,"yyyy-MM-dd")+"过期积分结算");
customerPointDetailMapper.insert(customerPointDetail);
//更新用户积分记录
diff --git a/src/main/resources/mapper/point/CustomerPointDetailMapper.xml b/src/main/resources/mapper/point/CustomerPointDetailMapper.xml
index 4e7b369..6e4689e 100644
--- a/src/main/resources/mapper/point/CustomerPointDetailMapper.xml
+++ b/src/main/resources/mapper/point/CustomerPointDetailMapper.xml
@@ -29,7 +29,7 @@
WHERE p.deleted= 0
<if test="lastYear!=null ">
<![CDATA[
- p.record_date <= #{lastYear}
+ and p.record_date <= #{lastYear}
]]>
</if>
GROUP BY
--
Gitblit v1.9.3