zxl
2025-12-05 70b9d626aa9e177d8be559c9dbe0bd43c50374f9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
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.SecurityUtils;
import com.ycl.domain.entity.WorkStationSchedule;
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 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.util.HashMap;
import java.util.List;
import java.util.stream.Collectors;
 
/**
 *  服务实现类
 *
 * @author zxl
 * @since 2025-12-05
 */
@Service
@RequiredArgsConstructor
public class WorkStationScheduleServiceImpl extends ServiceImpl<WorkStationScheduleMapper, WorkStationSchedule> implements WorkStationScheduleService {
 
    private final WorkStationScheduleMapper workStationScheduleMapper;
 
    private final FlowServiceFactory flowServiceFactory;
    /**
     * 添加
     * @param form
     * @return
     */
    @Override
    public Result add(WorkStationScheduleForm form) {
        WorkStationSchedule entity = WorkStationScheduleForm.getEntityByForm(form, null);
        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<String> 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<WorkStationScheduleVO> page = PageUtil.getPage(query, WorkStationScheduleVO.class);
        baseMapper.getPage(page, query);
        return Result.ok().data(page.getRecords()).total(page.getTotal());
    }
 
    /**
     * 根据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<WorkStationSchedule> entities = baseMapper.selectList(null);
        List<WorkStationScheduleVO> 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(userId.toString())
                .orderByHistoricTaskInstanceEndTime()
                .desc();
        List<HistoricTaskInstance> 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; // 转换为分钟
        double avgDurationHour = avgDurationMin / 60; // 转换为分钟
        System.out.println("用户完成任务总数:" + taskCount);
        System.out.println("平均耗时(秒):" + avgDurationSec);
        System.out.println("平均耗时(分钟):" + avgDurationMin);
        System.out.println("平均耗时(小时):" + avgDurationHour);
 
        //查询 日程总数
        List<WorkStationSchedule> 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<String,Object> map = new HashMap<>();
        map.put("totalDuration",totalDuration);
        map.put("avgDurationHour",avgDurationHour);
        map.put("scheduleCount",list.size());
        map.put("completedCount",count);
        return Result.ok().data(map);
    }
}