Pada tutorial kali ini, kita akan membahas query laravel sum dengan kondisi where. langkah demi langkah menjelaskan laravel di mana jumlah lebih besar dari. Saya menjelaskan secara sederhana tentang laravel yang memiliki kueri jumlah. mari kita bahas tentang query laravel where sum.

Kapan pun Anda perlu menjumlahkan kolom dan hanya perlu mendapatkan catatan yang memiliki nilai lebih besar dari beberapa di pembuat kueri laravel, maka saya akan memberi Anda contoh sederhana bagaimana menggunakan kondisi where dengan sum. anda dapat menggunakan contoh ini dengan versi laravel 6, laravel 7 dan laravel 8.

mari kita lihat contoh di bawah ini:

Contoh Menggunakan having()

Code Controller:

<?php
  
namespace App\Http\Controllers;
  
use App\Models\User;
use DB;
  
class ITSController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index()
    {
        $users = UserPayment::select("*", DB::raw('SUM(amount) as total'))
                    ->groupBy("user_id")
                    ->having('total', '>', 50)
                    ->get();
  
        dd($users);
    }
}

Output:

Array
(
    [0] => Array
        (
            [id] => 1
            [user_id] => 1
            [amount] => 56
            [payment_date] => 2021-08-04
            [status] => 1
            [created_at] => 
            [updated_at] => 
            [total] => 56
        )
    [1] => Array
        (
            [id] => 2
            [user_id] => 2
            [amount] => 45
            [payment_date] => 2021-09-07
            [status] => 0
            [created_at] => 
            [updated_at] => 
            [total] => 55
        )
    [2] => Array
        (
            [id] => 5
            [user_id] => 5
            [amount] => 66
            [payment_date] => 2022-01-04
            [status] => 1
            [created_at] => 
            [updated_at] => 
            [total] => 66
        )

)

Contoh Menggunakan havingRaw()

Code Controller:

<?php
  
namespace App\Http\Controllers;
  
use App\Models\User;
use DB;
  
class ITSController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index()
    {
        $users = UserPayment::select("*", DB::raw('SUM(amount) as total'))
                    ->groupBy("user_id")
                    ->havingRaw('total > 50')
                    ->get();
  
        dd($users);
    }
}

Output:

Array
(
    [0] => Array
        (
            [id] => 1
            [user_id] => 1
            [amount] => 56
            [payment_date] => 2021-08-04
            [status] => 1
            [created_at] => 
            [updated_at] => 
            [total] => 56
        )
    [1] => Array
        (
            [id] => 2
            [user_id] => 2
            [amount] => 45
            [payment_date] => 2021-09-07
            [status] => 0
            [created_at] => 
            [updated_at] => 
            [total] => 55
        )
    [2] => Array
        (
            [id] => 5
            [user_id] => 5
            [amount] => 66
            [payment_date] => 2022-01-04
            [status] => 1
            [created_at] => 
            [updated_at] => 
            [total] => 66
        )
)

saya harap dapat membantu anda...