tugbadogan/hotelmanagement ? reverse-engineered prompt

Build me a hotel management web app for staff to handle the day to day front desk work in one place. I want a clean admin style interface where they can log in, manage rooms, add and edit guest details, create reservations, mark check in and check out, and see what rooms are available at a glance. It should use a MySQL database and work as a PHP web app, and if you need to look up anything current while building it, go ahead and check the docs online.

Please include the basic screens a hotel team would expect, like a dashboard, room list, booking flow, guest records, and simple reports or summaries. Make it feel practical and easy to use, with forms, tables, and a few helpful status indicators. I also want the database setup included so it can be run locally and tested right away.