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.