修改统计中sql的bug

liurunyu

2025-01-15 55312d4e4877e8dfbc911221a56706ba0922bb8f

修改统计中sql的bug

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

@@ -611,7 +611,7 @@
                     inta.name AS intakeNum,
                     blo.name  AS blockName
              FROM pr_intake inta
              LEFT JOIN (SELECT intake_id
              INNER JOIN (SELECT intake_id
                          FROM rm_open_close_valve_history
                          WHERE id <![CDATA[>=]]> #{idStart} AND id <![CDATA[<=]]> #{idEnd}
              ) his ON his.intake_id = inta.id
@@ -629,7 +629,7 @@
               inta.lat  AS lat,
               blo.name  AS blockName
        FROM pr_intake inta
        LEFT JOIN(SELECT intake_id
        INNER JOIN(SELECT intake_id
                   FROM rm_open_close_valve_history
                   WHERE id <![CDATA[>=]]> #{idStart} AND id <![CDATA[<=]]> #{idEnd}
        ) his ON his.intake_id = inta.id