maddherlarupapriya-oss/DBMS-2.0 — reverse-engineered prompt

Build me a simple hotel booking web app with one login page for both regular users and admins. After login, normal users should be taken to a rooms page where they can see available rooms with the current price, book a room by choosing check in and check out dates, view their own bookings, mark a booking as paid, and cancel their own bookings.

Admins should land on a dashboard that shows key stats like total rooms, booked rooms, occupancy, bookings today, revenue collected and pending, plus a few charts and recent booking activity. I also want admin pages to manage all bookings, rooms, room types, users, and a pricing history log. Admins should be able to cancel bookings, mark payments paid or refunded, change room prices, set rooms to maintenance, add or delete rooms, add room types, add or disable users, and reset passwords.

Please keep the room pricing dynamic and handled in the database logic, not in Python, and make the app read available rooms from a database view. Use the sample login accounts from the README, and check current docs online if needed.