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