lundi 25 février 2019

Join two models with conditions in Laravel

I'm using two ManagerResult and manage models. I would like to extract all records between joining two DB but it returns a value of a column. The department_id is in manages DB. what change should I do in my code?

$manager_result = ManagerResult::join('manages', 'manage_id', 'manages.id')->select('manager_results.*')->where(function ($query) use ($win_seed) {
                $query->where('first_seed', $win_seed);
                $query->orWhere('second_seed', $win_seed);
            })->where('department_id', $manage->department_id)->first();



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire