From 7165632fcb7b3b782b8959cfe1e7e1c51872e228 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期二, 25 六月 2024 16:34:18 +0800
Subject: [PATCH] station used list and delete
---
pms-parent/pms-web-station/src/main/java/com/dy/pmsStation/workOrder/WorkOrderSv.java | 292 ++++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 211 insertions(+), 81 deletions(-)
diff --git a/pms-parent/pms-web-station/src/main/java/com/dy/pmsStation/workOrder/WorkOrderSv.java b/pms-parent/pms-web-station/src/main/java/com/dy/pmsStation/workOrder/WorkOrderSv.java
index 1e56963..cc7d0e4 100644
--- a/pms-parent/pms-web-station/src/main/java/com/dy/pmsStation/workOrder/WorkOrderSv.java
+++ b/pms-parent/pms-web-station/src/main/java/com/dy/pmsStation/workOrder/WorkOrderSv.java
@@ -3,18 +3,32 @@
import com.alibaba.excel.util.StringUtils;
import com.dy.common.webUtil.BaseResponseUtils;
import com.dy.pmsGlobal.daoBa.BaUserMapper;
+import com.dy.pmsGlobal.daoOth.OthFileMapper;
import com.dy.pmsGlobal.daoPlt.PltStationMapper;
import com.dy.pmsGlobal.daoPr.PrAssemblyPlanMapper;
+import com.dy.pmsGlobal.daoSta.StaAssemblyWorkHistoryMapper;
import com.dy.pmsGlobal.daoSta.StaAssemblyWorkLastMapper;
+import com.dy.pmsGlobal.dyFile.FileOperate;
+import com.dy.pmsGlobal.dyFile.FileRestVo;
import com.dy.pmsGlobal.pojoBa.BaUser;
+import com.dy.pmsGlobal.pojoOth.OthFile;
import com.dy.pmsGlobal.pojoPlt.PltStation;
import com.dy.pmsGlobal.pojoPr.PrAssemblyPlan;
+import com.dy.pmsGlobal.pojoPr.PrProductionNode;
+import com.dy.pmsGlobal.pojoPr.PrWorkingInstruction;
+import com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory;
import com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast;
import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import java.util.Date;
import java.util.List;
+import java.util.concurrent.atomic.AtomicLong;
+import java.util.stream.Collectors;
@Slf4j
@Service
@@ -23,7 +37,11 @@
private BaUserMapper baUserDao;
private PltStationMapper pltStationDao;
private StaAssemblyWorkLastMapper assemblyWorkLastDao;
-
+ private StaAssemblyWorkHistoryMapper assemblyWorkHistoryDao;
+ private FileOperate fileOperate;
+ private OthFileMapper othFileMapper;
+ @Value("${dy.webFile.fmUrl}")
+ private String fmUrl ;
@Autowired
public void setAssemblyDao(PrAssemblyPlanMapper assemblyDao) {
this.assemblyDao = assemblyDao;
@@ -37,105 +55,217 @@
this.pltStationDao = pltStationDao;
}
@Autowired
+ private void setStaAssemblyWorkHistoryDao(StaAssemblyWorkHistoryMapper assemblyWorkHistoryDao){
+ this.assemblyWorkHistoryDao = assemblyWorkHistoryDao;
+ }
+ @Autowired
private void setStaAssemblyWorkLastDao(StaAssemblyWorkLastMapper assemblyWorkLastDao){
this.assemblyWorkLastDao = assemblyWorkLastDao;
}
+ @Autowired
+ public void setFileOperate(FileOperate fileOperate){
+ this.fileOperate = fileOperate;
+ }
+ @Autowired
+ public void setOthFileMapper(OthFileMapper othFileMapper){
+ this.othFileMapper = othFileMapper;
+ }
- public String checkUser(Long id){
- Long userId = id;
- String message = "USER";
- //宸ョ珯103
- if(userId != null && userId.toString().startsWith("103")){
- message = checkStation(id);
- return message;
- }
- if(userId == null){
- message = "FALSE^鍛樺伐缂栫爜涓嶈兘涓虹┖";
- return message;
+ public BaUser getUserInfo(String id){
+ Long userId = null;
+ if(StringUtils.isBlank(id)){
+ throw new RuntimeException("鍛樺伐缂栫爜涓嶈兘涓虹┖");
}
//鐢ㄦ埛101
- if(userId.toString().startsWith("101")){
- userId = Long.parseLong(userId.toString().substring(3));
+ if(id.startsWith("101")){
+ userId = Long.parseLong(id.toString().substring(3));
+ }else{
+ userId = Long.parseLong(id.toString());
}
BaUser userInfo = baUserDao.selectByPrimaryKey(userId);
if(userInfo == null){
- message = "FALSE^鍛樺伐缂栫爜涓嶅湪绯荤粺涓�,璇峰厛缁存姢鍛樺伐淇℃伅";
+ throw new RuntimeException("鍛樺伐缂栫爜:"+ userId +"涓嶅湪绯荤粺涓�,璇峰厛缁存姢鍛樺伐淇℃伅");
+ }else if(userInfo.getDisabled()){
+ throw new RuntimeException("鍛樺伐("+userInfo.getName()+")缂栫爜:"+ userId +"鍦ㄧ郴缁熷凡绂佺敤,璇峰厛鍚敤鍛樺伐");
}
- message += "^"+ userId;
- return message;
+ return userInfo;
}
-
- public String checkStation(Long id){
- Long stationId = id;
- String message = "STATION";
- //鐢ㄦ埛101
- if(stationId != null && stationId.toString().startsWith("101")){
- message = checkUser(id);
- return message;
- }
- if(stationId == null){
- message = "FALSE^宸ョ珯缂栫爜涓嶈兘涓虹┖";
- return message;
+ public PltStation getStationInfo(String id){
+ //浠呮鏌ュ伐绔欎俊鎭互鍙婂伐绔欏崰鐢ㄦ儏鍐�
+ Long stationId = null;
+ if(StringUtils.isBlank(id)){
+ throw new RuntimeException("宸ョ珯缂栫爜涓嶈兘涓虹┖");
}
//宸ョ珯103
- if(stationId.toString().startsWith("103")){
- stationId = Long.parseLong(stationId.toString().substring(3));
+ if(id.startsWith("103")){
+ stationId = Long.parseLong(id.toString().substring(3));
+ }else{
+ stationId = Long.parseLong(id.toString());
}
- PltStation record = new PltStation();
- record.setId(stationId);
- List<PltStation> stationInfo = pltStationDao.selectStationList(record);
- if(stationInfo.size() == 0){
- message = "FALSE^宸ョ珯缂栫爜涓嶅湪绯荤粺涓�,璇峰厛缁存姢宸ョ珯淇℃伅";
- return message;
+ PltStation stationInfo = pltStationDao.selectByPrimaryKey(stationId);
+ if(stationInfo == null){
+ throw new RuntimeException("宸ョ珯缂栫爜:"+ stationId +"涓嶅湪绯荤粺涓�,璇峰厛缁存姢宸ョ珯淇℃伅");
+ }else if(stationInfo.getDisabled()){
+ throw new RuntimeException("宸ョ珯("+stationInfo.getName()+")缂栫爜:"+ stationId +"鍦ㄧ郴缁熷凡绂佺敤,璇峰厛鍚敤宸ョ珯");
}
- //妫�鏌ュ伐绔�
- message += "^"+ stationId;
- return message;
+ return stationInfo;
}
- public String checkStationIsUsed(StaAssemblyWorkLast last){
- String message = "OK";
- Long userId = null;
- Long stationId = null;
- String userMsg = checkUser(last.getUserId());
- String stationMsg = checkStation(last.getStationId());
- if(userMsg.startsWith("FALSE") || stationMsg.startsWith("FALSE")){
- if(userMsg.startsWith("FALSE") && stationMsg.startsWith("FALSE")){
- message = userMsg +","+ stationMsg.split("^")[1];
- }else if(userMsg.startsWith("FALSE")){
- message = userMsg;
- }else if(stationMsg.startsWith("FALSE")){
- message = stationMsg;
- }
- return message;
- }else{//鏍规嵁缁撴灉 鎵惧埌瀵瑰簲鐨処D鍊�
- if(userMsg.startsWith("USER")){
- userId = Long.parseLong(userMsg.split("^")[1]);
- }else if(userMsg.startsWith("STATION")){
- stationId = Long.parseLong(userMsg.split("^")[1]);
- }
- if(stationMsg.startsWith("USER")){
- userId = Long.parseLong(stationMsg.split("^")[1]);
- }else if(stationMsg.startsWith("STATION")){
- stationId = Long.parseLong(stationMsg.split("^")[1]);
- }
+ public StaAssemblyWorkLast checkStationUsed(String id){
+ StaAssemblyWorkLast result = new StaAssemblyWorkLast();
+ PltStation stationInfo = null;
+ if(StringUtils.isBlank(id)){
+ throw new RuntimeException("宸ョ珯缂栫爜涓嶈兘涓虹┖,璇锋鏌�");
}
- if(userId == null || stationId == null){
- message = "FALSE^鍛樺伐缂栫爜:"+ last.getUserId() + "鎴栧伐绔欑紪鐮�:" + last.getStationId() + "涓嶆纭�,璇锋鏌�";
- return message;
- }
- //妫�鏌ヨ〃涓槸涓嶆槸宸茬粡瀛樺湪
+ stationInfo = getStationInfo(id);
+ //妫�鏌ヨ〃涓璼tationId鏄惁宸茬粡瀛樺湪
StaAssemblyWorkLast param = new StaAssemblyWorkLast();
- param.setUserId(userId);
- param.setStationId(stationId);
+ param.setStationId(stationInfo.getId());
param.setStatus(1);
- List<StaAssemblyWorkLast> userStationList = assemblyWorkLastDao.selectList(param);
- if(userStationList.size() > 0){
- message = "FALSE^鍛樺伐缂栫爜:"+ userStationList.get(0).getUserId() + "宸茬粡缁戝畾璇ュ伐绔欑紪鐮�:" + userStationList.get(0).getStationId() + ".璇峰厛璁╁叾瑙ｇ粦";
- }//message = "OK^鍛樺伐缂栫爜:"+ userId+ "宸茬粡缁戝畾璇ュ伐绔欑紪鐮�:" + stationId + ".楠岃瘉閫氳繃";
- return message;
+ List<StaAssemblyWorkLast> workLasts = assemblyWorkLastDao.selectList(param);
+ if(workLasts.size() > 0){
+ BeanUtils.copyProperties(workLasts.get(0),result);
+ }else{
+ result.setStationId(stationInfo.getId());
+ result.setStationName(stationInfo.getName());
+ result.setLineId(stationInfo.getLineId());
+ result.setLineName(stationInfo.getLineName());
+ }
+ return result;
}
- public List<PrAssemblyPlan> selectList(PrAssemblyPlan params){
- List<PrAssemblyPlan> planList = assemblyDao.selectList(params);
+
+ public StaAssemblyWorkLast checkUserAndStationUsed(QueryVo last){
+ StaAssemblyWorkLast result = new StaAssemblyWorkLast();
+ PltStation stationInfo = null;
+ BaUser userInfo = null;
+ if(StringUtils.isBlank(last.getStationId()) || StringUtils.isBlank(last.getUserId())){
+ throw new RuntimeException("宸ョ珯缂栫爜鎴栧憳宸ョ紪鐮佸潎涓嶈兘涓虹┖,璇锋鏌�");
+ }
+ //宸ョ珯103
+ if(last.getStationId().startsWith("101")){
+ userInfo = getUserInfo(last.getStationId());
+ }else{
+ stationInfo = getStationInfo(last.getStationId());
+ }
+ if(last.getUserId().startsWith("103")){
+ stationInfo = getStationInfo(last.getUserId());
+ }else{
+ userInfo = getUserInfo(last.getUserId());
+ }
+ if(userInfo == null && stationInfo == null){
+ throw new RuntimeException("鍛樺伐缂栫爜:"+ last.getUserId() + "鍜屽伐绔欑紪鐮�:" + last.getStationId() + "涓嶆纭�,璇锋鏌�");
+ }else if(userInfo == null){
+ throw new RuntimeException("鍛樺伐缂栫爜:"+ last.getUserId() + "涓嶆纭�,璇锋鏌�");
+ }else if(stationInfo == null){
+ throw new RuntimeException("宸ョ珯缂栫爜:" + last.getStationId() + "涓嶆纭�,璇锋鏌�");
+ }
+ //妫�鏌ヨ〃涓璼tationId鏄惁宸茬粡瀛樺湪
+ StaAssemblyWorkLast param = new StaAssemblyWorkLast();
+ param.setStationId(stationInfo.getId());
+ param.setStatus(1);
+ List<StaAssemblyWorkLast> workLasts = assemblyWorkLastDao.selectList(param);
+ long userId = userInfo.getId();
+ if(workLasts.size() > 0){
+ List<StaAssemblyWorkLast> userStationList = workLasts.stream().filter(item->userId == item.getUserId()).collect(Collectors.toList());
+ if(userStationList.size() == 0){
+ throw new RuntimeException("鍛樺伐("+workLasts.get(0).getUserName()+")缂栫爜:"+ workLasts.get(0).getUserId() + "宸茬粡缁戝畾璇ュ伐绔�("+workLasts.get(0).getStationName()+")缂栫爜:" + workLasts.get(0).getStationId() + ".璇峰厛璁╁叾瑙ｇ粦");
+ }else{
+ BeanUtils.copyProperties(userStationList.get(0),result);
+ }
+ }else{
+ result.setUserId(userInfo.getId());
+ result.setUserName(userInfo.getName());
+ result.setStationId(stationInfo.getId());
+ result.setStationName(stationInfo.getName());
+ result.setLineId(stationInfo.getLineId());
+ }
+ return result;
+ }
+ @Transactional
+ public StaAssemblyWorkLast save(QueryVo last) {
+ //鍏坈heck
+ StaAssemblyWorkLast checkResult = checkUserAndStationUsed(last);
+ //鏍￠獙planId processId nodeId
+ PrAssemblyPlan params = new PrAssemblyPlan();
+ params.setStatus(1);
+ params.setId(last.getPlanId());
+ params.setProcessId(last.getProcessId());
+ List<PrAssemblyPlan> planList = selectAssyPlanList(params);
+ boolean hasNodeId= planList.stream()
+ .flatMap(process -> process.nodes.stream())
+ .anyMatch(node -> node.id.equals(last.getNodeId()));
+ if(!hasNodeId){
+ throw new RuntimeException("鑺傜偣淇℃伅鏈夎鎴栬鍏朵粬浜哄憳淇敼,璇烽噸鏂伴�夋嫨鑺傜偣淇℃伅");
+ }
+ last.setLineId(checkResult.getLineId());
+ StaAssemblyWorkLast staLast = new StaAssemblyWorkLast();
+ BeanUtils.copyProperties(last,staLast);
+ staLast.setUserId(checkResult.getUserId());
+ staLast.setStationId(checkResult.getStationId());
+ int count = 0;
+ if(checkResult.getId() == null){
+ BeanUtils.copyProperties(last,staLast);
+ staLast.setUserId(checkResult.getUserId());
+ staLast.setStationId(checkResult.getStationId());
+ staLast.setStatus(1);
+ staLast.setStartTime(new Date());
+ count = assemblyWorkLastDao.insertSelective(staLast);
+ }else{
+ //淇濆瓨涓�鏉istory?
+ BeanUtils.copyProperties(checkResult,staLast);
+ staLast.setPlanId(last.getPlanId());
+ staLast.setProcessId(last.getProcessId());
+ staLast.setNodeId(last.getNodeId());
+ staLast.setStatus(1);
+ staLast.setStartTime(new Date());
+ count = assemblyWorkLastDao.updateByPrimaryKeySelective(staLast);
+ }
+ if (count <= 0) {
+ throw new RuntimeException("鏁版嵁搴撳瓨鍌ㄥけ璐�");
+ }
+ StaAssemblyWorkLast result = assemblyWorkLastDao.selectByPrimaryKey(staLast.getId());
+ return result;
+ }
+ @Transactional
+ public int logout(String id) {
+ //鎵惧埌鐧诲綍璁板綍
+ StaAssemblyWorkLast workLast = assemblyWorkLastDao.selectByPrimaryKey(Long.parseLong(id));
+ if(workLast == null){
+ throw new RuntimeException("绯荤粺涓病鏈夎鏉＄櫥褰曚俊鎭�");
+ }
+ //鏇存柊鐧诲綍璁板綍
+ workLast.setStatus(2);
+ workLast.setEndTime(new Date());
+ // 淇濆瓨history
+ StaAssemblyWorkHistory history = new StaAssemblyWorkHistory();
+ BeanUtils.copyProperties(workLast,history);
+ history.setId(null);
+ int count = assemblyWorkHistoryDao.insertSelective(history);
+ //鍒犻櫎last
+ assemblyWorkLastDao.deleteByPrimaryKey(Long.parseLong(id));
+ return count;
+ }
+ public List<PrAssemblyPlan> selectAssyPlanList(PrAssemblyPlan params){
+ List<PrAssemblyPlan> planList = assemblyDao.selectAssyPlanList(params);
+ planList.stream().forEach(process -> {
+ process.nodes.forEach(node -> {
+ if(node.instruction != null){
+ addUrl(node.instruction);
+ }
+ });
+ });
return planList;
}
-}
+ private void addUrl(PrWorkingInstruction ins){
+ if (ins == null || ins.fileId == null) {
+ return;
+ }
+ OthFile file = othFileMapper.selectByPrimaryKey(ins.fileId);
+ if (file == null) {
+ return;
+ }
+ FileRestVo fileRestVo = fileOperate.parseHashcode(fmUrl, file.hash);
+ ins.webUrl = fileRestVo.fileSysRestUrl + fileRestVo.fileWebDownloadPath + ins.fileId;
+ ins.orgName = file.orgName;
+ ins.extName = file.extName;
+ }
+}
\ No newline at end of file
--
Gitblit v1.8.0