package com.dy.pipIrrGlobal.daoRm;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.dy.pipIrrGlobal.pojoRm.RmOnHourReportHistory;
|
import com.dy.pipIrrGlobal.voRm.VoOnHour;
|
import com.dy.pipIrrGlobal.voSt.VoIntake;
|
import com.dy.pipIrrGlobal.voSt.VoIntakeAccumulateAmount;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Author: liurunyu
|
* @Date: 2024/6/26 21:32
|
* @Description
|
*/
|
@Mapper
|
public interface RmOnHourReportHistoryMapper extends BaseMapper<RmOnHourReportHistory> {
|
/**
|
* 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(RmOnHourReportHistory record);
|
|
/**
|
* insert record to table selective
|
* @param record the record
|
* @return insert count
|
*/
|
int insertSelective(RmOnHourReportHistory record);
|
|
/**
|
* select by primary key
|
* @param id primary key
|
* @return object by primary key
|
*/
|
RmOnHourReportHistory selectByPrimaryKey(Long id);
|
|
/**
|
* update record selective
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKeySelective(RmOnHourReportHistory record);
|
|
/**
|
* update record
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKey(RmOnHourReportHistory record);
|
|
/**
|
* 根据指定条件获取整点报历史记录数量
|
* @param params
|
* @return
|
*/
|
Long getOnHourReportsCount_history(Map<?, ?> params);
|
|
/**
|
* 根据指定条件获取整点报历史记录
|
* @param params
|
* @return
|
*/
|
List<VoOnHour> getOnHourReports_history(Map<?, ?> params);
|
|
/**
|
* 获取指定时间段内未上线取水口数量
|
* @param params
|
* @return
|
*/
|
Long getNotOnlineIntakesCount(Map<?, ?> params);
|
|
/**
|
* 获取指定时间段内未上线的取水口
|
* @param params
|
* @return
|
*/
|
List<VoIntake> getNotOnlineIntakes(Map<?, ?> params);
|
|
/**
|
* 指定时间段内用水量超过指定值的取水口数量
|
* @param params
|
* @return
|
*/
|
Long getUseWaterGtValueIntakesCount(Map<String, Object> params);
|
|
/**
|
* 指定时间段内用水量超过指定值的取水口
|
* @param params
|
* @return
|
*/
|
List<VoIntakeAccumulateAmount> getUseWaterGtValueIntakes(Map<String, Object> params);
|
}
|
