接口提供：根据设备编码，查询本年所有月份的报警数量

zengh

2021-04-08 c4e1404f2e78cde3b807e030cf466f956b0de169

接口提供：根据设备编码，查询本年所有月份的报警数量

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/controller/AlarmController.java

@@ -602,4 +602,22 @@
        return null;
    }


    /**
     * 查询本年所有月份的警情数量
     * @param response 跨域配置
     * @param deviceNumber 条件
     * @return
     */
    @GetMapping("/queryYearAlarm")
    public List<Map<String, Object>> queryYearAlarm(HttpServletResponse response, String deviceNumber) {
        response.setHeader("Access-Control-Allow-Origin", "*");
        response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
        response.setHeader("Access-Control-Allow-Credentials","true");

        List<Map<String,Object>> list = alarmService.queryYearAlarm(deviceNumber);

        return list;
    }

}

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

@@ -107,4 +107,7 @@
     */
    @SqlParser(filter = true)
    List<Integer> selectAlarmTimeData(@Param("conditionVo")ConditionVo conditionVo);

    List<Map<String, Object>> queryYearAlarm(String deviceNumber,List childList);

}

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

@@ -494,4 +494,26 @@
        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}

            </foreach>
        </if>

    </select>
</mapper>

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/IAlarmService.java

@@ -111,4 +111,11 @@
     * @return
     */
    Map<String, Object> selectAlarmTimeData(ConditionVo conditionVo);

    /**
     * 根据编号查询本年所有月份的报警数
     * @param deviceNumber
     * @return
     */
    List<Map<String, Object>> queryYearAlarm(String deviceNumber);
}

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/impl/AlarmServiceImpl.java

@@ -365,4 +365,15 @@
        //返回数据
        return map;
    }

    @Override
    public List<Map<String, Object>> queryYearAlarm(String deviceNumber) {
        List childList = new ArrayList();
        for (int i = 1; i <= 12; i++) {
            childList.add(i);
        }

        return baseMapper.queryYearAlarm(deviceNumber,childList);
    }

}