Updated Times & New Status Options

Testing the new check-in/check-out times and enhanced booking status tracking

Updated Times
Check-in Time

2:00 PM (14:00)

Check-out Time

12:00 PM (12:00)

How to Test
  1. Run SQL: Execute the update_times_and_status.sql file
  2. Check Calendar: View updated times in calendar
  3. Test Status: Try updating booking statuses
  4. Verify Logs: Check system logs for updates
New Booking Status Options
Arrival Tracking
Confirmed

Booking confirmed, awaiting guest arrival

Default status for new bookings
Arrived

Guest has arrived at the hotel

Before formal check-in process
No Show

Guest did not arrive for check-in

After check-in time has passed
Checked-in

Guest has completed check-in process

Room is now occupied
Stay Management
Extended

Guest has extended their stay

Beyond original check-out date
Departed

Guest has left the hotel

Before formal check-out process
Checked-out

Guest has completed check-out process

Room is now available
Cancelled

Booking has been cancelled

Room is available for new bookings
SQL File Information
File: config/update_times_and_status.sql

This SQL file will:

  • Update check-in time to 2:00 PM (14:00:00)
  • Update check-out time to 12:00 PM (12:00:00)
  • Add new booking status options: Arrived, No Show, Departed, Extended
  • Create tracking views for check-in and check-out management
  • Add a stored procedure for status updates with logging
  • Insert sample data to demonstrate new features
Important Notes
  • Backup your database before running the SQL file
  • The SQL will update existing bookings with new times
  • New status options provide better guest tracking
  • System logs will record all status changes
How to Execute
Command Line
Get-Content config/update_times_and_status.sql | & "C:\xampp\mysql\bin\mysql.exe" -u root jerome_booking_system
phpMyAdmin
  1. Open phpMyAdmin
  2. Select jerome_booking_system database
  3. Go to SQL tab
  4. Copy and paste the SQL content
  5. Click Execute