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
});
}