Level 8
Anybody? Am i barking up the wrong tree?
Apr 29, 2015
4
Level 8
Pivot table sums?
How would i do calculations on data within a pivot table?
I have 3 tables:
Orders (id, date, customer_id) Order_Product (id, order_id, product_id, quantity, term, sell_price, buy_price) and Products (id, name)
I have setup a many to many relationship using the Order_product pivot table.
I'm stuck with how i would go about calculating the total contract value for example (sell_price * quantity * term) and returning this to the view?
Level 32
Just be patient nobody gets answer before 1-2 hours.
Level 32
You will need to select a row and access the pivot.
foreach($orders->products as $product) {
$total[$product->id] = $product->pivot->sell_price * $product->pivot->quantity * $product->pivot->term;
}
Level 2
I belive we're in the same boat. https://laracasts.com/discuss/channels/general-discussion/automatic-join
Please or to participate in this conversation.