query("SHOW COLUMNS FROM products LIKE 'purchase_type'"); if ($check_col->rowCount() === 0) { $db->exec("ALTER TABLE products ADD COLUMN purchase_type ENUM('normal', 'booking') DEFAULT 'normal' AFTER status"); } // Check and add image_path column to product_sizes $check_sz_col = $db->query("SHOW COLUMNS FROM product_sizes LIKE 'image_path'"); if ($check_sz_col->rowCount() === 0) { $db->exec("ALTER TABLE product_sizes ADD COLUMN image_path VARCHAR(255) NULL"); } // Auto-update system settings name to CMTC Smart Outfit Shopping & Booking $db->exec("UPDATE system_settings SET system_name = 'CMTC Smart Outfit Shopping & Booking' WHERE system_name = 'CMTC Shopping'"); } catch (Exception $e) { // Ignore migration error } $banners = []; $news = []; $products = []; $categories = []; if ($db) { try { $stmt_b = $db->query("SELECT * FROM banners WHERE status = 'active' ORDER BY sort_order ASC"); if ($stmt_b) $banners = $stmt_b->fetchAll(); } catch (Throwable $e) {} try { $stmt_n = $db->query("SELECT * FROM news WHERE status = 'active' ORDER BY id DESC LIMIT 3"); if ($stmt_n) $news = $stmt_n->fetchAll(); } catch (Throwable $e) {} // Filter values $cat_filter = isset($_GET['category']) ? intval($_GET['category']) : 0; $search_query = isset($_GET['search']) ? trim($_GET['search']) : ''; $sql = "SELECT p.*, c.name as category_name, (SELECT image_path FROM product_images WHERE product_id = p.id ORDER BY is_main DESC, id ASC LIMIT 1) as main_image, (SELECT COALESCE(SUM(quantity), 0) FROM product_stock WHERE product_id = p.id) as total_stock FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.status = 'active'"; $params = []; if ($cat_filter > 0) { $sql .= " AND p.category_id = ?"; $params[] = $cat_filter; } if (!empty($search_query)) { $sql .= " AND (p.name LIKE ? OR p.sku LIKE ?)"; $params[] = "%$search_query%"; $params[] = "%$search_query%"; } $sql .= " ORDER BY p.id DESC"; try { $stmt = $db->prepare($sql); $stmt->execute($params); $products = $stmt->fetchAll(); } catch (Throwable $e) {} try { $stmt_c = $db->query("SELECT * FROM categories ORDER BY name ASC"); if ($stmt_c) $categories = $stmt_c->fetchAll(); } catch (Throwable $e) {} } ?>

ช้อปสินค้าพรีเมียมและจอง

แหล่งรวมของที่ระลึกและบริการจองชุดหรูหราสำหรับทุกโอกาสสำคัญ

0): ?>

ข่าวประชาสัมพันธ์

ค้นหาสินค้าด่วน

หมวดหมู่สินค้าทั้งหมด

ทั้งหมด

รายการสินค้า ( รายการ)

0): ?>

ลด %

เปิดจอง 0 ? 'เหลือ ' . $prod['total_stock'] . ' ชิ้น' : 'หมดสต๊อก'; ?>

SKU:

ลด %

ดูรายละเอียด

ไม่พบสินค้าในระบบ