File Manager

X7ROOT File Manager

Current Path: /home/u126090504/domains/oceanicabeachresort.com/public_html/admin

home / u126090504 / domains / oceanicabeachresort.com / public_html / admin /

📁 ..
📁 assets
📄 banners.php(9.78 KB)
📄 booking-dashboard.php(4.93 KB)
📄 booking_status_update.php(6.14 KB)
📄 booking_view.php(4.04 KB)
📄 branding_settings.php(5.93 KB)
📄 change_password.php(3.01 KB)
📄 contacts.php(3.83 KB)
📄 dashboard.php(5.64 KB)
📁 dompdf
📄 downloads.php(4.91 KB)
📄 forgot_password.php(5.76 KB)
📄 gallery.php(3.08 KB)
📁 img
📁 includes
📄 index.php(82 B)
📁 invoices
📄 login.php(13.47 KB)
📄 logo.png(19.29 KB)
📄 logout.php(102 B)
📄 manage_albums.php(10.82 KB)
📄 manage_media.php(11.77 KB)
📄 manage_photos.php(6.35 KB)
📄 manage_videos.php(18.38 KB)
📄 new_password.php(3.9 KB)
📄 notice.php(15.52 KB)
📄 notice_error.log(38.45 KB)
📄 notices.php(8.24 KB)
📄 payments.php(14.96 KB)
📄 pdf_bill_template.php(30.69 KB)
📁 phpmailer
📄 popup.php(14.07 KB)
📄 reset_password.php(2.27 KB)
📄 secure_session.php(1000 B)
📄 settings.php(8.34 KB)
📄 test.php(239 B)
📄 test_pdf.php(1.58 KB)
📄 testimonials.php(15.15 KB)
📁 tmp
📄 update_status.php(1.66 KB)
📄 upi_settings.php(1.52 KB)

Editing: booking_status_update.php

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

/* ================= SESSION ================= */
include 'secure_session.php';

/* ================= DB ================= */
require_once __DIR__ . '/../config.php';

/* ================= PHPMailer ================= */
require $_SERVER['DOCUMENT_ROOT'].'/admin/phpmailer/src/PHPMailer.php';
require $_SERVER['DOCUMENT_ROOT'].'/admin/phpmailer/src/SMTP.php';
require $_SERVER['DOCUMENT_ROOT'].'/admin/phpmailer/src/Exception.php';

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

/* ================= DOMPDF ================= */
require_once __DIR__.'/dompdf/autoload.inc.php';
require_once __DIR__.'/pdf_bill_template.php';

use Dompdf\Dompdf;

/* ================= POST CHECK ================= */
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    header("Location: booking-dashboard.php");
    exit;
}

/* ================= INPUT ================= */
$id             = (int)$_POST['id'];
$payment_status = $_POST['payment_status'];
$booking_status = $_POST['booking_status'];

/* ================= UPDATE ================= */
$stmt = $conn->prepare(
    "UPDATE bookings SET payment_status=?, booking_status=? WHERE id=?"
);
$stmt->bind_param("ssi", $payment_status, $booking_status, $id);
$stmt->execute();
$stmt->close();

/* ================= FETCH BOOKING ================= */
$q = $conn->prepare("
    SELECT booking_id,name,email,room_type,
           checkin_date,checkout_date,
           adults,children,amount,payment_status,booking_status
    FROM bookings WHERE id=?
");
$q->bind_param("i", $id);
$q->execute();
$data = $q->get_result()->fetch_assoc();
$q->close();

/* ================= DATES ================= */
$checkin  = date("d M Y", strtotime($data['checkin_date']));
$checkout = date("d M Y", strtotime($data['checkout_date']));

/* ================= PDF GENERATION ================= */
$logoPath = 'file://' . $_SERVER['DOCUMENT_ROOT'] . '/admin/logo.png';
$pdfHtml  = bookingPdfHtml($data, $logoPath);

$dompdf = new Dompdf([
    'isRemoteEnabled' => true
]);
$dompdf->loadHtml($pdfHtml);
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();

$tmpDir = $_SERVER['DOCUMENT_ROOT'].'/admin/tmp';
if (!is_dir($tmpDir)) {
    mkdir($tmpDir, 0777, true);
}

$pdfPath = $tmpDir.'/Booking_'.$data['booking_id'].'.pdf';
file_put_contents($pdfPath, $dompdf->output());

/* ================= EMAIL ================= */
if (!empty($data['email'])) {
    try {
        $mail = new PHPMailer(true);
        $mail->isSMTP();
        $mail->Host       = 'smtp.hostinger.com';
        $mail->SMTPAuth   = true;
        $mail->Username   = 'noreply@oceanicabeachresort.com';
        $mail->Password   = '9861845796Aa@#';
        $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;
        $mail->Port       = 587;

$mail->setFrom('noreply@oceanicabeachresort.com', 'Oceanica Beach Resort');
        $mail->addAddress($data['email'], $data['name']);
        $mail->addAttachment($pdfPath, 'Booking_Invoice.pdf');

$mail->isHTML(true);
        $mail->Subject = 'Booking Confirmation | Oceanica Beach Resort';

$mail->Body = '
<!DOCTYPE html>
<html>
<body style="margin:0;background:#f4f6f9;font-family:Arial">

<table width="680" style="background:#fff;border-radius:14px;box-shadow:0 15px 40px rgba(0,0,0,.08)">
<tr>
<td style="background:#0b1c2d;padding:28px;text-align:center">
<img src="https://oceanicabeachresort.com/assets/images/logo/logo.png" style="height:70px"><br>
<h2 style="color:#fff;margin:15px 0 0">Booking Status Update</h2>
</td>
</tr>

<p>Dear <b>'.htmlspecialchars($data['name']).'</b>,</p>
<p>Your booking status has been updated. Details below:</p>

<table width="100%" cellpadding="10" style="font-size:14px;border-collapse:collapse">
<tr style="background:#f8fafc"><td><b>Booking ID</b></td><td>'.$data['booking_id'].'</td></tr>
<tr><td><b>Room</b></td><td>'.$data['room_type'].'</td></tr>
<tr style="background:#f8fafc"><td><b>Check-In</b></td><td>'.$checkin.'</td></tr>
<tr><td><b>Check-Out</b></td><td>'.$checkout.'</td></tr>
<tr style="background:#f8fafc"><td><b>Adults</b></td><td>'.$data['adults'].'</td></tr>
<tr><td><b>Children</b></td><td>'.$data['children'].'</td></tr>
<tr style="background:#f8fafc"><td><b>Payment Status</b></td><td style="color:green"><b>'.$payment_status.'</b></td></tr>
<tr><td><b>Paid Amount</b></td><td><b>₹'.number_format($data['amount'],2).'</b></td></tr>
<tr style="background:#f8fafc"><td><b>Booking Status</b></td><td style="color:#0b5ed7"><b>'.$booking_status.'</b></td></tr>
</table>

<div style="margin-top:25px;background:#fff3cd;padding:15px;border-left:5px solid #d4a017">
Please keep this email and attached invoice for your records.
</div>

<p style="margin-top:25px">
Regards,<br>
<b>Oceanica Beach Resort</b><br>
<a href="https://oceanicabeachresort.com">www.oceanicabeachresort.com</a>
</p>

</td>
</tr>

<tr>
<td style="background:#f1f1f1;text-align:center;font-size:12px;padding:12px">
© '.date('Y').' Oceanica Beach Resort • Bagda Beach, Odisha
</td>
</tr>
</table>

</td></tr>
</table>

</body>
</html>';

$mail->send();
    } catch (Exception $e) {}
}

$invoiceDir = $_SERVER['DOCUMENT_ROOT'].'/admin/invoices';
if (!is_dir($invoiceDir)) {
    mkdir($invoiceDir, 0777, true);
}

$pdfPath = $invoiceDir.'/Invoice_'.$data['booking_id'].'.pdf';
file_put_contents($pdfPath, $dompdf->output());

/* ================= WHATSAPP ================= */
if ($booking_status === 'Confirmed') {
    $waMsg = urlencode(
        "Hello {$data['name']},\n\nYour booking is CONFIRMED ✅\n\n".
        "Booking ID: {$data['booking_id']}\n".
        "Room: {$data['room_type']}\n".
        "Check-In: {$checkin}\n".
        "Check-Out: {$checkout}\n\n".
        "Oceanica Beach Resort"
    );
    echo "<script>window.open('https://wa.me/919124413026?text={$waMsg}','_blank');</script>";
}

/* ================= REDIRECT ================= */
header("Location: booking_view.php?id=$id&success=1");
exit;

X7ROOT File Manager

Editing: booking_status_update.php

Upload File

Create Folder