<?php
include "dbconnect.php";

// Get the ID from the URL
$edit_id = isset($_GET['id']) ? $_GET['id'] : null;
$row = [];

if ($edit_id) {
    $sql = "SELECT * FROM job_applicants WHERE id = ?";
    $stmt = $con->prepare($sql);
    $stmt->bind_param("i", $edit_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $row = $result->fetch_assoc();
}

// Handle POST request
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['edit_id'])) {
    $edit_id = $_POST['edit_id'];
    $name = $_POST['name'];
    $father_name = $_POST['father_name'];
    $passport_no = $_POST['passport_no'];
    $passport_expiry_date = $_POST['passport_expiry_date'];
    $mobile_no = $_POST['mobile_no'];
    $email_id = $_POST['email_id'];
    $address = $_POST['address'];
    $position = $_POST['position'];
    $job_country = $_POST['job_country'];
    $qualification = $_POST['qualification'];
    $experience = $_POST['experience'];
    $reference = $_POST['reference'];
    $message = $_POST['message'];

    $update_sql = "UPDATE job_applicants SET 
                    name = ?, father_name = ?, passport_no = ?, passport_expiry_date = ?, 
                    mobile_no = ?, email_id = ?, address = ?, position = ?, 
                    job_country = ?, qualification = ?, experience = ?, reference = ?, 
                    message = ? WHERE id = ?";

    if ($stmt = $con->prepare($update_sql)) {
        $stmt->bind_param("sssssssssssssi", $name, $father_name, $passport_no, $passport_expiry_date,
                          $mobile_no, $email_id, $address, $position, $job_country, $qualification,
                          $experience, $reference, $message, $edit_id);

        if ($stmt->execute()) {
            echo "<script>alert('Record updated successfully!'); window.location.href='regitationlist.php';</script>";
        } else {
            echo "<script>alert('Error: " . $stmt->error . "');</script>";
        }

        $stmt->close();
    } else {
        echo "<script>alert('Error preparing query: " . $con->error . "');</script>";
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Edit Job Applicant</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Bootstrap CSS & Font Awesome -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css" rel="stylesheet">

    <style>
        body {
            background: linear-gradient(to right, #e0f7fa, #ffffff);
            font-family: 'Segoe UI', sans-serif;
        }

        .container {
            margin-top: 40px;
            margin-bottom: 40px;
        }

        .card {
            background-color: #ffffff;
            border-radius: 15px;
            padding: 25px;
            box-shadow: 0 8px 16px rgba(0,0,0,0.1);
        }

        .form-label {
            font-weight: 600;
        }

        .btn-primary {
            background-color: #007bff;
            border: none;
        }

        .btn-primary:hover {
            background-color: #0056b3;
        }

        h3 {
            color: #007bff;
            font-weight: bold;
            margin-bottom: 30px;
        }

        .form-icon {
            margin-right: 8px;
            color: #007bff;
        }

        textarea.form-control {
            resize: none;
        }

        @media (max-width: 576px) {
            .card {
                padding: 15px;
            }
        }
    </style>
</head>
<body>

<div class="container">
    <h3 class="text-center"><i class="fas fa-user-edit form-icon"></i>Edit Job Applicant</h3>

    <div class="card">
        <form method="POST" action="">

            <input type="hidden" name="edit_id" value="<?= $row['id'] ?>">

            <div class="row">
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-user form-icon"></i>Name</label>
                    <input type="text" class="form-control" name="name" value="<?= $row['name'] ?>" required>
                </div>
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-user-friends form-icon"></i>Father Name</label>
                    <input type="text" class="form-control" name="father_name" value="<?= $row['father_name'] ?>" required>
                </div>
            </div>

            <div class="row">
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-passport form-icon"></i>Passport No</label>
                    <input type="text" class="form-control" name="passport_no" value="<?= $row['passport_no'] ?>" required>
                </div>
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="far fa-calendar-alt form-icon"></i>Passport Expiry Date</label>
                    <input type="date" class="form-control" name="passport_expiry_date" value="<?= $row['passport_expiry_date'] ?>" required>
                </div>
            </div>

            <div class="row">
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-phone form-icon"></i>Mobile No</label>
                    <input type="text" class="form-control" name="mobile_no" value="<?= $row['mobile_no'] ?>" required>
                </div>
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-envelope form-icon"></i>Email</label>
                    <input type="email" class="form-control" name="email_id" value="<?= $row['email_id'] ?>" required>
                </div>
            </div>

            <div class="mb-3">
                <label class="form-label"><i class="fas fa-map-marker-alt form-icon"></i>Address</label>
                <textarea class="form-control" name="address" rows="3" required><?= $row['address'] ?></textarea>
            </div>

            <div class="row">
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-briefcase form-icon"></i>Job Position</label>
                    <input type="text" class="form-control" name="position" value="<?= $row['position'] ?>" required>
                </div>
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-globe form-icon"></i>Job Country</label>
                    <input type="text" class="form-control" name="job_country" value="<?= $row['job_country'] ?>" required>
                </div>
            </div>

            <div class="row">
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-graduation-cap form-icon"></i>Qualification</label>
                    <input type="text" class="form-control" name="qualification" value="<?= $row['qualification'] ?>" required>
                </div>
                <div class="col-md-6 mb-3">
                    <label class="form-label"><i class="fas fa-briefcase form-icon"></i>Experience</label>
                    <input type="text" class="form-control" name="experience" value="<?= $row['experience'] ?>" required>
                </div>
            </div>

            <div class="mb-3">
                <label class="form-label"><i class="fas fa-user-check form-icon"></i>Reference</label>
                <input type="text" class="form-control" name="reference" value="<?= $row['reference'] ?>" required>
            </div>

            <div class="mb-3">
                <label class="form-label"><i class="fas fa-comment-alt form-icon"></i>Message</label>
                <textarea class="form-control" name="message" rows="3"><?= $row['message'] ?></textarea>
            </div>

            <button type="submit" class="btn btn-primary mt-3"><i class="fas fa-save"></i> Save Changes</button>
        </form>
    </div>
</div>

<!-- Bootstrap JS Bundle -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
