Help for integrating the Laravel package
Forum rules: Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#3477 by AlexYoung31
02 Oct 2016, 18:27
Hi,

Where abouts are the queries to form the dashboard for admin. I.e if I wanted to make one for profits.
#3478 by aimeos
02 Oct 2016, 21:13
The dashboard uses the Aimeos JSON API to retrieve the data:
https://aimeos.org/docs/Developers/Admin/JSONAPI/Search_items

To group the filtered results (like a GROUP BY), use the additional parameter
Code: Select allaggregate=...

e.g.
Code: Select allaggregate=order.cdate


The "columns" you can search for and group by are the same as listed in the managers. You can use the "aggregate=..." parameter for every manager that has an aggregate() method, e.g. https://github.com/aimeos/aimeos-core/blob/master/lib/mshoplib/src/MShop/Order/Manager/Standard.php