How antonioyg/antonioyg.github.io works
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 Date Range Form · guardar.php Save Hours · insertar.html Entry Form · consulta1.php Joined Hours Listing
Components 15
User Interface
- Entry Form
insertar.html - Date Range Form
entre_fechas.html - Views Page
vistas.html - Home Page
index.html
Timesheet Entry
- Save Hours
guardar.php - DB Connection Settings
conexion.php
Queries and Views
- Joined Hours Listing
consulta1.php - Range Listing
consulta.php - Create Date View
crear_vistas.php
Database
- Hours Database
- Hours SQL Definition
horas.sql - Hourshechas SQL Definition
horashechas.sql - Database Model
horasirun.mwb - Model Export
horasirun.ste
Other components
- User
Connections 15
- User → Entry Form: enters hours
- Entry Form → Save Hours: submits to
- Save Hours → DB Connection Settings: includes
guardar.php - Save Hours → Hours Database: inserts hours
guardar.php - User → Date Range Form: selects dates
- Date Range Form → Joined Hours Listing: requests listing
- Joined Hours Listing → Hours Database: queries joined hours
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
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