<?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>
