FixIIT is an intelligent campus maintenance management system that automates issue categorization, worker assignment, and email notifications using Google Gemini AI. The platform helps students report maintenance issues while enabling maintenance staff to efficiently manage and resolve them.
- 🤖 AI-powered issue categorization using Google Gemini 3.5 Flash
- ⚡ Automatic urgency detection (1–5)
- 👨🔧 Smart worker assignment based on skills, workload, and availability
- 📧 Automatic email notifications to assigned workers
- 📊 Interactive dashboard with maintenance statistics
- 🗂 Issue tracking and status management
- 🏢 Department-based worker organization
- 🗄 Supabase PostgreSQL backend
- 🎯 Responsive web interface
Student submits maintenance issue
│
▼
Node.js + Express API receives request
│
▼
Google Gemini 3.5 Flash analyzes issue
│
├── Category
├── Urgency
├── Summary
└── Reasoning
│
▼
Search best available worker
(Based on skills, workload & availability)
│
▼
Supabase Stored Procedure
│
├── Create issue
├── Assign worker
├── Update workload
└── Save assignment history
│
▼
Email notification sent to assigned worker
│
▼
Dashboard updates with latest issue
- HTML5
- CSS3
- JavaScript
- Node.js
- Express.js
- Supabase PostgreSQL
- Google Gemini 3.5 Flash
- Nodemailer
fixiit/
│
├── backend/
│ ├── server.js
│ ├── db.js
│ ├── schema.sql
│ ├── package.json
│ ├── .env.example
│ └── services/
│ ├── aiService.js
│ ├── workerService.js
│ └── notificationService.js
│
├── frontend/
│ └── public/
│ ├── index.html
│ ├── css/
│ ├── js/
│ └── assets/
│
├── README.md
└── .gitignore
git clone https://github.com/<your-username>/FixIIT.git
cd FixIIT/backendnpm installCreate a project on Supabase
Run
backend/schema.sql
inside the SQL Editor.
Copy
- SUPABASE_URL
- SUPABASE_SERVICE_KEY
Generate an API key from Google AI Studio
Add
GEMINI_API_KEY
to your .env file.
Using Gmail App Password:
EMAIL_HOST=smtp.gmail.com
EMAIL_PORT=587
EMAIL_USER=your_email@gmail.com
EMAIL_PASS=your_app_password
EMAIL_FROM=your_email@gmail.com
SUPABASE_URL=
SUPABASE_SERVICE_KEY=
GEMINI_API_KEY=
EMAIL_HOST=
EMAIL_PORT=
EMAIL_USER=
EMAIL_PASS=
EMAIL_FROM=
PORT=3000
NODE_ENV=development
npm run devOpen
http://localhost:3000
| Method | Endpoint | Description |
|---|---|---|
| GET | /api/health |
Health check |
| POST | /api/students |
Register student |
| POST | /api/issues |
Submit issue |
| GET | /api/issues |
List issues |
| GET | /api/issues/:id |
Get issue |
| PATCH | /api/issues/:id/status |
Update issue status |
| GET | /api/workers |
List workers |
| POST | /api/workers |
Add worker |
| PATCH | /api/workers/:id/status |
Update worker availability |
| GET | /api/stats |
Dashboard statistics |
| Table | Description |
|---|---|
| departments | Department information |
| workers | Worker details |
| students | Student information |
| issues | Maintenance issues |
| assignments | Assignment history |
| notifications | Email notification logs |
- Authentication & Authorization
- Student login portal
- Admin dashboard
- Real-time updates using Supabase Realtime
- Worker mobile application
- Issue analytics dashboard
- File/image upload support
- Push notifications
- SLA monitoring
Kushal Kumar
B.Tech Computer Science
Indian Institute of Technology Gandhinagar
GitHub: https://github.com/kus-coded
This project is developed for educational purposes.



