📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/admin/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 = ""; if (isset($_GET['search_passport']) && !empty($_GET['search_passport'])) { $search_passport = $_GET['search_passport']; $search_passport = $con->real_escape_string($search_passport); $search_query = "WHERE passport_no LIKE '%$search_passport%'"; } $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" /> <!-- FontAwesome CDN --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" /> <style> /* Reset and base */ * { box-sizing: border-box; } body { margin: 0; font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background: linear-gradient(135deg, #667eea, #764ba2); min-height: 100vh; display: flex; flex-direction: column; color: #333; } header { background-color: #4a3f6f; color: #f0e9ff; padding: 15px 25px; display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap; box-shadow: 0 4px 10px rgba(0,0,0,0.2); } header h2 { font-weight: 700; font-size: 1.8rem; user-select: none; display: flex; align-items: center; gap: 10px; } header h2 i { color: #ffd700; } .logout-btn { background-color: #ff6f61; color: white; border: none; padding: 10px 18px; font-size: 1rem; font-weight: 600; border-radius: 6px; cursor: pointer; display: flex; align-items: center; gap: 8px; transition: background-color 0.3s ease; user-select: none; } .logout-btn i { font-size: 1.2rem; } .logout-btn:hover { background-color: #e65550; } .container { max-width: 620px; background: #fff; margin: 40px auto 60px auto; border-radius: 12px; padding: 30px 35px 40px; box-shadow: 0 12px 30px rgba(0,0,0,0.15); flex-grow: 1; } h3 { font-weight: 700; font-size: 1.9rem; margin-bottom: 30px; text-align: center; color: #4a3f6f; user-select: none; display: flex; justify-content: center; align-items: center; gap: 12px; } h3 i { color: #764ba2; font-size: 1.5rem; } label { font-weight: 700; display: flex; align-items: center; gap: 10px; margin-bottom: 8px; color: #4a3f6f; font-size: 1rem; } label i { color: #764ba2; font-size: 1.2rem; min-width: 22px; text-align: center; } select, input[type="file"], input[type="text"], input[type="submit"] { width: 100%; padding: 14px 16px; margin-bottom: 22px; border-radius: 8px; border: 1.8px solid #ccc; font-size: 1rem; color: #444; transition: border-color 0.3s ease; outline-offset: 2px; } select:focus, input[type="file"]:focus, input[type="text"]:focus { border-color: #764ba2; outline: none; box-shadow: 0 0 8px rgba(118, 75, 162, 0.6); } input[type="submit"] { background-color: #764ba2; color: white; font-weight: 700; border: none; cursor: pointer; letter-spacing: 1.1px; display: flex; justify-content: center; align-items: center; gap: 10px; user-select: none; transition: background-color 0.35s ease; } input[type="submit"]:hover { background-color: #5b357b; } input[type="submit"] i { font-size: 1.2rem; } .success { background: #d4edda; color: #155724; padding: 12px 18px; margin-bottom: 25px; border-left: 6px solid #28a745; border-radius: 6px; font-weight: 600; user-select: none; } .error { background: #f8d7da; color: #721c24; padding: 12px 18px; margin-bottom: 25px; border-left: 6px solid #dc3545; border-radius: 6px; font-weight: 600; user-select: none; } /* Responsive */ @media (max-width: 600px) { header { flex-direction: column; align-items: flex-start; gap: 10px; } .logout-btn { width: 100%; justify-content: center; } .container { margin: 25px 15px 50px; padding: 25px 20px 30px; } } </style> </head> <body> <header> <h2><i class="fa-solid fa-file-contract"></i> Offer Letter Management</h2> <form action="logout.php" method="post" aria-label="Logout Form"> <button class="logout-btn" type="submit" aria-label="Logout"> <i class="fa-solid fa-right-from-bracket"></i> Logout </button> </form> </header> <div class="container" role="main" aria-labelledby="mainTitle"> <h3 id="mainTitle"><i class="fa-solid fa-pen-to-square"></i> Update Offer Letter Status</h3> <?php echo $success_message; ?> <!-- Search Form --> <form method="GET" action="offer_letters.php" aria-label="Search Applicants by Passport Number"> <label for="search_passport"><i class="fa-solid fa-magnifying-glass"></i> Search by Passport No:</label> <input type="text" id="search_passport" name="search_passport" placeholder="Enter Passport Number" value="<?php echo isset($search_passport) ? htmlspecialchars($search_passport) : ''; ?>" /> <input type="submit" value="Search" aria-label="Search Applicants"> </form> <!-- Offer Letter Form --> <form method="POST" action="offer_letters.php" enctype="multipart/form-data" aria-label="Update Offer Letter Status Form"> <label for="applicant_id"><i class="fa-solid fa-user"></i> Select Applicant:</label> <select name="applicant_id" id="applicant_id" required aria-required="true"> <option value="">-- Select Applicant --</option> <?php while ($row = $applicants_result->fetch_assoc()) { ?> <option value="<?php echo htmlspecialchars($row['id']); ?>"> <?php echo htmlspecialchars($row['name']); ?> (Passport: <?php echo htmlspecialchars($row['passport_no']); ?>) </option> <?php } ?> </select> <label for="offer_status"><i class="fa-solid fa-list-check"></i> Offer Status:</label> <select name="offer_status" id="offer_status" required aria-required="true"> <option value="">-- Select Status --</option> <option value="Received">Received</option> <option value="Rejected">Rejected</option> </select> <label for="offer_letter_file"><i class="fa-solid fa-file-pdf"></i> Upload Offer Letter (PDF):</label> <input type="file" name="offer_letter_file" id="offer_letter_file" accept="application/pdf" aria-describedby="fileHelp" /> <small id="fileHelp" style="color:#666; display:block; margin-top:-15px; margin-bottom:20px; font-size:0.85rem;"> Optional. Upload PDF only. </small> <input type="submit" value="Update Offer Letter Status" /> </form> </div> </body> </html>
Save
Cancel