Shopping Cart Freight calculator changes - PHP and smarty

Avg Bid (NZD)
Project Budget (NZD)
$250 - $750

Project Description:
1) Modify an existing shopping cart freight calculator to apply an extra $3 charge for addresses identified by there post codes to be Rural
2) The post code (zip code) entered by the user at checkout will be compared with a SQL database table to identify post codes that are rural
3) The checkout process will add the Rural Delivery charge and clearly inform the user of the extra charge at the final stages of the checkout process (just prior to customer confirming order)
4) At order confirmation an e-mail is sent to the customer with the order details. This will be modified to include and display the RD charge
5) At order confirmation an e-mail is sent to the on-line stores e-mail with the order details. This will be modified to include and display the RD charge
6) The e-mails sent to the customer and on-line store address need changing to deal with situations where freight is not defined, preferably with a BOOLEAN switch that can be used by other parts of code in future. This would be BOOLEAN freight defined or undefined.
a) Where freight is defined send the customer and on-line an store e-mail e-mail confirming freight and how to complete payment
This will occur where the current freight calculator calculates freight sucessfully

b) Where freight is un-defined send to the customer and on-line store and e-mail e-mail saying freight will be confirmer (existing code sends this)
This will occur where;
- Freight is international
- The freight calculator returns the result "To be confirmed"

7) The address details entered by the customer in the order process should remember details for returning customers. Using a cookie?

The Website uses SQL databases, PHP and smarty.

All work wil be done locally of-line, or via a mirror development site.
Work and testing must not be on the live site

The SQL database of Rural Post codes will be supplied.

Modification of these requirements may be allowed by mutal agreement by both parties if the requirement are impratical

1) Comments, questions and suggestions by the winning bidder of how best to implement these tasks
2) An outline by the winning bidder of how the final result will look and work (a milestone)
3) A record of changes made and finished and tested files (project completion)
4) After completion, testing and acceptance of changes made to the development site changes will be migrated to the live site

An incomplete snipet of the existing freight calculator based on weight and volume;

{if $total_size < 500}$4.00 {assign var=total_price value=`$total_price+4`}
{elseif $total_size < 1200}$6.00 {assign var=total_price value=`$total_price+6`}
{elseif $total_size < 3400}$7.00 {assign var=total_price value=`$total_price+7`}
{elseif $total_size < 3800}$8.00 {assign var=total_price value=`$total_price+8`}
{elseif $total_size < 7500}$10.00 {assign var=total_price value=`$total_price+10`}
{elseif $total_size < 40000}$10.00 {assign var=total_price value=`$total_price+10`}
{else}To be<br>Confirmed

Skills required:
MySQL, PHP, Shopping Carts, Smarty PHP, Website Design
Hire jimjimminy
Project posted by:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 1050
in 30 days
$ 1000
in 8 days
$ 875
in 7 days
$ 888
in 7 days
$ 500
in 7 days
$ 550
in 5 days
$ 450
in 15 days
$ 750
in 20 days
Hire devloperIT
$ 700
in 3 days
$ 550
in 12 days