Society Maintenance Tracker is a full-stack residential society maintenance management platform built with Next.js and PostgreSQL. It streamlines complaint tracking, community notices, and administrative governance for residential communities.
Key Highlights & Features
- Role-Based Workflows & Authentication: Engineered 2 distinct role-based workflows (Residents and Administrators) with secure JWT authentication, session handling, and RESTful API endpoints.
- Transactional Complaint Lifecycle: Implemented a comprehensive complaint state machine spanning 3 statuses (Open, In Progress, Resolved) and 3 priority levels (Low, Medium, High).
- Audit History & Consistency: Records 100% of status transitions with timestamped audit history and transaction guarantees using Prisma transactions.
- Overdue Detection & Analytics: Dynamic overdue detection algorithm alongside an administrative analytics dashboard providing real-time breakdowns of complaints by category, status, and resolution time.
- Media & Notifications: Integrated Cloudinary for resident photo uploads and automated email notifications for status updates via Maileroo.
Tech Stack
- Frontend: Next.js, React, Tailwind CSS, TypeScript
- Backend: Next.js API Routes, Prisma ORM, PostgreSQL
- Media & Communication: Cloudinary, Maileroo