VAGARY Admin — Reservation Management

✦

Online Bookings

0

From website

≡

Sheet Entries

0

Manual rows

RM

Total Revenue

RM 0

Online + deposits

⌂

Occupied

0

Active rooms

◉

Breakfast Pax

0

Today

New website bookings received — not yet in reservation sheet

Recent Bookings

Auto-synced from website

No bookings yet.

Quick Actions

Admin Notes

Reservation Sheet

A/B/C = Deluxe · 1–12 = Standard · KG = Rumah Kampung

Month

Day

Add New Month

Select the year and month to add all dates for that period.

Year

Month

Log Tempahan

ROOM	GUEST NAME	STATUS	PER NIGHT	ACTIVITIES / ADD ON	PAKEJ / B.COM	NUMBER PHONE	DEPOSIT (RM)	DATE DEPOSIT	DEPO ROOM COVERAGE	CPT	ADULT	CHILD (5-10Y)	EXTRA MATTRESS	BREAK FAST	REMARKS
Select a date above to view the sheet.
TOTALS

ROOMS OCCUPIED0

TOTAL PAX0

DEPOSITRM 0

BREAKFAST0

EXTRA MATTRESS0

CPT0

Remarks & Pax Summary

Cancelled/postponed notes and pax breakdown

CANCELLED BOOKING.COM

CANCELLED WHATSAPP BOOKING

POSTPONE WHATSAPP BOOKING

DOMESTIK

DEWASA

CHILD (5-10Y)

ANTARABANGSA

DEWASA

CHILD (5-10Y)

Housekeeping Report

Room status, linen & check-in/out times — exactly like Excel

ROOM	GUEST NAME	ROOM STATUS	DONE CHECK IN	DONE CHECK OUT	REMARK	BATH TOWEL	BATH MATH	SOAP	SHAMPOO	B SHEET			D.COVER			P CASE			ROOM
										K	Q	T	K	Q	T	K	Q	T
TOTALS

Occupancy Summary

Auto-calculated from room statuses above

OCCUPANCY	VACANT DIRTY	CHECK OUT	BLOCKED	VACANT CLEAN	RESERVE	STAY ON	CHECKOUT+CHECKIN	TISSUE	MATTRESS	BATH TOWEL	BATH MATH	SOAP	SHAMPOO	B SHEET K/Q/T			D.COVER K/Q/T			P CASE

Rate Calendar

Click any date to mark as Peak Season

Weekday

Weekend auto Sat/Sun

Peak Season click to set

Click Save All in the top bar to save rates to database.

Tempahan Online

Dari website — klik "→ Tambah ke Sheet" untuk masukkan dalam jadual

Tiada tempahan lagi.

Cancelled Bookings

Bookings cancelled by admin — room slots have been freed

No cancelled bookings.

Pendapatan

Semua tempahan online

Ref	Tetamu	Masuk	Keluar	Bilik	Jumlah	Bayaran	Status
Tiada data.

Jumlah Keseluruhan: RM 0

🔌 Setup Database & Email — cPanel Hosting

Panduan sambungan MySQL dan konfigurasi emel pengesahan

1

Upload Fail ke cPanel

Log masuk cPanel → File Manager → public_html. Upload folder vagary/ ke sini:

https://yourdomain.com/vagary/

💡 Jika laman utama, upload ke root public_html terus.

2

Cipta Database MySQL

cPanel → MySQL Databases (atau Wizard). Cipta:

Database: youraccount_vagary
Username: youraccount_vaguser
Password: (pilih kata laluan kuat)
Privileges: ALL PRIVILEGES

⚠ cPanel tambah prefix akaun. "vagary" → "youraccount_vagary" automatik.

3

Import Schema Database

cPanel → phpMyAdmin → Pilih database baru → Tab Import → Upload vagary/database.sql → Klik Go.

Ini cipta: users, bookings, reservation_sheets, room_rates

4

Edit Fail Config

File Manager → public_html/vagary/api/config.php → Edit. Tukar 4 nilai:

$DB_HOST = 'localhost';
$DB_NAME = 'youraccount_vagary';
$DB_USER = 'youraccount_vaguser';
$DB_PASS = 'kata_laluan_anda';

💡 Host biasanya "localhost" untuk shared hosting cPanel.

5

Test Sambungan

Buka URL ini dalam browser:

https://yourdomain.com/vagary/api/check-db.php

Patut nampak: {"success":true,"database":"youraccount_vagary"...}

6

Setup Email Pengesahan

Edit api/send-confirmation.php, tukar email admin:

$adminEmail = 'admin@vagary.com'; // ← Tukar ke email sebenar anda

Untuk SMTP yang lebih reliable, pasang PHPMailer atau guna cPanel Email Accounts. Uji dengan buat tempahan di website — emel akan dihantar ke tetamu dan admin.

💡 Jika emel tidak sampai, semak cPanel → Email Deliverability dan pastikan domain ada SPF record.

7

Siap! Test Keseluruhan

Lawati website → buat akaun → buat tempahan. Semak:

phpMyAdmin → youraccount_vagary → bookings → patut ada data

Admin → Online Bookings → patut tunjuk tempahan baru secara automatik.

✅ Database tersambung. Semua data pengguna dan tempahan kekal secara kekal.

Jana config.php

Masukkan nilai dari cPanel MySQL Databases

DB Host

Nama Database

DB Username

DB Password

Paste ke dalam api/config.php di server