How ortizrattanuel0601-coder/hotel-management-system-dbms-final-project---group-5-section-d works
Lumière is a hotel-operations web application: staff and guests use browser pages that call an Express REST API, which applies resource logic and persists hotel data in MySQL. The principal booking flow validates a reservation request, finds a matching available room, saves guest/reservation/room assignment, and returns the booking result. Other documented branches cover room records, service orders, invoicing, maintenance, reviews, and JOIN reports. Edges follow explicit README statements, indexed imports, or shown calls; some documented subsystems are represented at directory level because their implementation excerpts were not sampled.
Main entry points: db.js MySQL pool · reservationModel.js Reservation and booking · reservationController.js Reservation handler · serviceController.js Hotel services
Components 19
Web interface
- Hotel pages
public
API and operations
- Express server
server.js - Resource routes
routes
Data access
- MySQL pool
models/db.js - Hotel database
Hotel workflows
- Reservation handler
controllers/reservationController.js - Reservation and booking
models/reservationModel.js - Guest resources
controllers/guestController.js - Room resources
controllers/roomController.js - Housekeeping
controllers/housekeepingController.js - Employee management
controllers/employeeController.js - Hotel services
controllers/serviceController.js - Service orders
controllers/serviceOrderController.js - Room records
controllers/recordController.js - Invoices and billing
controllers/invoiceController.js - Maintenance requests
controllers/maintenanceController.js - Guest reviews
controllers/reviewController.js - JOIN reports
controllers/reportController.js
Other components
- Guest or staff
Connections 28
- Guest or staff → Hotel pages: uses
README.md - Hotel pages → Express server: requests
README.md - Express server → Resource routes: mounts
server.js - Resource routes → Reservation handler: dispatches
routes/reservationRoutes.js - Reservation handler → Reservation and booking: calls
controllers/reservationController.js - Reservation handler → MySQL pool: queries
controllers/reservationController.js - Reservation and booking → MySQL pool: queries
models/reservationModel.js - MySQL pool → Hotel database: connects
models/db.js - Reservation and booking → Room resources: checks availability
models/reservationModel.js - Guest or staff → Guest resources: manages guests
README.md - Guest or staff → Room resources: manages rooms
README.md - Guest or staff → Housekeeping: manages tasks
README.md - Guest or staff → Employee management: manages employees
README.md - Guest or staff → Hotel services: browses services
README.md - Guest or staff → Service orders: places orders
README.md - Guest or staff → Room records: views occupancy
README.md - Guest or staff → Invoices and billing: handles billing
README.md - Guest or staff → Maintenance requests: manages requests
README.md - Guest or staff → Guest reviews: submits reviews
README.md - Guest or staff → JOIN reports: views reports
README.md - Hotel services → MySQL pool: queries
- Service orders → MySQL pool: queries
- Reservation and booking → Hotel services: reads service totals
models/reservationModel.js - Invoices and billing → MySQL pool: queries
- Maintenance requests → MySQL pool: queries
- Room records → MySQL pool: queries
- Guest reviews → MySQL pool: queries
- JOIN reports → MySQL pool: queries