111

tjx

18 小时以前 6b9657a5a68d7493a53a9958f08478e7e89881b9

111

 src/main/java/com/gs/dingtalk/controller/KMController.java

@@ -2,12 +2,14 @@


import com.gs.dingtalk.config.ResultMessage;
import com.gs.dingtalk.service.QwCheckinDayDataService;
import com.gs.dingtalk.service.SendDingtalkService;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.bind.annotation.*;

import java.time.LocalDate;
import java.time.ZoneId;
import java.time.format.DateTimeFormatter;

@RestController
@RequestMapping("Numerical")
@@ -17,6 +19,8 @@


    private final SendDingtalkService sendDingtalkService;

    private final QwCheckinDayDataService qwCheckinDayDataService;

    @PostMapping("/chatSendMessage")
    public ResultMessage chatSendMessage() {
@@ -40,4 +44,35 @@
        }
    }

    /**
     * 同步企业微信打卡日报数据
     * @param startDate 开始日期，格式：yyyy-MM-dd
     * @param endDate 结束日期，格式：yyyy-MM-dd
     * @return 同步结果
     */
    @PostMapping("/syncCheckinDayData")
    public ResultMessage syncCheckinDayData(@RequestParam String startDate, @RequestParam String endDate) {
        try {
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
            LocalDate start = LocalDate.parse(startDate, formatter);
            LocalDate end = LocalDate.parse(endDate, formatter);

            // 转换为Unix时间戳（当天0点）
            ZoneId zoneId = ZoneId.of("Asia/Shanghai");
            long startTime = start.atStartOfDay(zoneId).toEpochSecond();
            long endTime = end.atStartOfDay(zoneId).toEpochSecond();

            int totalInsert = 0;
            // 日报接口starttime和endtime需相同，逐天同步
            for (long date = startTime; date <= endTime; date += 86400) {
                int insertCount = qwCheckinDayDataService.syncDayData(date);
                totalInsert += insertCount;
            }

            return ResultMessage.ok("同步成功，新增记录数: " + totalInsert);
        } catch (Exception e) {
            return ResultMessage.error(e);
        }
    }

}

 src/main/java/com/gs/dingtalk/task/ScheduledTasks.java

@@ -1,6 +1,7 @@
package com.gs.dingtalk.task;


import com.gs.dingtalk.service.QwCheckinDayDataService;
import com.gs.dingtalk.service.SendDingtalkService;
import com.gs.dingtalk.service.VwCjScSjTsBbService;
import lombok.RequiredArgsConstructor;
@@ -20,7 +21,11 @@

    private final VwCjScSjTsBbService vwCjScSjTsBbService;

    private final QwCheckinDayDataService qwCheckinDayDataService;

    private final AtomicBoolean exportTaskRunning = new AtomicBoolean(false);

    private final AtomicBoolean checkinDayDataTaskRunning = new AtomicBoolean(false);

//    /**
//     * 每两分钟执行一次
@@ -88,4 +93,27 @@
            exportTaskRunning.set(false);
        }
    }

    /**
     * 每天早上7:30执行
     * 同步前一天的企业微信打卡日报数据到数据库
     */
    @Async("taskExecutor")
    @Scheduled(cron = "0 30 7 * * ?")
    public void syncCheckinDayDataTask() {
        if (!checkinDayDataTaskRunning.compareAndSet(false, true)) {
            log.warn("打卡日报数据同步任务正在执行中，跳过本次执行");
            return;
        }

        try {
            log.info("开始执行打卡日报数据同步任务（同步昨天数据）");
            int insertCount = qwCheckinDayDataService.syncYesterdayDayData();
            log.info("打卡日报数据同步任务执行成功，新增记录数: {}", insertCount);
        } catch (Exception e) {
            log.error("打卡日报数据同步任务执行异常", e);
        } finally {
            checkinDayDataTaskRunning.set(false);
        }
    }
}