package com.thhy.mobile.modules.biz.pipeinfo.mapper; import com.thhy.mobile.modules.biz.checkhistory.entity.*; import com.thhy.mobile.modules.biz.cultivated.entity.PipeCultivated; import com.thhy.mobile.modules.biz.cultivated.entity.PipeIntoListVo; import com.thhy.mobile.modules.biz.mouldcheck.entity.Mould; import com.thhy.mobile.modules.biz.mouldcheck.entity.MouldFree; import com.thhy.mobile.modules.biz.mouldcheck.entity.RingCompleteCheck; import com.thhy.mobile.modules.biz.pipecheckrecord.entity.MaterialStockRecord; import com.thhy.mobile.modules.biz.pipeinfo.entity.*; import com.thhy.mobile.modules.biz.repo.entity.RepoRecord; import com.thhy.mobile.modules.biz.steelproduce.entity.ProduceDto; import com.thhy.mobile.modules.biz.steelproduce.entity.ProduceMonthVo; import com.thhy.mobile.modules.biz.temdevice.entity.DeviceInfo; import com.thhy.mobile.modules.biz.temdevice.entity.RestDto; import org.apache.ibatis.annotations.MapKey; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Component; import java.io.Serializable; import java.util.HashMap; import java.util.List; import java.util.Map; /** * Mapper 接口 * @author zhang_xiao_bo * @since 2023-05-08 15:28:37 */ @Component public interface PipeInfoMapper { PipeInfo queryById(Serializable pipeId); PipeInfo queryByPipeNum(String pipeNum); int countByPipeInfo(String proId); int queryMaxPipeNumByProId(String proId); Integer queryVersionById(Serializable pipeId); List findList(PipeInfo pipeinfo); List screenFindList(PipeInfo pipeinfo); List pipelist(PipeDto pipeDto); PipeInfoVo queryPipeInfoByPipeId(PipeDto pipeDto); List queryByRingNum(String ringNum); List findAll(); void insert(PipeInfo pipeinfo); void update(PipeInfo pipeinfo); void deletelogic(Serializable pipeId); void deleteById(Serializable pipeId); RingCompleteCheck queryRingComplete(PipeInfo pipeinfo); List queryRingCompleteByMod(@Param("mouldNum") String mouldNum,@Param("proId") String proId); int queryMaxRingNum(String companyId); void updateCheckResult(PipeInfo pipeInfo); List pipeMonthData(ProduceDto produceDto); List pipeCompare(ProduceDto produceDto); List pipeCompareByPro(ProduceDto produceDto); List checkHistoryList(CheckHisDto checkHisDto); SteelInfoVo hisSteelInfo(String produceNumber); List leastMixStation(); void deleteBySteelProNum(String produceNumber); int queryIsCheckBySteelNum(String produceNumber); WaterCulInfoVo queryWaterByRingNum(String ringNum); void updatePipeOutMod(String pipeNum); void updatePipeInRepo(String pipeNum); void updateModCheck(@Param("modId") String modId); void updateSysMouldFree(MouldFree mouldFree); int RepoRecordCountByPipeNum(String pipeNum); RepoInfoVo RepoRecordByPipeNum(String pipeNum); OutInfoVo PipeOutInfo(String pipeId); int ringCompleteByRingNum(String ringNum); ProblemInfoVo problemInfo(PipeDto pipeDto); String queryReasons(@Param("idList") String[] idList); void updateProblem(ProblemInfoVo problemInfoVo); List checkfiles(String pipeCheckId); List querySteelByPRSB(PipeInfo pipeInfo); List pipeThingJsInfo(String companyId); ModIdlThing modIdlThing(@Param("modId") String modId); SteelProduceThing steelProduceThing(String produceNumber); void pipeIdOutUpdate(String pipeId); List queryAllProject(); List queryPipeDeplete(PipeInfo pipeInfo); MaterialInfo queryMaterStock(@Param("materialName") String materialName,@Param("companyId") String companyId); void updateMaterStock(@Param("materialName") String materialName,@Param("materialValue") double materialValue,@Param("companyId") String companyId); void updateMaterStockRecord(MaterialStockRecord materialStockRecord); List materialTotalStock(String companyId); List> TableHeader(); List> queryMaterias(String companyId); @MapKey("node") Map queryDeviceBySn(String snCode); void updateDeviceStatus(@Param("deviceStatus") int deviceStatus,@Param("snCode") String snCode); void insertRestData(RestDto restDto); void insertWaterData(RestDto restDto); void updateRingNum(@Param("ringNum") String ringNum,@Param("newRingNum") String newRingNum); List queryBlockByPro(String proId); List queryMouldTypeByPro(String proId); List queryMouldByNumType(@Param("proId")String proId,@Param("numType")Integer numType); int queryMaxNumBySteelProduce(); int countByRingNum(String ringNum); Boolean compelteByRingNumAndPro(@Param("ringNum")String ringNum,@Param("proId")String proId); List queryByRingNumAndPro(@Param("ringNum") String ringNum,@Param("proId") String proId); PipeCultivated queryWaterTimeByPipeNum(String pipeNum); RepoRecord queryRepoDate(String pipeNum); void updatePipeDateByNum(PipeDateDto pipeDateDto); void updateInWaterTime(PipeCultivated pipeCultivated); void updateOutWaterTime(PipeCultivated pipeCultivated); void updateInRepoTime(RepoRecord repoRecord); List queryAllNumType(); List materialInfo(); List materialNumInfo(); List materialInfoTwo(); }