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

<?php

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

$currentDate = date("Y-m-d");
$check = 0;
$current_year = date('Y');  // e.g., '2025'
$year_suffix = date('y');   // e.g., '25'
function generate_invoice_number($conn, $year_suffix)
{
    // Starting invoice number prefix and year suffix for the format SC-<year>-<number>
    $prefix = "SC-";
    $suffix = $year_suffix;

// Get the highest invoice number for the current year in the new format SC-<year>-<number>
    $sql = "SELECT MAX(CAST(SUBSTRING_INDEX(room_book_num, '-', -1) AS UNSIGNED)) AS last_number 
            FROM room_booking 
            WHERE room_book_num LIKE '$prefix$year_suffix-%'";
    $result = $conn->query($sql);

if ($result->num_rows > 0) {
        // Fetch the last invoice number
        $row = $result->fetch_assoc();
        $last_number = $row['last_number'];

// If there is no last invoice number, start at 1
        if ($last_number === null) {
            $last_number = 0;
        }

// Increment the last invoice number
        $new_number = $last_number + 1;

// Format the new number to have leading zeros (5 digits)
        $formatted_number = str_pad($new_number, 6, '0', STR_PAD_LEFT);

// Return the new invoice number in the format SC-<year>-<number>
        return $prefix . $suffix . '-' . $formatted_number;
    } else {
        // If no invoice numbers exist for this year, start with SC-<year>-00001
        return $prefix . $suffix . '-000001';
    }
}

$invoice_number = generate_invoice_number($conn, $year_suffix);
$days_reserved = 0;

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

$room_type = $_POST['room_type'];
    $c_in = $_POST['c_in'];
    if ($c_in < $currentDate) {
        $_SESSION['status'] = "Unable to Reserve previous Date!";
        $_SESSION['code'] = "error";
    } else {
        $check = 1;
    }
}

if (isset($_POST['v_submit'])) {
    $mop = $_POST['mop'];
    $total = $_POST['total'];
    $balance = $_POST['balance'];
    $p_amount = $_POST['p_amount'];
    $payment_status = $_POST['payment_status'];
    $fullname = $_POST['fullname'];
    $contact_num = $_POST['contact_num'];
    $room_id = $_POST['room_id'];
    $check_in_date = $_POST['check_in_date'];

$get_record = mysqli_query($conn, "SELECT * FROM room WHERE room_id ='$room_id'");
    $row = mysqli_fetch_assoc($get_record);
    $db_price = $row['room_price'];

$sql = "INSERT INTO `room_booking`(`room_id`, `room_c_in`, `room_c_out`, `real_cout`, `status`, `book_type`, `r_book_date`, `customer_name`, `room_book_num`, `num_stay`, `total`, `paid_amount`, `balance`, `contact_num`, `customer_id`, `user_id`, `payment_method`) 
        VALUES ('$room_id','$check_in_date','$check_in_date','$check_in_date','Approved','Day Tour','$timezone','$fullname','$invoice_number','1','$total','$p_amount', '$balance','$contact_num', '2', '$log_id','$mop')";

$res = $conn->query($sql);

$_SESSION['status'] = "Reservation Added Successfully";
    $_SESSION['code'] = "success";
}

$db_price = 0;

if (isset($_POST['h_submit'])) {
    $mop = $_POST['mop'];
    $total = $_POST['total'];
    $room_name = $_POST['room_name'];
    $balance = $_POST['balance'];
    $p_amount = $_POST['payment_amount'];
    $payment_status = $_POST['payment_terms'];
    $fullname = $_POST['fullname'];
    $contact_num = $_POST['contact_num'];
    $check_in_date = $_POST['hotel_check_in_date'];

$get_record = mysqli_query($conn, "SELECT room_id FROM room WHERE room_name ='$room_name'");
    $row = mysqli_fetch_assoc($get_record);
    $db_room_id = $row['room_id'];

$sql = "INSERT INTO `room_booking`(`room_id`, `room_c_in`, `room_c_out`, `real_cout`, `status`, `book_type`, `r_book_date`, `customer_name`, `room_book_num`, `num_stay`, `total`,`paid_amount`, `balance`, `contact_num`, `customer_id`,`user_id`, `payment_method`) 
        VALUES ('$db_room_id','$check_in_date','$check_in_date','$check_in_date','Approved','Day Tour','$timezone','$fullname','$invoice_number','1','$total','$p_amount','$balance','$contact_num', '2', '$log_id','$mop')";

$res = $conn->query($sql);

$_SESSION['status'] = "Reservation Added Successfully";
    $_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  dropdown-toggle"><i class="fa-solid fa-person-walking-luggage"></i>
                                Walkin/Call Reservation</a>
                            <ul aria-labelledby="dropdownSubMenu1" class="dropdown-menu border-0 shadow">
                                <li><a href="create.php" class="dropdown-item "><i class="fa-solid fa-circle-plus mr-2"></i> Create</a></li>
                                <li><a href="reserved.php" class="dropdown-item"><i class="fa-solid fa-circle-check mr-2"></i> Reserved</a></li>
                                <li><a href="completed.php" class="dropdown-item"><i class="fa-solid fa-cash-register mr-2"></i> Completed</a></li>
                            </ul>
                        </li>

<li class="nav-item dropdown">
                            <a id="dropdownSubMenu1" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link dropdown-toggle active bg-navy"><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 active"><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">
                    <form action="" method="post">
                        <div class="card">
                            <div class="card-header bg-warning font-weight-bold h5 text-white">
                                DAY TOUR RESERVATION
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-lg-6">
                                        <div class="form-group">
                                            <label Class="">Room Type:</label>
                                            <select name="room_type" id="" class="form-control" required>
                                                <?php if (isset($_POST['submit'])) { ?>
                                                    <option selected value="<?php echo $room_type ?>"><?php echo $room_type ?></option>
                                                <?php } else { ?>
                                                    <option value="">*** Select Room Type ***</option>
                                                <?php } ?>
                                                <option value="Villa">Villa</option>
                                                <option value="Hotel">Hotel</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-lg-6">

<div class="form-group">
                                            <label Class="">Check In:</label>
                                            <?php if (isset($_POST['submit'])) { ?>
                                                <input type="date" class="form-control mb-2" name="c_in"
                                                    required value="<?php echo $c_in ?>">
                                            <?php } else { ?>
                                                <input type="date" class="form-control mb-2" name="c_in"
                                                    required>
                                            <?php } ?>

</div>
                                    </div>
                                </div>
                            </div>
                            <div class="card-footer">
                                <a href="create.php" class="btn bg-danger float-right ml-2"><i class="fa-solid fa-rotate"></i> Reset</a>
                                <button type="submit" name="submit" class="btn btn-primary float-right"><i class="fa-solid fa-filter"></i> Filter Available Room</button>

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

<div class="container pb-5">
                    <?php if ($check == 1) {
                        $sql = "
                        SELECT r.room_id, r.room_name, r.room_type, r.room_price, r.capacity 
                        FROM room r
                        WHERE r.room_type = ?
                        AND r.room_id NOT IN (
                            SELECT b.room_id 
                            FROM room_booking b 
                            WHERE (? >= b.room_c_in AND ? <= b.real_cout)
                            
                        )
                    ";

$stmt = $conn->prepare($sql);
                        $stmt->bind_param("sss", $room_type, $c_in, $c_in,);
                        $stmt->execute();
                        $result = $stmt->get_result();

if ($result->num_rows > 0) { ?>
                            <table id="example2" class="table table-bordered table-striped table-hover">
                                <thead class="text-white bg-warning">
                                    <tr>
                                        <th>Room Name</th>
                                        <th>Capacity</th>
                                        <th>Room Type</th>
                                        <th class="text-center col-2">Action</th>
                                    </tr>
                                </thead>
                                <?php while ($row = $result->fetch_assoc()) { ?>
                                    <tr>
                                        <td><?php echo $row['room_name'] ?></td>
                                        <td><?php echo $row['capacity'] ?></td>
                                        <td><?php echo $row['room_type'] ?></td>
                                        <td class="text-center col-2">
                                            <?php if ($room_type == 'Villa') { ?>
                                                <button type="button" id="updateBtn" class="btn btn-sm btn-success" data-toggle="modal" data-target="#exampleModal" data-days_reserve="<?php echo $days_reserved ?>" data-room_name="<?php echo $row['room_name'] ?>" data-check_out="<?php echo $c_out; ?>" data-check_in="<?php echo $c_in; ?>" data-room_id="<?php echo $row['room_id']; ?>">
                                                    <i class="fa-solid fa-pen-to-square"></i> Create Reservation
                                                </button>
                                            <?php  } else { ?>
                                                <button type="button" id="hotelUpdateBtn" class="btn btn-sm btn-success" data-toggle="modal" data-target="#hotelReservationModal" data-days_reserve="<?php echo $days_reserved ?>" data-price="<?php echo $row['room_price'] ?>" data-room_name="<?php echo $row['room_name'] ?>" data-capacity="<?php echo $row['capacity'] ?>" data-check_out="<?php echo $c_out; ?>" data-check_in="<?php echo $c_in; ?>" data-hotel_room_id="<?php echo $row['room_id']; ?>">
                                                    <i class="fa-solid fa-pen-to-square"></i> Create Reservation
                                                </button>
                                            <?php } ?>
                                        </td>
                                    </tr>
                                <?php } ?>

</table>
                        <?php } else { ?>

<?php  }
                    } ?>

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

<footer class=" main-footer text-dark footer">
            
            <div class="float-right d-none d-sm-inline">
                <strong class="font-weight-bold"><i class="fa-regular fa-clock"></i> Running:
                    <?php $currentDateTime = new DateTime('now');
                    $currentDate = $currentDateTime->format('F d, Y');
                    echo $currentDate; ?> -
                    <span id="txt"></span></strong>
            </div>
            
            <strong>Copyright &copy;<img src="../img/zamjy.png" style="height: 30px; width: 30px;"> Powered By: <a
                    href="https://www.facebook.com/profile.php?id=61560951500923" target="_blank"> ESG
                    IT-Solutions</a>.</strong> All rights reserved 2025.
        </footer>
    </div>

<div class="modal fade" id="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-success">
                    <h5 class="modal-title" id="exampleModalLabel">VILLA RESERVATION (DAY TOUR)</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">

<div class="row">
                            <div class="col">
                                <label for="check_in_date">Check-In Date:</label>
                                <input type="date" id="check_in_date" name="check_in_date" class="form-control" required readonly>
                            </div>
                        </div>

<div class="row mt-3">
                            <div class="col">
                                <label for="room_name">Room Name:</label>
                                <input type="text" id="room_name" name="room_name" class="form-control" readonly>
                                <input type="hidden" id="room_id" name="room_id" class="form-control" readonly>
                            </div>
                            <div class="col">
                                <label for="villa_type">Villa Type:</label>
                                <select name="villa_type" id="villa_type" class="form-control" required>
                                    <option value="">*** Select Villa Type ***</option>
                                    <option value="Villa B">Villa B</option>
                                    <option value="Villa C">Villa C</option>
                                </select>
                            </div>
                        </div>

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

<div class="row mt-3">
                            <div class="col">
                                <label for="capacity">Capacity:</label>
                                <input type="number" id="capacity" name="capacity" class="form-control" readonly>
                            </div>
                            <div class="col">
                                <label for="discounted">No. of PWD/Senior:</label>
                                <input type="number" id="discounted" name="pwd" class="form-control" placeholder="Enter PWD/SC" required>
                            </div>
                        </div>

<div class="row mt-3">
                            <div class="col">
                                <label for="payment_status">Payment Terms:</label>
                                <select name="payment_status" id="payment_status" class="form-control" required>
                                    <option value="">*** Select Term ***</option>
                                    <option value="Full Payment">Full Payment</option>
                                    <option value="Partial">Partial</option>
                                    <option value="Complimentary">Complimentary</option>
                                </select>
                            </div>
                            <div class="col">
                                <label for="mop">MOP:</label>
                                <select name="mop" id="mop" class="form-control" required>
                                    <option value="">*** Select MOP ***</option>
                                    <option value="Cash">Cash</option>
                                    <option value="Gcash">Gcash</option>
                                    <option value="Credit Card">Credit Card</option>
                                    <option value="BPI">BPI</option>
                                </select>
                            </div>
                        </div>

<div class="row mt-3">

<div class="col">
                                <label for="p_amount">Payment Amount:</label>
                                <div class="input-group">
                                    <div class="input-group-prepend">
                                        <span class="input-group-text">₱</span>
                                    </div>
                                    <input type="number" id="p_amount" name="p_amount" class="form-control" required placeholder="Enter Amount">
                                </div>
                            </div>
                            <div class="col">
                                <label for="balance">Balance:</label>
                                <div class="input-group">
                                    <div class="input-group-prepend">
                                        <span class="input-group-text">₱</span>
                                    </div>
                                    <input type="number" id="balance" name="balance" class="form-control" readonly>
                                </div>
                            </div>

<div class="col">
                                <label for="total">Total:</label>
                                <div class="input-group">
                                    <div class="input-group-prepend">
                                        <span class="input-group-text">₱</span>
                                    </div>
                                    <input type="number" id="total" name="total" class="form-control" readonly>
                                </div>
                            </div>
                        </div>

</div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                        <button type="submit" name="v_submit" class="btn btn-success">Create Reservation</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

<div class="modal fade" id="hotelReservationModal" tabindex="-1" role="dialog" aria-labelledby="hotelModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header bg-primary text-white">
                    <h5 class="modal-title" id="hotelModalLabel">HOTEL RESERVATION (DAY TOUR)</h5>
                    <button type="button" class="close text-white" 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>Check-In Date:</label>
                                    <input type="date"
                                        id="hotel_check_in_date"
                                        name="hotel_check_in_date"
                                        class="form-control mb-2"
                                        required
                                        value="<?php echo isset($c_in) ? htmlspecialchars($c_in) : ''; ?>">
                                </div>
                            </div>

</div>

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

<div class="form-group">
                            <label>Note:</label>
                            <textarea class="form-control" id="hotel_note" name="note" rows="2" placeholder="Enter Note"></textarea>
                        </div>
                        <div class="row">
                            <div class="col">
                                <div class="form-group">
                                    <label>Capacity:</label>
                                    <input type="number" id="hotel_capacity" class="form-control" readonly>
                                </div>
                            </div>
                            <div class="col">
                                <div class="form-group">
                                    <label>No. of PWD/Senior:</label>
                                    <input type="number" id="hotel_discounted" name="discounted" class="form-control" placeholder="Enter PWD/SC Count">
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col">
                                <div class="form-group">
                                    <label>Payment Terms:</label>
                                    <select name="payment_terms" id="hotel_payment_terms" class="form-control" required>
                                        <option value="">*** Select Term ***</option>
                                        <option value="Full Payment">Full Payment</option>
                                        <option value="Partial">Partial</option>
                                        <option value="Complimentary">Complimentary</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col">
                                <div class="form-group">
                                    <label>MOP (Mode of Payment):</label>
                                    <select name="mop" id="hotel_mop" class="form-control" required>
                                        <option value="">*** Select MOP ***</option>
                                        <option value="Cash">Cash</option>
                                        <option value="Credit Card">Credit Card</option>
                                        <option value="Bank Transfer">Bank Transfer</option>
                                    </select>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col">
                                <div class="form-group">
                                    <label>Payment Amount:</label>
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text">₱</span>
                                        </div>
                                        <input type="number" id="hotel_payment_amount" name="payment_amount" class="form-control" required>
                                    </div>
                                </div>
                            </div>
                            <div class="col">
                                <div class="form-group">
                                    <label>Balance:</label>
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text">₱</span>
                                        </div>
                                        <input type="number" id="hotel_balance" name="balance" class="form-control" readonly>
                                    </div>
                                </div>
                            </div>
                            <div class="col">
                                <div class="form-group">
                                    <label>Total:</label>
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text">₱</span>
                                        </div>
                                        <input type="number" id="hotel_total" name="total" class="form-control" 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="h_submit" class="btn btn-primary">Save Reservation</button>
                </div>
                </form>
            </div>
        </div>
    </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 basePrice = 0;
        let currentTotal = 0;
        let daysReserved = 1; // Store days reserved globally

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];
                basePrice = price;
                currentTotal = basePrice * daysReserved; // Multiply by days reserved here
                $('#total').val(currentTotal.toFixed(2));
                $('#capacity').val(capacity);
                $('#discounted').val('');
                $('#p_amount').val('');
                $('#balance').val('');
            }
        });

$('#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('');
            $('#balance').val('');
        });

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

$('#exampleModal').on('show.bs.modal', function(event) {
            const button = $(event.relatedTarget);
            const roomName = button.data('room_name');
            const checkInDate = button.data('check_in');
            const checkOutDate = button.data('check_out');
            const roomId = button.data('room_id');
            daysReserved = parseInt(button.data('days_reserve')) || 1; // update global daysReserved

$('#room_name').val(roomName);
            $('#check_in_date').val(checkInDate);
            $('#check_out_date').val(checkOutDate);
            $('#room_id').val(roomId);

if (roomName === "Villa 1 A" || roomName === "Villa 2 A") {
                basePrice = 4500;
                currentTotal = basePrice * daysReserved;
                $('#total').val(currentTotal.toFixed(2));
                $('#capacity').val(4);
                $('#villa_type').prop('disabled', true);
            } else if (villaDetails[roomName]) {
                basePrice = villaDetails[roomName].price;
                currentTotal = basePrice * daysReserved;
                $('#total').val(currentTotal.toFixed(2));
                $('#capacity').val(villaDetails[roomName].capacity);
                $('#villa_type').prop('disabled', false);
                $('#villa_type').val(roomName); // Optional: Set dropdown value to current villa
            } else {
                basePrice = 0;
                currentTotal = 0;
                $('#total').val('');
                $('#capacity').val('');
                $('#villa_type').prop('disabled', false);
            }

$('#discounted').val('0');
            $('#p_amount').val('');
            $('#balance').val('');
        });

$('#exampleModal').on('hidden.bs.modal', function() {
            basePrice = 0;
            currentTotal = 0;
            daysReserved = 1; // Reset days reserved
            $('#total').val('');
            $('#capacity').val('');
            $('#discounted').val('');
            $('#p_amount').val('');
            $('#balance').val('');
            $('#villa_type').prop('disabled', false);
            $('#villa_type').val(''); // reset dropdown
        });
    });
</script>

// Reset the discounted field to zero
        $('#hotel_discounted').val(0);
        // Populate modal fields with button data
        $('#hotel_room_name').val(roomName);
        $('#hotel_capacity').val(capacity);
        $('#hotel_check_in_date').val(checkInDate);

// Set the initial total price as a data attribute for reference
        const totalPriceForDays = price * daysReserve; // Multiply price by days reserved
        $('#hotel_total').data('original-price', totalPriceForDays);
        $('#hotel_total').val(totalPriceForDays.toFixed(2));

// Store daysReserve as a data attribute to use in calculations
        $('#hotel_total').data('days-reserve', daysReserve);

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 daysReserve = parseInt($('#hotel_total').data('days-reserve')) || 1; // Retrieve stored days reserved
        const paymentAmount = parseFloat($('#hotel_payment_amount').val()) || 0;

// Calculate pre-total and discount
        let discount = 0;
        if (capacity > 0 && discounted > 0) {
            const discountPerPerson = (originalPrice / daysReserve) / capacity * 0.2; // 20% discount per eligible guest
            discount = discountPerPerson * discounted * daysReserve;
        }
        const finalTotal = originalPrice - discount;

// 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
            c
        }; // add zero in front of numbers < 10
        return i;
    }
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: day_create.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation