Merge branch 'master' of http://8.140.179.55:20000/r/pipIrr-SV

wuzeyu

2024-08-06 7bd7091b7ee72a2bb5737943af47862dbb272bfe

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseValveHistoryMapper.java

@@ -2,8 +2,14 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseValveHistory;
import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseValveLast;
import com.dy.pipIrrGlobal.voRm.VoOpenCloseValve;
import com.dy.pipIrrGlobal.voSt.VoClient;
import com.dy.pipIrrGlobal.voSt.VoIntake;
import com.dy.pipIrrGlobal.voSt.VoIntakeOpenCount;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

/**
 * @Author: liurunyu
@@ -59,4 +65,131 @@
     * @return update count
     */
    int updateByPrimaryKey(RmOpenCloseValveHistory record);

    /**
     * 根据指定条件获取开关阀报历史记录数量
     * @param params
     * @return
     */
    Long getOpenCloseValveReportsCount_history(Map<?, ?> params);

    /**
     * 根据指定条件获取开关阀报历史记录
     * @param params
     * @return
     */
    List<VoOpenCloseValve> getOpenCloseValveReports_history(Map<?, ?> params);


    /**
     * 获取指定时间段内从未开过阀的取水口数量
     * @param params
     * @return
     */
    Long getNeverOpenValveIntakesCount(Map<?, ?> params);

    /**
     * 获取指定时间段内从未开过阀的取水口
     * @param params
     * @return
     */
    List<VoIntake> getNeverOpenValveIntakes(Map<?, ?> params);

    /**
     * 获取指定时间段内开阀次数超过指定值的取水口数量
     * @param params
     * @return
     */
    Long getOpenValveGtIntakesCount(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数超过指定值的取水口
     * @param params
     * @return
     */
    List<VoIntakeOpenCount> getOpenValveGtIntakes(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数低于指定值的取水口数量
     * @param params
     * @return
     */
    Long getOpenValveLtIntakesCount(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数低于指定值的取水口
     * @param params
     * @return
     */
    List<VoIntakeOpenCount> getOpenValveLtIntakes(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数超过指定值的农户数量
     * @param params
     * @return
     */
    Long getLargeOpenCountClientsCount(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数超过指定值的农户
     * @param params
     * @return
     */
    List<VoClient> getLargeOpenCountClients(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数低于指定值的农户数量
     * @param params
     * @return
     */
    Long getSmallOpenCountClientsCount(Map<String, Object> params);

    /**
     * 获取指定时间段内开阀次数低于指定值的农户
     * @param params
     * @return
     */
    List<VoClient> getSmallOpenCountClients(Map<String, Object> params);

    /**
     * 获取指定时间段内用水量超过指定值的农户数量
     * @param params
     * @return
     */
    Long getLargeWaterConsumptionClientsCount(Map<String, Object> params);

    /**
     * 获取指定时间段内用水量超过指定值的农户
     * @param params
     * @return
     */
    List<VoClient> getLargeWaterConsumptionClients(Map<String, Object> params);

    /**
     * 获取指定时间段内消费金额超过指定值的农户数量
     * @param params
     * @return
     */
    Long getLargeAmountSpentClientsCount(Map<String, Object> params);

    /**
     * 获取指定时间段内消费金额超过指定值的农户
     * @param params
     * @return
     */
    List<VoClient> getLargeAmountSpentClients(Map<String, Object> params);

    /**
     * 获取指定时间段内用水时长超过指定值的农户数量
     * @param params
     * @return
     */
    Long getLargeWaterDurationClientsCount(Map<String, Object> params);

    /**
     * 获取指定时间段内用水时长超过指定值的农户
     * @param params
     * @return
     */
    List<VoClient> getLargeWaterDurationClients(Map<String, Object> params);
}