From 9cf6783836fcee8afd5519b7bde82e10eadec4df Mon Sep 17 00:00:00 2001
From: guoyujie <guoyujie@ng.com>
Date: 星期五, 08 八月 2025 13:05:16 +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 | 160 ++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 140 insertions(+), 20 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 c6b4230..9535a46 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
@@ -14,7 +14,9 @@
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.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
+import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -304,22 +306,68 @@
public Map<String, Object> selectOptimizeResult(String processId) {
Map<String, Object> map = new HashMap<>();
map.put("data", glassOptimizeMapper.selectOptimizeResult(processId));
+ map.put("optimizeUse", glassOptimizeMapper.materialStoreOptimizeUse(processId));
return map;
}
//宸ョ▼淇℃伅
- public Map<String, Object> projectInfoSv(String projectNo) {
+ public Map<String, Object> projectInfoSv(String projectNo,String username) {
Map<String, Object> stringObjectMap = glassOptimizeMapper.selectProjectCount(projectNo);
Map<String, Object> map = new HashMap<>();
- if(Integer.parseInt(stringObjectMap.get("optimize_state").toString())==1||Integer.parseInt(stringObjectMap.get("tempering_state").toString())==1){
- map.put("optimizeState", Integer.parseInt(stringObjectMap.get("optimize_state").toString()));
- map.put("data", glassOptimizeMapper.analogComputationOptimization(projectNo));
- map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming());
- }else{
- map.put("optimizeState", Integer.parseInt(stringObjectMap.get("optimize_state").toString()));
- map.put("data", glassOptimizeMapper.firstOptimization(projectNo));
- map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming());
+// if(Integer.parseInt(stringObjectMap.get("optimize_state").toString())==1){
+// map.put("optimizeState", Integer.parseInt(stringObjectMap.get("optimize_state").toString()));
+// map.put("data", glassOptimizeMapper.getOptimizeDetail(projectNo));
+// map.put("project", glassOptimizeMapper.selectProjectCount(projectNo));
+// map.put("grindingTrimming", null);
+// } else if (Integer.parseInt(stringObjectMap.get("tempering_state").toString())==1) {
+// map.put("optimizeState", Integer.parseInt(stringObjectMap.get("optimize_state").toString()));
+// map.put("data", glassOptimizeMapper.analogComputationOptimization(projectNo));
+// map.put("project", glassOptimizeMapper.selectProjectCount(projectNo));
+// map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming(username));
+// } else{
+// map.put("optimizeState", Integer.parseInt(stringObjectMap.get("optimize_state").toString()));
+// map.put("data", glassOptimizeMapper.firstOptimization(projectNo));
+// map.put("project", glassOptimizeMapper.selectProjectCount(projectNo));
+// map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming(username));
+// }
+ map.put("optimizeState", Integer.parseInt(stringObjectMap.get("optimize_state").toString()));
+ map.put("data", glassOptimizeMapper.firstOptimization(projectNo));
+ map.put("project", glassOptimizeMapper.selectProjectCount(projectNo));
+ map.put("grindingTrimming", glassOptimizeMapper.getGrindingTrimming(username));
+ return map;
+ }
+
+
+
+
+ public Object optimizeInfoSv(String projectNo, String username) {
+ Map<String, Object> stringObjectMap = glassOptimizeMapper.selectProjectCount(projectNo);
+ Map<String, Object> map = new HashMap<>();
+ List<Map<String, Object>> dataList = null;
+ if (Integer.parseInt(stringObjectMap.get("tempering_state").toString())==1){
+ dataList = glassOptimizeMapper.computeAndOptimization(projectNo);
+ } else {
+ dataList = glassOptimizeMapper.directOptimization(projectNo);
}
+
+ // 鑾峰彇纾ㄩ噺閰嶇疆鏁版嵁
+ List<Map<String, Object>> grindingTrimmingList = glassOptimizeMapper.getGrindingOptimize(username);
+ // 灏嗙（閲忛厤缃暟鎹嫾鎺ュ埌姣忔潯涓绘暟鎹悗闈�
+ if (dataList != null && !dataList.isEmpty() && grindingTrimmingList != null && !grindingTrimmingList.isEmpty()) {
+ // 鑾峰彇绗竴鏉＄（閲忛厤缃暟鎹紙閫氬父鍙湁涓�鏉¤褰曪級
+ Map<String, Object> grindingConfig = grindingTrimmingList.get(0);
+ // 灏嗙（閲忛厤缃坊鍔犲埌姣忔潯涓绘暟鎹腑
+ for (Map<String, Object> dataItem : dataList) {
+ // 灏嗙（閲忛厤缃殑瀛楁娣诲姞鍒版瘡鏉℃暟鎹腑
+ for (Map.Entry<String, Object> entry : grindingConfig.entrySet()) {
+ // 閬垮厤瑕嗙洊鍘熸湁瀛楁
+ if (!dataItem.containsKey(entry.getKey())) {
+ dataItem.put(entry.getKey(), entry.getValue());
+ }
+ }
+ }
+ }
+ map.put("data", dataList);
return map;
}
@@ -332,7 +380,7 @@
}
//搴撳瓨淇℃伅
- public Map<String, Object> materialStoreSv(String thickness, String model, String projectNumber,Integer type) {
+ public Map<String, Object> materialStoreSv(String thickness, String model, String projectNumber,Integer type,String username) {
Map<String, Object> stringObjectMap = glassOptimizeMapper.selectProjectCount(projectNumber);
Map<String, Object> map = new HashMap<>();
if(Integer.parseInt(stringObjectMap.get("optimize_state").toString())==0){
@@ -343,12 +391,13 @@
}else{
map.put("data", glassOptimizeMapper.materialStoreSurplusMp(thickness,model));
}
- map.put("edgeTrimming", glassOptimizeMapper.getEdgeTrimming());
+ map.put("edgeTrimming", glassOptimizeMapper.getEdgeTrimming(username));
}else{
map.put("data", glassOptimizeMapper.materialStoreOptimizeUse(projectNumber));
map.put("edgeTrimming", null);
}
map.put("state", Integer.parseInt(stringObjectMap.get("state").toString()));
+
return map;
}
@@ -543,11 +592,25 @@
if(projectType.equals("2")){
deleteProject(projectId,2);
}
+
+ // 鍒涘缓涓�涓槧灏勬潵瀛樺偍 (processId-technologyNumber) 缁勫悎鍒� rack 缂栧彿鐨勬槧灏�
+ Map<String, Integer> rackMap = new HashMap<>();
+ int rackCounter = 1;
+
for (FlowCard flowCard : flowCardList) {
+ // 涓烘瘡涓敮涓�鐨� processId-technologyNumber 缁勫悎鍒嗛厤 rack 缂栧彿
+ String key = flowCard.getProcessId() + "-" + flowCard.getTechnologyNumber();
+ if (!rackMap.containsKey(key)) {
+ rackMap.put(key, rackCounter++);
+ }
+ int rackValue = rackMap.get(key);
+
if(flowCard.getPatchState().equals(0)){
state1=1;
//缁欐祦绋嬪崱琛ㄦ坊鍔犲搴旂殑宸ョ▼鍙�
- Boolean a=glassOptimizeMapper.updateFlowCardProject(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectId);
+ Boolean a = glassOptimizeMapper.updateFlowCardProject(flowCard.getProcessId(),flowCard.getTechnologyNumber(),projectId);
+ // 鏇存柊娴佺▼鍗＄殑rack瀛楁
+ glassOptimizeMapper.updateFlowCardRack(flowCard.getProcessId(), flowCard.getTechnologyNumber(), rackValue);
area = glassOptimizeMapper.getSelectArea(flowCard.getProcessId(),flowCard.getTechnologyNumber()).doubleValue();
sumArea = sumArea.add(BigDecimal.valueOf(area));
sumQuantity +=flowCard.getQuantity();
@@ -602,30 +665,30 @@
}
- public Map<String, Object> getConfiguration(String type) {
+ public Map<String, Object> getConfiguration(String type,String username) {
Map<String, Object> map = new HashMap<>();
if(type.equals("閽㈠寲")){
- map.put("data", glassOptimizeMapper.getTemperedConfiguration());
+ map.put("data", glassOptimizeMapper.getTemperedConfiguration(username));
}else if(type.equals("纾ㄩ噺")){
- map.put("data", glassOptimizeMapper.getGrindingTrimming());
+ map.put("data", glassOptimizeMapper.getGrindingTrimming(username));
}else if(type.equals("淇竟")){
- map.put("data", glassOptimizeMapper.getEdgeTrimming());
+ map.put("data", glassOptimizeMapper.getEdgeTrimming(username));
}
return map;
}
- public Boolean saveConfiguration(Map<String,Object> object,String type) {
+ public Boolean saveConfiguration(Map<String,Object> object,String type,String username) {
String json = "";
if (object.get("json") != null) {
json = object.get("json").toString();
}
if(type.equals("閽㈠寲")){
- glassOptimizeMapper.updateOptimizeConfig(json,1);
+ glassOptimizeMapper.updateOptimizeConfig(json,1,username);
} else if (type.equals("淇竟")) {
- glassOptimizeMapper.updateOptimizeConfig(json,5);
+ glassOptimizeMapper.updateOptimizeConfig(json,5,username);
}else if (type.equals("纾ㄩ噺")) {
- glassOptimizeMapper.updateOptimizeConfig(json,4);
+ glassOptimizeMapper.updateOptimizeConfig(json,4,username);
}
return true;
@@ -825,7 +888,64 @@
}
+ public Map<String, Object> getProjectByProjectNoSv(String projectNo) {
+ Map<String, Object> map = new HashMap<>();
+ map.put("data", glassOptimizeMapper.getProjectByProjectNoSv(projectNo));
+ return map;
+ }
+ public Boolean issuingProjects(String projectNo) throws JsonProcessingException {
+ boolean saveState=false;
+ try {
+ // 1. 鍒涘缓URL瀵硅薄
+ URL url = new URL("http://localhost:88/api/loadGlass/engineering/importEngineer");
+
+ // 2. 鎵撳紑杩炴帴
+ HttpURLConnection conn = (HttpURLConnection) url.openConnection();
+ conn.setRequestMethod("POST");
+ conn.setRequestProperty("Content-Type", "application/json");
+ conn.setRequestProperty("Accept", "application/json");
+ conn.setDoOutput(true);
+
+ // 3. 鍑嗗璇锋眰浣�
+ Map<String, Object> optimizeProject=glassOptimizeMapper.selectOptimizeProject(projectNo);
+ optimizeProject.put("engineeringRawQueueList", glassOptimizeMapper.selectOptimizeLayout(projectNo));
+ optimizeProject.put("glassInfolList", glassOptimizeMapper.selectOptimizeDetail(projectNo));
+ optimizeProject.put("flowCardInfoList", glassOptimizeMapper.selectFlowCardInfoList(projectNo));
+ ObjectMapper mapper = new ObjectMapper();
+ mapper.registerModule(new JavaTimeModule());
+ String jsonInputString = mapper.writeValueAsString(optimizeProject);
+
+ //鍙戦�佽姹�
+ try(OutputStream os = conn.getOutputStream()) {
+ byte[] input = jsonInputString.getBytes(StandardCharsets.UTF_8);
+ os.write(input, 0, input.length);
+ }
+
+ // 鑾峰彇鍝嶅簲
+ try(BufferedReader br = new BufferedReader(
+ new InputStreamReader(conn.getInputStream(), StandardCharsets.UTF_8))) {
+ StringBuilder response = new StringBuilder();
+ String responseLine;
+ while ((responseLine = br.readLine()) != null) {
+ response.append(responseLine.trim());
+ }
+ System.out.println("Response: " + response.toString());
+ JSONObject obj = JSONObject.parseObject(response.toString());
+ if(obj.get("code").equals(200)&&obj.get("data").equals(true)){
+ saveState=true;
+ }
+
+ }
+
+ //鍏抽棴杩炴帴
+ conn.disconnect();
+ } catch (Exception e) {
+ e.printStackTrace();
+ saveState= false;
+ }
+ return saveState;
+ }
}
--
Gitblit v1.8.0