public virtual ActionResult OrderList(DataSourceRequest command, Admin.Models.Orders.OrderListModel model) { var storeScope = this.GetActiveStoreScopeConfiguration(_storeService, _workContext); var amazonSettings = _settingService.LoadSetting<OrderAmazonSettings>(storeScope); if (!_permissionService.Authorize(StandardPermissionProvider.ManageOrders)) return AccessDeniedKendoGridJson(); //a vendor should have access only to his products if (_workContext.CurrentVendor != null) { model.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); var orderStatusIds = !model.OrderStatusIds.Contains(0) ? model.OrderStatusIds : null; var paymentStatusIds = !model.PaymentStatusIds.Contains(0) ? model.PaymentStatusIds : null; var shippingStatusIds = !model.ShippingStatusIds.Contains(0) ? model.ShippingStatusIds : null; var filterByProductId = 0; var product = _productService.GetProductById(model.ProductId); if (product != null && HasAccessToProduct(product)) filterByProductId = model.ProductId; //load orders var orders = _orderAmazonService.SearchOrders(storeId: model.StoreId, vendorId: model.VendorId, productId: filterByProductId, warehouseId: model.WarehouseId, paymentMethodSystemName: model.PaymentMethodSystemName, createdFromUtc: startDateValue, createdToUtc: endDateValue, osIds: orderStatusIds, psIds: paymentStatusIds, ssIds: shippingStatusIds, billingEmail: model.BillingEmail, billingLastName: model.BillingLastName, billingCountryId: model.BillingCountryId, orderNotes: model.OrderNotes, pageIndex: command.Page - 1, pageSize: command.PageSize); var gridModel = new DataSourceResult { Data = orders.Select(x => { var store = _storeService.GetStoreById(x.StoreId); return new OrderModel { Id = x.Id, StoreName = store != null ? store.Name : "Unknown", OrderTotal = _priceFormatter.FormatPrice(x.OrderTotal, true, false), OrderStatus = x.OrderStatus.GetLocalizedEnum(_localizationService, _workContext), OrderStatusId = x.OrderStatusId, PaymentStatus = x.PaymentStatus.GetLocalizedEnum(_localizationService, _workContext), PaymentStatusId = x.PaymentStatusId, ShippingStatus = x.ShippingStatus.GetLocalizedEnum(_localizationService, _workContext), ShippingStatusId = x.ShippingStatusId, CustomerEmail = x.BillingAddress.Email, CustomerFullName = string.Format("{0} {1}", x.BillingAddress.FirstName, x.BillingAddress.LastName), CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc), CustomOrderNumber = x.CustomOrderNumber, OrderAmazon = _orderAmazonService.GetOrderAmazonByOrderId(x.Id) }; }), Total = orders.TotalCount }; //summary report //currently we do not support productId and warehouseId parameters for this report var reportSummary = _orderReportService.GetOrderAverageReportLine( storeId: model.StoreId, vendorId: model.VendorId, orderId: 0, paymentMethodSystemName: model.PaymentMethodSystemName, osIds: orderStatusIds, psIds: paymentStatusIds, ssIds: shippingStatusIds, startTimeUtc: startDateValue, endTimeUtc: endDateValue, billingEmail: model.BillingEmail, billingLastName: model.BillingLastName, billingCountryId: model.BillingCountryId, orderNotes: model.OrderNotes); var profit = _orderReportService.ProfitReport( storeId: model.StoreId, vendorId: model.VendorId, paymentMethodSystemName: model.PaymentMethodSystemName, osIds: orderStatusIds, psIds: paymentStatusIds, ssIds: shippingStatusIds, startTimeUtc: startDateValue, endTimeUtc: endDateValue, billingEmail: model.BillingEmail, billingLastName: model.BillingLastName, billingCountryId: model.BillingCountryId, orderNotes: model.OrderNotes); var primaryStoreCurrency = _currencyService.GetCurrencyById(_currencySettings.PrimaryStoreCurrencyId); if (primaryStoreCurrency == null) throw new Exception("Cannot load primary store currency"); gridModel.ExtraData = new Admin.Models.Orders.OrderAggreratorModel { aggregatorprofit = _priceFormatter.FormatPrice(profit, true, false), aggregatorshipping = _priceFormatter.FormatShippingPrice(reportSummary.SumShippingExclTax, true, primaryStoreCurrency, _workContext.WorkingLanguage, false), aggregatortax = _priceFormatter.FormatPrice(reportSummary.SumTax, true, false), aggregatortotal = _priceFormatter.FormatPrice(reportSummary.SumOrders, true, false) }; return Json(gridModel); }
public ActionResult InvoiceList(DataSourceRequest command, InvoiceListModel model) { //if (!_permissionService.Authorize(StandardPermissionProvider.ManageOrders)) // return AccessDeniedView(); //a vendor should have access only to his products if (_workContext.CurrentVendor != null) { model.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; ShippingStatus?shippingStatus = model.ShippingStatusId > 0 ? (ShippingStatus?)(model.ShippingStatusId) : null; var filterByProductId = 0; var product = _productService.GetProductById(model.ProductId); //if (product != null && HasAccessToProduct(product)) // filterByProductId = model.ProductId; //load invoices var invoices = _invoiceService.SearchInvoices(storeId: model.StoreId, //vendorId: model.VendorId, productId: filterByProductId, warehouseId: model.WarehouseId, billingCountryId: model.BillingCountryId, paymentMethodSystemName: model.PaymentMethodSystemName, createdFromUtc: startDateValue, createdToUtc: endDateValue, os: orderStatus, ps: paymentStatus, ss: shippingStatus, billingEmail: model.CustomerEmail, orderNotes: model.OrderNotes, orderGuid: model.OrderGuid, pageIndex: command.Page - 1, pageSize: command.PageSize); foreach (var invoice in invoices) { var order = _orderService.GetOrderById(invoice.OrderId); invoice.OrderTotal = order.OrderTotal; } var gridModel = new DataSourceResult { Data = invoices.Select(x => { var store = _storeService.GetStoreById(x.StoreId); return(new InvoiceModel { Id = x.Id, StoreName = store != null ? store.Name : "Unknown", OrderTotal = _priceFormatter.FormatPrice(x.OrderTotal, true, false), OrderStatus = x.OrderStatus.GetLocalizedEnum(_localizationService, _workContext), PaymentStatus = x.PaymentStatus.GetLocalizedEnum(_localizationService, _workContext), ShippingStatus = x.ShippingStatus.GetLocalizedEnum(_localizationService, _workContext), // CustomerEmail = x.BillingAddress.Email, // CustomerFullName = string.Format("{0} {1}", x.BillingAddress.FirstName, x.BillingAddress.LastName), CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc), Commission = x.Commission }); }), Total = invoices.TotalCount }; //summary report //currently we do not support productId and warehouseId parameters for this report var reportSummary = _orderReportService.GetOrderAverageReportLine( storeId: model.StoreId, vendorId: model.VendorId, billingCountryId: model.BillingCountryId, orderId: 0, paymentMethodSystemName: model.PaymentMethodSystemName, os: orderStatus, ps: paymentStatus, ss: shippingStatus, startTimeUtc: startDateValue, endTimeUtc: endDateValue, billingEmail: model.CustomerEmail, orderNotes: model.OrderNotes); var profit = _orderReportService.ProfitReport( storeId: model.StoreId, vendorId: model.VendorId, billingCountryId: model.BillingCountryId, paymentMethodSystemName: model.PaymentMethodSystemName, os: orderStatus, ps: paymentStatus, ss: shippingStatus, startTimeUtc: startDateValue, endTimeUtc: endDateValue, billingEmail: model.CustomerEmail, orderNotes: model.OrderNotes); var primaryStoreCurrency = _currencyService.GetCurrencyById(_currencySettings.PrimaryStoreCurrencyId); if (primaryStoreCurrency == null) { throw new Exception("Cannot load primary store currency"); } gridModel.ExtraData = new OrderAggreratorModel { aggregatorprofit = _priceFormatter.FormatPrice(profit, true, false), aggregatorshipping = _priceFormatter.FormatShippingPrice(reportSummary.SumShippingExclTax, true, primaryStoreCurrency, _workContext.WorkingLanguage, false), aggregatortax = _priceFormatter.FormatPrice(reportSummary.SumTax, true, false), aggregatortotal = _priceFormatter.FormatPrice(reportSummary.SumOrders, true, false) }; return(new JsonResult { Data = gridModel }); }