public ChartModel SalesByDay(ChartModel model)
{
var data = _orderAnalyticsService.GetRevenueGroupedByDate(model.From, model.To);
_chartService.SetLineChartData(ref model, data);
_chartService.SetLineChartLabels(ref model);
return model;
}
public void SetLineChartLabels(ref ChartModel model)
{
model.Labels = new List<string>();
TimeSpan ts = model.To - model.From;
DateTime oldDate = DateTime.Parse(model.From.Date.ToString());
DateTime currentDate = oldDate;
if (ts.Days == 1)
{
for (int i = 0; i < 24; i++)
{
oldDate = currentDate;
currentDate = oldDate.AddHours(1);
model.Labels.Add(oldDate.Hour.ToString());
}
}
else if (model.From.Month == model.To.Month || ts.Days < 31)
{
for (int i = 0; i < ts.Days; i++)
{
oldDate = currentDate;
currentDate = oldDate.AddDays(1);
model.Labels.Add(oldDate.ToString("dd/MM"));
}
}
else
{
while (oldDate.Month <= currentDate.Month)
{
oldDate = currentDate;
currentDate = oldDate.AddMonths(1);
model.Labels.Add(oldDate.Month.GetMonth());
}
}
}
public ChartModel SalesLastWeekGroupedByDay()
{
var model = new ChartModel() { From = CurrentRequestData.Now.Date.AddDays(-6), To = CurrentRequestData.Now.Date.AddDays(1) };
var data = _orderAnalyticsService.GetRevenueGroupedByDate(model.From, model.To);
_chartService.SetLineChartData(ref model, data);
_chartService.SetLineChartLabels(ref model);
return model;
}
public ChartModel SalesTodayGroupedByHour()
{
var data = _orderAnalyticsService.GetRevenueForTodayGroupedByHour();
var model = new ChartModel { From = CurrentRequestData.Now.Date, To = CurrentRequestData.Now.Date.AddDays(1) };
_chartService.SetLineChartData(ref model, data);
_chartService.SetLineChartLabels(ref model);
return model;
}
public ChartModel SalesXDays()
{
var days = _ecommerceSettings.DashboardRevenueDays;
if (days <= 0)
days = 7;
var model = new ChartModel() { From = CurrentRequestData.Now.Date.AddDays(-(days - 1)), To = CurrentRequestData.Now.Date.AddDays(1) };
var data = _orderAnalyticsService.GetRevenueGroupedByDate(model.From, model.To);
_chartService.SetLineChartData(ref model, data);
_chartService.SetLineChartLabels(ref model);
return model;
}
public void SetLineChartData(ref ChartModel model,
Dictionary<string, IList<KeyValuePair<DateTime, decimal>>> items)
{
foreach (string key in items.Keys)
{
IList<KeyValuePair<DateTime, decimal>> item = items[key];
var data = new List<decimal>();
TimeSpan ts = model.To - model.From;
DateTime oldDate = DateTime.Parse(model.From.Date.ToString());
DateTime currentDate = oldDate;
if (ts.Days == 1)
{
for (int i = 0; i < 24; i++)
{
data.Add(item.Where(x => x.Key.Hour == i + 1).Sum(x => x.Value));
}
}
else if (model.From.Month == model.To.Month || ts.Days < 31)
{
for (int i = 0; i < ts.Days; i++)
{
oldDate = currentDate;
currentDate = oldDate.AddDays(1);
data.Add(i == 0
? item.Where(x => x.Key.Date == currentDate.Date).Sum(x => x.Value)
: item.Where(x => oldDate.Date <= x.Key && x.Key < currentDate.Date)
.Sum(x => x.Value));
}
}
else
{
while (oldDate.Month <= currentDate.Month)
{
oldDate = currentDate;
data.Add(item.Where(x => x.Key.Month == currentDate.Month).Sum(x => x.Value));
currentDate = oldDate.AddMonths(1);
}
}
model.MultipleData.Add(key, data.Any(x => x != 0) ? data : new List<decimal>());
}
}
public void SetBarChartLabelsAndData(ref ChartModel model,
Dictionary<string, IList<KeyValuePair<string, decimal>>> items)
{
model.Labels = new List<string>();
model.MultipleData = new Dictionary<string, List<decimal>>();
foreach (string label in items.Values.SelectMany(item => item.Select(x => x.Key).Distinct()))
{
if (model.Labels.All(x => x != label))
model.Labels.Add(label);
}
foreach (string key in items.Keys)
{
IList<KeyValuePair<string, decimal>> item = items[key];
List<decimal> data =
model.Labels.Select(
label => item.Any(x => x.Key == label) ? item.SingleOrDefault(x => x.Key == label).Value : 0)
.ToList();
model.MultipleData.Add(key, data.Any(x => x != 0) ? data : new List<decimal>());
}
}
public ChartModel OrdersByShippingType(ChartModel model)
{
var data = _orderAnalyticsService.GetOrdersGrouped(model.From, model.To);
_chartService.SetBarChartLabelsAndData(ref model, data);
return model;
}
public ChartModel SalesByShippingType(ChartModel model)
{
var data = _orderAnalyticsService.GetRevenueByShippingMethod(model.From, model.To);
_chartService.SetBarChartLabelsAndData(ref model, data);
return model;
}