/** * 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); } });