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