时间段内,每天的销量
请求参数:
{
"timeStart": "2023-12-14",
"timeEnd": "2024-01-14"
}
//获取两个时间,时间(天)集合
public static List<String> getDatesBetween(String startDateStr, String endDateStr) {
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
LocalDate startDate = LocalDate.parse(startDateStr, formatter);
LocalDate endDate = LocalDate.parse(endDateStr, formatter);
List<String> dates = new ArrayList<>();
while (startDate .isBefore(endDate) || startDate .isEqual(endDate)) {
String add = startDate .format(formatter);
dates.add(add);
startDate = startDate .plusDays(1);
}
return dates;
}
//添加没有销量的日期值
public List<StatNumVo> addDateNum(List<StatNumVo> list,List<String> listDate){
for (String date:listDate){
boolean isExist = list.stream().map(StatNumVo::getDate).anyMatch(date::equals);
if(!isExist){
StatNumVo vo=new StatNumVo();
vo.setDate(date);
vo.setNum(0);
list.add(vo);
}
}
//时间排序
List nList= list.stream().sorted(Comparator.comparing(StatNumVo::getDate))
.collect(Collectors.toList());
return nList;
}
//获取集合
@Override
public List<StatNumVo> getOrderDayStat(StatParam param) throws Exception {
List<StatNumVo> list = bbStockMapper.getOrderDayStat(param);
List<String> listDate= getDatesBetween(param.getTimeStart(),param.getTimeEnd());
List<StatNumVo> nList= addDateNum(list,listDate);
return nList;
}
SELECT DATE(ctime) AS date, count(1) AS num,sum(price) as price
FROM td_orders
WHERE 1=1
and ctime>='2023-12-14' and ctime <='2024-01-14'
group by DATE_FORMAT(ctime,'%Y-%m-%d')