setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Load services
$stmt = $conn->query("SELECT id, name, duration_minutes FROM services WHERE salon_id = 1 ORDER BY name");
$services = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Load masters
$stmt = $conn->query("SELECT id, name FROM masters WHERE salon_id = 1 ORDER BY name");
$masters = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Handle POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$name = htmlspecialchars($_POST['name'] ?? '');
$phone = htmlspecialchars($_POST['phone'] ?? '');
$service_id = intval($_POST['service_id'] ?? 0);
$master_id = intval($_POST['master_id'] ?? 0);
$date = htmlspecialchars($_POST['date'] ?? '');
$time = htmlspecialchars($_POST['time'] ?? '');
$notes = htmlspecialchars($_POST['notes'] ?? '');
// Validation
if (empty($name)) $errors[] = 'Укажите имя';
if (empty($phone) || !preg_match('/^\+375\d{9}$/', $phone)) $errors[] = 'Телефон в формате +375XXXXXXXXX';
if ($service_id <= 0) $errors[] = 'Выберите услугу';
if (empty($date)) $errors[] = 'Укажите дату';
if (empty($time)) $errors[] = 'Выберите время';
if (empty($errors)) {
$stmt = $conn->prepare("
INSERT INTO appointments (salon_id, client_name, client_phone, service_id, master_id, appointment_date, appointment_time, notes, status)
VALUES (1, :name, :phone, :service_id, :master_id, :date, :time, :notes, 'confirmed')
");
$stmt->execute([
':name' => $name,
':phone' => $phone,
':service_id' => $service_id,
':master_id' => $master_id ?: null,
':date' => $date,
':time' => $time,
':notes' => $notes
]);
$appointment_id = $conn->lastInsertId();
$success = true;
$message = "Спасибо, $name! Вы записаны на $date в $time.";
// Notify master via Telegram
if ($master_id > 0) {
$stmt = $conn->prepare("SELECT telegram_id FROM masters WHERE id = :id");
$stmt->execute([':id' => $master_id]);
$master = $stmt->fetch(PDO::FETCH_ASSOC);
if (!empty($master['telegram_id'])) {
$text = urlencode("📅 Новая запись!\nКлиент: $name\nТелефон: $phone\nУслуга: ID $service_id\nДата: $date $time\nЗаметки: " . ($notes ?: 'нет'));
$chat_id = $master['telegram_id'];
file_get_contents("https://api.telegram.org/bot$bot_token/sendMessage?chat_id=$chat_id&text=$text");
}
}
}
}
} catch (PDOException $e) {
$errors[] = 'Ошибка базы данных: ' . $e->getMessage();
}
?>
Запись онлайн | Салон красоты «Элизабет»