Overview
Industrial engineering and telecommunications contracting require managing complex multi-month deployments: Factory Acceptance Testing (FAT), Site Acceptance Testing (SAT), cable schedules, PAGA acoustic commissioning, and rigorous client approvals.
The Enterprise Tracking System (WebTracking) is a centralized management portal engineered to streamline technical workflows, track milestones across multiple ongoing projects, and automate the tedious generation of formal Word and Excel inspection certificates.
Core Features & Architecture
1. Modern Web Tech Stack
- Framework: Next.js 16 with React 19 and App Router, utilizing Server Actions and React Server Components for ultra-fast page rendering.
- Styling: Tailwind CSS v4 featuring modern glassmorphism panels, dark mode, and responsive data grids.
- Data Persistence: Prisma ORM with SQLite / PostgreSQL, supporting normalized relational schemas for Projects, Milestones, Tasks, Personnel, Documents, and Activity Audit Logs.
2. Automated Technical Document Generation
- Integrated Docxtemplater and ExcelJS engines to generate standardized engineering handoff dossiers (
PAGA_COMMISSIONING_PROCEDURE.docx, Inspection Acceptance Sheets, Equipment Tag Lists) dynamically populated with real database records. - Eliminates human transcription errors during tight FAT/SAT handover deadlines.
3. Interactive Analytics & Notification Engine
- Visual Analytics: Interactive timeline charts and completion burn-down widgets built with Recharts.
- Automated Alerts: Email notifications and milestone reminder dispatchers configured via Nodemailer.
- Document Management: File storage repository with version history tracking for technical drawings and contract specs.
Results & Efficiency
The system drastically reduces administrative overhead for project engineers, providing project managers and field technicians with a single source of truth for all milestone progress and engineering deliverables.