<?php

namespace App\Models;

use Hoyvoy\CrossDatabase\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class UserRoleFromProject extends Model
{
    protected $connection = "mysql_proj";
    protected $table = "user_roles";
    protected $guarded = [''];

    public $timestamps = false;

    protected static function withRoleLevel()
    {
        return false;
    }

    public function role()
    {
        return $this->belongsTo(Role::class);
    }

    public function scopeOnlyProjectManager($q)
    {
        if (env('DB_DATABASE')) {
            return $q->whereHas('role', function ($q) {
                $q->from(
                    env('DB_DATABASE') . '.roles'
                )->where('name', DB::raw('LOWER("project manager")'));
            });
        }

        return $q;
    }

    public function user()
    {
        return $this->setConnection('mysql_hris')
            ->hasOne(User::class, 'id', 'user_id');
    }
}