prepare("SELECT * FROM vendors WHERE store_slug = ? AND status = 'approved'");
$stmt->execute([$slug]);
$vendor = $stmt->fetch();
} elseif ($id > 0) {
$stmt = $db->prepare("SELECT * FROM vendors WHERE id = ? AND status = 'approved'");
$stmt->execute([$id]);
$vendor = $stmt->fetch();
} else {
$vendor = false;
}
if (!$vendor) {
header('Location: ' . SITE_URL . '/vendors.php');
exit;
}
$vendorId = (int)$vendor['id'];
// Filtering parameters
$vcat_id = isset($_GET['vcategory']) ? (int)$_GET['vcategory'] : 0;
$cat_id = isset($_GET['category']) ? (int)$_GET['category'] : 0;
$search = isset($_GET['search']) ? sanitize($_GET['search']) : '';
$sort = isset($_GET['sort']) ? sanitize($_GET['sort']) : 'latest';
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$limit = 8;
$offset = ($page - 1) * $limit;
// Build query for products belonging to this vendor
$where = ["p.vendor_id = ?", "p.status = 'active'"];
$params = [$vendorId];
if ($vcat_id > 0) {
$where[] = "p.vendor_category_id = ?";
$params[] = $vcat_id;
}
if ($cat_id > 0) {
$where[] = "p.category_id = ?";
$params[] = $cat_id;
}
if (!empty($search)) {
$where[] = "(p.name LIKE ? OR p.description LIKE ?)";
$params[] = "%$search%";
$params[] = "%$search%";
}
$whereClause = implode(" AND ", $where);
// Sorting logic
$orderBy = "p.created_at DESC";
if ($sort === 'price_asc') $orderBy = "p.price ASC";
if ($sort === 'price_desc') $orderBy = "p.price DESC";
// Count products
$countStmt = $db->prepare("SELECT COUNT(*) FROM products p WHERE $whereClause");
$countStmt->execute($params);
$totalProducts = $countStmt->fetchColumn();
$totalPages = ceil($totalProducts / $limit);
// Fetch products
$query = "SELECT p.*, c.name as category_name, vc.name as vcat_name
FROM products p
JOIN categories c ON p.category_id = c.id
LEFT JOIN vendor_categories vc ON p.vendor_category_id = vc.id
WHERE $whereClause
ORDER BY $orderBy
LIMIT $limit OFFSET $offset";
$stmt = $db->prepare($query);
$stmt->execute($params);
$products = $stmt->fetchAll();
// Fetch sub-categories of this vendor
$vcatStmt = $db->prepare("SELECT * FROM vendor_categories WHERE vendor_id = ? AND is_active = 1 ORDER BY sort_order ASC");
$vcatStmt->execute([$vendorId]);
$vendorCategories = $vcatStmt->fetchAll();
$pageTitle = sanitize($vendor['store_name']) . " - หน้าร้านค้า";
require_once __DIR__ . '/../includes/header.php';
?>
1): ?>