MYSQL Ajax product quotation form

From the details provided below create an optimised mysql database with appropriate indexes.

Create an ajax form to query and obtain results from the database to build a product quote.

Store the quote in the database which can be retrieved by quote number or email address.

Send the quote to email address if required.

A more detailed specification is shown below and provides enough information to do the work.

Please ask questions only if something is not clear.

PLEASE DO NOT MAKE PLACEHOLDER BIDS, I just ignore them and are a waste of my time.

Please read carefully before making a bid.

I will want this to look pretty and a nice email layout too.

This should take an experienced developer just a few hours.

Database: Quote System

Table Name: print_area

Fields: id, area_name, measurement_units, width, height, sort_order

Notes:

measurement_units is a choice between cm and inches

Sample data:

1, A1, cm, 59.4, 84.1, 1

2, A2, cm, 42.0, 59.4, 2

3, A3, cm, 29.7, 42.0, 3

4, A4, cm, 21.0, 29.7, 4

5, A5, cm, 14.8, 21.0, 5

6, A6, cm, 10.5, 14.8, 6

Table Name: print_positions

Fields: id, position_name, print_area.area_name, sort_order

Notes:

print_area.area_name is selected from print_area table

area_name is unique

Sample data:

1, Left Breast, A6, 1

2, Centre Front, A4, 2

3, Right Sleeve, A6, 3

Table Name: print_styles

Fields: id, style_name, sort_order

Notes:

style_name is unique

Sample data:

1, Digital, 1

2, Screen Printing, 2

Table Name: price_band

Fields: id, price_band_name, print_styles.style_name, print_area.area_name, price_band_start, price_band_end, sort_order

Notes:

print_styles.style_name comes from Table print_styles

print_area.area_name, comes from print_area table.

price_band_name is unique

Sample data:

1, PB1, Digital, A1, 1, 10, 1

2, PB2, Digital, A1, 11, 25, 2

3, PB3 Digital, A4, 26, 100, 3

Table Name: setup_costs

Fields: id, print_styles.style_name, cost_type, setup_cost, sort_order

Notes:

print_styles.style_name comes from Table print_styles

cost_type is a choice between per_design or per_colour

Sample data:

1, Digital, per_design, 10.00, 1

2, Screen Printing, per_colour, 20.00 2

Table Name: production_costs

Fields: id, price_band.band_name, production_cost, supplementary_colour_cost, sort_order

Notes:

price_band.band_name is from price_band table

1, PB3, 6.00, 2, 1

2, PB2, 10.00, 2, 2

Notes:

setup_cost

if cost_type = per_design, then setup_cost = (setup_cost * 1)

if cost_type = per_colour then setup_cost =(setup_cost * colours)

formula to reach final cost.

(setup_cost + ((production_cost +supplementary_colour_cost)*quantity))

Ajax Quote Form Required

Print Style = $style_name

Print Position $position_name

Quantity = $quantity

Number of Colours = $colours

Return result

$style_name on the $position_name in $colours Colour/s would cost £00.00 plus VAT Total cost Including VAT £00.00 for $quantity items (Delete Button)

Add another position or save and email

$style_name on the $position_name in $colours Colour/s would cost £00.00 plus VAT Total cost Including VAT £00.00 for $quantity items (Delete Button)

$style_name on the $position_name in $colours Colour/s would cost £00.00 plus VAT Total cost Including VAT £00.00 for $quantity items (Delete Button)

Add another position or save and email

Quote to be given number and saved to DB & can be retrieved by quote number or email address.

AJAX CSS HTML5 MySQL PHP

Project ID: #8273700

About the project