2024-08-06 朱宝民 优化代码

Administrator

2024-08-06 617fbf342de25d3e07629b9107b2f035101ee8da

2024-08-06 朱宝民 优化代码

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseValveHistoryMapper.xml

@@ -791,9 +791,10 @@
    <select id="getLargeWaterConsumptionClientsCount" resultType="java.lang.Long">
        SELECT COUNT(*) AS recordCount
        FROM se_client cli
                 INNER JOIN rm_open_close_valve_history his ON his.client_id = cli.id
        WHERE his.op_dt BETWEEN #{timeStart} AND #{timeStop}
          AND his.cl_this_amount > #{waterConsumption}
        WHERE (SELECT SUM(his.cl_this_amount)
               FROM rm_open_close_valve_history his
               WHERE his.client_id = cli.id
                 AND his.op_dt BETWEEN #{timeStart} AND #{timeStop}) > #{waterConsumption}
    </select>

    <!--获取指定时间段内用水量超过指定值的农户-->
@@ -805,9 +806,10 @@
               cli.phone,
               cli.idCard
        FROM se_client cli
                 INNER JOIN rm_open_close_valve_history his ON his.client_id = cli.id
        WHERE his.op_dt BETWEEN #{timeStart} AND #{timeStop}
          AND his.cl_this_amount > #{waterConsumption}
        WHERE (SELECT SUM(his.cl_this_amount)
               FROM rm_open_close_valve_history his
               WHERE his.client_id = cli.id
                 AND his.op_dt BETWEEN #{timeStart} AND #{timeStop}) > #{waterConsumption}
        ORDER BY cli.id
        <trim prefix="limit ">
            <if test="start != null and count != null">
@@ -820,9 +822,10 @@
    <select id="getLargeAmountSpentClientsCount" resultType="java.lang.Long">
        SELECT COUNT(*) AS recordCount
        FROM se_client cli
                 INNER JOIN rm_open_close_valve_history his ON his.client_id = cli.id
        WHERE his.op_dt BETWEEN #{timeStart} AND #{timeStop}
          AND his.cl_this_money > #{amountSpent}
        WHERE (SELECT SUM(his.cl_this_money)
               FROM rm_open_close_valve_history his
               WHERE his.client_id = cli.id
                 AND his.op_dt BETWEEN #{timeStart} AND #{timeStop}) > #{amountSpent}
    </select>
    <!--获取指定时间段内消费金额超过指定值的农户-->
    <select id="getLargeAmountSpentClients" resultType="com.dy.pipIrrGlobal.voSt.VoClient">
@@ -833,9 +836,10 @@
               cli.phone,
               cli.idCard
        FROM se_client cli
                 INNER JOIN rm_open_close_valve_history his ON his.client_id = cli.id
        WHERE his.op_dt BETWEEN #{timeStart} AND #{timeStop}
          AND his.cl_this_money > #{amountSpent}
        WHERE (SELECT SUM(his.cl_this_money)
               FROM rm_open_close_valve_history his
               WHERE his.client_id = cli.id
                 AND his.op_dt BETWEEN #{timeStart} AND #{timeStop}) > #{amountSpent}
        ORDER BY cli.id
        <trim prefix="limit ">
            <if test="start != null and count != null">
@@ -848,9 +852,10 @@
    <select id="getLargeWaterDurationClientsCount" resultType="java.lang.Long">
        SELECT COUNT(*) AS recordCount
        FROM se_client cli
                 INNER JOIN rm_open_close_valve_history his ON his.client_id = cli.id
        WHERE his.op_dt BETWEEN #{timeStart} AND #{timeStop}
          AND his.cl_this_time > #{waterDuration}
        WHERE (SELECT SUM(his.cl_this_time)
               FROM rm_open_close_valve_history his
               WHERE his.client_id = cli.id
                 AND his.op_dt BETWEEN #{timeStart} AND #{timeStop}) > #{waterDuration}
    </select>

    <!--获取指定时间段内用水时长超过指定值的农户-->
@@ -862,9 +867,10 @@
               cli.phone,
               cli.idCard
        FROM se_client cli
                 INNER JOIN rm_open_close_valve_history his ON his.client_id = cli.id
        WHERE his.op_dt BETWEEN #{timeStart} AND #{timeStop}
          AND his.cl_this_time > #{waterDuration}
        WHERE (SELECT SUM(his.cl_this_time)
               FROM rm_open_close_valve_history his
               WHERE his.client_id = cli.id
                 AND his.op_dt BETWEEN #{timeStart} AND #{timeStop}) > #{waterDuration}
        ORDER BY cli.id
        <trim prefix="limit ">
            <if test="start != null and count != null">