/**
* atualiza um registro da tabela
*
* @parametro UsuarioPermissaoMySql usuarioPermissao
*/
public function update(UsuarioPermissao $UsuarioPermissao)
{
$sql = "UPDATE {$this->table} SET WHERE fk_usuario = :id";
$id = $UsuarioPermissao->getFkUsuario();
$stmt = ConnectionFactory::prepare($sql);
$stmt->bindParam(':id', $id);
return $stmt->execute();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('menus')->truncate();
$menu = array(array('id' => 1, 'descricao' => 'Usuarios', 'url' => '/users', 'icone' => 'ion ion-person-add', 'indice' => '', 'menu_pai' => null, 'created_at' => 'now()', 'updated_at' => 'now()', 'color' => 'blue'), array('id' => 28, 'descricao' => 'Taxas', 'url' => '/taxa', 'icone' => 'fa fa-money', 'indice' => null, 'menu_pai' => null, 'created_at' => 'now()', 'updated_at' => 'now()', 'color' => 'black'), array('id' => 29, 'descricao' => 'Corretor', 'url' => 'corretors', 'icone' => 'glyphicon glyphicon-user', 'indice' => null, 'menu_pai' => 28, 'created_at' => 'now()', 'updated_at' => 'now()', 'color' => null), array('id' => 30, 'descricao' => 'Itens', 'url' => 'itens', 'icone' => 'glyphicon glyphicon-ok', 'indice' => null, 'menu_pai' => 28, 'created_at' => 'now()', 'updated_at' => 'now()', 'color' => null), array('id' => 31, 'descricao' => 'Taxas', 'url' => 'taxas', 'icone' => 'glyphicon glyphicon-signal', 'indice' => null, 'menu_pai' => 28, 'created_at' => 'now()', 'updated_at' => 'now()', 'color' => null), array('id' => 32, 'descricao' => 'Relatorios', 'url' => 'relatorios', 'icone' => 'glyphicon glyphicon-list-alt', 'indice' => null, 'menu_pai' => 28, 'created_at' => 'now()', 'updated_at' => 'now()', 'color' => null));
DB::table('menus')->insert($menu);
$menu = Menu::all();
foreach ($menu as $value) {
$res = UsuarioPermissao::where('usuario_id', '=', 1)->where('menu_id', '=', $value->id)->count();
if ($res == 0) {
$permissao = new UsuarioPermissao();
$permissao->usuario_id = 1;
$permissao->menu_id = $value->id;
$permissao->save();
}
}
}
public function permite($usuario)
{
$permite = UsuarioPermissao::where('menu_id', $this->attributes['id'])->where('usuario_id', $usuario->id)->count();
return $permite;
//print_r($this->attributes['id']);
}
public function postMenu()
{
$input = Input::all();
$res = UsuarioPermissao::where('usuario_id', '=', $input['usuario_id'])->where('menu_id', '=', $input['menu_id'])->count();
if ($res == 0) {
$return = UsuarioPermissao::create($input);
} else {
$return = UsuarioPermissao::where('usuario_id', $input['usuario_id'])->where('menu_id', $input['menu_id'])->delete();
}
return $return;
}
*/
Route::filter('guest', function () {
if (Auth::check()) {
return Redirect::to('/');
}
});
/*
|--------------------------------------------------------------------------
| CSRF Protection Filter
|--------------------------------------------------------------------------
|
| The CSRF filter is responsible for protecting your application against
| cross-site request forgery attacks. If this special token in a user
| session does not match the one given in this request, we'll bail.
|
*/
Route::filter('csrf', function () {
if (Session::token() != Input::get('_token')) {
throw new Illuminate\Session\TokenMismatchException();
}
});
Route::filter('permissao', function ($route, $request) {
$url = '/' . $request->segment(1);
$idUrl = Menu::where('url', $url)->get();
// print_r(count($idUrl));
// die;
$permissao = UsuarioPermissao::where('usuario_id', Auth::user()->id)->where('menu_id', $idUrl[0]->id)->count();
if (!$permissao) {
return Response::make('Usuario não tem permissao para realizar este procedimento!', 401);
}
});
