// government records · Secretaria do Bem Estar Social
Projeto Social Futura
A PHP/MySQL records system built for Joinville City Hall's Department of Social Welfare, replacing paper family registries with searchable households, benefit tracking, and audit-ready printed reports.
HTML5
CSS3
PHP4.3.4
MySQL4.1.02005
Screenshots
Overview
SBES (Secretaria do Bem Estar Social) is a records and case-management system built for the city of Joinville's Department of Social Welfare. Internally branded "Projeto Social Futura — Gestão Social," it replaced a paper-based filing process for tracking families enrolled in municipal social assistance programs.
The system centers on two core records: the Domicílio (household) and the Pessoa (person), each tied to a physical address and socioeconomic profile. From there, caseworkers enroll a household in one or more Programas Sociais (social programs — food assistance, gas vouchers, etc.), log Benefícios (benefit disbursements) against that enrollment, and keep a running Histórico (case history) for each family.
Access is split across four roles — Operador, Assistente Social, Secretário, and Administrador — each surfaced as its own tab on the home dashboard, so a front-line caseworker and the department secretary see only the actions relevant to their job. Two printable reports close the loop with the city's audit requirements: a Ficha de Usuário (per-family case file) and a Recebimento de Benefício (proof-of-benefit receipt), both rendered as print-ready HTML directly from the database.
Built in PHP 4 against a MySQL backend, the system was developed and deployed for Joinville's City Hall in 2005. This repository preserves a wget-crawled archive of the live application (rip/) alongside the original PHP source (www/) and database schema (db/sbes.sql).
Highlights
Searchable digital registry
a digital household-and-person database replacing paper-based family registries, cutting the time caseworkers spent locating a family's history from manual filing to a single search
Role-based staff workflow
tiered access (Operador, Assistente Social, Secretário, Administrador) so each level of City Hall staff saw only the actions relevant to their job, reducing training overhead and data-entry errors
Print-ready audit reports
per-family case files and proof-of-benefit receipts generated straight from the database, giving the department auditable records without manual transcription