use app\classes\slug; use app\classes\validation; use app\models\users; use app\models\customers; use app\models\categories; use app\models\albums; use app\models\images; use app\models\orders; use app\models\item_order; $app->get('/admin/orders/', function () use($app) { login::estaLogado('user_logado', $app); $users = users::where('name', $_SESSION['name']); $view = $app->view(); $view->setTemplatesDirectory(TEMPLATE_ADMIN); $categories = categories::listar(); $customers = customers::find('all', array('order' => 'name asc')); $albums = albums::find('all', array('order' => 'name asc')); $orders = orders::find_by_sql('SELECT order.id, order.date, order.customer_id, order.status, c.name FROM `order` JOIN customers c ON(order.customer_id = c.id) ORDER BY order.id DESC;'); $dados = array('pagina' => 'orders', 'users' => $users, 'categories' => $categories, 'customers' => $customers, 'albums' => $albums, 'orders' => $orders); $app->render('layout.php', $dados); }); $app->get('/admin/orders/orders_detail/:id', function ($id) use($app) { login::estaLogado('user_logado', $app); $users = users::where('name', $_SESSION['name']); $view = $app->view(); $view->setTemplatesDirectory(TEMPLATE_ADMIN); $items_order = item_order::find_by_sql("SELECT image_id, amount, total, i.name FROM `item_order`\n\t\tJOIN images i ON(item_order.image_id = i.id)\n\t\tWHERE item_order.order_id = {$id};"); $dados = array('pagina' => 'order_detail', 'users' => $users, 'items_order' => $items_order); $app->render('layout.php', $dados); }); $app->post('/admin/orders/orders_detail/edit_status/:id', function ($id) use($app) {
$app->redirect('/admin/customers'); } else { $attributes = array('name' => $name, 'email' => $email, 'password' => hash::hash($pass)); customers::cadastrar($attributes); $app->flash('sucesso', 'Cliente cadastrado com sucesso !'); $app->redirect('/admin/customers'); } } else { $app->flash('erro', $validation->mostrarErros()); $app->flash('nameAlbum', $name); $app->redirect('/admin/customers'); } } }); $app->post('/admin/customers/delete/:id', function ($id) use($app) { $customers = new customers(); $customers->deletar($id); $app->flash('sucesso', 'Cliente deletado com sucesso !'); $app->redirect('/admin/customers'); }); $app->post('/admin/customers/edit/:id', function () use($app) { $id = $app->request()->post('customer-id'); $name = $app->request()->post('customer-name'); $email = $app->request()->post('customer-email'); $pass = $app->request()->post('customer-pass'); $conf_pass = $app->request()->post('customer-conf-pass'); $validation = new validation(); $validacoes = array('customer-email' => 'obrigatorio', 'customer-pass' => 'obrigatorio'); $validar = $validation->validar($_POST, $validacoes); if ($pass != $conf_pass) { $app->flash('erro', 'As senhas não conferem. Digite novamente.');
$customer = customers::where('name', $_SESSION['name']); $categories = categories::listar(); $customer = customers::where('id', $id); $id = $customer->id; //$orders = orders::all(array('conditions' => array("id = $idOrder"))); $items_order = item_order::find_by_sql("SELECT image_id, amount, total, i.name FROM `item_order`\n\t\t\tJOIN images i ON(item_order.image_id = i.id)\n\t\t\tWHERE item_order.order_id = {$idOrder};"); $dados = array('categories' => $categories, 'customer' => $customer, 'items_order' => $items_order); $template = $twig->loadTemplate('order_detail.html'); $template->display($dados); } else { } }); $app->get('/area-do-cliente/:id/:slug', function ($id, $slug) use($app, $twig) { $logado = login::banLogado('user_logado', $app); if ($logado) { $customer = customers::where('name', $_SESSION['name']); } else { } $categories = \app\models\categories::listar(); $album = \app\models\albums::where('slug', $slug); $id = $album->id; $_SESSION['album'] = $id; $images = \app\models\images::all(array('conditions' => array('album_id = ?', $id))); $dados = array('categories' => $categories, 'album' => $album, 'images' => $images, 'customer' => $customer); $template = $twig->loadTemplate('customer-albums-photos.html'); $template->display($dados); }); $app->get('/image/buy/:id', function ($id) use($app) { $attributes = ['purchased' => 1]; $images = new \app\models\images(); $images->atualizar($id, $attributes);