积分过期优化

gongzuming

2024-09-02 4d5f9b2c6177b5018e2c34ade73e53410345d1b5

积分过期优化

 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);
}

 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);

                    //更新用户积分记录

 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