Core System
Authentication, Equipment & Station Management
Authentication & Access Control
✓JWT-based login with email & password, cookie + localStorage dual-token for PWA compatibility
✓QR scan redirect — technicians scan a QR code, are sent to login, and returned directly to the equipment page after signing in
✓Signup / request access flow with admin approval step
✓First-time admin setup page for fresh deployments
✓7 role levels with route-level protection throughout the app:
Admin
Technician
Supervisor
OCC Operator
Station Incharge
Management
Director
Stations & Lines
✓Create and manage metro lines with name, code and colour
✓Create and manage stations linked to lines, with station code (e.g., HGJ, LKO)
✓Latitude/longitude fields for future map integration
Equipment Management
✓Full CRUD for Lifts and Escalators with human-readable equipment IDs (e.g., LKO-HGJ-L01)
✓Equipment fields: name, type, make, model, installation date, vendor name, vendor contact, vendor email
✓CAMC expiry and warranty expiry dates tracked per equipment
✓Status tracking: Running / Faulty / Under Maintenance / Out of Service
✓Bulk filters: station, type, status, text search
Core System
Fault / Breakdown Management
Fault Logging & Lifecycle
✓4-level fault taxonomy: System → Sub-System → Equipment → Sub-Equipment (same taxonomy used in Indian metro L&E CMRS)
✓Fault fields: fault code, description, severity (Low / Medium / High / Critical), passenger impact flag
✓Full lifecycle: Open → Acknowledged → In Progress → Resolved / Closed
✓Cause of failure, corrective action, preventive action, and action plan fields
✓Technician assignment, attended-at timestamp, and resolution timestamp
✓Repeat fault detection — flags if the same equipment has seen a similar fault before
✓SLA breach auto-detection on fault update (response SLA & restore SLA)
✓Recommendation engine — suggests corrective and preventive actions based on fault history
Breakdown Analysis
✓Station-level KPIs with fault trend charts
✓Equipment reliability metrics and SLA compliance rates
✓Filterable by station, date range, equipment type, severity, status
Core System
Preventive Maintenance (PM)
✓PM checklists per equipment — schedule and log maintenance tasks
✓PM completion score tracking per technician and per equipment
✓Full maintenance history log per equipment
✓PM due today dashboard widget — shows overdue and upcoming PM tasks
Core System
Engineering Reports
13-Column CMRS Report Format
The report structure exactly matches the format used in Indian metro CMRS systems:
| # | Column | Format / Notes |
|---|---|---|
| 1 | Date / Time | DD-MM-YYYY HH:MM:SS |
| 2 | System | e.g., A. DOOR |
| 3 | Subsystem | e.g., A1. CAR DOOR |
| 4 | Equipment | e.g., A1.1. SKATE |
| 5 | Sub Equipment | e.g., A1.1.1. GUIDE SHOE |
| 6 | Equipment ID | e.g., LKO-HGJ-L01 |
| 7 | Fault Code | e.g., E-201 |
| 8 | Fault Description | Free text |
| 9 | Cause of Failure | Free text |
| 10 | Prompt Corrective Action Taken | Free text |
| 11 | Preventive Action | Free text |
| 12 | Action Plan | Free text |
| 13 | Downtime | "Xh Ym" for closed faults · "Ongoing" for open faults |
Export Formats
✓CSV — all 13 columns, UTF-8, directly importable
✓Excel (.xlsx) — formatted headers, auto column widths, bold header row
✓PDF — landscape orientation, auto-column widths, table with borders
✓Filters before export: date range, station, equipment type, severity, status
Phase 2
Performance Analytics
Technician Performance Analytics
✓Per-technician metrics: total faults, closed faults, open faults, repeat faults
✓Avg Response Time — fault raised to technician attending (minutes)
✓Avg MTTR — Mean Time To Repair (mean downtime in minutes)
✓SLA Compliance Rate — % of faults restored before the SLA restore deadline
✓First Time Fix Rate — closed non-repeat faults as a % of all closed faults
✓PM Rate and average PM score per technician
✓Weighted Performance Score: SLA 40% + First Fix 25% + PM 20% + Response 15%
✓Sortable 12-column table, colour-coded metric badges, search by name or station, CSV export
✓Visible to: Admin, Management, Director, Supervisor
Vendor Performance Analytics
✓Per-vendor metrics: total equipment supplied, fault rate, avg downtime, repeat fault rate, SLA breach rate
✓CAMC Coverage — % of vendor's equipment with an active CAMC contract
✓Reliability Score (0–100) computed from fault rate, repeat rate, SLA breach rate, faulty ratio, CAMC coverage
✓Reliability badge: Reliable (≥70) / Average (40–69) / Poor (<40)
✓CAMC status breakdown per vendor row, CSV export
✓Visible to: Admin, Management, Director
Phase 3
Operations & Contract Management
Spare Parts Inventory
✓Part fields: part number, name, category, unit, unit cost, current stock, min stock, max stock, supplier, location
✓Auto stock status: OK / LOW / Out of Stock / Overstocked based on configurable min/max levels
✓KPI cards: Total Parts, Low Stock count, Out of Stock count, Total Inventory Value (₹)
✓Visual stock level bar per part, category filter, supplier search
✓Usage tracking — parts linked to fault/maintenance records
CAMC / AMC Contract Manager
✓Tracks CAMC and warranty expiry for every equipment
✓Contract status: Active / Expiring <90 days / Expiring <30 days / Expired / No Contract
✓Days-remaining countdown per equipment on the contract table
✓Red warning banner auto-appears when expired or near-expiry contracts exist
✓KPI strip: CAMC Active, Expiring <30d, Expiring <90d, Expired, No CAMC — at a glance
✓Colour-coded rows (red border for critical, amber for warning), CSV export
SLA Penalty Engine
✓Configurable penalty rules per severity, breach type and equipment type
✓Penalty formula: Per-Breach Amount + (Per-Minute Rate × Minutes Overdue), capped by Max Penalty
✓Penalty auto-calculated whenever an SLA breach is detected
✓Monthly penalty report: total penalty, breakdown by breach type & severity, full log table with CSV export
✓Year / month filter, monthly trend grid, per-fault penalty audit trail
Phase 4
QR Code Based Equipment Access
QR Code Generation (Admin)
✓Every equipment gets a unique QR code — no extra software required, no app store needed
✓Admin QR Manager grid: browse all equipment as cards with live QR images
✓Filter by station, equipment type, or text search across equipment IDs and names
✓Download PNG — high-resolution 400×400 QR image download per equipment
✓Copy URL — one-click copy of the scan URL to clipboard
✓Print All — browser print with clean 4-column layout, hides nav/sidebar automatically
Scan Landing Page (Public)
✓Scan URL:
app.metrorailguru.in/scan/LKO-HGJ-L01 — no login needed to view✓Always visible: equipment name, ID, type, live status badge, station, line, make, model, vendor, last maintenance date, CAMC expiry
✓Active fault alert banner — shows up to 5 current open faults with severity badges
✓Stats strip: Total Faults · Active Faults · Maintenance Logs
✓Not logged in: shows "Login to Report Fault" button — after login user is returned directly to the same equipment page
✓Logged in: inline fault report form (description, severity, passenger impact) → submits directly to the fault system
✓Quick-access buttons: View All Faults, PM Checklists & Maintenance History
✓Mobile-optimised layout — works on any smartphone browser
Platform
Dashboard, Alerts & Audit
✓Live Dashboard — KPI cards (active equipment, open faults, PM due today, stations), recent fault feed, SLA breach alerts
✓Configurable Alerts — alert rules and notification feed for SLA breaches, faults and contract expiry warnings
✓Audit Log — full system-wide action trail: user, role, timestamp, action type — filtered and paginated
✓PWA support — install to home screen on any phone or desktop, works like a native app without app store
✓Tech stack: Next.js 14, PostgreSQL, Prisma ORM — hosted on Railway, database on Supabase
Ready to try it?
The app is live and free to explore. Log in with the demo credentials or request a walkthrough.