# faceincase/social-security-platform architecture

> Architecture diagram of the GitHub repository faceincase/social-security-platform, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-01). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/faceincase/social-security-platform
- Repository: https://github.com/faceincase/social-security-platform

## Overview

Social Input Platform is a PHP/SQLite community-issue reporting app with an admin oversight dashboard and a community blog. Residents submit categorized reports, optionally with images; administrators review and moderate reports, with JSON export and map/network visualizations. Users can register and log in, then publish blog updates. The sampled pages show direct page-to-SQLite access rather than a separate service layer. Some feature details and wiring are documented only in the README; unsampled implementation links are omitted unless documented.

Main entry points: [`DATABASE/reports.sqlite`](https://github.com/faceincase/social-security-platform/blob/main/DATABASE/reports.sqlite) (SQLite database), [`report.php`](https://github.com/faceincase/social-security-platform/blob/main/report.php) (Report submission), [`issues.php`](https://github.com/faceincase/social-security-platform/blob/main/issues.php) (Report dashboard), [`debug.php`](https://github.com/faceincase/social-security-platform/blob/main/debug.php) (Admin metrics)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_entry["Entry and accounts"]
  node_home["Landing page<br/>[index.php]"]
  node_accounts["Registration and login<br/>[login.php]"]
  node_adminverify["Admin verification<br/>[login_admin.php]"]
  node_verifyhelper["JS verification helper<br/>[verify.php]"]
end

subgraph group_reports["Issue reporting"]
  node_reportform["Report submission<br/>[report.php]"]
  node_postcode{{"Postcode lookup"}}
  node_uploads["Report images"]
end

subgraph group_oversight["Admin oversight"]
  node_dashboard["Report dashboard<br/>[issues.php]"]
  node_debug["Admin metrics<br/>[debug.php]"]
end

subgraph group_community["Community blog"]
  node_blogcreate["Post creation<br/>[new_post.php]"]
  node_blogfeed["Community feed<br/>[blog.php]"]
end

node_visitor(("Community user"))
node_admin(("Administrator"))
node_database[("SQLite database<br/>[reports.sqlite]")]

node_visitor -->|"opens"| node_home
node_visitor -->|"submits report"| node_reportform
node_reportform -->|"stores report"| node_database
node_reportform -->|"validates postcode"| node_postcode
node_reportform -->|"saves image"| node_uploads
node_visitor -->|"registers or logs in"| node_accounts
node_admin -->|"verifies account"| node_adminverify
node_visitor -->|"creates post"| node_blogcreate
node_blogcreate -->|"stores post"| node_database
node_visitor -->|"reads updates"| node_blogfeed
node_blogfeed -->|"loads and deletes posts"| node_database
node_admin -->|"reviews reports"| node_dashboard
node_dashboard -->|"reads and moderates"| node_database
node_admin -->|"views metrics"| node_debug
node_debug -->|"reads account data"| node_database

click node_home "https://github.com/faceincase/social-security-platform/blob/main/index.php"
click node_accounts "https://github.com/faceincase/social-security-platform/blob/main/login.php"
click node_adminverify "https://github.com/faceincase/social-security-platform/blob/main/login_admin.php"
click node_verifyhelper "https://github.com/faceincase/social-security-platform/blob/main/verify.php"
click node_reportform "https://github.com/faceincase/social-security-platform/blob/main/report.php"
click node_uploads "https://github.com/faceincase/social-security-platform/tree/main/REPORT_IMAGES"
click node_dashboard "https://github.com/faceincase/social-security-platform/blob/main/issues.php"
click node_debug "https://github.com/faceincase/social-security-platform/blob/main/debug.php"
click node_blogcreate "https://github.com/faceincase/social-security-platform/blob/main/new_post.php"
click node_blogfeed "https://github.com/faceincase/social-security-platform/blob/main/blog.php"
click node_database "https://github.com/faceincase/social-security-platform/blob/main/DATABASE/reports.sqlite"

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_home,node_accounts,node_adminverify,node_verifyhelper,node_visitor toneBlue
class node_reportform,node_postcode,node_uploads,node_database toneAmber
class node_dashboard,node_debug toneMint
class node_blogcreate,node_blogfeed toneRose
class node_admin toneIndigo
```

## Components

### Entry and accounts

- [Landing page](https://github.com/faceincase/social-security-platform/blob/main/index.php): `index.php`
- [Registration and login](https://github.com/faceincase/social-security-platform/blob/main/login.php): `login.php`
- [Admin verification](https://github.com/faceincase/social-security-platform/blob/main/login_admin.php): `login_admin.php`
- [JS verification helper](https://github.com/faceincase/social-security-platform/blob/main/verify.php): `verify.php`

### Issue reporting

- [Report submission](https://github.com/faceincase/social-security-platform/blob/main/report.php): `report.php`
- **Postcode lookup**
- [Report images](https://github.com/faceincase/social-security-platform/tree/main/REPORT_IMAGES): `REPORT_IMAGES`

### Admin oversight

- [Report dashboard](https://github.com/faceincase/social-security-platform/blob/main/issues.php): `issues.php`
- [Admin metrics](https://github.com/faceincase/social-security-platform/blob/main/debug.php): `debug.php`

### Community blog

- [Post creation](https://github.com/faceincase/social-security-platform/blob/main/new_post.php): `new_post.php`
- [Community feed](https://github.com/faceincase/social-security-platform/blob/main/blog.php): `blog.php`

### Other components

- **Community user**
- **Administrator**
- [SQLite database](https://github.com/faceincase/social-security-platform/blob/main/DATABASE/reports.sqlite): `DATABASE/reports.sqlite`

## Connections

- Community user → Landing page: opens (evidence: `README.md`)
- Community user → Report submission: submits report (evidence: `README.md`)
- Report submission → SQLite database: stores report (evidence: `report.php`)
- Report submission → Postcode lookup: validates postcode (evidence: `README.md`)
- Report submission → Report images: saves image (evidence: `report.php`)
- Community user → Registration and login: registers or logs in (evidence: `README.md`)
- Administrator → Admin verification: verifies account (evidence: `README.md`)
- Community user → Post creation: creates post (evidence: `README.md`)
- Post creation → SQLite database: stores post (evidence: `README.md`)
- Community user → Community feed: reads updates (evidence: `README.md`)
- Community feed → SQLite database: loads and deletes posts (evidence: `blog.php`)
- Administrator → Report dashboard: reviews reports (evidence: `README.md`)
- Report dashboard → SQLite database: reads and moderates (evidence: `issues.php`)
- Administrator → Admin metrics: views metrics (evidence: `debug.php`)
- Admin metrics → SQLite database: reads account data (evidence: `debug.php`)
