Skip to content
Marlo Barua
All work

DSWD Records Dashboard

2023 · Team lead · Full-stack (internship)

A records-management and analytics dashboard built for five divisions of the Department of Social Welfare and Development.

Laravel 8, Sanctum, Vue 3, RBAC, Vercel

  • 5 divisions
  • Role-based access
  • Version history
  • Excel export

Problem

Five divisions needed one place to manage their records and see summary figures, with access limited by role and a history of changes.

Approach

  • Laravel 8 REST API with Sanctum authentication and role-based access control
  • Soft-delete archival and version history for records
  • Aggregation endpoints consumed by a Vue 3 SPA with Excel export, deployed to Vercel

API and access control

I led a small team through the internship and managed the team GitHub repository. The backend is a Laravel 8 REST API using Sanctum for authentication and role-based access control.

Archival and version history

  • Soft-delete archival, so removed records can be recovered
  • Version history that keeps earlier states of a record

Analytics and export

Aggregation endpoints feed a Vue 3 single-page app. Users can export the results to Excel, and the front end is deployed to Vercel.

  1. Vue 3 SPA
  2. Laravel 8 API (Sanctum, RBAC)
  3. Aggregation endpoints
  4. Excel export

Outcome

Staff in the five divisions could manage records, review change history and export figures to Excel from one dashboard.