<?php
/** 首页 / 分类页 / 搜索页 */
require __DIR__ . '/inc/core.php';

$cat = (int)input('cat', 0);
$kw = (string)input('kw', '');
$sort = (string)input('sort', '');

if ($cat || $kw !== '' || $sort !== '' || isset($_GET['all'])) {
    $where = 'status = 1';
    $params = [];
    if ($cat) { $where .= ' AND category_id = ?'; $params[] = $cat; }
    if ($kw !== '') { $where .= ' AND (name LIKE ? OR subtitle LIKE ?)'; $params[] = "%$kw%"; $params[] = "%$kw%"; }
    $order = match ($sort) {
        'sales' => 'sales DESC', 'price_asc' => 'price ASC', 'price_desc' => 'price DESC', 'new' => 'id DESC',
        default => 'sort DESC, id DESC',
    };
    $page = max(1, (int)input('page', 1));
    $per = 20;
    $total = (int)val("SELECT COUNT(*) FROM products WHERE $where", $params);
    $products = rows("SELECT * FROM products WHERE $where ORDER BY $order LIMIT $per OFFSET " . (($page - 1) * $per), $params);
    $category = $cat ? row('SELECT * FROM categories WHERE id = ?', [$cat]) : null;
    $qs = http_build_query(array_filter(['all' => ($cat || $kw !== '') ? null : 1, 'cat' => $cat ?: null, 'kw' => $kw ?: null, 'sort' => $sort ?: null]));
    $pager = paginate($total, $page, $per, $qs ? $qs . '&' : '');
    $title = $category['name'] ?? ($kw !== '' ? "搜索：$kw" : '全部商品');
    view('list', compact('products', 'category', 'kw', 'sort', 'cat', 'total', 'pager', 'title'), $title);
    exit;
}

$banners = rows('SELECT * FROM banners ORDER BY sort DESC, id DESC');
$hot = rows('SELECT * FROM products WHERE status = 1 AND is_hot = 1 ORDER BY sort DESC, id DESC LIMIT 10');
// 每张轮播配 3 个真实商品：链接指向某分类就取该分类的商品，否则取热销
foreach ($banners as &$b) {
    $bc = preg_match('/[?&]cat=(\d+)/', (string)$b['link'], $mm) ? (int)$mm[1] : 0;
    $b['showcase'] = $bc ? rows('SELECT * FROM products WHERE status = 1 AND category_id = ? ORDER BY is_hot DESC, sales DESC LIMIT 3', [$bc]) : array_slice($hot, 0, 3);
}
unset($b);
$sections = [];
foreach (rows('SELECT * FROM categories ORDER BY sort DESC, id ASC') as $c) {
    $list = rows('SELECT * FROM products WHERE status = 1 AND category_id = ? ORDER BY sort DESC, id DESC LIMIT 10', [$c['id']]);
    if ($list) $sections[] = ['cat' => $c, 'products' => $list];
}
$latest = rows('SELECT o.product_name, o.created_at, u.username FROM orders o LEFT JOIN users u ON u.id = o.user_id WHERE o.status IN (1,2,3) ORDER BY o.id DESC LIMIT 8');
view('home', compact('banners', 'hot', 'sections', 'latest'));
