How to get a sum() from joinTable.field * belongsToMany.field

Need Help
1

Hi Folks !

I have the cliché situation: Orders belongsToMany Products through OrderItems.
And also Orders belongsTo Customers

I am trying to get a resultSet with order.date, order.customer.name and a calculate field order.total which
means (order.product.price * order.order_item.quantity)

I’have tried with ->matching(‘Products’) with however I’ve got duplicated order entities :frowning:

Is there any way to do that?

Thanks in advance !

2

There are belongsToMany association in between orders and products so it obvious that you will get duplicate orders. For avoiding this just try to add something like ->group(['Products.id']);, this will give you single entity by products.