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/dceprojects.corals.io/Corals/modules/ProjectPlan/Scopes/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\Modules\ProjectPlan\Scopes;

use Corals\Foundation\Contracts\CoralsScope;

class UserPositionScope implements CoralsScope
{
    /**
     * @param $builder
     * @param array $extras
     */
    public function apply($builder, $extras = [])
    {
        $position = data_get($extras, 'position');

        $builder->join('pp_user_position', 'users.id', 'pp_user_position.user_id')
            ->where('pp_user_position.position_code', $position)
            ->select('users.*');
    }
}