ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

require_once __DIR__ . '/config.php';

$error = '';
$message = '';
/* =========================================================
   SERVICII EVENIMENT
========================================================= */

$serviceAction = $_POST['service_action'] ?? '';

if ($serviceAction === 'add_service') {

    $serviceId = (int)($_POST['service_id'] ?? 0);
    $quantity = (int)($_POST['quantity'] ?? 1);
    $serviceNotes = trim($_POST['service_notes'] ?? '');

    if ($quantity < 1) {
        $quantity = 1;
    }

    if ($serviceId <= 0) {

        $error = 'Selectează un serviciu.';

    } else {

        try {

            /*
             * Verificăm că serviciul aparține aceleiași firme
             * și este activ.
             */
            $stmtService = $pdo->prepare("
                SELECT id, name, price
                FROM services
                WHERE id = ?
                AND company_id = ?
                AND active = 1
                LIMIT 1
            ");

            $stmtService->execute([
                $serviceId,
                $companyId
            ]);

            $service = $stmtService->fetch(PDO::FETCH_ASSOC);

            if (!$service) {

                $error = 'Serviciul selectat nu este disponibil.';

            } else {

                /*
                 * Prețul este copiat în event_services.
                 * Astfel, dacă prețul serviciului se schimbă
                 * ulterior, evenimentul păstrează prețul vechi.
                 */
                $stmtAdd = $pdo->prepare("
                    INSERT INTO event_services
                    (
                        event_id,
                        service_id,
                        quantity,
                        price,
                        notes
                    )
                    VALUES (?, ?, ?, ?, ?)
                ");

                $stmtAdd->execute([
                    $id,
                    $serviceId,
                    $quantity,
                    $service['price'],
                    $serviceNotes !== '' ? $serviceNotes : null
                ]);

                $message = 'Serviciul a fost adăugat la eveniment.';
            }

        } catch (PDOException $e) {

            $error = 'Eroare la adăugarea serviciului: ' . $e->getMessage();
        }
    }
}


/* =========================================================
   ȘTERGERE SERVICIU DIN EVENIMENT
========================================================= */

if ($serviceAction === 'delete_service') {

    $eventServiceId = (int)($_POST['event_service_id'] ?? 0);

    if ($eventServiceId > 0) {

        try {

            /*
             * Ștergem doar dacă înregistrarea aparține
             * evenimentului curent.
             */
            $stmtDelete = $pdo->prepare("
                DELETE FROM event_services
                WHERE id = ?
                AND event_id = ?
            ");

            $stmtDelete->execute([
                $eventServiceId,
                $id
            ]);

            $message = 'Serviciul a fost eliminat din eveniment.';

        } catch (PDOException $e) {

            $error = 'Eroare la eliminarea serviciului: ' . $e->getMessage();
        }
    }
}


/* =========================================================
   SERVICII DISPONIBILE
========================================================= */

$stmtServices = $pdo->prepare("
    SELECT
        id,
        name,
        duration_hours,
        price
    FROM services
    WHERE company_id = ?
    AND active = 1
    ORDER BY name ASC
");

$stmtServices->execute([
    $companyId
]);

$availableServices = $stmtServices->fetchAll(PDO::FETCH_ASSOC);


/* =========================================================
   SERVICII DEJA ADAUGATE LA EVENIMENT
========================================================= */

$stmtEventServices = $pdo->prepare("
    SELECT
        es.id,
        es.service_id,
        es.quantity,
        es.price,
        es.notes,
        s.name,
        s.duration_hours
    FROM event_services es
    INNER JOIN services s
        ON s.id = es.service_id
    WHERE es.event_id = ?
    ORDER BY es.id ASC
");

$stmtEventServices->execute([
    $id
]);

$eventServices = $stmtEventServices->fetchAll(PDO::FETCH_ASSOC);


/* =========================================================
   TOTAL SERVICII
========================================================= */

$servicesTotal = 0;

foreach ($eventServices as $eventService) {

    $servicesTotal +=
        (float)$eventService['price'] *
        (int)$eventService['quantity'];
}

/* =========================
   VERIFICĂ ID EVENIMENT
========================= */

$id = (int)($_GET['id'] ?? $_POST['id'] ?? 0);

if ($id <= 0) {
    die('Eveniment invalid.');
}


/* =========================
   SALVARE MODIFICĂRI
========================= */

if ($_SERVER['REQUEST_METHOD'] === 'POST') {

    $client_id  = (int)($_POST['client_id'] ?? 0);
    $title      = trim($_POST['title'] ?? '');
    $event_date = $_POST['event_date'] ?? '';
    $start_time = $_POST['start_time'] ?: null;
    $end_time   = $_POST['end_time'] ?: null;
    $location   = trim($_POST['location'] ?? '');
    $status     = $_POST['status'] ?? 'lead';
    $total      = (float)($_POST['total'] ?? 0);
    $deposit    = (float)($_POST['deposit'] ?? 0);
    $notes      = trim($_POST['notes'] ?? '');

    if ($client_id <= 0) {

        $error = 'Selectează un client.';

    } elseif ($title === '') {

        $error = 'Introdu denumirea evenimentului.';

    } elseif ($event_date === '') {

        $error = 'Selectează data evenimentului.';

    } else {

        try {

            $stmt = $pdo->prepare("
                UPDATE events
                SET
                    client_id = ?,
                    title = ?,
                    event_date = ?,
                    start_time = ?,
                    end_time = ?,
                    location = ?,
                    status = ?,
                    total = ?,
                    deposit = ?,
                    notes = ?
                WHERE id = ?
            ");

            $stmt->execute([
                $client_id,
                $title,
                $event_date,
                $start_time,
                $end_time,
                $location ?: null,
                $status,
                $total,
                $deposit,
                $notes ?: null,
                $id
            ]);

            $message = 'Evenimentul a fost actualizat cu succes!';

        } catch (PDOException $e) {

            $error = 'Eroare la actualizare: ' . $e->getMessage();

        }
    }
}


/* =========================
   ÎNCARCĂ EVENIMENTUL
========================= */

try {

    $stmt = $pdo->prepare("
        SELECT *
        FROM events
        WHERE id = ?
        LIMIT 1
    ");

    $stmt->execute([$id]);

    $event = $stmt->fetch(PDO::FETCH_ASSOC);

    if (!$event) {
        die('Evenimentul nu există.');
    }

} catch (PDOException $e) {

    die('Eroare la încărcarea evenimentului: ' . $e->getMessage());

}


/* =========================
   CLIENȚI
========================= */

try {

    $clientsStmt = $pdo->query("
        SELECT id, name
        FROM clients
        ORDER BY name ASC
    ");

    $clients = $clientsStmt->fetchAll(PDO::FETCH_ASSOC);

} catch (PDOException $e) {

    die('Eroare la încărcarea clienților: ' . $e->getMessage());

}

?>

<!DOCTYPE html>
<html lang="ro">

<head>

    <meta charset="UTF-8">

    <meta name="viewport"
          content="width=device-width, initial-scale=1.0">

    <title>CRMEvent - Editare eveniment</title>

    <style>

        * {
            box-sizing: border-box;
        }

        body {
            margin: 0;
            font-family: Arial, sans-serif;
            background: #f3f4f6;
            color: #111827;
        }

        .header {
            background: #111827;
            color: white;
            padding: 18px 30px;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .header h1 {
            margin: 0;
            font-size: 24px;
        }

        .container {
            max-width: 850px;
            margin: 30px auto;
            padding: 0 20px;
        }

        .card {
            background: white;
            border-radius: 12px;
            padding: 30px;
            box-shadow: 0 5px 20px rgba(0,0,0,0.06);
        }

        h2 {
            margin-top: 0;
            margin-bottom: 25px;
        }

        .grid {
            display: grid;
            grid-template-columns: repeat(2, 1fr);
            gap: 18px;
        }

        .full {
            grid-column: 1 / -1;
        }

        label {
            display: block;
            font-weight: bold;
            margin-bottom: 7px;
        }

        input,
        select,
        textarea {
            width: 100%;
            padding: 12px;
            border: 1px solid #d1d5db;
            border-radius: 7px;
            font-size: 15px;
        }

        textarea {
            min-height: 120px;
            resize: vertical;
        }

        .buttons {
            display: flex;
            gap: 10px;
            margin-top: 10px;
        }

        button,
        .back {
            display: inline-block;
            padding: 13px 20px;
            border-radius: 7px;
            border: 0;
            font-size: 15px;
            cursor: pointer;
            text-decoration: none;
        }

        button {
            background: #111827;
            color: white;
        }

        .back {
            background: #e5e7eb;
            color: #111827;
        }

        .message {
            padding: 12px 15px;
            background: #dcfce7;
            color: #166534;
            border-radius: 8px;
            margin-bottom: 20px;
        }

        .error {
            padding: 12px 15px;
            background: #fee2e2;
            color: #991b1b;
            border-radius: 8px;
            margin-bottom: 20px;
        }

        @media (max-width: 700px) {

            .grid {
                grid-template-columns: 1fr;
            }

        }

    </style>

</head>

<body>

<div class="header">

    <h1>CRMEvent</h1>

    <div>
        Editare eveniment
    </div>

</div>


<div class="container">

    <div class="card">

        <h2>Editează eveniment</h2>


        

        

        <form method="post">

            <input
                type="hidden"
                name="id"
                value="0"
            >


            <div class="grid">


                <div>

                    <label>Client</label>

                    <select name="client_id" required>

                        <option value="">
                            Selectează clientul
                        </option>

                        
                    </select>

                </div>


                <div>

                    <label>Denumire eveniment</label>

                    <input
                        type="text"
                        name="title"
                        value=""
                        required
                    >

                </div>


                <div>

                    <label>Data evenimentului</label>

                    <input
                        type="date"
                        name="event_date"
                        value=""
                        required
                    >

                </div>


                <div>

                    <label>Status</label>

                    <select name="status">

                        
                            <option
                                value="lead"
                                                            >

                                Lead
                            </option>

                        
                            <option
                                value="oferta"
                                                            >

                                Ofertă
                            </option>

                        
                            <option
                                value="confirmat"
                                                            >

                                Confirmat
                            </option>

                        
                            <option
                                value="contract"
                                                            >

                                Contract
                            </option>

                        
                            <option
                                value="finalizat"
                                                            >

                                Finalizat
                            </option>

                        
                            <option
                                value="anulat"
                                                            >

                                Anulat
                            </option>

                        
                    </select>

                </div>


                <div>

                    <label>Ora început</label>

                    <input
                        type="time"
                        name="start_time"
                        value=""
                    >

                </div>


                <div>

                    <label>Ora sfârșit</label>

                    <input
                        type="time"
                        name="end_time"
                        value=""
                    >

                </div>
<!-- =====================================================
     SERVICII EVENIMENT
===================================================== -->

<div class="full">

    <div class="services-section">

        <h3>Servicii eveniment</h3>


        
            <div class="no-services">
                Nu există servicii adăugate la acest eveniment.
            </div>

        

        <!-- ADAUGĂ SERVICIU -->

        <div class="add-service-box">

            <h4>Adaugă serviciu</h4>

            <form method="post">

                <input
                    type="hidden"
                    name="id"
                    value="0"
                >

                <input
                    type="hidden"
                    name="service_action"
                    value="add_service"
                >


                <div class="service-add-grid">


                    <div>

                        <label>
                            Serviciu
                        </label>

                        <select
                            name="service_id"
                            required
                        >

                            <option value="">
                                Selectează serviciul
                            </option>

                            
                        </select>

                    </div>


                    <div>

                        <label>
                            Cantitate
                        </label>

                        <input
                            type="number"
                            name="quantity"
                            min="1"
                            value="1"
                            required
                        >

                    </div>


                    <div class="service-notes-field">

                        <label>
                            Observații serviciu
                        </label>

                        <input
                            type="text"
                            name="service_notes"
                            placeholder="Opțional"
                        >

                    </div>


                </div>


                <button
                    type="submit"
                    class="add-service-button"
                >
                    + Adaugă serviciu
                </button>

            </form>

        </div>

    </div>

</div>

                <div class="full">

                    <label>Locație</label>

                    <input
                        type="text"
                        name="location"
                        value=""
                    >

                </div>


                <div>

                    <label>Valoare totală (lei)</label>

                    <input
                        type="number"
                        name="total"
                        step="0.01"
                        min="0"
                        value=""
                    >

                </div>


                <div>

                    <label>Avans (lei)</label>

                    <input
                        type="number"
                        name="deposit"
                        step="0.01"
                        min="0"
                        value=""
                    >

                </div>


                <div class="full">

                    <label>Observații</label>

                    <textarea name="notes"></textarea>

                </div>


                <div class="full buttons">

                    <button type="submit">
                        Salvează modificările
                    </button>

                    <a
                        href="events.php"
                        class="back"
                    >
                        Înapoi la evenimente
                    </a>

                </div>

            </div>

        </form>

    </div>

</div>

</body>

</html>