| New file | 
 |  |  | 
 |  |  | package com.dy.pipIrrGlobal.daoRm; | 
 |  |  |  | 
 |  |  | import com.baomidou.mybatisplus.core.mapper.BaseMapper; | 
 |  |  | import com.dy.pipIrrGlobal.pojoRm.RmOnHourReportLast; | 
 |  |  | import com.dy.pipIrrGlobal.voRm.VoOnHour; | 
 |  |  | import com.dy.pipIrrGlobal.voSt.*; | 
 |  |  | import org.apache.ibatis.annotations.Mapper; | 
 |  |  |  | 
 |  |  | import java.util.List; | 
 |  |  | import java.util.Map; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  |  * @Author: liurunyu | 
 |  |  |  * @Date: 2024/6/26 21:15 | 
 |  |  |  * @Description | 
 |  |  |  */ | 
 |  |  | @Mapper | 
 |  |  | public interface RmOnHourReportLastMapper extends BaseMapper<RmOnHourReportLast> { | 
 |  |  |     /** | 
 |  |  |      * delete by primary key | 
 |  |  |      * @param id primaryKey | 
 |  |  |      * @return deleteCount | 
 |  |  |      */ | 
 |  |  |     int deleteByPrimaryKey(Long id); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * insert record to table | 
 |  |  |      * @param record the record | 
 |  |  |      * @return insert count | 
 |  |  |      */ | 
 |  |  |     int insert(RmOnHourReportLast record); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * insert record to table selective | 
 |  |  |      * @param record the record | 
 |  |  |      * @return insert count | 
 |  |  |      */ | 
 |  |  |     int insertSelective(RmOnHourReportLast record); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * select by primary key | 
 |  |  |      * @param id primary key | 
 |  |  |      * @return object by primary key | 
 |  |  |      */ | 
 |  |  |     RmOnHourReportLast selectByPrimaryKey(Long id); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * update record selective | 
 |  |  |      * @param record the updated record | 
 |  |  |      * @return update count | 
 |  |  |      */ | 
 |  |  |     int updateByPrimaryKeySelective(RmOnHourReportLast record); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * update record | 
 |  |  |      * @param record the updated record | 
 |  |  |      * @return update count | 
 |  |  |      */ | 
 |  |  |     int updateByPrimaryKey(RmOnHourReportLast record); | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据阀控器地址获取整点上报最新数据 | 
 |  |  |      * @param intakeId | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<RmOnHourReportLast> getRmOnHourReportLast(Long intakeId); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取整点报最新记录数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getOnHourReportsCount_last(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据指定条件获取整点报最新记录 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoOnHour> getOnHourReports_last(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取累计流量超过指定值的取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getLargeFlowIntakesCount(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取累计流量超过指定值的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoCumulativeFlow> getLargeFlowIntakes(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取累计流量低于指定值的取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getSmallFlowIntakesCount(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取累计流量低于指定值的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoCumulativeFlow> getSmallFlowIntakes(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取欠压取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getUnderVoltIntakesCount(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取欠压取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoBatteryVolt> getUnderVoltIntakes(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定信号强度的取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getSpecifiedSignalIntakesCount(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定信号强度的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoSignalIntensity> getSpecifiedSignalIntakes(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 最近未报数的取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getUnReportedIntakesCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 最近未报数的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntakeUnReported> getUnReportedIntakes(Map<String, Object> params); | 
 |  |  | } |