Counting of the sold goods in each SKU.

[ЕвгенияСемихова(ИПСемиховаЕ.А.)]

At my old site was count of selling items.



Q: have Aimeos this functional? Place in database? Or necessary to add a new record to the database and make a separate query?
How will this be done more correctly, taking into account further Aimeos updates?

[aimeos]

This isn't available yet in Aimeos and you have to create an own project specific Aimeos extension:
https://aimeos.org/docs/latest/developer/extensions/

Then, implement a HTML client decorator for the catalog/detail component:
https://aimeos.org/docs/latest/frontend ... omponents/

In the data() method of the decorator, add:

Code: Select all

$manager = \Aimeos\MShop::create( $this->context, 'order' );
$filter = $manager->filter()->add( 'order.product.productid', '==', $this->get( 'detailProductItem' )?->getId() );
$view->productsOrdered = $manager->aggregate( $filter, 'order.product.productid', 'order.product.quantity'', 'sum' )->first();

Finally, overwrite the catalog/detail template in your own extension and output the "productsOrdered" value:
https://aimeos.org/docs/latest/frontend ... templates/

This is save for updating because you don't change any code in the vendor directory which would be overwritten each time the package is updated.