public ActionResult ReportBestCustomersByNumberOfOrdersList(DataSourceRequest command, BestCustomersReportModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCustomers))
return Content("");
DateTime? startDateValue = (model.StartDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.StartDate.Value, _dateTimeHelper.CurrentTimeZone);
DateTime? endDateValue = (model.EndDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.EndDate.Value, _dateTimeHelper.CurrentTimeZone).AddDays(1);
OrderStatus? orderStatus = model.OrderStatusId > 0 ? (OrderStatus?)(model.OrderStatusId) : null;
PaymentStatus? paymentStatus = model.PaymentStatusId > 0 ? (PaymentStatus?)(model.PaymentStatusId) : null;
ShippingStatus? shippingStatus = model.ShippingStatusId > 0 ? (ShippingStatus?)(model.ShippingStatusId) : null;
var items = _customerReportService.GetBestCustomersReport(startDateValue, endDateValue,
orderStatus, paymentStatus, shippingStatus, 2, command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = items.Select(x =>
{
var m = new BestCustomerReportLineModel
{
CustomerId = x.CustomerId,
OrderTotal = _priceFormatter.FormatPrice(x.OrderTotal, true, false),
OrderCount = x.OrderCount,
};
var customer = _customerService.GetCustomerById(x.CustomerId);
if (customer != null)
{
m.CustomerName = customer.IsRegistered() ? customer.Email : _localizationService.GetResource("Admin.Customers.Guest");
}
return m;
}),
Total = items.TotalCount
};
return Json(gridModel);
}
public ActionResult ReportBestCustomersByOrderTotalList(GridCommand command, BestCustomersReportModel model)
{
DateTime? startDateValue = (model.StartDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.StartDate.Value, _dateTimeHelper.CurrentTimeZone);
DateTime? endDateValue = (model.EndDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.EndDate.Value, _dateTimeHelper.CurrentTimeZone).AddDays(1);
OrderStatus? orderStatus = model.OrderStatusId > 0 ? (OrderStatus?)(model.OrderStatusId) : null;
PaymentStatus? paymentStatus = model.PaymentStatusId > 0 ? (PaymentStatus?)(model.PaymentStatusId) : null;
ShippingStatus? shippingStatus = model.ShippingStatusId > 0 ? (ShippingStatus?)(model.ShippingStatusId) : null;
var items = _customerReportService.GetBestCustomersReport(startDateValue, endDateValue,
orderStatus, paymentStatus, shippingStatus, 1);
var gridModel = new GridModel<BestCustomerReportLineModel>
{
Data = items.Select(x =>
{
var m = new BestCustomerReportLineModel()
{
CustomerId = x.CustomerId,
OrderTotal = _priceFormatter.FormatPrice(x.OrderTotal, true, false),
OrderCount = x.OrderCount,
};
var customer = _customerService.GetCustomerById(x.CustomerId);
if (customer != null)
{
m.CustomerName = customer.IsGuest()
? _localizationService.GetResource("Admin.Customers.Guest")
: customer.Email;
}
return m;
}),
Total = items.Count
};
return new JsonResult
{
Data = gridModel
};
}