Complaint System 24x7

A command-line based Complaint Management System built with Python and MySQL. This was my Class 12th Computer Science project, demonstrating core programming principles and database management.

---

Key Features

• Multi-User Role System: Separate interfaces and functionalities for Admin, Manager, Worker, and User roles.
• Complaint Lifecycle Management: Users can submit complaints, which managers can assign to workers. Workers can then update the status to 'In Progress' or 'Completed'.
• Database Integration: Fully integrated with a MySQL backend to handle all data related to users, services, and complaints.
• History & Tracking: All actions are logged, and users can view the history of their complaints.

Tech Stack

• Frontend: Python (Command-Line Interface)
• Backend: MySQL Database

Full Documentation

For a complete overview of the project, including database structure, full source code analysis, and screenshots, please see the full project report here.

---

How to Run Locally

1. Ensure you have Python and a local MySQL server installed.
2. Clone the repository.
3. Create a new database in MySQL named complaint_system_24x7.
4. Run the main Python script. The script will automatically create the necessary tables and seed them with initial data.