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

<?php
include('user.php');

date_default_timezone_set('Asia/Manila');
$timezone = date('Y-m-d H:i:s');
$formatted_date = date('F j, Y', strtotime($timezone));

$rb_id = $_SESSION['rb_id'];
$stmt = $conn->prepare("SELECT * FROM room_booking, room, customer WHERE room.room_id = room_booking.room_id AND room_booking.customer_id = customer.customer_id AND room_booking.rb_id = ?");
$stmt->bind_param("i", $rb_id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

$name = $row['customer_name'];
$db_email = $row['email'];
echo $name;
echo $db_email;

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

require '../../vendor/autoload.php';  // Make sure you have PHPMailer installed

// Assuming form submission is via POST method for booking
// Booking details (get these from your form or database)

$email = $db_email;  // Customer email

$c_in = $row['room_c_in'];
$c_out = $row['real_cout'];

$formatted_c_in = date('M. j, Y', strtotime($c_in)); // Full day of the week + Date
$formatted_c_out = date('M. j, Y', strtotime($c_out)); // Full day of the week + Date

$room_total = $row['total'];
$room_booking_total = number_format($row['total'], 2);
$room_id = $row['room_id'];
$customer_id = $row['customer_id'];
$days_reserved = $row['num_stay'];
$invoice_number =  $row['room_book_num'];
$room_name =  $row['room_name'];
$room_price =  $row['room_price'];
$f_room_price = $room_total / $days_reserved;
$grand_total = $room_total + 30;
$f_total = number_format($grand_total, 2);

$formatted_rprice = number_format($f_room_price, 2);

echo $days_reserved;

echo $room_price;
// Create a new PHPMailer instance
$mail = new PHPMailer(true);

try {
    // Server settings
    $mail->isSMTP();
    $mail->Host = 'smtp.hostinger.com';  // Your SMTP host
    $mail->SMTPAuth = true;
    $mail->Username = "admin@silverconchawavepoolresortandhotel.com";
    $mail->Password = "Scadmin2025##";
    $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;
    $mail->Port = 587;

// Recipients
    $mail->setFrom('admin@silverconchawavepoolresortandhotel.com', "Silverconcha Wavepool Resort & Hotel");
    $mail->addAddress($email, $name);  // Add the recipient's email address

// Content
    $mail->isHTML(true);
    $mail->Subject = 'Booking Confirmation - APPROVED RS#: ' . $invoice_number;

// HTML Email Body with the booking details
    $mail->Body = "

<div style='margin:0; border: none; background:#f5f7f8'>
        <table align='center' border='0' cellpadding='0' cellspacing='0' height='100%' width='100%'>
            <tbody>
                <tr>
                    <td align='center' valign='top'>
                        <table class='contenttable' border='0' cellpadding='0' cellspacing='0' width='600' bgcolor='#ffffff' style='border-width:1px; border-style: solid; border-collapse: separate; border-color:#ededed; margin-top:20px; font-family:Arial, Helvetica, sans-serif'>
                            <tbody>
                                <tr>
                                    <td>
                                        <table border='0' cellpadding='0' cellspacing='0' width='100%'>
                                            <tbody>
                                                <tr>
                                                    <td height='30'>&nbsp;</td>
                                                </tr>
                                                <tr>
                                                    <td width='100%' align='center'>
                                                        <a href='#'>
                                                            <img alt='' style='height: 70px; width: 200px;' src='https://silverconchawavepoolresortandhotel.com/img/core-img/logo1.png'>
                                                        </a>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td height='30'>&nbsp;</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td style='padding:0px 20px;'>
                                        <table width='100%' cellspacing='0' cellpadding='0' border='0'>
                                            <tbody>
                                                <tr>
                                                    <td style='border:4px solid #eee; border-radius:4px; padding:25px 0px;'>
                                                        <table width='100%' cellspacing='0' cellpadding='0' border='0' align='center'>
                                                            <tbody>
                                                                <tr>
                                                                    <td width='50' style='font-size:14px; padding:0px 25px;'><img alt='' src='https://silverconchawavepoolresortandhotel.com/img/book_icon.png' style='height: 50px;'></td>
                                                                    <td style='font-size:16px; font-weight:600; color:#40403e; line-height:26px; padding-right:20px;'><span style='font-size:13px;'>Hi $db_name,</span><br>Thanks! Your reservation is <span style='color:#13a939;'>Approved</span>.</td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td style='padding:20px;'>
                                        <table border='0' cellpadding='0' cellspacing='0' width='100%'>
                                            <tbody>
                                                <tr>
                                                    <td style='padding-right: 30px; font-size:14px; line-height:28px;'><span style='color:#7a7a7a;'>Customer Name: </span><br><span style=' font-weight: bold; color:#40403e;'>$name</span> </td>
                                                    <td style='font-size:14px; line-height:28px;'><span style='color:#7a7a7a;'>Customer Email: </span><br><span style=' font-weight: bold; color:#40403e;'>$email</span> </td>
                                                </tr>
                                                <tr>
                                                    <td style='padding-right: 30px; font-size:14px; line-height:28px;'><span style='color:#7a7a7a;'>Booking Number:</span><br> <a style='outline:none; color:#0071cc; text-decoration:none;' href='#'><span style=' font-weight: bold; color:#40403e;'>$invoice_number</span></a></td>
                                                    <td style='font-size:14px; line-height:28px;'><span style='color:#7a7a7a;'>Booking Status:</span><br> <span style=' font-weight: bold; color:#40403e;'>Approved</span></td>
                                                </tr>
                                                <tr>
                                                    <td style='padding-right: 30px;font-size:14px; line-height:28px;'><span style='color:#7a7a7a;'>Booking Date:</span><br> <span style=' font-weight: bold; color:#40403e;'>$formatted_date</span></td>
                                                    <td style='font-size:14px; line-height:28px;'><span style='color:#7a7a7a;'>Payment:</span><br> <span style=' font-weight: bold; color:#40403e;'>Confirmed</span></td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td class='tablepadding' style='border-top:1px solid #e9e9e9;border-bottom:1px solid #e9e9e9;padding:25px 20px;'>
                                        <table width='100%' align='center' cellpadding='0' cellspacing='0' border='0'>
                                            <tbody>
                                                <tr>
                                                    <td colspan='4' valign='top' style='font-size:14px; line-height:20px; padding-bottom:25px;'><span style='color:#7a7a7a; font-weight: bold; font-size:13px;'>Room Details:</span><br>
                                                        <span style='color:#40403e;display:inline-block; font-weight: bold;'>$room_name</span><br>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td valign='top' width='35%' style='font-size:14px; font-weight: bold; color:#40403e; line-height:20px;'><span style='color:#7a7a7a; font-weight: bold; font-size:13px;'>Check In:</span><br>
                                                        $formatted_c_in</td>
                                                    <td valign='top' width='35%' style='font-size:14px; font-weight: bold; color:#40403e; line-height:20px;'><span style='color:#7a7a7a; font-weight: bold; font-size:13px;'>Check Out:</span><br>
                                                        $formatted_c_out</td>
                                                    <td valign='top' width='30%' style='font-size:14px; font-weight: bold; color:#40403e; line-height:20px;'><span style='color:#7a7a7a; font-weight: bold; font-size:13px;'>No. of Nights:</span><br>
                                                        $days_reserved</td>
                                                </tr>
                                                <tr>
                                                    <td colspan='4' valign='top' style='font-size:13px; line-height:25px; color:#808080; padding-top:20px;'><strong>Note:</strong> The standard check-in time is <strong>2:00 PM</strong> and the standard check-out time is <strong>12:00 PM</strong>.</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td style='padding:25px 20px 0px;'>
                                        <h3 style='margin:0; font-weight:bold; color:#444444;'> Price Summary</h3>
                                    </td>
                                </tr>
                                <tr>
                                    <td class='tablepadding' style='padding:20px 20px;'>
                                        <table width='100%' cellspacing='0' cellpadding='0' border='0' align='center'>
                                            <thead>
                                                <tr>
                                                    <td style='font-size:13px;border-right:1px solid #dddddd;background-color:#f8f8fa;font-weight:bold;padding:10px 7px;color:#505050'>Description</td>
                                                    <td align='right' style='font-size:13px; background-color:#f8f8fa;font-weight:bold;padding:10px 7px;color:#505050'>Amount</td>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <tr>
                                                    <td valign='top' width='100%' style='font-size:14px; line-height:20px; padding:12px 7px; border-top: 1px solid #eaebed; border-bottom: 1px solid #eaebed; color:#404040'>Room Charges<br>
                                                        <span style='font-size:12px; color:#808080'>₱ $formatted_rprice X $days_reserved Night/s</span>
                                                    </td>
                                                    <td valign='top' width='100%' style='font-size:14px; line-height:20px; padding: 12px 7px 12px 0px; border-top: 1px solid #eaebed; border-bottom: 1px solid #eaebed; color: #404040;' valign='top' align='right'><strong>₱$room_booking_total</strong></td>
                                                </tr>
                                                <tr>
                                                    <td valign='top' width='100%' style='font-size:14px; line-height:20px; padding:12px 7px; border-bottom: 1px solid #eaebed; color:#404040'>Other Charges</td>
                                                    <td valign='top' width='100%' style='font-size:14px; line-height:20px; padding: 12px 7px 12px 0px; border-bottom: 1px solid #eaebed; color: #404040;' valign='top' align='right'><strong>0</strong></td>
                                                </tr>
                                                <tr>
                                                    <td valign='top' width='100%' style='font-size:14px; line-height:20px; padding:12px 7px; color:#404040'>Convenience Fee<br>
                                                        <span style='font-size:12px; color:#808080'>₱ 30.00 </span>
                                                    </td>
                                                    <td valign='top' width='100%' style='font-size:14px; line-height:20px; padding: 12px 7px 12px 0px; color: #404040; font-weight: bold;' valign='top' align='right'>₱30.00</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                        <table width='100%' cellspacing='0' cellpadding='0' border='0'>
                                            <tbody>
                                                <tr>
                                                    <td style='background-color:#efefef; border-radius:4px; padding:15px;'>
                                                        <table width='100%' cellspacing='0' cellpadding='0' border='0'>
                                                            <tbody>
                                                                <tr>
                                                                    <td align='right' style='font-size:14px; line-height:25px; color:#404040; font-weight: bold;'>Sub Total Payment:</td>
                                                                    <td style='font-size:14px; line-height:25px; color: #404040; padding-left: 100px;' valign='top' align='right'>₱$room_booking_total</td>
                                                                </tr>
                                                                <tr>
                                                                    <td align='right' style='font-size:14px; line-height:25px; color:#404040; font-weight: bold;'>Convenience Fee:</td>
                                                                    <td style='font-size:14px; line-height:25px; color: #404040; padding-left: 100px;' valign='top' align='right'>₱30.00</td>
                                                                </tr>
                                                                <tr>
                                                                    <td align='right' style='font-size:14px; line-height:25px; color:#404040; font-weight: bold;'>Total Payment:</td>
                                                                    <td style='font-size:17px; line-height:25px; color: #404040; padding-left: 100px;' valign='top' align='right'><strong>₱$f_total</strong></td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td valign='top' align='center' style='font-size:13px; line-height:25px; color:#808080; padding-top:20px;'><strong>Please Note:</strong> Your booking has been approved! Thank you for choosing Silverconcha Wavepool Resort and Hotel. If you have any additional requests or questions, feel free to reach out.We look forward to serving you.</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </td>
                </tr>
                <td>
                    <table width='100%' cellspacing='0' cellpadding='0' border='0' style='font-size:13px;color:#777777; font-family:Arial, Helvetica, sans-serif'>
                        <tbody>
                            <tr>
                                <td class='tablepadding'  style='padding:20px 0; border-collapse:collapse'>
                                    <table width='100%' cellspacing='0' cellpadding='0' border='0' style='font-size:13px;color:#777777; font-family:Arial, Helvetica, sans-serif'>
                                        <tbody>
                                            <tr>
                                                <td>
                                                    <table width='100%' cellspacing='0' cellpadding='0' border='0' style='font-size:13px;color:#555555; font-family:Arial, Helvetica, sans-serif;'>
                                                        <tbody>
                                                            <tr>
                                                                <td align='center' class='tablepadding' style='line-height:20px; padding:20px;'> Silverconcha Wavepool Resort and Hotel <br>Sitio Pugo, Bayambang, Pangasinan, Philippines. <br><a href='https://silverconchawavepoolresortandhotel.com/'>www.silveconchawavepoolresortandhotel.com</a><br>Call us: Smart(+639) 968-551-5335 <br> Globe(+639) 916-638-85747 </td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </td>
            </tbody>
        </table>
    </div>

// Send the email
    if ($mail->send()) {
        $_SESSION['status'] = "Booking Successfully Approved and Email Sent!";
        $_SESSION['code'] = "success";
        unset($_SESSION['$rb_id']);
        header("location: pending_ol.php");
    } else {
        $_SESSION['status'] = "Booking Approval Error!";
        $_SESSION['code'] = "error";
        header("location: pending_ol.php");
    }
} catch (Exception $e) {
    echo "Mailer Error: " . $mail->ErrorInfo;
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: approved_receipt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation