Add Stage Check Feature

Job ID: 40081940

Budget: $30 – $250 USD

I have an Android QR-code scanner used every day on Honeywell handhelds in our warehouse. The workflow is solid, yet operators sometimes miss a scan point; the mistake only surfaces later when the SQL backend shows an unexpected 0 or 1 in the stage field.

What I need now is a validation layer inside the existing app:

• After every successful scan, the app should run a lightweight SQL query (I’ll provide the exact table, field, and connection details) to discover the next expected stage.
• If the value reveals that a stage was skipped, the screen must clearly state which stage is missing and block further action until the user taps a “Confirm & Continue” button.
• Both Admins and Employees will see the prompt; their acknowledgement must be logged the same way other scans are recorded.

Deliverable: updated APK and source code that compile without warnings in our current Android project, plus a short read-me explaining any new classes, database calls, and UI elements. When the app flags a skipped stage, the confirmation flow should trigger in under one second on a typical Honeywell device.