Esempi in PHP per app\models albums::find_by_sql

Esempio n. 1

File: customers.php Progetto: brunocoelhor/photoecomm

            $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 !');
    $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);