# ailtonmds/agrostock architecture

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

- Interactive diagram: https://gitdiagram.com/ailtonmds/agrostock
- Repository: https://github.com/ailtonmds/agrostock

## Overview

AgroStock is a web-based warehouse inventory system. Staff sign in, manage products, categories and lots, then record stock receipts or issues; barcode scans can help identify products during those stock operations. The backend serves PHP endpoints, checks sessions, and persists inventory and movement data in MySQL/MariaDB. Dashboard, alerts and reports provide operational visibility, while user administration controls access. The README documents frontend-to-API and barcode behavior; sampled backend files show database queries and shared session/configuration dependencies. Other frontend wiring is described but was not sampled.

Main entry points: [`frontend/assets/js/api.js`](https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/api.js) (API client), [`backend/auth/verificar_sessao.php`](https://github.com/ailtonmds/agrostock/blob/main/backend/auth/verificar_sessao.php) (Session validation), [`backend/config/conexao.php`](https://github.com/ailtonmds/agrostock/blob/main/backend/config/conexao.php) (PDO connection), [`database/database.sql`](https://github.com/ailtonmds/agrostock/blob/main/database/database.sql) (MySQL/MariaDB)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web interface"]
  node_screens["Inventory screens"]
  node_api_client["API client<br/>[api.js]"]
  node_scan["Barcode input<br/>[scan-to-input.js]"]
  node_auth_ui["Login screens<br/>[login.js]"]
end

subgraph group_inventory["Inventory operations"]
  node_products["Product endpoints"]
  node_categories["Category endpoints"]
  node_lots["Lot endpoints"]
  node_stock["Stock operations"]
  node_barcode_lookup["Barcode lookup"]
end

subgraph group_insights["Monitoring and reports"]
  node_dashboard["Dashboard data<br/>[dashboard.php]"]
  node_alerts["Stock and expiry alerts"]
  node_reports["Inventory reports"]
end

subgraph group_access["Access and configuration"]
  node_auth_api["Authentication endpoints"]
  node_session["Session validation"]
  node_config["Backend configuration<br/>[config.php]"]
  node_users["User administration"]
end

subgraph group_persistence["Data storage"]
  node_connection["PDO connection<br/>[conexao.php]"]
  node_db[("MySQL/MariaDB<br/>[database.sql]")]
end

node_staff(("Warehouse staff"))

node_staff -->|"uses"| node_screens
node_screens -->|"requests through"| node_api_client
node_api_client -->|"calls API"| node_auth_api
node_api_client -->|"calls API"| node_products
node_api_client -->|"calls API"| node_categories
node_api_client -->|"calls API"| node_lots
node_api_client -->|"calls API"| node_stock
node_api_client -->|"calls API"| node_dashboard
node_api_client -->|"calls API"| node_alerts
node_api_client -->|"calls API"| node_reports
node_api_client -->|"calls API"| node_users
node_screens -->|"uses on stock screens"| node_scan
node_scan -->|"triggers lookup"| node_barcode_lookup
node_screens -->|"includes login"| node_auth_ui
node_auth_api -.->|"validates protected access"| node_session
node_session -->|"queries users"| node_connection
node_session -->|"loads settings"| node_config
node_auth_api -->|"loads PDO"| node_connection
node_auth_api -->|"loads settings"| node_config
node_products -->|"checks session"| node_session
node_lots -->|"checks session"| node_session
node_stock -->|"checks session"| node_session
node_dashboard -->|"checks session"| node_session
node_alerts -->|"checks session"| node_session
node_reports -->|"checks session"| node_session
node_users -->|"checks session"| node_session
node_products -->|"queries via PDO"| node_connection
node_lots -->|"updates via PDO"| node_connection
node_stock -->|"queries via PDO"| node_connection
node_dashboard -->|"queries via PDO"| node_connection
node_alerts -->|"queries via PDO"| node_connection
node_reports -->|"queries via PDO"| node_connection
node_users -->|"updates via PDO"| node_connection
node_barcode_lookup -->|"checks session"| node_session
node_barcode_lookup -->|"queries via PDO"| node_connection
node_connection -->|"connects to"| node_db
node_products -->|"reads and writes"| node_db
node_lots -->|"reads and writes"| node_db
node_stock -->|"reads movement data"| node_db
node_dashboard -->|"aggregates inventory"| node_db
node_alerts -->|"reads lot expiry"| node_db
node_reports -->|"reads stock data"| node_db
node_users -->|"reads and writes"| node_db
node_barcode_lookup -->|"searches product codes"| node_db

click node_screens "https://github.com/ailtonmds/agrostock/tree/main/frontend/pages"
click node_api_client "https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/api.js"
click node_scan "https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/scan-to-input.js"
click node_auth_ui "https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/login.js"
click node_auth_api "https://github.com/ailtonmds/agrostock/tree/main/backend/auth"
click node_session "https://github.com/ailtonmds/agrostock/blob/main/backend/auth/verificar_sessao.php"
click node_config "https://github.com/ailtonmds/agrostock/blob/main/backend/config/config.php"
click node_connection "https://github.com/ailtonmds/agrostock/blob/main/backend/config/conexao.php"
click node_products "https://github.com/ailtonmds/agrostock/tree/main/backend/produtos"
click node_categories "https://github.com/ailtonmds/agrostock/tree/main/backend/categorias"
click node_lots "https://github.com/ailtonmds/agrostock/tree/main/backend/lotes"
click node_stock "https://github.com/ailtonmds/agrostock/tree/main/backend/estoque"
click node_barcode_lookup "https://github.com/ailtonmds/agrostock/blob/main/backend/produtos/buscar_por_codigo.php"
click node_dashboard "https://github.com/ailtonmds/agrostock/blob/main/backend/dashboard.php"
click node_alerts "https://github.com/ailtonmds/agrostock/tree/main/backend/alertas"
click node_reports "https://github.com/ailtonmds/agrostock/tree/main/backend/relatorios"
click node_users "https://github.com/ailtonmds/agrostock/tree/main/backend/usuarios"
click node_db "https://github.com/ailtonmds/agrostock/blob/main/database/database.sql"

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_screens,node_api_client,node_scan,node_auth_ui toneBlue
class node_products,node_categories,node_lots,node_stock,node_barcode_lookup toneAmber
class node_dashboard,node_alerts,node_reports toneMint
class node_auth_api,node_session,node_config,node_users toneRose
class node_connection,node_db,node_staff toneIndigo
```

## Components

### Web interface

- [Inventory screens](https://github.com/ailtonmds/agrostock/tree/main/frontend/pages): `frontend/pages`
- [API client](https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/api.js): `frontend/assets/js/api.js`
- [Barcode input](https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/scan-to-input.js): `frontend/assets/js/scan-to-input.js`
- [Login screens](https://github.com/ailtonmds/agrostock/blob/main/frontend/assets/js/login.js): `frontend/assets/js/login.js`

### Inventory operations

- [Product endpoints](https://github.com/ailtonmds/agrostock/tree/main/backend/produtos): `backend/produtos`
- [Category endpoints](https://github.com/ailtonmds/agrostock/tree/main/backend/categorias): `backend/categorias`
- [Lot endpoints](https://github.com/ailtonmds/agrostock/tree/main/backend/lotes): `backend/lotes`
- [Stock operations](https://github.com/ailtonmds/agrostock/tree/main/backend/estoque): `backend/estoque`
- [Barcode lookup](https://github.com/ailtonmds/agrostock/blob/main/backend/produtos/buscar_por_codigo.php): `backend/produtos/buscar_por_codigo.php`

### Monitoring and reports

- [Dashboard data](https://github.com/ailtonmds/agrostock/blob/main/backend/dashboard.php): `backend/dashboard.php`
- [Stock and expiry alerts](https://github.com/ailtonmds/agrostock/tree/main/backend/alertas): `backend/alertas`
- [Inventory reports](https://github.com/ailtonmds/agrostock/tree/main/backend/relatorios): `backend/relatorios`

### Access and configuration

- [Authentication endpoints](https://github.com/ailtonmds/agrostock/tree/main/backend/auth): `backend/auth`
- [Session validation](https://github.com/ailtonmds/agrostock/blob/main/backend/auth/verificar_sessao.php): `backend/auth/verificar_sessao.php`
- [Backend configuration](https://github.com/ailtonmds/agrostock/blob/main/backend/config/config.php): `backend/config/config.php`
- [User administration](https://github.com/ailtonmds/agrostock/tree/main/backend/usuarios): `backend/usuarios`

### Data storage

- [PDO connection](https://github.com/ailtonmds/agrostock/blob/main/backend/config/conexao.php): `backend/config/conexao.php`
- [MySQL/MariaDB](https://github.com/ailtonmds/agrostock/blob/main/database/database.sql): `database/database.sql`

### Other components

- **Warehouse staff**

## Connections

- Warehouse staff → Inventory screens: uses (evidence: `README.md`)
- Inventory screens → API client: requests through (evidence: `README.md`)
- API client → Authentication endpoints: calls API (evidence: `README.md`)
- API client → Product endpoints: calls API (evidence: `README.md`)
- API client → Category endpoints: calls API (evidence: `README.md`)
- API client → Lot endpoints: calls API (evidence: `README.md`)
- API client → Stock operations: calls API (evidence: `README.md`)
- API client → Dashboard data: calls API (evidence: `README.md`)
- API client → Stock and expiry alerts: calls API (evidence: `README.md`)
- API client → Inventory reports: calls API (evidence: `README.md`)
- API client → User administration: calls API (evidence: `README.md`)
- Inventory screens → Barcode input: uses on stock screens (evidence: `README.md`)
- Barcode input → Barcode lookup: triggers lookup (evidence: `README.md`)
- Inventory screens → Login screens: includes login (evidence: `README.md`)
- Authentication endpoints → Session validation: validates protected access
- Session validation → PDO connection: queries users (evidence: `backend/auth/verificar_sessao.php`)
- Session validation → Backend configuration: loads settings (evidence: `backend/auth/verificar_sessao.php`)
- Authentication endpoints → PDO connection: loads PDO (evidence: `backend/auth/login.php`)
- Authentication endpoints → Backend configuration: loads settings (evidence: `backend/auth/login.php`)
- Product endpoints → Session validation: checks session (evidence: `backend/produtos/excluir.php`)
- Lot endpoints → Session validation: checks session (evidence: `backend/lotes/editar.php`)
- Stock operations → Session validation: checks session (evidence: `backend/estoque/movimentacoes.php`)
- Dashboard data → Session validation: checks session (evidence: `backend/dashboard.php`)
- Stock and expiry alerts → Session validation: checks session (evidence: `backend/alertas/validade.php`)
- Inventory reports → Session validation: checks session (evidence: `backend/relatorios/estoque.php`)
- User administration → Session validation: checks session (evidence: `backend/usuarios/editar.php`)
- Product endpoints → PDO connection: queries via PDO (evidence: `backend/produtos/excluir.php`)
- Lot endpoints → PDO connection: updates via PDO (evidence: `backend/lotes/editar.php`)
- Stock operations → PDO connection: queries via PDO (evidence: `backend/estoque/movimentacoes.php`)
- Dashboard data → PDO connection: queries via PDO (evidence: `backend/dashboard.php`)
- Stock and expiry alerts → PDO connection: queries via PDO (evidence: `backend/alertas/validade.php`)
- Inventory reports → PDO connection: queries via PDO (evidence: `backend/relatorios/estoque.php`)
- User administration → PDO connection: updates via PDO (evidence: `backend/usuarios/editar.php`)
- Barcode lookup → Session validation: checks session (evidence: `backend/produtos/buscar_por_codigo.php`)
- Barcode lookup → PDO connection: queries via PDO (evidence: `backend/produtos/buscar_por_codigo.php`)
- PDO connection → MySQL/MariaDB: connects to (evidence: `backend/config/conexao.php`)
- Product endpoints → MySQL/MariaDB: reads and writes (evidence: `backend/produtos/excluir.php`)
- Lot endpoints → MySQL/MariaDB: reads and writes (evidence: `backend/lotes/editar.php`)
- Stock operations → MySQL/MariaDB: reads movement data (evidence: `backend/estoque/movimentacoes.php`)
- Dashboard data → MySQL/MariaDB: aggregates inventory (evidence: `backend/dashboard.php`)
- Stock and expiry alerts → MySQL/MariaDB: reads lot expiry (evidence: `backend/alertas/validade.php`)
- Inventory reports → MySQL/MariaDB: reads stock data (evidence: `backend/relatorios/estoque.php`)
- User administration → MySQL/MariaDB: reads and writes (evidence: `backend/usuarios/editar.php`)
- Barcode lookup → MySQL/MariaDB: searches product codes (evidence: `backend/produtos/buscar_por_codigo.php`)
