This is a Mailroom Management tool was made out of necessity for my current job.
The problem, we get to many packages and we dont know how many each person has.
Lable each package with its unit number and (QR code see below) Add each new package to a database (SQL) keep track of how many packages each unit has Send email to inform of package Remove package form DB with QR code
This project will use:
- Raspberry pi 3
- pi cam v2
- Micro sd (8GB)
- Power (Micro USB)
- Keyboard
- Monitor
- Thermal Printer
Input
- Package comes in
- User adds package to unit through CLI (Ex. 705 1) (GUI in V2)
- System adds package to unit then prints a QR code with unit number on sticker (QR tells DB to remove 1 from that unit Check Out)
- User adds sticker to package then stores on shelf
- System will send email to units with and updated package total (HTML) (Can be configured to only send from direct User input) (System Backend V2)
Output
- User asks system to show units packages (Ex. show 705)
- System will print units packages (Ex. 705 => 2 Packages)
- User will get packages and scan into system
- System will remove each package from Units package total