Case Study
EcoOps Dashboard
C&D Recycling Facility Operations Management System transforming manual Excel workflows into a scalable web platform.
Problem
Recycling facility operations relied entirely on manual Excel-based workflows. Daily production metrics, material dispatches, equipment utilization, and manpower attendance were tracked across disconnected spreadsheets with no centralized visibility, audit trail, or role-based access control.
Scope
Build a modular operations management platform digitizing the complete C&D recycling workflow. Core modules: Production, Dispatch, Received Materials, Equipment Utilization, Manpower Attendance, and automated Inventory calculations. Foundational modules: dynamic Site Management and three-tier RBAC User Management.
Architecture
Next.js 16 App Router with Hono RPC endpoints replacing traditional REST. React Query for client-side state with automatic cache invalidation. Better Auth for session-based authentication with module permissions, operation permissions, and user-specific overrides. Prisma ORM with PostgreSQL. Background job processing for bulk imports and multi-format exports.
Module Relationships
Results
Real-time operational visibility across all facility metrics. Dual data entry supporting web forms and bulk CSV/Excel import. Automated inventory calculations eliminating reconciliation errors. Complete audit trail for regulatory compliance. Role-based access control with site-level granularity.