wjli
2024-03-18 84fd23e5e865bd5529441a0c318809a00362f44c
xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/schedulings/OrderDealScheduleImpl.java
@@ -1,4 +1,5 @@
package cn.exrick.xboot.your.schedulings;
import cn.exrick.xboot.your.entity.*;
import cn.exrick.xboot.your.service.*;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
@@ -9,6 +10,7 @@
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
//删除历史数据
@Component
@@ -26,10 +28,19 @@
    @Autowired
    private IOrderDetailService iOrderDetailService;
    @Autowired
    private IDuoZhengService iDuoZhengService;
    /**
     * 每天21点执行
     * 1.将配送日期小于10天前的订单删除(t_order_task),同时删除相应订单详情数据(t_order_detail)
     * 2.将配送日期小于20天前的订单从原始订单数据表删除(t_order_original),同时删除相应原始订单详情数据(t_order_original_detail)
     */
    @Scheduled(cron="0 0 21 * * ?")//每晚下午9点执行
    //@Scheduled(cron="0 * * * * ?")//测试
    //@Scheduled(cron="0 33 17 * * ?")//测试
    public void execute(){
        String day = getDay(-8);
        String day = getDay(-10);
        QueryWrapper<OrderTask> wrapper = new QueryWrapper<>();
        wrapper.lt("send_Date",day);
        iOrderTaskService.remove(wrapper);
@@ -38,7 +49,7 @@
        wrapper2.lt("create_time",day+" 00:00:00");
        iOrderDetailService.remove(wrapper2);
        String day2 = getDay(-31);
        String day2 = getDay(-20);
        QueryWrapper<OrderTaskOriginal> wrapper3 = new QueryWrapper<>();
        wrapper3.lt("create_time",day2+" 00:00:00");
        iOrderTaskOriginalService.remove(wrapper3);
@@ -46,6 +57,12 @@
        QueryWrapper<OrderDetailOriginal> wrapper4 = new QueryWrapper<>();
        wrapper4.lt("create_time",day2+" 00:00:00");
        iOrderDetailOriginalService.remove(wrapper4);
        QueryWrapper<DuoZheng> wrapper5 = new QueryWrapper<>();
        iDuoZhengService.remove(wrapper5);
        List<DuoZheng> list = iDuoZhengService.getYiHuDuoZheng();
        iDuoZhengService.saveBatch(list);
    }
    private String getDay(int day){