comparison of two tables in laravel using model

Solutions on MaxInterview for comparison of two tables in laravel using model by the best coders in the world

showing results for - "comparison of two tables in laravel using model"

1$paidFeesIds = Fee::whereHas('paidFees', function($q) {
2    $q->where('payment_status', 1);
3})->pluck('id')->toArray();
4
5$notPaidFeesIds = Fee::whereNotIn('id', $paidFeesIds)->pluck('id')->toArray();

1public function paidFees()
2{
3    return $this->hasMany(PaidFees::class, 'fee_id');
4}

similar questions

multiple logical condition in laravel query laravel lumen use 2 databases double where condition in laravel laravel join 2 tables eloquent same column in and where laravel query laravel one command for model table and controller condition for both of one should be true laravel eloquent laravel get data from multiple tables laravel list of tables laravel show table columns laravel get data from multiple tables with laravel if database has table laravel table in model laravel model use specific table how condition for multiple row by orwhere laravel get data from 2 table in response laravel insrt data in two tablesuse laravelonce laravel where equal laravel model tablename two condition in one laravel query join multiple tables in laravel eloquent laravel relationship with for single data laravel list all tbales multiple orwhere condition in laravel laravel create table with model command line

queries leading to this page

how to compare a column between two table in laravel best way to comparison between tow table database in laravel laravel compare two tables comparison of two tables in laravel using model 2 models with same table laravel compare two fields of a tables in laravel comparer deux table eloquent how to compare two table in laravel and match same row if exist how to combine 2 column data in where clause laravel how to compare two tables in laravel compare two table and get same id data in laravel laravel model to combine two table data laravel multiple relationships same model comparison of two tables in laravel using model