Awarded

PHP FORM WITH SQL DATABASE TO CREATE PROPOSED OFFERS in PDF

Using PHP and MYSQL on a Web Form where in an Admin (password protected area).

We are installers and resellers of Photovoltaic Panels and our sales team requires a simple form to complete online and create a final offer that would be in PDF / printable to email to customers.

We want to include the following fields on a php page:

ALL THE FIELDS THAT OUR SALES PEOPLE SHOULD FILL UP.

1. Each of our Sales Person should have an ACCESS Account from our Admin Page and each sales person shall be logged when they access the server, time and IP and timestamps in and out and all the actions should be logged.

2. Sales person shall have the following links showing on his Admin Page:

a. My Offers (link that shows past offers that can be sorted by date, name of customer and searchable)

b. Create New Offer

c. Customers List

d. Approved Offers

3. Name of Customer or Company Name

4. Address, City, Country, Zip Code of Customer (billing info)

5. Address of Location of Solar Installation (window that will show on Google maps or Bing the location)

PRODUCTS TO BE ADDED IN OFFER:

6. Select Product A (scroll down menu with a list of 10 products)

7. Select Amount of Products (text field)

8. Select Product B (scroll down menu with list of 5 products)

9. Select Amount of Products (text field)

10. Select Product C (scroll down menu with list of 5 products)

11. Select Amount of units (text field)

12. Select Product D (scroll down menu with list of 5 products)

13. Select Amount of units (text field)

14. Select Product E (scroll down menu with list of 5 products)

15. Select Amount of units (text field)

16. Select Product F (scroll down menu with list of 5 products)

17. Select Amount of units (text field)

LOCATION WHERE SYSTEM WILL BE INCLUDED / TYPE of BUILDING or LAND:

18. SCROLL DOWN MENU

19. SIZE OF AREA TEXT FIELD

20. Must input the information in the DBS and create an an ID number of the OFFER.

21. THE FINAL RESULT WOULD BE FROM A DATABASE TO CREATE A PDF which would include the PROPOSED OFFER (the outcome of the above info) the final offer will include the products datasheets and descriptions with a formal pricing after including and adding up each item from above. For example based on their product selection we will add prices and based on type of roof and area the final cost and the offer would have to be approved by an administrator (management) in order for it to be created in PDF.

Its easy in general to create the above form for someone that already knows well PHP and MYSQL and should take about a day or two to finish it thus pricing should reasonably not be high however whoever does this part will go ahead and do other projects (expand the structure to a formal CRM) so consider your work an evaluation for future projects. I will select probably more than 1 developer to do the same project.

Bid competitively.

Skills: HTML, MySQL, PHP, Script Install, Website Design

See more: php form sql database, php form sql, create form link sql database php, create pdf sql database, proposed database php project, php sql create database billing, add sql database php, php menu create sql database, php create database pdf fields, php sql pdf, create pdf form using php database, include sql field pdf form, web developer pricing, web crm developer, sql server developer pricing, sql projects online, sql developer online, sql code pdf, projects in php and mysql, php developer pdf, php developer offer, php and mysql pdf, past code online, part time project based web developer php, online sql developer

About the Employer:
( 22 reviews ) Athens, Greece

Project ID: #1320438

7 freelancers are bidding on average €179 for this job

hatem87

I am a computer engineer. Please check PM please. Thanks.

€100 EUR in 3 days
(9 Reviews)
4.7
sunsriinfosys

Hi, I have over 13 years of Experience in software design, development and implementation of various commercial applications in Client/Server environment, Web and ERP applications using C# 1.1/2.0/3.5, ASP.Net, VB.N More

€110 EUR in 3 days
(21 Reviews)
4.4
jonesa01

Experienced PHP & MySQL Developer. I understand what you require and I am ready to start immediately. Please check your PM.

€200 EUR in 5 days
(9 Reviews)
3.8
kevinorange84

HELLO SIR PLEASE CHECK PMB

€220 EUR in 4 days
(0 Reviews)
0.0
timviecinfo

Hello Please read more than private message Thank you!

€200 EUR in 3 days
(1 Review)
0.0
harry809

HELLO SIR PLEASE CHECK PMB

€250 EUR in 5 days
(0 Reviews)
0.0
Mmonyango

I am an expert in Drupal,PHP,.NET,ASP,C#,javascript programming languages and SQL databases, and Web design in CSS,Wordpress etc. My project was produced by Regional Computers Ltd called SML VISION 2007 and SASA-PRO VI More

€175 EUR in 5 days
(1 Review)
0.0