统计今日、最近一周、最近一个月

结果

req请求参数

@DatapublicclassReportDayWeekMonthReq{//1-day, 2-week, 3-monthprivateIntegerflag;}

service

@OverridepublicList<ReportDayWeekMonth>getReportDayWeekMonth(ReportDayWeekMonthReqreq){if(req.getFlag()==null){thrownewIllegalArgumentException("flag 不能为空");}Integerday=1;switch(req.getFlag()){case1:// 查询日数据day=1;break;case2:// 查询周数据day=7;break;case3:// 查询月数据day=30;break;default:day=1;}List<ReportDayWeekMonth>reportDayWeekMonth=xxlJobLogReportMapper.getReportDayWeekMonth(day);for(ReportDayWeekMonthdayWeekMonth:reportDayWeekMonth){System.out.println(dayWeekMonth);}returnreportDayWeekMonth;}

mapper

SELECTt1.orderly_time,IFNULL(t2.fail_count,0)fail_count,IFNULL(t2.running_count,0)running_count,IFNULL(t2.suc_count,0)suc_countFROM(SELECTDATE_FORMAT(date_add(CURDATE(),INTERVAL-t.help_topic_idDAY),'%Y-%m-%d')orderly_timeFROMmysql.help_topic tWHEREt.help_topic_id<#{day})t1LEFTJOIN(SELECTDATE_FORMAT(trigger_day,'%Y-%m-%d')formatime,running_count,suc_count,fail_countFROMxxl_job_log_report)t2ONt1.orderly_time=t2.formatime