📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/2vinternational.com/admin/approval.php
<?php session_start(); include "dbconnect.php"; // Database Connection // If form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) { $_SESSION['submitted'] = true; $applicant_id = $_POST['applicant_id']; $work_permit_received = $_POST['work_permit_received']; $approval_date = $_POST['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)) { $upload_dir = 'uploads/'; $file_path = $upload_dir . uniqid() . '_' . basename($file_name); if (!move_uploaded_file($file_tmp_name, $file_path)) { echo "<script>alert('File upload failed.');</script>"; exit; } } else { echo "<script>alert('Invalid file type. Only JPG, PNG, and PDF are allowed.');</script>"; exit; } } // Check for existing record $sql_check = "SELECT * FROM work_permit_approval WHERE applicant_id = ?"; $stmt_check = $con->prepare($sql_check); $stmt_check->bind_param("i", $applicant_id); $stmt_check->execute(); $result_check = $stmt_check->get_result(); if ($result_check->num_rows > 0) { echo "<script>alert('Work Permit record already exists for this applicant.');</script>"; } else { $sql = "INSERT INTO work_permit_approval (applicant_id, work_permit_received, file_upload, approval_date) VALUES (?, ?, ?, ?)"; $stmt = $con->prepare($sql); $stmt->bind_param("isss", $applicant_id, $work_permit_received, $file_path, $approval_date); if ($stmt->execute()) { echo "<script>alert('Record Added Successfully');</script>"; unset($_SESSION['submitted']); } else { echo "<script>alert('Error: " . $stmt->error . "');</script>"; } } } elseif (isset($_SESSION['submitted'])) { echo "<script>alert('You have already submitted the form.');</script>"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Work Permit Approval</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Bootstrap 5 --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <!-- Font Awesome --> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" rel="stylesheet"> <style> body { background: linear-gradient(135deg, #f5f7fa, #c3cfe2); min-height: 100vh; padding-top: 60px; font-family: 'Segoe UI', sans-serif; } .form-container { background-color: white; border-radius: 12px; padding: 30px; box-shadow: 0 8px 20px rgba(0, 0, 0, 0.1); max-width: 600px; margin: auto; } .form-container h3 { color: #2c3e50; } .input-group-text { background-color: #f0f0f0; border-right: 0; } .form-control { border-left: 0; } .logout-btn { position: fixed; top: 20px; right: 20px; background-color: #dc3545; color: white; border: none; border-radius: 5px; padding: 8px 15px; font-size: 14px; } .logout-btn:hover { background-color: #c82333; } @media (max-width: 576px) { .form-container { padding: 20px; } .logout-btn { font-size: 12px; padding: 6px 10px; } } </style> </head> <body> <form method="POST" action="logout.php"> <button class="logout-btn"><i class="fas fa-sign-out-alt"></i> Logout</button> </form> <div class="container"> <div class="form-container"> <h3 class="text-center mb-4"><i class="fas fa-file-signature"></i> Work Permit Approval</h3> <?php if (isset($_SESSION['submitted'])): ?> <div class="alert alert-success text-center">Thank you! Your submission has been received.</div> <?php endif; ?> <!-- Search Input --> <div class="mb-4"> <div class="input-group"> <span class="input-group-text"><i class="fas fa-passport"></i></span> <input type="text" id="passport_search" class="form-control" placeholder="Enter Passport Number"> <button type="button" id="search_btn" class="btn btn-primary"><i class="fas fa-search"></i></button> </div> </div> <!-- FORM --> <form method="POST" enctype="multipart/form-data"> <!-- Applicant --> <div class="mb-3"> <label for="applicant_id" class="form-label">Select Applicant</label> <div class="input-group"> <span class="input-group-text"><i class="fas fa-user"></i></span> <select name="applicant_id" id="applicant_id" class="form-select" required> <option value="">-- Select Applicant --</option> <?php $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' : ''; echo '<option value="' . $row['id'] . '" data-passport="' . $row['passport_no'] . '" ' . $selected . '>' . $row['name'] . ' (' . $row['passport_no'] . ')</option>'; } ?> </select> </div> </div> <!-- Work Permit Received --> <div class="mb-3"> <label for="work_permit_received" class="form-label">Work Permit Received</label> <div class="input-group"> <span class="input-group-text"><i class="fas fa-check-circle"></i></span> <select name="work_permit_received" class="form-select" 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> <!-- Approval Date --> <div class="mb-3"> <label for="approval_date" class="form-label">Approval Date</label> <div class="input-group"> <span class="input-group-text"><i class="fas fa-calendar-alt"></i></span> <input type="date" name="approval_date" class="form-control" value="<?= isset($_POST['approval_date']) ? $_POST['approval_date'] : '' ?>" required> </div> </div> <!-- File Upload --> <div class="mb-4"> <label for="work_permit_upload" class="form-label">Upload Document</label> <div class="input-group"> <span class="input-group-text"><i class="fas fa-upload"></i></span> <input type="file" name="work_permit_upload" class="form-control" accept=".jpg,.jpeg,.png,.pdf"> </div> </div> <!-- Submit --> <div class="text-center"> <button type="submit" class="btn btn-primary w-100"><i class="fas fa-save"></i> Submit</button> </div> </form> </div> </div> <!-- jQuery (Optional) and Bootstrap JS --> <script src="https://code.jquery.com/jquery-3.7.0.min.js"></script> <script> $(document).ready(function () { $("#search_btn").click(function () { let passportNo = $("#passport_search").val().trim(); let found = false; if (passportNo !== "") { $("#applicant_id option").each(function () { if ($(this).data("passport") == passportNo) { $(this).prop("selected", true); found = true; return false; } }); if (!found) { alert("No Applicant Found with this Passport No!"); } } else { alert("Please enter a Passport Number."); } }); }); </script> </body> </html>
Save
Cancel