I would like to have an online database that allows shops to login and register customer warranties. The shop should be able to login and input the customer details and warrenty information. When an online warranty form is completed, the shop should be shown a unique activation code. The activation code needs to be unique and automatically created, but only when a warranty form has been completed fully. Each completed customer warranty needs to be printable. Shops should be able be able to view all their warranties completed and uncompleted, but must not be able to modify completed warranties.
An admin account needs to be able to view/edit all shop warranties and be able to create shop accounts. Useful static widgets showing warranties per month, week and type should be viewable.
The database will only have around 20 fields to cover the customer and product warranty details. I want the site to use a jquerry/ajax front end. I have provided more detail in the attached pdf.