package com.dy.pipIrrGlobal.daoRm;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoRm.RmClientAmountDayLast;
import com.dy.pipIrrGlobal.voRm.VoClientAmountDay;
import com.dy.pipIrrGlobal.voSt.VoClient;
import com.dy.pipIrrGlobal.voSt.VoDayClient;
import com.dy.pipIrrGlobal.voSt.VoMonthClient;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

/**
 * @Author: liurunyu
 * @Date: 2024/7/9 14:33
 * @Description
 */
@Mapper
public interface RmClientAmountDayLastMapper extends BaseMapper<RmClientAmountDayLast> {
    /**
     * delete by primary key
     *
     * @param id primaryKey
     * @return deleteCount
     */
    int deleteByPrimaryKey(Long id);

    List<RmClientAmountDayLast> selectByClientId(Long clientId) ;

    /**
     * insert record to table
     *
     * @param record the record
     * @return insert count
     */
    int insert(RmClientAmountDayLast record);

    /**
     * insert record to table selective
     *
     * @param record the record
     * @return insert count
     */
    int insertSelective(RmClientAmountDayLast record);

    /**
     * select by primary key
     *
     * @param id primary key
     * @return object by primary key
     */
    RmClientAmountDayLast selectByPrimaryKey(Long id);

    /**
     * update record selective
     *
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKeySelective(RmClientAmountDayLast record);

    /**
     * update record
     *
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKey(RmClientAmountDayLast record);


    /**
     * 根据指定条件获取记录总数
     * @param params
     * @return
     */
    Long getRecordCount(Map<?, ?> params);

    /**
     * 根据指定条件获取记录
     * @param params
     * @return
     */
    List<VoClientAmountDay> getClientAmountDayLast(Map<?, ?> params);

    /**
     * 统计指定月份各农户各天用水量及消费金额记录数量
     * @param params
     * @return
     */
    Long getDayAmountAndMoneyCount(Map<?, ?> params);

    /**
     * 统计指定月份各农户各天用水量及消费金额
     * @param params
     * @return
     */
    List<VoDayClient> getDayAmountAndMoney(Map<?, ?> params);

    /**
     * 统计指定年份各农户各月用水量及消费金额记录数量
     * @param params
     * @return
     */
    Long getMonthAmountAndMoneyCount(Map<?, ?> params);

    /**
     * 统计指定年份各农户各月用水量及消费金额
     * @param params
     * @return
     */
    List<VoMonthClient> getMonthAmountAndMoney(Map<?, ?> params);

    /**
     * 最近未充值的农户数量
     * @param params
     * @return
     */
    Long getNotRechargeLastClientsCount(Map<String, Object> params);

    /**
     * 最近未充值的农户
     * @param params
     * @return
     */
    List<VoClient> getNotRechargeLastClients(Map<String, Object> params);
}