# wilgenjarethvasqueztorrez/horario-de-asistencia architecture

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

- Interactive diagram: https://gitdiagram.com/wilgenjarethvasqueztorrez/horario-de-asistencia
- Repository: https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia

## Overview

Horario-de-asistencia is a PHP attendance and workforce administration portal. Administrators manage employees, roles, schedules, holidays, attendance and user accounts; employees can review work-hour summaries and submit requests. The visible workflow is a session-protected page or form, followed by a CRUD handler that persists changes through the shared database connection. The tree also shows login, dashboards, attendance charts and interface components. Evidence is limited: the README is only a title, and several page and handler implementations were not sampled, so unsupported links are omitted.

Main entry points: [`Config/Conexion.php`](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Config/Conexion.php) (DB Connection), [`index.php`](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/index.php) (Admin Dashboard), [`pages/dia_no_laboral.php`](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/dia_no_laboral.php) (Holiday Page), [`pages/perfil_empleado.php`](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/perfil_empleado.php) (Employee Profile)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_access["Access and Shell"]
  node_session["Session Guard"]
  node_login_form["Login Form<br/>[login.php]"]
  node_login_handlers["Login Handlers<br/>[validarLogin.php]"]
  node_dashboard["Admin Dashboard<br/>[index.php]"]
  node_sidebar["Sidebar<br/>[sidebar.php]"]
  node_userbar["User Bar<br/>[userbar.php]"]
  node_db_connection["DB Connection<br/>[Conexion.php]"]
end

subgraph group_attendance["Attendance"]
  node_attendance_pages["Attendance Pages<br/>[asistencia.php]"]
  node_attendance_forms["Attendance Forms"]
  node_attendance_crud["Attendance CRUD"]
  node_attendance_report["Employee Attendance Report<br/>[VerAsistencias.php]"]
end

subgraph group_admin["Workforce Administration"]
  node_holiday_page["Holiday Page<br/>[dia_no_laboral.php]"]
  node_holiday_forms["Holiday Forms"]
  node_holiday_crud["Holiday CRUD"]
  node_employee_crud["Employee CRUD<br/>[editarEmpleado.php]"]
  node_schedule_crud["Schedule CRUD<br/>[editarHorario.php]"]
  node_role_crud["Role CRUD<br/>[editarRol.php]"]
  node_user_crud["User CRUD<br/>[editarUsuario.php]"]
end

subgraph group_requests["Requests and Reporting"]
  node_employee_page["Employee Profile"]
  node_requests_forms["Request Forms"]
  node_requests_crud["Request CRUD"]
end

node_admin_actor(("Administrator"))
node_employee_actor(("Employee"))
node_database[("MySQL Database")]

node_admin_actor -->|"opens"| node_login_form
node_employee_actor -->|"opens"| node_login_form
node_login_form -.->|"submits login"| node_login_handlers
node_login_handlers -->|"uses connection"| node_db_connection
node_dashboard -->|"requires session"| node_session
node_dashboard -.->|"queries data"| node_db_connection
node_dashboard -->|"includes"| node_sidebar
node_dashboard -->|"includes"| node_userbar
node_userbar -->|"uses connection"| node_db_connection
node_db_connection -->|"connects"| node_database
node_attendance_forms -->|"submits update"| node_attendance_crud
node_attendance_crud -->|"uses connection"| node_db_connection
node_attendance_report -->|"queries records"| node_db_connection
node_employee_page -->|"requires session"| node_session
node_employee_page -->|"queries data"| node_db_connection
node_employee_page -->|"links to"| node_requests_forms
node_requests_forms -->|"submits request"| node_requests_crud
node_requests_crud -->|"uses connection"| node_db_connection
node_holiday_page -->|"requires session"| node_session
node_holiday_page -->|"includes form"| node_holiday_forms
node_holiday_page -->|"queries data"| node_db_connection
node_holiday_forms -->|"queries records"| node_db_connection
node_holiday_crud -->|"uses connection"| node_db_connection
node_employee_crud -->|"uses connection"| node_db_connection
node_schedule_crud -->|"uses connection"| node_db_connection
node_role_crud -->|"uses connection"| node_db_connection
node_user_crud -->|"uses connection"| node_db_connection

click node_session "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Config/verificarSesion.php"
click node_login_form "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Login/login.php"
click node_login_handlers "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Login/validarLogin.php"
click node_dashboard "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/index.php"
click node_sidebar "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/src/includes/Componentes/sidebar.php"
click node_userbar "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/src/includes/Componentes/userbar.php"
click node_db_connection "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Config/Conexion.php"
click node_attendance_pages "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/asistencia.php"
click node_attendance_forms "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Asistencia/EditarAsistencia.php"
click node_attendance_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Asistencia/editarAsistencia.php"
click node_attendance_report "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Empleado/VerAsistencias.php"
click node_employee_page "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/perfil_empleado.php"
click node_requests_forms "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Solicitud/AgregarSolicitud.php"
click node_requests_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Solicitud/insertarSolicitud.php"
click node_holiday_page "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/dia_no_laboral.php"
click node_holiday_forms "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/DiaNoLaboral/EditarDiaNoLaboral.php"
click node_holiday_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/DiaNoLaboral/editarDiaNoLaboral.php"
click node_employee_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Empleado/editarEmpleado.php"
click node_schedule_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Horario/editarHorario.php"
click node_role_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Rol/editarRol.php"
click node_user_crud "https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Usuario/editarUsuario.php"

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_session,node_login_form,node_login_handlers,node_dashboard,node_sidebar,node_userbar,node_db_connection toneBlue
class node_attendance_pages,node_attendance_forms,node_attendance_crud,node_attendance_report,node_database toneAmber
class node_holiday_page,node_holiday_forms,node_holiday_crud,node_employee_crud,node_schedule_crud,node_role_crud,node_user_crud toneMint
class node_employee_page,node_requests_forms,node_requests_crud toneRose
class node_admin_actor,node_employee_actor toneIndigo
```

## Components

### Access and Shell

- [Session Guard](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Config/verificarSesion.php): `Config/verificarSesion.php`
- [Login Form](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Login/login.php): `Formularios/Login/login.php`
- [Login Handlers](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Login/validarLogin.php): `CRUD/Login/validarLogin.php`
- [Admin Dashboard](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/index.php): `index.php`
- [Sidebar](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/src/includes/Componentes/sidebar.php): `src/includes/Componentes/sidebar.php`
- [User Bar](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/src/includes/Componentes/userbar.php): `src/includes/Componentes/userbar.php`
- [DB Connection](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Config/Conexion.php): `Config/Conexion.php`

### Attendance

- [Attendance Pages](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/asistencia.php): `pages/asistencia.php`
- [Attendance Forms](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Asistencia/EditarAsistencia.php): `Formularios/Asistencia/EditarAsistencia.php`
- [Attendance CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Asistencia/editarAsistencia.php): `CRUD/Asistencia/editarAsistencia.php`
- [Employee Attendance Report](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Empleado/VerAsistencias.php): `Formularios/Empleado/VerAsistencias.php`

### Workforce Administration

- [Holiday Page](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/dia_no_laboral.php): `pages/dia_no_laboral.php`
- [Holiday Forms](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/DiaNoLaboral/EditarDiaNoLaboral.php): `Formularios/DiaNoLaboral/EditarDiaNoLaboral.php`
- [Holiday CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/DiaNoLaboral/editarDiaNoLaboral.php): `CRUD/DiaNoLaboral/editarDiaNoLaboral.php`
- [Employee CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Empleado/editarEmpleado.php): `CRUD/Empleado/editarEmpleado.php`
- [Schedule CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Horario/editarHorario.php): `CRUD/Horario/editarHorario.php`
- [Role CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Rol/editarRol.php): `CRUD/Rol/editarRol.php`
- [User CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Usuario/editarUsuario.php): `CRUD/Usuario/editarUsuario.php`

### Requests and Reporting

- [Employee Profile](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/pages/perfil_empleado.php): `pages/perfil_empleado.php`
- [Request Forms](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/Formularios/Solicitud/AgregarSolicitud.php): `Formularios/Solicitud/AgregarSolicitud.php`
- [Request CRUD](https://github.com/wilgenjarethvasqueztorrez/horario-de-asistencia/blob/main/CRUD/Solicitud/insertarSolicitud.php): `CRUD/Solicitud/insertarSolicitud.php`

### Other components

- **Administrator**
- **Employee**
- **MySQL Database**

## Connections

- Administrator → Login Form: opens
- Employee → Login Form: opens
- Login Form → Login Handlers: submits login
- Login Handlers → DB Connection: uses connection (evidence: `CRUD/Login/validarLogin.php`)
- Admin Dashboard → Session Guard: requires session (evidence: `index.php`)
- Admin Dashboard → DB Connection: queries data (evidence: `index.php`)
- Admin Dashboard → Sidebar: includes (evidence: `index.php`)
- Admin Dashboard → User Bar: includes (evidence: `index.php`)
- User Bar → DB Connection: uses connection (evidence: `src/includes/Componentes/userbar.php`)
- DB Connection → MySQL Database: connects (evidence: `Config/Conexion.php`)
- Attendance Forms → Attendance CRUD: submits update (evidence: `Formularios/Asistencia/EditarAsistencia.php`)
- Attendance CRUD → DB Connection: uses connection (evidence: `CRUD/Asistencia/editarAsistencia.php`)
- Employee Attendance Report → DB Connection: queries records (evidence: `Formularios/Empleado/VerAsistencias.php`)
- Employee Profile → Session Guard: requires session (evidence: `pages/perfil_empleado.php`)
- Employee Profile → DB Connection: queries data (evidence: `pages/perfil_empleado.php`)
- Employee Profile → Request Forms: links to (evidence: `pages/perfil_empleado.php`)
- Request Forms → Request CRUD: submits request (evidence: `Formularios/Solicitud/AgregarSolicitud.php`)
- Request CRUD → DB Connection: uses connection (evidence: `CRUD/Solicitud/insertarSolicitud.php`)
- Holiday Page → Session Guard: requires session (evidence: `pages/dia_no_laboral.php`)
- Holiday Page → Holiday Forms: includes form (evidence: `pages/dia_no_laboral.php`)
- Holiday Page → DB Connection: queries data (evidence: `pages/dia_no_laboral.php`)
- Holiday Forms → DB Connection: queries records (evidence: `Formularios/DiaNoLaboral/EditarDiaNoLaboral.php`)
- Holiday CRUD → DB Connection: uses connection (evidence: `CRUD/DiaNoLaboral/editarDiaNoLaboral.php`)
- Employee CRUD → DB Connection: uses connection (evidence: `CRUD/Empleado/editarEmpleado.php`)
- Schedule CRUD → DB Connection: uses connection (evidence: `CRUD/Horario/editarHorario.php`)
- Role CRUD → DB Connection: uses connection (evidence: `CRUD/Rol/editarRol.php`)
- User CRUD → DB Connection: uses connection (evidence: `CRUD/Usuario/editarUsuario.php`)
