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

<?php

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

$time_zone = date('Y-m-d');

$c_cat_id = $_GET['id'];

$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['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";

header('location: nightCreate.php?id=' . $c_cat_id);
        exit();
    }
}

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";
    }
}

?>
<!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% */
            }

.bg-light-danger {
                background-color: rgb(239, 104, 115);
                /* Lighter red */
            }
        </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>
                        <H4 class="font-weight-bold">NIGHT TOUR ACCOMMODATION</H4>
                    </center>
                </div>
                
            </div>

<div class="content">

<div class="container">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title font-weight-bold mt-1">Cottage: <span class="text-success"><?php echo $category_name ?></span></h3>
                            <a href="nightTour.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-purple">
                                    <tr>
                                        <th>Cottage Name</th>
                                        <th>Status</th>
                                        <th>Capacity</th>
                                        <th class="col-2 text-center">Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $sqlCottages = "SELECT c.cottage_id, c.cottage_name, cc.price, cc.capacity 
                                    FROM cottage c 
                                    INNER JOIN cottage_category cc ON c.c_cat_id = cc.c_cat_id 
                                    WHERE c.c_cat_id = '$c_cat_id'";
                                    $resultCottages = $conn->query($sqlCottages);

while ($cottage = $resultCottages->fetch_assoc()) {
                                        $cottageId = $cottage['cottage_id'];
                                        $sqlBooking = "SELECT COUNT(*) AS booking_count 
                                       FROM cottage_reservation 
                                       WHERE cottage_id = '$cottageId' 
                                       AND tour = 'NIght' 
                                       AND c_r_date = '$time_zone'";
                                        $resultBooking = $conn->query($sqlBooking);
                                        $booking = $resultBooking->fetch_assoc();
                                        $rowClass = ($booking['booking_count'] > 0) ? 'bg-danger text-white' : '';
                                    ?>
                                        <tr class="<?php echo $rowClass; ?>">
                                            <td><?php echo $cottage['cottage_name']; ?></td>
                                            <td class="text-center"><?php echo ($booking['booking_count'] > 0) ? 'Occupied' : 'Available'; ?></td>
                                            <td><?php echo $cottage['capacity']; ?></td>
                                            <td class="text-center">
                                                <?php if ($booking['booking_count'] == 0) { ?>
                                                    <button type="button" class="btn btn-sm btn-success" data-toggle="modal" data-target="#exampleModal"
                                                        data-cottage-id="<?php echo $cottage['cottage_id']; ?>"
                                                        data-cottage-name="<?php echo $cottage['cottage_name']; ?>"
                                                        data-category-id="<?php echo $c_cat_id; ?>"
                                                        data-capacity="<?php echo $cottage['capacity']; ?>"
                                                        data-price="<?php echo $cottage['price']; ?>">
                                                        <i class="fa-solid fa-plus"></i> Occupy
                                                    </button>
                                                <?php } else { ?>

<a href="nightviewCottage.php?id=<?php echo $cottageId ?>" class="btn btn-sm btn-warning px-3"><i class="fa-solid fa-eye"></i> View</a>
                                                <?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 text-white" style="background-color:rgb(60, 9, 123);">
                        <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>
                    <form action="" method="post">
                        <div class="modal-body">
                            <input type="hidden" name="tour" value="Night">
                            <input type="hidden" name="c_r_date" value="<?php echo $time_zone; ?>">

<div class="row">
                                <div class="col">
                                    <label for="cottage_name">Cottage Name:</label>
                                    <input type="text" id="cottage_name" name="cottage_name" class="form-control h5 font-weight-bold" readonly>
                                </div>
                                <input type="hidden" id="cottage_id" name="cottage_id" class="form-control h5 font-weight-bold" readonly>
                            </div>

<div class="row mt-3">
                                <div class="col">
                                    <label for="fullname">Full Name:</label>
                                    <input type="text" name="fullname" class="form-control" placeholder="Enter Full Name" required>
                                </div>
                                <div class="col">
                                    <label for="contact_num">Contact Number:</label>
                                    <input type="number" name="contact_num" class="form-control " placeholder="Enter Contact Number" required>
                                </div>
                            </div>

<div class="row mt-3">
                                <div class="col">
                                    <div class="form-group">
                                        <label Class="">Max. Capacity:</label>
                                        <input type="number" id="capacity" class="form-control mb-2" readonly>
                                    </div>
                                </div>
                                <div class="col">
                                    <label for="adult">No. of Adults:</label>
                                    <input type="number" id="adult" name="adult" class="form-control" value="0" required>
                                </div>
                                <div class="col">
                                    <label for="child">No. of Children:</label>
                                    <input type="number" id="child" name="child" class="form-control" value="0" required>
                                </div>
                            </div>

<div class="row mt-3">
                                <div class="col">
                                    <label for="discounted">No. of PWD/Senior Adults:</label>
                                    <input type="number" id="discounted" name="discounted" class="form-control" value="0" required>
                                </div>
                                <div class="col">
                                    <label for="pwd_child">No. of PWD Children:</label>
                                    <input type="number" id="pwd_child" name="pwd_child" class="form-control" value="0" required>
                                </div>
                            </div>

<div class="row mt-3">
                                <div class="col">
                                    <label for="payment_status">Payment Status:</label>
                                    <select name="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 class="col">
                                    <label for="mop">Mode of Payment:</label>
                                    <select name="mop" class="form-control" required>
                                        <option value="">*** Select MOP ***</option>
                                        <option value="Cash">Cash</option>
                                        <option value="Check">Check</option>
                                        <option value="Credit Card">Credit Card</option>
                                        <option value="Bank Transfer">Bank Transfer</option>
                                        <option value="Gcash">Gcash</option>
                                        <option value="Complimentary">Complimentary</option>
                                    </select>
                                </div>
                                <div class="col">
                                    <label for="total">Total:</label>
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text font-weight-bold">₱</span>
                                        </div>
                                        <input type="number" id="total" name="total" class="form-control h4 font-weight-bold text-success" style="font-size: 20px;" 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-success px-5">Create</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>

// Set cottage details in the modal
        $('#cottage_name').val(cottageName);
        $('#capacity').val(capacity);
        $('#cottage_id').val(cottageId); // Set the cottage_id in the modal

// Reset inputs
        $('#adult, #child, #discounted, #pwd_child').val(0);
        $('#total').val(cottagePrice.toFixed(2)); // Initialize total with cottage price

// Store cottage price as a data attribute for consistent access during calculations
        $('#total').data('cottage-price', cottagePrice);
    });

function calculateTotal() {
        // Retrieve cottage price
        var cottagePrice = parseFloat($('#total').data('cottage-price')) || 0;

// Get input values
        var adultCount = parseInt($('#adult').val()) || 0;
        var childCount = parseInt($('#child').val()) || 0;
        var discountedCount = parseInt($('#discounted').val()) || 0;
        var pwdChildCount = parseInt($('#pwd_child').val()) || 0;

// Get capacity
        var capacity = parseInt($('#capacity').val()) || 0;

// Prices
        var adultPrice = 200; // Fixed price per adult
        var childPrice = 110; // Fixed price per child
        var discountedPrice = 200; // Fixed price for senior/PWD adults
        var pwdChildPrice = 110; // Fixed price for PWD children
        var discountRate = 0.20; // 20% discount

// Calculate discounted totals
        var discountedTotal = discountedCount * discountedPrice * (1 - discountRate);
        var pwdChildTotal = pwdChildCount * pwdChildPrice * (1 - discountRate);

// Calculate total cost
        var total = cottagePrice + (adultCount * adultPrice) + (childCount * childPrice) + discountedTotal + pwdChildTotal;

// Update total
        $('#total').val(total.toFixed(2));

// Capacity validation
        if ((adultCount + childCount + discountedCount + pwdChildCount) > capacity) {
            $('#adult, #child, #discounted, #pwd_child').css('background-color', 'rgba(255, 0, 0, 0.3)');
        } else {
            $('#adult, #child, #discounted, #pwd_child').css('background-color', '');
        }
    }

// Recalculate total whenever inputs change
    $('#adult, #child, #discounted, #pwd_child').on('input', calculateTotal);
</script>

});
</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: nightCreate.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation