/PHP/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

14 votes102 views3 answers
Extract in php
PHP
0 vote115 views1 answer
Eloquent self foreign key
PHP
2 votes106 views2 answers
Wpdb last query
PHP
0 vote115 views1 answer
Bin/cake cache clear_all
PHP
0 vote68 views2 answers
Typeahead bootstrap 4 add multiple values
PHP
6 votes112 views5 answers
Php new object
PHP
0 vote105 views1 answer
How to get create table query preview in phpmyadmin
PHP
0 vote130 views1 answer
Laravel migration unknown column type double requested
PHP Laravel
0 vote137 views2 answers
Laravel collection collect
PHP Laravel
2 votes124 views3 answers
Laravel public static variable
PHP Laravel