/** * test for deleting users data [delete user 3 & 4] * * @return void */ public function testDelete() { users::where('email', '*****@*****.**')->delete(); users::where('email', '*****@*****.**')->delete(); $this->dontSeeInDatabase('users', ['email' => '*****@*****.**']); $this->dontSeeInDatabase('users', ['email' => '*****@*****.**']); }
$view = $app->view(); $view->setTemplatesDirectory(TEMPLATE_ADMIN); $customer = customers::where('id', $id); $albums = albums::find('all', array('order' => 'name asc')); $albumsCustomers = albumsCustomers::where('customers_id', $id, 'all'); $join = "JOIN albums_customers a ON(albums.id = a.albums_id) WHERE customers_id = {$id}"; // $manages = albums::all(array('joins' => $join)); $manages = albums::find_by_sql("SELECT a.id as ab, albums.name, albums.cover FROM albums JOIN albums_customers a ON ( albums.id = a.albums_id ) WHERE customers_id = {$id}"); $dados = array('pagina' => 'albums_customer', 'albums' => $albums, 'customer' => $customer, 'users' => $users, 'albumsCustomers' => $albumsCustomers, 'manages' => $manages); $app->render('layout.php', $dados); }); $app->post('/admin/customers/albums_manage/album_add', function () use($app) { login::estaLogado('user_logado', $app); $users = users::where('name', $_SESSION['name']); $customer = $app->request()->post('customer'); $album = $app->request()->post('album'); $attributes = array('customers_id' => $customer, 'albums_id' => $album); albumsCustomers::cadastrar($attributes); $app->flash('sucesso', 'Relação cadastrada com sucesso !'); $app->redirect("/admin/customers/albums_manage/{$customer} "); }); $app->delete('/admin/customers/albums_manage/album_del/:id', function ($id) use($app) { login::estaLogado('user_logado', $app); $users = users::where('name', $_SESSION['name']); $id = filter_var($id, FILTER_SANITIZE_NUMBER_INT); albumsCustomers::deletar($id); // $images = new images(); // // $images->deletar($id); // echo 'deletou'; });
function userEmailbyID($id) { $user = users::where('id', '=', $id)->firstOrFail(); return $user->email; }
/** * Submit function of the Users Page. * * @return \Illuminate\Http\Response */ public function SettingsSubmit(Request $request) { $input = $request->all(); $UserId = Auth::user()->id; $Name = $input['Name']; $Email = $input['Email']; $Telephone = $input['Telephone']; $Password = $input['password']; $RePassword = $input['password_confirmation']; //create validation array if ($Password == "") { $rules = array('Name' => 'regex:/(^[A-Za-z ]+$)+/', 'Email' => 'required|email', 'Telephone' => 'regex:/(^\\(?0\\d{2}\\)?[\\s\\-]?\\d{7}$)+/'); } else { $rules = array('Name' => 'regex:/(^[A-Za-z ]+$)+/', 'Email' => 'required|email', 'Telephone' => 'regex:/(^\\(?0\\d{2}\\)?[\\s\\-]?\\d{7}$)+/', 'password' => 'required|min:6|confirmed'); } // $messages = [ // 'b_name.required' => 'please fill Broadcast Name field', // 'base_size.required' => 'please fill Base Size field', // 'base_size.integer' => 'Please insert integer', // 'date.required' => 'please fill Broadcast Date', // 'start_date.date' => 'Please insert valid start_date format', // 'end_date.date' => 'Please insert valid end_date format', // ]; //use validation class $validation = Validator::make($input, $rules); //if validation fails, redirect. if ($validation->fails()) { return redirect('dashboard/settings')->withErrors($validation)->withInput(); } try { if ($Password == "") { users::where('id', $UserId)->update(['name' => $Name, 'Email' => $Email, 'telephone' => $Telephone]); return redirect('dashboard/settings')->with('message', 'Your settings have been updated Successfully.')->with('type', 'success')->with('title', 'Settings Saved!'); } else { users::where('id', $UserId)->update(['name' => $Name, 'Email' => $Email, 'telephone' => $Telephone, 'password' => bcrypt($Password)]); return redirect('dashboard/settings')->with('message', 'Your settings have been updated Successfully.')->with('type', 'success')->with('title', 'Settings Saved!'); } } catch (\Illuminate\Database\QueryException $e2) { return redirect('dashboard/settings')->with('message', 'Failed to update!')->with('type', 'error')->with('title', 'Error'); } }
/** * test for deleting users data * * @return void */ public function testDelete() { //delete record ClientList::where('email', '*****@*****.**')->delete(); users::where('email', '*****@*****.**')->delete(); ClientList::where('email', '*****@*****.**')->delete(); users::where('email', '*****@*****.**')->delete(); ClientList::where('email', '*****@*****.**')->delete(); users::where('email', '*****@*****.**')->delete(); //assert records are not in database $this->dontSeeInDatabase('clients', ['email' => '*****@*****.**']); $this->dontSeeInDatabase('clients', ['email' => '*****@*****.**']); $this->dontSeeInDatabase('clients', ['email' => '*****@*****.**']); }
function search($query) { return users::where('firstName', 'LIKE', '%' . $query . '%')->orWhere('lastName', 'LIKE', '%' . $query . '%')->orWhere('email', 'LIKE', '%' . $query . '%')->get(); }
$view = $app->view(); $view->setTemplatesDirectory(TEMPLATE_ADMIN); $facebook = $app->request()->post('facebook'); $linkedin = $app->request()->post('linkedin'); $twitter = $app->request()->post('twitter'); $gplus = $app->request()->post('gplus'); $attributes = array('facebook' => $facebook, 'linkedin' => $linkedin, 'twitter' => $twitter, 'gplus' => $gplus); $social = new social(); $social->atualizar('1', $attributes); $app->flash('sucesso', 'Dados das redes sociais alterados com sucesso !'); $app->redirect('/admin/configuration'); }); $app->post('/admin/configuration/password/', function () use($app) { login::estaLogado('user_logado', $app); // $users = users::where('name',$_SESSION['name']); $users = users::where('id', $_SESSION['id']); $id = $users->id; $view = $app->view(); $view->setTemplatesDirectory(TEMPLATE_ADMIN); $old_pass = $app->request()->post('old-pass'); $pass = $app->request()->post('pass'); $conf_pass = $app->request()->post('conf-pass'); $validation = new validation(); $validacoes = array('old-pass' => 'obrigatorio', 'pass' => 'obrigatorio', 'conf-pass' => 'obrigatorio'); $validar = $validation->validar($_POST, $validacoes); if ($pass != $conf_pass) { $app->flash('erro', 'As senhas não conferem. Digite novamente.'); $app->redirect('/admin/configuration'); } else { if ($validar) { $user = new users();