package com.ruzhoukj.sms.task; import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.util.ObjectUtil; import com.dingtalk.api.response.OapiAttendanceGetupdatedataResponse; import com.google.common.collect.Lists; import com.ruzhoukj.sms.controller.DingAttendanceController; import com.ruzhoukj.sms.controller.DingEmployeeController; import com.ruzhoukj.sms.entity.DingAttendanceEntity; import com.ruzhoukj.sms.entity.DingAttendanceTotalEntity; import com.ruzhoukj.sms.entity.DingUserEntity; import com.ruzhoukj.sms.model.vo.DingAttendanceDTO; import com.ruzhoukj.sms.model.vo.DingAttendanceVO; import com.ruzhoukj.sms.model.vo.DingUserVO; import com.ruzhoukj.sms.service.DingAttendanceService; import com.ruzhoukj.sms.service.DingAttendanceTotalService; import com.ruzhoukj.sms.service.DingUserService; import com.ruzhoukj.sms.util.DateUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; import javax.annotation.Resource; import java.math.BigDecimal; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.Date; import java.util.List; /** * @author : wujipeng * @date : 2025/2/28 15:16 * @Version: 1.0 * @Desc : 同步钉钉数据 */ @Component @Slf4j public class DingTask { @Resource private DingEmployeeController dingEmployeeController; @Resource private DingUserService dingUserService; @Resource private DingAttendanceService dingAttendanceService; @Resource private DingAttendanceTotalService dingAttendanceTotalService; @Resource private DingAttendanceController dingAttendanceController; /** * 每天凌晨三点同步员工信息 */ @Scheduled(cron = "0 0 3 * * *") // @Scheduled(fixedRate = 20000) public void syncEmployee() { log.info("开始同步员工信息"); List employeeIdList = dingEmployeeController.getEmployeeIdList(); List userList = Lists.newArrayList(); for (String s : employeeIdList) { DingUserVO employeeDetail = dingEmployeeController.getEmployeeDetail(s); userList.add(DingUserEntity.builder() .id(employeeDetail.getId()) .name(employeeDetail.getName()) .mobile(employeeDetail.getMobile()) .email(employeeDetail.getEmail()) .build()); } dingUserService.saveOrUpdateBatch(userList); log.info("同步员工信息结束"); } /** * 每天十点同步昨天考勤数据 */ @Scheduled(cron = "0 0 10 * * *") // @Scheduled(fixedRate = 20000) public void syncAttendance() { log.info("开始同步考勤数据"); List employeeIdList = dingEmployeeController.getEmployeeIdList(); DingAttendanceDTO dingAttendanceDTO = new DingAttendanceDTO(); dingAttendanceDTO.setUserIds(employeeIdList); // 获取当前日期 Date currentDate = new Date(); LocalDate localDate = currentDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDate(); // 减去一天 LocalDate previousDate = localDate.minusDays(1); // 将 LocalDate 转换回 Date Date previousDateAsDate = Date.from(previousDate.atStartOfDay(ZoneId.systemDefault()).toInstant()); String[] startAndEndOfDay = DateUtils.getStartAndEndOfDay(previousDateAsDate); dingAttendanceDTO.setCheckDateFrom(startAndEndOfDay[0]); dingAttendanceDTO.setCheckDateTo(startAndEndOfDay[1]); List checkInRecord = dingAttendanceController.getCheckInRecord(dingAttendanceDTO); List dingAttendanceEntities = BeanUtil.copyToList(checkInRecord, DingAttendanceEntity.class); for (DingAttendanceEntity dingAttendanceEntity : dingAttendanceEntities) { DingUserVO employeeDetail = dingEmployeeController.getEmployeeDetail(dingAttendanceEntity.getUserId()); List userClockIn = dingAttendanceController.getUserClockIn(dingAttendanceEntity.getUserId(), startAndEndOfDay[0]); dingAttendanceEntity.setName(employeeDetail.getName()); if (!userClockIn.isEmpty()) { dingAttendanceEntity.setDuration(userClockIn.get(0).getDuration()); dingAttendanceEntity.setDurationUnit(userClockIn.get(0).getDurationUnit()); dingAttendanceEntity.setSubType(userClockIn.get(0).getSubType()); dingAttendanceEntity.setTagName(userClockIn.get(0).getTagName()); dingAttendanceEntity.setBizType(userClockIn.get(0).getBizType()); } } dingAttendanceService.saveOrUpdateBatch(dingAttendanceEntities); log.info("同步考勤数据结束"); } /** * 汇总考勤数据 */ @Scheduled(cron = "0 0 10 * * *") // @Scheduled(fixedRate = 20000) public void collectAttendance() { log.info("同步考勤汇总数据开始"); // 获取当前日期 Date currentDate = new Date(); LocalDate localDate = currentDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDate(); // 减去两天 LocalDate previousDate = localDate.minusDays(2); // 将 LocalDate 转换回 Date Date previousDateAsDate = Date.from(previousDate.atStartOfDay(ZoneId.systemDefault()).toInstant()); //上午结束时间 LocalDateTime localDateTime = previousDateAsDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); LocalDateTime noonDateTime = localDateTime.withHour(12).withMinute(0).withSecond(0).withNano(0); Date an = Date.from(noonDateTime.atZone(ZoneId.systemDefault()).toInstant()); //下午开始时间 LocalDateTime localDateTime1 = previousDateAsDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); LocalDateTime noonDateTime1 = localDateTime1.withHour(13).withMinute(30).withSecond(0).withNano(0); Date pn = Date.from(noonDateTime1.atZone(ZoneId.systemDefault()).toInstant()); List dingAttendanceList = dingAttendanceService.getListByDate(previousDateAsDate); List dingAttendanceTotalList = Lists.newArrayList(); for (DingAttendanceEntity dingAttendanceEntity : dingAttendanceList) { double workMillisecond = 0.0; if (ObjectUtil.isNotEmpty(dingAttendanceEntity.getStartTime()) && dingAttendanceEntity.getStartTime().before(an)) { long diffInMillis = Math.abs(dingAttendanceEntity.getStartTime().getTime() - an.getTime()); workMillisecond += diffInMillis; } if (ObjectUtil.isNotEmpty(dingAttendanceEntity.getEndTime()) && dingAttendanceEntity.getEndTime().after(pn)) { long diffInMillis = Math.abs(pn.getTime() - dingAttendanceEntity.getEndTime().getTime()); workMillisecond += diffInMillis; } double workMilliHour = workMillisecond / (1000 * 60 * 60); DingAttendanceTotalEntity dingAttendanceTotalEntity = new DingAttendanceTotalEntity(); dingAttendanceTotalEntity.setUserId(dingAttendanceEntity.getUserId()); dingAttendanceTotalEntity.setName(dingAttendanceEntity.getName()); //workMilliHour保留两位小数 dingAttendanceTotalEntity.setWorkTime(String.format("%.2f", workMilliHour)); dingAttendanceTotalEntity.setDate(dingAttendanceEntity.getDate()); dingAttendanceTotalEntity.setDuration(dingAttendanceEntity.getDuration()); dingAttendanceTotalEntity.setDurationUnit(dingAttendanceEntity.getDurationUnit()); dingAttendanceTotalEntity.setSubType(dingAttendanceEntity.getSubType()); dingAttendanceTotalEntity.setTagName(dingAttendanceEntity.getTagName()); dingAttendanceTotalEntity.setBizType(dingAttendanceEntity.getBizType()); dingAttendanceTotalList.add(dingAttendanceTotalEntity); } dingAttendanceTotalService.saveOrUpdateBatch(dingAttendanceTotalList); log.info("同步考勤汇总数据结束"); } }