We need to develop a simple webpage where workers in a production area can collect data regarding batchnumbers and serialnumbers.
A product has a serialnumber and every component that is part of the product has a batchnumber or lotnumber.
There has to be a admin page where we dynamically can list what components needs to registered with a product in the production area. The admin page should have a simple login page, with simple authentication with username and password, stored in the dataabse. The list of components will grow over time
A work types in a product serialnumber, the page scans the database to search for a record for the current product. If not found, show new page where the list of components that needs to be filled in. The workers fills out the relevant data and submits the page.
If a product serialnumber is found, the page loads with all components that needs to be filled, even new ones, and loads the fields with the stored data. The worker edits the data and submits the page. The new data is saved and the changed values are preserved so that they can be included in an analysis later on if necessary.
I got a small wireframe diagram showing what we think we need. It is written on danish but I think you get the picture:
[url removed, login to view]
Click on the gridview/tiles button in the bottom right corner to see the 3 flows on the page. The first is the worker flow with a new product serial. The second is the worker flow with product serial that was found and we need to change a component. The third is the admin login and management interface to type in new components. A component can be created and being marked at not show on page. A component can have been in the system but is no longer needed this component will be marked as disabled.
I've attached a simple E/R diagram with the fields we believe is a minimum for the solution.
I hope that I've covered enough about the project so you can decide if you want to go on with the project.