ViVan2706/Municipal_Complaint_System — reverse-engineered prompt

Build me a simple municipal complaint tracking website for a local city office. It should let citizens sign up, log in, submit civic complaints, see their complaint history, and track whether each complaint is pending, in progress, resolved, or rejected.

There should also be an admin area where staff can view all complaints, set severity, assign or reassign complaints to workers, and manage complaint progress. Workers should have their own login where they can see only the complaints assigned to them and mark work as completed or resolved.

Please include a basic notification system so citizens, admins, and workers get updates when complaints are submitted, assigned, reassigned, removed, or resolved. Unread notifications should show a count and be markable as read.

Use PHP, MySQL, HTML, and CSS, with session based login and a clean simple interface. Include the database tables and setup script so it can run locally with XAMPP.