订单每天销量统计

时间段内，每天的销量
请求参数：
{
    "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')