Complaint System

The Complaint System allows citizens to report civic issues (e.g., potholes, waste, lights), track their progress, and enables admins and solvers to resolve them efficiently.

---

✅ Core Flow

1. Citizen submits a complaint with:
2. Title and description
3. Location (lat/long or address)
4. Media (images/videos)

5. Category (e.g., Roads, Water, Health)

6. Admin reviews and verifies:

7. Ensures complaint is valid (not spam or duplicate)

8. Assigns it to a solver based on location/category

9. Solver receives the task:

10. Views complaint details
11. Marks progress (in-progress, resolved)

12. Optionally uploads before/after images or comments

13. Citizen gets updates and can rate the resolution.

---

🧩 Core Tables

• complaints
• complaint_media
• complaint_assignments
• complaint_status_logs
• complaint_feedback

---

🧭 Status Lifecycle

```text Submitted → Verified → Assigned → In Progress → Resolved → Closed