package com.dy.pipIrrGlobal.daoSe;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoSe.SeRechargeHistory;
import com.dy.pipIrrGlobal.voSt.VoClientRechargeStatistics;
import com.dy.pipIrrGlobal.voSt.VoIcRechargeStatistics;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author ZhuBaoMin
 * @date 2023/12/23 8:47
 * @LastEditTime 2023/12/23 8:47
 * @Description
 */

@Mapper
public interface SeRechargeHistoryMapper extends BaseMapper<SeRechargeHistory> {
    int deleteByPrimaryKey(Long id);

    int insert(SeRechargeHistory record);

    int insertSelective(SeRechargeHistory record);

    SeRechargeHistory selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(SeRechargeHistory record);

    int updateByPrimaryKey(SeRechargeHistory record);

    /**
     * 依据水卡ID将最后一条无效状态的充值历史记录改为有效
     * @param cardId
     * @return
     */
    Integer turnRechargeHistoryValidByCardId(@Param("cardId") Long cardId);


    ///////////////////////////////
    //统计相关

    /**
     * 以农户和IC卡为单位统计一日的充值
     * @param statisticsStartId
     * @param statisticsEndId
     * @return
     */
    List<VoIcRechargeStatistics> statisticsByIc(@Param("startId")Long statisticsStartId, @Param("endId")Long statisticsEndId) ;
    /**
     * 以农户为单位统计一日的充值
     * @param statisticsStartId
     * @param statisticsEndId
     * @return
     */
    List<VoClientRechargeStatistics> statisticsByClient(@Param("startId")Long statisticsStartId, @Param("endId")Long statisticsEndId) ;

}