@if (in_array('Scanner', $privileges)) @php $user = Auth::user(); $agencyIds = $user->viewable_agency_ids; $query = App\Models\Department::with('client.agency')->withCount([ 'channels as active_employee_count' => function ($query) { $query->where('status', 1); }, ]); if (!empty($agencyIds)) { $query->whereHas('client.agency', function ($q) use ($agencyIds) { $q->whereIn('id', $agencyIds); }); $assignIds = App\Models\Assign::where('user_id', $user->id)->whereIn('agency_id', $agencyIds)->pluck('id'); $restrictedCompanyIds = App\Models\AssignCompany::whereIn('assign_id', $assignIds)->pluck('id'); $restrictedDepartmentIds = App\Models\AssignCompanyDepartment::whereIn( 'assigncompany_id', $restrictedCompanyIds, ) ->pluck('department_id') ->unique(); if ($restrictedDepartmentIds->isNotEmpty()) { $query->whereIn('id', $restrictedDepartmentIds); } } $data = $query->get(); $currentclient = App\Models\Department::where('user_id', $user->id)->first(); @endphp