Ajándékutalvány/Kupon lekérdező

PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,];try { $pdo = new PDO($dsn, DEFAULT_USER, DEFAULT_PASS, $options);} catch (\PDOException $e) { die('Adatbázis hiba: ' . $e->getMessage());}// --- Szobanév leképezés ---$roomNames = [ 2 => 'Outlast', 4 => 'Pénzrablás', 5 => 'Fertőzés', 7 => 'Fűrész'];$message = '';$today = new DateTime();if (isset($_POST['promo_code'])) { $promo_code = trim($_POST['promo_code']); // Lekérdezés az érvényes kuponok között $stmt = $pdo->prepare("SELECT * FROM gz_time_slot_discount WHERE promo_code = ?"); $stmt->execute([$promo_code]); $discount = $stmt->fetch(); if ($discount) { $promoDate = new DateTime($discount['promodate']); $roomName = $roomNames[$discount['calendar_id']] ?? "Ismeretlen szoba"; if ($promoDate < $today) { // Lejárt kupon áthelyezése $stmtCheckExpired = $pdo->prepare("SELECT * FROM gz_time_slot_discount_expired WHERE promo_code = ?"); $stmtCheckExpired->execute([$promo_code]); if (!$stmtCheckExpired->fetch()) { $stmtInsertExpired = $pdo->prepare(" INSERT INTO gz_time_slot_discount_expired (id, calendar_id, discount_title, promo_code, discount, type, promodate) VALUES (?, ?, ?, ?, ?, ?, ?) "); $stmtInsertExpired->execute([ $discount['id'], $discount['calendar_id'], $discount['discount_title'], $discount['promo_code'], $discount['discount'], $discount['type'], $discount['promodate'] ]); } $stmtDelete = $pdo->prepare("DELETE FROM gz_time_slot_discount WHERE promo_code = ?"); $stmtDelete->execute([$promo_code]); $message = ''; } else { $message = ''; } } else { // Ellenőrzés a lejárt kuponok között $stmtExpired = $pdo->prepare("SELECT * FROM gz_time_slot_discount_expired WHERE promo_code = ?"); $stmtExpired->execute([$promo_code]); $expired = $stmtExpired->fetch(); if ($expired) { $roomName = $roomNames[$expired['calendar_id']] ?? "Ismeretlen szoba"; $message = ''; } else { $message = ''; } }}?>