ERP_override.git

			@@ -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;
			@@ -336,6 +338,40 @@
			}




			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;
			}


			//工程信息流程卡
			public Map<String, Object> getProcessCardSv(String projectNo) {
			Map<String, Object> map = new HashMap<>();
			@@ -556,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();
			@@ -843,4 +893,59 @@
			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;
			}

			}