How to count the total price of order?

Question

I have these tables:

Orders: 
id - status -user_id - address_id 
1     await    1          1 

products:
id -  name -   price  - quantity
1     test1    100$       5 
2     test2    50$        5 


order_product:
order_id - product_id - quantity
 1           1            2
 1           2            2

cities:
id - name - shipping_charges
1    NY       30$

How can I count the total price of the these columns:

for each product:

  products(price) * order_product(quantity)

for all products with shipping_charges

- products(price) * order_product(quantity) + cities(shipping_charges)

so if one product[$20] has two orders, [qty: 1, qty: 2,] two order has same cities' `shipping_charges`[$1, $1]. So you want to cal one product's shipping_charges is `20*(1+2) + 1` or `20*(1+2) + 2*1`? — TsaiKoga, Feb 01 '20 at 04:44

score 1 · Answer 1 · answered Jan 31 '20 at 21:51

1

Find the sum of a field by using laravel collection by doing something like this;

$profuctTotal=Product::all()->sum('price'); Do same for others using Eloquent models.

answered Jan 31 '20 at 21:51

spartyboy

428
4
12

the problem with the pivot table there is model for it how can I handle it! – Jan 31 '20 at 21:55
Now I have this ( $order->products->sum('price') it's ok but how can I * this with the pivot table that I have – Jan 31 '20 at 21:57

score 1 · Answer 2 · answered Feb 01 '20 at 14:09

If you don't use any model then use this raw query

$orderitem = DB::table('order_product')->where('order_id', 'your order id')->get();

    // Now create a foreach loop for get total price 

    $total = 0;

    foreach($orderitem as $order){
        $porduct = DB::table('products')->where('id', $order->product_id)->first();
        $total += $porduct->price * $order->quantity;
    }
    // now you got sub total
    $shipping = DB::table('cities')->where('id', 'Orders table address column')->first();
    $subtotal = $tatal + $shipping->shipping_charges;

score 0 · Accepted Answer · answered Feb 01 '20 at 05:10

You can retrieve the pivot table columns by accessing the pivot attribute, this has been there for a long while.

By default, only the model keys will be present on the pivot object. If your pivot table contains extra attributes, you must specify them when defining the relationship:

In your case you can define the relationship like in the following code:

class Order extends Model {
    public function products()
    {
        return $this->belongsToMany(Order::class)->withPivot('quantity')
    }
}

Now the quantity column on the order_product table will be accessible via the pivot attribute (e.g. $order->products()->first()->pivot->quantity).

In the end, here is the resulting code to calculate the order total:

$total = 0;
foreach ($product as $products) {
    $total += $product->price * $product->pivot->quantity
}

$total += $order->address()->city->shipping_charges

Source: https://laravel.com/docs/master/eloquent-relationships#many-to-many

How to count the total price of order?

3 Answers3

Linked

Related