<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;
use DB;
use App\Http\Controllers\BaseController;
use App\Http\Requests;
use App\User;
use Sentinel;
use Activation;

class UserController extends BaseController
{
	public function __construct(){
		parent::__construct();
		$this->middleware('auth');
	}

	public function index(Request $request){
		if(!$this->current_user->inRole('admins')){
			return redirect('admin');
		}

		$query = User::select('sis_users.*');

		$query->orderBy('id', 'DESC');

		if ($request->input('email'))
        {
        	$query->where('sis_users.email', 'like', '%'.$request->input('email').'%');
        }

        if ($request->input('id_role'))
        {
        	$id_role = $request->input('id_role');
        	$query->whereRaw("EXISTS (SELECT 1 FROM sis_role_users sru, sis_roles sr WHERE sru.role_id = sr.id AND sru.user_id = sis_users.id AND sr.id = {$id_role})");
        }

		if ($request->input('term'))
        {
        	$query->where(function($qr) use ($request){
        		$qr->where('sis_users.first_name', 'like', '%'.$request->input('term').'%');
            	$qr->orWhere('sis_users.last_name', 'like', '%'.$request->input('term').'%');
        	});
        }

		$data['listaUser'] = $query->orderBy('sis_users.id', 'ASC')->with('roleUser')->paginate(20);
		$data['roles']     = \App\Role::get();

		return view('admin/users',$data);
	}

	public function add(){
		$data = array();
		$data['roles'] = \App\Role::get();
		$data['userLogado'] = \App\User::find(Sentinel::getUser()->id);
		return view('admin/form-users', $data);
	}

	public function edit($id){
		$data['user'] = \App\User::find($id);
		$data['roles'] = \App\Role::get();
		$data['userLogado'] = \App\User::find(Sentinel::getUser()->id);
		return view('admin/form-users',$data);
	}



	public function save(Request $request){
		try{
			$post = $request->input();
			$role = Sentinel::findRoleById($post['id_role']);
			if($request->input('id')){
				$id_user = \App\User::editar($post, $request->input('id'));
				$user = Sentinel::findById($id_user);
				$user->roles()->detach();
			}else{
				$id_user = \App\User::criar($post);
				$user = Sentinel::findById($id_user);
				$activation = Activation::create($user);
				Activation::complete($user, $activation->code);
			}

			$role->users()->attach($user);
			\Session::flash('type', 'success');
			\Session::flash('message', "Alteracoes salvas com sucesso!");
			return redirect('admin/users');
		}catch(Exception $e){
			\Session::flash('type', 'error');
			\Session::flash('message', $e->getMessage());
			return redirect()->back();
		}


	}

	public function upload_image(Request $request) {
		if($request->hasFile('file')) {
			//upload an image to the /img/tmp directory and return the filepath.
			$file = $request->file('file');
			$tmpFilePath = '/uploads/users/';
			$tmpFileName = time() . '-' . $file->getClientOriginalName();
			$file = $file->move(public_path() . $tmpFilePath, $tmpFileName);
			$path = $tmpFilePath . $tmpFileName;
			return response()->json(array('path'=> $path, 'file_name'=>$tmpFileName), 200);
		} else {
			return response()->json(false, 200);
		}
	}

	public function crop_image(Request $request) {
		$img = \Image::make('uploads/users/'.$request->input('file_name'));
		$dataCrop = json_decode($request->input('data_crop'));
		if($img->crop(intval($dataCrop->width), intval($dataCrop->height), intval($dataCrop->x), intval($dataCrop->y))->save('uploads/users/thumb_'.$request->input('file_name'))){
			@unlink('uploads/users/'.$request->input('file_name'));
			echo json_encode(array(
				'status' => true,
				'path' => '/uploads/users/thumb_'.$request->input('file_name'),
				'file_name' => 'thumb_'.$request->input('file_name'),
			));
		}else{
			echo json_encode(array(
				'status' => false,
				'message' => 'Não foi possível alterar a imagem.'
			));
		}

	}

	public function delete($id){
		try{
			$user = \App\User::find($id);
			DB::table('sis_users')
			->where('id', $id)
			->delete();
			@unlink("uploads/users/$user->thumbnail_principal");
			\Session::flash('type', 'success');
			\Session::flash('message', "Registro removido com sucesso!");
			return redirect('admin/users');
		}catch(Exception $e){
			\Session::flash('type', 'error');
			\Session::flash('message', "Nao foi possivel remover o registro!");
			return redirect()->back();
		}


	}
}