/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 vote256 views1 answer
Laravel update order field sample
PHP Laravel
0 vote296 views1 answer
Laravel: Validation unique on update
PHP Laravel
1 vote257 views1 answer
Laravel active route check
PHP Laravel
8 votes286 views4 answers
Laravel between dates
PHP Laravel
8 votes305 views4 answers
Get single column value in laravel eloquent
PHP Laravel
1 vote291 views1 answer
Laravel multiple orderby
PHP Laravel
0 vote273 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
0 vote273 views2 answers
How to structure database in laravel
PHP Laravel
2 votes426 views1 answer
How to set field type of date of birth in laravel
PHP Laravel
1 vote289 views1 answer
Laravel eloquent where id not equal to
PHP Laravel