package org.jeecg.modules.eam.service.impl; import cn.hutool.core.collection.CollectionUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.fasterxml.jackson.core.JsonProcessingException; import com.fasterxml.jackson.databind.ObjectMapper; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.flowable.engine.TaskService; import org.flowable.task.api.Task; import org.jeecg.common.api.vo.FileUploadResult; import org.jeecg.common.api.vo.Result; import org.jeecg.common.constant.CommonConstant; import org.jeecg.common.constant.DataBaseConstant; import org.jeecg.common.exception.JeecgBootException; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.eam.aspect.annotation.EquipmentHistoryLog; import org.jeecg.modules.eam.constant.BusinessCodeConst; import org.jeecg.modules.eam.constant.EquipmentOperationTagEnum; import org.jeecg.modules.eam.constant.InspectionStatus; import org.jeecg.modules.eam.entity.EamEquipment; import org.jeecg.modules.eam.entity.EamInspectionOrder; import org.jeecg.modules.eam.entity.EamInspectionOrderDetail; import org.jeecg.modules.eam.mapper.EamInspectionOrderMapper; import org.jeecg.modules.eam.request.EamInspectionOrderQuery; import org.jeecg.modules.eam.request.EamInspectionOrderRequest; import org.jeecg.modules.eam.service.IEamEquipmentService; import org.jeecg.modules.eam.service.IEamInspectionOrderDetailService; import org.jeecg.modules.eam.service.IEamInspectionOrderService; import org.jeecg.modules.eam.service.IEamReportRepairService; import org.jeecg.modules.eam.vo.InspectionVo; import org.jeecg.modules.flowable.apithird.business.entity.FlowMyBusiness; import org.jeecg.modules.flowable.apithird.business.service.impl.FlowMyBusinessServiceImpl; import org.jeecg.modules.flowable.apithird.service.FlowCallBackServiceI; import org.jeecg.modules.flowable.apithird.service.FlowCommonService; import org.jeecg.modules.flowable.service.IFlowDefinitionService; import org.jeecg.modules.flowable.service.IFlowTaskService; import org.jeecg.modules.system.service.IMdcUserProductionService; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.util.*; /** * @Description: 点检工单 * @Author: jeecg-boot * @Date: 2025-04-02 * @Version: V1.0 */ @Service("IEamInspectionOrderService") public class EamInspectionOrderServiceImpl extends ServiceImpl implements IEamInspectionOrderService, FlowCallBackServiceI { @Resource private EamInspectionOrderMapper eamInspectionOrderMapper; @Autowired private IEamInspectionOrderDetailService eamInspectionOrderDetailService; @Resource private FlowCommonService flowCommonService; @Resource private IFlowDefinitionService flowDefinitionService; @Autowired private IFlowTaskService flowTaskService; @Autowired private IEamEquipmentService eamEquipmentService; @Autowired private FlowMyBusinessServiceImpl flowMyBusinessService; @Autowired private TaskService taskService; @Autowired private IEamEquipmentService iEamEquipmentService; @Autowired private IMdcUserProductionService mdcUserProductionService; @Autowired private IEamReportRepairService eamReportRepairService; @Override public IPage queryPageList(Page page, EamInspectionOrderQuery query) { QueryWrapper queryWrapper = new QueryWrapper<>(); //用户数据权限 LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); if (sysUser == null) { return page; } if (StringUtils.isNotBlank(sysUser.getEquipmentIds())) { //选择了设备,根据设备id过滤设备 List equipArr = Arrays.asList(sysUser.getEquipmentIds().split(",")); queryWrapper.in("e.equipment_code", equipArr); } else { //没有选择设备,根据车间过滤设备 queryWrapper.exists("select 1 from mdc_user_production t where t.user_id={0} and t.pro_id=e.org_id ", sysUser.getId()); } //查询条件过滤 if (query != null) { if (StringUtils.isNotBlank(query.getEquipmentId())) { queryWrapper.eq("wmo.equipment_id", query.getEquipmentId()); } if (StringUtils.isNotBlank(query.getOrderNum())) { queryWrapper.like("wmo.order_num", query.getOrderNum()); } if (StringUtils.isNotBlank(query.getInspectionStatus())) { queryWrapper.eq("wmo.inspection_status", query.getInspectionStatus()); } if (query.getInspectionDateBegin() != null && query.getInspectionDateEnd() != null) { queryWrapper.between("wmo.inspection_date", query.getInspectionDateBegin(), query.getInspectionDateEnd()); } //排序 if (StringUtils.isNotBlank(query.getColumn()) && StringUtils.isNotBlank(query.getOrder())) { String column = query.getColumn(); if (column.endsWith(CommonConstant.DICT_TEXT_SUFFIX)) { column = column.substring(0, column.lastIndexOf(CommonConstant.DICT_TEXT_SUFFIX)); } if (DataBaseConstant.SQL_ASC.equalsIgnoreCase(query.getOrder())) { queryWrapper.orderByAsc("wmo." + oConvertUtils.camelToUnderline(column)); } else { queryWrapper.orderByDesc("wmo." + oConvertUtils.camelToUnderline(column)); } } else { queryWrapper.orderByDesc("wmo.create_time"); } } else { queryWrapper.orderByDesc("wmo.create_time"); } return eamInspectionOrderMapper.queryPageList(page, queryWrapper); } @Override public List selectUnCompleteOrder(String expiredDate) { LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.lt(EamInspectionOrder::getInspectionDate, expiredDate); List unCompleteStatus = new ArrayList<>(); unCompleteStatus.add(InspectionStatus.WAIT_INSPECTION.name()); unCompleteStatus.add(InspectionStatus.UNDER_INSPECTION.name()); queryWrapper.in(EamInspectionOrder::getInspectionStatus, unCompleteStatus); queryWrapper.orderByAsc(EamInspectionOrder::getInspectionDate); return eamInspectionOrderMapper.selectList(queryWrapper); } @Override @Transactional(rollbackFor = Exception.class) public boolean addInspectionOrder(EamInspectionOrderRequest eamInspectionOrderRequest) { EamInspectionOrder eamInspectionOrder = new EamInspectionOrder(); BeanUtils.copyProperties(eamInspectionOrderRequest, eamInspectionOrder); //修改状态 if (StrUtil.isNotBlank(eamInspectionOrderRequest.getOperator())) { eamInspectionOrder.setInspectionStatus(InspectionStatus.UNDER_INSPECTION.name()); } else { eamInspectionOrder.setInspectionStatus(InspectionStatus.WAIT_INSPECTION.name()); } save(eamInspectionOrder); //处理明细数据 if (CollectionUtil.isNotEmpty(eamInspectionOrderRequest.getTableDetailList())) { eamInspectionOrderRequest.getTableDetailList().forEach(tableDetail -> { tableDetail.setOrderId(eamInspectionOrder.getId()); tableDetail.setId(null); }); eamInspectionOrderDetailService.saveBatch(eamInspectionOrderRequest.getTableDetailList()); } //处理附件 if (CollectionUtil.isNotEmpty(eamInspectionOrderRequest.getFileList())) { FileUploadResult fileUploadResult = eamInspectionOrderRequest.getFileList().get(0); ObjectMapper mapper = new ObjectMapper(); try { String referenceFile = mapper.writeValueAsString(fileUploadResult); eamInspectionOrder.setImageFiles(referenceFile); } catch (JsonProcessingException e) { log.error("JSON转换失败:" + e.getMessage(), e); } } if (StrUtil.isNotBlank(eamInspectionOrderRequest.getOperator())) { triggerProcess(eamInspectionOrder); } return true; } /** * 触发流程 * * @param eamInspectionOrder * @return */ public boolean triggerProcess(EamInspectionOrder eamInspectionOrder) { EamEquipment equipment = eamEquipmentService.getById(eamInspectionOrder.getEquipmentId()); if (equipment == null) { return false; } else { eamInspectionOrder.setEquipmentCode(equipment.getEquipmentCode()); } flowCommonService.initActBusiness("工单号: " + eamInspectionOrder.getOrderNum() + ";设备编号: " + eamInspectionOrder.getEquipmentCode() + ";安装位置: " + equipment.getInstallationPosition(), eamInspectionOrder.getId(), "IEamInspectionOrderService", "eam_inspection", null); Map variables = new HashMap<>(); variables.put("dataId", eamInspectionOrder.getId()); if (StrUtil.isEmpty(eamInspectionOrder.getRemark())) { variables.put("organization", "新增点检工单默认启动流程"); variables.put("comment", "新增点检工单默认启动流程"); } else { variables.put("organization", eamInspectionOrder.getRemark()); variables.put("comment", eamInspectionOrder.getRemark()); } variables.put("proofreading", true); List usernames = new ArrayList<>(); usernames.add(eamInspectionOrder.getOperator()); variables.put("NextAssignee", usernames); Result result = flowDefinitionService.startProcessInstanceByKey("eam_inspection", variables); return result.isSuccess(); } @Override public boolean editInspectionOrder(EamInspectionOrderRequest eamInspectionOrderRequest) { EamInspectionOrder eamInspectionOrder = new EamInspectionOrder(); BeanUtils.copyProperties(eamInspectionOrderRequest, eamInspectionOrder); if (StrUtil.isNotEmpty(eamInspectionOrder.getOperator())) { eamInspectionOrder.setInspectionStatus(InspectionStatus.UNDER_INSPECTION.name()); } super.updateById(eamInspectionOrder); //处理明细数据 if (CollectionUtil.isNotEmpty(eamInspectionOrderRequest.getTableDetailList())) { eamInspectionOrderRequest.getTableDetailList().forEach(tableDetail -> { tableDetail.setOrderId(eamInspectionOrder.getId()); tableDetail.setCreateTime(new Date()); }); //删除明细 eamInspectionOrderDetailService.remove(new QueryWrapper().eq("order_id", eamInspectionOrder.getId())); eamInspectionOrderDetailService.saveBatch(eamInspectionOrderRequest.getTableDetailList()); } return true; } /** * 领取点检工单 * * @param id * @return */ @Override @Transactional(rollbackFor = Exception.class) public boolean takeInspectionOrder(String id) { LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); if(user == null || !BusinessCodeConst.PCR0001.equals(user.getPost())) { throw new JeecgBootException("不是操作工,无法领取此工单!"); } EamInspectionOrder eamInspectionOrder = this.getById(id); if (eamInspectionOrder == null) { return false; } else { eamInspectionOrder.setOperator(user.getUsername()); //修改状态 eamInspectionOrder.setInspectionStatus(InspectionStatus.UNDER_INSPECTION.name()); this.triggerProcess(eamInspectionOrder); this.updateById(eamInspectionOrder); return true; } } /** * 作废点检工单 * * @param id * @return */ @Override public boolean cancelInspectionOrder(String id) { EamInspectionOrder eamInspectionOrder = this.getById(id); if (eamInspectionOrder == null) { return false; } else { eamInspectionOrder.setInspectionStatus(InspectionStatus.ABOLISH.name()); return updateById(eamInspectionOrder); } } /** * 点检流程 * * @param eamInspectionOrderRequest * @return */ @Override @Transactional(rollbackFor = Exception.class) @EquipmentHistoryLog(operationTag = EquipmentOperationTagEnum.POINT_INSPECTION, businessTable = "eam_inspection_order") public EamInspectionOrder inspectionProcess(EamInspectionOrderRequest eamInspectionOrderRequest) { try { // 检查请求参数 if (!isValidRequest(eamInspectionOrderRequest)) { throw new JeecgBootException("非法参数"); } // 获取当前登录用户 LoginUser user = getCurrentUser(); if (user == null || StrUtil.isBlank(user.getId())) { throw new JeecgBootException("账号不存在"); } eamInspectionOrderRequest.setAssignee(user.getUsername()); // 获取点检工单信息 EamInspectionOrder eamInspectionOrder = getEamInspectionOrder(eamInspectionOrderRequest.getDataId()); if (eamInspectionOrder == null) { throw new JeecgBootException("未找到对应数据"); } // 获取流程业务记录 FlowMyBusiness flowMyBusiness = getFlowMyBusiness(eamInspectionOrderRequest.getInstanceId()); if (flowMyBusiness == null) { throw new JeecgBootException("流程记录不存在"); } // 检查用户是否有权限操作任务 if (!isUserAuthorized(flowMyBusiness, user)) { throw new JeecgBootException("用户无权操作此任务"); } // 认领任务 if (!claimTask(flowMyBusiness.getTaskId(), user)) { throw new JeecgBootException("任务不存在、已完成或已被他人认领"); } // 设置流程变量 setupProcessVariables(eamInspectionOrderRequest, eamInspectionOrder, user); // 完成流程任务 Result result = flowTaskService.complete(eamInspectionOrderRequest); // 根据任务完成结果更新工单状态 updateOrderStatus(result, eamInspectionOrderRequest, eamInspectionOrder, user); // 更新工单信息 updateEamInspectionOrder(eamInspectionOrder); //查询数据,进行设备维修处理 if (eamInspectionOrder.getInspectionStatus().equals(InspectionStatus.WAIT_CONFIRM.name())) { updateEamInspectionOrderDetail(eamInspectionOrder); } return eamInspectionOrder; } catch (Exception e) { throw new JeecgBootException("操作失败:" + e.getMessage()); } } private boolean isValidRequest(EamInspectionOrderRequest request) { return StrUtil.isNotBlank(request.getTaskId()) && StrUtil.isNotBlank(request.getDataId()); } private LoginUser getCurrentUser() { try { return (LoginUser) SecurityUtils.getSubject().getPrincipal(); } catch (Exception e) { return null; } } private EamInspectionOrder getEamInspectionOrder(String dataId) { return this.getById(dataId); } private FlowMyBusiness getFlowMyBusiness(String instanceId) { List businessList = flowMyBusinessService.list( new QueryWrapper().eq("process_instance_id", instanceId)); return businessList.isEmpty() ? null : businessList.get(0); } private boolean isUserAuthorized(FlowMyBusiness flowMyBusiness, LoginUser user) { List todoUsers = JSON.parseArray(flowMyBusiness.getTodoUsers(), String.class); return todoUsers != null && todoUsers.contains(user.getUsername()); } private boolean claimTask(String taskId, LoginUser user) { Task task = taskService.createTaskQuery().taskId(taskId).singleResult(); if (task == null) { return false; } if (task.getAssignee() != null && !task.getAssignee().equals(user.getUsername())) { return false; } taskService.claim(taskId, user.getUsername()); return true; } private void setupProcessVariables(EamInspectionOrderRequest request, EamInspectionOrder order, LoginUser user) { Map values = new HashMap<>(); if (InspectionStatus.UNDER_INSPECTION.name().equals(order.getInspectionStatus()) && user.getUsername().equals(order.getOperator())) { // 点检人点检结束 String manager = Optional.ofNullable(iEamEquipmentService.getById(order.getEquipmentId())) .map(EamEquipment::getEquipmentManager) .orElse(null); if (manager == null) { throw new IllegalArgumentException("设备管理员未配置"); } List usernameList = Collections.singletonList(manager); values.put("dataId", order.getId()); values.put("organization", "点检人点检结束"); values.put("comment", "点检人点检结束"); values.put("NextAssignee", usernameList); request.setComment("点检人点检结束"); } else { // 班组长确认 values.put("dataId", order.getId()); values.put("organization", request.getConfirmComment()); values.put("comment", request.getConfirmComment()); values.put("confirmation", request.getConfirmDealType()); request.setComment(request.getConfirmComment()); if ("2".equals(request.getConfirmDealType())) { // 班组长驳回 List usernames = new ArrayList<>(); usernames.add(order.getOperator()); order.setInspectionStatus(InspectionStatus.UNDER_INSPECTION.name()); values.put("NextAssignee", usernames); } } request.setValues(values); } private void updateOrderStatus(Result result, EamInspectionOrderRequest request, EamInspectionOrder order, LoginUser user) { if (result.isSuccess()) { if (InspectionStatus.UNDER_INSPECTION.name().equals(order.getInspectionStatus()) && StrUtil.isEmpty(request.getConfirmDealType())) { // 点检完成 order.setInspectionStatus(InspectionStatus.WAIT_CONFIRM.name()); order.setOperateTime(new Date()); if (CollectionUtil.isNotEmpty(request.getFileList())) { List fileUploadResultList = request.getFileList(); ObjectMapper mapper = new ObjectMapper(); try { String referenceFile = mapper.writeValueAsString(fileUploadResultList); order.setImageFiles(referenceFile); } catch (JsonProcessingException e) { log.error("JSON转换失败:" + e.getMessage(), e); } } eamInspectionOrderDetailService.remove(new QueryWrapper().eq("order_id", order.getId())); eamInspectionOrderDetailService.saveBatch(request.getTableDetailList()); } else if (InspectionStatus.WAIT_CONFIRM.name().equals(order.getInspectionStatus()) && StrUtil.isNotEmpty(request.getConfirmDealType())) { // 班组长确认任务 order.setInspectionStatus(InspectionStatus.COMPLETE.name()); order.setConfirmUser(user.getUsername()); order.setConfirmComment(request.getConfirmComment()); order.setConfirmDealType(request.getConfirmDealType()); order.setConfirmTime(new Date()); } } } private void updateEamInspectionOrder(EamInspectionOrder eamInspectionOrder) { this.updateById(eamInspectionOrder); } /** * 设备是否存在异常,并进行设备维修 * * @param eamInspectionOrder */ private void updateEamInspectionOrderDetail(EamInspectionOrder eamInspectionOrder) { List eamInspectionOrderDetails = eamInspectionOrderDetailService .list(new QueryWrapper() .eq("order_id", eamInspectionOrder.getId()).eq("report_flag", "1").eq("inspection_result", "2")); //只有保养项明细中“点检结果”为“异常”,并且"异常是否报修"为“是”的情况才会生成故障数据,其他情况则不生成 if (CollectionUtils.isEmpty(eamInspectionOrderDetails)) { return; } eamReportRepairService.reportRepairFromInspection(eamInspectionOrder.getEquipmentId(), eamInspectionOrder.getOperator(), eamInspectionOrderDetails); } /** * 批量作废与领取 * * @param ids * @param type * @return */ @Override @Transactional(rollbackFor = Exception.class) public Result batchCancelOrTakeInspectionOrder(String ids, String type) { if (type == null) { return Result.error("请选择操作类型"); } LoginUser loginUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); List list = Arrays.asList(ids.split(",")); QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.in("id", list); queryWrapper.eq("inspection_status", InspectionStatus.WAIT_INSPECTION.name()); List eamInspectionOrderList = this.list(queryWrapper); if (!eamInspectionOrderList.isEmpty()) { eamInspectionOrderList.forEach(eamInspectionOrder -> { eamInspectionOrder.setInspectionStatus(type); if (InspectionStatus.UNDER_INSPECTION.name().equals(type)) { eamInspectionOrder.setOperator(loginUser.getUsername()); this.triggerProcess(eamInspectionOrder); } else { eamInspectionOrder.setOperator(null); } }); this.updateBatchById(eamInspectionOrderList); } return Result.OK("操作成功"); } @Override public Result selectVoById(String id) { List eamInspectionOrders = this.list(new QueryWrapper().eq("id", id)); List eamInspectionOrderRequestList = new ArrayList<>(); eamInspectionOrders.forEach(eamInspectionOrder -> { EamInspectionOrderRequest eamInspectionOrderRequest = new EamInspectionOrderRequest(); BeanUtils.copyProperties(eamInspectionOrder, eamInspectionOrderRequest); List eamInspectionOrderDetails = eamInspectionOrderDetailService .list(new QueryWrapper().eq("order_id", eamInspectionOrder.getId())); eamInspectionOrderRequest.setTableDetailList(eamInspectionOrderDetails); eamInspectionOrderRequestList.add(eamInspectionOrderRequest); }); return Result.ok(eamInspectionOrderRequestList); } @Override public void afterFlowHandle(FlowMyBusiness business) { business.getTaskNameId();//接下来审批的节点 business.getValues();//前端传进来的参数 business.getActStatus(); } @Override public Object getBusinessDataById(String dataId) { return this.getById(dataId); } @Override public Map flowValuesOfTask(String taskNameId, Map values) { return null; } @Override public List flowCandidateUsernamesOfTask(String taskNameId, Map values) { //业务是否干预流程,业务干预,流程干预,指定人员进行处理 //获取下一步处理人 Object object = values.get("NextAssignee"); return (List) object; } @Override public List findInspectionResult(String equipmentId,String itemDemand,String yearMonth) { return this.baseMapper.findInspectionResult(equipmentId,itemDemand,yearMonth); } @Override public List findInspectionUser(String equipmentId,String yearMonth) { return this.baseMapper.findInspectionUser(equipmentId,yearMonth); } @Override public List> findInspectionStandard(String equipmentId) { return this.baseMapper.findInspectionStandard(equipmentId); } }