How tyronnejohn/lgu-donsol works
LGU Donsol is a municipal project-monitoring system with a public transparency portal and a role-based staff portal. The workflow spans MPDC project entry, Engineering review and site monitoring, BAC procurement, and public publication; administrators manage staff, offices, and audit records, while staff can message across roles. Shared Supabase access backs the portals, and image-analysis Edge Functions support project and site-photo workflows. Some domain pages and database wiring were not excerpted, so those relationships are shown only where the route table, SOURCE INDEX, or README supports them.
Main entry points: AppRoutes.jsx Role-based routes · ProjectReviewDetail.jsx Engineering review · AuthContext.jsx Staff authentication · migrations Supabase database
Components 23
Portals and access
- Public portal
frontend/apps/public/src/App.jsx - Public home
frontend/apps/public/src/pages/PublicHome.jsx - Public projects
frontend/apps/public/src/pages/PublicProjects.jsx - Staff portal
frontend/apps/staff/src/App.jsx - Staff authentication
frontend/apps/staff/src/contexts/AuthContext.jsx - Auth hook
frontend/apps/staff/src/hooks/useAuth.js - Role-based routes
frontend/apps/staff/src/routes/AppRoutes.jsx
Project lifecycle
- MPDC projects
frontend/apps/staff/src/pages/mpdc/ProjectForm.jsx - Engineering review
frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx - Site monitoring
frontend/apps/staff/src/pages/engineering/ProjectMonitoringDetail.jsx
Operations and oversight
- Admin projects
frontend/apps/staff/src/pages/admin/AdminProjectDetail.jsx - BAC procurement
frontend/apps/staff/src/pages/bac/BacProcurementDetail.jsx - Staff messaging
frontend/apps/staff/src/pages/shared/Messaging.jsx - Staff accounts
frontend/apps/staff/src/pages/admin/StaffAccounts.jsx - Audit log
frontend/apps/staff/src/pages/admin/AuditLog.jsx
Shared capabilities
- Project map
frontend/shared/src/components/ProjectMap.jsx - Decision support
frontend/shared/src/utils/decisionSupport.js - Form drafts
frontend/apps/staff/src/hooks/useFormDraft.js
Supabase services
- Supabase client
frontend/shared/src/lib/supabaseClient.js - Project image analysis
backend/supabase/functions/analyze-project-image/index.ts - Site photo analysis
backend/supabase/functions/analyze-site-photo/index.ts - Staff account function
backend/supabase/functions/create-staff-account/index.ts - Supabase database
backend/supabase/migrations
Connections 23
- Public portal → Public home: routes to
frontend/apps/public/src/App.jsx - Public portal → Public projects: routes to
frontend/apps/public/src/App.jsx - Staff portal → Staff authentication: provides auth
frontend/apps/staff/src/App.jsx - Staff portal → Role-based routes: renders routes
frontend/apps/staff/src/App.jsx - Auth hook → Staff authentication: reads context
frontend/apps/staff/src/hooks/useAuth.js - Role-based routes → MPDC projects: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → Engineering review: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → Site monitoring: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → Admin projects: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → BAC procurement: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → Staff messaging: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → Staff accounts: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Role-based routes → Audit log: routes to
frontend/apps/staff/src/routes/AppRoutes.jsx - Engineering review → Form drafts: uses drafts
frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx - MPDC projects → Form drafts: uses drafts
frontend/apps/staff/src/pages/mpdc/ProjectForm.jsx - Engineering review → Supabase client: queries data
- Staff authentication → Supabase client: uses client
frontend/apps/staff/src/contexts/AuthContext.jsx - Project map → Decision support: uses flags
frontend/shared/src/components/ProjectMap.jsx - Project image analysis → Supabase database: may access
- Site photo analysis → Supabase database: may access
- Staff account function → Supabase database: may access
- Engineering review → Project image analysis: may analyze images
- Site monitoring → Site photo analysis: may analyze photos