polizia_frascati/app/Models/User.php

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Sanctum\HasApiTokens;

class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;

    protected $table = 'fcf_users';

    public $timestamps = false;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'email',
        'password',
        'username',
        'firstname',
        'lastname'
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];


    public function group()
    {
        $rel = \App\Models\UserUserGroup::where('user_id', $this->id)->first();
        if ($rel)
        {
            if ($rel->group_id > 0)
                return \App\Models\UserGroup::findOrFail($rel->group_id)->name;
            else
                return "";
        }
        else
            return "";
    }

    public function userGroups()
    {
        return $this->hasMany(UserUserGroup::class, 'user_id');
    }

    public function groups()
    {
        return $this->belongsToMany(UserGroup::class, 'fcf_user_user_groups', 'user_id', 'group_id');
    }


}