| | |
| | | package com.example.erp.mapper.pp; |
| | | |
| | | |
| | | import com.example.erp.entity.pp.OptimizeProjectMange; |
| | | 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; |
| | |
| | | |
| | | @Mapper |
| | | public interface GlassOptimizeMapper { |
| | | //工程信息 |
| | | List<Map<String, Object>> projectInfoMp(String projectNo); |
| | | |
| | | List<Map<String, Object>> firstOptimization(String projectNo); |
| | | |
| | | List<Map<String, Object>> analogComputationOptimization(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<OrderGlassDetail> selectWordOrder(Date selectTime1, Date selectTime2, OrderGlassDetail orderGlassDetail); |
| | | 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); |
| | | List<Map<String, Object>> getProjectListMp();} |
| | | |
| | | 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>> 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); |
| | | |
| | | } |