Adding to members area

We have a secure members area on my clients website which I need some pages adding to. I have designed the look of most of the pages and just need the functionality adding to it. The site works on PHP with a MySql database. The first page is opal-quotation-request.php. 1) This page has a form on it which when completed and the next button is clicked needs to enter the information into the database into a request quote table which holds all the request quotations. The Request Quotations table does not yet exist. 2) As the member is already logged on to get into this area and for the most part, we have their address, telephone number etc these details need to appear in the fields on the form. Then if the user wants to edit these details they can, but if they are correct then they can simply leave them as they are. 3) The fields marked with a * need to have validation on them to make sure they complete them correctly. The email address needs to be the correct syntax for an email address and not just some random letters and numbers. 4) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. 5) When they have finished the form they will click Next. This needs to insert the data into the Request Quotations table and then take the user to the next page, opal-quotation-request2.php. 6) On this page there are 6 drop down menus. These at present are static, but we need to make them so they run off a database with all the options in it. This is so we can update them, add, edit and delete options ourselves. There will need to be another page to enable us to do this, but I will come to that later. 7) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. 8) When they have finished the form they will click Next. This needs to insert the data into the Request Quotations table and then take the user to the next page, opal-quotation-request3.php. 9) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. 10) When they have finished the form they will click Submit. This needs to insert the data into the Request Quotations table and then take the user to the thank you for your Quotation request page. Also an email needs to be sent to the administrators email address and needs to say the following. ( I will explain later about the administrators email address) You have a new Quotation Request from “username” at “Company Name”. Please check the website for details. Click here (the click here needs to link to [login to view URL] 11) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. The next part starts with the page opal-reseller-order.php. 1) This page has a form on it which when completed and the next button is clicked needs to enter the information into the database into a Reseller Order table which holds all the reseller orders. The Reseller Order table does not yet exist. 2) As the member is already logged on to get into this area and for the most part, we have their address, telephone number etc these details need to appear in the fields on the form. Then if the user wants to edit these details they can, but if they are correct then they can simply leave them as they are. 3) The fields marked with a * need to have validation on them to make sure they complete them correctly. The email address needs to be the correct syntax for an email address and not just some random letters and numbers. 4) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. 5) When they have finished the form they will click Next. This needs to insert the data into the Reseller Orders table and then take the user to the next page, opal-reseller-order2.php. 6) On this page there are 6 drop down menus. These at present are static, but we need to make them so they run off a database with all the options in it. This is so we can update them, add, edit and delete options ourselves. There will need to be another page to enable us to do this, but I will come to that later. 7) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. 8) When they have finished the form they will click Next. This needs to insert the data into the Resellers Order table and then take the user to the next page, opal-reseller-order3.php. 9) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. 10) The fields marked with a * need to have validation on them to make sure they complete them correctly. The email address needs to be the correct syntax for an email address and not just some random letters and numbers. 11) When they have finished the form they will click Submit. This needs to insert the data into the Resellers Orders table and then take the user to the thank you for your order page. Also an email needs to be sent to the administrators email address and needs to say the following. ( I will explain later about the administrators email address) You have a new Order from “username” at “Company Name”. Please check the website for details. Click here (the click here needs to link to [login to view URL] 12) This page is part of the secure members area so if someone was to type in the url for this page it needs to direct back to the login page, unless of course they are already logged in. The code to do this is at the top of all the other existing pages. These are the 2 online form pages done. The members area also has an administrators area which can be found at [login to view URL] . In this area currently we can view, set up, edit and delete users. We can also change the user name, password and email address for the administrator. The email address for the administrator is the one that I referred to earlier, the one to send the email to telling them that they had an order or quotation request. We now need to add a few sections to this. The first section is a way of viewing Quotation Requests. 1) We need a link to the View Quotations page on the first page you view when you log into the administrators area. 2) When you click this link it should have a list of all the quotation requests with the newest first. 3) For each entry in the list it should say: unique quotation id, company name, user name, date and a link to view the full details. 4) You should only show quotations in this list where all pages in the quotation form have been completed. So in other words if the user only got to page 2 of the form and abandoned it by closing the browser, then the entry should now appear in the list. The next page is the Quotation Request Details Page. So when they click on an entry in the list to see view the full details this is the page that should appear. 1) You need to first have a table which displays all the company details and user details. 2) The next table should display all the quotation information collected in the Quotation Request Forms. The second section is a way of viewing Reseller Orders. 5) We need a link to the View Orders page on the first page you view when you log into the administrators area. 6) When you click this link it should have a list of all the orders with the newest first. 7) For each entry in the list it should say: unique order id, company name, user name, date and a link to view the full details. 8) You should only show orders in this list where all pages in the order form have been completed. So in other words if the user only got to page 2 of the form and abandoned it by closing the browser, then the entry should now appear in the list. The second page is the Order Details Page. So when they click on an entry in the list to see view the full details, this is the page that should appear. 3) You need to first have a table which displays all the company details and user details. 4) The next table should display all the quotation information collected in the Order Forms. The Third section to add is a page on the administrators area where we can add, edit or delete the options in the Car Kits, GPS Solution, Tracking, Navigation, Service and Supply Only drop down menus. There needs to be a link to this page on the first page you come to when you log into the administrators area. To recap this section needs enable us to add options to a particular drop down; to be able to view and edit the options of a particular drop down menu; and also to view and delete options from a particular drop down menu.