Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/medad.corals.io/Corals/modules/Medad/DataTables/Scopes/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\Modules\Medad\DataTables\Scopes;

use Yajra\DataTables\Contracts\DataTableScope;

class UsersPerCompanyScope implements DataTableScope
{
    protected $company;

    public function __construct($company)
    {
        $this->company = $company;
    }

    /**
     * Apply a query scope.
     *
     * @param \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder $query
     * @return mixed
     */
    public function apply($query)
    {
        $query->join('medad_company_user', 'users.id', '=', 'medad_company_user.user_id')
            ->where('medad_company_user.company_id', $this->company->id);
    }
}