接口提供：根据设备编码

zengh

2021-04-09 6971c195601ecc91b2b7b52af83efed9956dcfe0

接口提供：根据设备编码

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/mapper/AlarmMapper.xml

@@ -492,4 +492,28 @@
        on
        a.days = b.datetime
    </select>


    <!--查询本年所有月份的预警数量-->
    <select id="queryYearAlarm" resultType="java.util.HashMap">

        <if test="childList!=null and childList.size>0">

            <foreach collection="childList" index="index" item="item" open="" separator="union all" close="">
                SELECT
                #{item} as month,count(ce.id) as count
                FROM
                sys_alarm as ce
                WHERE
                YEAR ( alarmTime ) = date_format(now(),'%Y%')
                AND MONTH ( alarmTime ) = #{item}

                AND waringType = "紧急求救"
                AND deviceNumber = #{deviceNumber}

            </foreach>
        </if>

    </select>

</mapper>