public ReportData GetData(DateTime startDate, DateTime endDate, TimePeriod granularity)
{
startDate = granularity.BeginningDate(startDate);
endDate = granularity.EndingDate(endDate);
var orders = _contentManager
.Query <CommonPart, CommonPartRecord>("Order")
.Where(r =>
r.CreatedUtc >= startDate.ToUniversalTime() &&
r.CreatedUtc <= endDate.ToUniversalTime())
.OrderBy(r => r.CreatedUtc)
.Join <OrderPartRecord>()
.Where(order => order.Status != OrderPart.Cancelled)
.List()
.ToList();
var numberOfPoints = granularity.PeriodCount(startDate, endDate);
var results = new List <ReportDataPoint>(numberOfPoints);
var intervalStart = startDate;
var intervalEnd = startDate + granularity;
while (intervalStart < endDate)
{
var ordersForInterval = orders.Where(
common => common.CreatedUtc >= intervalStart &&
common.CreatedUtc < intervalEnd)
.Select(common => common.As <OrderPart>())
.ToList();
results.Add(new ReportDataPoint {
Description = granularity.ToString(intervalStart, CultureInfo.CurrentUICulture),
Value = ComputeResultForInterval(ordersForInterval)
});
intervalStart = intervalEnd;
intervalEnd = intervalStart + granularity;
}
return(new ReportData {
DataPoints = results
});
}
public ReportData GetData(DateTime startDate, DateTime endDate, TimePeriod granularity)
{
startDate = granularity.BeginningDate(startDate);
endDate = granularity.EndingDate(endDate);
var orders = _contentManager
.Query <CommonPart, CommonPartRecord>("Order")
.Where(r =>
r.CreatedUtc >= startDate.ToUniversalTime() &&
r.CreatedUtc <= endDate.ToUniversalTime())
.OrderBy(r => r.CreatedUtc)
.Join <OrderPartRecord>()
.Where(order => order.Status != OrderPart.Cancelled)
.List()
.ToList();
var numberOfPoints = granularity.PeriodCount(startDate, endDate);
var results = new List <ReportDataPoint>(numberOfPoints);
var intervalStart = startDate;
var intervalEnd = startDate + granularity;
var seriesProductIds = orders
.SelectMany(order => order
.As <OrderPart>()
.Items
.Select(item => new {
Id = item.ProductId,
Amount = (item.Quantity * item.Price) + item.LinePriceAdjustment
}))
.GroupBy(item => item.Id)
.Select(group => new {
Id = group.Key,
Amount = group.Sum(item => item.Amount)
})
.OrderByDescending(sale => sale.Amount)
.Take(HowManyProductsAreDisplayed)
.Select(sale => sale.Id)
.ToList();
var series = _contentManager
.GetMany <TitlePart>(seriesProductIds, VersionOptions.Published, QueryHints.Empty)
.ToDictionary(
item => item.Id,
item => item.Title
);
while (intervalStart < endDate)
{
var ordersForInterval = orders.Where(
common => common.CreatedUtc >= intervalStart &&
common.CreatedUtc < intervalEnd)
.Select(common => common.As <OrderPart>())
.ToList();
results.Add(new ReportDataPoint {
Description = granularity.ToString(intervalStart, CultureInfo.CurrentUICulture),
Value = ordersForInterval.Any()
? ordersForInterval.Sum(order => order.AmountPaid)
: 0.0,
Series = ordersForInterval
.SelectMany(order => order
.Items
.Where(item => seriesProductIds.Contains(item.ProductId)))
.GroupBy(item => item.ProductId)
.ToDictionary(
group => series[group.Key],
group => new ReportDataPoint {
Value = group.Sum(item => (item.Quantity * item.Price) + item.LinePriceAdjustment)
})
});
intervalStart = intervalEnd;
intervalEnd = intervalStart + granularity;
}
return(new ReportData {
DataPoints = results,
Series = seriesProductIds.Select(id => series[id]).ToList()
});
}