<?php


namespace App\Repository\User;


use App\Http\Requests\User\CreateRequest;
use App\Http\Requests\User\IndexRequest;
use App\Http\Requests\User\UpdateRequest;
use App\Models\Role;
use App\Repository\BaseRepository;
use App\Traits\GridTrait;
use App\Traits\RoleTrait;
use App\Traits\UserTrait;
use App\User;
use Illuminate\Http\Request;

class UserRepository extends BaseRepository
{

    use UserTrait, RoleTrait, GridTrait;

    /**
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public static function getQuery()
    {
        return User::query();
    }

    public static function getDisplayed()
    {
        $query = static::getAvailable();
        $query->canLogin();

        return $query;
    }

    /**
     * @param IndexRequest $request
     *
     * @return mixed
     */
    public function search(IndexRequest $request)
    {
        $query = self::getAvailable();
        $this->makeQueryOrdered(User::class, $query, $request);

        $query->with('branches');

        if (isset($request->search) && !empty($request->search)) {
            $query->where('email', 'like', '%' . $request->search . '%');
        }
        if (isset($request->status_id)) {
            $query->where('access_system', (int) $request->status_id);
        }

        $query->whereHas('roles', function ($q) {
            $q->where('type', '!=', Role::service);
        });

        if (isset($request->role_id) && !empty($request->role_id)) {
            $role_id = (int) $request->role_id;
            $query->whereHas('roles', function ($q) use ($role_id) {
                $q->where('role_id', $role_id);
            });
        }
        if (isset($request->branch_id)) {
            $branch_id = (int) $request->branch_id;
            $query->whereHas('branches', function ($q) use ($branch_id) {
                $q->where('branch_id', $branch_id);
            });
        }

        $perPage = $request->per_page ?? config('crud.defaultPerPage');

        return $query->paginate((int) $perPage)->appends($request->all());
    }

    /**
     * @param CreateRequest $request
     */
    public function store(CreateRequest $request)
    {

    }

    public function edit(Request $request)
    {

    }

    public function update(UpdateRequest $request)
    {

    }


    /**
     * @param $id
     */
    public static function delete($id)
    {
        $user = self::getById($id);

        if ($user->service) {
            $user->service->delete();
        }
        $user->delete();
    }

    /**
     * Return items available for me, and available to login
     *
     * @param integer $branchId
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function getManagers($branchId = null)
    {
        $query = User::canLogin()->my()->getByRoleType(Role::manager);

        if (!empty($branchId)) {
            $query->whereHas('branches', function ($q) use ($branchId) {
                $q->where('branch_id', $branchId);
            });
        }

        return $query;
    }
}