<?php
include('dbconnect.php');

$success_message = "";

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $applicant_id = $_POST['applicant_id'];
    $offer_status = $_POST['offer_status'];

    $offer_letter_file = NULL;
    if (isset($_FILES['offer_letter_file']) && $_FILES['offer_letter_file']['error'] == 0) {
        $upload_dir = 'uploads/offer_letters/';
        $file_name = basename($_FILES['offer_letter_file']['name']);
        $file_path = $upload_dir . $file_name;

        if (!file_exists($upload_dir)) {
            mkdir($upload_dir, 0777, true);
        }

        if (move_uploaded_file($_FILES['offer_letter_file']['tmp_name'], $file_path)) {
            $offer_letter_file = $file_path;
        } else {
            $success_message = "<p class='error'>❌ File upload failed!</p>";
            exit;
        }
    }

    $sql = "INSERT INTO offer_letters (applicant_id, offer_status, offer_letter_file, upload_date)
            VALUES (?, ?, ?, NOW())
            ON DUPLICATE KEY UPDATE offer_status = ?, offer_letter_file = ?, upload_date = NOW()";

    if ($stmt = $con->prepare($sql)) {
        $stmt->bind_param("issss", $applicant_id, $offer_status, $offer_letter_file, $offer_status, $offer_letter_file);
        if ($stmt->execute()) {
            $success_message = "<p class='success'>✅ Offer letter status updated successfully. Thank you!</p>";
        } else {
            $success_message = "<p class='error'>❌ Error: " . $stmt->error . "</p>";
        }
        $stmt->close();
    } else {
        $success_message = "<p class='error'>❌ Error preparing query: " . $con->error . "</p>";
    }
}

$search_query = "";
if (isset($_GET['search_passport']) && !empty($_GET['search_passport'])) {
    $search_passport = $_GET['search_passport'];
    $search_passport = $con->real_escape_string($search_passport);
    $search_query = "WHERE passport_no LIKE '%$search_passport%'";
}

$applicants_sql = "SELECT * FROM job_applicants $search_query ORDER BY name ASC";
$applicants_result = $con->query($applicants_sql);
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title>Offer Letter Status Update</title>
<meta name="viewport" content="width=device-width, initial-scale=1" />

<!-- FontAwesome CDN -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" />

<style>
    /* Reset and base */
    * {
        box-sizing: border-box;
    }
    body {
        margin: 0;
        font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
        background: linear-gradient(135deg, #667eea, #764ba2);
        min-height: 100vh;
        display: flex;
        flex-direction: column;
        color: #333;
    }

    header {
        background-color: #4a3f6f;
        color: #f0e9ff;
        padding: 15px 25px;
        display: flex;
        justify-content: space-between;
        align-items: center;
        flex-wrap: wrap;
        box-shadow: 0 4px 10px rgba(0,0,0,0.2);
    }
    header h2 {
        font-weight: 700;
        font-size: 1.8rem;
        user-select: none;
        display: flex;
        align-items: center;
        gap: 10px;
    }
    header h2 i {
        color: #ffd700;
    }

    .logout-btn {
        background-color: #ff6f61;
        color: white;
        border: none;
        padding: 10px 18px;
        font-size: 1rem;
        font-weight: 600;
        border-radius: 6px;
        cursor: pointer;
        display: flex;
        align-items: center;
        gap: 8px;
        transition: background-color 0.3s ease;
        user-select: none;
    }
    .logout-btn i {
        font-size: 1.2rem;
    }
    .logout-btn:hover {
        background-color: #e65550;
    }

    .container {
        max-width: 620px;
        background: #fff;
        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 {
        font-weight: 700;
        font-size: 1.9rem;
        margin-bottom: 30px;
        text-align: center;
        color: #4a3f6f;
        user-select: none;
        display: flex;
        justify-content: center;
        align-items: center;
        gap: 12px;
    }
    h3 i {
        color: #764ba2;
        font-size: 1.5rem;
    }

    label {
        font-weight: 700;
        display: flex;
        align-items: center;
        gap: 10px;
        margin-bottom: 8px;
        color: #4a3f6f;
        font-size: 1rem;
    }
    label i {
        color: #764ba2;
        font-size: 1.2rem;
        min-width: 22px;
        text-align: center;
    }

    select,
    input[type="file"],
    input[type="text"],
    input[type="submit"] {
        width: 100%;
        padding: 14px 16px;
        margin-bottom: 22px;
        border-radius: 8px;
        border: 1.8px solid #ccc;
        font-size: 1rem;
        color: #444;
        transition: border-color 0.3s ease;
        outline-offset: 2px;
    }
    select:focus,
    input[type="file"]:focus,
    input[type="text"]:focus {
        border-color: #764ba2;
        outline: none;
        box-shadow: 0 0 8px rgba(118, 75, 162, 0.6);
    }

    input[type="submit"] {
        background-color: #764ba2;
        color: white;
        font-weight: 700;
        border: none;
        cursor: pointer;
        letter-spacing: 1.1px;
        display: flex;
        justify-content: center;
        align-items: center;
        gap: 10px;
        user-select: none;
        transition: background-color 0.35s ease;
    }
    input[type="submit"]:hover {
        background-color: #5b357b;
    }
    input[type="submit"] i {
        font-size: 1.2rem;
    }

    .success {
        background: #d4edda;
        color: #155724;
        padding: 12px 18px;
        margin-bottom: 25px;
        border-left: 6px solid #28a745;
        border-radius: 6px;
        font-weight: 600;
        user-select: none;
    }

    .error {
        background: #f8d7da;
        color: #721c24;
        padding: 12px 18px;
        margin-bottom: 25px;
        border-left: 6px solid #dc3545;
        border-radius: 6px;
        font-weight: 600;
        user-select: none;
    }

    /* Responsive */
    @media (max-width: 600px) {
        header {
            flex-direction: column;
            align-items: flex-start;
            gap: 10px;
        }
        .logout-btn {
            width: 100%;
            justify-content: center;
        }
        .container {
            margin: 25px 15px 50px;
            padding: 25px 20px 30px;
        }
    }
</style>
</head>
<body>

<header>
    <h2><i class="fa-solid fa-file-contract"></i> Offer Letter Management</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="mainTitle">
    <h3 id="mainTitle"><i class="fa-solid fa-pen-to-square"></i> Update Offer Letter Status</h3>

    <?php echo $success_message; ?>

    <!-- Search Form -->
    <form method="GET" action="offer_letters.php" aria-label="Search Applicants by Passport Number">
        <label for="search_passport"><i class="fa-solid fa-magnifying-glass"></i> Search by Passport No:</label>
        <input type="text" id="search_passport" name="search_passport" placeholder="Enter Passport Number" value="<?php echo isset($search_passport) ? htmlspecialchars($search_passport) : ''; ?>" />
        <input type="submit" value="Search" aria-label="Search Applicants">
    </form>

    <!-- Offer Letter Form -->
    <form method="POST" action="offer_letters.php" enctype="multipart/form-data" aria-label="Update Offer Letter Status Form">
        <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">
            <option value="">-- Select Applicant --</option>
            <?php while ($row = $applicants_result->fetch_assoc()) { ?>
                <option value="<?php echo htmlspecialchars($row['id']); ?>">
                    <?php echo htmlspecialchars($row['name']); ?> (Passport: <?php echo htmlspecialchars($row['passport_no']); ?>)
                </option>
            <?php } ?>
        </select>

        <label for="offer_status"><i class="fa-solid fa-list-check"></i> Offer Status:</label>
        <select name="offer_status" id="offer_status" required aria-required="true">
            <option value="">-- Select Status --</option>
            <option value="Received">Received</option>
            <option value="Rejected">Rejected</option>
        </select>

        <label for="offer_letter_file"><i class="fa-solid fa-file-pdf"></i> Upload Offer Letter (PDF):</label>
        <input type="file" name="offer_letter_file" id="offer_letter_file" accept="application/pdf" aria-describedby="fileHelp" />
        <small id="fileHelp" style="color:#666; display:block; margin-top:-15px; margin-bottom:20px; font-size:0.85rem;">
            Optional. Upload PDF only.
        </small>

        <input type="submit" value="Update Offer Letter Status" />
    </form>
</div>

</body>
</html>
