Web App for QR Code Validation

Job ID: 39222266

Budget: ₹75,000 – ₹150,000 INR

I'm seeking a web developer to create a browser-based web application for me. This app will periodically ingest and parse Excel files into a MySQL database. The Excel files will be in XLS format. The application will also need to connect to a PLC via OPC UA to validate QR codes that are scanned by a device and exchange PASS/FAIL test results.

Key Requirements:
- The frontend should be built in React and use WebSockets to display real-time, station-specific data on two monitor instances (Station 1 & Station 2).
- The backend should be developed with Flask and utilize a Python OPC UA client to handle data synchronization, database updates, and OPC UA communication.
- The solution must be capable of running on-premise and include a stubbed OPC UA server for testing.
- The code must be fully documented, include automated tests, and come with deployment scripts.

Ideal Skills and Experience:
- Proficiency in MySQL, React, Flask, and Python.
- Experience with OPC UA communication.
- Familiarity with data visualization in web applications.
- Ability to deliver well-documented code and automated tests.
- Experience with creating on-premise solutions.

---

Above is generated by AI of freelancer website. For more tech details , please find my PRD attached. Please check that and quote. To avoid spam, I have inserted a generic question, and request bidders to start their bid by answer to that question which would then help me filter for them.

I had similar but smaller requirement which I posted earlier earlier, but further conversation with client led to major changes, including major requirements of coordinating with PLCs as well. This PRD covers the IT part of total system. For OT part, I may post separately.
Related categories: MySQL Node.js SQLite React.js FastAPI