order Desc in products query

[Oscar]

Hello plz how can order the products in a descending order like order by product.id "DESC" in this query?

$products = $this->homeTree->getRefItems( 'product', null, 'promotion', )->slice(0,6);

and other question plz:

$this->homeTree is the manager?

thx

[aimeos]

Hello plz how can order the products in a descending order like order by product.id "DESC" in this query?

Code: Select all

$products = $this->homeTree->getRefItems( 'product', null, 'promotion', )->slice(0,6);

You can't because the referenced products are always ordered by the position you can set in the category panel. If you add a decorator that uses the product controller directly, you can execute a query with a custom order. The disadvantage is that you will fetch the products again and most likely not in an optimized way so your home page will slow down.

$this->homeTree is the manager?

No, it's the root tree node of the category tree.

[Oscar]

Could be a search with filter? And then aply to the filter a -product.id
Thx for help

[aimeos]

Yes, if you use the product controller, you can do that.

[Oscar]

Hello, I have tried to do a search ordering them descendingly and I have been able, but how could I filter only the promotional ones?
Thank you very much for the help. This is my code

Code: Select all

$context = app()->make('\Aimeos\Shop\Base\Context')->get();
$manager = \Aimeos\MShop::create( $context, 'product' );				
$filter = $manager->filter();
$filter = $manager->filter( true );
$filter->order( '-product.id' );
$items = $manager->search( $filter);

[aimeos]

You should use the product controller instead of the manager:
https://github.com/aimeos/ai-client-htm ... #L317-L321

Code: Select all

$context = app()->make('aimeos.context')->get();
$items = \Aimeos\Controller\Frontend::create($context, 'product')
	->category( $catId, 'promotion' )
	->sort( '-product.id' )->slice( 0, 6 )
	->uses( ['media', 'price', 'text'] )
	->search();

Available methods are:
https://github.com/aimeos/ai-controller ... /Iface.php

[Oscar]

Thanks a lot!! runs perfect