In Progress

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 [url removed, login to view]

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 [url removed, login to view]

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 [url removed, login to view] . 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.

Skills: PHP

See more: you by your numbers, us car online, top member, top 10 data entry company, thank you letters, thank you later, take off service, see my clients, referred from, quotation service, please enter your password, online car site, online car code, my correct address, log company, i was referred by, get found now, first supply, enter email get password, enter email address and get password, direct update, direct supply, delete quote, data entry quotation, database administrator online course

About the Employer:
( 520 reviews ) Chelmsford, United Kingdom

Project ID: #41282

Awarded to:

eccentricworld

hi, we can do this in good manner. regards sri

$225 USD in 8 days
(63 Reviews)
6.5

15 freelancers are bidding on average $195 for this job

siddhartha1

Hello, this would cost you more than $300,pls evise your budget range,thanx

$300 USD in 10 days
(35 Reviews)
7.6
noiresol

Dear sir, We offer an outstanding value added services and high degree of quality at very competitive prices. Norsol is equipped with creative designers , professional programmers and business analysts to give cutt More

$200 USD in 10 days
(28 Reviews)
6.4
kasoft

Hi, I am an experienced programmer so I can assure you that you will get the best for your money. Your project details are more than cristal clear and requests can be completed in four days for the requested amount. More

$140 USD in 4 days
(13 Reviews)
5.6
elfuerte

Can start immediately and get it completed in 48 hours or less.

$150 USD in 0 days
(25 Reviews)
5.0
brunobfB

Hi! Please check PMB

$200 USD in 5 days
(25 Reviews)
4.9
seanboy

Hey Guy, No Prob, I have massive experience with php/mysql/paypal and can easily build you the perfect solution.

$150 USD in 1 day
(13 Reviews)
4.6
bloodyveins

hello, i'm interested in providing solution for this. please check pmb for more details. regards,

$165 USD in 3 days
(28 Reviews)
4.4
bentaylor

Please see PMB.

$175 USD in 2 days
(5 Reviews)
3.4
svitja

Thanks, I can help with this project.

$110 USD in 7 days
(1 Review)
1.4
SORCIM

HI, We are a rapidly growing software development company. We have excellent and hardworking employees. We understood your given requirements .we can accomplish this task in real Elegant manner in 7 days and we assur More

$275 USD in 7 days
(5 Reviews)
1.5
manjulagrawal

I have gone through your requirement and found my profile perfect and can do this for you within 7 days with challenge. I have team of 260 developers from top CMM 5 level company's working for me as a freelancer and ev More

$300 USD in 7 days
(0 Reviews)
3.0
jiju

Quality work at affordable cost :)

$200 USD in 7 days
(0 Reviews)
0.0
muhammadaqeel

After getting all the information from your side the site will be completed between 8 to 10 days.

$111 USD in 18 days
(0 Reviews)
0.0
alyosha

we can do it plz check PMB

$230 USD in 7 days
(0 Reviews)
0.0