Overview

A field system for the Egyptian Red Crescent's community health programme. Health pioneers, each attached to a health unit, register the refugee families in their care, visit them every month and record what was discussed and where the family was referred. The same record is then seen at three levels: the pioneer sees her own families, a supervisor sees every pioneer in his directorate, and headquarters sees the whole country. The interface is Arabic and right-to-left, with an English translation alongside. Everything shown in the demo video and the screenshots is invented data in a separate demo database. No real family, pioneer or staff member appears.

Key Features

• Family register: Each family is registered once, with its members, nationality, registration status with the refugee agency, and the support it receives. Members carry their relationship, age, education, work and health status.
• Monthly visits: One form per visit covers the kind of visit, the ten health messages a pioneer can give (from pregnancy care to vaccinations), a referral to child care, mother care, family planning or dental services, and whether the family needs psychological support.
• Referral follow-through: Each visit asks whether the family was referred last time and whether it went. The family list shows, per family, how often it was referred, how often it went and how often it did not.
• Three levels of access: A role's reach is geographic: the whole country, one directorate, or a single health unit. The scoping is applied in the data layer, so every list, count and chart respects it.
• National dashboard: Totals for families, members and pioneers, a breakdown of referrals by service, an interactive map of all 27 governorates with each one's counts, and a Pareto chart of the governorates carrying most of the families.
• Meetings and attendance: Supervisors record meetings and trainings with a report, and attendance can be imported from an Excel sheet built from a downloadable template.
• Pioneer management: A pioneer can be suspended with a recorded reason or moved between health units with a log of the move, and her families are transferred to a colleague before she is removed.
• Reminders: Pioneers are notified ahead of a scheduled visit, in their own language.

Tech Stack

Laravel 10 on PHP 8.2 with MySQL. The interface is server-rendered Blade on Bootstrap 5 with full RTL support and server-side DataTables for every list, with CSV and Excel export. The dashboard uses Leaflet for the map, amCharts for the Pareto chart and Chart.js for the referral breakdown. Spatie Permission handles roles, with pages, routes and permissions stored as rows in the database, and Spatie Activitylog records changes to families and visits.

My Role & Impact

I worked on the backend as part of a small team. I built the dashboard for all three roles: the statistics widgets and their shared filters, the pioneers table with search and sort, the interactive map of the governorates and the Pareto chart. I also built the meetings module with its Excel attendance import, the pioneer log, the visit reminder notifications in two languages, and the rule that a pioneer's families are transferred before she is deleted. Later I replaced cached lookups with paginated database queries on the family, visit and meeting pages, so lists stay fast as the data grows. The demo video above was recorded straight from the running app with a Playwright and Remotion pipeline, against a database of invented families built for the purpose.