去除 电源alm_cleared_type筛选

whycxzp

2021-10-12 54a03bb6042a1b3151cd4258e7ceb844df3b302a

去除 电源alm_cleared_type筛选

 src/main/resources/mapper/BatteryDataMapper.xml

@@ -22,7 +22,6 @@
                    LEFT OUTER JOIN db_user.tb_user_inf ON tb_user_inf.uid = db_user.tb_user_battgroup_baojigroup_usr.uid
                WHERE
                    db_user.tb_user_inf.uid =#{userId}
                    AND db_battinf.tb_battinf.station_install = 1
                )
    </select>
    <select id="getBatteryCap" resultType="com.whyc.pojo.BatteryRTState">
@@ -45,8 +44,6 @@
                    LEFT OUTER JOIN db_user.tb_user_inf ON tb_user_inf.uid = db_user.tb_user_battgroup_baojigroup_usr.uid
                WHERE
                    db_user.tb_user_inf.uid = #{userId}

                    AND db_battinf.tb_battinf.station_install = 1
                )
    </select>
    <select id="getMonVolAndTemp" resultType="com.whyc.dto.DataAnalysisFloatDTO"></select>

 src/main/resources/mapper/PowerAlarmMapper.xml

@@ -7,7 +7,6 @@
        select alm_type as alarmType,count(alm_type) as num
        from db_pwrdev_alarm.tb_pwrdev_alarm alarm,db_pwrdev_inf.tb_pwrdev_inf inf
        where alarm.PowerDeviceId = inf.PowerDeviceId
        and alm_cleared_type=0
        and alm_type in
        <foreach collection="types" separator="," open="(" close=")" item="alarm_type">
            #{alarm_type}
@@ -44,7 +43,6 @@
        select count(distinct StationId) as num
        from db_pwrdev_alarm.tb_pwrdev_alarm alarm,db_pwrdev_inf.tb_pwrdev_inf inf
        where alarm.PowerDeviceId = inf.PowerDeviceId
        and alm_cleared_type=0
        and alm_type in
        <foreach collection="types" separator="," open="(" close=")" item="alarm_type">
            #{alarm_type}