QR Code-based Dispatch Verification System

We need a simple, localized web-based portal for a trucking company to verify that drivers are picking up the correct trailers. The system will generate a QR code at dispatch which security will later scan at the gate to confirm the trailer number against their physical observations.
Scope of Work
Dispatcher Dashboard (The Generator):
A simple web interface for dispatchers to enter: Driver Name, Truck #, and Trailer #.
Action: System generates a unique record in a local database and produces a printable QR code.
The QR code should encode a URL pointing to that specific record on the local network.
Security Gate Portal (The Verifier):
A "Security View" optimized for tablets or rugged PCs.
When security scans the driver's QR code, the portal must instantly display the Expected Trailer Number in large, bold text.
Manual Confirmation: Security will look at their existing camera monitors (manual check) and click an "Approved / Confirm Exit" button on the portal.
The portal must log the exact date and time of the confirmation for auditing.
Audit Log / Reporting:
A simple table view for management to see all completed "Checkouts," showing the timestamp, driver, and trailer number.
Technical Requirements
Language: Python (Flask or Django) or Node.js preferred.
Database: SQLite or MySQL (must be lightweight and run on a Windows PC).