QR Code Beverage Authenticator App
Budget: $250 – $750 USD
Here is a concise technical overview suitable for initial contractor onboarding and UML diagram creation:
---
### **Project Title:** QR Code Beverage Tracking System
### **Objective:**
Develop a role-based system to track every beverage bottle from warehouse intake to final sale using QR codes and handheld Android (Netum) scanners, ensuring alignment with regulatory requirements and minimizing manual work through process automation.
---
### **Core Functional Modules:**
1. **Warehouse Module**
* Scan QR codes of incoming bottles
* Save entries in the central database with status: `WAREHOUSE`
* Duplicate validation and logging of scan events
2. **Barmen Module**
* Transfer bottles to the bar via QR scan (status updated to `BAR`)
* Option to scan again on sale or rely on backend update via IIKO export
* All actions logged
3. **Admin Web Panel**
* CRUD for users and bottle records
* Upload IIKO sales reports to automatically match and mark bottles as `SOLD` (FIFO logic by product)
* Perform and log physical inventory (inventarisation)
* Generate mismatch alerts and export QR codes for manual submission to SOLIQ
4. **CEO Dashboard**
* View high-level metrics: total received, sold, in-bar, accuracy %
* Visual representations and read-only database access
---
### **Database Design (Centralized):**
* Single `bottles` table with unique QR code and `status` (`WAREHOUSE`, `BAR`, `SOLD`)
* `events` table (immutable audit trail for all actions)
* `users` table with role-based access control
---
### **Technological Stack (Proposed):**
* **Backend:** FastAPI (Python)
* **Frontend:** Flutter (mobile), React (web)
* **Database:** PostgreSQL
* **Devices:** Netum Android barcode terminals
* **Authentication:** JWT-based or integrated identity provider
---
---
### **Project Title:** QR Code Beverage Tracking System
### **Objective:**
Develop a role-based system to track every beverage bottle from warehouse intake to final sale using QR codes and handheld Android (Netum) scanners, ensuring alignment with regulatory requirements and minimizing manual work through process automation.
---
### **Core Functional Modules:**
1. **Warehouse Module**
* Scan QR codes of incoming bottles
* Save entries in the central database with status: `WAREHOUSE`
* Duplicate validation and logging of scan events
2. **Barmen Module**
* Transfer bottles to the bar via QR scan (status updated to `BAR`)
* Option to scan again on sale or rely on backend update via IIKO export
* All actions logged
3. **Admin Web Panel**
* CRUD for users and bottle records
* Upload IIKO sales reports to automatically match and mark bottles as `SOLD` (FIFO logic by product)
* Perform and log physical inventory (inventarisation)
* Generate mismatch alerts and export QR codes for manual submission to SOLIQ
4. **CEO Dashboard**
* View high-level metrics: total received, sold, in-bar, accuracy %
* Visual representations and read-only database access
---
### **Database Design (Centralized):**
* Single `bottles` table with unique QR code and `status` (`WAREHOUSE`, `BAR`, `SOLD`)
* `events` table (immutable audit trail for all actions)
* `users` table with role-based access control
---
### **Technological Stack (Proposed):**
* **Backend:** FastAPI (Python)
* **Frontend:** Flutter (mobile), React (web)
* **Database:** PostgreSQL
* **Devices:** Netum Android barcode terminals
* **Authentication:** JWT-based or integrated identity provider
---