Updated Dashboard Features

Testing the manual check-in system and extend functionality

Manual Check-in System
Check-in Today Section
  • Shows all Confirmed bookings for today's check-in date
  • Manual action required - staff must choose action
  • Standard check-in time displayed (2:00 PM)
  • Two action buttons:
    • Check-in - Guest has arrived and checked in
    • No Show - Guest did not arrive
Process:
1. Guest arrives at hotel → Staff clicks "Check-in" → Status becomes "Checked-in"
2. Guest doesn't arrive → Staff clicks "No Show" → Status becomes "No Show"
3. Room status updates accordingly (Occupied for Checked-in, Available for No Show)
Check-out with Extend Option
Check-out Tomorrow Section
  • Shows Checked-in bookings for tomorrow's check-out date
  • Standard check-out time displayed (12:00 PM)
  • Two action buttons:
    • Check-out - Complete check-out process
    • Extend - Extend stay by 1 day
Extend Process:
1. Staff clicks "Extend" button
2. Modal opens with day selection options (1-5 days, 1-2 weeks)
3. Staff selects number of days to extend
4. New checkout date is calculated and displayed
5. Staff confirms extension
6. Check-out date is updated, booking remains "Checked-in" status
Updated Times
Check-in Time: 2:00 PM (14:00)
Check-out Time: 12:00 PM (12:00)
Reverted Status Options
Confirmed

Default status for new bookings

Checked-in

Guest has completed check-in

No Show

Guest did not arrive for check-in

Checked-out

Guest has completed check-out

Cancelled

Booking has been cancelled

SQL File Information
File: config/update_checkin_extend.sql

This SQL file will:

  • Revert booking status to original options (Confirmed, Checked-in, Checked-out, Cancelled)
  • Keep updated check-in time (2:00 PM) and check-out time (12:00 PM)
  • Reset any bookings with new status options back to "Confirmed"
  • Create views for manual check-in system
  • Insert sample data for testing
Key Changes Made
  • Enhanced Check-in: Dashboard shows all scheduled check-ins with Check-in/No Show options
  • Extend with Day Selection: Added extend button with modal for day selection
  • No Show Status: Added No Show status for guests who don't arrive
  • Updated Times: Maintained 2:00 PM check-in and 12:00 PM check-out
How to Test
Command Line
Get-Content config/update_checkin_extend.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
Testing Steps
  1. Run SQL: Execute the update_checkin_extend.sql file
  2. Check Dashboard: View the updated check-in and check-out sections
  3. Test Check-in: Try clicking Check-in or No Show buttons on Confirmed bookings
  4. Test Extend: Try clicking extend buttons on Checked-in bookings (select days)
  5. Verify Times: Confirm 2:00 PM check-in and 12:00 PM check-out times