优化未关阀记录接口2

zhubaomin

2024-11-13 1ba46471b7831f057991ad92573463488504b20e

优化未关阀记录接口2

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

@@ -275,7 +275,7 @@
                )
            ) rtus ON com.rtu_addr = rtus.rtuAddr
        <where>
            AND com.com_id in #{comIds}
            AND    com.com_id in (#{comIds})

            AND (
                SELECT op_dt FROM rm_open_close_valve_last

 pipIrr-platform/pipIrr-web/pipIrr-web-remote/src/main/java/com/dy/pipIrrRemote/common/CommandSv.java

@@ -137,7 +137,7 @@
        //    return new ArrayList<>();
        }

        List<VoUnclosedValve> res = rmCommandHistoryMapper.getUnclosedValves(jsonArray.toJSONString(), operator);
        List<VoUnclosedValve> res = rmCommandHistoryMapper.getUnclosedValves2(jsonArray.toJSONString(), operator);
        if(res != null) {
            return res;
        } else {

 pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/command/CommandSv.java

@@ -133,7 +133,7 @@
        }

        if(comIds.length() > 0) {
            comIds = "(" + comIds.substring(0,comIds.length()) + ")";
            comIds = comIds.substring(0,comIds.length()-1);
            List<VoUnclosedValve> res = rmCommandHistoryMapper.getUnclosedValves(jsonArray.toJSONString(), comIds);
            if(res != null) {
                return res;