How sephguirren/inventory_system works
Celeste Inventory is a Flask/MySQL inventory and point-of-sale application. The main workflow is staff sign-in, warehouse-scoped product and order management, and completed sales that deduct stock; dashboards and receipts expose sales results. The README also documents global/supervisor access, warehouse and personnel management, customer/VIP features, analytics, and audit logging. The sampled backend excerpt confirms database-backed dashboard, product, order, and customer operations; other documented capabilities are shown without inferring unsampled internal wiring.
Main entry points: api.js API and auth client · app.py Flask API · login.html Sign-in · dashboard.html Analytics dashboards
Components 19
Web interface
- Sign-in
frontend/login.html - API and auth client
frontend/js/api.js - Analytics dashboards
frontend/dashboard.html - Supervisor dashboard
frontend/supervisor_dashboard.html - Product management
frontend/products.html - Orders and POS
frontend/orders.html - E-receipts
frontend/receipt.html - Customer records
frontend/customers.html - Personnel management
frontend/supervisors.html - Warehouse management
frontend/warehouses.html
Application service
- Flask API
backend/app.py - Role and zone access
backend/app.py - Inventory operations
backend/app.py - POS and sales
backend/app.py - Sales analytics
backend/app.py - Customer and VIP insights
backend/app.py - Activity audit
backend/app.py
Persistent data
- MySQL database
dbase/celeste_inventory.sql
Other components
- Staff
Connections 18
- Staff → Sign-in: signs in
- Sign-in → API and auth client: uses auth
- Analytics dashboards → API and auth client: requests analytics
- Supervisor dashboard → API and auth client: requests analytics
- Product management → API and auth client: manages products
- Orders and POS → API and auth client: submits orders
- E-receipts → API and auth client: requests receipt
- Customer records → API and auth client: requests customers
- Personnel management → API and auth client: manages personnel
- Warehouse management → API and auth client: manages warehouses
- API and auth client → Flask API: calls API
- Flask API → Role and zone access: applies roles
- Flask API → Inventory operations: handles product requests
- Flask API → POS and sales: handles order requests
- Flask API → Sales analytics: handles dashboard requests
- Flask API → Customer and VIP insights: handles customer requests
- Flask API → Activity audit: records activity
- Flask API → MySQL database: queries and updates