MIC Management System
A Municipal Inspection and Compliance management system for tracking field inspections, recording violations, managing corrective actions, and generating compliance reports.
Features
- Inspection scheduling and mobile-friendly field data entry
- Violation recording with photographic evidence and severity classification
- Corrective action tracking with deadline management
- Bulk and single exports of inspection kits with pre-filled details in Word and Excel format
- Custom calendar for yearly, monthly, and weekly inspection schedules overview
- PDF report generation for compliance submissions
- Automated notifications for inspection deadlines and violations
- Role-based access control for different user types
- Structured logging with Pino for operational observability
Tech Stack
ReactViteTypeScriptNode.jsExpressMSSQLMongoDBPrismaAnt DesignTailwindJSPdfNodeMailerPinoZodXlsxDocxDockerPortainer
Key Insights
- Migration from .NET to React/Node resulted in $20k/year savings in support costs
- Using Prisma with MSSQL for structured compliance data and MongoDB for unstructured inspection notes kept each store optimised for its access pattern
- JSPdf allowed generating formatted compliance reports entirely on the server without a headless browser dependency
- Pino structured logging made filtering and aggregating operational events straightforward in production