🏫 CampusResolve

Anonymous Smart Grievance Tracking System

Demo Video Link: https://www.youtube.com/watch?v=fFNg0Zc-VLA

A transparency and trust-building digital grievance ecosystem for educational institutions.

---

🚀 Quick Start

# 1. Install dependencies
pip install -r requirements.txt

# 2. Run the server
uvicorn app.main:app --reload

# 3. Open browser
# → http://localhost:8000

---

🔐 Admin Access

• URL: http://localhost:8000/admin/login
• Username: admin
• Password: admin123

⚠️ Change credentials in app/utils.py before production deployment.

---

📁 Project Structure

grievance-tracker/
├── app/
│   ├── main.py         # FastAPI app, page routes, startup
│   ├── models.py       # SQLAlchemy ORM models
│   ├── database.py     # SQLite engine & session
│   ├── routes.py       # All API endpoints
│   ├── schemas.py      # Pydantic validation schemas
│   └── utils.py        # Priority detection, password hashing
├── templates/
│   ├── index.html      # Landing page
│   ├── submit.html     # Submit grievance form
│   ├── track.html      # Track by ID
│   ├── admin_login.html
│   └── dashboard.html  # Full admin dashboard
├── static/
│   └── uploads/        # Uploaded files (auto-created)
├── requirements.txt
└── README.md

---

🧠 Smart Features

Feature	Description
Auto Priority Detection	Keywords like "harassment", "ragging", "unsafe" → HIGH priority
Sensitive Flag	Student-marked sensitive → immediate HIGH priority
Auto Escalation	No update in 5 days → status becomes "Escalated"
Unique Tracking IDs	Format: GRV-2026-XXXXX
Analytics Charts	Category doughnut + status bar charts

---

🚦 Status Flow

Submitted → Under Review → Assigned → In Progress → Resolved

Also: Rejected, Escalated

---

🔒 Security

• Passlib bcrypt password hashing
• SQLAlchemy ORM (prevents SQL injection)
• File upload validation (type + 5MB limit)
• Session-based admin auth (client-side guard + server-side verification)

---

📊 API Endpoints

Method	Path	Description
POST	/api/submit	Submit a grievance
GET	/api/track/{id}	Track by tracking ID
POST	/api/admin/login	Admin authentication
GET	/api/admin/grievances	List grievances (with filters)
PUT	/api/admin/grievances/{id}	Update status/comment
GET	/api/admin/analytics	Dashboard analytics data

Full docs: http://localhost:8000/api/docs

---

🏆 Hackathon Pitch

Problem: Students fear retaliation. Colleges lack transparent grievance systems.

Solution: CampusResolve provides:

• ✅ Anonymous submission (email optional, IP not logged)
• ✅ Unique tracking ID for transparency
• ✅ Smart AI keyword-based priority detection
• ✅ Auto-escalation for stale complaints
• ✅ Professional admin dashboard with analytics
• ✅ Zero-setup SQLite database

Impact: Builds trust, ensures accountability, and empowers student voices.

---

Built with FastAPI + SQLite + Tailwind CSS