| | |
| | | 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/19 10:35 |
| | | * @LastEditTime 2023/12/19 10:35 |
| | | * @date 2023/12/23 8:47 |
| | | * @LastEditTime 2023/12/23 8:47 |
| | | * @Description |
| | | */ |
| | | public interface SeRechargeHistoryMapper { |
| | | |
| | | @Mapper |
| | | public interface SeRechargeHistoryMapper extends BaseMapper<SeRechargeHistory> { |
| | | int deleteByPrimaryKey(Long id); |
| | | |
| | | int insert(SeRechargeHistory record); |
| | |
| | | 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) ; |
| | | |
| | | } |