$app->flash('sucesso', 'Dados do cliente alterados com sucesso !'); $app->redirect('/admin/customers'); } else { $app->flash('erro', $validation->mostrarErros()); $app->flash('nameAlbum', $name); $app->redirect('/admin/customers'); } } }); $app->get('/admin/customers/albums_manage/:id', function ($id) use($app) { login::estaLogado('user_logado', $app); $users = users::where('name', $_SESSION['name']); $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 !');
<?php use app\traits\login; use app\models\users; use app\models\categories; use app\models\albums; use app\models\images; use app\models\orders; $app->get('/painel', function () use($app) { login::estaLogado('user_logado', $app); $users = users::where('name', $_SESSION['name']); $categories = categories::find('all'); $albums = albums::find('all'); $images = images::find('all'); $orders = orders::find('all'); $view = $app->view(); $view->setTemplatesDirectory(TEMPLATE_ADMIN); $dados = array('pagina' => 'painel', 'name' => $_SESSION['name'], 'users' => $users, 'categories' => $categories, 'albums' => $albums, 'images' => $images, 'orders' => $orders); $app->render('layout.php', $dados); });