📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/emply/appointment_list.php
<?php include "dbconnect.php"; // Pagination settings $limit = 10; $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $offset = ($page - 1) * $limit; // Search & Date Filtering $searchQuery = ""; $dateFilter = ""; if (!empty($_GET['search'])) { $search = $con->real_escape_string($_GET['search']); $searchQuery = "AND (ja.passport_no LIKE '%$search%' OR ja.mobile_no LIKE '%$search%')"; } if (!empty($_GET['start_date']) && !empty($_GET['end_date'])) { $start_date = $con->real_escape_string($_GET['start_date']); $end_date = $con->real_escape_string($_GET['end_date']); $dateFilter = "AND a.appointment_date BETWEEN '$start_date' AND '$end_date'"; } // Load Data for Appointment List $sql = "SELECT ja.id, ja.name, ja.passport_no, ja.mobile_no, ja.position, ja.job_country, ja.reference, a.appointment_date, a.status AS appointment_status FROM job_applicants ja LEFT JOIN appointments a ON ja.id = a.applicant_id WHERE 1 $searchQuery $dateFilter ORDER BY a.appointment_date ASC LIMIT $limit OFFSET $offset"; $result = $con->query($sql); // Fetch Expiring Soon for Marquee $marqueeQuery = "SELECT ja.name, ja.passport_no, a.appointment_date FROM job_applicants ja LEFT JOIN appointments a ON ja.id = a.applicant_id WHERE DATEDIFF(a.appointment_date, CURDATE()) BETWEEN 1 AND 15 ORDER BY a.appointment_date ASC"; $marqueeResult = $con->query($marqueeQuery); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Appointment List</title> <meta name="viewport" content="width=device-width, initial-scale=1" /> <!-- Bootstrap + jQuery --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" /> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <style> /* Background and typography */ body { background: linear-gradient(135deg, #89f7fe 0%, #66a6ff 100%); font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; min-height: 100vh; padding-top: 70px; color: #333; } /* Container styling */ .container { max-width: 1100px; background: #fff; padding: 25px 30px; border-radius: 15px; box-shadow: 0 15px 40px rgba(0,0,0,0.12); } h3.text-primary { color: #0d6efd; font-weight: 700; margin-bottom: 25px; text-align: center; letter-spacing: 0.03em; } /* Marquee styling */ .marquee-wrapper { font-weight: 700; color: #dc3545; margin-bottom: 20px; background-color: #fff3f3; padding: 12px 15px; border-radius: 8px; box-shadow: inset 0 0 10px rgba(220, 53, 69, 0.2); } marquee span { font-size: 1rem; margin-right: 30px; } /* Table styles */ .table-container { overflow-x: auto; } table { min-width: 900px; } thead.table-dark th { background-color: #0d6efd; border-color: #0b5ed7; color: white; text-transform: uppercase; font-size: 14px; letter-spacing: 0.03em; } tbody tr.done { background-color: #d1e7dd; color: #0f5132; font-weight: 600; } tbody tr.pending { background-color: #fff3cd; color: #664d03; font-weight: 600; } tbody tr.missed { background-color: #f8d7da; color: #842029; font-weight: 600; } /* Buttons */ .btn-warning { background-color: #ffc107; border: none; color: #212529; font-weight: 600; border-radius: 8px; transition: background-color 0.3s ease; } .btn-warning:hover { background-color: #e0a800; color: #fff; } .btn-primary, .btn-success, .btn-secondary { border-radius: 8px; font-weight: 600; transition: background-color 0.3s ease; } .btn-primary:hover { background-color: #0046d5; } /* Logout button fixed top-right */ .logout-btn { position: fixed; top: 20px; right: 20px; z-index: 1100; background-color: #dc3545; color: #fff; padding: 10px 16px; border: none; border-radius: 10px; font-weight: 600; box-shadow: 0 6px 15px rgba(220,53,69,0.5); cursor: pointer; transition: background-color 0.3s ease; } .logout-btn:hover { background-color: #b02a37; } /* Responsive adjustments */ @media (max-width: 992px) { table { min-width: 700px; } } @media (max-width: 768px) { body { padding-top: 100px; } .container { padding: 20px 15px; } table { min-width: 100%; font-size: 14px; } .marquee-wrapper { font-size: 0.9rem; padding: 10px 12px; } .btn-warning, .btn-primary, .btn-success, .btn-secondary { font-size: 13px; padding: 7px 12px; } /* Stack filter form inputs on small screens */ form.row.g-2 > div { flex: 0 0 100%; max-width: 100%; } } @media (max-width: 480px) { .logout-btn { top: 10px; right: 10px; padding: 8px 12px; font-size: 14px; } } </style> </head> <body> <!-- Logout Button --> <form method="POST" action="logout.php"> <button type="submit" class="logout-btn">Logout</button> </form> <div class="container shadow-sm"> <h3 class="text-primary">Appointment List</h3> <div class="marquee-wrapper"> <marquee scrollamount="5" behavior="scroll" direction="left" onmouseover="this.stop();" onmouseout="this.start();"> <?php while ($row = $marqueeResult->fetch_assoc()) { ?> <span>🗓 <?= htmlspecialchars($row['name']) ?> (<?= htmlspecialchars($row['passport_no']) ?>) - <?= htmlspecialchars($row['appointment_date']) ?> |</span> <?php } ?> </marquee> </div> <!-- Filter Form --> <form method="GET" class="row g-2 mb-4"> <div class="col-md-4 col-sm-12"> <input type="text" name="search" class="form-control" placeholder="Search Passport/Mobile" value="<?= isset($_GET['search']) ? htmlspecialchars($_GET['search']) : '' ?>" /> </div> <div class="col-md-3 col-sm-6"> <input type="date" name="start_date" class="form-control" value="<?= $_GET['start_date'] ?? '' ?>" /> </div> <div class="col-md-3 col-sm-6"> <input type="date" name="end_date" class="form-control" value="<?= $_GET['end_date'] ?? '' ?>" /> </div> <div class="col-md-2 col-sm-12 d-grid"> <button type="submit" class="btn btn-success w-100">Search</button> </div> </form> <!-- Table --> <div class="table-container"> <table class="table table-bordered text-center table-striped table-hover"> <thead class="table-dark"> <tr> <th>#</th> <th>Name</th> <th>Passport No</th> <th>Mobile No</th> <th>Position</th> <th>Job Country</th> <th>Reference</th> <th>Appointment Date</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php $sr = $offset + 1; while ($row = $result->fetch_assoc()) { $status_class = 'done'; $status_text = ucfirst($row['appointment_status'] ?? 'N/A'); if ($row['appointment_status'] == "pending") $status_class = "pending"; if ($row['appointment_status'] == "missed") $status_class = "missed"; ?> <tr class="<?= $status_class ?>"> <td><?= $sr++ ?></td> <td><?= htmlspecialchars($row['name']) ?></td> <td><?= htmlspecialchars($row['passport_no']) ?></td> <td><?= htmlspecialchars($row['mobile_no']) ?></td> <td><?= htmlspecialchars($row['position']) ?></td> <td><?= htmlspecialchars($row['job_country']) ?></td> <td><?= htmlspecialchars($row['reference']) ?></td> <td><?= htmlspecialchars($row['appointment_date'] ?? 'N/A') ?></td> <td><?= $status_text ?></td> <td> <a href="appointment_edit.php?id=<?= $row['id'] ?>" class="btn btn-warning btn-sm">Edit</a> <!-- Delete button removed as requested --> </td> </tr> <?php } ?> </tbody> </table> </div> <!-- Export & Print --> <div class="text-center my-3"> <a href="export.php?search=<?= urlencode($_GET['search'] ?? '') ?>&start_date=<?= urlencode($_GET['start_date'] ?? '') ?>&end_date=<?= urlencode($_GET['end_date'] ?? '') ?>" class="btn btn-primary btn-sm me-2">Export to CSV</a> <button onClick="window.print()" class="btn btn-secondary btn-sm">Print</button> </div> <!-- Pagination --> <nav> <ul class="pagination justify-content-center"> <?php $countQuery = "SELECT COUNT(*) AS total FROM job_applicants ja LEFT JOIN appointments a ON ja.id = a.applicant_id WHERE 1 $searchQuery $dateFilter"; $countResult = $con->query($countQuery); $totalRows = $countResult->fetch_assoc()['total']; $totalPages = ceil($totalRows / $limit); for ($i = 1; $i <= $totalPages; $i++) { $active = ($i == $page) ? 'active' : ''; // Preserve existing search and date filters in pagination links $queryParams = $_GET; $queryParams['page'] = $i; $queryString = http_build_query($queryParams); echo "<li class='page-item $active'><a class='page-link' href='?$queryString'>$i</a></li>"; } ?> </ul> </nav> </div> </body> </html>
Save
Cancel