/PHP/Laravel/Comparison of two tables in laravel using model

Comparison of two tables in laravel using model

$paidFeesIds = Fee::whereHas('paidFees', function($q) {
    $q->where('payment_status', 1);
})->pluck('id')->toArray();

$notPaidFeesIds = Fee::whereNotIn('id', $paidFeesIds)->pluck('id')->toArray();

Source: stackoverflow.com

Similar codes

0 vote195 views1 answer
Can we use 2 select in a query laravel
PHP Laravel
0 vote201 views2 answers
Laravel eloquent select case when
PHP Laravel
12 votes216 views4 answers
Laravel get second last record
PHP Laravel
8 votes166 views3 answers
Laravel redirect back with errors and input
PHP Laravel
0 vote189 views1 answer
Check mobile or email in laravel
PHP Laravel
14 votes186 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel
-2 votes189 views1 answer
Laravel model bind with route in model
PHP Laravel
0 vote189 views1 answer
Laravel get mysql column datatype
PHP Laravel
1 vote185 views1 answer
Laravel fixed character limit
PHP Laravel
1 vote179 views2 answers
Laravel ckeditor
PHP Laravel