package com.ycl.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; import com.ycl.common.enums.business.WorkStationEnum; import com.ycl.common.utils.DateUtils; import com.ycl.common.utils.SecurityUtils; import com.ycl.common.utils.StringUtils; import com.ycl.domain.entity.ProjectInfo; import com.ycl.domain.entity.WorkStationSchedule; import com.ycl.domain.vo.DailyStatVO; import com.ycl.factory.FlowServiceFactory; import com.ycl.mapper.WorkStationScheduleMapper; import com.ycl.service.WorkStationScheduleService; import com.ycl.common.base.Result; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ycl.domain.form.WorkStationScheduleForm; import com.ycl.domain.vo.WorkStationScheduleVO; import com.ycl.domain.query.WorkStationScheduleQuery; import com.ycl.service.common.TaskCommonService; import org.flowable.task.api.Task; import org.flowable.task.api.TaskQuery; import org.flowable.task.api.history.HistoricTaskInstance; import org.flowable.task.api.history.HistoricTaskInstanceQuery; import org.springframework.stereotype.Service; import lombok.RequiredArgsConstructor; import com.ycl.framework.utils.PageUtil; import org.springframework.beans.BeanUtils; import org.springframework.util.Assert; import org.springframework.util.CollectionUtils; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.*; import java.util.stream.Collectors; /** * 服务实现类 * * @author zxl * @since 2025-12-05 */ @Service @RequiredArgsConstructor public class WorkStationScheduleServiceImpl extends ServiceImpl implements WorkStationScheduleService { private final WorkStationScheduleMapper workStationScheduleMapper; private final FlowServiceFactory flowServiceFactory; private final TaskCommonService taskCommonService; private final IndexHomeServiceImpl indexHomeServiceImpl; /** * 添加 * @param form * @return */ @Override public Result add(WorkStationScheduleForm form) { WorkStationSchedule entity = WorkStationScheduleForm.getEntityByForm(form, null); Long userId = SecurityUtils.getUserId(); entity.setUserId(userId); entity.setStatus(WorkStationEnum.Incomplete.name()); baseMapper.insert(entity); return Result.ok("添加成功"); } /** * 修改 * @param form * @return */ @Override public Result update(WorkStationScheduleForm form) { WorkStationSchedule entity = baseMapper.selectById(form.getId()); // 为空抛IllegalArgumentException,做全局异常处理 Assert.notNull(entity, "记录不存在"); BeanUtils.copyProperties(form, entity); baseMapper.updateById(entity); return Result.ok("修改成功"); } /** * 批量删除 * @param ids * @return */ @Override public Result remove(List ids) { baseMapper.deleteBatchIds(ids); return Result.ok("删除成功"); } /** * id删除 * @param id * @return */ @Override public Result removeById(String id) { baseMapper.deleteById(id); return Result.ok("删除成功"); } /** * 分页查询 * @param query * @return */ @Override public Result page(WorkStationScheduleQuery query) { IPage page = PageUtil.getPage(query, WorkStationScheduleVO.class); baseMapper.getPage(page, query); return Result.ok().data(page.getRecords()).total(page.getTotal()); } @Override public Result listByDate(WorkStationScheduleQuery query) { Integer projectId = null; if (!"all".equals(query.getProjectId())){ projectId = Integer.valueOf(query.getProjectId()); } Long userId = SecurityUtils.getUserId(); //查询出指定时间段内的数据 List list = baseMapper.groupByProjectAndDate(userId,projectId, DateUtils.getMonthStartTime(query.getCompletedTime()), DateUtils.getMonthEndTime(query.getCompletedTime())); List dailyStatVOList = new ArrayList<>(); for (WorkStationScheduleVO vo : list) { if (vo == null) { continue; } DailyStatVO statVO = new DailyStatVO(); statVO.setId(vo.getId() == null ? -1 : vo.getId()); statVO.setTitle(StringUtils.isBlank(vo.getContent()) ? "无内容" : vo.getContent()); Map stringTimeMap = DateUtils.splitDateToDateAndTime(vo.getCompletedTime()); String date = StringUtils.defaultIfBlank(stringTimeMap.get("date"), ""); String time = StringUtils.defaultIfBlank(stringTimeMap.get("time"), ""); statVO.setDate(date); statVO.setTime(time); statVO.setProject(StringUtils.isBlank(vo.getProjectName()) ? "未关联项目" : vo.getProjectName()); statVO.setProjectId(vo.getProjectId()); statVO.setCompletedTime(vo.getCompletedTime()); dailyStatVOList.add(statVO); } return Result.ok().data(dailyStatVOList); } /** * 根据id查找 * @param id * @return */ @Override public Result detail(Integer id) { WorkStationScheduleVO vo = baseMapper.getById(id); Assert.notNull(vo, "记录不存在"); return Result.ok().data(vo); } /** * 列表 * @return */ @Override public Result all() { List entities = baseMapper.selectList(null); List vos = entities.stream() .map(entity -> WorkStationScheduleVO.getVoByEntity(entity, null)) .collect(Collectors.toList()); return Result.ok().data(vos); } @Override public Result completedAchievements(Integer id) { WorkStationSchedule workStationSchedule = baseMapper.selectById(id); workStationSchedule.setStatus(WorkStationEnum.COMPLETED.name()); baseMapper.updateById(workStationSchedule); return Result.ok(); } @Override public Result countAchievements() { //获得个人已完成流程任务,并计算平均用时 Long userId = SecurityUtils.getUserId(); HistoricTaskInstanceQuery query = flowServiceFactory.getHistoryService() .createHistoricTaskInstanceQuery() .finished() .taskAssignee(SecurityUtils.getUserId() + "") .orderByHistoricTaskInstanceEndTime() .desc(); if (!SecurityUtils.getLoginUser().getUser().isAdmin()) { query .or() .taskCandidateGroupIn(taskCommonService.getCurrentUserGroups()) .taskCandidateUser(SecurityUtils.getUserId() + "") .taskAssignee(SecurityUtils.getUserId() + "") .endOr(); } List taskList = query.list(); long totalDuration = 0L; int taskCount = 0; if (!CollectionUtils.isEmpty(taskList)) { taskCount = taskList.size(); } for (HistoricTaskInstance task : taskList) { // 任务创建时间和完成时间 Long createTime = task.getCreateTime().getTime(); Long endTime = task.getEndTime().getTime(); // 单个任务耗时(毫秒) long duration = endTime - createTime; totalDuration += duration; } double avgDurationMs = (double) totalDuration / taskCount; // 平均耗时(毫秒) double avgDurationSec = avgDurationMs / 1000; // 转换为秒 double avgDurationMin = avgDurationSec / 60; // 转换为分钟 BigDecimal avgDurationHour = new BigDecimal(avgDurationMin / 60).setScale(2, RoundingMode.HALF_UP); // 转换为分钟 System.out.println("用户完成任务总数:" + taskCount); System.out.println("平均耗时(秒):" + avgDurationSec); System.out.println("平均耗时(分钟):" + avgDurationMin); System.out.println("平均耗时(小时):" + avgDurationHour); //查询 日程总数 List list = new LambdaQueryChainWrapper<>(baseMapper) .eq(WorkStationSchedule::getUserId, userId) .eq(WorkStationSchedule::getDeleted, Boolean.FALSE) .list(); int count = 0; for (WorkStationSchedule workStationSchedule : list) { if (WorkStationEnum.COMPLETED.name().equals(workStationSchedule.getStatus())){ count++; } } HashMap map = new HashMap<>(); map.put("totalSchedules",list.size()); map.put("completedSchedules",count); map.put("avgDuration",avgDurationHour.doubleValue()); map.put("completedTasks",taskCount); return Result.ok().data(map); } @Override public Result countTodayTask() { Long userId = SecurityUtils.getUserId(); Date now = new Date(); Date dayStart = DateUtils.getDayStart(now); Date dayEnd = DateUtils.getDayEnd(now); List list = new LambdaQueryChainWrapper<>(baseMapper) .eq(WorkStationSchedule::getUserId, SecurityUtils.getUserId()) .eq(WorkStationSchedule::getDeleted, Boolean.FALSE) .between(WorkStationSchedule::getCompletedTime, dayStart, dayEnd) .list(); HashMap map = new HashMap<>(); map.put("todaySchedules",list.size()); //查询今日处理的 的任务 long claimedAndCompletedCount = flowServiceFactory.getHistoryService().createHistoricTaskInstanceQuery() .finished() .taskAssignee(userId+"") // 任务由当前用户认领(处理人是该用户) .taskCompletedAfter(dayStart) .taskCompletedBefore(dayEnd) .count(); map.put("totalActiveTasks",claimedAndCompletedCount); int distinctTotal = indexHomeServiceImpl.countWaitTask(); map.put("todayTasks",distinctTotal); return Result.ok().data(map); } }