I am looking to create a Test website that will pull in data from an MS SQL database. Initially, it can be populated manually, with the intent of syncing it with our database at a later date. The website will initially be very basic without much design or flair. The website must be able to export information from the database that will be printed on ID cards. This will include a picture & generating a QR code from database information. The requirements for this will be determined at a later date, but would likely just be a PDF generation.
The site will require User Account Creation and access. The site must be able to be able to generate email & text alerts when triggered. Although, this could likely be handled at a database level.
The website will need to be able to get information from a scanner that will read QR codes. I would assume this would be handled by the software of the scanner, but not exactly sure on the execution of this.
The Iphone & Android mobile apps will require account login & creation that are synced with the website. The apps must be able to scan bar-codes & QR codes, as well as save data for date, time, and geolocation when the scanning takes place. There will likely be no cell service or wifi many times the app is used, so local storage of information & uploading when an internet connection is available is a must.
This is for a proof of concept, so design would be very basic. If the system works well, there may be opportunity to create a much better design and more robust features.