<?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 = "";
$search_passport = "";
if (isset($_GET['search_passport']) && !empty($_GET['search_passport'])) {
    $search_passport = $_GET['search_passport'];
    $search_esc = $con->real_escape_string($search_passport);
    $search_query = "WHERE passport_no LIKE '%$search_esc%'";
}

$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" />
    <style>
        /* Reset and base */
        * {
            box-sizing: border-box;
        }
        body {
            margin: 0;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: linear-gradient(135deg, #f9fafb 0%, #e4ebf5 100%);
            color: #2c3e50;
            min-height: 100vh;
        }

        header {
            background-color: #34495e;
            color: #ecf0f1;
            padding: 15px 25px;
            display: flex;
            justify-content: space-between;
            align-items: center;
            flex-wrap: wrap;
        }

        header h2 {
            margin: 0;
            font-weight: 600;
            font-size: 1.5rem;
        }

        .logout-btn {
            background-color: #e74c3c;
            border: none;
            color: #fff;
            padding: 10px 18px;
            border-radius: 6px;
            font-weight: 600;
            cursor: pointer;
            transition: background-color 0.25s ease;
            font-size: 1rem;
        }
        .logout-btn:hover {
            background-color: #c0392b;
        }

        .container {
            max-width: 600px;
            margin: 40px auto 60px;
            background: #fff;
            border-radius: 12px;
            padding: 30px 25px;
            box-shadow: 0 15px 30px rgba(44, 62, 80, 0.12);
        }

        h3 {
            text-align: center;
            margin-bottom: 28px;
            font-weight: 700;
            color: #34495e;
            font-size: 1.7rem;
        }

        label {
            display: block;
            font-weight: 600;
            margin-bottom: 6px;
            color: #34495e;
            font-size: 1rem;
        }

        input[type="text"],
        select,
        input[type="file"] {
            width: 100%;
            padding: 12px 14px;
            font-size: 1rem;
            border-radius: 8px;
            border: 1.8px solid #bdc3c7;
            outline-offset: 2px;
            outline-color: transparent;
            transition: border-color 0.3s ease;
            margin-bottom: 20px;
            color: #2c3e50;
            background-color: #fafafa;
        }

        input[type="text"]:focus,
        select:focus,
        input[type="file"]:focus {
            border-color: #3498db;
            background-color: #fff;
        }

        input[type="submit"] {
            width: 100%;
            background-color: #27ae60;
            border: none;
            color: white;
            padding: 14px 0;
            font-size: 1.15rem;
            font-weight: 700;
            border-radius: 10px;
            cursor: pointer;
            box-shadow: 0 5px 10px rgba(39, 174, 96, 0.4);
            transition: background-color 0.3s ease;
            margin-top: 10px;
        }

        input[type="submit"]:hover {
            background-color: #219150;
        }

        .success, .error {
            border-radius: 6px;
            padding: 12px 18px;
            margin-bottom: 25px;
            font-weight: 600;
            font-size: 1rem;
        }
        .success {
            background-color: #d4edda;
            color: #155724;
            border-left: 6px solid #28a745;
        }
        .error {
            background-color: #f8d7da;
            color: #721c24;
            border-left: 6px solid #dc3545;
        }

        /* Responsive adjustments */
        @media (max-width: 640px) {
            .container {
                margin: 30px 15px 50px;
                padding: 25px 20px;
            }
            header {
                flex-direction: column;
                align-items: flex-start;
            }
            .logout-btn {
                width: 100%;
                margin-top: 12px;
                padding: 12px 0;
                font-size: 1.1rem;
            }
        }
    </style>
</head>
<body>

<header>
    <h2>Offer Letter Management</h2>
    <form action="logout.php" method="post" style="margin:0;">
        <button class="logout-btn" type="submit">Logout</button>
    </form>
</header>

<div class="container">
    <h3>Update Offer Letter Status</h3>

    <?php echo $success_message; ?>

    <!-- Search Form -->
    <form method="GET" action="offer_letters.php">
        <label for="search_passport">Search by Passport No:</label>
        <input type="text" id="search_passport" name="search_passport" placeholder="Enter Passport Number" value="<?php echo htmlspecialchars($search_passport); ?>" />
        <input type="submit" value="Search" />
    </form>

    <!-- Offer Letter Form -->
    <form method="POST" action="offer_letters.php" enctype="multipart/form-data" style="margin-top: 25px;">
        <label for="applicant_id">Select Applicant:</label>
        <select id="applicant_id" name="applicant_id" required>
            <option value="" disabled selected>-- Select Applicant --</option>
            <?php while ($row = $applicants_result->fetch_assoc()) { ?>
                <option value="<?php echo $row['id']; ?>">
                    <?php echo htmlspecialchars($row['name']); ?> (Passport: <?php echo htmlspecialchars($row['passport_no']); ?>)
                </option>
            <?php } ?>
        </select>

        <label for="offer_status">Offer Status:</label>
        <select id="offer_status" name="offer_status" required>
            <option value="Received">Received</option>
            <option value="Rejected">Rejected</option>
        </select>

        <label for="offer_letter_file">Upload Offer Letter (PDF):</label>
        <input type="file" id="offer_letter_file" name="offer_letter_file" accept="application/pdf" />

        <input type="submit" value="Update Offer Letter Status" />
    </form>
</div>

</body>
</html>
