Web-based DB system which of course allows management and customer login I will write what the problem is and what solution I thought and would love to hear what you think
I need to build-DB of machinery.
Which is linked to certain customers
For example, engine 400G machine X345L
Filter LS567. Oil 45LR. Located at the customer John Doe
Client (eg there are many clients) send samples of oil to the laboratory.
The oil is collected in special bottles that they have a barcode on the bottle
I enclose you an example of questions that need to fill by the customer. See JPG
I want to establish a database where I get all the customer data
Under each client I want to establish a database of machines and oils and geographical location.
The data that I put myself. Not usually change by the customer if there is a change I /administrator changed it himself
So far so simple, even I can do it. :)
After building this system for the Internet (with an interface that users with password can log online and enter the data as in PDF)
I want to build a smart phone application. To iPhone / Android
And integrate this component
[url removed, login to view]
The main idea is issuing QR code for a specific customer-specific machine
And therefore to a customer who has two machines of the same type. Are two Different QR code
After the First After the system has identified the customer and his specific machine - the application will ask the customer
to Do another scan The additional scan will be performed on the bottle
After everything was received as intended. Customer should answer a few questions such as:
Is was drying - the client will answer yes or no. And other similar questions .And a place to leave comments
After the client click OK. All data will concentrate on the system,
When you type the number that is on the bottle. A screen will appear containing all relevant data.
Please send examples of work you have done.
Please send offers only if you have a minimum of 15 full feedbacks.
Note that a quarter of the money will be accepted only after two months of the end of work and after fixing all the bugs.
Sorry for the inconvenience.
Payment of course. Be paid when you are done. Through a milestone system - a quarter of the money will be released only after two months
Thanks everyone for the time you put into writing the proposal.