How fenrir315/barangayconnect-system-roadmap-planning works
BarangayConnect is a barangay operations and resident-services platform. Residents and staff use separate portals to manage records and submit requests; staff process documents through approval and release, while appointments, complaints, and incidents have their own status workflows. The app also provides announcements, payments, reporting, audit trails, and public certificate verification. The sampled API shows a local PostgreSQL query gateway that authorizes and executes writes, then dispatches notifications and queued email. Several portal implementations were not sampled, so their data wiring is shown only where documented or explicit in the API.
Main entry points: route.ts Query API · resident Resident portal · admin Admin portal · route.tsx Certificate printing
Components 26
Portals and access
- Resident portal
src/app/resident - Admin portal
src/app/admin - Login page
src/app/(auth)/login/page.tsx - Auth context
src/hooks/useAuth.tsx
Barangay operations
- Residents and households
src/app/admin/residents - Document workflow
src/app/admin/documents - Appointments
src/app/admin/appointments - Complaints
src/app/admin/complaints - Incident tracking
src/app/admin/incidents - Announcements
src/app/admin/announcements - Payments
src/app/admin/payments - Reports and exports
src/app/admin/reports - Certificate verification
src/app/verify/[certificateNumber]/page.tsx
Platform services
- Local auth API
src/app/api/local/auth/route.ts - Role routing
src/proxy.ts - Query API
src/app/api/local/db/route.ts - SQL execution
src/lib/local/sql.ts - Query authorization
src/lib/local/dbacl.ts - Write notifications
src/lib/notify.ts - Email queue
src/lib/mail.ts - Certificate printing
src/app/api/documents/[id]/print/route.tsx - File endpoints
src/app/api/local/files/route.ts
Persistence and integrations
- PostgreSQL
Other components
- Resident
- Barangay staff
- Public visitor
Connections 25
- Resident → Resident portal: uses
- Barangay staff → Admin portal: uses
- Resident portal → Login page: signs in
- Admin portal → Login page: signs in
- Login page → Local auth API: authenticates
- Auth context → Local auth API: checks session
- Local auth API → PostgreSQL: reads and writes
- Role routing → Auth context: checks role
- Resident portal → Query API: queries records
- Admin portal → Query API: manages records
- Query API → Query authorization: authorizes query
- Query API → SQL execution: executes query
- SQL execution → PostgreSQL: reads and writes
- Query API → Write notifications: dispatches writes
- Query API → Email queue: drains queue
- Write notifications → PostgreSQL: writes notifications
- Email queue → PostgreSQL: reads pending mail
- Document workflow → Certificate printing: requests PDF
- Certificate printing → PostgreSQL: reads certificate data
- Certificate printing → Certificate verification: provides certificate number
- Public visitor → Certificate verification: checks certificate
- Resident portal → File endpoints: uploads evidence
- Admin portal → File endpoints: uploads attachments
- File endpoints → PostgreSQL: writes audit records
- Reports and exports → Query API: reads report data