Shopping Cart Freight calculator changes - PHP and smarty

Tasks: 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 Deliverables: 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 {/if}