getConnection();
// Recupera lo school_id dalla sessione
$school_id = session('school_id');
$school = null;
$school_name = 'Nessuna scuola selezionata';
$school_logo_path = url('userarea/photoschool/yogibook_logo.png'); // Default logo
if ($school_id) {
$school = \Vanguard\Models\School::find($school_id);
if ($school) {
$school_name = $school->name;
$school_logo_path = $school->logo ? url('userarea/photoschool/' . $school->logo) : $school_logo_path;
}
}
$product_id = $_GET['product_id'] ?? 0;
// Recupera i dettagli del prodotto, verificando che appartenga alla scuola selezionata
$stmt = $pdo->prepare("
SELECT p.id, p.name AS product_name,
c.name AS class_name, c.description AS class_description, c.photo AS class_photo
FROM products p
LEFT JOIN product_class_types pct ON p.id = pct.product_id AND pct.variation_id IS NULL
LEFT JOIN class_types ct ON pct.class_type_id = ct.id
LEFT JOIN classes c ON ct.class_id = c.id
WHERE p.id = ? AND p.school_id = ?
GROUP BY p.id
");
$stmt->execute([$product_id, $school_id]);
$product = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$product) {
die("Prodotto non trovato o non appartiene alla scuola selezionata.");
}
// Recupera le variazioni del prodotto
$stmt = $pdo->prepare("
SELECT id, name, price
FROM product_variations
WHERE product_id = ? AND status = 'active'
");
$stmt->execute([$product_id]);
$variations = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Recupera le variazioni delle classi associate al prodotto
$stmt = $pdo->prepare("
SELECT ct.id, ct.level, ct.day_of_week
FROM product_class_types pct
JOIN class_types ct ON pct.class_type_id = ct.id
WHERE pct.product_id = ? AND pct.variation_id IS NULL
");
$stmt->execute([$product_id]);
$class_types = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
![<?php echo htmlspecialchars($product['class_name']); ?>](<?php echo htmlspecialchars($product['class_photo'] ?: 'default_class_image.jpg'); ?>)