📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/emply/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; // 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>
Save
Cancel