public IQueryable <RevenueStatisticsViewModel> RevenueStatistics(RevenueStatisticsRequest request)
{
if (request.option == enums.DayOrMonth.DaysInMonth)
{
var rp = from o in _context.orders
group o by o.createDate.Date into g
where g.Key.Month == request.month && g.Key.Year == request.year
select new RevenueStatisticsViewModel
{
date = g.Key.ToString("dd/MM/yyyy"),
countOrder = g.Count(),
sumRevenue = g.Sum(x => x.total)
};
return(rp);
}
else
{
var rp = from i in _context.orders
where i.createDate.Year == request.year
group i by i.createDate.Month into h
select new RevenueStatisticsViewModel
{
date = "Tháng " + h.Key.ToString(),
countOrder = h.Count(),
sumRevenue = h.Sum(x => x.total)
};
return(rp);
}
}
public IActionResult RevenueStatistics(RevenueStatisticsRequest request)
{
var data = _statisticsService.RevenueStatistics(request);
return(Ok(data));
}
