<?php
namespace App;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Zizaco\Entrust\Traits\EntrustUserTrait;
use DB ;
class User extends Authenticatable
{
    use EntrustUserTrait;
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];
    
    public static function getUsers($id = FALSE)
    {
        $users = User::
            join('sys_status','sys_status.id','=','users.status_id')
            ->leftJoin('role_user','role_user.user_id','=','users.id')
            ->leftJoin('roles','roles.id','=','role_user.role_id')
            ->select('users.*', 'role_user.role_id' , 'roles.name as role_name' ,'sys_status.statusActive as status');
        if($id > 0)
        {
            $users = $users->where('users.id',$id);
        }
        $users = $users->groupBy('users.id')->orderBy('users.id', 'desc')->get();
        return $users ;
    }    


    // public function timeZone()
    // {
    //     return $this->belongsTo('App\Time_zone','timeZoneId')->withDefault();
    // }
    // public function language()
    // {
    //   return $this->belongsToMany('App\Language', 'user_language_rels','userId','languageId'); 
    // }
    // public static function fnName( $userId )
    // { 
    // }
}