/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

18 votes121 views4 answers
Laravel create model controller and migration on line
PHP Laravel
0 vote126 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
0 vote120 views1 answer
Data type for price in laravel
PHP Laravel
0 vote122 views2 answers
How do we calculate average in laravel 8
PHP Laravel
0 vote168 views1 answer
String length laravel validation
PHP Laravel
4 votes122 views2 answers
Switch in laravel
PHP Laravel
3 votes142 views2 answers
Laravel Migrations from an existing database
PHP Laravel
0 vote132 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
0 vote137 views1 answer
Laravel asset prevent browser caching
PHP Laravel
2 votes131 views2 answers
Laravel eloquent get all where in
PHP Laravel