每天
首先效验传过来的时间数据,这里传过来的是vue的日期组件所产生的的时间范围
效验代码:
private List<LocalDate> getStartAndEnd(String createDate){
LocalDate preDate;
LocalDate endDate;
if (!StringUtils.isEmpty(createDate)){
String[] split = createDate.split(",");
DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
preDate = LocalDate.parse(split[0], dateTimeFormatter);
endDate = LocalDate.parse(split[1], dateTimeFormatter);
}else {
preDate = LocalDate.now().minusMonths(3);
endDate = LocalDate.now();
}
List<LocalDate> localDates = new ArrayList<>();
localDates.add(preDate);
localDates.add(endDate);
return localDates;
}
获取到到时间范围后通过数据库查询
SELECT
DATE_FORMAT( create_date, '%j' ) dayNum,
count( id ) count ,
create_date dateTime
FROM
表名
GROUP BY
dayNu