public ActionResult BestsellersReportList(GridCommand command, BestsellersReportModel model) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageOrders)) return Content(""); //a vendor should have access only to his products int vendorId = 0; if (_workContext.CurrentVendor != null) vendorId = _workContext.CurrentVendor.Id; 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; //group by product variants (not products) var items = _orderReportService.BestSellersReport( createdFromUtc: startDateValue, createdToUtc: endDateValue, os: orderStatus, ps: paymentStatus, billingCountryId: model.BillingCountryId, orderBy: 2, vendorId: vendorId, pageIndex: command.Page - 1, pageSize: command.PageSize, showHidden: true); var gridModel = new GridModel<BestsellersReportLineModel> { Data = items.Select(x => { var m = new BestsellersReportLineModel() { ProductVariantId = x.EntityId, TotalAmount = _priceFormatter.FormatPrice(x.TotalAmount, true, false), TotalQuantity = x.TotalQuantity, }; var productVariant = _productService.GetProductVariantById(x.EntityId); if (productVariant != null) m.ProductVariantFullName = productVariant.FullProductName; return m; }), Total = items.TotalCount }; return new JsonResult { Data = gridModel }; }
public ActionResult BestsellersReport() { if (!_permissionService.Authorize(StandardPermissionProvider.ManageOrders)) return AccessDeniedView(); var model = new BestsellersReportModel(); //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" }); //billing countries foreach (var c in _countryService.GetAllCountriesForBilling()) { model.AvailableCountries.Add(new SelectListItem() { Text = c.Name, Value = c.Id.ToString() }); } model.AvailableCountries.Insert(0, new SelectListItem() { Text = _localizationService.GetResource("Admin.Address.SelectCountry"), Value = "0" }); //vendor model.IsLoggedInAsVendor = _workContext.CurrentVendor != null; return View(model); }