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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: createRoom.php

<?php
include("header.php"); //HEADER CALL
include("topnav.php"); // TOP NAVIGATION CALL

//FUNCTION ADDING CUSTOMER

$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);

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

$fullname = $_POST['full_name'];
    $contact_num = $_POST['contact_num'];
    $address = $_POST['address'];
    $room_id = $_POST['room_id'];
    $c_in = $_POST['c_in'];
    $c_out = $_POST['c_out'];
    $c_out_minus_one_day = date('Y-m-d', strtotime($c_out . ' -1 day'));

$nc_in = new DateTime($_POST['c_in']);
    $nc_out = new DateTime($_POST['c_out']);

// Calculate the difference between the two dates
    $interval = $nc_in->diff($nc_out);
    $days_reserved = $interval->days;

// Check for existing booking with overlapping dates
    $check_booking_sql = "SELECT * FROM `room_booking` 
                          WHERE `room_id` = '$room_id' 
                          AND (
                              (`room_c_in` <= '$c_out' AND `room_c_out` >= '$c_in') 
                          )";
    $result = mysqli_query($conn, $check_booking_sql);

if (mysqli_num_rows($result) > 0) {
        // There is an overlap with another booking
        $_SESSION['status'] = "This room is already booked for the selected dates.";
        $_SESSION['code'] = "error";
    } else {
        // No overlap, proceed with the booking
        $get_record = mysqli_query($conn, "SELECT * FROM room WHERE room_id ='$room_id'");
        $row = mysqli_fetch_assoc($get_record);
        $db_price = $row['room_price'];

$total = $db_price * $days_reserved;

$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`, `contact_num`, `address`, `customer_id`) 
        VALUES ('$room_id','$c_in','$c_out_minus_one_day','$c_out','Pending','Walk In','$timezone','$fullname','$invoice_number','$days_reserved','$total','$contact_num','$address', '2')";

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

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

//FUNCTION FOR DELETING CUSTOMER
if (isset($_POST['id'])) {
    $rb_id = $_POST['id'];

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

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

//END FUNCTION
?>

<nav class="mt-3">
    <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
        
        <li class="nav-item">
            <a href="index.php" class="nav-link ">
                <i class="nav-icon fas fa-tachometer-alt"></i>
                <p>
                    Dashboard
                    
                </p>
            </a>
        </li>

<li class="nav-header">MANAGEMENT</li>

<li class="nav-item">
            <a href="manageEmployee.php" class="nav-link ">
                <i class="fa-solid fa-user nav-icon"></i>
                <p>
                    Manage Employee
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageCustomer.php" class="nav-link">
                <i class="fa-solid fa-users nav-icon"></i>
                <p>
                    Manage Customer
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageEvent.php" class="nav-link ">
                <i class="fa-solid fa-champagne-glasses nav-icon"></i>
                <p>
                    Manage Event
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageRoom.php" class="nav-link ">
                <i class="fa-solid fa-bed nav-icon"></i>
                <p>
                    Manage Room
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageServices.php" class="nav-link ">
                <i class="fa-solid fa-cart-flatbed-suitcase nav-icon"></i>
                <p>
                    Manage Services
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageAmeneties.php" class="nav-link">
                <i class="fa-solid fa-tree nav-icon"></i>
                Manage Amenities
                
                </p>
            </a>
        </li>

<li class="nav-header">RESERVATIONS</li>

<li class="nav-item menu-is-opening menu-open">
            <a href="#" class="nav-link active">
                <i class="fa-regular fa-calendar nav-icon"></i>
                <p>
                    Room Reservation
                    <i class="fas fa-angle-left right"></i>
                </p>
            </a>
            <ul class="nav nav-treeview">
                <li class="nav-item">
                    <a href="createRoom.php" class="nav-link active">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Create</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="pendingRoom.php" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Pending</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="approvedRoom.php" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Approved</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="completedRoom.php" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Completed</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="declinedRoom.php" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Decline</p>
                    </a>
                </li>
            </ul>
        </li>

<li class="nav-item menu-is-opening menu-close">
            <a href="#" class="nav-link">
                <i class="fa-regular fa-calendar nav-icon"></i>
                <p>
                    Cottage Reservation
                    <i class="fas fa-angle-left right"></i>
                </p>
            </a>
            <ul class="nav nav-treeview" style="display: hidden;">
                <li class="nav-item">
                    <a href="../pos/index.php" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Go to Dashboard</p>
                    </a>
                </li>

</ul>
        </li>

<li class="nav-item">
            <a href="eventReservation.php" class="nav-link">
                <i class="fa-regular fa-calendar nav-icon"></i>
                <p>
                    Event Reservation
                    
                </p>
            </a>
        </li>

<li class="nav-header">REPORTS</li>

<li class="nav-item">
            <a href="reports.php" class="nav-link">
                <i class="fa-solid fa-sack-dollar nav-icon"></i>
                <p>
                    Sales Report
                    
                </p>
            </a>
        </li>

</ul>
</nav>

</div>

</aside>

<div class="content-wrapper">
    
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">

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

<div class="content">
        <div class="container-fluid bg-light">

<div class="card">
                <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">ROOM BOOKING (WALK-IN)</h3>

<button class="btn bg-primary float-right" data-toggle="modal"
                        data-target="#exampleModal"><i class="fa-solid fa-plus"></i> Add Booking</button>

</div>

<div class="card-body">
                    <table id="example2" class="table table-bordered table-striped table-hover">
                        <thead class="text-white bg-lightblue">
                            <tr>
                                <th>Book Number</th>
                                <th>Customer Name</th>
                                <th>Room Name</th>
                                <th>Check In</th>
                                <th>Check Out</th>
                                <th>No. of Stay</th>
                                <th>Total</th>
                                <th>Book Type</th>
                                <th>Status</th>
                                <th class="col-2 text-center">Action</th>
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $sql = "select * from room_booking, room where room_booking.room_id = room.room_id and room_booking.book_type = 'Walk In'; "; // SHOWING DATA ON THE TABLES
                            $res = $conn->query($sql);
                            while ($row = $res->fetch_assoc()) {
                            ?>
                                <tr>
                                    <td><span class="badge badge-primary p-1"><?php echo $row['room_book_num'] ?></span><br><?php echo date("M d, Y h:i A", strtotime($row['r_book_date'])) ?></td>
                                    <td><?php echo $row['customer_name'] ?></td>
                                    <td><?php echo $row['room_name'] ?></td>
                                    <td><?php echo date("M d, Y", strtotime($row['room_c_in'])) ?></td>
                                    <td><?php echo date("M d, Y", strtotime($row['real_cout'])) ?></td>
                                    <td><?php echo $row['num_stay'] ?> Night/s</td>
                                    <td>₱ <?php echo number_format($row['total'], 2) ?></td>
                                    <td><?php echo $row['book_type'] ?></td>
                                    <td>
                                        <?php if ($row['status'] == 'Approved') { ?>
                                            <span class="badge badge-primary"><?php echo $row['status'] ?></span>
                                        <?php } else if ($row['status'] == 'Completed') { ?>
                                            <span class="badge badge-success"><?php echo $row['status'] ?></span>
                                        <?php } else if ($row['status'] == 'Pending') { ?>
                                            <span class="badge badge-warning"><?php echo $row['status'] ?></span>
                                        <?php } else { ?>
                                            <span class="badge badge-danger"><?php echo $row['status'] ?></span>
                                        <?php } ?>

</td>

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

</table>

</div>
                
            </div>

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

<aside class="control-sidebar control-sidebar-dark">
    
    <div class="p-3">
        <h5>Title</h5>
        <p>Sidebar content</p>
    </div>
</aside>

<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">ADD ROOM BOOKING</h5>

<button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form action="" method="post">
                    <div class="row">
                        <div class="col">
                            <div class="form-group">
                                <label Class="">Customer Full Name:</label>
                                <input type="text" class="form-control mb-2" name="full_name" placeholder="Enter name" required>
                            </div>

<div class="form-group">
                                <label Class="">Contact #:</label>
                                <input type="number" maxlength="11" class="form-control mb-2" name="contact_num"
                                    placeholder="Enter Contact Number" required>
                            </div>

<div class="form-group">
                                <label for="comment" class="">Address:</label>
                                <textarea class="form-control" rows="3" name="address" required placeholder="Enter Address"></textarea>
                            </div>
                        </div>
                        <div class="col">
                            <div class="form-group">
                                <label Class="">Room:</label>
                                <select name="room_id" id="" class="form-control">
                                    <option value="">*** Select Room ***</option>
                                    <?php $sql1 = "select * from room";
                                    $res1 = $conn->query($sql1);
                                    while ($row1 = $res1->fetch_assoc()) { ?>
                                        <option value="<?php echo $row1['room_id'] ?>"><?php echo $row1['room_name'] ?></option>
                                    <?php } ?>

</select>
                            </div>
                            <div class="form-group">
                                <label Class="">Check In:</label>
                                <input type="date" class="form-control mb-2" name="c_in"
                                    required>
                            </div>

<div class="form-group">
                                <label Class="">Check Out:</label>
                                <input type="date" class="form-control mb-2" name="c_out"
                                    required>
                            </div>

</div>
                    </div>

</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                <button type="submit" name="add" class="btn btn-primary">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>

<?php
include("footer.php");
include("alert.php");
?>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: createRoom.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation