/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

5 votes316 views2 answers
Route() and with() in laravel
PHP Laravel
0 vote331 views3 answers
Convert object to array laravel
PHP Laravel
8 votes290 views3 answers
Laravel model::query
PHP Laravel
0 vote282 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel
0 vote308 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
0 vote316 views1 answer
Laravel share on whatsapp link
PHP Laravel
0 vote290 views1 answer
Laravel launch only one dusk test
PHP Laravel
0 vote318 views1 answer
Server error in laravel
PHP Laravel
1 vote311 views1 answer
Get all errors view laravel
PHP Laravel
7 votes298 views3 answers
Laravel migration seed fresh
PHP Laravel