From dd890a133f35b4b21ed00ec557ca83f733ff04dc Mon Sep 17 00:00:00 2001
From: lyh <925863403@qq.com>
Date: 星期三, 03 九月 2025 18:03:24 +0800
Subject: [PATCH] 实现二保三保规范一个Word文档中包含多个保养内容（即多个设备）导入
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java | 1321 +++++++++++++++++++++++++++++++++++++++++---------------
1 files changed, 962 insertions(+), 359 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java
index 111e961..f7a0afa 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java
@@ -5,11 +5,13 @@
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.conditions.update.UpdateWrapper;
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.jeecg.weibo.exception.BusinessException;
+import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xwpf.usermodel.*;
@@ -39,6 +41,7 @@
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.domain.vo.FlowTaskVo;
import org.jeecg.modules.flowable.service.IFlowDefinitionService;
import org.jeecg.modules.flowable.service.IFlowTaskService;
import org.jeecg.modules.system.entity.BaseFactory;
@@ -46,6 +49,8 @@
import org.jeecg.modules.system.entity.SysParams;
import org.jeecg.modules.system.service.*;
import org.jeecg.modules.system.vo.UserSelector;
+import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTP;
+import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTTbl;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -67,6 +72,7 @@
* @Version: V1.0
*/
@Service("IEamMaintenanceStandardService")
+@Slf4j
public class EamMaintenanceStandardServiceImpl extends ServiceImpl<EamMaintenanceStandardMapper, EamMaintenanceStandard> implements IEamMaintenanceStandardService, FlowCallBackServiceI {
@Resource
@@ -286,6 +292,7 @@
queryWrapper.eq(EamMaintenanceStandard::getMaintenanceCategory, maintenanceCategory);
queryWrapper.eq(EamMaintenanceStandard::getDelFlag, CommonConstant.DEL_FLAG_0);
queryWrapper.ne(EamMaintenanceStandard::getStandardStatus, standardStatus);
+ queryWrapper.ne(EamMaintenanceStandard::getStandardStatus,MaintenanceStandardStatusEnum.START.name());
queryWrapper.orderByDesc(EamMaintenanceStandard::getStandardVersion);
List<EamMaintenanceStandard> list = eamMaintenanceStandardMapper.selectList(queryWrapper);
@@ -336,195 +343,361 @@
/*娴佺▼涓氬姟浠ｇ爜--------------------------寮�濮�*/
- /**
- * 娴佺▼鍚姩,淇濆瓨瀵瑰簲鐨勬暟鎹�
- *
- * @param id
- * @return
- */
@Override
+ @Transactional(rollbackFor = Exception.class)
public Result<?> saveEamMaintenanceStandardProcess(String id) {
- LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
- EamMaintenanceStandard maintenanceStandard = this.getById(id);
- if (maintenanceStandard == null) {
- return Result.error("鏈壘鍒板搴斾繚鍏绘爣鍑�");
+ // 鑾峰彇褰撳墠鐧诲綍鐢ㄦ埛
+ LoginUser currentUser = getCurrentUser();
+
+ // 鏍￠獙淇濆吇鏍囧噯鏄惁瀛樺湪
+ EamMaintenanceStandard maintenanceStandard = validateStandardExistence(id);
+
+ // 鏍￠獙鍏宠仈璁惧鏄惁瀛樺湪
+ EamEquipment equipment = validateEquipmentExistence(maintenanceStandard.getEquipmentId());
+
+ // 妫�鏌ユ槸鍚︽槸椹冲洖鍚庨噸鏂版彁浜ょ殑娴佺▼
+ FlowMyBusiness flowBusiness = flowMyBusinessService.selectByDataId(maintenanceStandard.getId());
+
+ if (isReSubmitScenario(flowBusiness)) {
+ return handleReSubmitScenario(maintenanceStandard, equipment, currentUser, flowBusiness);
}
- System.out.println("淇濆吇瑙勮寖娴佺▼锛�" + maintenanceStandard.getId());
- flowCommonService.initActBusiness(maintenanceStandard.getStandardName() + "瑙勮寖杩涜娴佺▼瀹℃牳",
- maintenanceStandard.getId(), "IEamMaintenanceStandardService", "eam_maintenance_standard", null);
- Map<String, Object> variables = new HashMap<>();
- variables.put("dataId", maintenanceStandard.getId());
- variables.put("organization", "淇濆吇瑙勮寖鍚姩娴佺▼");
- variables.put("comment", "淇濆吇瑙勮寖鍚姩娴佺▼");
- variables.put("proofreading", true);
- EamEquipment eamEquipment = eamEquipmentService.getById(maintenanceStandard.getEquipmentId());
- List<UserSelector> userSelectorList = sysUserService.selectOperatorList(eamEquipment.getEquipmentCode(), eamEquipment.getFactoryOrgCode(), BusinessCodeConst.PCR0008);
- if (!CollectionUtils.isEmpty(userSelectorList)) {
- List<String> usernameList = userSelectorList.stream().map(UserSelector::getUsername).collect(Collectors.toList());
- if (CollectionUtils.isNotEmpty(usernameList)) {
- variables.put("NextAssignee", usernameList);
- }else {
- throw new JeecgBootException("璁惧鏈瓨鍦ㄧ淮淇涓讳换锛屾棤娉曡繘鍏ヤ笅绾у鎵癸紒");
- }
+
+ // 澶勭悊棣栨鍚姩娴佺▼
+ return handleFirstSubmitScenario(maintenanceStandard, equipment, currentUser);
+ }
+
+ /**
+ * 鍒ゆ柇鏄惁鏄┏鍥炲悗閲嶆柊鎻愪氦鐨勫満鏅�
+ */
+ private boolean isReSubmitScenario(FlowMyBusiness flowBusiness) {
+ return flowBusiness != null &&
+ MaintenanceStandardStatusEnum.WAIT_SUBMIT.name().equals(flowBusiness.getTaskNameId());
+ }
+
+ /**
+ * 澶勭悊椹冲洖鍚庨噸鏂版彁浜ょ殑娴佺▼
+ */
+ private Result<?> handleReSubmitScenario(EamMaintenanceStandard maintenanceStandard,
+ EamEquipment equipment,
+ LoginUser currentUser,
+ FlowMyBusiness flowBusiness) {
+ // 鏇存柊寰呭姙缁翠慨宸�
+ updateTodoMaintenanceWorkers(flowBusiness, equipment);
+
+ // 璁ら浠诲姟
+ claimTaskOrFail(flowBusiness.getTaskId(), currentUser);
+
+ // 鏋勫缓娴佺▼鍙橀噺
+ Map<String, Object> variables = buildProcessVariables(maintenanceStandard.getId(), "淇濆吇瑙勮寖鍐嶆鍚姩娴佺▼");
+
+ // 璁剧疆涓嬩竴绾у鎵逛汉(缁翠慨瀹や富浠�)
+ setNextApprover(variables, equipment, BusinessCodeConst.PCR0008, "缁翠慨瀹や富浠�");
+
+ // 瀹屾垚褰撳墠浠诲姟锛屾帹杩涙祦绋�
+ FlowTaskVo taskVo = buildFlowTaskVo(flowBusiness, maintenanceStandard, variables, "淇濆吇瑙勮寖鍐嶆鍚姩娴佺▼");
+ Result result = flowTaskService.complete(taskVo);
+
+ // 鏇存柊淇濆吇鏍囧噯鐘舵��
+ if (result.isSuccess()) {
+ updateMaintenanceStandardStatus(maintenanceStandard, currentUser, MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR);
+ return Result.ok("淇濆吇瑙勮寖娴佺▼閲嶅惎鎴愬姛");
}
- 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鐨勬祦绋嬪疄渚媔d,璁剧疆涓嬩竴姝ョ殑澶勭悊浜哄憳
- List<FlowMyBusiness> businessList = flowMyBusinessService.list(
- new QueryWrapper<FlowMyBusiness>()
- .eq("data_id", maintenanceStandard.getId())
- );
- if (businessList.isEmpty()) {
- return Result.error("娴佺▼璁板綍涓嶅瓨鍦�");
- }
- }
+
return result;
}
/**
- * 瀹℃壒鎿嶄綔
- *
- * @param eamMaintenanceStandardVo
- * @return
+ * 澶勭悊棣栨鎻愪氦鐨勬祦绋�
+ */
+ private Result<?> handleFirstSubmitScenario(EamMaintenanceStandard maintenanceStandard,
+ EamEquipment equipment,
+ LoginUser currentUser) {
+ // 鍒濆鍖栨祦绋嬩笟鍔′俊鎭�
+ flowCommonService.initActBusiness(
+ maintenanceStandard.getStandardName() + "瑙勮寖杩涜娴佺▼瀹℃牳",
+ maintenanceStandard.getId(),
+ "IEamMaintenanceStandardService",
+ "eam_maintenance_standard",
+ null
+ );
+
+ // 鏋勫缓娴佺▼鍙橀噺
+ Map<String, Object> variables = buildProcessVariables(maintenanceStandard.getId(), "淇濆吇瑙勮寖鍚姩娴佺▼");
+
+ // 璁剧疆涓嬩竴绾у鎵逛汉(缁翠慨瀹や富浠�)
+ setNextApprover(variables, equipment, BusinessCodeConst.PCR0008, "缁翠慨瀹や富浠�");
+
+ // 鍚姩娴佺▼瀹炰緥
+ Result result = flowDefinitionService.startProcessInstanceByKey("eam_maintenance_standard", variables);
+
+ // 澶勭悊娴佺▼鍚姩缁撴灉
+ if (result.isSuccess()) {
+ updateMaintenanceStandardStatus(maintenanceStandard, currentUser, MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR);
+ validateFlowBusinessRecord(maintenanceStandard.getId());
+ } else {
+ this.removeById(maintenanceStandard.getId());
+ }
+
+ return result;
+ }
+
+ /**
+ * 瀹℃壒鎿嶄綔
*/
@Override
@Transactional(rollbackFor = Exception.class)
- 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("鏈壘鍒板搴旂敤鎴�");
- }
+ public Result<?> auditEamMaintenanceStandard(EamMaintenanceStandardVo vo) {
+ // 鍩虹鏍￠獙
+ EamMaintenanceStandard standard = validateStandardExistence(vo.getDataId());
+ LoginUser user = getCurrentUser();
+ FlowMyBusiness business = validateFlowBusiness(vo);
+ validateUserAuthorization(business, user);
+ claimTaskOrFail(business.getTaskId(), user);
- // 鏁版嵁鏌ヨ
- EamMaintenanceStandard eamMaintenanceStandard = this.getById(eamMaintenanceStandardVo.getDataId());
- if (eamMaintenanceStandard == null) {
- return Result.error("鏈壘鍒板搴斾繚鍏绘爣鍑�");
- }
+ // 鍑嗗瀹℃壒鎵�闇�鏁版嵁
+ EamEquipment equipment = validateEquipmentExistence(standard.getEquipmentId());
+ Map<String, Object> variables = new HashMap<>();
- // 2. 鏌ヨ娴佺▼涓氬姟璁板綍锛堝鐞嗙┖缁撴灉锛�
- List<FlowMyBusiness> businessList = flowMyBusinessService.list(
- new QueryWrapper<FlowMyBusiness>()
- .eq("process_instance_id", eamMaintenanceStandardVo.getInstanceId())
- );
- if (businessList.isEmpty()) {
- return Result.error("娴佺▼璁板綍涓嶅瓨鍦�");
- }
- FlowMyBusiness flowMyBusiness = businessList.get(0);
+ // 鏍规嵁褰撳墠鐘舵�佸鐞嗗鎵�
+ MaintenanceStandardStatusEnum status = MaintenanceStandardStatusEnum.getInstance(standard.getStandardStatus());
+ if (status == null) {
+ throw new JeecgBootException("鏃犳晥鐨勪繚鍏绘爣鍑嗙姸鎬�");
+ }
- // 3. 鏍￠獙鐢ㄦ埛鏄惁涓哄�欓�夊鐞嗕汉
- List<String> todoUsers = JSON.parseArray(flowMyBusiness.getTodoUsers(), String.class);
- if (todoUsers == null || !todoUsers.contains(user.getUsername())) {
- return Result.error("鐢ㄦ埛鏃犳潈鎿嶄綔姝や换鍔�");
- }
+ switch (status) {
+ case WAIT_REPAIR_DIRECTOR:
+ handleRepairDirectorApproval(vo, standard, equipment, variables);
+ break;
+ case WAIT_TECHNICAL_DIRECTOR:
+ handleTechnicalDirectorApproval(vo, standard, equipment, variables);
+ break;
+ default:
+ throw new JeecgBootException("褰撳墠鐘舵�佷笉鏀寔瀹℃壒鎿嶄綔");
+ }
- // 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());
+ // 鎻愪氦瀹℃壒缁撴灉
+ submitApprovalResult(vo, standard, variables);
+ return Result.OK("鎿嶄綔鎴愬姛");
+ }
- // 璁剧疆娴佺▼鍙橀噺
- Map<String, Object> 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 ("2".equals(eamMaintenanceStandard.getRepairManagerApproveResult())) {
- eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.REJECTED.name());
- }
- if (eamMaintenanceStandardVo.getRepairManagerApproveResult().equals("1")) {
- eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name());
- } 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 ("2".equals(eamMaintenanceStandard.getTechnicalManagerApproveResult())) {
- eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.REJECTED.name());
- }
- if (eamMaintenanceStandardVo.getTechnicalManagerApproveResult().equals("1")) {
- eamMaintenanceStandard.setStandardStatus(MaintenanceStandardStatusEnum.START.name());
- //鍒ゆ柇鏄惁杩涜鍗囩増锛岄�氳繃璁惧缂栧彿銆佷繚鍏诲垎绫汇�佺姸鎬佽繘琛岀瓫閫�
- EamMaintenanceStandard maintenanceStandard = this.getById(eamMaintenanceStandardVo.getDataId());
- QueryWrapper<EamMaintenanceStandard> queryWrapper = new QueryWrapper<>();
- queryWrapper.eq("equipment_id", maintenanceStandard.getEquipmentId());
- queryWrapper.eq("maintenance_category", maintenanceStandard.getMaintenanceCategory());
- queryWrapper.eq("standard_status", MaintenanceStandardStatusEnum.START.name());
- List<EamMaintenanceStandard> 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 LoginUser getCurrentUser() {
+ LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
+ if (user == null) {
+ throw new JeecgBootException("鏈幏鍙栧埌鐧诲綍鐢ㄦ埛锛岃閲嶆柊鐧诲綍鍚庡啀璇曪紒");
+ }
+ return user;
+ }
+
+ private EamMaintenanceStandard validateStandardExistence(String id) {
+ EamMaintenanceStandard standard = this.getById(id);
+ if (standard == null) {
+ throw new JeecgBootException("鏈壘鍒板搴斾繚鍏绘爣鍑�");
+ }
+ return standard;
+ }
+
+ private EamEquipment validateEquipmentExistence(String equipmentId) {
+ EamEquipment equipment = eamEquipmentService.getById(equipmentId);
+ if (equipment == null) {
+ throw new JeecgBootException("鍏宠仈璁惧涓嶅瓨鍦�");
+ }
+ return equipment;
+ }
+
+ private FlowMyBusiness validateFlowBusiness(EamMaintenanceStandardVo vo) {
+ FlowMyBusiness business = flowMyBusinessService.getFlowMyBusiness(vo.getInstanceId(), vo.getTaskId());
+ if (business == null) {
+ throw new JeecgBootException("娴佺▼瀹炰緥涓嶅瓨鍦紝璇峰埛鏂伴噸璇�");
+ }
+ return business;
+ }
+
+ private void validateUserAuthorization(FlowMyBusiness business, LoginUser user) {
+ List<String> todoUsers = JSON.parseArray(business.getTodoUsers(), String.class);
+ if (todoUsers == null || !todoUsers.contains(user.getUsername())) {
+ throw new JeecgBootException("鐢ㄦ埛鏃犳潈鎿嶄綔姝や换鍔�");
}
}
- private Map<String, Object> setProcessVariables(EamMaintenanceStandard eamMaintenanceStandard, String userId, EamMaintenanceStandardVo eamMaintenanceStandardVo) {
- Map<String, Object> 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());
+ private void claimTaskOrFail(String taskId, LoginUser user) {
+ Task task = taskService.createTaskQuery().taskId(taskId).singleResult();
+ if (task == null) {
+ throw new JeecgBootException("浠诲姟涓嶅瓨鍦ㄦ垨宸插畬鎴�");
}
- if (eamMaintenanceStandardVo.getTechnicalManagerApproveResult() != null) {
- values.put("technicalManagerApproveResult", eamMaintenanceStandardVo.getTechnicalManagerApproveResult());
- values.put("organization", eamMaintenanceStandardVo.getTechnicalManagerApproveComment());
- values.put("comment", eamMaintenanceStandardVo.getTechnicalManagerApproveComment());
+ if (task.getAssignee() != null && !task.getAssignee().equals(user.getUsername())) {
+ throw new JeecgBootException("浠诲姟宸茶浠栦汉璁ら");
}
- List<UserSelector> userSelectorList=new ArrayList<>();
- if (eamMaintenanceStandardVo.getRepairManagerApproveResult() != null) {
- //鑾峰彇flow鐨勬祦绋嬪疄渚媔d,璁剧疆涓嬩竴姝ョ殑澶勭悊浜哄憳
- EamMaintenanceStandard maintenanceStandard = this.getById(eamMaintenanceStandardVo.getDataId());
- EamEquipment eamEquipment = eamEquipmentService.getById(maintenanceStandard.getEquipmentId());
- userSelectorList = sysUserService.selectOperatorList(eamEquipment.getEquipmentCode(), eamEquipment.getFactoryOrgCode(), BusinessCodeConst.PCR0009);
- if (CollectionUtils.isEmpty(userSelectorList)) {
- throw new JeecgBootException("璁惧鏈瓨鍦ㄧ鐞嗗憳锛屾棤娉曡繘鍏ヤ笅绾у鎵癸紒");
- }
+ taskService.claim(taskId, user.getUsername());
+ }
+
+ private Map<String, Object> buildProcessVariables(String dataId, String comment) {
+ Map<String, Object> vars = new HashMap<>();
+ vars.put("dataId", dataId);
+ vars.put("organization", comment);
+ vars.put("comment", comment);
+ vars.put("proofreading", true);
+ return vars;
+ }
+
+ private void setNextApprover(Map<String, Object> variables, EamEquipment equipment,
+ String businessCode, String roleName) {
+ List<UserSelector> approvers = sysUserService.selectOperatorList(
+ equipment.getEquipmentCode(),
+ equipment.getFactoryOrgCode(),
+ businessCode
+ );
+ if (CollectionUtils.isEmpty(approvers)) {
+ throw new JeecgBootException("璁惧鏈厤缃�" + roleName);
}
- return values;
+ variables.put("NextAssignee", approvers.stream()
+ .map(UserSelector::getUsername)
+ .collect(Collectors.toList()));
+ }
+
+ private void updateTodoMaintenanceWorkers(FlowMyBusiness business, EamEquipment equipment) {
+ List<UserSelector> maintenanceWorkers = sysUserService.selectOperatorList(
+ equipment.getEquipmentCode(),
+ equipment.getFactoryOrgCode(),
+ BusinessCodeConst.PCR0002
+ );
+ if (CollectionUtils.isEmpty(maintenanceWorkers)) {
+ throw new JeecgBootException("璁惧鏈厤缃淮淇伐");
+ }
+ business.setTodoUsers(JSON.toJSONString(
+ maintenanceWorkers.stream()
+ .map(UserSelector::getUsername)
+ .collect(Collectors.toList())
+ ));
+ flowMyBusinessService.updateById(business);
+ }
+
+ private FlowTaskVo buildFlowTaskVo(FlowMyBusiness business, EamMaintenanceStandard standard,
+ Map<String, Object> variables, String comment) {
+ FlowTaskVo taskVo = new FlowTaskVo();
+ taskVo.setTaskId(business.getTaskId());
+ taskVo.setComment(comment);
+ taskVo.setInstanceId(business.getProcessInstanceId());
+ taskVo.setDataId(standard.getId());
+ taskVo.setValues(variables);
+ return taskVo;
+ }
+
+ private void updateMaintenanceStandardStatus(EamMaintenanceStandard standard,
+ LoginUser user,
+ MaintenanceStandardStatusEnum status) {
+ standard.setStandardStatus(status.name());
+ if (MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR.equals(status)) {
+ standard.setDesigner(user.getUsername());
+ standard.setDesignTime(new Date());
+ }
+ this.updateById(standard);
+ }
+
+ private void validateFlowBusinessRecord(String standardId) {
+ List<FlowMyBusiness> businessList = flowMyBusinessService.list(
+ new QueryWrapper<FlowMyBusiness>().eq("data_id", standardId)
+ );
+ if (CollectionUtils.isEmpty(businessList)) {
+ throw new JeecgBootException("娴佺▼璁板綍涓嶅瓨鍦�");
+ }
+ }
+
+ private void handleRepairDirectorApproval(EamMaintenanceStandardVo vo,
+ EamMaintenanceStandard standard,
+ EamEquipment equipment,
+ Map<String, Object> variables) {
+ // 璁剧疆鍩虹娴佺▼鍙橀噺
+ variables.putAll(buildProcessVariables(standard.getId(),
+ StrUtil.blankToDefault(vo.getRepairManagerApproveComment(), "")));
+ variables.put("repairManagerApproveResult", vo.getRepairManagerApproveResult());
+
+ LoginUser user = getCurrentUser();
+ vo.setAssignee(user.getUsername());
+ vo.setComment(vo.getRepairManagerApproveComment());
+ if ("2".equals(vo.getRepairManagerApproveResult())) {
+ // 椹冲洖
+ UpdateWrapper<EamMaintenanceStandard> updateWrapper = new UpdateWrapper<>();
+ updateWrapper.eq("id", standard.getId());
+ updateWrapper.set("standard_status", MaintenanceStandardStatusEnum.WAIT_SUBMIT.name());
+ updateWrapper.set("designer", null);
+ updateWrapper.set("design_time", null);
+ this.update(updateWrapper);
+ } else {
+ // 閫氳繃
+ setNextApprover(variables, equipment, BusinessCodeConst.PCR0009, "鐢熶骇璁惧鎶�鏈富绠�");
+ standard.setRepairManager(user.getUsername());
+ standard.setRepairManagerApproveResult(vo.getRepairManagerApproveResult());
+ standard.setRepairManagerApproveTime(new Date());
+ standard.setRepairManagerApproveComment(vo.getRepairManagerApproveComment());
+ standard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name());
+ }
+ }
+
+ private void handleTechnicalDirectorApproval(EamMaintenanceStandardVo vo,
+ EamMaintenanceStandard standard,
+ EamEquipment equipment,
+ Map<String, Object> variables) {
+ // 璁剧疆鍩虹娴佺▼鍙橀噺
+ variables.putAll(buildProcessVariables(standard.getId(),
+ StrUtil.blankToDefault(vo.getTechnicalManagerApproveComment(), "")));
+ variables.put("technicalManagerApproveResult", vo.getTechnicalManagerApproveResult());
+
+ LoginUser user = getCurrentUser();
+ vo.setAssignee(user.getUsername());
+ vo.setComment(vo.getTechnicalManagerApproveComment());
+ if ("2".equals(vo.getTechnicalManagerApproveResult())) {
+ // 椹冲洖
+ standard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR.name());
+ standard.setRepairManager(null);
+ standard.setRepairManagerApproveResult(null);
+ standard.setRepairManagerApproveTime(null);
+ standard.setRepairManagerApproveComment(null);
+ setNextApprover(variables, equipment, BusinessCodeConst.PCR0008, "缁翠慨瀹や富浠�");
+ } else {
+ // 閫氳繃
+ standard.setTechnicalManager(user.getUsername());
+ standard.setTechnicalManagerApproveResult(vo.getTechnicalManagerApproveResult());
+ standard.setTechnicalManagerApproveTime(new Date());
+ standard.setTechnicalManagerApproveComment(vo.getTechnicalManagerApproveComment());
+ standard.setStandardStatus(MaintenanceStandardStatusEnum.START.name());
+ }
+ }
+
+ private void submitApprovalResult(EamMaintenanceStandardVo vo,
+ EamMaintenanceStandard standard,
+ Map<String, Object> variables) {
+ vo.setValues(variables);
+ Result result = flowTaskService.complete(vo);
+ if (!result.isSuccess()) {
+ throw new JeecgBootException("瀹℃壒娴佺▼鎻愪氦澶辫触: " + result.getMessage());
+ }
+
+ // 鏇存柊淇濆吇鏍囧噯
+ this.updateById(standard);
+
+ // 鎶�鏈富绠″鎵归�氳繃鍚庯紝浣滃簾鏃х増鏈�
+ if (MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name().equals(standard.getStandardStatus())
+ && "1".equals(vo.getTechnicalManagerApproveResult())) {
+ abolishPreviousStandards(standard);
+ }
+ }
+
+ private void abolishPreviousStandards(EamMaintenanceStandard current) {
+ List<EamMaintenanceStandard> previous = eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>()
+ .ne("id", current.getId())
+ .eq("equipment_id", current.getEquipmentId())
+ .eq("maintenance_category", current.getMaintenanceCategory())
+ .eq("standard_status", MaintenanceStandardStatusEnum.START.name())
+ );
+
+ if (!CollectionUtils.isEmpty(previous)) {
+ previous.forEach(standard -> {
+ standard.setStandardStatus(MaintenanceStandardStatusEnum.ABOLISH.name());
+ });
+ this.updateBatchById(previous);
+ }
}
@@ -562,7 +735,11 @@
*/
@Override
@Transactional(rollbackFor = Exception.class)
- public Result<?> importPointInspectionExcel(MultipartFile file) {
+ public Result<?> importPointInspectionExcel(MultipartFile file,String id) {
+ EamMaintenanceStandard eamMaintenanceStandardOld=new EamMaintenanceStandard();
+ if (StrUtil.isNotEmpty(id)){
+ eamMaintenanceStandardOld=eamMaintenanceStandardMapper.selectById(id);
+ }
try (Workbook workbook = WorkbookFactory.create(file.getInputStream())) {
Sheet sheet = workbook.getSheetAt(0);
@@ -577,11 +754,56 @@
eamMaintenanceStandard.setStandardName(name);
- // 妫�鏌ラ噸澶�
- EamMaintenanceStandard exist = checkDuplicate(eamMaintenanceStandard.getEquipmentId(),
- eamMaintenanceStandard.getMaintenanceCategory(), MaintenanceStandardStatusEnum.ABOLISH.name());
- if (exist != null) {
- return Result.error(name + ": 璁惧鏍囧噯宸插瓨鍦紝涓嶈兘閲嶅娣诲姞");
+ // 妫�鏌ラ噸澶�,鍙鍏ユ牎楠岋紝鍗囩増涓嶆牎楠�
+ if (StrUtil.isEmpty(id)){
+ EamMaintenanceStandard exist = checkDuplicate(eamMaintenanceStandard.getEquipmentId(),
+ eamMaintenanceStandard.getMaintenanceCategory(), MaintenanceStandardStatusEnum.ABOLISH.name());
+ if (exist != null) {
+ return Result.error(name + ": 璁惧鏍囧噯宸插瓨鍦紝涓嶈兘閲嶅娣诲姞");
+ }
+ }
+ if (StrUtil.isNotEmpty(id)){
+ if (eamMaintenanceStandardOld.getEquipmentId().equals(eamMaintenanceStandard.getEquipmentId())
+ &&eamMaintenanceStandardOld.getMaintenanceCategory().equals(eamMaintenanceStandard.getMaintenanceCategory())) {
+ //鍒ゆ柇鏄惁鐜版湁寰呮彁浜ゆ暟鎹�
+ EamMaintenanceStandard maintenanceStandard=eamMaintenanceStandardMapper.selectOne(
+ new QueryWrapper<EamMaintenanceStandard>().eq("equipment_id",eamMaintenanceStandard.getEquipmentId())
+ .eq("maintenance_category",eamMaintenanceStandard.getMaintenanceCategory())
+ .eq("standard_status",MaintenanceStandardStatusEnum.WAIT_SUBMIT.name())
+ .eq("del_flag", CommonConstant.DEL_FLAG_0));
+ if (maintenanceStandard != null) {
+ //鍒犻櫎鍘熸湁寰呮彁浜�
+ eamMaintenanceStandardMapper.deleteById(maintenanceStandard.getId());
+ }
+ //鏌ヨ鍦ㄦ祦绋嬩腑鐨勬暟鎹�
+ List<EamMaintenanceStandard> eamMaintenanceStandardList=eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>().eq("equipment_id",eamMaintenanceStandard.getEquipmentId())
+ .eq("maintenance_category",eamMaintenanceStandard.getMaintenanceCategory())
+ .eq("del_flag", CommonConstant.DEL_FLAG_0)
+ .and(i->i.
+ eq("standard_status",MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR.name())
+ .or()
+ .eq("standard_status",MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name())
+ ));
+ if (!eamMaintenanceStandardList.isEmpty()) {
+ return Result.error("宸插瓨鍦ㄥ浜庡鎵规祦绋嬬殑鏁版嵁锛岃鍒犻櫎鎴栫粨鏉熷悗杩涜鍗囩増瀵煎叆鎿嶄綔");
+ }
+ //鍗囩増鎿嶄綔锛屼綔搴熷師鏈�
+ eamMaintenanceStandardOld.setStandardStatus(MaintenanceStandardStatusEnum.ABOLISH.name());
+ eamMaintenanceStandardMapper.updateById(eamMaintenanceStandardOld);
+ //鐗堟湰閫掑鑾峰彇鏁板瓧
+ Pattern pattern = Pattern.compile("(\\d+)(?:\\.\\d+)*$");
+ Matcher matcher = pattern.matcher(eamMaintenanceStandardOld.getStandardVersion());
+ if (matcher.find()) {
+ try {
+ int mainVersion = Integer.parseInt(matcher.group(1));
+ eamMaintenanceStandard.setStandardVersion("v" + (mainVersion + 1));
+ } catch (NumberFormatException ignored) {
+ }
+ }
+ }else {
+ return Result.error("鍗囩増瀵煎叆鐨勬枃浠朵笌鍘熸湁鏁版嵁鐨勮澶囩紪鍙蜂笉涓�鑷�,璇烽噸鏂扮紪杈戝鍏ユ枃浠�");
+ }
}
eamMaintenanceStandard.setInitialDate(new Date());
eamMaintenanceStandardMapper.insert(eamMaintenanceStandard);
@@ -1083,157 +1305,581 @@
}
/*瀵煎叆鐐规鏂囦欢Excel--------------------------缁撴潫*/
- /*瀵煎叆浜屼繚涓変繚鏂囦欢Excel--------------------------寮�濮�*/
-
+ /*瀵煎叆浜屼繚涓変繚鏂囦欢Word--------------------------寮�濮�*/
/**
- * 缁熶竴淇濆吇瑙勮寖瀵煎叆鍏ュ彛
- *
* @param file 涓婁紶鏂囦欢
* @param type 淇濆吇绫诲瀷 (SECOND/THIRD)
* @return 瀵煎叆缁撴灉锛堝寘鍚垚鍔�/澶辫触淇℃伅锛�
*/
@Override
@Transactional
- public Result<?> importMaintenanceStandard(MultipartFile file, String type) {
+ public Result<?> importMaintenanceStandard(MultipartFile file, String type, String id) {
String fileName = file.getOriginalFilename();
-
try (XWPFDocument doc = new XWPFDocument(file.getInputStream())) {
- // 鑾峰彇鏂囨。鏍囬锛堢涓�涓潪绌烘钀斤級
- String documentTitle = null;
- for (XWPFParagraph p : doc.getParagraphs()) {
- String text = p.getText();
- if (text != null && !text.trim().isEmpty()) {
- documentTitle = text.trim();
- break; // 鎵惧埌绗竴涓潪绌烘钀藉嵆閫�鍑�
- }
- }
-
- // 鍩虹楠岃瘉
- if (doc.getTables().isEmpty()) {
- return Result.error(fileName + ": 鏂囨。涓湭鎵惧埌琛ㄦ牸");
- }
-
- // 鍩虹楠岃瘉
- if (doc.getTables().isEmpty()) {
- return Result.error(fileName + ": 鏂囨。涓湭鎵惧埌琛ㄦ牸");
- }
-
List<XWPFTable> tables = doc.getTables();
- EamMaintenanceStandard standard = null;
- List<EamMaintenanceStandardDetail> items = new ArrayList<>();
- String standardId = null;
+ List<EamMaintenanceStandard> standards = new ArrayList<>();
+ List<EamMaintenanceStandardDetail> allItems = new ArrayList<>();
+ int deviceCount = 0;
+ boolean isRevision = StrUtil.isNotEmpty(id);
+ EamMaintenanceStandard oldStandardForRevision = null;
+ Map<String, Integer> deviceVersionMap = new HashMap<>();
+ Map<String, Integer> compositeVersionMap = new HashMap<>();
- // 1. 澶勭悊鎵�鏈夎〃鏍�
- for (int i = 0; i < tables.size(); i++) {
+ // 鑾峰彇鏂囨。涓殑鎵�鏈夋钀�
+ List<XWPFParagraph> paragraphs = doc.getParagraphs();
+
+ // 濡傛灉鏄崌鐗堝鍏ワ紝鑾峰彇鍘熸湁鏍囧噯
+ if (isRevision) {
+ oldStandardForRevision = eamMaintenanceStandardMapper.selectById(id);
+ if (oldStandardForRevision == null) {
+ return Result.error("鍗囩増瀵煎叆澶辫触锛氭湭鎵惧埌ID涓�" + id + "鐨勮澶囨爣鍑�");
+ }
+ // 棰勫姞杞借澶囩増鏈俊鎭紙浣跨敤澶嶅悎閿級
+ loadDeviceMaxVersions(oldStandardForRevision.getEquipmentId(), compositeVersionMap);
+ } else {
+ // 闈炲崌鐗堝鍏ユ椂锛岄鍔犺浇鎵�鏈夎澶囩殑鏈�澶х増鏈紙浣跨敤澶嶅悎閿級
+ loadAllDeviceMaxVersions(compositeVersionMap);
+ }
+
+ // 澶氳澶囧鐞嗕富寰幆
+ for (int i = 0; i < tables.size(); ) {
XWPFTable table = tables.get(i);
- if (i == 0) { // 绗竴椤佃〃鏍�
- // 楠岃瘉璁惧淇℃伅琛ㄦ牸
- if (isWrongDocumentType(table, type)) {
- return Result.error(fileName + ": 鏂囨。绫诲瀷涓嶅尮閰� - " +
- ("SECOND".equals(type) ? "璇峰鍏ヤ簩绾т繚鍏绘枃妗�" : "璇峰鍏ヤ笁绾т繚鍏绘枃妗�"));
+ // 璇嗗埆璁惧淇℃伅琛ㄦ牸
+ if (isDeviceInfoTable(table)) {
+ deviceCount++;
+
+ // 鍗囩増瀵煎叆鍙兘澶勭悊鍗曡澶�
+ if (isRevision && deviceCount > 1) {
+ throw new ImportException("鍗囩増瀵煎叆浠呮敮鎸佸崟璁惧鏂囨。");
}
// 鎻愬彇璁惧淇℃伅
- standard = extractDeviceInfo(table, type);
+ EamMaintenanceStandard standard = extractDeviceInfo(table, type);
if (standard == null) {
- return Result.error(fileName + ": 璁惧淇℃伅鎻愬彇澶辫触");
+ throw new ImportException("琛ㄦ牸" + (i+1) + "锛氳澶囦俊鎭彁鍙栧け璐�");
}
- // 閰嶇疆绫诲瀷鐩稿叧鍙傛暟
- configureStandard(standard, type, file);
- EamMaintenanceStandard exist = checkDuplicate(standard.getEquipmentId(), standard.getMaintenanceCategory(), MaintenanceStandardStatusEnum.ABOLISH.name());
- if (exist != null) {
- return Result.error(fileName + ": 璁惧鏍囧噯宸插瓨鍦紝涓嶈兘閲嶅娣诲姞");
+ // 浠庢枃妗ｄ腑鑾峰彇鏍囬锛堣〃鏍煎墠鐨勬钀斤級
+ String title = extractTitleBeforeTable(table, paragraphs);
+ if (title != null) {
+ standard.setStandardName(title);
}
- standard.setStandardName(documentTitle);
+
+ // 澶勭悊閲嶅鍜屽崌鐗堥�昏緫
+ processStandard(standard, type, file, id, oldStandardForRevision, compositeVersionMap);
+
+ // 淇濆瓨璁惧鏍囧噯
eamMaintenanceStandardMapper.insert(standard);
- standardId = standard.getId();
+ standards.add(standard);
- // 鎻愬彇绗竴椤电殑淇濆吇椤圭洰
+ // 鏇存柊璁惧鐗堟湰鏄犲皠
+ updateDeviceVersionMap(deviceVersionMap, standard);
+
+ // 鎻愬彇褰撳墠璁惧淇℃伅琛ㄦ牸涓殑淇濆吇椤圭洰
+ List<EamMaintenanceStandardDetail> items = new ArrayList<>();
if ("SECOND".equals(type)) {
- items.addAll(extractSecondMaintenanceItems(table, standardId, true));
- } else if ("THIRD".equals(type)) {
- items.addAll(extractThirdMaintenanceItems(table, standardId, true));
+ items.addAll(extractSecondMaintenanceItems(table, standard.getId(), true));
+ } else {
+ items.addAll(extractThirdMaintenanceItems(table, standard.getId(), true));
}
- } else { // 鍚庣画椤甸潰
- // 鎻愬彇鍚庣画椤甸潰鐨勪繚鍏婚」鐩�
- if ("SECOND".equals(type)) {
- items.addAll(extractSecondMaintenanceItems(table, standardId, false));
- } else if ("THIRD".equals(type)) {
- items.addAll(extractThirdMaintenanceItems(table, standardId, false));
+ // 鎻愬彇鍚庣画鍏宠仈鐨勪繚鍏婚」鐩〃鏍�
+ i++; // 绉诲姩鍒颁笅涓�涓〃鏍�
+ while (i < tables.size() && !isDeviceInfoTable(tables.get(i))) {
+ XWPFTable itemTable = tables.get(i);
+ if ("SECOND".equals(type)) {
+ items.addAll(extractSecondMaintenanceItems(itemTable, standard.getId(), false));
+ } else {
+ items.addAll(extractThirdMaintenanceItems(itemTable, standard.getId(), false));
+ }
+ i++;
}
+
+ // 椤圭洰鍚庡鐞�
+ processItemsAfterExtraction(items, type);
+ allItems.addAll(items);
+
+ // 濡傛灉鏄渶鍚庝竴涓〃鏍硷紝闇�瑕侀��鍑哄惊鐜�
+ if (i >= tables.size()) break;
+ } else {
+ i++; // 濡傛灉涓嶆槸璁惧淇℃伅琛ㄦ牸锛岀户缁笅涓�涓�
}
}
- // 楠岃瘉璁惧淇℃伅鎻愬彇
- if (standard == null) {
- return Result.error(fileName + ": 璁惧淇℃伅鎻愬彇澶辫触");
+ // 鏍￠獙璁惧鏁伴噺
+ if (standards.isEmpty()) {
+ return Result.error(fileName + "锛氭湭鎵惧埌鏈夋晥鐨勮澶囦俊鎭〃鏍�");
}
- // 2. 鍚庡鐞嗭細鏍规嵁涓嶅悓绫诲瀷杩涜澶勭悊
- processItemsAfterExtraction(items, type);
-
- // 3. 椤圭洰楠岃瘉
- if (items.isEmpty()) {
- return Result.error(fileName + ": 鏈彁鍙栧埌浠讳綍淇濆吇椤圭洰");
+ // 鎵归噺淇濆瓨淇濆吇椤圭洰
+ if (!allItems.isEmpty()) {
+ eamMaintenanceStandardDetailService.saveBatch(allItems);
}
- // 4. 淇濆瓨椤圭洰
- eamMaintenanceStandardDetailService.saveBatch(items);
-
-
+ // 鏇存柊娴佺▼鐘舵��
SysParams sysParams = sysParamsService.getSysPramBySettingKey("maintenance_import_type");
-
- if (sysParams != null) {
- if (sysParams.getSettingValue().equals("1")) {
+ if (sysParams != null && "1".equals(sysParams.getSettingValue())) {
+ for (EamMaintenanceStandard standard : standards) {
standard.setStandardStatus(MaintenanceStandardStatusEnum.WAIT_SUBMIT.name());
eamMaintenanceStandardMapper.updateById(standard);
}
- } else {
- return Result.error("鏈壘鍒颁繚鍏绘祦绋嬪鍏ョ浉鍏抽厤缃�,璇疯仈绯荤鐞嗗憳");
+ } else if (sysParams == null) {
+ throw new ImportException("鏈厤缃繚鍏绘祦绋嬪鍏ュ弬鏁�");
}
- return Result.ok(fileName + ": 瀵煎叆鎴愬姛, 椤圭洰鏁�: " + items.size());
+ // 浣滃簾鏃х増鏈紙淇濈暀鏈�鏂扮増鏈級
+ obsoleteOldVersionsByCompositeKey(deviceVersionMap);
+
+ return Result.ok(fileName + "瀵煎叆鎴愬姛锛岃澶囨暟锛�" + standards.size() + "锛岄」鐩暟锛�" + allItems.size());
} catch (ImportException e) {
- return Result.error(e.getMessage());
+ return Result.error(fileName + "锛�" + e.getMessage());
} catch (Exception e) {
- return Result.error(fileName + ": 绯荤粺閿欒 - " + e.getClass().getSimpleName());
+ log.error("瀵煎叆淇濆吇瑙勮寖澶辫触", e);
+ return Result.error(fileName + "锛氱郴缁熼敊璇� - " + e.getMessage());
}
}
+ // 璁惧淇℃伅琛ㄦ牸璇嗗埆鏂规硶
+ private boolean isDeviceInfoTable(XWPFTable table) {
+ if (table.getNumberOfRows() < 2) return false;
+
+ // 妫�鏌ュ墠涓よ鏄惁鍖呭惈璁惧淇℃伅鐗瑰緛
+ String row1 = getRowText(table.getRow(0));
+ String row2 = getRowText(table.getRow(1));
+ List<String> keywords = Arrays.asList("璁惧绫诲埆", "璁惧缂栧彿", "璁惧鍚嶇О", "璁惧鍨嬪彿");
+ int matchCount = 0;
+
+ for (String keyword : keywords) {
+ if (row1.contains(keyword) || row2.contains(keyword)) {
+ matchCount++;
+ }
+ }
+ return matchCount >= 2; // 鑷冲皯鍖归厤涓や釜鍏抽敭璇�
+ }
+
+ // 鑾峰彇琛ㄦ牸琛岀殑鏂囨湰鍐呭
+ private String getRowText(XWPFTableRow row) {
+ if (row == null) return "";
+ StringBuilder sb = new StringBuilder();
+ for (XWPFTableCell cell : row.getTableCells()) {
+ sb.append(getCellText(cell));
+ }
+ return sb.toString();
+ }
+
+
/**
- * 鍚庡鐞嗘柟娉曪細鏍规嵁涓嶅悓绫诲瀷杩涜澶勭悊
+ * 浠庤〃鏍煎墠鐨勬钀戒腑鎻愬彇鏍囬锛堜慨澶嶇増锛�
*/
- private void processItemsAfterExtraction(List<EamMaintenanceStandardDetail> items, String type) {
- if ("SECOND".equals(type)) {
- // 浜岀骇淇濆吇: 鍒犻櫎娌℃湁搴忓彿鐨勬暟鎹�
- items.removeIf(item -> item.getItemCode() == null);
- } else {
- // 涓夌骇淇濆吇:
- // 1. 鍒犻櫎绗竴鏉℃暟鎹紙閫氬父鏄爣棰樿锛�
- if (!items.isEmpty()) {
- items.remove(0);
- }
- // 2. 涓虹己澶遍儴浣嶇殑鏁版嵁濉厖鍓嶄竴鏉＄殑淇濆吇閮ㄤ綅
- String lastPart = "";
- int i = 1;
- for (EamMaintenanceStandardDetail item : items) {
- item.setItemCode(i);
- if (item.getItemPart() != null && !item.getItemPart().isEmpty()) {
- lastPart = item.getItemPart();
- } else if (!lastPart.isEmpty()) {
- item.setItemPart(lastPart);
+ private String extractTitleBeforeTable(XWPFTable table, List<XWPFParagraph> paragraphs) {
+ try {
+ // 鑾峰彇琛ㄦ牸鐨凜TTbl瀵硅薄
+ CTTbl ctTbl = table.getCTTbl();
+
+ // 鑾峰彇琛ㄦ牸鎵�鍦ㄧ殑body
+ IBody body = table.getBody();
+
+ // 鑾峰彇body鐨勬墍鏈夊厓绱狅紙娈佃惤鍜岃〃鏍硷級
+ List<IBodyElement> bodyElements = body.getBodyElements();
+
+ // 鎵惧埌褰撳墠琛ㄦ牸鍦╞ody涓殑浣嶇疆
+ int tableIndex = -1;
+ for (int i = 0; i < bodyElements.size(); i++) {
+ IBodyElement element = bodyElements.get(i);
+ if (element instanceof XWPFTable && element.equals(table)) {
+ tableIndex = i;
+ break;
}
- i++;
+ }
+
+ // 濡傛灉鎵惧埌琛ㄦ牸浣嶇疆锛屽悜鍓嶆煡鎵炬钀�
+ if (tableIndex > 0) {
+ for (int i = tableIndex - 1; i >= 0; i--) {
+ IBodyElement element = bodyElements.get(i);
+ if (element instanceof XWPFParagraph) {
+ XWPFParagraph paragraph = (XWPFParagraph) element;
+ String text = paragraph.getText();
+ if (text != null && !text.trim().isEmpty() && text.contains("淇濆吇瑙勮寖")) {
+ return text.trim();
+ }
+ }
+ }
+ }
+
+ // 濡傛灉涓婃柟娌℃湁鎵惧埌鏍囬锛屽皾璇曚粠琛ㄦ牸鍐呴儴鎻愬彇
+ if (table.getNumberOfRows() > 0) {
+ XWPFTableRow firstRow = table.getRow(0);
+ for (XWPFTableCell cell : firstRow.getTableCells()) {
+ String text = getCellText(cell);
+ if (text != null && text.contains("淇濆吇瑙勮寖")) {
+ return text.trim();
+ }
+ }
+ }
+ } catch (Exception e) {
+ log.warn("鎻愬彇鏍囬澶辫触", e);
+ }
+
+ return null;
+ }
+
+ /**
+ * 澶勭悊璁惧鏍囧噯鐨勯噸澶嶆牎楠屽拰鍗囩増閫昏緫
+ */
+ private void processStandard(EamMaintenanceStandard standard, String type, MultipartFile file,
+ String id, EamMaintenanceStandard oldStandard,
+ Map<String, Integer> versionMap) throws ImportException {
+ // 濡傛灉鏍囬涓虹┖锛屼娇鐢ㄨ澶囧悕绉扮敓鎴愰粯璁ゆ爣棰�
+ if (StrUtil.isEmpty(standard.getStandardName())) {
+ String defaultTitle = standard.getEquipmentName() + "鐢熶骇璁惧" +
+ ("SECOND".equals(type) ? "浜岀骇" : "涓夌骇") + "淇濆吇瑙勮寖";
+ standard.setStandardName(defaultTitle);
+ }
+
+ // 閰嶇疆鍩虹灞炴��
+ configureStandard(standard, type, file);
+
+ if (StrUtil.isNotEmpty(id)) {
+ // 鍗囩増瀵煎叆澶勭悊
+ if (oldStandard == null) {
+ throw new ImportException("鏈壘鍒拌鍗囩増鐨勬爣鍑嗚褰�");
+ }
+
+ // 楠岃瘉璁惧涓�鑷存�э紙璁惧ID鍜屼繚鍏荤被鍒繀椤讳竴鑷达級
+ if (!oldStandard.getEquipmentId().equals(standard.getEquipmentId()) ||
+ !oldStandard.getMaintenanceCategory().equals(standard.getMaintenanceCategory())) {
+ throw new ImportException("鍗囩増璁惧淇℃伅鎴栦繚鍏荤被鍒笉涓�鑷�");
+ }
+
+ // 妫�鏌ュ緟鍔炴祦绋�
+ List<EamMaintenanceStandard> pendingList = eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>()
+ .eq("equipment_id", standard.getEquipmentId())
+ .eq("maintenance_category", standard.getMaintenanceCategory())
+ .in("standard_status",
+ MaintenanceStandardStatusEnum.WAIT_SUBMIT.name(),
+ MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR.name(),
+ MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name())
+ .eq("del_flag", CommonConstant.DEL_FLAG_0)
+ );
+
+ if (!pendingList.isEmpty()) {
+ throw new ImportException("瀛樺湪寰呭鎵规祦绋嬶紝璇风粨鏉熷悗鍐嶆搷浣�");
+ }
+
+ // 浣滃簾鏃ф爣鍑�
+ oldStandard.setStandardStatus(MaintenanceStandardStatusEnum.ABOLISH.name());
+ eamMaintenanceStandardMapper.updateById(oldStandard);
+
+ // 鐗堟湰鍗囩骇
+ String newVersion = incrementVersion(oldStandard.getStandardVersion());
+ standard.setStandardVersion(newVersion);
+
+ // 鏇存柊鐗堟湰鏄犲皠
+ String compositeKey = generateCompositeKey(
+ standard.getEquipmentId(),
+ standard.getMaintenanceCategory()
+ );
+ int newVersionNum = extractVersionNumber(newVersion);
+ versionMap.put(compositeKey, newVersionNum);
+
+ } else {
+ // 鏌ヨ鎵�鏈夊尮閰嶇殑璁惧+淇濆吇绫诲埆鏍囧噯
+ List<EamMaintenanceStandard> existingStandards = eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>()
+ .eq("equipment_id", standard.getEquipmentId())
+ .eq("maintenance_category", standard.getMaintenanceCategory())
+ .eq("del_flag", CommonConstant.DEL_FLAG_0)
+ );
+
+ // 濡傛灉瀛樺湪鍖归厤璁板綍锛屾壘鍑烘渶澶х増鏈彿
+ if (!existingStandards.isEmpty()) {
+ // 鎵惧嚭鏈�澶х増鏈彿
+ int maxVersion = existingStandards.stream()
+ .mapToInt(s -> extractVersionNumber(s.getStandardVersion()))
+ .max()
+ .orElse(0);
+
+ // 璁剧疆鏂扮増鏈彿涓烘渶澶х増鏈�+1
+ standard.setStandardVersion("v" + (maxVersion + 1));
+
+ // 鏇存柊鐗堟湰鏄犲皠
+ String compositeKey = generateCompositeKey(
+ standard.getEquipmentId(),
+ standard.getMaintenanceCategory()
+ );
+ versionMap.put(compositeKey, maxVersion + 1);
+ } else {
+ // 娌℃湁鍖归厤璁板綍锛屽垵濮嬪寲涓簐1
+ standard.setStandardVersion("v1");
+
+ // 鏇存柊鐗堟湰鏄犲皠
+ String compositeKey = generateCompositeKey(
+ standard.getEquipmentId(),
+ standard.getMaintenanceCategory()
+ );
+ versionMap.put(compositeKey, 1);
}
}
}
/**
- * 鎻愬彇浜岀骇淇濆吇椤圭洰锛堝尯鍒嗙涓�椤靛拰鍚庣画椤甸潰锛�
+ * 閰嶇疆淇濆吇鏍囧噯鍙傛暟
+ */
+ private void configureStandard(EamMaintenanceStandard standard, String type, MultipartFile file) {
+ // 鍩虹鍙傛暟
+ standard.setInitialDate(new Date())
+ .setStandardStatus(MaintenanceStandardStatusEnum.START.name())
+ .setDelFlag(CommonConstant.DEL_FLAG_0)
+ .setStandardCode(businessCodeRuleService.generateBusinessCodeSeq(
+ BusinessCodeConst.MAINTENANCE_STANDARD_CODE_RULE
+ ));
+
+ // 绫诲瀷鐗瑰畾鍙傛暟
+ if ("SECOND".equals(type)) {
+ standard.setMaintenanceCategory("SECOND_MAINTENANCE")
+ .setMaintenancePeriod(6)
+ .setPeriodUnit("鏈�");
+ } else {
+ standard.setMaintenanceCategory("THIRD_MAINTENANCE")
+ .setPeriodUnit("骞�");
+
+ // 鑾峰彇涓夌骇淇濆吇鍛ㄦ湡
+ if (standard.getEquipmentId() != null) {
+ EamEquipmentExtend extend = eamEquipmentExtendService.getById(standard.getEquipmentId());
+ if (extend != null && extend.getThirdMaintenancePeriod() != null) {
+ standard.setMaintenancePeriod(extend.getThirdMaintenancePeriod());
+ }
+ }
+
+ // 榛樿涓夌骇淇濆吇鍛ㄦ湡
+ if (standard.getMaintenancePeriod() == null) {
+ standard.setMaintenancePeriod(1);
+ }
+ }
+ }
+
+
+ /**
+ * 鍔犺浇鎸囧畾璁惧鐨勬渶澶х増鏈彿
+ */
+ private void loadDeviceMaxVersions(String equipmentId, Map<String, Integer> compositeVersionMap) {
+ if (StrUtil.isBlank(equipmentId)) return;
+
+ // 鏌ヨ璇ヨ澶囩殑鎵�鏈夋爣鍑�
+ List<EamMaintenanceStandard> standards = eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>()
+ .eq("equipment_id", equipmentId)
+ .eq("del_flag", CommonConstant.DEL_FLAG_0)
+ );
+
+ // 鎸変繚鍏诲垎绫诲垎缁�
+ Map<String, List<EamMaintenanceStandard>> standardsByCategory = standards.stream()
+ .collect(Collectors.groupingBy(EamMaintenanceStandard::getMaintenanceCategory));
+
+ // 瑙ｆ瀽姣忎釜淇濆吇鍒嗙被鐨勬渶澶х増鏈彿
+ for (Map.Entry<String, List<EamMaintenanceStandard>> entry : standardsByCategory.entrySet()) {
+ String maintenanceCategory = entry.getKey();
+ int maxVersion = entry.getValue().stream()
+ .mapToInt(s -> extractVersionNumber(s.getStandardVersion()))
+ .max()
+ .orElse(0);
+
+ String compositeKey = generateCompositeKey(equipmentId, maintenanceCategory);
+ compositeVersionMap.put(compositeKey, maxVersion);
+ }
+ }
+
+ /**
+ * 鍔犺浇鎵�鏈夎澶囩殑鏈�澶х増鏈彿
+ */
+ private void loadAllDeviceMaxVersions(Map<String, Integer> deviceVersionMap) {
+ // 鏌ヨ鎵�鏈夎澶囩殑鏍囧噯
+ List<EamMaintenanceStandard> allStandards = eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>()
+ .eq("del_flag", CommonConstant.DEL_FLAG_0)
+ );
+
+ // 鍒涘缓澶嶅悎閿垎缁勶細璁惧ID + 淇濆吇鍒嗙被
+ Map<String, List<EamMaintenanceStandard>> standardsByCompositeKey = new HashMap<>();
+
+ for (EamMaintenanceStandard standard : allStandards) {
+ String compositeKey = generateCompositeKey(
+ standard.getEquipmentId(),
+ standard.getMaintenanceCategory()
+ );
+
+ standardsByCompositeKey
+ .computeIfAbsent(compositeKey, k -> new ArrayList<>())
+ .add(standard);
+ }
+
+ // 璁＄畻姣忎釜澶嶅悎閿殑鏈�澶х増鏈彿
+ for (Map.Entry<String, List<EamMaintenanceStandard>> entry : standardsByCompositeKey.entrySet()) {
+ String compositeKey = entry.getKey();
+ int maxVersion = entry.getValue().stream()
+ .mapToInt(s -> extractVersionNumber(s.getStandardVersion()))
+ .max()
+ .orElse(0);
+
+ deviceVersionMap.put(compositeKey, maxVersion);
+ }
+ }
+
+ /**
+ * 鏇存柊璁惧鐗堟湰鏄犲皠琛�
+ */
+ private void updateDeviceVersionMap(Map<String, Integer> compositeVersionMap,
+ EamMaintenanceStandard newStandard) {
+ String compositeKey = generateCompositeKey(
+ newStandard.getEquipmentId(),
+ newStandard.getMaintenanceCategory()
+ );
+
+ int newVersion = extractVersionNumber(newStandard.getStandardVersion());
+
+ // 濡傛灉澶嶅悎閿凡瀛樺湪锛屾瘮杈冪増鏈彿
+ if (compositeVersionMap.containsKey(compositeKey)) {
+ int currentMax = compositeVersionMap.get(compositeKey);
+ if (newVersion > currentMax) {
+ compositeVersionMap.put(compositeKey, newVersion);
+ }
+ } else {
+ compositeVersionMap.put(compositeKey, newVersion);
+ }
+ }
+ /**
+ * 浣滃簾鏃х増鏈�
+ */
+ private void obsoleteOldVersionsByCompositeKey(Map<String, Integer> compositeVersionMap) {
+ for (Map.Entry<String, Integer> entry : compositeVersionMap.entrySet()) {
+ String compositeKey = entry.getKey();
+ String[] parts = compositeKey.split("\\|");
+ if (parts.length != 2) continue;
+
+ String equipmentId = parts[0];
+ String maintenanceCategory = parts[1];
+ int maxVersion = entry.getValue();
+
+ // 浣滃簾鎵�鏈変笉鏄渶鏂扮増鏈殑鏍囧噯锛堢浉鍚岃澶�+鐩稿悓淇濆吇鍒嗙被锛�
+ List<EamMaintenanceStandard> oldStandards = eamMaintenanceStandardMapper.selectList(
+ new QueryWrapper<EamMaintenanceStandard>()
+ .eq("equipment_id", equipmentId)
+ .eq("maintenance_category", maintenanceCategory)
+ .eq("del_flag", CommonConstant.DEL_FLAG_0)
+ );
+
+ for (EamMaintenanceStandard standard : oldStandards) {
+ int version = extractVersionNumber(standard.getStandardVersion());
+ if (version < maxVersion) {
+ // 妫�鏌ユ槸鍚﹀湪瀹℃壒娴佺▼涓�
+ if (isPendingApproval(standard)) {
+ log.warn("璺宠繃浣滃簾锛氳澶噞}鐨剓}鏍囧噯{}澶勪簬瀹℃壒娴佺▼涓�",
+ equipmentId, maintenanceCategory, standard.getId());
+ continue;
+ }
+
+ standard.setStandardStatus(MaintenanceStandardStatusEnum.ABOLISH.name());
+ eamMaintenanceStandardMapper.updateById(standard);
+
+ log.info("璁惧{}鐨剓}鏃ф爣鍑嗗凡浣滃簾锛歿} (v{})",
+ equipmentId, maintenanceCategory, standard.getId(), version);
+ }
+ }
+ }
+ }
+
+ /**
+ * 鍒ゆ柇鏍囧噯鏄惁澶勪簬瀹℃壒娴佺▼涓�
+ */
+ private boolean isPendingApproval(EamMaintenanceStandard standard) {
+ return MaintenanceStandardStatusEnum.WAIT_SUBMIT.name().equals(standard.getStandardStatus()) ||
+ MaintenanceStandardStatusEnum.WAIT_REPAIR_DIRECTOR.name().equals(standard.getStandardStatus()) ||
+ MaintenanceStandardStatusEnum.WAIT_TECHNICAL_DIRECTOR.name().equals(standard.getStandardStatus());
+ }
+
+ /**
+ * 浠庣増鏈瓧绗︿覆涓彁鍙栨暟瀛�
+ */
+ private int extractVersionNumber(String versionStr) {
+ if (StrUtil.isBlank(versionStr)) return 0;
+
+ Pattern pattern = Pattern.compile("v?(\\d+)");
+ Matcher matcher = pattern.matcher(versionStr);
+ if (matcher.find()) {
+ try {
+ return Integer.parseInt(matcher.group(1));
+ } catch (NumberFormatException e) {
+ log.warn("鐗堟湰鍙疯В鏋愬け璐�: {}", versionStr);
+ }
+ }
+ return 0;
+ }
+
+ /**
+ * 鐢熸垚璁惧+淇濆吇绫诲埆鐨勫鍚堥敭
+ */
+ private String generateCompositeKey(String equipmentId, String maintenanceCategory) {
+ return equipmentId + "|" + maintenanceCategory;
+ }
+
+ /**
+ * 鐗堟湰鍙烽�掑閫昏緫
+ */
+ private String incrementVersion(String oldVersion) {
+ if (StrUtil.isBlank(oldVersion)) {
+ return "v1";
+ }
+
+ // 灏濊瘯鍖归厤 vX 鏍煎紡
+ Pattern pattern = Pattern.compile("v?(\\d+)");
+ Matcher matcher = pattern.matcher(oldVersion);
+ if (matcher.find()) {
+ try {
+ int verNum = Integer.parseInt(matcher.group(1)) + 1;
+ return "v" + verNum;
+ } catch (NumberFormatException e) {
+ // 鏍煎紡閿欒锛屼娇鐢ㄩ粯璁�
+ }
+ }
+ return "v1";
+ }
+
+ /**
+ * 鎻愬彇璁惧鍩烘湰淇℃伅
+ */
+ private EamMaintenanceStandard extractDeviceInfo(XWPFTable table, String type) {
+ if (table.getNumberOfRows() < 2) return null;
+
+ // 鎻愬彇鍓嶄袱琛屾暟鎹�
+ Map<String, String> row1Data = extractRowData(table.getRow(0));
+ Map<String, String> row2Data = extractRowData(table.getRow(1));
+
+ // 鍒涘缓璁惧鏍囧噯瀵硅薄
+ EamMaintenanceStandard standard = new EamMaintenanceStandard();
+ standard.setEquipmentText(row1Data.get("璁惧绫诲埆"));
+ standard.setEquipmentCode(row1Data.get("璁惧缂栧彿"));
+ standard.setEquipmentName(row2Data.get("璁惧鍚嶇О"));
+ standard.setEquipmentModel(row2Data.get("璁惧鍨嬪彿"));
+
+ // 鍏宠仈璁惧ID
+ if (StrUtil.isNotEmpty(standard.getEquipmentCode())) {
+ EamEquipment equipment = eamEquipmentService.selectByEquipmentCode(standard.getEquipmentCode());
+ if (equipment == null) {
+ log.warn("璁惧缂栫爜鏈壘鍒�: {}", standard.getEquipmentCode());
+ return null;
+ } else {
+ standard.setEquipmentId(equipment.getId());
+ }
+ }
+
+ return standard;
+ }
+
+ /**
+ * 鎻愬彇浜岀骇淇濆吇椤圭洰
*/
private List<EamMaintenanceStandardDetail> extractSecondMaintenanceItems(
XWPFTable table, String standardId, boolean isFirstTable) {
@@ -1375,26 +2021,6 @@
}
/**
- * 浼樺寲鍚庣殑绌鸿妫�娴嬶紙瑙ｅ喅璺ㄩ〉绌鸿闂锛�
- */
- private boolean isRowEmpty(XWPFTableRow row) {
- if (row == null || row.getTableCells().isEmpty()) {
- return true;
- }
-
- boolean allCellsEmpty = true;
- for (XWPFTableCell cell : row.getTableCells()) {
- String text = getCellText(cell).trim();
- // 淇濈暀鍖呭惈鎹㈣绗︾瓑鐨勫崟鍏冩牸浣滀负闈炵┖琛�
- if (!text.isEmpty() && !text.replaceAll("\\s+", "").isEmpty()) {
- allCellsEmpty = false;
- break;
- }
- }
- return allCellsEmpty;
- }
-
- /**
* 鏂囨。绫诲瀷鏍￠獙 - 闃叉浜屼繚浼犲叆涓変繚鎴栧弽涔�
*/
private boolean isWrongDocumentType(XWPFTable table, String requestedType) {
@@ -1441,41 +2067,6 @@
}
/**
- * 鎻愬彇璁惧鍩烘湰淇℃伅
- */
- private EamMaintenanceStandard extractDeviceInfo(XWPFTable table, String type) {
- if (table.getNumberOfRows() < 2) return null;
-
- // 鎻愬彇鍓嶄袱琛屾暟鎹�
- Map<String, String> row1Data = extractRowData(table.getRow(0));
- Map<String, String> row2Data = extractRowData(table.getRow(1));
-
- // 鍒涘缓璁惧鏍囧噯瀵硅薄
- EamMaintenanceStandard standard = new EamMaintenanceStandard();
- standard.setEquipmentText(row1Data.get("璁惧绫诲埆"));
- standard.setEquipmentCode(row1Data.get("璁惧缂栧彿"));
- standard.setEquipmentName(row2Data.get("璁惧鍚嶇О"));
- standard.setEquipmentModel(row2Data.get("璁惧鍨嬪彿"));
-
- // 鍏宠仈璁惧ID
- if (StrUtil.isNotEmpty(standard.getEquipmentCode())) {
- EamEquipment equipments = eamEquipmentService.selectByEquipmentCode(standard.getEquipmentCode());
- if (equipments == null) {
- return null;
- } else {
- standard.setEquipmentId(equipments.getId());
- }
- if (type.equals("THIRD")) {
- EamEquipmentExtend eamEquipmentExtend = eamEquipmentExtendService.getById(standard.getEquipmentId());
- standard.setMaintenancePeriod(eamEquipmentExtend.getThirdMaintenancePeriod());
- }
- }
-
- return standard;
- }
-
-
- /**
* 琛ㄦ牸琛屾暟鎹В鏋�
*/
private Map<String, String> extractRowData(XWPFTableRow row) {
@@ -1495,7 +2086,10 @@
else {
for (int i = 0; i < cellCount; i++) {
String text = getCellText(row.getCell(i));
+ // 鏀寔涓枃鍐掑彿鍜岃嫳鏂囧啋鍙�
int colonIndex = text.indexOf('锛�');
+ if (colonIndex < 0) colonIndex = text.indexOf(':');
+
if (colonIndex > 0) {
String key = cleanKey(text.substring(0, colonIndex));
String value = text.substring(colonIndex + 1);
@@ -1511,49 +2105,31 @@
/**
* 閿悕鏍囧噯鍖栧鐞�
- */
+ */
private String cleanKey(String key) {
if (key == null) return "";
// 绉婚櫎绌烘牸鍜屼腑鏂囧啋鍙�
- return key.replaceAll("\\s", "").replace("锛�", "");
+ return key.replaceAll("\\s", "").replace("锛�", "").replace(":", "");
}
/**
- * 閰嶇疆淇濆吇鏍囧噯鍙傛暟
+ * 绌鸿妫�娴嬶紙瑙ｅ喅璺ㄩ〉绌鸿闂锛�
*/
- private void configureStandard(EamMaintenanceStandard standard, String type, MultipartFile file) {
- // 鍩虹鍙傛暟
- String filename = file.getOriginalFilename();
- if (filename != null && filename.contains(".")) {
- filename = filename.substring(0, filename.lastIndexOf('.'));
+ private boolean isRowEmpty(XWPFTableRow row) {
+ if (row == null || row.getTableCells().isEmpty()) {
+ return true;
}
- standard.setStandardName(filename)
- .setInitialDate(new Date())
- .setStandardStatus(MaintenanceStandardStatusEnum.START.name())
- .setStandardVersion("v" + CommonConstant.OPERATE_TYPE_1)
- .setDelFlag(0)
- .setStandardCode(businessCodeRuleService.generateBusinessCodeSeq(
- BusinessCodeConst.MAINTENANCE_STANDARD_CODE_RULE
- ));
-
- // 绫诲瀷鐗瑰畾鍙傛暟
- if ("SECOND".equals(type)) {
- standard.setMaintenanceCategory("SECOND_MAINTENANCE")
- .setMaintenancePeriod(6)
- .setPeriodUnit("鏈�");
- } else {
- standard.setMaintenanceCategory("THIRD_MAINTENANCE")
- .setPeriodUnit("骞�");
-
- // 鑾峰彇涓夌骇淇濆吇鍛ㄦ湡
- if (standard.getEquipmentId() != null) {
- EamEquipmentExtend extend = eamEquipmentExtendService.getById(standard.getEquipmentId());
- if (extend != null) {
- standard.setMaintenancePeriod(extend.getThirdMaintenancePeriod());
- }
+ boolean allCellsEmpty = true;
+ for (XWPFTableCell cell : row.getTableCells()) {
+ String text = getCellText(cell).trim();
+ // 淇濈暀鍖呭惈鎹㈣绗︾瓑鐨勫崟鍏冩牸浣滀负闈炵┖琛�
+ if (!text.isEmpty() && !text.replaceAll("\\s+", "").isEmpty()) {
+ allCellsEmpty = false;
+ break;
}
}
+ return allCellsEmpty;
}
/**
@@ -1587,6 +2163,33 @@
!getCellText(row.getCell(1)).trim().isEmpty();
}
- /*瀵煎叆浜屼繚涓変繚鏂囦欢Excel--------------------------缁撴潫*/
+ /**
+ * 鍚庡鐞嗘柟娉曪細鏍规嵁涓嶅悓绫诲瀷杩涜澶勭悊
+ */
+ private void processItemsAfterExtraction(List<EamMaintenanceStandardDetail> items, String type) {
+ if ("SECOND".equals(type)) {
+ // 浜岀骇淇濆吇: 鍒犻櫎娌℃湁搴忓彿鐨勬暟鎹�
+ items.removeIf(item -> item.getItemCode() == null);
+ } else {
+ // 涓夌骇淇濆吇:
+ // 1. 鍒犻櫎绗竴鏉℃暟鎹紙閫氬父鏄爣棰樿锛�
+ if (!items.isEmpty()) {
+ items.remove(0);
+ }
+ // 2. 涓虹己澶遍儴浣嶇殑鏁版嵁濉厖鍓嶄竴鏉＄殑淇濆吇閮ㄤ綅
+ String lastPart = "";
+ int i = 1;
+ for (EamMaintenanceStandardDetail item : items) {
+ item.setItemCode(i);
+ if (item.getItemPart() != null && !item.getItemPart().isEmpty()) {
+ lastPart = item.getItemPart();
+ } else if (!lastPart.isEmpty()) {
+ item.setItemPart(lastPart);
+ }
+ i++;
+ }
+ }
+ }
+ /*瀵煎叆浜屼繚涓変繚鏂囦欢Word--------------------------缁撴潫*/
}
--
Gitblit v1.9.3