<?php
require_once('include/headscript.php');

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die(json_encode(['success' => false, 'message' => 'Connessione al database fallita']));
}

$id_booking_class = isset($_POST['id']) ? intval($_POST['id']) : 0;
$class_id = isset($_POST['class_id']) ? intval($_POST['class_id']) : 0;
$new_date = isset($_POST['new_date']) ? $_POST['new_date'] : '';

if ($id_booking_class <= 0 || $class_id <= 0 || empty($new_date)) {
    die(json_encode(['success' => false, 'message' => 'Dati non validi']));
}

// Ottieni i dettagli della classe attuale
$sql = "SELECT bookingstart, servicename, day, time FROM bookingclass WHERE idbookingclass = ?";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, 'i', $id_booking_class);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$current_class = mysqli_fetch_assoc($result);

if (!$current_class) {
    die(json_encode(['success' => false, 'message' => 'Lezione non trovata']));
}

// Ottieni i dettagli della nuova classe
$sql = "SELECT servicename, day, time FROM classes WHERE id = ?";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, 'i', $class_id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$new_class = mysqli_fetch_assoc($result);

if (!$new_class) {
    die(json_encode(['success' => false, 'message' => 'Classe non trovata']));
}

// Aggiorna la lezione
$sql = "UPDATE bookingclass 
        SET bookingstart = ?, prevbookingstart = ?, servicename = ?, day = ?, time = ?
        WHERE idbookingclass = ?";
$stmt = mysqli_prepare($conn, $sql);
$new_bookingstart = $new_date . ' ' . $new_class['time'] . ':00';
mysqli_stmt_bind_param($stmt, 'sssssi', $new_bookingstart, $current_class['bookingstart'], $new_class['servicename'], $new_class['day'], $new_class['time'], $id_booking_class);

if (mysqli_stmt_execute($stmt)) {
    echo json_encode(['success' => true]);
} else {
    echo json_encode(['success' => false, 'message' => 'Errore durante l\'aggiornamento della lezione']);
}

mysqli_stmt_close($stmt);
mysqli_close($conn);