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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: confirm_payment.php

<?php
session_start();
include('config.php');

if (!isset($_SESSION['customer_id'])) {
    header('location: login.php');
} else {
    $customer_id = $_SESSION['customer_id'];

$get_record = mysqli_query($conn, "select * from customer where customer_id ='$customer_id'");
    $row = mysqli_fetch_assoc($get_record);
    $db_name = $row['name'];
    $log_lastname = $row['lastname'];
    $db_fullname = $db_name . " " . $log_lastname;
    $db_email = $row['email'];

$timezone = new DateTimeZone('Asia/Manila');
    $date = new DateTime('now', $timezone);
    $currentDate = $date->format('Y-m-d H:i:s');
    $current_year = date('Y');
    $year_suffix = date('y');

function generate_invoice_number($conn, $year_suffix)
    {
        $prefix = "SC-";
        $suffix = $year_suffix;

$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) {
            $row = $result->fetch_assoc();
            $last_number = $row['last_number'];
            if ($last_number === null) {
                $last_number = 0;
            }
            $new_number = $last_number + 1;
            $formatted_number = str_pad($new_number, 6, '0', STR_PAD_LEFT);
            return $prefix . $suffix . '-' . $formatted_number;
        } else {
            return $prefix . $suffix . '-000001';
        }
    }

// Generate invoice number
    $invoice_number = generate_invoice_number($conn, $year_suffix);

// Check if invoice number already exists in the database
    $check_invoice_sql = "SELECT * FROM room_booking WHERE room_book_num = '$invoice_number'";
    $check_result = mysqli_query($conn, $check_invoice_sql);

if (mysqli_num_rows($check_result) > 0) {
        // If the invoice number already exists, redirect back to check_out.php
        header('location: check_out.php?id=' . $_SESSION['room_id']);
        exit;  // Make sure to exit after the redirect
    } else {

// Booking data
        $c_in = $_SESSION['c_in'];
        $c_out = $_SESSION['c_out'];

if ($c_in == $c_out) {
            $c_out1 = date('Y-m-d', strtotime($c_out . ' +1 day'));
        } else {
            $c_out1 = $c_out; // Corrected variable name
        }
        $c_out_minus_one_day = date('Y-m-d', strtotime($c_out . ' -1 day'));
        $room_booking_total = $_SESSION['total'];
        $room_id = $_SESSION['room_id'];
        $customer_id = $_SESSION['customer_id'];
        $days_reserved = $_SESSION['num_stay'];
        $_SESSION['invoice'] = $invoice_number;

// Insert booking into the database
        $sql = "INSERT INTO `room_booking`(`room_id`, `room_c_in`, `room_c_out`, `status`, `book_type`, `r_book_date`, `customer_id`, `room_book_num`, `num_stay`, `total`, `real_cout`, `customer_name`) VALUES
 ('$room_id','$c_in','$c_out_minus_one_day','Pending','Online','$currentDate','$customer_id','$invoice_number','$days_reserved','$room_booking_total','$c_out1','$db_fullname')";
        $res = $conn->query($sql);

if ($res) {
            // Booking successful, redirect to email_receipt.php
            header('location: email_receipt.php');
        } else {
            // Something went wrong, redirect back to check_out.php
            header('location: check_out.php?id=' . $room_id);
        }
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: confirm_payment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation