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