<?php
// Include the database connection
include('dbconnect.php');

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $applicant_id = $_POST['applicant_id'];
    $interview_date = $_POST['interview_date'];
    $selection_status = $_POST['selection_status'];

    $sql = "INSERT INTO candidate_selection (applicant_id, interview_status, selection_status, interview_date, selection_date)
            VALUES (?, 'Completed', ?, ?, NOW())
            ON DUPLICATE KEY UPDATE 
                interview_status = 'Completed', 
                selection_status = ?, 
                interview_date = ?, 
                selection_date = NOW()";

    if ($stmt = $con->prepare($sql)) {
        $stmt->bind_param("isssss", $applicant_id, $selection_status, $interview_date, $selection_status, $interview_date);
        if ($stmt->execute()) {
            header("Location: " . $_SERVER['PHP_SELF']);
            exit();
        } else {
            echo "<p style='color:red; font-weight:700;'>❌ Error: " . $stmt->error . "</p>";
        }
        $stmt->close();
    } else {
        echo "<p style='color:red; font-weight:700;'>❌ Error preparing query: " . $con->error . "</p>";
    }
}

// Fetch applicants
$applicants_sql = "SELECT * FROM job_applicants";
$applicants_result = $con->query($applicants_sql);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8" />
    <title>Interview Status Update</title>
    <meta name="viewport" content="width=device-width, initial-scale=1" />

    <!-- FontAwesome CDN for icons -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" />

    <style>
        /* Reset */
        * {
            box-sizing: border-box;
        }

        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: linear-gradient(135deg, #2980b9, #6dd5fa);
            margin: 0;
            padding: 0;
            min-height: 100vh;
            display: flex;
            flex-direction: column;
        }

        header {
            background-color: #1c3f6d;
            color: #fff;
            padding: 15px 25px;
            display: flex;
            justify-content: space-between;
            align-items: center;
            box-shadow: 0 4px 8px rgba(0,0,0,0.2);
        }

        header h2 {
            margin: 0;
            font-weight: 700;
            font-size: 1.8rem;
            letter-spacing: 1.5px;
            user-select: none;
        }

        .logout-btn {
            background-color: #e74c3c;
            border: none;
            padding: 10px 22px;
            border-radius: 5px;
            color: #fff;
            font-weight: 700;
            font-size: 0.9rem;
            cursor: pointer;
            display: flex;
            align-items: center;
            gap: 8px;
            transition: background-color 0.3s ease;
        }

        .logout-btn i {
            font-size: 1.1rem;
        }

        .logout-btn:hover {
            background-color: #c0392b;
        }

        .container {
            background: #fff;
            max-width: 600px;
            margin: 40px auto 60px auto;
            border-radius: 12px;
            padding: 30px 35px 40px;
            box-shadow: 0 12px 30px rgba(0,0,0,0.15);
            flex-grow: 1;
        }

        h3 {
            text-align: center;
            margin-bottom: 30px;
            font-weight: 700;
            color: #34495e;
            font-size: 1.9rem;
            letter-spacing: 1px;
            user-select: none;
        }

        form label {
            display: flex;
            align-items: center;
            gap: 10px;
            font-weight: 600;
            margin-bottom: 6px;
            color: #2c3e50;
            font-size: 1rem;
        }

        form label i {
            color: #3498db;
            font-size: 1.2rem;
            min-width: 22px;
            text-align: center;
        }

        select,
        input[type="datetime-local"] {
            width: 100%;
            padding: 14px 16px;
            margin-bottom: 20px;
            border-radius: 8px;
            border: 1.8px solid #bdc3c7;
            font-size: 1rem;
            color: #2c3e50;
            transition: border-color 0.3s ease;
            outline-offset: 2px;
        }

        select:focus,
        input[type="datetime-local"]:focus {
            border-color: #2980b9;
            outline: none;
            box-shadow: 0 0 8px rgba(41, 128, 185, 0.5);
        }

        input[type="submit"] {
            background-color: #2980b9;
            border: none;
            padding: 16px 0;
            width: 100%;
            border-radius: 10px;
            color: #ecf0f1;
            font-weight: 700;
            font-size: 1.1rem;
            cursor: pointer;
            letter-spacing: 1.1px;
            display: flex;
            justify-content: center;
            align-items: center;
            gap: 12px;
            transition: background-color 0.35s ease;
            user-select: none;
        }

        input[type="submit"]:hover {
            background-color: #1b669d;
        }

        input[type="submit"] i {
            font-size: 1.2rem;
        }

        /* Responsive */
        @media (max-width: 768px) {
            .container {
                margin: 25px 20px 40px;
                padding: 25px 20px 30px;
            }

            header {
                flex-direction: column;
                align-items: flex-start;
                gap: 10px;
                padding: 15px 20px;
            }

            .logout-btn {
                width: 100%;
                justify-content: center;
            }
        }
    </style>
</head>
<body>

<header>
    <h2><i class="fa-solid fa-clipboard-list"></i> Interview Panel</h2>
    <form action="logout.php" method="post" aria-label="Logout Form">
        <button class="logout-btn" type="submit" aria-label="Logout">
            <i class="fa-solid fa-right-from-bracket"></i> Logout
        </button>
    </form>
</header>

<div class="container" role="main" aria-labelledby="updateTitle">
    <h3 id="updateTitle"><i class="fa-solid fa-pen-to-square"></i> Update Interview Status</h3>
    <form method="POST" action="interview.php" aria-describedby="formInstructions">
        <p id="formInstructions" style="display:none;">
            Select applicant, interview date and update the selection status, then submit the form.
        </p>

        <label for="applicant_id"><i class="fa-solid fa-user"></i> Select Applicant:</label>
        <select name="applicant_id" id="applicant_id" required aria-required="true" aria-describedby="applicantHelp">
            <option value="">-- Select Applicant --</option>
            <?php while ($row = $applicants_result->fetch_assoc()) { ?>
                <option value="<?php echo htmlspecialchars($row['id']); ?>">
                    <?php 
                    echo htmlspecialchars($row['name']); 
                    echo " (Passport: " . htmlspecialchars($row['passport_no']) . ")";
                    echo " - Position: " . htmlspecialchars($row['position']);
                    echo " - Country: " . htmlspecialchars($row['job_country']);
                    echo " - Ref: " . htmlspecialchars($row['reference']);
                    ?>
                </option>
            <?php } ?>
        </select>

        <label for="interview_date"><i class="fa-solid fa-calendar-days"></i> Interview Date:</label>
        <input type="datetime-local" id="interview_date" name="interview_date" required aria-required="true" />

        <label for="selection_status"><i class="fa-solid fa-list-check"></i> Selection Status:</label>
        <select name="selection_status" id="selection_status" required aria-required="true">
            <option value="">-- Select Status --</option>
            <option value="Selected">Selected</option>
            <option value="Rejected">Rejected</option>
        </select>

        <input type="submit" value="Update Interview Status" aria-label="Update Interview Status">
    </form>
</div>

</body>
</html>
