EEAD — Energy Efficiency Assessment & Database

About This Project

Built while at Procons Infotech for the Sustainable Energy Authority (SLSEA), EEAD is an enterprise-grade ERP and certification platform that handles product registrations, agency-driven testing workflows, payments (online and offline), rating generation, and public product discovery. Manufacturers (Damro, Singer, Abans, etc.) submit product applications which SLSEA routes to accredited test agencies based on product type and agency capabilities. Test agencies update safety and performance test results back into the system; products that pass safety testing proceed to energy performance testing which yields a 1–5 star efficiency rating. Each certified product receives a generated QR code and printable sticker/artwork reflecting its star rating so consumers can verify efficiency by scanning. The platform exposes APIs consumed by a WordPress marketing front-end (product listings, comparisons, reviews) and includes offline-capable features for field inspectors. Built with Laravel (API, services, background jobs) and React (admin & agency UIs), it uses AWS for hosting with load balancing, autoscaling, and resilient deployment patterns. The system follows SOLID principles, uses the Laravel ecosystem (Spatie roles & permissions, Media Library, AWS S3 for media, queues), and includes robust audit logs, role-based workflows, and secure payment integrations.

Key Features & Highlights

Multi-stage certification workflow

Product application → safety test → performance test → rating issuance with automated agency assignment and reassignment.

Agency integration & updates

Accredited test agencies receive assignments and push structured test results back to the ERP via secure APIs or signed uploads.

Online & offline payments

Supports gateways for online payments plus offline receipt/manual reconciliation for bank/cheque payments used by businesses.

QR code & dynamic rating stickers

Automated QR generation per certified product plus printable sticker art that reflects the star rating and links to verification pages.

Public discovery & WordPress integration

Product catalogs, comparisons and consumer reviews are published to a WordPress front-end via authenticated API syncs.

Role-based ERP with audit trails

Fine-grained roles for SLSEA admins, agency testers, manufacturer users and field inspectors with immutable audit logs for compliance.

AWS resilient deployment

Load balancers, autoscaling groups, S3 for media, RDS for relational data, and background workers for heavy processing and reports.

Offline-capable field workflows

Field inspector UIs that can cache data offline and sync when connectivity is restored.