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