public ActionResult CountryReportList(DataSourceRequest command, CountryReportModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.OrderCountryReport))
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;
var items = _orderReportService.GetCountryReport(
os: orderStatus,
ps: paymentStatus,
startTimeUtc: startDateValue,
endTimeUtc: endDateValue);
var gridModel = new DataSourceResult
{
Data = items.Select(x =>
{
var country = _countryService.GetCountryById(x.CountryId.HasValue ? x.CountryId.Value : 0);
var m = new CountryReportLineModel
{
CountryName = country != null ? country.Name : "Unknown",
SumOrders = _priceFormatter.FormatPrice(x.SumOrders, true, false),
TotalOrders = x.TotalOrders,
};
return m;
}),
Total = items.Count
};
return Json(gridModel);
}
public ActionResult CountryReport()
{
if (!_permissionService.Authorize(StandardPermissionProvider.OrderCountryReport))
return AccessDeniedView();
var model = new CountryReportModel();
//order statuses
model.AvailableOrderStatuses = OrderStatus.Pending.ToSelectList(false).ToList();
model.AvailableOrderStatuses.Insert(0, new SelectListItem { Text = _localizationService.GetResource("Admin.Common.All"), Value = "0" });
//payment statuses
model.AvailablePaymentStatuses = PaymentStatus.Pending.ToSelectList(false).ToList();
model.AvailablePaymentStatuses.Insert(0, new SelectListItem { Text = _localizationService.GetResource("Admin.Common.All"), Value = "0" });
return View(model);
}
