Project Description
I need a lightweight, cross-platform mobile application built with Framework7 and Apache Cordova that lets staff scan Code 128 barcodes with the device camera, record those scans as raw-material movements, and instantly sync everything to a MySQL database running on 192.168.1.200 (all devices sit on the same LAN).
On first launch the app should present a username-and-password screen; once authenticated, users can open the scan view, point the camera, and have the barcode value, time stamp, and logged-in user written to the database through a REST endpoint. Please rely on a proven Cordova barcode-scanner plugin so no custom native code is required.
Alongside the app I also need a small, web-based admin console. From any browser on the same network I should be able to
• view real-time inventory levels for every raw material, and
• create, edit, or disable user accounts.
No other reporting is required at this stage.
The project is complete when:
1. An Android APK and iOS build archive run smoothly on current OS versions.
2. The admin panel displays live data pulled from the local MySQL instance.
3. Source code is handed over (Framework7 project, Cordova config, SQL schema, and simple setup notes).
If you have recent experience with Framework7 + Cordova barcode scanning and MySQL connectivity on LAN-based deployments, this should be a straightforward, quick win for both of us.