<?php
session_start();
include "dbconnect.php"; // Database Connection

// If form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) {
    $_SESSION['submitted'] = true; // Set session to prevent further submissions

    // Get form values
    $applicant_id = $_POST['applicant_id'];
    $work_permit_received = $_POST['work_permit_received']; // Yes/No
    $approval_date = $_POST['approval_date']; // Approval Date
    $file_path = null;

    // Handle file upload
    if (isset($_FILES['work_permit_upload']) && $_FILES['work_permit_upload']['error'] == 0) {
        $file_name = $_FILES['work_permit_upload']['name'];
        $file_tmp_name = $_FILES['work_permit_upload']['tmp_name'];
        $file_ext = pathinfo($file_name, PATHINFO_EXTENSION);

        $allowed_extensions = ['jpg', 'jpeg', 'png', 'pdf'];

        if (in_array(strtolower($file_ext), $allowed_extensions)) {
            // Set the upload directory
            $upload_dir = 'uploads/';
            // Generate unique file name to avoid overwriting
            $file_path = $upload_dir . uniqid() . '_' . basename($file_name);

            // Move the uploaded file to the server directory
            if (move_uploaded_file($file_tmp_name, $file_path)) {
                echo "<script>alert('File uploaded successfully');</script>";
            } else {
                echo "<script>alert('File upload failed. Please try again.');</script>";
                exit;
            }
        } else {
            echo "<script>alert('Invalid file type. Only JPG, PNG, and PDF files are allowed.');</script>";
            exit;
        }
    }

    // Check if record already exists for this applicant
    $sql_check = "SELECT * FROM work_permit_approval WHERE applicant_id = ?";
    $stmt_check = $con->prepare($sql_check);
    $stmt_check->bind_param("i", $applicant_id); // "i" indicates integer
    $stmt_check->execute();
    $result_check = $stmt_check->get_result();

    if ($result_check->num_rows > 0) {
        echo "<script>alert('Work Permit Approval record already exists for this applicant.');</script>";
    } else {
        // Prepare the SQL query with values using prepared statement
        $sql = "INSERT INTO work_permit_approval (applicant_id, work_permit_received, file_upload, approval_date) 
                VALUES (?, ?, ?, ?)";
        // Prepare statement
        $stmt = $con->prepare($sql);
        $stmt->bind_param("isss", $applicant_id, $work_permit_received, $file_path, $approval_date); // Bind the parameters

        // Execute the query and check for success
        if ($stmt->execute()) {
            echo "<script>alert('Work Permit Approval Record Added Successfully');</script>";
            unset($_SESSION['submitted']); // Reset session variable after successful submission
        } else {
            echo "<script>alert('Error: " . $stmt->error . "');</script>";
            echo "<pre>Error: " . $stmt->error . "</pre>";  // Show the error
        }
    }
} elseif (isset($_SESSION['submitted'])) {
    // If form was already submitted, prevent further submissions
    echo "<script>alert('You have already submitted the form.');</script>";
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <title>Work Permit Approval</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" />
    <style>
        /* Color Palette */
        :root {
            --primary-blue: #2a7ae2;
            --primary-blue-dark: #1854a6;
            --background-light: #f0f4f8;
            --card-bg: #ffffff;
            --success-green: #28a745;
            --error-red: #e74c3c;
            --text-primary: #1f2937;
            --text-muted: #6b7280;
            --border-gray: #d1d5db;
        }

        /* Body & Container */
        body {
            background-color: var(--background-light);
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            color: var(--text-primary);
            min-height: 100vh;
            padding: 20px;
            display: flex;
            justify-content: center;
            align-items: flex-start;
        }

        .form-container {
            background: var(--card-bg);
            max-width: 500px;
            width: 100%;
            padding: 30px 30px 40px;
            border-radius: 12px;
            box-shadow: 0 6px 18px rgba(42, 122, 226, 0.15);
            margin-top: 40px;
            transition: box-shadow 0.3s ease-in-out;
        }

        .form-container:hover {
            box-shadow: 0 8px 24px rgba(42, 122, 226, 0.3);
        }

        h3 {
            color: var(--primary-blue);
            font-weight: 700;
            font-size: 28px;
            text-align: center;
            margin-bottom: 30px;
        }

        /* Form Groups */
        .form-group {
            margin-bottom: 22px;
        }

        label {
            font-weight: 600;
            margin-bottom: 8px;
            display: block;
            color: var(--text-primary);
        }

        select.form-control,
        input.form-control,
        input[type="file"] {
            border-radius: 8px;
            border: 1.5px solid var(--border-gray);
            padding: 10px 15px;
            font-size: 16px;
            transition: border-color 0.3s ease;
        }

        select.form-control:focus,
        input.form-control:focus,
        input[type="file"]:focus {
            border-color: var(--primary-blue);
            box-shadow: 0 0 6px rgba(42, 122, 226, 0.4);
            outline: none;
        }

        /* Buttons */
        .btn-primary {
            background-color: var(--primary-blue);
            border: none;
            font-weight: 600;
            font-size: 18px;
            padding: 12px 0;
            border-radius: 8px;
            width: 100%;
            transition: background-color 0.3s ease;
            cursor: pointer;
        }

        .btn-primary:hover,
        .btn-primary:focus {
            background-color: var(--primary-blue-dark);
            outline: none;
        }

        /* Alert Success */
        .alert-success {
            background-color: var(--success-green);
            color: white;
            font-size: 16px;
            padding: 15px;
            border-radius: 8px;
            margin-bottom: 25px;
            text-align: center;
            font-weight: 600;
        }

        /* Logout Button */
        .logout-btn {
            position: fixed;
            top: 20px;
            right: 20px;
            padding: 10px 18px;
            background-color: var(--error-red);
            color: white;
            border: none;
            border-radius: 8px;
            cursor: pointer;
            font-weight: 600;
            box-shadow: 0 3px 8px rgba(231, 76, 60, 0.5);
            transition: background-color 0.3s ease;
            z-index: 9999;
        }

        .logout-btn:hover,
        .logout-btn:focus {
            background-color: #b9312a;
            outline: none;
        }

        /* Search Section */
        .input-group {
            margin-bottom: 30px;
            border-radius: 8px;
            overflow: hidden;
            box-shadow: 0 2px 6px rgba(42, 122, 226, 0.15);
        }

        #passport_search {
            border: none;
            padding: 12px 15px;
            font-size: 16px;
            flex-grow: 1;
        }

        #passport_search:focus {
            outline: none;
        }

        #search_btn {
            background-color: var(--primary-blue);
            border: none;
            padding: 0 25px;
            color: white;
            font-weight: 600;
            cursor: pointer;
            transition: background-color 0.3s ease;
        }

        #search_btn:hover,
        #search_btn:focus {
            background-color: var(--primary-blue-dark);
            outline: none;
        }

        /* Responsive */
        @media (max-width: 576px) {
            body {
                padding: 15px 10px;
            }

            .form-container {
                padding: 25px 20px 35px;
                margin-top: 30px;
                box-shadow: 0 4px 12px rgba(42, 122, 226, 0.12);
            }

            h3 {
                font-size: 24px;
                margin-bottom: 25px;
            }

            .logout-btn {
                top: 10px;
                right: 10px;
                padding: 8px 14px;
                font-size: 14px;
            }
        }
    </style>
</head>
<body>

<!-- Logout Button -->
<form method="POST" action="logout.php">
    <button class="logout-btn" type="submit">Logout</button>
</form>

<div class="form-container">
    <h3>Work Permit Approval Form</h3>

    <?php if (isset($_SESSION['submitted'])): ?>
        <div class="alert alert-success" role="alert">
            Thank you! Your submission has been received.
        </div>
    <?php endif; ?>

    <!-- Search Section -->
    <div class="input-group">
        <input type="text" id="passport_search" placeholder="Enter Passport No" aria-label="Search Passport Number" />
        <button type="button" id="search_btn">Search</button>
    </div>

    <!-- Form -->
    <form method="POST" enctype="multipart/form-data" novalidate>
        <div class="form-group">
            <label for="applicant_id">Select Applicant</label>
            <select name="applicant_id" id="applicant_id" class="form-control" required>
                <option value="" disabled selected>-- Select Applicant --</option>
                <?php 
                // Get applicant data from the database
                $sql = "SELECT * FROM job_applicants";
                $result = $con->query($sql);
                while ($row = $result->fetch_assoc()) { 
                    $selected = (isset($_POST['applicant_id']) && $_POST['applicant_id'] == $row['id']) ? 'selected' : '';
                ?>
                    <option value="<?= htmlspecialchars($row['id']) ?>" data-passport="<?= htmlspecialchars($row['passport_no']) ?>" data-reference="<?= htmlspecialchars($row['reference']) ?>" <?= $selected ?>>
                        <?= htmlspecialchars($row['name']) ?> (<?= htmlspecialchars($row['passport_no']) ?>)
                    </option>
                <?php } ?>
            </select>
        </div>

        <div class="form-group">
            <label for="work_permit_received">Work Permit Received</label>
            <select name="work_permit_received" id="work_permit_received" class="form-control" required>
                <option value="Yes" <?= (isset($_POST['work_permit_received']) && $_POST['work_permit_received'] == 'Yes') ? 'selected' : '' ?>>Yes</option>
                <option value="No" <?= (isset($_POST['work_permit_received']) && $_POST['work_permit_received'] == 'No') ? 'selected' : '' ?>>No</option>
            </select>
        </div>

        <div class="form-group">
            <label for="approval_date">Approval Date</label>
            <input type="date" name="approval_date" id="approval_date" class="form-control" value="<?= isset($_POST['approval_date']) ? htmlspecialchars($_POST['approval_date']) : '' ?>" required />
        </div>

        <div class="form-group">
            <label for="work_permit_upload">Upload Work Permit Document</label>
            <input type="file" name="work_permit_upload" id="work_permit_upload" class="form-control" accept=".jpg,.jpeg,.png,.pdf" />
        </div>

        <div class="form-group">
            <button type="submit" class="btn btn-primary">Save Work Permit Approval</button>
        </div>
    </form>
</div>

<script>
    // Vanilla JS Search functionality for Passport No.
    document.getElementById('search_btn').addEventListener('click', function() {
        const passportInput = document.getElementById('passport_search').value.trim();
        if (!passportInput) {
            alert('Please enter a Passport Number.');
            return;
        }

        const options = document.getElementById('applicant_id').options;
        let found = false;

        for (let i = 0; i < options.length; i++) {
            if (options[i].dataset.passport === passportInput) {
                options[i].selected = true;
                found = true;
                break;
            }
        }

        if (!found) {
            alert('No Applicant Found with this Passport No!');
        }
    });
</script>

</body>
</html>
