# antonioyg/antonioyg.github.io architecture

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

- Interactive diagram: https://gitdiagram.com/antonioyg/antonioyg.github.io
- Repository: https://github.com/antonioyg/antonioyg.github.io

## Overview

This is a small PHP/MySQL timesheet application. Its apparent workflow is entering work-hour details, saving them to the `horas` table, then querying records or creating a date-range view. The excerpts show the save and query handlers, but the HTML pages, SQL files, and database-model files were not sampled; their connections to handlers and their exact schemas remain unverified.

Main entry points: [`entre_fechas.html`](https://github.com/antonioyg/antonioyg.github.io/blob/main/entre_fechas.html) (Date Range Form), [`guardar.php`](https://github.com/antonioyg/antonioyg.github.io/blob/main/guardar.php) (Save Hours), [`insertar.html`](https://github.com/antonioyg/antonioyg.github.io/blob/main/insertar.html) (Entry Form), [`consulta1.php`](https://github.com/antonioyg/antonioyg.github.io/blob/main/consulta1.php) (Joined Hours Listing)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ui["User Interface"]
  node_entry_form["Entry Form<br/>[insertar.html]"]
  node_range_form["Date Range Form<br/>[entre_fechas.html]"]
  node_views_page["Views Page<br/>[vistas.html]"]
  node_home["Home Page<br/>[index.html]"]
end

subgraph group_write["Timesheet Entry"]
  node_save["Save Hours<br/>[guardar.php]"]
  node_connection["DB Connection Settings<br/>[conexion.php]"]
end

subgraph group_read["Queries and Views"]
  node_list_joined["Joined Hours Listing<br/>[consulta1.php]"]
  node_list_range["Range Listing<br/>[consulta.php]"]
  node_create_view["Create Date View<br/>[crear_vistas.php]"]
end

subgraph group_data["Database"]
  node_hours_db[("Hours Database")]
  node_hours_sql["Hours SQL Definition<br/>[horas.sql]"]
  node_hourshechas_sql["Hourshechas SQL Definition<br/>[horashechas.sql]"]
  node_model["Database Model<br/>[horasirun.mwb]"]
  node_model_export["Model Export<br/>[horasirun.ste]"]
end

node_user(("User"))

node_user -.->|"enters hours"| node_entry_form
node_entry_form -.->|"submits to"| node_save
node_save -->|"includes"| node_connection
node_save -->|"inserts hours"| node_hours_db
node_user -.->|"selects dates"| node_range_form
node_range_form -.->|"requests listing"| node_list_joined
node_list_joined -->|"queries joined hours"| node_hours_db
node_range_form -.->|"requests range"| node_list_range
node_list_range -.->|"queries hours"| node_hours_db
node_views_page -.->|"requests view"| node_create_view
node_create_view -->|"creates and queries view"| node_hours_db
node_hours_sql -.->|"defines schema"| node_hours_db
node_hourshechas_sql -.->|"defines schema"| node_hours_db
node_model -.->|"models database"| node_hours_db
node_model_export -.->|"models database"| node_hours_db

click node_entry_form "https://github.com/antonioyg/antonioyg.github.io/blob/main/insertar.html"
click node_range_form "https://github.com/antonioyg/antonioyg.github.io/blob/main/entre_fechas.html"
click node_views_page "https://github.com/antonioyg/antonioyg.github.io/blob/main/vistas.html"
click node_home "https://github.com/antonioyg/antonioyg.github.io/blob/main/index.html"
click node_save "https://github.com/antonioyg/antonioyg.github.io/blob/main/guardar.php"
click node_connection "https://github.com/antonioyg/antonioyg.github.io/blob/main/conexion.php"
click node_list_joined "https://github.com/antonioyg/antonioyg.github.io/blob/main/consulta1.php"
click node_list_range "https://github.com/antonioyg/antonioyg.github.io/blob/main/consulta.php"
click node_create_view "https://github.com/antonioyg/antonioyg.github.io/blob/main/crear_vistas.php"
click node_hours_sql "https://github.com/antonioyg/antonioyg.github.io/blob/main/horas.sql"
click node_hourshechas_sql "https://github.com/antonioyg/antonioyg.github.io/blob/main/horashechas.sql"
click node_model "https://github.com/antonioyg/antonioyg.github.io/blob/main/horasirun.mwb"
click node_model_export "https://github.com/antonioyg/antonioyg.github.io/blob/main/horasirun.ste"

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_entry_form,node_range_form,node_views_page,node_home,node_user toneBlue
class node_save,node_connection toneAmber
class node_list_joined,node_list_range,node_create_view toneMint
class node_hours_db,node_hours_sql,node_hourshechas_sql,node_model,node_model_export toneRose
```

## Components

### User Interface

- [Entry Form](https://github.com/antonioyg/antonioyg.github.io/blob/main/insertar.html): `insertar.html`
- [Date Range Form](https://github.com/antonioyg/antonioyg.github.io/blob/main/entre_fechas.html): `entre_fechas.html`
- [Views Page](https://github.com/antonioyg/antonioyg.github.io/blob/main/vistas.html): `vistas.html`
- [Home Page](https://github.com/antonioyg/antonioyg.github.io/blob/main/index.html): `index.html`

### Timesheet Entry

- [Save Hours](https://github.com/antonioyg/antonioyg.github.io/blob/main/guardar.php): `guardar.php`
- [DB Connection Settings](https://github.com/antonioyg/antonioyg.github.io/blob/main/conexion.php): `conexion.php`

### Queries and Views

- [Joined Hours Listing](https://github.com/antonioyg/antonioyg.github.io/blob/main/consulta1.php): `consulta1.php`
- [Range Listing](https://github.com/antonioyg/antonioyg.github.io/blob/main/consulta.php): `consulta.php`
- [Create Date View](https://github.com/antonioyg/antonioyg.github.io/blob/main/crear_vistas.php): `crear_vistas.php`

### Database

- **Hours Database**
- [Hours SQL Definition](https://github.com/antonioyg/antonioyg.github.io/blob/main/horas.sql): `horas.sql`
- [Hourshechas SQL Definition](https://github.com/antonioyg/antonioyg.github.io/blob/main/horashechas.sql): `horashechas.sql`
- [Database Model](https://github.com/antonioyg/antonioyg.github.io/blob/main/horasirun.mwb): `horasirun.mwb`
- [Model Export](https://github.com/antonioyg/antonioyg.github.io/blob/main/horasirun.ste): `horasirun.ste`

### Other components

- **User**

## Connections

- User → Entry Form: enters hours
- Entry Form → Save Hours: submits to
- Save Hours → DB Connection Settings: includes (evidence: `guardar.php`)
- Save Hours → Hours Database: inserts hours (evidence: `guardar.php`)
- User → Date Range Form: selects dates
- Date Range Form → Joined Hours Listing: requests listing
- Joined Hours Listing → Hours Database: queries joined hours (evidence: `consulta1.php`)
- Date Range Form → Range Listing: requests range
- Range Listing → Hours Database: queries hours
- Views Page → Create Date View: requests view
- Create Date View → Hours Database: creates and queries view (evidence: `crear_vistas.php`)
- Hours SQL Definition → Hours Database: defines schema
- Hourshechas SQL Definition → Hours Database: defines schema
- Database Model → Hours Database: models database
- Model Export → Hours Database: models database