|  |  | 
 |  |  |  | 
 |  |  | import com.baomidou.mybatisplus.core.mapper.BaseMapper; | 
 |  |  | import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseValveHistory; | 
 |  |  | import com.dy.pipIrrGlobal.voRm.VoExpend; | 
 |  |  | import com.dy.pipIrrGlobal.voRm.VoOpenCloseValve; | 
 |  |  | import com.dy.pipIrrGlobal.voSt.VoClient; | 
 |  |  | import com.dy.pipIrrGlobal.voSt.VoIntake; | 
 |  |  | import com.dy.pipIrrGlobal.voSt.VoIntakeAccumulateAmount; | 
 |  |  | import com.dy.pipIrrGlobal.voSt.VoIntakeOpenCount; | 
 |  |  | import com.dy.pipIrrGlobal.voRm.VoOpenClostWechat; | 
 |  |  | import com.dy.pipIrrGlobal.voSt.*; | 
 |  |  | import org.apache.ibatis.annotations.Mapper; | 
 |  |  | import org.apache.ibatis.annotations.Param; | 
 |  |  |  | 
 |  |  | import java.util.Date; | 
 |  |  | import java.util.List; | 
 |  |  | import java.util.Map; | 
 |  |  |  | 
 |  |  | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntake> getNeverOpenValveIntakes(Map<?, ?> params); | 
 |  |  |     List<VoIntakeUnOpenValve> getNeverOpenValveIntakes(Map<?, ?> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内开阀次数超过指定值的取水口数量 | 
 |  |  | 
 |  |  |     List<VoClient> getLargeWaterConsumptionClients(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内用水量低于指定值的农户数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getSmallWaterConsumptionClientsCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内用水量低于指定值的农户 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoClient> getSmallWaterConsumptionClients(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内消费金额超过指定值的农户数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoClient> getLargeAmountSpentClients(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内消费金额低于指定值的农户数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getSmallAmountSpentClientsCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内消费金额低于指定值的农户 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoClient> getSmallAmountSpentClients(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取指定时间段内用水时长超过指定值的农户数量 | 
 |  |  | 
 |  |  |     List<VoClient> getLargeWaterDurationClients(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段用水量超过指定值的取水口数量 | 
 |  |  |      * 获取指定时间段内用水时长低于指定值的农户数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getUseWaterGtValueIntakesCount(Map<String, Object> params); | 
 |  |  |     Long getSmallWaterDurationClientsCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段用水量超过指定值的取水口 | 
 |  |  |      * 获取指定时间段内用水时长低于指定值的农户 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntakeAccumulateAmount> getUseWaterGtValueIntakes(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段内消费金额超过指定值的取水口的数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getExpenseGtValueIntakesCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段内消费金额超过指定值的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntakeAccumulateAmount> getExpenseGtValueIntakes(Map<String, Object> params); | 
 |  |  |     List<VoClient> getSmallWaterDurationClients(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段内用水时长超过指定值的取水口数量 | 
 |  |  | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntakeOpenCount> getUseWaterDurationGtValueIntakes(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段 有开阀 无关阀的取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getHaveOpenNoCloseIntakesCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段 有开阀 无关阀的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntake> getHaveOpenNoCloseIntakes(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段 无开阀 有关阀的取水口数量 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getNoOpenHaveCloseIntakesCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 指定时间段 无开阀 有关阀的取水口 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIntake> getNoOpenHaveCloseIntakes(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取水卡消费记录数量,管理平台使用 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getExpendsCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取水卡消费记录,管理平台使用 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoExpend> getExpends(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取物理卡开关阀记录数量,微信小程序使用 | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getCardOpenCloseCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取物理卡开关阀记录,微信小程序使用 | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoOpenClostWechat> getCardOpenClose(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取虚拟卡开关阀记录数量,微信小程序使用 | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     Long getVcCardOpenCloseCount(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 获取虚拟卡开关阀记录,微信小程序使用 | 
 |  |  |      * @param params | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoOpenClostWechat> getVcCardOpenClose(Map<String, Object> params); | 
 |  |  |  | 
 |  |  |     ////////////////////////////////////////// | 
 |  |  |     //                                      // | 
 |  |  |     //统计相关                                // | 
 |  |  |     //                                      // | 
 |  |  |     ////////////////////////////////////////// | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 以农户、农户IC卡为单位进行统计 | 
 |  |  |      * @param startDt | 
 |  |  |      * @param endDt | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoIcConsumeStatistics> statisticsByIc(@Param("startDt")Date startDt, @Param("endDt")Date endDt); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 以农户为单位进行统计 | 
 |  |  |      * @param startDt | 
 |  |  |      * @param endDt | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     List<VoClientConsumeStatistics> statisticsByClient(@Param("startDt")Date startDt, @Param("endDt")Date endDt); | 
 |  |  | } |