How birondo-ops/capstone works
This is an administrator-facing inventory and sales operations system for a cleaning-products distributor. The main workflow is to maintain product stock, record wholesale dispatches or retailer sales, settle dispatch remittances, and review resulting sales and stock movement for operational decisions. The PHP pages share a MySQL database; a separate Python job derives monthly revenue forecasts. README evidence establishes the product goals, while several page implementations were not sampled, so their detailed call wiring is not inferred.
Main entry points: conn.php Database connection · dispatchers.php Dispatch operations · inventory.php Inventory management · capstone_1 (2).sql MySQL database
Components 20
Access and overview
- Login and recovery
auth/login.php - Database connection
auth/conn.php - Dashboard
index.php
Inventory operations
- Inventory management
inventory.php - Product edits
function/edit_product.php - Stock registration
function/insert_into.php - Stock movement logs
inventory_logs.php
Sales and dispatch
- Dispatch operations
dispatchers.php - Dispatch controller
function/dispatchController.php - Dispatch adjustments
function/edit_despatch.php - Dispatch remittance
function/afternoon_remit.php - Retailer sales
retailer.php - Sales history
sales.php - Worker balances
balance.php
Reporting and decisions
- Audit trail
audit_trail.php - System settings
setting.php - Revenue forecast
py_ml/forecast.py
Other components
- Administrator
- MySQL database
capstone_1 (2).sql - SMTP mail service
Connections 34
- Administrator → Login and recovery: signs in
- Login and recovery → Database connection: queries users
- Login and recovery → SMTP mail service: sends recovery
- Administrator → Dashboard: views metrics
- Dashboard → Database connection: queries reports
- Database connection → MySQL database: connects
- Administrator → Inventory management: manages stock
- Inventory management → Stock registration: submits stock
- Inventory management → Product edits: edits products
- Inventory management → Database connection: reads products
- Stock registration → Database connection: writes stock
- Product edits → Database connection: updates products
- Product edits → MySQL database: stores images
- Administrator → Stock movement logs: reviews movements
- Stock movement logs → Database connection: queries logs
- Administrator → Dispatch operations: records dispatch
- Dispatch operations → Dispatch controller: invokes dispatch
- Dispatch operations → Database connection: loads dispatch data
- Dispatch controller → MySQL database: reads and updates
- Dispatch operations → Dispatch adjustments: adjusts quantities
- Dispatch adjustments → Database connection: updates dispatch
- Dispatch operations → Dispatch remittance: opens settlement
- Dispatch remittance → Database connection: records settlement
- Administrator → Retailer sales: records retail sales
- Retailer sales → Database connection: processes orders
- Administrator → Sales history: reviews sales
- Sales history → Database connection: queries sales
- Administrator → Worker balances: reviews balances
- Worker balances → Database connection: reads balances
- Administrator → Audit trail: reviews activity
- Audit trail → Database connection: queries audit data
- Administrator → System settings: configures system
- System settings → Database connection: reads settings
- Revenue forecast → MySQL database: reads revenue and saves prediction