/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

36 votes204 views6 answers
Laravel 8 foreign key migration
PHP Laravel
6 votes268 views6 answers
Laravel get current route name
PHP Laravel
2 votes221 views1 answer
Read global laravel request()
PHP Laravel
2 votes206 views2 answers
Laravel eloquent multiple primary key
PHP Laravel
15 votes220 views3 answers
Pass data to blade laravel
PHP Laravel
18 votes226 views5 answers
If else statement in laravel blade
PHP Laravel
1 vote224 views1 answer
Human readable date laravel
PHP Laravel
0 vote239 views2 answers
Laravel composer sanctum
PHP Laravel
0 vote208 views1 answer
Import local js file laravel
PHP Laravel
0 vote227 views2 answers
Value() in laravel
PHP Laravel