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

    String selectConfigByUserAndType(String username, int type);

    void insertOptimizeConfig(String json, int type, String userName, String configName);

    Map<String, Object> getGlassProjectList(String projectId);
}