Get the Total value of sum of 2 columns in db laravel

Question

I have joined 2 databases, what i want is to get the total value/sum of these 2 multiplied column:

Example on the database:

Price Quantity 100 1 110 2 120 3

in my query in laravel- i got the total, 100, 220, 360, i want the sum of all these, total that is equals to, 680, how can i achieve the 680 total?

    $jointwo = DB::table('invoices')
                ->select('invoices.id', 'invoices.user', 'invoices.company', 'invoices.invoice_month', 'invoices.created','invoice_details.invoice_id', DB::raw('invoice_details.quantity * invoice_details.unit_price as total'))->join('invoice_details', 'invoice_details.invoice_id', '=', 'invoices.id')->get();


     dd($jointwo);

I got the total, 100, 220, 360, i want the sum of all these, total that is equals to, 680, how can i achieve the 680 total?

enter image description here

Denis Sinyukov · Accepted Answer · 2023-12-01 11:43:48Z

1

first, group by invoices.id ->groupBy('invoices.id') and then get the total amount.

$jointwo = DB::table('invoices')
    ->select('invoices.id', 'invoices.user', 'invoices.company', 'invoices.invoice_month', 'invoices.created')
    ->selectRaw('SUM(invoice_details.quantity * invoice_details.unit_price) as total')
    ->join('invoice_details', 'invoice_details.invoice_id', '=', 'invoices.id')
    ->groupBy('invoices.id')
    ->get();

answered Dec 1, 2023 at 11:43

Denis Sinyukov

5924 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

babe_engineer Over a year ago

thankssssssss. you saved my day with this code

Collectives™ on Stack Overflow

Get the Total value of sum of 2 columns in db laravel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related