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.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; 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.exception.JeecgBootException; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.modules.eam.base.entity.BaseFactory; import org.jeecg.modules.eam.base.entity.BaseFactoryUser; import org.jeecg.modules.eam.base.service.IBaseFactoryService; import org.jeecg.modules.eam.base.service.IBaseFactoryUserService; import org.jeecg.modules.eam.constant.BusinessCodeConst; import org.jeecg.modules.eam.constant.MaintenanceStandardStatusEnum; import org.jeecg.modules.eam.entity.EamEquipment; import org.jeecg.modules.eam.entity.EamMaintenanceStandard; import org.jeecg.modules.eam.entity.EamMaintenanceStandardDetail; import org.jeecg.modules.eam.mapper.EamMaintenanceStandardMapper; import org.jeecg.modules.eam.request.EamMaintenanceStandardRequest; import org.jeecg.modules.eam.service.IEamEquipmentService; import org.jeecg.modules.eam.service.IEamMaintenanceStandardDetailService; import org.jeecg.modules.eam.service.IEamMaintenanceStandardService; import org.jeecg.modules.eam.vo.EamMaintenanceStandardVo; import org.jeecg.modules.flowable.apithird.business.entity.FlowMyBusiness; import org.jeecg.modules.flowable.apithird.business.service.IFlowMyBusinessService; 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.ISysUserService; import org.jeecg.modules.system.vo.UserSelector; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import java.util.*; import java.util.regex.Matcher; import java.util.regex.Pattern; import java.util.stream.Collectors; /** * @Description: 保养标准 * @Author: jeecg-boot * @Date: 2025-03-26 * @Version: V1.0 */ @Service("IEamMaintenanceStandardService") public class EamMaintenanceStandardServiceImpl extends ServiceImpl implements IEamMaintenanceStandardService , FlowCallBackServiceI { @Resource private EamMaintenanceStandardMapper eamMaintenanceStandardMapper; @Autowired private IEamMaintenanceStandardDetailService eamMaintenanceStandardDetailService; @Autowired private IBaseFactoryUserService baseFactoryUserService; @Autowired private IBaseFactoryService baseFactoryService; @Resource private FlowCommonService flowCommonService; @Resource private IFlowDefinitionService flowDefinitionService; @Autowired private IFlowTaskService flowTaskService; @Autowired private TaskService taskService; @Autowired private IFlowMyBusinessService flowMyBusinessService; @Autowired private ISysUserService sysUserService; @Autowired private IEamEquipmentService eamEquipmentService; @Override public IPage queryPageList(Page page, EamMaintenanceStandard eamMaintenanceStandard) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("ems.del_flag", CommonConstant.DEL_FLAG_0); //用户数据权限 LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); if (sysUser == null) { return page; } if (StringUtils.isNotBlank(sysUser.getEamEquipmentIds())) { //选择了设备,根据设备id过滤设备 List equipArr = Arrays.asList(sysUser.getEamEquipmentIds().split(",")); queryWrapper.in("e.equipment_code", equipArr); } else { //没有选择设备,根据中心过滤设备 List baseFactoryUserList=baseFactoryUserService. list(new LambdaQueryWrapper().eq(BaseFactoryUser::getUserId,sysUser.getId())); if(!CollectionUtils.isEmpty(baseFactoryUserList)){ List factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList()); List factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList()); queryWrapper.in("e.factory_code", factoryCode); } } if(eamMaintenanceStandard != null) { //编码 模糊查询 if(StringUtils.isNotBlank(eamMaintenanceStandard.getStandardCode())) { queryWrapper.like("ems.standard_code", eamMaintenanceStandard.getStandardCode()); } //名称 模糊查询 if(StringUtils.isNotBlank(eamMaintenanceStandard.getStandardName())) { queryWrapper.like("ems.standard_name", eamMaintenanceStandard.getStandardName()); } //设备 if(StringUtils.isNotBlank(eamMaintenanceStandard.getEquipmentId())) { queryWrapper.eq("ems.equipment_id", eamMaintenanceStandard.getEquipmentId()); } //保养分类 if(StringUtils.isNotBlank(eamMaintenanceStandard.getMaintenanceCategory())) { queryWrapper.eq("ems.maintenance_category", eamMaintenanceStandard.getMaintenanceCategory()); } //保养分类 if(StringUtils.isNotBlank(eamMaintenanceStandard.getStandardStatus())) { queryWrapper.eq("ems.standard_status", eamMaintenanceStandard.getStandardStatus()); } //设备编码 if(StringUtils.isNotBlank(eamMaintenanceStandard.getKeyword())) { queryWrapper.and(wrapper -> wrapper.like("e.equipment_name", eamMaintenanceStandard.getKeyword()) .or() .like("e.equipment_code", eamMaintenanceStandard.getKeyword())); } //id if(StringUtils.isNotBlank(eamMaintenanceStandard.getId())) { queryWrapper.eq("ems.id", eamMaintenanceStandard.getId()); } } queryWrapper.orderByDesc("ems.create_time"); return eamMaintenanceStandardMapper.queryPageList(page, queryWrapper); } @Override @Transactional(rollbackFor = Exception.class) public boolean addMaintenanceStandard(EamMaintenanceStandardRequest standardRequest) { EamMaintenanceStandard entity = new EamMaintenanceStandard(); BeanUtils.copyProperties(standardRequest, entity); entity.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); //版本递增 entity.setStandardVersion("v"+CommonConstant.OPERATE_TYPE_1); //设备处理 entity.setEquipmentId(standardRequest.getEquipmentId()); //删除标记 entity.setDelFlag(CommonConstant.DEL_FLAG_0); //重复性校验 EamMaintenanceStandard exist = checkDuplicate(entity.getEquipmentId(), entity.getMaintenanceCategory()); if(exist != null){ throw new JeecgBootException("设备标准已存在,不能重复添加!"); } eamMaintenanceStandardMapper.insert(entity); //处理明细数据 if(CollectionUtil.isNotEmpty(standardRequest.getTableDetailList())) { standardRequest.getTableDetailList().forEach(tableDetail -> { tableDetail.setStandardId(entity.getId()); }); eamMaintenanceStandardDetailService.saveBatch(standardRequest.getTableDetailList()); } return true; } @Override @Transactional(rollbackFor = Exception.class) public boolean editMaintenanceStandard(EamMaintenanceStandardRequest standardRequest) { EamMaintenanceStandard entity = eamMaintenanceStandardMapper.selectById(standardRequest.getId()); if(entity == null){ throw new JeecgBootException("编辑的数据已删除,请刷新重试!"); } entity.setStandardName(standardRequest.getStandardName()); entity.setMaintenancePeriod(standardRequest.getMaintenancePeriod()); eamMaintenanceStandardMapper.updateById(entity); //处理详情 if(CollectionUtil.isNotEmpty(standardRequest.getTableDetailList())) { List addList = new ArrayList<>(); List updateList = new ArrayList<>(); standardRequest.getTableDetailList().forEach(tableDetail -> { tableDetail.setStandardId(entity.getId()); if(tableDetail.getId() == null){ addList.add(tableDetail); }else { updateList.add(tableDetail); } }); if(CollectionUtil.isNotEmpty(addList)){ eamMaintenanceStandardDetailService.saveBatch(addList); } if(CollectionUtil.isNotEmpty(updateList)){ eamMaintenanceStandardDetailService.updateBatchById(updateList); } } if(CollectionUtil.isNotEmpty(standardRequest.getRemoveDetailList())) { List ids = standardRequest.getRemoveDetailList().stream().map(EamMaintenanceStandardDetail::getId).collect(Collectors.toList()); eamMaintenanceStandardDetailService.removeBatchByIds(ids); } return true; } @Override @Transactional(rollbackFor = Exception.class) public boolean upgradeMaintenanceStandard(EamMaintenanceStandardRequest standardRequest) { EamMaintenanceStandard entity = eamMaintenanceStandardMapper.selectById(standardRequest.getId()); if(entity == null){ throw new JeecgBootException("编辑的数据已删除,请刷新重试!"); } //新增一个版本 EamMaintenanceStandard newEntity = new EamMaintenanceStandard(); newEntity.setStandardCode(standardRequest.getStandardCode()); newEntity.setStandardName(standardRequest.getStandardName()); newEntity.setMaintenanceCategory(standardRequest.getMaintenanceCategory()); newEntity.setMaintenancePeriod(standardRequest.getMaintenancePeriod()); newEntity.setInitialDate(standardRequest.getInitialDate()); newEntity.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); //版本递增 //获取数字 Pattern pattern = Pattern.compile("(\\d+)(?:\\.\\d+)*$"); Matcher matcher = pattern.matcher(entity.getStandardVersion()); if (matcher.find()) { try { int mainVersion = Integer.parseInt(matcher.group(1)); newEntity.setStandardVersion("v"+(mainVersion+1)); } catch (NumberFormatException ignored) { } } //设备处理 newEntity.setEquipmentId(standardRequest.getEquipmentId()); //删除标记 newEntity.setDelFlag(CommonConstant.DEL_FLAG_0); //重复性校验 EamMaintenanceStandard exist = checkDuplicate(newEntity.getEquipmentId(), newEntity.getMaintenanceCategory()); if(exist != null){ throw new JeecgBootException("设备标准已存在,不能重复添加!"); } eamMaintenanceStandardMapper.insert(newEntity); //处理明细数据 if(CollectionUtil.isNotEmpty(standardRequest.getTableDetailList())) { standardRequest.getTableDetailList().forEach(tableDetail -> { tableDetail.setId(null); tableDetail.setCreateBy(null); tableDetail.setUpdateBy(null); tableDetail.setCreateTime(null); tableDetail.setUpdateTime(null); tableDetail.setStandardId(newEntity.getId()); }); eamMaintenanceStandardDetailService.saveBatch(standardRequest.getTableDetailList()); } return true; } @Override public EamMaintenanceStandard checkDuplicate(String equipmentId, String maintenanceCategory) { LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(EamMaintenanceStandard::getEquipmentId, equipmentId); queryWrapper.eq(EamMaintenanceStandard::getMaintenanceCategory, maintenanceCategory); queryWrapper.eq(EamMaintenanceStandard::getDelFlag, CommonConstant.DEL_FLAG_0); queryWrapper.eq(EamMaintenanceStandard::getStandardStatus, MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); queryWrapper.orderByDesc(EamMaintenanceStandard::getStandardVersion); List list = eamMaintenanceStandardMapper.selectList(queryWrapper); if(CollectionUtil.isEmpty(list)) { return null; } return list.get(0); } /** * 查询标准列表-前端展示该用户拥有的标准 * @param keyword 设备编号 * @param maintenanceCategory 保养类型 * @return */ @Override public List queryListByKeywordAndCategory(String keyword, String equipmentId, Integer pageSize, String maintenanceCategory){ Page page = new Page(1, pageSize); EamMaintenanceStandard query = new EamMaintenanceStandard(); query.setEquipmentId(equipmentId); query.setKeyword(keyword); query.setMaintenanceCategory(maintenanceCategory); query.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); IPage pageData = this.queryPageList(page, query); return pageData.getRecords(); } @Override public List queryListByCategory(String maintenanceCategory) { LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(EamMaintenanceStandard::getDelFlag, CommonConstant.DEL_FLAG_0); queryWrapper.eq(EamMaintenanceStandard::getMaintenanceCategory, maintenanceCategory); queryWrapper.eq(EamMaintenanceStandard::getStandardStatus, MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); return eamMaintenanceStandardMapper.selectList(queryWrapper); } /*流程业务代码--------------------------开始*/ /** * 流程启动,保存对应的数据 * @param id * @return */ @Override public Result saveEamMaintenanceStandardProcess(String id){ LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); EamMaintenanceStandard maintenanceStandard=this.getById(id); if (maintenanceStandard==null){ return Result.error("未找到对应保养标准"); } System.out.println("保养规范流程:" + maintenanceStandard.getId()); flowCommonService.initActBusiness(maintenanceStandard.getStandardName()+"规范进行流程审核", maintenanceStandard.getId(), "IEamMaintenanceStandardService", "eam_maintenance_standard", null); Map variables = new HashMap<>(); variables.put("dataId", maintenanceStandard.getId()); variables.put("organization", "保养规范启动流程"); variables.put("comment", "保养规范启动流程"); variables.put("proofreading",true); Result result= flowDefinitionService.startProcessInstanceByKey("eam_maintenance_standard", variables); if (!result.isSuccess()) { super.removeById(maintenanceStandard.getId()); }else { maintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR.name()); maintenanceStandard.setDesigner(user.getUsername()); maintenanceStandard.setDesignTime(new Date()); eamMaintenanceStandardMapper.updateById(maintenanceStandard); //获取flow的流程实例id,设置下一步的处理人员 List businessList = flowMyBusinessService.list( new QueryWrapper() .eq("data_id", maintenanceStandard.getId()) ); if (businessList.isEmpty()) { return Result.error("流程记录不存在"); } FlowMyBusiness flowMyBusiness = businessList.get(0); EamEquipment eamEquipment=eamEquipmentService.getById(maintenanceStandard.getEquipmentId()); BaseFactory baseFactory=baseFactoryService.getOne(new QueryWrapper().eq("org_code", eamEquipment.getFactoryOrgCode())); List userSelectorList=sysUserService.selectOperatorFactoryList(eamEquipment.getEquipmentCode(),baseFactory.getId(), BusinessCodeConst.PCR0007); if (!CollectionUtils.isEmpty(userSelectorList)) { List usernameList=userSelectorList.stream().map(UserSelector::getUsername).collect(Collectors.toList()); flowMyBusiness.setTodoUsers(JSON.toJSONString(usernameList)); flowMyBusinessService.updateById(flowMyBusiness); } } return result; } /** * 审批操作 * @param eamMaintenanceStandardVo * @return */ @Override public Result auditEamMaintenanceStandard(EamMaintenanceStandardVo eamMaintenanceStandardVo){ try { // 参数校验 if (StrUtil.isEmpty(eamMaintenanceStandardVo.getTaskId()) || StrUtil.isEmpty(eamMaintenanceStandardVo.getDataId())) { return Result.error("参数错误"); } LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); String userId = user.getId(); eamMaintenanceStandardVo.setAssignee(user.getUsername()); if (StrUtil.isEmpty(userId)) { return Result.error("未找到对应用户"); } // 数据查询 EamMaintenanceStandard eamMaintenanceStandard = this.getById(eamMaintenanceStandardVo.getDataId()); if (eamMaintenanceStandard == null) { return Result.error("未找到对应保养标准"); } // 2. 查询流程业务记录(处理空结果) List businessList = flowMyBusinessService.list( new QueryWrapper() .eq("process_instance_id", eamMaintenanceStandardVo.getInstanceId()) ); if (businessList.isEmpty()) { return Result.error("流程记录不存在"); } FlowMyBusiness flowMyBusiness = businessList.get(0); // 3. 校验用户是否为候选处理人 List todoUsers = JSON.parseArray(flowMyBusiness.getTodoUsers(), String.class); if (todoUsers == null || !todoUsers.contains(user.getUsername())) { return Result.error("用户无权操作此任务"); } // 4. 认领任务(处理已被认领的情况) String taskId = flowMyBusiness.getTaskId(); Task task = taskService.createTaskQuery().taskId(taskId).singleResult(); if (task == null) { return Result.error("任务不存在或已完成"); } if (task.getAssignee() != null && !task.getAssignee().equals(user.getUsername())) { return Result.error("任务已被他人认领"); } taskService.claim(taskId, user.getUsername()); // 设置流程变量 Map values = setProcessVariables(eamMaintenanceStandard, userId, eamMaintenanceStandardVo); eamMaintenanceStandardVo.setValues(values); eamMaintenanceStandardVo.setComment(values.get("comment").toString()); // 完成流程任务 Result result = flowTaskService.complete(eamMaintenanceStandardVo); if (result.isSuccess()) { if (eamMaintenanceStandardVo.getRepairManagerApproveResult() != null) { if (eamMaintenanceStandardVo.getRepairManagerApproveResult().equals("1")){ eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name()); //获取flow的流程实例id,设置下一步的处理人员 EamMaintenanceStandard maintenanceStandard=this.getById(eamMaintenanceStandardVo.getDataId()); EamEquipment eamEquipment=eamEquipmentService.getById(maintenanceStandard.getEquipmentId()); BaseFactory baseFactory=baseFactoryService.getOne(new QueryWrapper().eq("org_code", eamEquipment.getFactoryOrgCode())); List userSelectorList=sysUserService.selectOperatorFactoryList(eamEquipment.getEquipmentCode(),baseFactory.getId(), BusinessCodeConst.PCR0008); if (!CollectionUtils.isEmpty(userSelectorList)) { List usernameList=userSelectorList.stream().map(UserSelector::getUsername).collect(Collectors.toList()); flowMyBusiness.setTodoUsers(JSON.toJSONString(usernameList)); flowMyBusinessService.updateById(flowMyBusiness); } }else { eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); } eamMaintenanceStandard.setRepairManager(user.getUsername()); eamMaintenanceStandard.setRepairManagerApproveResult(eamMaintenanceStandardVo.getRepairManagerApproveResult()); eamMaintenanceStandard.setRepairManagerApproveTime(new Date()); eamMaintenanceStandard.setRepairManagerApproveComment(eamMaintenanceStandardVo.getComment()); } if (eamMaintenanceStandardVo.getTechnicalManagerApproveResult() != null) { if (eamMaintenanceStandardVo.getTechnicalManagerApproveResult().equals("1")){ eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.START.name()); //判断是否进行升版,通过设备编号、保养分类、状态进行筛选 EamMaintenanceStandard maintenanceStandard=this.getById(eamMaintenanceStandardVo.getDataId()); QueryWrapper queryWrapper=new QueryWrapper<>(); queryWrapper.eq("equipment_id", maintenanceStandard.getEquipmentId()); queryWrapper.eq("maintenance_category", maintenanceStandard.getMaintenanceCategory()); queryWrapper.eq("standard_status", MaintenanceStandardStatusEnum.START.name()); List list=eamMaintenanceStandardMapper.selectList(queryWrapper); if (!CollectionUtils.isEmpty(list)) { //作废原有 for (EamMaintenanceStandard eamMaintenanceStandard1 : list) { eamMaintenanceStandard1.setStandardStatus(MaintenanceStandardStatusEnum.ABOLISH.name()); this.updateById(eamMaintenanceStandard1); } } }else { eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name()); } eamMaintenanceStandard.setTechnicalManager(user.getUsername()); eamMaintenanceStandard.setTechnicalManagerApproveResult(eamMaintenanceStandardVo.getTechnicalManagerApproveResult()); eamMaintenanceStandard.setTechnicalManagerApproveTime(new Date()); eamMaintenanceStandard.setTechnicalManagerApproveComment(eamMaintenanceStandardVo.getComment()); } this.updateById(eamMaintenanceStandard); } else { return result; } return Result.OK("操作成功"); } catch (Exception e) { return Result.error("操作失败:" + e.getMessage()); } } private Map setProcessVariables(EamMaintenanceStandard eamMaintenanceStandard, String userId, EamMaintenanceStandardVo eamMaintenanceStandardVo) { Map values = new HashMap<>(); values.put("dataId", eamMaintenanceStandard.getId()); values.put("assignee", userId); if (eamMaintenanceStandardVo.getRepairManagerApproveResult() != null) { values.put("repairManagerApproveResult", eamMaintenanceStandardVo.getRepairManagerApproveResult()); values.put("organization", eamMaintenanceStandardVo.getRepairManagerApproveComment()); values.put("comment", eamMaintenanceStandardVo.getRepairManagerApproveComment()); } if (eamMaintenanceStandardVo.getTechnicalManagerApproveResult() != null) { values.put("technicalManagerApproveResult", eamMaintenanceStandardVo.getTechnicalManagerApproveResult()); values.put("organization", eamMaintenanceStandardVo.getTechnicalManagerApproveComment()); values.put("comment", eamMaintenanceStandardVo.getTechnicalManagerApproveComment()); } return values; } @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) { //业务是否干预流程,业务干预,流程干预,指定人员进行处理 return null; } /*流程业务代码--------------------------结束*/ }