관리-도구

편집 파일: aupost.php

<?php
/*
  Copyright (c) 2007-2009 Rod Gasson / VCSWEB
 
    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    any later version.

This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.

$Id: aupost.php,v1.0  May 2012

var_dump(get_defined_vars());
*/

// class constructor

class aupost extends base
{

// Declare shipping module alias code
   var $code;

// Shipping module display name
   var $title;

// Shipping module display description
    var $description;

// Shipping module icon filename/path
   var $icon;

// Shipping module status
   var $enabled;

function aupost()
{
    global $order, $db, $template ;

// disable only when entire cart is free shipping
    if (zen_get_shipping_enabled($this->code))  $this->enabled = ((MODULE_SHIPPING_AUPOST_STATUS == 'True') ? true : false);

$this->code = 'aupost';
    $this->title = MODULE_SHIPPING_AUPOST_TEXT_TITLE ;
    $this->description = MODULE_SHIPPING_AUPOST_TEXT_DESCRIPTION;
    $this->sort_order = MODULE_SHIPPING_AUPOST_SORT_ORDER;
    $this->icon = $template->get_template_dir('aupost.jpg', '' ,'','images/icons'). '/aupost.jpg';
    if (zen_not_null($this->icon)) $this->quotes['icon'] = zen_image($this->icon, $this->title);
    $this->logo = $template->get_template_dir('aupost_logo.jpg', '','' ,'images/icons'). '/aupost_logo.jpg';
    $this->tax_class = MODULE_SHIPPING_AUPOST_TAX_CLASS;
    $this->tax_basis = 'Shipping' ;    // It'll always work this way, regardless of any global settings

if (MODULE_SHIPPING_AUPOST_ICONS != "No" )
	 {
        if (zen_not_null($this->logo)) $this->title = zen_image($this->logo, $this->title) ;
    }

$this->allowed_methods = explode(", ", MODULE_SHIPPING_AUPOST_TYPES1) ;
}

// class methods
//////////////////////////////////////////////////////////////

function quote($method = '')
{
    global $db, $order, $cart, $currencies, $template, $parcelweight, $packageitems;
	$module = substr($_SESSION['shipping'], 0,6);
	$method = substr($_SESSION['shipping'],7);

if (zen_not_null($method) && (isset($_SESSION['aupostQuotes'])))
    {
        $testmethod = $_SESSION['aupostQuotes']['methods'] ;

foreach($testmethod as $temp) {
            $search = array_search("$method", $temp) ;

if (strlen($search) > 0 && $search >= 0) break ;
            }

$usemod = $this->title ; 
		$usetitle = $temp['title'] ;

if (MODULE_SHIPPING_AUPOST_ICONS != "No" )
        {  // strip the icons //
            if (preg_match('/(title)=("[^"]*")/',$this->title, $module))  $usemod = trim($module[2], "\"") ;
            if (preg_match('/(title)=("[^"]*")/',$temp['title'], $title)) $usetitle = trim($title[2], "\"") ;
        }

$this->quotes = array
        (
            'id' => $this->code,
            'module' => $usemod,
            'methods' => array
            (
                array
                (
                    'id' => $method,
                    'title' => $usetitle,
                    'cost' =>  $temp['cost']
                )
            )
        );

if ($this->tax_class >  0)
        {
            $this->quotes['tax'] = zen_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
        }

return $this->quotes;   // return a single quote

}  ////////////////////////////  Single Quote Exit Point //////////////////////////////////

// Maximums
    $MAXWEIGHT_P = 20 ; // 20kgs
    $MAXLENGTH_P = 105 ;  // 105cm max parcel length
    $MAXGIRTH_P =  140 ;  // 140cm max parcel girth  ( (width + height) * 2)

// default dimensions //
    $x = explode(',', MODULE_SHIPPING_AUPOST_DIMS) ;
    $defaultdims = array($x[0],$x[1],$x[2]) ;
    sort($defaultdims) ;  // length[2]. width[1], height=[0]

// initialise variables
    $parcelwidth = 0 ;
    $parcellength = 0 ;
    $parcelheight = 0 ;
    $parcelweight = 0 ;
    $cube = 0 ;

$frompcode = MODULE_SHIPPING_AUPOST_SPCODE;
    $dest_country=$order->delivery['country']['iso_code_2'];
    $topcode = str_replace(" ","",($order->delivery['postcode']));
    $aus_rate = (float)$currencies->get_value(AUD) ;
    $ordervalue=$order->info['total'] / $aus_rate ;
    $tare = MODULE_SHIPPING_AUPOST_TARE ;

$FlatText = " Using AusPost Flat Rate." ;

// loop through cart extracting productIDs and qtys //

$myorder = $_SESSION['cart']->get_products();
 
    for($x = 0 ; $x < count($myorder) ; $x++ )
    {
        $t = $myorder[$x]['id'] ;
        $q = $myorder[$x]['quantity'];
		$w = $myorder[$x]['weight'];
 
        $dim_query = "select products_length, products_height, products_width from " . TABLE_PRODUCTS . " where products_id='$t' limit 1 ";
        $dims = $db->Execute($dim_query);

// re-orientate //
        $var = array($dims->fields['products_width'], $dims->fields['products_height'], $dims->fields['products_length']) ; sort($var) ;
        $dims->fields['products_length'] = $var[2] ; $dims->fields['products_width'] = $var[1] ;  $dims->fields['products_height'] = $var[0] ;
        // if no dimensions provided use the defaults
        if($dims->fields['products_height'] == 0) {$dims->fields['products_height'] = $defaultdims[0] ; }
        if($dims->fields['products_width']  == 0) {$dims->fields['products_width']  = $defaultdims[1] ; }
        if($dims->fields['products_length'] == 0) {$dims->fields['products_length'] = $defaultdims[2] ; }
        if($w == 0) {$w = 1 ; }  // 1 gram minimum
		
		$parcelweight = $w * $q;
		
        // get the cube of these items
        $itemcube =  ($dims->fields['products_width'] * $dims->fields['products_height'] * $dims->fields['products_length'] * $q) ;
        // Increase widths and length of parcel as needed
        if ($dims->fields['products_width'] >  $parcelwidth)  { $parcelwidth  = $dims->fields['products_width']  ; }
        if ($dims->fields['products_length'] > $parcellength) { $parcellength = $dims->fields['products_length'] ; }
        // Stack on top on existing items
        $parcelheight =  ($dims->fields['products_height'] * ($q)) + $parcelheight  ;
        $packageitems =  $packageitems + $q ;

// Useful debugging information //
        if ( MODULE_SHIPPING_AUPOST_DEBUG == "Yes" )
        {
            $dim_query = "select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id='$t' limit 1 ";
            $name = $db->Execute($dim_query);

echo "<center><table border=1 width=95% ><th colspan=8>Debugging information</hr>
            <tr><th>Item " . ($x + 1) . "</th><td colspan=7>" . $name->fields['products_name'] . "</td>
            <tr><th width=1%>Attribute</th><th colspan=3>Item</th><th colspan=4>Parcel</th></tr>
            <tr><th>Qty</th><td>&nbsp; " . $q . "<th>Weight</th><td>&nbsp; " . $dims->fields['products_weight'] . "</td>
            <th>Qty</th><td>&nbsp;$packageitems</td><th>Weight</th><td>&nbsp;" ; echo $parcelweight + (($parcelweight* $tare)/100) ; echo "</td></tr>
            <tr><th>Dimensions</th><td colspan=3>&nbsp; " . $dims->fields['products_length'] . " x " . $dims->fields['products_width'] . " x "  . $dims->fields['products_height'] . "</td>
            <td colspan=4>&nbsp;$parcellength  x  $parcelwidth  x $parcelheight </td></tr>
            <tr><th>Cube</th><td colspan=3>&nbsp; " . $itemcube . "</td><td colspan=4>&nbsp;" . ($parcelheight * $parcellength * $parcelwidth) . " </td></tr>
            <tr><th>CubicWeight</th><td colspan=3>&nbsp;" . (($dims->fields['products_length'] * $dims->fields['products_height'] * $dims->fields['products_width']) * 0.00001 * 250) . "Kgs  </td><td colspan=4>&nbsp;" . (($parcelheight * $parcellength * $parcelwidth) * 0.00001 * 250) . "Kgs </td></tr>
            </table></center> " ;
        }
    }

// package created, now re-orientate and check dimensions
    $var = array($parcelheight, $parcellength, $parcelwidth) ; sort($var) ;
    $parcelheight = $var[0] ; $parcelwidth = $var[1] ; $parcellength = $var[2] ;
    $girth = ($parcelheight * 2) + ($parcelwidth * 2)  ;

$parcelweight = $parcelweight + (($parcelweight*$tare)/100) ;

if (MODULE_SHIPPING_AUPOST_WEIGHT_FORMAT == "gms") {$parcelweight = $parcelweight/1000 ; }

//  save dimensions for display purposes on quote form (this way I don't need to hack another system file)
$_SESSION['swidth'] = $parcelwidth ; $_SESSION['sheight'] = $parcelheight ;
$_SESSION['slength'] = $parcellength ;  // $_SESSION['boxes'] = $shipping_num_boxes ;

// Check for maximum length allowed
    if($parcellength > $MAXLENGTH_P)
    {
         $cost = $this->_get_error_cost($dest_country) ;

if ($cost == 0) return  ;
   
        $methods[] = array('title' => ' (AusPost excess length)', 'cost' => $cost ) ;
        $this->quotes['methods'] = $methods;   // set it
        return $this->quotes;
    }  // exceeds AustPost maximum length. No point in continuing.

// Check girth
    if($girth > $MAXGIRTH_P )
    {
         $cost = $this->_get_error_cost($dest_country) ;

if ($cost == 0)  return  ;
      
        $methods[] = array('title' => ' (AusPost excess girth)', 'cost' => $cost ) ;
        $this->quotes['methods'] = $methods;   // set it
        return $this->quotes;
    }  // exceeds AustPost maximum girth. No point in continuing.

if ($parcelweight > $MAXWEIGHT_P)
    {
         $cost = $this->_get_error_cost($dest_country) ;

if ($cost == 0)  return  ;
      
        $methods[] = array('title' => ' (AusPost excess weight)', 'cost' => $cost ) ;
        $this->quotes['methods'] = $methods;   // set it
        return $this->quotes;
    }  // exceeds AustPost maximum weight. No point in continuing.

// Check to see if cache is useful
    if(isset($_SESSION['aupostParcel']))
    {
        $test = explode(",", $_SESSION['aupostParcel']) ;

if (
            ($test[0] == $dest_country) &&
            ($test[1] == $topcode) &&
            ($test[2] == $parcelwidth) &&
            ($test[3] == $parcelheight) &&
            ($test[4] == $parcellength) &&
            ($test[5] == $parcelweight) &&
            ($test[6] == $ordervalue)
           )
        {
            if ( MODULE_SHIPPING_AUPOST_DEBUG == "Yes" )
            {
                echo "<center><table border=1 width=95% ><td align=center><font color=\"#FF0000\">Using Cached quotes </font></td></table></center>" ;
            }

$this->quotes =  $_SESSION['aupostQuotes'] ;
return $this->quotes ;

///////////////////////////////////  Cache Exit Point //////////////////////////////////

} // No cache match -  get new quote from server //

}  // No cache session -  get new quote from server //
///////////////////////////////////////////////////////////////////////////////////////////////

// always save new session  CSV //
    $_SESSION['aupostParcel'] = implode(",", array($dest_country, $topcode, $parcelwidth, $parcelheight, $parcellength, $parcelweight, $ordervalue)) ;
    $shipping_weight = $parcelweight ;  // global value for zencart

// convert cm to mm 'cos thats what the server uses //
    $parcelwidth = $parcelwidth ;
    $parcelheight = $parcelheight ;
    $parcellength = $parcellength ;

// Set destination code ( postcode if AU, else 2 char iso country code )
    $dcode = ($dest_country == "AU") ? $topcode:$dest_country ;

if (!$dcode) $dcode =  SHIPPING_ORIGIN_ZIP ; // if no destination postcode - (aka first run - zencart only), set to local (cheapest rates)

$flags = ((MODULE_SHIPPING_AUPOST_HIDE_PARCEL == "No") || ( MODULE_SHIPPING_AUPOST_DEBUG == "Yes" )) ? 0:1 ;

// Server query string //
	$qu = $this->get_auspost_api("http://auspost.com.au/api/postage/parcel/domestic/service.xml?from_postcode=" . MODULE_SHIPPING_AUPOST_SPCODE . "&to_postcode=$dcode&length=$parcellength&width=$parcelwidth&height=$parcelheight&weight=$parcelweight") ;

// Parse the .xml results into an array //
    $xml = new SimpleXMLElement($qu)  ; 
	
	  if ( MODULE_SHIPPING_AUPOST_DEBUG == "Yes" )  { echo "<table><tr><td>Server Returned:<br>" ; print_r($query) ; echo "</td></tr></table>" ; }

// print_r($xml) ; exit ;
    /////  Initialise our quote array(s)
    $this->quotes = array('id' => $this->code, 'module' => $this->title);
    $methods = array() ;

///////////////////////////////////////
//
//  loop through the quotes retrieved //

$i = 0 ;  // counter
    foreach($xml as $foo => $bar)
    {
        $id = ($xml->service[$i]->code);
        $cost = (float)($xml->service[$i]->price);
        $description = ($xml->service[$i]->name);
        $i++ ;

$add = 0 ; $f = 0 ; $info=0 ;

switch ($id) {
	
         case  "AUS_PARCEL_REGULAR_SATCHEL_5KG" ;
         case  "AUS_PARCEL_REGULAR_SATCHEL_3KG" ;
		 case  "AUS_PARCEL_REGULAR_SATCHEL_500G" ;
        if ((in_array("Prepaid Satchel", $this->allowed_methods)))
        {
            $add = MODULE_SHIPPING_AUPOST_PPS_HANDLING ; $f = 1 ;
        }
		break;
		
		case  "AUS_PARCEL_EXPRESS_SATCHEL_5KG" ;
        case  "AUS_PARCEL_EXPRESS_SATCHEL_3KG" ;
		case  "AUS_PARCEL_EXPRESS_SATCHEL_500G" ;
        if ((in_array("Prepaid Express Satchel", $this->allowed_methods)))
        {
            $add =  MODULE_SHIPPING_AUPOST_PPSE_HANDLING ; $f = 1 ;
        }
		break;
		
		case  "AUS_PARCEL_REGULAR" ;
        if (in_array("Regular Parcel", $this->allowed_methods))
        {
            $add = MODULE_SHIPPING_AUPOST_RPP_HANDLING ; $f = 1 ;
        }
		break;
		
		case  "REG" ;
        if (in_array("Registered Parcel", $this->allowed_methods))
        {
            $add =  MODULE_SHIPPING_AUPOST_RPP_HANDLING + MODULE_SHIPPING_AUPOST_RI_HANDLING ; $f = 1 ; $info = $xml->information[0]->registration ;
        }
		break;
		
        case  "AUS_PARCEL_EXPRESS" ;
        if (in_array("Express Parcel", $this->allowed_methods)) 
        {
            $add = MODULE_SHIPPING_AUPOST_EXP_HANDLING ; $f = 1 ;
        }
		break;
	
		 case  "AUS_PARCEL_PLATINUM" ;
		 if (in_array("Express Post Platinum Parcel", $this->allowed_methods))
        {
            $add = MODULE_SHIPPING_AUPOST_PLAT_HANDLING ; $f = 1 ;
        }
		break;
		
		 case  "AUS_PARCEL_PLATINUM_SATCHEL_5KG" ;
         case  "AUS_PARCEL_PLATINUM_SATCHEL_3KG" ;
		 case  "AUS_PARCEL_PLATINUM_SATCHEL_500G" ;
        if ((in_array("Express Post Platinum Satchel", $this->allowed_methods)))
        {
            $add = MODULE_SHIPPING_AUPOST_PLATSATCH_HANDLING ; $f = 1 ;
        }
		break;
	}
        //////////////////////////////
        if ((($cost > 0) && ($f == 1)) || ( MODULE_SHIPPING_AUPOST_DEBUG == "Yes" ))
        {
            $cost = $cost + $add ;
	   if ( MODULE_SHIPPING_AUPOST_CORE_WEIGHT == "Yes") { $cost = $cost * $shipping_num_boxes ; }

if (($dest_country == "AU") && (($this->tax_class) > 0))
            {
                $t = $cost - ($cost / (zen_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id'])+1)) ;

if ($t > 0) $cost = $t ;
            }
            if  (MODULE_SHIPPING_AUPOST_HIDE_HANDLING !='Yes')
            {
                $details = ' (Includes ' . $currencies->format($add / $aus_rate ). ' Packaging &amp; Handling ';

if ($info > 0)  {
                    $details = $details." +$".$info." fee)." ;

}  else {$details = $details.")" ;}

}

$cost = $cost / $aus_rate;

$methods[] = array('id' => "$id",  'title' => " ".$description . " " . $details, 'cost' => ($cost ));
        }

}  // end foreach loop

///////////////////////////////////////////////////////////////////////
//
//  check to ensure we have at least one valid quote - produce error message if not.

if  (sizeof($methods) == 0) {

$cost = $this->_get_error_cost($dest_country) ;

if ($cost == 0)  return  ;

$methods[] = array( 'id' => "Error",  'title' => ' Unexpected error (no valid methods). Using AusPost Flat Rate.' ,'cost' => $cost ) ;
    }

//  Sort by cost //
    $sarray[] = array() ;
    $resultarr = array() ;

foreach($methods as $key => $value)
    {
		$sarray[ $key ] = $value['cost'] ;
    }
    asort( $sarray ) ;

foreach($sarray as $key => $value)
    {
        $resultarr[ $key ] = $methods[ $key ] ;
	}

$this->quotes['methods'] = array_values($resultarr) ;   // set it

if ($this->tax_class >  0)
    {
        $this->quotes['tax'] = zen_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
   
    }
	
 
$_SESSION['aupostQuotes'] = $this->quotes  ; // save as session to avoid reprocessing when single method required

return $this->quotes;   //  all done //

///////////////////////////////////  Final Exit Point //////////////////////////////////
}

function _get_error_cost($dest_country) {
	
 $x = explode(',', MODULE_SHIPPING_AUPOST_COST_ON_ERROR) ;

unset($_SESSION['aupostParcel']) ;  // don't cache errors.
        $cost = $dest_country == "AU" ?  $x[0]:$x[1] ;

if ($cost == 0) {
            $this->enabled = FALSE ;
            unset($_SESSION['aupostQuotes']) ;
            }
	    else 
	    {  
		$this->quotes = array('id' => $this->code, 'module' => 'Flat Rate'); 
	    }

return $cost;
    }
////////////////////////////////////////////////////////////////
function check()
{
    global $db;
    if (!isset($this->_check))
    {
        $check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_AUPOST_STATUS'");
        $this->_check = $check_query->RecordCount();
    }
    return $this->_check;
}
////////////////////////////////////////////////////////////////////////////
function install()
{
    global $db;

$result = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'SHIPPING_ORIGIN_ZIP'"  ) ;
      $pcode = $result->fields['configuration_value'] ;
      
	if (!$pcode) $pcode = "2000" ;

$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable this module?', 'MODULE_SHIPPING_AUPOST_STATUS', 'True', 'Enable this Module', '6', '1', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())");																																																																																																			  $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Auspost API Key:', 'MODULE_SHIPPING_AUPOST_AUTHKEY', '', 'To use this module, you must obtain a 36 digit API Key from the <a href=\"https://auspost.com.au/devcentre/pacpcs-registration.asp\" target=\"_blank\">Auspost Development Centre</a>', '6', '2', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Dispatch Postcode', 'MODULE_SHIPPING_AUPOST_SPCODE', $pcode, 'Dispatch Postcode?', '6', '2', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title,
                          configuration_key,
                          configuration_value,
                          configuration_description,
                          configuration_group_id,
                          sort_order,
                          set_function,
                          date_added)

values ('Shipping Methods for Australia',
                            'MODULE_SHIPPING_AUPOST_TYPES1',
          'Regular Parcel, Registered Parcel, Express Parcel, , Prepaid Satchel, Prepaid Express Satchel, Express Post Platinum Parcel, Express Post Platinum Satchel',
                            'Select the methods you wish to allow',
                            '6',
                            '3',
                            'zen_cfg_select_multioption(array(\'Regular Parcel\',\'Express Parcel\',\'Prepaid Satchel\',\'Prepaid Express Satchel\',\'Express Post Platinum Parcel\',\'Express Post Platinum Satchel\'), ',
                            now())"
                ) ;

$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee - Regular parcels', 'MODULE_SHIPPING_AUPOST_RPP_HANDLING', '0.00', 'Handling Fee Regular parcels', '6', '6', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee - Prepaid Satchels', 'MODULE_SHIPPING_AUPOST_PPS_HANDLING', '0.00', 'Handling Fee for Prepaid Satchels.', '6', '7', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee - Prepaid Satchels - Express', 'MODULE_SHIPPING_AUPOST_PPSE_HANDLING', '0.00', 'Handling Fee for Prepaid Express Satchels.', '6', '8', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee - Express parcels', 'MODULE_SHIPPING_AUPOST_EXP_HANDLING', '0.00', 'Handling Fee for Express parcels.', '6', '9', now())");
	$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee - Platinum parcels', 'MODULE_SHIPPING_AUPOST_PLAT_HANDLING', '0.00', 'Handling Fee for Platinum parcels.', '6', '10', now())");
	$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee - Platinum Satchels', 'MODULE_SHIPPING_AUPOST_PLATSATCH_HANDLING', '0.00', 'Handling Fee for Platinum Satchels.', '6', '11', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Hide Handling Fees?', 'MODULE_SHIPPING_AUPOST_HIDE_HANDLING', 'Yes', 'The handling fees are still in the total shipping cost but the Handling Fee is not itemised on the invoice.', '6', '16', 'zen_cfg_select_option(array(\'Yes\', \'No\'), ', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Default Parcel Dimensions', 'MODULE_SHIPPING_AUPOST_DIMS', '10,10,2', 'Default Parcel dimensions (in cm). Three comma seperated values (eg 10,10,2 = 10cm x 10cm x 2cm). These are used if the dimensions of individual products are not set', '6', '40', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Cost on Error', 'MODULE_SHIPPING_AUPOST_COST_ON_ERROR', '25', 'If an error occurs this Flat Rate fee will be used.</br> A value of zero will disable this module on error.', '6', '20', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Parcel Weight format', 'MODULE_SHIPPING_AUPOST_WEIGHT_FORMAT', 'kgs', 'Are your store items weighted by grams or Kilos? (required so that we can pass the correct weight to the server).', '6', '25', 'zen_cfg_select_option(array(\'gms\', \'kgs\'), ', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Show AusPost logo?', 'MODULE_SHIPPING_AUPOST_ICONS', 'Yes', 'Show Auspost logo in place of text?', '6', '19', 'zen_cfg_select_option(array(\'No\', \'Yes\'), ', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Debug?', 'MODULE_SHIPPING_AUPOST_DEBUG', 'No', 'See how parcels are created from individual items.</br>Shows all methods returned by the server, including possible errors. <strong>Do not enable in a production environment</strong>', '6', '40', 'zen_cfg_select_option(array(\'No\', \'Yes\'), ', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Tare percent.', 'MODULE_SHIPPING_AUPOST_TARE', '10', 'Add this percentage of the items total weight as the tare weight. (This module ignores the global settings that seems to confuse many users. 10% seems to work pretty well.).', '6', '50', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_SHIPPING_AUPOST_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '55', now())");
    $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_AUPOST_TAX_CLASS', '0', 'Set Tax class or -none- if not registered for GST.', '6', '60', 'zen_get_tax_class_title', 'zen_cfg_pull_down_tax_classes(', now())");

/////////////////////////  update tables //////

$conn = mysql_connect(DB_SERVER, DB_SERVER_USERNAME,DB_SERVER_PASSWORD);
 $dbselect = mysql_select_db(DB_SERVER_DATABASE);
 $v = mysql_query("select * from " . TABLE_PRODUCTS . " limit 1" ) ;
$inst = 1 ; $i = 0 ; $c = mysql_num_fields($v) ;

while ($i < $c)
    {
        $r = mysql_field_name($v,$i) ;

if($r == "products_length") { unset($inst) ; } ;
        $i++ ;
    }
   mysql_close($conn) ;

if(isset($inst))
    {
      //  echo "new" ;
        $db->Execute("ALTER TABLE " .TABLE_PRODUCTS. " ADD `products_length` FLOAT(6,2) NULL AFTER `products_weight`, ADD `products_height` FLOAT(6,2) NULL AFTER `products_length`, ADD `products_width` FLOAT(6,2) NULL AFTER `products_height`" ) ;
    }
    else
    {
      //  echo "update" ;
        $db->Execute("ALTER TABLE " .TABLE_PRODUCTS. " CHANGE `products_length` `products_length` FLOAT(6,2), CHANGE `products_height` `products_height` FLOAT(6,2), CHANGE `products_width`  `products_width`  FLOAT(6,2)" ) ;
    }

}

function remove()
{
    global $db;
    $db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key like 'MODULE_SHIPPING_AUPOST_%' ");
}

function keys()
{
    return array
    (
        'MODULE_SHIPPING_AUPOST_STATUS',
		'MODULE_SHIPPING_AUPOST_AUTHKEY',
	    'MODULE_SHIPPING_AUPOST_SPCODE',
	    'MODULE_SHIPPING_AUPOST_TYPES1',
        'MODULE_SHIPPING_AUPOST_RPP_HANDLING',
        'MODULE_SHIPPING_AUPOST_EXP_HANDLING',
        'MODULE_SHIPPING_AUPOST_PPS_HANDLING',
	    'MODULE_SHIPPING_AUPOST_PPSE_HANDLING',
		'MODULE_SHIPPING_AUPOST_PLAT_HANDLING',
	    'MODULE_SHIPPING_AUPOST_PLATSATCH_HANDLING',
        'MODULE_SHIPPING_AUPOST_COST_ON_ERROR',
		'MODULE_SHIPPING_AUPOST_HIDE_HANDLING',
	    'MODULE_SHIPPING_AUPOST_DIMS',
	    'MODULE_SHIPPING_AUPOST_WEIGHT_FORMAT',
	    'MODULE_SHIPPING_AUPOST_ICONS',
	    'MODULE_SHIPPING_AUPOST_DEBUG',
        'MODULE_SHIPPING_AUPOST_TARE',
	    'MODULE_SHIPPING_AUPOST_SORT_ORDER',
	    'MODULE_SHIPPING_AUPOST_TAX_CLASS'
    );
}

//auspost API
function get_auspost_api($url)
{
$crl = curl_init();
$timeout = 5;
curl_setopt ($crl, CURLOPT_HTTPHEADER, array('AUTH-KEY:' . MODULE_SHIPPING_AUPOST_AUTHKEY));
curl_setopt ($crl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt ($crl, CURLOPT_URL, $url);
curl_setopt ($crl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($crl, CURLOPT_CONNECTTIMEOUT, $timeout);
$ret = curl_exec($crl);
curl_close($crl);
return $ret;
}
// end auspost API

}  // end class
?>