1#@!#!123s

32759 1#@!#!123s
: / home / aissorg / www / admin /
Filename : room-booking-list.php
back
<?php
include('include/config.php');

// Initialize Alert Variables
$alert = '';
$alert_class = '';

// Show success message after redirect
if (isset($_GET['msg'])) {
    switch ($_GET['msg']) {
        case 'insert_success':
            $alert = 'Data added successfully.';
            $alert_class = 'alert-success';
            break;
        case 'update_success':
            $alert = 'Booking status updated successfully.';
            $alert_class = 'alert-success';
            break;
        case 'delete_success':
            $alert = 'Data deleted successfully.';
            $alert_class = 'alert-success';
            break;
    }
}

// Handle POST Actions (Confirm, Cancel, Checkout)
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        $id = $_POST['id'];
        $action = $_POST['action'];

        switch ($action) {
            case 'confirm':
                $update_query = "UPDATE rooms SET status = 1 WHERE id = '$id'";
                break;
            case 'cancel':
                $update_query = "UPDATE rooms SET status = 0 WHERE id = '$id'";
                break;
            case 'checkout':
                // Update status to 2 and set checkout_date to the current date
                $update_query = "UPDATE rooms SET status = 2, checkout_date = CURDATE() WHERE id = '$id'";
                break;
            default:
                $update_query = null;
                break;
        }

        if ($update_query) {
            mysqli_query($con, $update_query);
            header("Location: room-booking-list.php?msg=update_success");
            exit();
        }
    }
}

// Fetch All Bookings
function fetchPujaBookings($con) {
    $sql = "SELECT * FROM rooms";
    $result = mysqli_query($con, $sql);
    $categories = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $categories[] = $row;
    }
    return $categories;
}
?>

<!DOCTYPE html>
<html lang="en" data-layout="vertical" data-topbar="light" data-sidebar="light" data-sidebar-size="lg" data-sidebar-image="none">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Room Booking Report</title>
    <!-- Favicon -->
    <link rel="shortcut icon" type="image/x-icon" href="">
    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <!-- Fontawesome CSS -->
    <link rel="stylesheet" href="assets/plugins/fontawesome/css/fontawesome.min.css">
    <link rel="stylesheet" href="assets/plugins/fontawesome/css/all.min.css">
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Arimo:ital,wght@0,400..700;1,400..700&display=swap" rel="stylesheet">
    <!-- Feather CSS -->
    <link rel="stylesheet" href="assets/plugins/feather/feather.css">
    <!-- Datepicker CSS -->
    <link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css">
    <!-- Daterangepikcer CSS -->
    <link rel="stylesheet" href="assets/plugins/daterangepicker/daterangepicker.css">
    <!-- Datatables CSS -->
    <link rel="stylesheet" href="assets/plugins/datatables/datatables.min.css">
    <!-- Main CSS -->
    <link rel="stylesheet" href="assets/css/style.css">
    <!-- Layout Js -->
    <script src="assets/js/layout.js" type="text/javascript"></script>
</head>
<body>
    <!-- Main Wrapper -->
    <div class="main-wrapper">
        <!-- Header -->
        <?php include("include/header.php")?>
        <!-- /Header -->
        <!-- Sidebar -->
        <?php include("include/sidebar.php")?>
        <!-- /Sidebar -->
        <!-- Page Wrapper -->
        <div class="page-wrapper">
            <div class="content container-fluid">
                <!-- Page Header -->
                <div class="page-header">
                    <div class="content-page-header">
                        <h5>Room Booking Report</h5>
                    </div>
                </div>
                <!-- /Page Header -->
                <!-- Table -->
                <div class="row">
                    <div class="col-sm-12">
                        <!-- Dynamic Alert -->
                        <?php if (!empty($alert)): ?>
                            <div class="alert <?php echo $alert_class; ?> alert-dismissible fade show" role="alert">
                                <strong><?php echo ($alert_class === 'alert-success') ? 'Success!' : 'Error!'; ?></strong> <?php echo $alert; ?>
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                            </div>
                        <?php endif; ?>
                        <div class="card-table">
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-hover datatable">
                                        <thead class="thead-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Name</th>
                                                <th>Mobile</th>
                                                <th>Email</th>
                                                <th>Checkin</th>
                                                <th>Checkout</th>
                                                <th>Rooms</th>
                                                <th>Adult</th>
                                                <th>Aadhar</th>
                                                <th>Address</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $bookings = fetchPujaBookings($con);
                                            foreach ($bookings as $booking) {
                                                echo "<tr>";
                                                echo "<td>{$booking['id']}</td>";
                                                echo "<td>{$booking['name']}</td>";
                                                echo "<td>{$booking['mobile']}</td>";
                                                echo "<td>{$booking['email']}</td>";
                                                echo "<td>{$booking['checkin_date']}</td>";

                                                // Display Checkout Date
                                                echo "<td>";
                                                if (!empty($booking['checkout_date'])) {
                                                    echo $booking['checkout_date'];
                                                } else {
                                                    echo '<span class="text-muted">Not Checked Out</span>';
                                                }
                                                echo "</td>";

                                                echo "<td>{$booking['rooms']}</td>";
                                                echo "<td>{$booking['adult']}</td>";
                                                echo "<td>{$booking['aadhar']}</td>";
                                                echo "<td>{$booking['address']}</td>";

                                                // Status Column
                                                $status = $booking['status'];
                                                $status_text = '';
                                                if ($status == 0) {
                                                    $status_text = '<span class="badge bg-danger">Pending/Cancelled</span>';
                                                } elseif ($status == 1) {
                                                    $status_text = '<span class="badge bg-success">Confirmed</span>';
                                                } elseif ($status == 2) {
                                                    $status_text = '<span class="badge bg-secondary">Checked Out</span>';
                                                }
                                                echo "<td>$status_text</td>";

                                                // Actions Column
                                                echo '<td>';
                                                if ($status == 0) {
                                                    echo '<form method="POST" action="confirm_mail.php" class="d-inline-block">';
                                                    echo '<input type="hidden" name="action" value="confirm">';
                                                    echo '<input type="hidden" name="booking_id" value="' . $booking['id'] . '">';
                                                    echo '<button type="submit" class="btn btn-sm btn-primary me-1">Confirm</button>';
                                                    echo '</form>';

                                                    echo '<form method="POST" class="d-inline-block">';
                                                    echo '<input type="hidden" name="action" value="cancel">';
                                                    echo '<input type="hidden" name="id" value="' . $booking['id'] . '">';
                                                    echo '<button type="submit" class="btn btn-sm btn-danger me-1">Cancel</button>';
                                                    echo '</form>';
                                                } elseif ($status == 1) {
                                                    echo '<form method="POST" class="d-inline-block">';
                                                    echo '<input type="hidden" name="action" value="checkout">';
                                                    echo '<input type="hidden" name="id" value="' . $booking['id'] . '">';
                                                    echo '<button type="submit" class="btn btn-sm btn-secondary">Checkout</button>';
                                                    echo '</form>';
                                                }
                                                echo '</td>';

                                                echo "</tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- /Table -->
            </div>
        </div>
        <!-- /Page Wrapper -->
    </div>
    <!-- /Main Wrapper -->
    <!-- jQuery -->
    <script data-cfasync="false" src="../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>
    <script src="assets/js/jquery-3.7.1.min.js" type="text/javascript"></script>
    <!-- Bootstrap Core JS -->
    <script src="assets/js/bootstrap.bundle.min.js" type="text/javascript"></script>
    <!-- Datatable JS -->
    <script src="assets/plugins/datatables/datatables.min.js" type="text/javascript"></script>
    <!-- select CSS -->
    <script src="assets/plugins/select2/js/select2.min.js" type="text/javascript"></script>
    <!-- Slimscroll JS -->
    <script src="assets/plugins/slimscroll/jquery.slimscroll.min.js" type="text/javascript"></script>
    <!-- Datepicker Core JS -->
    <script src="assets/plugins/moment/moment.min.js" type="text/javascript"></script>
    <script src="assets/js/bootstrap-datetimepicker.min.js" type="text/javascript"></script>
    <script src="assets/plugins/daterangepicker/daterangepicker.js" type="text/javascript"></script>
    <!-- multiselect JS -->
    <script src="assets/js/jquery-ui.min.js" type="text/javascript"></script>
    <!-- Theme Settings JS -->
    <script src="assets/js/theme-settings.js" type="text/javascript"></script>
    <script src="assets/js/greedynav.js" type="text/javascript"></script>
    <!-- Custom JS -->
    <script src="assets/js/script.js" type="text/javascript"></script>
    <script src="../../cdn-cgi/scripts/7d0fa10a/cloudflare-static/rocket-loader.min.js" data-cf-settings="|49" defer></script>
</body>
</html>