/PHP/Laravel/Laravel Eloquent sum of multiplied columns

Laravel Eloquent sum of multiplied columns

Laravel Eloquent sum of multiplied columns

$amount = Transaction::all()->sum(function($t){ 
    return $t->jumlah * $t->harga; 
});

0

Source: stackoverflow.com

Laravel Eloquent sum of multiplied columns

$amount = Transaction::sum(\DB::raw('jumla * harga'));

0

Source: stackoverflow.com

Laravel Eloquent sum of multiplied columns

$amount = Transaction::select(DB::raw('sum(jumlah * harga) as total'))->get();

0

Source: stackoverflow.com

Similar codes

16 votes148 views3 answers
Make a forign key in migrations using laravel 8
PHP Laravel
7 votes142 views3 answers
Laravel 8 validation unique 2 columns
PHP Laravel
0 vote162 views1 answer
Aws s3 laravel package
PHP Laravel
37 votes179 views6 answers
Laravel create or update
PHP Laravel
1 vote170 views3 answers
Laravel required if
PHP Laravel
0 vote182 views1 answer
Laravel get previous route without domain
PHP Laravel
0 vote161 views1 answer
Laravel Upsert always inserting
PHP Laravel
5 votes162 views2 answers
Laravel collection chunk
PHP Laravel
0 vote161 views1 answer
Laravel load models by id array
PHP Laravel
3 votes152 views4 answers
Csrf token mismatch laravel api
PHP Laravel

Share