<?php

namespace App;

use Illuminate\Foundation\Auth\User as Authenticatable;
use DB;

use Illuminate\Notifications\Notifiable;

class User extends Authenticatable
{
	use Notifiable;

	protected $table = 'sis_users';

	/**
	* The attributes that are mass assignable.
	*
	* @var array
	*/
	protected $fillable = [
		'name', 'email', 'password', 'id_user_group'
	];

	/**
	* The attributes that should be hidden for arrays.
	*
	* @var array
	*/
	protected $hidden = [
		'password', 'remember_token',
	];


	public function userGroup(){
		return $this->belongsTo('\App\UserGroup','id_user_group');
	}

	public static function getUsersMaster(){
		return DB::table('sis_users')->where('id_user_group', 1)->get();
	}

	public static function criar($input){

		$arrayInput = [
			'email' => $input['email'],
			'first_name' => $input['name'],
			'password' => bcrypt($input['password']),
			//'id_user_group' => $input['id_user_group'],
		];
		if(isset($input['id_empresa']) && $input['id_empresa']){
			$arrayInput['id_empresa'] = $input['id_empresa'];
		}
		DB::table('sis_users')->insert([
			$arrayInput
		]);

		$id_user = DB::getPdo()->lastInsertId();


		return $id_user;
	}

	public static function editar($input, $id){

		$updateArray = [
			'email'               => $input['email'],
			'thumbnail_principal' => isset($input['thumbnail_principal']) ? $input['thumbnail_principal'] : NULL
		];

		if(isset($input['name']) && $input['name']){
			$updateArray['first_name'] = $input['name'];
		}

		if(isset($input['id_empresa']) && $input['id_empresa']){
			$updateArray['id_empresa'] = $input['id_empresa'];
		}

		if($input['password'] != ''){
			$updateArray['password'] = bcrypt($input['password']);
		}

		DB::table('sis_users')->where('id', $id)
		->update($updateArray);

		return $id;
	}

	public function roleUser(){
		return $this->hasOne('App\RoleUser', 'user_id');
	}

	public function ativacao(){
		return $this->hasOne('App\UserActivation', 'user_id');
	}

	public function condomino(){
		return $this->belongsTo('App\Modules\Condominos\Models\Condominos', 'id_condomino');
	}

	public function cliente(){
		return $this->hasOne('App\Modules\Cadastro\Models\Cadastro', 'user_id');
	}

	public function routeNotificationForMail()
    {
        return $this->email;
    }
}