zhubaomin
2025-04-09 80e22bcc7af8aebed7443965655542fbe4966708
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeRechargeHistoryMapper.java
@@ -2,12 +2,17 @@
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
 */
@@ -24,4 +29,31 @@
    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) ;
}