From 24888c4b2ca2ffc49c4d94aefd6aea32d515b6dd Mon Sep 17 00:00:00 2001
From: chenlu <1320612696@qq.com>
Date: 星期日, 20 四月 2025 14:17:24 +0800
Subject: [PATCH] 分架明细报表修改查询问题
---
north-glass-erp/src/main/java/com/example/erp/service/pp/GlassOptimizeService.java | 353 +++++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 306 insertions(+), 47 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/service/pp/GlassOptimizeService.java b/north-glass-erp/src/main/java/com/example/erp/service/pp/GlassOptimizeService.java
index 3d5c1f1..81ffb3e 100644
--- a/north-glass-erp/src/main/java/com/example/erp/service/pp/GlassOptimizeService.java
+++ b/north-glass-erp/src/main/java/com/example/erp/service/pp/GlassOptimizeService.java
@@ -7,24 +7,32 @@
import com.example.erp.common.RabbitMQUtil;
import com.example.erp.entity.pp.FlowCard;
import com.example.erp.entity.pp.OptimizeProjectMange;
+import com.example.erp.entity.pp.PatchLog;
+import com.example.erp.entity.userInfo.Log;
+import com.example.erp.entity.userInfo.SysError;
import com.example.erp.mapper.pp.GlassOptimizeMapper;
+import com.example.erp.service.userInfo.SysErrorService;
import com.fasterxml.jackson.databind.ObjectMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import org.springframework.transaction.interceptor.TransactionAspectSupport;
import java.io.IOException;
+import java.math.BigDecimal;
import java.sql.Date;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.text.DecimalFormat;
+import java.util.*;
import java.util.concurrent.TimeoutException;
@Service
+@Transactional(rollbackFor = Exception.class)
@DS("sd")
public class GlassOptimizeService {
@Autowired
GlassOptimizeMapper glassOptimizeMapper;
+ @Autowired
+ SysErrorService sysErrorService;
RabbitMQUtil rabbitMQUtil;
//妯℃嫙璁＄畻
@@ -37,10 +45,10 @@
// 鑾峰彇 computeData 鍜� cardData
- Object computeData = message.get("computeData");
- Object cardData = message.get("cardData");
+ /*Object computeData = message.get("computeData");
+ Object cardData = message.get("cardData");*/
- rabbitMQUtil.sendMessage("6");
+ rabbitMQUtil.sendMessage(message.toString());
System.out.println("send message: " + message);
String date = rabbitMQUtil.receiveMessages();
System.out.println("Received message: " + date);
@@ -72,10 +80,71 @@
return false;
}
}
+
+
+ //浼樺寲璁剧疆淇濆瓨
+ public Boolean optimizeParmsSave(Map<String, Object> object) {
+ try {
+ ObjectMapper mapper = new ObjectMapper();
+ String jsonString = mapper.writeValueAsString(object);
+
+ glassOptimizeMapper.optimizeParmsSave(jsonString);
+ return true;
+ } catch (Exception e) {
+ e.printStackTrace();
+ return false;
+ }
+ }
+
+
+
+ //浼樺寲璋冩暣缁撴灉淇濆瓨
+ public Boolean saveOptimizeResult(Map<String, Object> object) {
+ try {
+ ObjectMapper mapper = new ObjectMapper();
+ String jsonString = mapper.writeValueAsString(object);
+ glassOptimizeMapper.optimizeResultSave(jsonString);
+ return true;
+ } catch (Exception e) {
+ e.printStackTrace();
+ return false;
+ }
+ }
+
+
+ public Boolean updateOptimizeResult(Map<String, Object> object,String processId){
+ try {
+ ObjectMapper mapper = new ObjectMapper();
+ String jsonString = mapper.writeValueAsString(object);
+ glassOptimizeMapper.updateOptimizeResult(jsonString,processId);
+ return true;
+ } catch (Exception e) {
+ e.printStackTrace();
+ return false;
+ }
+ }
+
+ //浼樺寲璋冩暣缁撴灉鏌ヨ
+ public Map<String, Object> selectOptimizeResult(String processId) {
+ Map<String, Object> map = new HashMap<>();
+ map.put("data", glassOptimizeMapper.selectOptimizeResult(processId));
+ return map;
+ }
+
//宸ョ▼淇℃伅
public Map<String, Object> projectInfoSv(String projectNo) {
+ Map<String, Object> stringObjectMap = glassOptimizeMapper.selectProjectCount(projectNo);
Map<String, Object> map = new HashMap<>();
- map.put("data", glassOptimizeMapper.projectInfoMp(projectNo));
+ if(Integer.parseInt(stringObjectMap.get("state").toString())<10){
+ map.put("data", glassOptimizeMapper.firstOptimization(projectNo));
+ map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming());
+ }else if(stringObjectMap.get("state").equals(10)){
+ map.put("data", glassOptimizeMapper.analogComputationOptimization(projectNo));
+ map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming());
+ }else{
+ map.put("data", glassOptimizeMapper.analogComputationOptimization(projectNo));
+ map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming());
+ }
return map;
}
@@ -88,9 +157,32 @@
}
//搴撳瓨淇℃伅
- public Map<String, Object> materialStoreSv(String thickness, String model) {
+ public Map<String, Object> materialStoreSv(String thickness, String model, String projectNumber,Integer type) {
+ Map<String, Object> stringObjectMap = glassOptimizeMapper.selectProjectCount(projectNumber);
Map<String, Object> map = new HashMap<>();
- map.put("data", glassOptimizeMapper.materialStoreMp(thickness,model));
+ if(Integer.parseInt(stringObjectMap.get("state").toString())<10){
+ if(type==1){
+ map.put("data", glassOptimizeMapper.materialStoreMp(thickness,model));
+ }else if(type==2){
+ map.put("data", glassOptimizeMapper.surplusMaterialsMp(thickness,model));
+ }else{
+ map.put("data", glassOptimizeMapper.materialStoreSurplusMp(thickness,model));
+ }
+ map.put("edgeTrimming", glassOptimizeMapper.getEdgeTrimming());
+ }else if(Integer.parseInt(stringObjectMap.get("state").toString())==10){
+ if(type==1){
+ map.put("data", glassOptimizeMapper.materialStoreMp(thickness,model));
+ }else if(type==2){
+ map.put("data", glassOptimizeMapper.surplusMaterialsMp(thickness,model));
+ }else{
+ map.put("data", glassOptimizeMapper.materialStoreSurplusMp(thickness,model));
+ }
+ map.put("edgeTrimming", glassOptimizeMapper.getEdgeTrimming());
+ }else{
+ map.put("data", glassOptimizeMapper.materialStoreOptimizeUse(projectNumber));
+ map.put("edgeTrimming", null);
+ }
+ map.put("state", Integer.parseInt(stringObjectMap.get("state").toString()));
return map;
}
@@ -98,7 +190,28 @@
//宸ョ▼鏌ヨ娴佺▼鍗�
public Map<String, Object> getFlowCardList(String optionVal, Integer radio) {
Map<String, Object> map = new HashMap<>();
- map.put("data", glassOptimizeMapper.getFlowCardListMp(optionVal, radio));
+ if(radio==1){
+ map.put("data", glassOptimizeMapper.getFlowCardListWhole(optionVal));
+ }else if(radio==2){
+ map.put("data", glassOptimizeMapper.getFlowCardListNormal(optionVal));
+ }else{
+ map.put("data", glassOptimizeMapper.getFlowCardListPatch(optionVal));
+ }
+
+
+ return map;
+ }
+
+ public Map<String, Object> getUpdateFlowCardList(String type,String thickness, Integer radio,String projectNo) {
+ Map<String, Object> map = new HashMap<>();
+ if(radio==1){
+ map.put("data", glassOptimizeMapper.getFlowCardListModify(type,thickness,projectNo));
+ }else if(radio==2){
+ map.put("data", glassOptimizeMapper.getFlowCardListNormal(type));
+ }else{
+ map.put("data", glassOptimizeMapper.getFlowCardListPatch(type));
+ }
+
return map;
}
@@ -111,9 +224,33 @@
}
//淇敼鎺掔増鐘舵��
- public Boolean updateProjectState(String projectNumber, Integer state) {
+ public Boolean updateProjectState(String projectNumber, Integer state, Integer code) {
if (!projectNumber.isEmpty()) {
- glassOptimizeMapper.updateProjectStateMp(projectNumber, state);
+ //鎾ら攢妯℃嫙璁＄畻
+ if(code==1){
+ glassOptimizeMapper.deleteOptimizeHeatDetail(projectNumber);
+ glassOptimizeMapper.deleteOptimizeHeatLayout(projectNumber);
+ glassOptimizeMapper.updateProjectStateMp(projectNumber, state);
+ }
+ //鎾ら攢浼樺寲鎺掔増
+ else if(code==2){
+ glassOptimizeMapper.deleteOptimizeHeatDetail(projectNumber);
+ glassOptimizeMapper.deleteOptimizeHeatDetail(projectNumber);
+ glassOptimizeMapper.deleteOptimizeHeatLayout(projectNumber);
+ glassOptimizeMapper.updateProjectStateMp(projectNumber, state);
+ }
+ //鍏佽鐢熶骇
+ else if(code==3){
+ glassOptimizeMapper.updateProjectStateMp(projectNumber, state);
+ }
+ //鐢熶骇涓嶅彲瑙�
+ else if(code==4){
+ glassOptimizeMapper.updateProjectStateMp(projectNumber, state);
+ }
+ //鍒濆鍖栧伐绋�
+ else if(code==5){
+ glassOptimizeMapper.updateProjectStateMp(projectNumber, state);
+ }
return true;
} else {
return false;
@@ -121,10 +258,33 @@
}
//鍒犻櫎宸ョ▼
- public Map<String, Object> deleteProject(String projectNumber) {
- Map<String, Object> map = new HashMap<>();
- map.put("data", glassOptimizeMapper.deleteProjectMp(projectNumber));
- return map;
+ public boolean deleteProject(String projectNumber,Integer type) {
+ Map<String, Object> stringObjectMap = glassOptimizeMapper.selectProjectCount(projectNumber);
+ if(stringObjectMap.get("state").equals(10)){
+ glassOptimizeMapper.deleteOptimizeHeatDetail(projectNumber);
+ glassOptimizeMapper.deleteOptimizeHeatLayout(projectNumber);
+ }else if(stringObjectMap.get("state").equals(20)){
+ glassOptimizeMapper.deleteOptimizeDetail(projectNumber);
+ glassOptimizeMapper.deleteOptimizeHeatDetail(projectNumber);
+ glassOptimizeMapper.deleteOptimizeHeatLayout(projectNumber);
+ }
+ List<FlowCard> flowCardList =glassOptimizeMapper.getFlowCardList(projectNumber);
+ List<PatchLog> patchLogList =glassOptimizeMapper.getPatchLogList(projectNumber);
+ if(flowCardList!=null){
+ for (FlowCard flowCard:flowCardList){
+ glassOptimizeMapper.updateFlowCardProjectReturn(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectNumber);
+ }
+ }
+ if(patchLogList!=null){
+ for (PatchLog patchLog:patchLogList){
+ glassOptimizeMapper.updatePatchLogProjectReturn(patchLog.getProcessId(),patchLog.getTechnologyNumber(),projectNumber);
+ }
+ }
+ //鍒ゆ柇鏄惁鏄慨鏀瑰伐绋�
+ if(type.equals(1)){
+ glassOptimizeMapper.deleteProjectMp(projectNumber);
+ }
+ return true;
}
@@ -138,13 +298,30 @@
public Map<String, Object>selectProjectComputeSv(String projectNumber) {
Map<String, Object> map = new HashMap<>();
map.put("data", glassOptimizeMapper.selectProjectComputeMp(projectNumber));
+ //map.put("project", glassOptimizeMapper.selectProjectCount(projectNumber));
+ return map;
+ }
+
+ public Map<String, Object>selectProjectComputeAll(String projectNumber) {
+ Map<String, Object> map = new HashMap<>();
+ List<Map<String, Object>> projectComputeMpList=glassOptimizeMapper.selectProjectComputeMp(projectNumber);
+ for (Map<String, Object> stringObjectMap : projectComputeMpList) {
+ stringObjectMap.get("process_id");
+ stringObjectMap.get("technology_number");
+ }
+ map.put("data", glassOptimizeMapper.selectProjectComputeMp(projectNumber));
+ //map.put("project", glassOptimizeMapper.selectProjectCount(projectNumber));
return map;
}
//妯℃嫙璁＄畻娴佺▼鍗¤鎯�
- public Map<String, Object>selectComputeDetailSv(String processId) {
+ public Map<String, Object>selectComputeDetailSv(String processId,Integer technologyNumber,String patchState) {
Map<String, Object> map = new HashMap<>();
- map.put("data", glassOptimizeMapper.selectComputeDetailMp(processId));
+ if(patchState.equals("0")){
+ map.put("data", glassOptimizeMapper.selectComputeDetailMp(processId,technologyNumber));
+ }else{
+ map.put("data", glassOptimizeMapper.selectComputeDetailMpPatchState(processId,technologyNumber));
+ }
return map;
}
@@ -167,37 +344,119 @@
return map;
}
- public Boolean addProjectSv(String optionVal, String projectId, String projectNmae, Map<String, Object> object) {
- String userName = "";
- if (object.get("userName") != null) {
- userName = object.get("userName").toString();
- }
- if ("null".equals(projectNmae)) {
- projectNmae = "";
- }
- Double sumArea = (double) 0;
- Double area = (double) 0;
- Integer sumQuantity = 0;
- List<FlowCard> flowCardList = JSONArray.parseArray(JSONObject.toJSONString(object.get("projectdetail")), FlowCard.class);
- if (!flowCardList.isEmpty()) {
- for (FlowCard flowCard : flowCardList) {
- //缁欐祦绋嬪崱琛ㄦ坊鍔犲搴旂殑宸ョ▼鍙�
- glassOptimizeMapper.updateFlowCardProject(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectId);
- area = glassOptimizeMapper.getSelectArea(flowCard.getProcessId(),flowCard.getTechnologyNumber());
- sumArea += area;
- sumQuantity +=flowCard.getQuantity();
+ public String addProjectSv(String optionVal, String projectId, String projectNmae, Map<String, Object> object) {
+ String saveState = "true";
+ //璁剧疆鍥炴粴鐐�
+ Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint();
+ try {
+ String userName = "";
+ if (object.get("userName") != null) {
+ userName = object.get("userName").toString();
}
- int index = optionVal.indexOf("mm");
- // 鑾峰彇 "mm" 鍓嶉潰鐨勯儴鍒�
- String glass_thickness = optionVal.substring(0, index);
- // 鑾峰彇 "mm" 鍚庨潰鐨勯儴鍒�
- String glass_type = optionVal.substring(index + 2);
- glassOptimizeMapper.addProjectMp(projectId,projectNmae,glass_thickness,glass_type,sumQuantity,sumArea,userName);
- return true;
- }
- else {
- return false;
+ String projectType = "";
+ if (object.get("projectType") != null) {
+ projectType = object.get("projectType").toString();
+ }
+ if ("null".equals(projectNmae)) {
+ projectNmae = "";
+ }
+ BigDecimal sumArea = new BigDecimal(0);
+ double area = 0;
+ Integer sumQuantity = 0;
+ Integer type = 0;
+ int state1 = 0;
+ int state2 = 0;
+ StringBuilder processId= new StringBuilder();
+ List<FlowCard> flowCardList = JSONArray.parseArray(JSONObject.toJSONString(object.get("projectdetail")), FlowCard.class);
+ if (!flowCardList.isEmpty()) {
+ if(projectType.equals("2")){
+ deleteProject(projectId,2);
+ }
+ for (FlowCard flowCard : flowCardList) {
+ if(flowCard.getPatchState().equals(0)){
+ state1=1;
+ //缁欐祦绋嬪崱琛ㄦ坊鍔犲搴旂殑宸ョ▼鍙�
+ Boolean a=glassOptimizeMapper.updateFlowCardProject(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectId);
+ area = glassOptimizeMapper.getSelectArea(flowCard.getProcessId(),flowCard.getTechnologyNumber()).doubleValue();
+ sumArea = sumArea.add(BigDecimal.valueOf(area));
+ sumQuantity +=flowCard.getQuantity();
+ processId.append(flowCard.getProcessId()).append("-").append(flowCard.getTechnologyNumber()).append(";");
+ }else{
+ state2=1;
+ Boolean a=glassOptimizeMapper.updatePatchLogProject(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectId);
+ area = glassOptimizeMapper.getSelectAreaPatchLog(flowCard.getProcessId(),flowCard.getTechnologyNumber()).doubleValue();
+ sumArea = sumArea.add(BigDecimal.valueOf(area));
+ sumQuantity +=flowCard.getQuantity();
+ processId.append(flowCard.getProcessId()).append("-").append(flowCard.getTechnologyNumber()).append(";");
+ }
+
+ }
+ if(state1==1&&state2==0){
+ type=1;
+ }else if(state1==1&&state2==1){
+ type=2;
+ }
+ int index = optionVal.indexOf("mm");
+ // 鑾峰彇 "mm" 鍓嶉潰鐨勯儴鍒�
+ String glass_thickness = optionVal.substring(0, index);
+ // 鑾峰彇 "mm" 鍚庨潰鐨勯儴鍒�
+ String glass_type = optionVal.substring(index + 2);
+ if(projectType.equals("2")){
+ glassOptimizeMapper.updateProjectMp(projectId,projectNmae,glass_thickness,glass_type,sumQuantity,sumArea.doubleValue(),userName,
+ flowCardList.size(), String.valueOf(processId),type);
+ }else{
+ if(glassOptimizeMapper.selectProjectCount(projectId)==null){
+ glassOptimizeMapper.addProjectMp(projectId,projectNmae,glass_thickness,glass_type,sumQuantity,sumArea.doubleValue(),userName,
+ flowCardList.size(), String.valueOf(processId),type);
+ }else{
+ TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
+ return "false1";
+ }
+ }
+ }else {
+ return "false2";
+
+ }
+ } catch (Exception e) {
+ TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
+ //灏嗗紓甯镐紶鍏ユ暟鎹簱
+ SysError sysError = new SysError();
+ sysError.setError(e+Arrays.toString(e.getStackTrace()));
+ sysError.setFunc("addProjectSv");
+ sysErrorService.insert(sysError);
+ saveState = "false";
}
+ return saveState;
+
+ }
+
+ public Map<String, Object> getConfiguration(String type) {
+ Map<String, Object> map = new HashMap<>();
+ if(type.equals("閽㈠寲")){
+ map.put("data", glassOptimizeMapper.getTemperedConfiguration());
+ }else if(type.equals("纾ㄩ噺")){
+ map.put("data", glassOptimizeMapper.getGrindingTrimming());
+ }else if(type.equals("淇竟")){
+ map.put("data", glassOptimizeMapper.getEdgeTrimming());
+ }
+
+ return map;
+ }
+
+ public Boolean saveConfiguration(Map<String,Object> object,String type) {
+ String json = "";
+ if (object.get("json") != null) {
+ json = object.get("json").toString();
+ }
+ if(type.equals("閽㈠寲")){
+ glassOptimizeMapper.updateOptimizeConfig(json,1);
+ } else if (type.equals("淇竟")) {
+ glassOptimizeMapper.updateOptimizeConfig(json,5);
+ }else if (type.equals("纾ㄩ噺")) {
+ glassOptimizeMapper.updateOptimizeConfig(json,4);
+ }
+ return true;
+
}
}
--
Gitblit v1.8.0