package com.yssh.controller;


import com.yssh.service.Yssh2dreliService;
import com.yssh.service.Yssh3dreliService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;


/**
 * 定时任务处理数据控制器
 *
 * @author xingjs
 * @date 2023/02/06
 */
@Component("sqlDataTask")
public class DealDataTaksController {

    @Autowired
    private Yssh2dreliService yssh2dreliService;

    @Autowired
    private Yssh3dreliService yssh3dreliService;


    //每天晚上23:59:00点执行
    @Scheduled(cron = "0 59 23 * * ?")
    public void createTable() {
        yssh2dreliService.create2dreliTable();
        System.out.println("========创建2维热力表执行完毕======== ");
        yssh3dreliService.create3dreliTable();
        System.out.println("========创建3维热力执行完毕======== ");
    }


    /**
     * 删除前几年数据
     * //删除前一年的数据 每天晚上0点执行
     */
    @Scheduled(cron = "0 0 0 * * ?")
    public void deletePreviousYearsData() {
        yssh2dreliService.drop2dreliTable();
        System.out.println("========删除2维热力表执行完毕======== ");
        yssh3dreliService.drop3dreliTable();
        System.out.println("========删除3维热力执行完毕======== ");
    }



}