package com.dy.pipIrrGlobal.daoRm;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.dy.pipIrrGlobal.pojoRm.RmClientAmountDay;
|
import com.dy.pipIrrGlobal.voRm.VoClientAmountDay;
|
import com.dy.pipIrrGlobal.voSt.VoClientAmountStatistics;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Author: liurunyu
|
* @Date: 2024/7/9 14:33
|
* @Description
|
*/
|
@Mapper
|
public interface RmClientAmountDayMapper extends BaseMapper<RmClientAmountDay> {
|
/**
|
* 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(RmClientAmountDay record);
|
|
/**
|
* insert record to table selective
|
*
|
* @param record the record
|
* @return insert count
|
*/
|
int insertSelective(RmClientAmountDay record);
|
|
/**
|
* select by primary key
|
*
|
* @param id primary key
|
* @return object by primary key
|
*/
|
RmClientAmountDay selectByPrimaryKey(Long id);
|
|
/**
|
* select by primary key
|
*
|
* @param clientId clientId
|
* @param dt dt
|
* @return objects by ByClientAndDate
|
*/
|
List<RmClientAmountDay> selectByClientAndDate(@Param("clientId")Long clientId, @Param("dt")Date dt) ;
|
|
/**
|
* update record selective
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKeySelective(RmClientAmountDay record);
|
|
/**
|
* update record
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKey(RmClientAmountDay record);
|
|
/**
|
* 根据指定条件获取记录总数
|
* @param params
|
* @return
|
*/
|
Long getRecordCount(Map<?, ?> params);
|
|
/**
|
* 根据指定条件获取记录
|
* @param params
|
* @return
|
*/
|
List<VoClientAmountDay> getClientAmountDayHistory(Map<?, ?> params);
|
|
|
/**
|
* 以农户维度统计用水量及费用
|
* @param statisticsStartId 统计时间段开始时间对应的ID
|
* @param statisticsEndId 统计时间段截止时间对应的ID
|
* @return
|
*/
|
List<VoClientAmountStatistics> statisticsByClient(@Param("startId")Long statisticsStartId, @Param("endId")Long statisticsEndId) ;
|
|
}
|
