I need a section of a website to be created to allow engineers in the field to request parts.
The site needs to be able to have the parts list updated easily by uploading either a csv or xls file in a format we will specify.
It needs user access control as we only want authorised people to be able to access it and place an order.
Once a user has logged in then he is not needed to re enter his details. Rather the site will on every page show his name to confirm his identity.
He will be given a list of products, some of which may have photos. He can select a quantity he wants for each item with the default being 1. He must however also enter against each item he is ordering what job he used the items on. This needs to allow for up to 150 characters.
When he has selected all the items he is to be shown a summary page and also given 2 delivery options. Option 1, to ship to his default address. If he selects this option then there is nothing further he needs to enter. Option 2, to ship to an alternate address. He then needs to be asked to fill in the address details - contact name? company/site name,? address line 1, address line 2, Town, County, postcode. The contact name is to be prefilled in as his name, but can be changed by him if needed. He is also to be given the option to select when to be delivered. The delivery option is to be 2 working days from the current system date. Hence if he was to order on Friday, he would be given the earliest next delivery date of the following Tuesday.
User details are to be gained from the user database of our seperate PHP/SQL based filestore.? We are to have the option of selecting which user groups and users can order from our stock requisition site.
Once a user has completed his order he will click a button and this order will be both recorded on the server and also emailed to a nominated email address. Within the email will be the following information:
date order placed, name of person placed order, date delivery requested for, address (either the default taken from the filestore user details, or the alternate address they entered.) It will also show their phone and email addresses, again taken from the filestore user database. It will next show a neat list of Quantity, Part code? then description, and then where the item was used/needed for.