How ivanparada/product-registration-system works
This is a PHP/PostgreSQL product-registration application. A user fills a product form; browser-side validation gates submission, while lookup requests populate warehouse, branch, currency, and material choices. The save endpoint validates the submitted product, checks branch and code constraints, and transactionally stores the product and material links. The graph includes the form-rendering components and lookup capabilities; several lookup endpoint implementations are not excerpted, so their database connections are supported only by the SOURCE INDEX references.
Main entry points: database.php PDO connection · api.js HTTP API client · app.js Form orchestration · index.php Registration form
Components 15
Product form
- Registration form
index.php - Form controls
components
Browser workflow
- Form orchestration
js/app.js - Field validation
js/validation.js - HTTP API client
js/api.js
PHP services
- Warehouse lookup
php/get_warehouses.php - Branch lookup
php/get_branches.php - Currency lookup
php/get_currencies.php - Material lookup
php/get_materials.php - Product code check
php/check_product_code.php - Product persistence
php/save_product.php
Persistence
- PDO connection
php/config/database.php - Database schema
SQL/database.sql
Other components
- Product user
- PostgreSQL
Connections 20
- Product user → Registration form: enters product
README.md - Registration form → Form controls: renders controls
index.php - Registration form → Form orchestration: loads script
index.php - Form controls → Form orchestration: provides form fields
js/app.js - Form orchestration → Field validation: validates fields
js/app.js - Form orchestration → HTTP API client: requests data and saves
js/app.js - HTTP API client → Warehouse lookup: fetches
js/api.js - HTTP API client → Branch lookup: fetches
js/api.js - HTTP API client → Currency lookup: fetches
js/api.js - HTTP API client → Material lookup: fetches
js/api.js - HTTP API client → Product persistence: posts product
js/api.js - Warehouse lookup → PDO connection: uses connection
php/get_warehouses.php - Branch lookup → PDO connection: queries branches
php/get_branches.php - Currency lookup → PDO connection: uses connection
php/get_currencies.php - Material lookup → PDO connection: uses connection
php/get_materials.php - Product code check → PDO connection: uses connection
php/check_product_code.php - Product persistence → PDO connection: uses connection
php/save_product.php - PDO connection → PostgreSQL: connects
php/config/database.php - Product persistence → PostgreSQL: writes product and materials
php/save_product.php - Database schema → PostgreSQL: initializes schema
README.md