# tyronnejohn/lgu-donsol architecture

> Architecture diagram of the GitHub repository tyronnejohn/lgu-donsol, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/tyronnejohn/lgu-donsol
- Repository: https://github.com/tyronnejohn/lgu-donsol

## Overview

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: [`frontend/apps/staff/src/routes/AppRoutes.jsx`](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/routes/AppRoutes.jsx) (Role-based routes), [`frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx`](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx) (Engineering review), [`frontend/apps/staff/src/contexts/AuthContext.jsx`](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/contexts/AuthContext.jsx) (Staff authentication), [`backend/supabase/migrations`](https://github.com/tyronnejohn/lgu-donsol/tree/main/backend/supabase/migrations) (Supabase database)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_portals["Portals and access"]
  node_public["Public portal<br/>[App.jsx]"]
  node_public_home["Public home<br/>[PublicHome.jsx]"]
  node_public_projects["Public projects<br/>[PublicProjects.jsx]"]
  node_staff_app["Staff portal<br/>[App.jsx]"]
  node_auth["Staff authentication<br/>[AuthContext.jsx]"]
  node_auth_hook["Auth hook<br/>[useAuth.js]"]
  node_routes["Role-based routes<br/>[AppRoutes.jsx]"]
end

subgraph group_project["Project lifecycle"]
  node_mpdc["MPDC projects<br/>[ProjectForm.jsx]"]
  node_engineering["Engineering review"]
  node_site_monitoring["Site monitoring"]
end

subgraph group_operations["Operations and oversight"]
  node_admin_projects["Admin projects"]
  node_bac_procurement["BAC procurement"]
  node_messaging["Staff messaging<br/>[Messaging.jsx]"]
  node_staff_accounts["Staff accounts<br/>[StaffAccounts.jsx]"]
  node_audit["Audit log<br/>[AuditLog.jsx]"]
end

subgraph group_shared["Shared capabilities"]
  node_project_map["Project map<br/>[ProjectMap.jsx]"]
  node_dss["Decision support<br/>[decisionSupport.js]"]
  node_form_drafts["Form drafts<br/>[useFormDraft.js]"]
end

subgraph group_backend["Supabase services"]
  node_supabase_client["Supabase client<br/>[supabaseClient.js]"]
  node_project_image["Project image analysis<br/>[index.ts]"]
  node_site_photo["Site photo analysis<br/>[index.ts]"]
  node_staff_account_fn["Staff account function<br/>[index.ts]"]
  node_database[("Supabase database")]
end

node_public -->|"routes to"| node_public_home
node_public -->|"routes to"| node_public_projects
node_staff_app -->|"provides auth"| node_auth
node_staff_app -->|"renders routes"| node_routes
node_auth_hook -->|"reads context"| node_auth
node_routes -->|"routes to"| node_mpdc
node_routes -->|"routes to"| node_engineering
node_routes -->|"routes to"| node_site_monitoring
node_routes -->|"routes to"| node_admin_projects
node_routes -->|"routes to"| node_bac_procurement
node_routes -->|"routes to"| node_messaging
node_routes -->|"routes to"| node_staff_accounts
node_routes -->|"routes to"| node_audit
node_engineering -->|"uses drafts"| node_form_drafts
node_mpdc -->|"uses drafts"| node_form_drafts
node_engineering -->|"queries data"| node_supabase_client
node_auth -->|"uses client"| node_supabase_client
node_project_map -->|"uses flags"| node_dss
node_project_image -.->|"may access"| node_database
node_site_photo -.->|"may access"| node_database
node_staff_account_fn -.->|"may access"| node_database
node_engineering -.->|"may analyze images"| node_project_image
node_site_monitoring -.->|"may analyze photos"| node_site_photo

click node_public "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/public/src/App.jsx"
click node_public_home "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/public/src/pages/PublicHome.jsx"
click node_public_projects "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/public/src/pages/PublicProjects.jsx"
click node_staff_app "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/App.jsx"
click node_auth "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/contexts/AuthContext.jsx"
click node_auth_hook "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/hooks/useAuth.js"
click node_routes "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/routes/AppRoutes.jsx"
click node_mpdc "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/mpdc/ProjectForm.jsx"
click node_engineering "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx"
click node_site_monitoring "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/engineering/ProjectMonitoringDetail.jsx"
click node_admin_projects "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/admin/AdminProjectDetail.jsx"
click node_bac_procurement "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/bac/BacProcurementDetail.jsx"
click node_messaging "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/shared/Messaging.jsx"
click node_staff_accounts "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/admin/StaffAccounts.jsx"
click node_audit "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/admin/AuditLog.jsx"
click node_project_map "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/shared/src/components/ProjectMap.jsx"
click node_dss "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/shared/src/utils/decisionSupport.js"
click node_form_drafts "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/hooks/useFormDraft.js"
click node_supabase_client "https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/shared/src/lib/supabaseClient.js"
click node_project_image "https://github.com/tyronnejohn/lgu-donsol/blob/main/backend/supabase/functions/analyze-project-image/index.ts"
click node_site_photo "https://github.com/tyronnejohn/lgu-donsol/blob/main/backend/supabase/functions/analyze-site-photo/index.ts"
click node_staff_account_fn "https://github.com/tyronnejohn/lgu-donsol/blob/main/backend/supabase/functions/create-staff-account/index.ts"
click node_database "https://github.com/tyronnejohn/lgu-donsol/tree/main/backend/supabase/migrations"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_public,node_public_home,node_public_projects,node_staff_app,node_auth,node_auth_hook,node_routes toneBlue
class node_mpdc,node_engineering,node_site_monitoring toneAmber
class node_admin_projects,node_bac_procurement,node_messaging,node_staff_accounts,node_audit toneMint
class node_project_map,node_dss,node_form_drafts toneRose
class node_supabase_client,node_project_image,node_site_photo,node_staff_account_fn,node_database toneIndigo
```

## Components

### Portals and access

- [Public portal](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/public/src/App.jsx): `frontend/apps/public/src/App.jsx`
- [Public home](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/public/src/pages/PublicHome.jsx): `frontend/apps/public/src/pages/PublicHome.jsx`
- [Public projects](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/public/src/pages/PublicProjects.jsx): `frontend/apps/public/src/pages/PublicProjects.jsx`
- [Staff portal](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/App.jsx): `frontend/apps/staff/src/App.jsx`
- [Staff authentication](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/contexts/AuthContext.jsx): `frontend/apps/staff/src/contexts/AuthContext.jsx`
- [Auth hook](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/hooks/useAuth.js): `frontend/apps/staff/src/hooks/useAuth.js`
- [Role-based routes](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/routes/AppRoutes.jsx): `frontend/apps/staff/src/routes/AppRoutes.jsx`

### Project lifecycle

- [MPDC projects](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/mpdc/ProjectForm.jsx): `frontend/apps/staff/src/pages/mpdc/ProjectForm.jsx`
- [Engineering review](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx): `frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx`
- [Site monitoring](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/engineering/ProjectMonitoringDetail.jsx): `frontend/apps/staff/src/pages/engineering/ProjectMonitoringDetail.jsx`

### Operations and oversight

- [Admin projects](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/admin/AdminProjectDetail.jsx): `frontend/apps/staff/src/pages/admin/AdminProjectDetail.jsx`
- [BAC procurement](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/bac/BacProcurementDetail.jsx): `frontend/apps/staff/src/pages/bac/BacProcurementDetail.jsx`
- [Staff messaging](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/shared/Messaging.jsx): `frontend/apps/staff/src/pages/shared/Messaging.jsx`
- [Staff accounts](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/admin/StaffAccounts.jsx): `frontend/apps/staff/src/pages/admin/StaffAccounts.jsx`
- [Audit log](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/pages/admin/AuditLog.jsx): `frontend/apps/staff/src/pages/admin/AuditLog.jsx`

### Shared capabilities

- [Project map](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/shared/src/components/ProjectMap.jsx): `frontend/shared/src/components/ProjectMap.jsx`
- [Decision support](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/shared/src/utils/decisionSupport.js): `frontend/shared/src/utils/decisionSupport.js`
- [Form drafts](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/apps/staff/src/hooks/useFormDraft.js): `frontend/apps/staff/src/hooks/useFormDraft.js`

### Supabase services

- [Supabase client](https://github.com/tyronnejohn/lgu-donsol/blob/main/frontend/shared/src/lib/supabaseClient.js): `frontend/shared/src/lib/supabaseClient.js`
- [Project image analysis](https://github.com/tyronnejohn/lgu-donsol/blob/main/backend/supabase/functions/analyze-project-image/index.ts): `backend/supabase/functions/analyze-project-image/index.ts`
- [Site photo analysis](https://github.com/tyronnejohn/lgu-donsol/blob/main/backend/supabase/functions/analyze-site-photo/index.ts): `backend/supabase/functions/analyze-site-photo/index.ts`
- [Staff account function](https://github.com/tyronnejohn/lgu-donsol/blob/main/backend/supabase/functions/create-staff-account/index.ts): `backend/supabase/functions/create-staff-account/index.ts`
- [Supabase database](https://github.com/tyronnejohn/lgu-donsol/tree/main/backend/supabase/migrations): `backend/supabase/migrations`

## Connections

- Public portal → Public home: routes to (evidence: `frontend/apps/public/src/App.jsx`)
- Public portal → Public projects: routes to (evidence: `frontend/apps/public/src/App.jsx`)
- Staff portal → Staff authentication: provides auth (evidence: `frontend/apps/staff/src/App.jsx`)
- Staff portal → Role-based routes: renders routes (evidence: `frontend/apps/staff/src/App.jsx`)
- Auth hook → Staff authentication: reads context (evidence: `frontend/apps/staff/src/hooks/useAuth.js`)
- Role-based routes → MPDC projects: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → Engineering review: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → Site monitoring: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → Admin projects: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → BAC procurement: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → Staff messaging: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → Staff accounts: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Role-based routes → Audit log: routes to (evidence: `frontend/apps/staff/src/routes/AppRoutes.jsx`)
- Engineering review → Form drafts: uses drafts (evidence: `frontend/apps/staff/src/pages/engineering/ProjectReviewDetail.jsx`)
- MPDC projects → Form drafts: uses drafts (evidence: `frontend/apps/staff/src/pages/mpdc/ProjectForm.jsx`)
- Engineering review → Supabase client: queries data
- Staff authentication → Supabase client: uses client (evidence: `frontend/apps/staff/src/contexts/AuthContext.jsx`)
- Project map → Decision support: uses flags (evidence: `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
