| | |
| | | String selectConfigByUserAndType(String username, int type); |
| | | |
| | | void insertOptimizeConfig(String json, int type, String userName, String configName); |
| | | |
| | | Map<String, Object> getGlassProjectList(String projectId); |
| | | } |
| | |
| | | |
| | | List<Map<String, Object>> objectMapList = (List<Map<String, Object>>) optimalResults.get("layouts"); |
| | | glassOptimizeMapper.addOptimizeLayout(objectMapList,projectId); |
| | | // 收集所有需要保存的玻璃明细数据 |
| | | List<Map<String, Object>> allGlassDetails = new ArrayList<>(); |
| | | |
| | | for(Map<String, Object> objectMap:objectMapList){ |
| | | List<Map<String, Object>> objectMap2 = (List<Map<String, Object>>) objectMap.get("glassDetails"); |
| | | //迭代玻璃明细集合处理余料和其他 |
| | |
| | | } |
| | | } |
| | | } |
| | | glassOptimizeMapper.addOptimizeDetail(objectMap2,projectId); |
| | | // 将当前批次的玻璃明细添加到总列表中 |
| | | allGlassDetails.addAll(objectMap2); |
| | | } |
| | | |
| | | Map<String, Object> projectInfo = glassOptimizeMapper.getGlassProjectList(projectId); |
| | | if (projectInfo != null && Integer.parseInt(projectInfo.get("tempering_state").toString()) == 1) { |
| | | // tempering_state 为 1 时的处理逻辑 |
| | | glassOptimizeMapper.addOptimizeDetail(allGlassDetails,projectId); |
| | | List<OptimizeHeatDetail> optimizeHeatDetail = glassOptimizeMapper.selectOptimizeHeatDetail(projectId); |
| | | for (OptimizeHeatDetail projectdetail:optimizeHeatDetail){ |
| | | OptimizeDetail optimizeDetail=glassOptimizeMapper.selectOptimizeDetailById(projectId,projectdetail.getProcessId(), |
| | | projectdetail.getOrderSort(),projectdetail.getLayer()); |
| | | glassOptimizeMapper.updateOptimizeDetail(optimizeDetail.getId(),projectdetail.getLayoutId(),projectdetail.getSort()); |
| | | } |
| | | } else { |
| | | // tempering_state 为 0 时的处理逻辑 |
| | | glassOptimizeMapper.addOptimizeDetail(allGlassDetails,projectId); |
| | | } |
| | | |
| | | glassOptimizeMapper.updateProjectOptimize(projectId, 1, optimalResults); |
| | |
| | | boolean saveState=false; |
| | | try { |
| | | // 1. 创建URL对象 |
| | | URL url = new URL("http://localhost:88/api/loadGlass/engineering/importEngineer"); |
| | | URL url = new URL("http://10.153.19.31:88/api/loadGlass/engineering/importEngineer"); |
| | | |
| | | // 2. 打开连接 |
| | | HttpURLConnection conn = (HttpURLConnection) url.openConnection(); |
| | |
| | | order_sort, |
| | | stock_id, |
| | | polys_id, |
| | | o_width, |
| | | o_height, |
| | | p_width, |
| | | p_height, |
| | | width, |
| | | height, |
| | | x_axis, |
| | | y_axis, |
| | | patch_state, |
| | |
| | | |
| | | <update id="updateOptimizeDetail"> |
| | | update pp.optimize_detail |
| | | set heat_layout_id=#{layoutId},heat_layout_sort=#{sort},glass_id=concat(process_id,'|',#{layoutId},'|',#{sort}) |
| | | set heat_layout_id=#{layoutId},heat_layout_sort=#{sort} |
| | | where id=#{id}; |
| | | </update> |
| | | |
| | |
| | | <select id="getOptimizeDetailsInfo" resultType="java.util.Map"> |
| | | SELECT |
| | | 0 AS isRemain, |
| | | od.width AS realWidth, |
| | | od.height AS realHeight, |
| | | od.o_width AS realWidth, |
| | | od.o_height AS realHeight, |
| | | od.p_width AS width, |
| | | od.p_height AS height, |
| | | od.process_id AS processId, |
| | |
| | | pp.optimize_config |
| | | WHERE creater = #{username} AND config_type = #{type} |
| | | </select> |
| | | <select id="getGlassProjectList" resultType="java.util.Map" parameterType="java.lang.String"> |
| | | SELECT |
| | | project_no AS projectId, |
| | | tempering_state |
| | | FROM |
| | | pp.optimize_project |
| | | WHERE |
| | | project_no = #{projectId} |
| | | </select> |
| | | |
| | | |
| | | </mapper> |