Write a Web Utility for Inventory Process

We need a web utility for an inventory process. We will have the user import a 'master' inventory list. They will walk the store and scan items. This utility is checking the scanned items against the 'master' list, displaying results and saving that info to a database, which then can be exported. We included an example file that has been directly exported by our software. We would prefer to not have to do anything to this file. Here's what we're expecting: -reads a file exported from our software -user scans upcs -tries to find a match in the original file -if it doesn’t, it returns an error: Scanned Item Not Found. Try Again. user must hit OK to continue -if it does, it returns the product attributes: -SKU, product name, UPC, amount in stock, product status -User will be asked to select a reason -The product info and reason, along with the date and time of the scan and the user, will be saved in a table (i refer to it as “scan database”) which can be only accessed by Admins. It can be exported to CSV by admins. Scan Database Contents Date of Scan Time of Scan User UPC* SKU* Product Name* Amount in Stock* Reason Current import file imported date *this data comes from the imported file Reason Table. (no reasons can be deleted, just hidden. Reasons can be reordered to display in certain order when prompted) Reason ID Reason Name Visible Order Functions Load a new file. File data should be cleared after 12 hours automatically. User can’t do the scan process without a new file. If the file is > 4 hours, it should warn the user that the file is old. Start New Scan. If a new file is present, the user can start scanning products. A new file is <4 hours old (from import date). If not, it will warn the user. They CAN still scan with an old file. Scan process is outlined above (and below). each scan line will be added to the table. items will be displayed for the user until the user selects to clear that data. Clear Data. This will prompt the user “This will clear the current view. Are you sure?” The displayed data will go away, the line items will stay in our scan database, but the imported file will remain. Complete Scan. This will prompt the user “This will clear the view and clear the inventory file. Are you sure?” The imported file will be removed, the display will be cleared, the user will return to the “home” screen Admin - Add User Admin - Remove User Admin - Add/Edit/Hide “Reasons” Admin - View/Download Database data (allow filters for range of dates to be downloaded) Admin - Delete database data (allow filters for range of dates to be deleted) Requirements for UI -Needs to be minimal (for ios/ipad display) and responsive -Web based - user will load file from a desktop, then access the app from mobile. -Time is EST (we are in NY) Algorithm: -Loads File -Scans UPC -UPC Found? -Yes -Prompt User For Reason -Reason Table (can change names, can’t delete, can hide) -Amount in stock 0? -Yes - Add to scan database, display -No - Add to scan database, display in Red Background, White Font -No -Display Error on screen WILL NEED MOCKUPS PRIOR TO START PROGRAMMING