From df143921e8ec85b43420b71961d73825521911d1 Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期四, 23 十月 2025 10:14:49 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10105/r/ERP_override
---
north-glass-erp/src/main/java/com/example/erp/mapper/pp/GlassOptimizeMapper.java | 232 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 232 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/pp/GlassOptimizeMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/GlassOptimizeMapper.java
new file mode 100644
index 0000000..bd27548
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/pp/GlassOptimizeMapper.java
@@ -0,0 +1,232 @@
+package com.example.erp.mapper.pp;
+
+
+import com.example.erp.entity.pp.*;
+import com.example.erp.entity.sd.OrderGlassDetail;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.sql.Date;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface GlassOptimizeMapper {
+ //宸ョ▼淇℃伅
+ List<Map<String, Object>> projectInfoMp(String projectNo);
+
+ List<Map<String, Object>> firstOptimization(String projectNo);
+
+ List<Map<String, Object>> directOptimization(String projectNo);
+
+ List<Map<String, Object>> analogComputationOptimization(String projectNo);
+
+
+ List<Map<String, Object>> computeAndOptimization(String projectNo);
+
+ List<Map<String, Object>> getOptimizeDetail(String projectNo);
+
+ List<Map<String, Object>> simulatedTypesettingUsingOpt(List<String> processId,List<Integer> technologyNumber);
+
+ //宸ョ▼淇℃伅娴佺▼鍗�
+ List<Map<String, Object>> getProcessCardMp(String projectNo);
+
+ List<FlowCard> getFlowCardList(String projectNo);
+
+ List<PatchLog> getPatchLogList(String projectNo);
+
+ //搴撳瓨淇℃伅
+ List<Map<String, Object>> materialStoreMp(String thickness, String model);
+
+ List<Map<String, Object>> surplusMaterialsMp(String thickness, String model);
+
+ List<Map<String, Object>> materialStoreSurplusMp(String thickness, String model);
+
+ List<Map<String, Object>> materialStoreOptimizeUse(String projectNumber);
+
+ //宸ュ崟绠＄悊鏌ヨ鏈浆宸ュ崟鏁版嵁
+ List<Map<String, Object>> selectWordOrder(Date selectTime1, Date selectTime2, OrderGlassDetail orderGlassDetail);
+
+ //鍒涘缓宸ョ▼鑶滅郴鏌ヨ
+ List<Map<String, Object>> getFlowCardListMp(String optionVal, Integer radio);
+ List<Map<String, Object>> getFlowCardListWhole(String optionVal);
+ List<Map<String, Object>> getFlowCardListNormal(String optionVal);
+ List<Map<String, Object>> getFlowCardListPatch(String optionVal);
+
+ List<Map<String, Object>> getFlowCardListModify(String type,String thickness,String projectNO);
+
+ //宸ョ▼绠＄悊宸ョ▼鍙锋煡璇�
+ List<OptimizeProjectMange> optimizeProjectMangeMp(Date startSelectTime, Date endSelectTime, OptimizeProjectMange optimizeProjectMange);
+
+ //淇敼宸ョ▼鐘舵��
+ Boolean updateProjectStateMp(String projectNumber,Integer state);
+
+ Boolean updateProjectTemperingStateMp(String projectNumber,Integer states);
+
+ Boolean updateProjectOptimizeStateMp(String projectNumber,Integer states);
+
+ List<Map<String, Object>> getProjectListMp();
+
+ //鍒犻櫎宸ョ▼
+ int deleteProjectMp(String projectNumber);
+
+ int deleteOptimizeHeatDetail(String projectNumber);
+
+ int deleteOptimizeHeatLayout(String projectNumber);
+
+ int deleteOptimizeDetail(String projectNumber);
+
+ int deleteOptimizeLayout(String projectNumber);
+
+ int deleteOptimizeProjectFile(String projectNumber);
+
+ int updateOptimizeUse(String projectNumber);
+
+ List<OptimizeHeatDetail> selectOptimizeHeatDetail(String projectNumber);
+
+ OptimizeDetail selectOptimizeDetailById(String projectNumber,String processId,Integer orderSort,Integer layer);
+
+ //妯℃嫙璁＄畻宸ョ▼鍙锋煡璇�
+ List<Map<String, Object>> selectProjectComputeMp(@Param("projectNo")String projectNumber);
+
+ Map<String, Object> selectProjectCount(@Param("projectNo")String projectNumber);
+
+ //妯℃嫙璁＄畻娴佺▼鍗¤鎯�
+ List<Map<String, Object>> selectComputeDetailMp(String processId,Integer technologyNumber);
+
+
+ List<Map<String, Object>> selectComputeDetailMpPatchState(String processId,Integer technologyNumber);
+
+
+ //妯℃嫙璁＄畻淇濆瓨 閽㈠寲鎺掔増璇︽儏
+ void addSimulation(Map<String, Object> object);
+ //妯℃嫙璁＄畻淇濆瓨 閽㈠寲鎺掔増
+ void addratioResult(Map<String, Object> object);
+ //妯℃嫙璁＄畻淇濆瓨 宸ョ▼淇℃伅
+ void addratioProjectResult(Map<String, Object> object);
+
+ void insertOptimizeHeatDetail(String projectId,String processId,Integer technologyNumber,Integer patchState,
+ Integer orderNumber,Double width,Double height,Integer index,String username);
+ //浼樺寲璁剧疆淇濆瓨
+ void optimizeParmsSave(String jsonString,String username);
+
+ void addOptimizeDetail(List<Map<String, Object>> object,String projectId);
+
+ void addOptimizeLayout(List<Map<String, Object>> object,String projectId);
+
+ void addOptimizeProjectFile(String object,String projectId,String name);
+
+ void addOptimizeUse(List<Map<String, Object>> object,String projectId,String name);
+
+ //浼樺寲缁撴灉淇濆瓨
+ void optimizeResultSave(String jsonString);
+ //浼樺寲缁撴灉鏌ヨ
+ List<Map<String, Object>> selectOptimizeResult(String processId);
+ //浼樺寲缁撴灉璋冩暣
+ void updateOptimizeResult(String jsonString,String processId);
+
+ void updateOptimizeDetail(Long id,Integer layoutId,Integer sort);
+
+ List<Map<String, Object>> getProcessCardDetailmMp(String processId, Integer technologyNumber);
+
+ List<Map<String, Object>> selectGlassTypeMp();
+
+ List<Map<String, Object>> getProjectIdSv();
+
+ Boolean updateFlowCardProject(String processId, String technologyNumber, String projectId);
+
+ Boolean updatePatchLogProject(String processId, String technologyNumber, String projectId);
+
+ Boolean updateFlowCardProjectReturn(String processId, String technologyNumber, String projectId);
+
+ Boolean updatePatchLogProjectReturn(String processId, Integer technologyNumber, String projectId);
+
+ Double getSelectArea(String processId, String technologyNumber);
+
+ Double getSelectAreaPatchLog(String processId, String technologyNumber);
+
+ Integer selectPatchLogState(String processId, Integer technologyNumber,Integer orderNumber,String projectNo);
+
+ Boolean addProjectMp(String projectId, String projectNmae, String glassThickness, String glassType,
+ Integer sumQuantity, Double sumArea, String userName,Integer processIdCount, String processId, Integer type);
+
+ Boolean updateProjectMp(String projectId, String projectNmae, String glassThickness, String glassType,
+ Integer sumQuantity, Double sumArea, String userName,Integer processIdCount, String processId, Integer type);
+
+ List<Map<String, Object>> getTemperedConfiguration(String username);
+
+ List<Map<String, Object>> getGrindingTrimming(String username);
+
+ List<Map<String, Object>> getGrindingOptimize(String username);
+
+ List<Map<String, Object>> getEdgeTrimming(String username);
+
+ Boolean updateOptimizeConfig(String json,Integer type,String username);
+
+ List<Map<String, Object>> getFlowCardListSimulated(String optionVal);
+
+
+
+
+ //妯℃嫙璁＄畻宸ョ▼鍙锋煡璇�
+ List<Map<String, Object>> selectProjectComputeMpThirdParty(@Param("projectNo")String projectNumber);
+
+ //妯℃嫙璁＄畻娴佺▼鍗¤鎯�
+ List<Map<String, Object>> selectComputeDetailMpThirdParty(String processId,Integer technologyNumber);
+
+ int deleteOptimizeDetailThirdParty(String projectNumber);
+
+ List<Map<String, Object>> firstOptimizationThirdParty(String projectNo);
+
+ List<Map<String, Object>> analogComputationOptimizationThirdParty(String projectNo);
+
+ //宸ョ▼淇℃伅娴佺▼鍗�
+ List<Map<String, Object>> getProcessCardMpThirdParty(String projectNo);
+
+ List<Map<String, Object>> getProjectByProjectNoSv(String projectNo);
+
+ void updateFlowCardRack(String processId, String technologyNumber, int rackValue);
+
+ Map<String,Object> selectOptimizeProject(String projectNo);
+
+ List<Map<String,Object>> selectOptimizeLayout(String projectNo);
+
+ List<Map<String,Object>> selectOptimizeDetail(String projectNo);
+
+ List<Map<String,Object>> selectFlowCardInfoList(String projectNo);
+
+
+ Map<String, Object> getGlassInfo(String projectId);
+
+ void addOptimizeOffcut(Map<String, Object> map, String projectId, String glassType, String glassThickness);
+
+ List<Map<String, Object>> getOptimizeLayoutsInfo(String processId);
+
+ List<Map<String, Object>> getOptimizeDetailsInfo(String processId);
+
+ List<Map<String, Object>> getOptimizeOffsetsInfo(String processId);
+
+ int deleteOptimizeOffcut(String projectNumber);
+
+ void updateNormalDetails(Map<String, Object> detail, String processId);
+
+ void deleteOffcutDetails(String processId);
+
+ void addUpdateOffcut(Map<String, Object> detail, String processId, String glassType, String glassThickness, int stockId);
+
+ void updateProjectOptimize(String projectId, Integer states, Map<String, Object> optimalResults);
+
+ List<Map<String, Object>> getReportDataProcessIdSv(String processId);
+
+ List<Map<String, Object>> getPeriMeterDataSv(String processId);
+
+ List<Map<String, Object>> getMaterialInfoSv(String processId);
+
+ List<Map<String, Object>> getProductListSv(String processId);
+
+ List<Map<String, Object>> selectProjectList(String processId);
+
+ List<Map<String, Object>> materialOptimizeUse(String processId);
+
+ List<Map<String, Object>> getLayoutSetSv(String processId);
+}
--
Gitblit v1.8.0