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