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.