From 1e1c416c6aa6596feb333b75d882ffeede73d3c9 Mon Sep 17 00:00:00 2001
From: guoyujie <guoyujie@ng.com>
Date: 星期二, 08 四月 2025 17:37:34 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/ERP_override

---
 north-glass-erp/src/main/java/com/example/erp/service/pp/GlassOptimizeService.java |  287 +++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 275 insertions(+), 12 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 8a9cb51..8c480d4 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
@@ -1,15 +1,27 @@
 
 package com.example.erp.service.pp;
 
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
 import com.baomidou.dynamic.datasource.annotation.DS;
+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.userInfo.Log;
+import com.example.erp.entity.userInfo.SysError;
 import com.example.erp.mapper.pp.GlassOptimizeMapper;
+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.Map;
+import java.text.DecimalFormat;
+import java.util.*;
+import java.util.concurrent.TimeoutException;
 
 @Service
 @DS("sd")
@@ -17,18 +29,140 @@
     @Autowired
     GlassOptimizeMapper glassOptimizeMapper;
 
+    RabbitMQUtil rabbitMQUtil;
+    //妯℃嫙璁$畻
+
+    public Map<String, Object> SimulationCalculation(Map<String,Object> message) {
+        Map<String, Object> map = new HashMap<>();
+        try {
+            rabbitMQUtil = new RabbitMQUtil();
+            // 鍙戦�佹秷鎭�
+
+
+            // 鑾峰彇 computeData 鍜� cardData
+            Object computeData = message.get("computeData");
+            Object cardData = message.get("cardData");
+
+           rabbitMQUtil.sendMessage("6");
+            System.out.println("send message: " + message);
+            String date = rabbitMQUtil.receiveMessages();
+            System.out.println("Received message: " + date);
+
+            // 鍏抽棴杩炴帴
+            rabbitMQUtil.close();
+            map.put("data", date);
+
+        } catch (IOException e) {
+            e.printStackTrace();
+        } catch (TimeoutException | InterruptedException e) {
+            e.printStackTrace();
+        }
+
+        return map;
+    }
+
+
+//妯℃嫙璁$畻淇濆瓨
+    public Boolean addSimulation(Map<String, Object> object) {
+        try {
+            glassOptimizeMapper.addSimulation(object);
+            glassOptimizeMapper.addratioResult(object);
+            glassOptimizeMapper.addratioProjectResult(object);
+
+            return true;
+        } catch (Exception e) {
+            e.printStackTrace();
+            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.projectInfoMp(projectNo));
+            map.put("grindingTrimming", glassOptimizeMapper.getEdgeTrimming());
+        }else if(stringObjectMap.get("state").equals(10)){
+            map.put("data", glassOptimizeMapper.projectInfoMp(projectNo));
+            map.put("grindingTrimming", glassOptimizeMapper.getEdgeTrimming());
+        }else{
+            map.put("data", glassOptimizeMapper.projectInfoMp(projectNo));
+            map.put("grindingTrimming", null);
+        }
+        return map;
+    }
+
+
+    //宸ョ▼淇℃伅娴佺▼鍗�
+    public Map<String, Object> getProcessCardSv(String projectNo) {
+        Map<String, Object> map = new HashMap<>();
+        map.put("data", glassOptimizeMapper.getProcessCardMp(projectNo));
         return map;
     }
 
     //搴撳瓨淇℃伅
-    public Map<String, Object> materialStoreSv(String thickness, String model) {
+    public Map<String, Object> materialStoreSv(String thickness, String model, String projectNumber) {
+        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){
+            map.put("data", glassOptimizeMapper.materialStoreMp(thickness,model));
+            map.put("edgeTrimming", glassOptimizeMapper.getEdgeTrimming());
+        }else{
+            map.put("data", glassOptimizeMapper.materialStoreOptimizeUse(projectNumber));
+            map.put("edgeTrimming", null);
+        }
+
         return map;
     }
 
@@ -36,7 +170,14 @@
     //宸ョ▼鏌ヨ娴佺▼鍗�
     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;
     }
@@ -49,9 +190,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;
@@ -59,10 +224,22 @@
     }
 
     //鍒犻櫎宸ョ▼
-    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) {
+        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);
+        for (FlowCard flowCard:flowCardList){
+            glassOptimizeMapper.updateFlowCardProjectReturn(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectNumber);
+        }
+        glassOptimizeMapper.deleteProjectMp(projectNumber);
+        return true;
     }
 
 
@@ -76,6 +253,7 @@
     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;
     }
 
@@ -86,4 +264,89 @@
         return map;
     }
 
+    public Map<String, Object> getProcessCardDetailSv(String processId, Integer technologyNumber) {
+        Map<String, Object> map = new HashMap<>();
+        map.put("data", glassOptimizeMapper.getProcessCardDetailmMp(processId,technologyNumber));
+        return map;
+    }
+
+    public Map<String, Object> selectGlassTypeSv() {
+        Map<String, Object> map = new HashMap<>();
+        map.put("data", glassOptimizeMapper.selectGlassTypeMp());
+        return map;
+    }
+
+
+    public Map<String, Object> getProjectIdSv() {
+        Map<String, Object> map = new HashMap<>();
+        map.put("data", glassOptimizeMapper.getProjectIdSv());
+        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 = "";
+        }
+        BigDecimal sumArea = new BigDecimal(0);
+        double area = 0;
+        Integer sumQuantity = 0;
+        Integer type = 1;
+        StringBuilder processId= new StringBuilder();
+        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()).doubleValue();
+                sumArea = sumArea.add(BigDecimal.valueOf(area));
+                sumQuantity +=flowCard.getQuantity();
+                processId.append(flowCard.getProcessId()).append("-").append(flowCard.getTechnologyNumber()).append(";");
+            }
+            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.doubleValue(),userName,
+                    flowCardList.size(), String.valueOf(processId),type);
+            return true;
+        }
+        else {
+            return false;
+
+        }
+    }
+
+    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