0

I have created a custom sorting option distance in magento 2.4.3-p1 and sort the collection with custom sorted entity ids

di.xml

`<type name="Magento\Catalog\Model\Config">
    <plugin name="catalog_config_plugin" type="Sunarc\NearByProduct\Plugin\Config" />
</type>`
<preference for="Magento\Catalog\Block\Product\ProductList\Toolbar" type="Sunarc\NearByProduct\Block\Catalog\Product\ProductList\Toolbar" />

<type name="Magento\Elasticsearch\Model\ResourceModel\Fulltext\Collection\SearchCriteriaResolver">
    <plugin name="ajourquin_unset_es_order" type="Sunarc\NearByProduct\Plugin\Elasticsearch\Model\ResourceModel\Fulltext\Collection\SearchCriteriaResolver" />
</type>

app\code\Sunarc\NearByProduct\Plugin\config.php

public function afterGetAttributeUsedForSortByArray(\Magento\Catalog\Model\Config $catalogConfig,$results)
{
    $results['distance'] = __('Distance');
   
    return $results;
}

app\code\Sunarc\NearByProduct\Plugin\Elasticsearch\Model\ResourceModel\Fulltext\Collection\SearchCriteriaResolver.php

public function afterResolve(MagentoSearchCriteriaResolver $subject, SearchCriteria $result): SearchCriteria
{
    $sortOrders = $result->getSortOrders();
    unset($sortOrders['distance']);
    $result->setSortOrders($sortOrders);
    return $result;
}

app\code\Sunarc\NearByProduct\Block\Catalog\Product\ProductListToolbar.php

$ids = array(4,5,2,1,3);
$ids = implode(',',$ids);
$this->_collection->getSelect()->reset(\Magento\Framework\DB\Select::ORDER);
$this->_collection->getSelect()->order(array(new \Zend_Db_Expr("FIELD(e.entity_id, " . $ids . ")")));
//$logger->info('collection'.json_encode($this->_collection->getData()));
 //$logger->info($this->_collection->getSelectSql());
 foreach($this->_collection as $data)
 {
   $logger->info('getData'.json_encode($data->getData()));
 }

Here before foreach collection is sort with entity id 4,5,2,1,3 properly, but when we in the foreach loop $data->getData() give the product in 1,2,3,4,5 entity_id order, and also print query show correct field order 4,5,2,1,3.Because of this products are not showing with sort order on storefront.

Any one tell me what is the issue or any other things which i have missed. Any help is appriciated.

1 Answer 1

0

If think you just need to save the sorted collection and iteration over that one.

$this->_collection->getSelect()->order(array(new \Zend_Db_Expr("FIELD(e.entity_id, " . $ids . ")")));

Replaced by

$sortedCollection = $this->_collection->getSelect()->order(array(new \Zend_Db_Expr("FIELD(e.entity_id, " . $ids . ")")));

Then for foreach on sortedCollection.

That being said, this is not how you should sort a collection in magento

This is the way

    $productCollection = $this->productCollectionFactory->create();
    $productCollection->addAttributeToSelect('*');
    $productCollection->addAttributeToSort('distance','ASC');
2
  • Thanks but distance is not a product attribute, it's only a option on storefront in sort by option dropdown Aug 12, 2022 at 10:56
  • I have only $ids = array(4,5,2,1,3); Aug 12, 2022 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.