年度关键过程日志情况分析

最新推荐文章于 2024-08-10 17:19:19 发布

qq_41868957

最新推荐文章于 2024-08-10 17:19:19 发布

阅读量58

点赞数

分类专栏： zq-o 文章标签：蓝桥杯 linq webview

本文链接：https://blog.csdn.net/qq_41868957/article/details/125350483

版权

zq-o 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

该博客内容涉及一个关键日志完整性分析的年度过程，主要通过API接口进行操作。Controller层接收请求，调用Service层进行处理。ServiceImpl中从数据库获取一年中各个月份的日志数量，并封装成趋势数据返回。Mapper接口使用SQL查询语句，根据日期类型汇总不同月份的日志数。

摘要由CSDN通过智能技术生成

controller:

/**
 * 关键日志完整性分析-年度关键过程日志情况分析
 * @param query
 * @return
 */
@ApiOperation(value = "年度关键过程日志情况分析")
@PostMapping("/yearProcessLogAnalysis")
public RespBean<List<TrendPo>> yearProcessLogAnalysis(@RequestBody DataQualityAnalysisQuery query){
    return dataIntegrityAnalysisService.yearProcessLogAnalysis(query);
}

service:

RespBean yearProcessLogAnalysis(DataQualityAnalysisQuery query);

serviceimpl:

@Override
    public RespBean yearProcessLogAnalysis(DataQualityAnalysisQuery query) {
        String dateType = query.getDateType();
        Map<String, BigDecimal> yearProcessLog = otaStatisticsMapper.getYearProcessLog(dateType);
        List<TrendPo> list = new ArrayList<>();
        List<BigDecimal> numlist = new ArrayList<BigDecimal>(yearProcessLog.values());
        List<String> datelist = new ArrayList<String>(yearProcessLog.keySet());
        TrendPo result = new TrendPo();
        result.setNumList(numlist);
        result.setDateList(datelist);
//        list.add(numlist);
//        list.add(datelist);
        return RespBean.ok("年度关键过程日志情况分析", result);
    }

mapper:

LinkedHashMap<String, BigDecimal> getYearProcessLog(String toyear);

XML:

<select id="getYearProcessLog" resultType="java.util.LinkedHashMap">
    select
        sum(case month(date) when '1'  then log_num else 0 end) as "1月",
        sum(case month(date) when '2'  then log_num else 0 end) as "2月",
        sum(case month(date) when '3'  then log_num else 0 end) as "3月",
        sum(case month(date) when '4'  then log_num else 0 end) as "4月",
        sum(case month(date) when '5'  then log_num else 0 end) as "5月",
        sum(case month(date) when '6'  then log_num else 0 end) as "6月",
        sum(case month(date) when '7'  then log_num else 0 end) as "7月",
        sum(case month(date) when '8'  then log_num else 0 end) as "8月",
        sum(case month(date) when '9'  then log_num else 0 end) as "9月",
        sum(case month(date) when '10' then log_num  else 0 end) as "10月",
        sum(case month(date) when '11' then log_num  else 0 end) as "11月",
        sum(case month(date) when '12' then log_num  else 0 end) as "12月"
    from ota_statistics
    where year(date) = #{toyear};
</select>