Ejemplos de app\models customers::where en PHP

Ejemplo n.º 1

Archivo: customers.php Proyecto: brunocoelhor/photoecomm

            $customer->atualizar($id, $attributes);
            $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);

Ejemplo n.º 2

Archivo: customer.php Proyecto: brunocoelhor/photoecomm

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