Sustainability Information System

Project Description

Sustainability Information System is a web-based information system built on the Laravel 10 framework to support sustainability reporting and management in the AAB corporate environment. This system has two main interfaces: Frontend accessed by internal company users to input sustainability data per office/installation, and Backend/CMS used by administrators to manage report configuration, master data, users, and system content.

The business domains served include greenhouse gas emission reduction (GHG Reduction), renewable energy mix (Renewable Energy Mix), water withdrawal (Water Withdrawal), waste diversion (Waste Diverted), lost time injury rate (Lost Time Injury Rate), and community development through education, entrepreneurship, health, and environment pillars. The system supports multi-level organizational hierarchy from office/installation, region, division, to corporate level (consolidation).

Problems

Decentralized sustainability data across various offices/installations.
Complexity of multi-level approval flow (Branch Manager → VP → Director → President Director).
Need for complex consolidation calculations with specific formulas per indicator.
Limited real-time dashboard visibility for management.
Security and data integrity risks handling sensitive company data.
Dependency on manual processes and email for reminders and notifications.

Solutions Built

Sustainability Office Report module for data input per office/installation, and Sustainability Consolidation Report for corporate data aggregation.
Approval Configuration module with role-based approval and PIC Configuration per office/region.
Baseline Configuration, Threshold Configuration, Conversion Factor Configuration, and Index Configuration modules with automatic calculations on consolidation.
Sustainability Dashboard with progress charts, quick analysis, global performance, community development distribution map, and company overview demographics.
Implementation of XSS/HTML tags validation, file type upload validation, Audit Trail, Login History, Login Suspend, and penetration test remediation.
Scheduled Task / Reminder, Job Queue for email notification delivery via API/SMTP, and Email Tester.

Project Goals

Centralization of sustainability reporting from all AAB offices/installations.
Automation of calculations and consolidation to reduce manual errors.
Improved management visibility through interactive dashboard with chart visualizations, maps, and final report.
Strengthened security and compliance through penetration test remediation, input validation, role-based access control, and audit trail.
Approval and notification process efficiency through tiered approval system and automatic email notifications.

Tech Stack

Backend: Laravel 10, PHP 8.1, Inertia Laravel 0.6.9, Livewire, Laravel Sanctum 3.3, Laravel UI 4.4, Maatwebsite Excel 3.1, Intervention Image 2.7, Spatie Image Optimizer 1.7, Spatie Laravel Sluggable 3.4, Mews Captcha 3.3, Rackbeat UI Avatars 1.1
Frontend: React 18.2, Inertia.js React 1.0.11, Bootstrap 4.6, jQuery 3.7, Sass 1.56, Swiper 10.3, date-fns 2.30.
Database & DevOps: MySQL, Laravel File Storage, Vite 4.4.9, Laravel Vite Plugin 0.7.8, Grunt 1.6.1, Grunt SVGStore 2.0.0, Patch Package 8.0.0, Laravel Pint 1.0, PHPUnit 10.1, Laravel Debugbar 3.6, Snyk.

Timeline

Period: February 2024 – July 2025 (~1.5 years)
Phase: Setup & Foundation → Core Configuration → Reporting Engine → Consolidation & UAT → Security & Stabilization.

Architecture Notes

This system implements an internal CMS abstraction layer (app/Api/) that closely resembles WordPress architecture, complete with action/filter hook system (Eventy), facades, and custom service providers. This hybrid approach uses traditional Blade for most backend and some frontend, plus Inertia.js + React for certain pages.

Project Description

Related

Governance, Compliance & Legal Management System

Integrated Recruitment System (Web Career)

Product Catalog Management System