tax_and_shipping.php

<?php
global $wpdb;
$changes_made = false;

  
// function country_list($selected_country = null)
//   {
//   global $wpdb;
//   $output = "";
//   $country_data = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_CURRENCY_LIST."` ORDER BY `country` ASC",ARRAY_A);
//   foreach ($country_data as $country)
//     {
//     $selected ='';
//     if($selected_country == $country['isocode'])
//       {
//       $selected = "selected='true'";
//       }
//     $output .= "<option value='".$country['isocode']."' $selected>".$country['country']."</option>";
//     }
//   return $output;
//   }
  
if(preg_match("/[a-zA-Z]{2,4}/",$_GET['isocode']))
  {
  $country_isocode = $_GET['isocode'];
  }
  else
    {
    $country_isocode = get_option('base_country');
    }
$base_region = get_option('base_region');
?>
<div class="wrap">
  <h2><?php echo __('GST/Tax Rate', 'wpsc');?></h2>
  <?php
  if($changes_made === true)
    {
    echo "Thanks, your changes have been made<br />";
    }

  ?>

  <form action='' method='post' name='regional_tax'>
  <?php
  $country_data = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `isocode` IN('".$country_isocode."') LIMIT 1",ARRAY_A);
  if(($country_data['has_regions'] == 1))
    {
    $region_data = $wpdb->get_results("SELECT `".WPSC_TABLE_REGION_TAX."`.* FROM `".WPSC_TABLE_REGION_TAX."` WHERE `".WPSC_TABLE_REGION_TAX."`.`country_id` IN('".$country_data['id']."') ",ARRAY_A) ;
    $region_data = array_chunk($region_data, 14);
    
    echo "<table>\n\r";
    echo "  <tr>\n\r";
    foreach($region_data as $region_col)
      {
      echo "    <td style='vertical-align: top; padding-right: 3em;'>\n\r";
      echo "<table>\n\r";
      foreach($region_col as $region)
        {
        $tax_percentage =  $region['tax'];
        echo "  <tr>\n\r";
        if($region['id'] == $base_region)
          {
          echo "    <td><label for='region_tax_".$region['id']."' style='text-decoration: underline;'>".$region['name'].":</label></td>\n\r";
          }
          else
            {
            echo "    <td><label for='region_tax_".$region['id']."'>".$region['name'].":</label></td>\n\r";
            }
        echo "    <td><input type='text' id='region_tax_".$region['id']."' name='region_tax[".$region['id']."]' value='".$tax_percentage."' class='tax_forms'  size='2'/>%</td>\n\r";
        echo "  </tr>\n\r";
        }      
      echo "</table>\n\r";
      echo "    </td>\n\r";
      }
    echo "  </tr>\n\r";
    echo "</table>\n\r";
    }
    else
      {
      $tax_percentage =  $country_data['tax'];
      echo "<label for='country_tax'>Tax Rate:</label> ";
      echo "<input type='text' id='country_tax' name='country_tax' value='".$tax_percentage."' class='tax_forms' maxlength='3' size='3'/>%";
      }
  ?>
  <input type='hidden' name='wpsc_admin_action' value='change_region_tax' />
  <input class='button-secondary' type='submit' name='submit' value='<?php echo __('Save Changes', 'wpsc');?>' />
  </form>
</div>