Categories & Banners API

<?php
require_once __DIR__ . '/../includes/helpers.php';
require_method('GET');

$rows = db()->query(
    'SELECT c.id, c.name, c.slug, c.image,
            (SELECT COUNT(*) FROM products p WHERE p.category_id = c.id AND p.is_active = 1) AS product_count
     FROM categories c WHERE c.is_active = 1 ORDER BY c.sort_order, c.name'
)->fetchAll();

$out = array();
foreach ($rows as $r) {
    $out[] = array(
        'id' => (int) $r['id'],
        'name' => $r['name'],
        'slug' => $r['slug'],
        'image' => img_url($r['image']),
        'product_count' => (int) $r['product_count'],
    );
}
ok($out);

<?php
require_once __DIR__ . '/../includes/helpers.php';
require_method('GET');

$rows = db()->query('SELECT * FROM banners WHERE is_active = 1 ORDER BY sort_order, id')->fetchAll();
$out = array();
foreach ($rows as $b) {
    $out[] = array(
        'id' => (int) $b['id'],
        'title' => $b['title'],
        'subtitle' => $b['subtitle'],
        'image' => img_url($b['image']),
        'link_type' => $b['link_type'],
        'link_id' => $b['link_id'] === null ? null : (int) $b['link_id'],
    );
}
ok($out);

<?php
// Everything the Home screen needs in ONE request: banners, categories,
// featured products, deals and new arrivals.
require_once __DIR__ . '/../includes/helpers.php';
require_method('GET');

$userId = optional_user_id();
$wish = $userId ? wishlist_ids($userId) : array();

function shape_list($rows, $wish)
{
    $out = array();
    foreach ($rows as $r) {
        $p = product_out($r);
        $p['in_wishlist'] = isset($wish[$p['id']]);
        $out[] = $p;
    }
    return $out;
}

$banners = array();
foreach (db()->query('SELECT * FROM banners WHERE is_active = 1 ORDER BY sort_order, id')->fetchAll() as $b) {
    $banners[] = array(
        'id' => (int) $b['id'], 'title' => $b['title'], 'subtitle' => $b['subtitle'],
        'image' => img_url($b['image']), 'link_type' => $b['link_type'],
        'link_id' => $b['link_id'] === null ? null : (int) $b['link_id'],
    );
}

$categories = array();
foreach (db()->query('SELECT id, name, image FROM categories WHERE is_active = 1 ORDER BY sort_order, name')->fetchAll() as $c) {
    $categories[] = array('id' => (int) $c['id'], 'name' => $c['name'], 'image' => img_url($c['image']));
}

$featured = db()->query('SELECT * FROM products WHERE is_active = 1 AND is_featured = 1 ORDER BY id DESC LIMIT 10')->fetchAll();
// Deals = biggest discount percentage first
$deals = db()->query('SELECT * FROM products WHERE is_active = 1 AND mrp > price ORDER BY (mrp - price) / mrp DESC LIMIT 10')->fetchAll();
$latest = db()->query('SELECT * FROM products WHERE is_active = 1 ORDER BY created_at DESC, id DESC LIMIT 10')->fetchAll();

ok(array(
    'banners'      => $banners,
    'categories'   => $categories,
    'featured'     => shape_list($featured, $wish),
    'deals'        => shape_list($deals, $wish),
    'new_arrivals' => shape_list($latest, $wish),
));