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: completed_ol.php

<?php

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

$currentDate = date("Y-m-d");
$check = 0;
if (isset($_POST['submit'])) {

$room_type = $_POST['room_type'];
    $c_in = $_POST['c_in'];
    $c_out = $_POST['c_out'];
    if ($c_in < $currentDate) {
        $_SESSION['status'] = "Date is Past!";
        $_SESSION['code'] = "error";
    } else if ($c_in > $c_out) {
        $_SESSION['status'] = "Invalid Date!";
        $_SESSION['code'] = "error";
    } else if ($c_in == $c_out) {
        $_SESSION['status'] = "Dates are the Same!";
        $_SESSION['code'] = "error";
    } else {
        $check = 1;
    }
}

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

<head>

<head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>Silver Concha Wavepool Resort | Admin</title>
        <link href="../img/logo2.png" rel="icon" />

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

.suggestion-item:hover {
                background: #286ba9;
                color: white;
            }
        </style>
    </head>

option {
            font-size: 20px;
        }

tr td {
            padding: 0.1 !important;
            margin: 0.1 !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_ompleted.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 active bg-navy"><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 active"><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"><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-fluid pb-5">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title font-weight-bold mt-1">COMPLETED RESERVATION (ONLINE)</h3>

</div>

<div class="card-body">
                            <table id="example2" class="table table-bordered table-striped table-hover">
                                <thead class="text-white bg-primary">
                                    <tr>
                                        <th>Book Number</th>
                                        <th>Customer Name</th>
                                        <th>Room Name</th>
                                        <th>Check In</th>
                                        <th>Check Out</th>
                                        <th>No. of Stay</th>
                                        <th>Total</th>
                                        <th>Paid Amount</th>
                                        <th>Balance</th>
                                        <th>MOP</th>
                                        <th>Book Type</th>
                                        <th>Status</th>
                                        <th>Completed By</th>

</tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $sql = "SELECT 
                                                *
                                            FROM 
                                                room_booking
                                            JOIN 
                                                room ON room_booking.room_id = room.room_id
                                            JOIN 
                                                user ON room_booking.user_id = user.user_id
                                            WHERE 
                                                room_booking.book_type = 'Online' and room_booking.status = 'Completed'
                                            ORDER BY 
                                                room_booking.room_c_in DESC;"; // SHOWING DATA ON THE TABLES
                                    $res = $conn->query($sql);
                                    while ($row = $res->fetch_assoc()) {
                                    ?>
                                        <tr>
                                            <td><span class="badge badge-success p-1"><?php echo $row['room_book_num'] ?></span><br><?php echo date("M d, Y h:i A", strtotime($row['r_book_date'])) ?></td>
                                            <td><?php echo $row['customer_name'] ?></td>
                                            <td><?php echo $row['room_name'] ?></td>
                                            <td><?php echo date("M d, Y", strtotime($row['room_c_in'])) ?></td>
                                            <td><?php echo date("M d, Y", strtotime($row['real_cout'])) ?></td>
                                            <td><?php echo $row['num_stay'] ?> Night/s</td>
                                            <td>₱<?php echo number_format($row['total'], 2) ?></td>
                                            <td>₱<?php echo number_format($row['paid_amount'], 2) ?></td>
                                            <td>₱<?php echo number_format($row['balance'], 2) ?></td>
                                            <td><?php echo $row['payment_method'] ?></td>
                                            <td><?php echo $row['book_type'] ?></td>
                                            <td>
                                                <?php if ($row['status'] == 'Approved') { ?>
                                                    <span class="badge badge-primary"><?php echo $row['status'] ?></span>
                                                <?php } else if ($row['status'] == 'Completed') { ?>
                                                    <span class="badge badge-success"><?php echo $row['status'] ?></span>
                                                <?php } else if ($row['status'] == 'Pending') { ?>
                                                    <span class="badge badge-warning"><?php echo $row['status'] ?></span>
                                                <?php } else { ?>
                                                    <span class="badge badge-danger"><?php echo $row['status'] ?></span>
                                                <?php } ?>
                                            <td><?php echo $row['name'] ?></td>
                                            </td>
                                        </tr>
                                    <?php } ?>
                                </tbody>

</table>

</div>
                        
                    </div>

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

<div class="modal fade" id="approveModal" tabindex="-1" role="dialog" aria-labelledby="approveModalLabel" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header bg-lightblue">
                    <h5 class="modal-title" id="approveModalLabel">Approve Room Booking</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <form id="approveForm" action="roomApproval.php" method="POST">
                    <div class="modal-body">
                        
                        <div class="form-group">
                            <label for="reference_number">Reference Number</label>
                            <input type="text" class="form-control" id="reference_number" name="reference_number" required placeholder="Enter Reference Number">
                        </div>

<div class="form-group">
                            <label for="payment_method">Payment Method</label>
                            <select id="payment_method" name="payment_method" class="form-control form-select">
                                <option value="">*** Select MOP ***</option>
                                <option value="Gcash">Gcash</option>
                                <option value="Paymaya">Paymaya</option>
                                <option value="Bank Transfer">Bank Transfer</option>
                                <option value="Complimentary">Complimentary</option>
                            </select>
                        </div>

<input type="hidden" id="booking_id" name="booking_id">

</div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                        <button type="submit" name="approved" class="btn btn-primary">Approve Booking</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

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

</html>

// Set the data in the modal
            var modal = $(this);
            modal.find('#booking_id').val(bookingId);
            modal.find('#reference_number').val(referenceNumber);
            modal.find('#payment_method').val(paymentMethod);
        });
    });
</script>

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

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

document.getElementById("form-delete").id.value = id;
        $("#deleteModal").modal("show");
    }
</script>

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>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: completed_ol.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation