If You want to do Sorting At Any Grid at Admin side....
You just have to Write This Two lines
Ordering = true,
ServerSide = false,
After LengthMenu Property And Before <Filter> Property
Sorting at Grid in NopCommerce 4.20
- 15
- 83
- 7/26/2010
- Turkey
tanzimsiddiqee wrote:
When I apply this to the products section in the admin panel, it only shows 15 products. And there might be a special reason why it's not sorting? I can't sort the products in the admin panel.
Where do we activate this code? I couldn't find any.
Suppose you want to sort store list
Go to :-> Presentation\Nop.Web\Areas\Admin\Views\Store\List.cshtml
and add
Ordering = true,
ServerSide = false,
Suppose you want to sort store list
Go to :-> Presentation\Nop.Web\Areas\Admin\Views\Store\List.cshtml
and add
Ordering = true,
ServerSide = false,
When I apply this to the products section in the admin panel, it only shows 15 products. And there might be a special reason why it's not sorting? I can't sort the products in the admin panel.
- 24
- 298
- 6/30/2022
- Bangladesh
HoLyDream wrote:
In the product list, the data comes from the Store Procedure via the SearchProducts Routine.
So you need to pass a orderby value by using ProductSearchModel.
When I apply this to the products section in the admin panel, it only shows 15 products. And there might be a special reason why it's not sorting? I can't sort the products in the admin panel.
In the product list, the data comes from the Store Procedure via the SearchProducts Routine.
So you need to pass a orderby value by using ProductSearchModel.
- 15
- 83
- 7/26/2010
- Turkey
tanzimsiddiqee wrote:
Do you have an example of this? I want it to be like the sorting in the products section on the homepage.
When I apply this to the products section in the admin panel, it only shows 15 products. And there might be a special reason why it's not sorting? I can't sort the products in the admin panel.
In the product list, the data comes from the Store Procedure via the SearchProducts Routine.
So you need to pass a orderby value by using ProductSearchModel.
In the product list, the data comes from the Store Procedure via the SearchProducts Routine.
So you need to pass a orderby value by using ProductSearchModel.
Do you have an example of this? I want it to be like the sorting in the products section on the homepage.
- 24
- 298
- 6/30/2022
- Bangladesh
HoLyDream wrote:
Please try this....
1. Presentation\Nop.Web\Areas\Admin\Models\Catalog\ProductSearchModel.cs
2: add
to Presentation\Nop.Web\Areas\Admin\Factories\IBaseAdminModelFactory.cs
3: add
to Presentation\Nop.Web\Areas\Admin\Factories\BaseAdminModelFactory.cs
4. modify
to Presentation\Nop.Web\Areas\Admin\Factories\ProductModelFactory.cs
5. modify Presentation\Nop.Web\Areas\Admin\Factories\ProductModelFactory.cs
to Presentation\Nop.Web\Areas\Admin\Factories\ProductModelFactory.cs
6. modify
to Presentation\Nop.Web\Areas\Admin\Views\Product\List.cshtml
Do you have an example of this? I want it to be like the sorting in the products section on the homepage.
Please try this....
1. Presentation\Nop.Web\Areas\Admin\Models\Catalog\ProductSearchModel.cs
public partial record ProductSearchModel : BaseSearchModel
{
public ProductSearchModel()
{
........
AvailableProductTypes = new List<SelectListItem>();
AvailablePublishedOptions = new List<SelectListItem>();
//add
OrderByOptions = new List<SelectListItem>();
}
[NopResourceDisplayName("Admin.Catalog.Products.List.SearchProductName")]
public string SearchProductName { get; set; }
............................
[NopResourceDisplayName("Admin.Catalog.Products.List.GoDirectlyToSku")]
public string GoDirectlyToSku { get; set; }
//add
[NopResourceDisplayName("Admin.Catalog.Products.List.OrderBy")]
public int OrderBy { get; set; }
...................
public IList<SelectListItem> AvailableProductTypes { get; set; }
public IList<SelectListItem> AvailablePublishedOptions { get; set; }
//add
public IList<SelectListItem> OrderByOptions { get; set; }
}
2: add
Task PrepareProductOrdersAsync(IList<SelectListItem> items, bool withSpecialDefaultItem = true, string defaultItemText = null);
to Presentation\Nop.Web\Areas\Admin\Factories\IBaseAdminModelFactory.cs
3: add
public virtual async Task PrepareProductOrdersAsync(IList<SelectListItem> items, bool withSpecialDefaultItem = true, string defaultItemText = null)
{
if (items == null)
throw new ArgumentNullException(nameof(items));
//prepare available product orders
var availableProductOrderItems = await ProductSortingEnum.Position.ToSelectListAsync(false);
foreach (var productOrderItem in availableProductOrderItems)
{
items.Add(productOrderItem);
}
//insert special item for the default value
await PrepareDefaultItemAsync(items, withSpecialDefaultItem, defaultItemText);
}
to Presentation\Nop.Web\Areas\Admin\Factories\BaseAdminModelFactory.cs
4. modify
public virtual async Task<ProductSearchModel> PrepareProductSearchModelAsync(ProductSearchModel searchModel)
{
if (searchModel == null)
throw new ArgumentNullException(nameof(searchModel));
......................
//prepare available vendors
await _baseAdminModelFactory.PrepareVendorsAsync(searchModel.AvailableVendors);
//prepare available product types
await _baseAdminModelFactory.PrepareProductTypesAsync(searchModel.AvailableProductTypes);
//add
//prepare available product orders
await _baseAdminModelFactory.PrepareProductOrdersAsync(searchModel.OrderByOptions, false);
//prepare available warehouses
await _baseAdminModelFactory.PrepareWarehousesAsync(searchModel.AvailableWarehouses);
....................
return searchModel;
}
to Presentation\Nop.Web\Areas\Admin\Factories\ProductModelFactory.cs
5. modify Presentation\Nop.Web\Areas\Admin\Factories\ProductModelFactory.cs
public virtual async Task<ProductListModel> PrepareProductListModelAsync(ProductSearchModel searchModel)
{
if (searchModel == null)
throw new ArgumentNullException(nameof(searchModel));
....................
if (searchModel.SearchIncludeSubCategories && searchModel.SearchCategoryId > 0)
{
var childCategoryIds = await _categoryService.GetChildCategoryIdsAsync(parentCategoryId: searchModel.SearchCategoryId, showHidden: true);
categoryIds.AddRange(childCategoryIds);
}
//get products
var products = await _productService.SearchProductsAsync(showHidden: true,
categoryIds: categoryIds,
manufacturerIds: new List<int> { searchModel.SearchManufacturerId },
storeId: searchModel.SearchStoreId,
vendorId: searchModel.SearchVendorId,
warehouseId: searchModel.SearchWarehouseId,
productType: searchModel.SearchProductTypeId > 0 ? (ProductType?)searchModel.SearchProductTypeId : null,
keywords: searchModel.SearchProductName,
pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize,
orderBy: (ProductSortingEnum)searchModel.OrderBy,
overridePublished: overridePublished);
.........................
to Presentation\Nop.Web\Areas\Admin\Factories\ProductModelFactory.cs
6. modify
<div class="form-group row" @(Model.AvailableManufacturers.SelectionIsNotPossible() ? Html.Raw("style=\"display:none\"") : null)>
<div class="col-md-4">
<nop-label asp-for="SearchManufacturerId" />
</div>
<div class="col-md-8">
<nop-select asp-for="SearchManufacturerId" asp-items="Model.AvailableManufacturers" />
</div>
</div>
<div class="form-group row" @(Model.AvailableVendors.SelectionIsNotPossible() || Model.IsLoggedInAsVendor ? Html.Raw("style='display: none;'") : null)>
<div class="col-md-4">
<nop-label asp-for="SearchVendorId" />
</div>
<div class="col-md-8">
<nop-select asp-for="SearchVendorId" asp-items="Model.AvailableVendors" />
</div>
</div>
<div class="form-group row">
<div class="col-md-4">
<nop-label asp-for="OrderBy" />
</div>
<div class="col-md-8">
<nop-select asp-for="OrderBy" asp-items="Model.OrderByOptions" />
</div>
</div>
.......................................
<div class="card-body">
<nop-doc-reference asp-string-resource="@T("Admin.Documentation.Reference.Products", Docs.Products + Utm.OnAdmin)" />
@await Html.PartialAsync("Table", new DataTablesModel
{
Name = "products-grid",
UrlRead = new DataUrl("ProductList", "Product", null),
SearchButtonId = "search-products",
Length = Model.PageSize,
LengthMenu = Model.AvailablePageSizes,
Filters = new List<FilterParameter>
{
new FilterParameter(nameof(Model.SearchProductName)),
new FilterParameter(nameof(Model.SearchCategoryId)),
new FilterParameter(nameof(Model.SearchIncludeSubCategories), typeof(bool)),
new FilterParameter(nameof(Model.SearchManufacturerId)),
new FilterParameter(nameof(Model.SearchStoreId)),
new FilterParameter(nameof(Model.SearchWarehouseId)),
new FilterParameter(nameof(Model.SearchVendorId)),
new FilterParameter(nameof(Model.SearchProductTypeId)),
new FilterParameter(nameof(Model.SearchPublishedId)),
new FilterParameter(nameof(Model.OrderBy))
},
....................................
to Presentation\Nop.Web\Areas\Admin\Views\Product\List.cshtml
MVP
- 11328
- 101032
- 5/22/2011
- United States
. wrote:
Ordering = true,
ServerSide = false,
I've not really looked into it, but I suspect it would typically not work well. The nop 'services' will already apply an 'order by', and then use Paging. So, the client grid would only get a partial set of records to then sort. (Above Tanzim's revised reply is an example of it.)
Ordering = true,
ServerSide = false,
I've not really looked into it, but I suspect it would typically not work well. The nop 'services' will already apply an 'order by', and then use Paging. So, the client grid would only get a partial set of records to then sort. (Above Tanzim's revised reply is an example of it.)