/modules/avalaratax/avalaratax.php

Large files files are truncated, but you can click here to view the full file

<?php
/*
* 2007-2011 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
*  @author PrestaShop SA <contact@prestashop.com>
*  @copyright  2007-2011 PrestaShop SA
*  @license    http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

// Security
if (!defined('_PS_VERSION_'))
	exit;

spl_autoload_register('avalaraAutoload');

class AvalaraTax extends Module
{
	/**
	 * @brief Constructor
	 */
	public function __construct()
	{
		$this->name = 'avalaratax';
		$this->tab = 'billing_invoicing';
		$this->version = '3.1.1';
		$this->author = 'PrestaShop';
		parent::__construct();

		$this->displayName = $this->l('Avalara - AvaTax');
		$this->description = $this->l('Sales Tax is complicated. AvaTax makes it easy.');

		/** Backward compatibility */
		require(_PS_MODULE_DIR_.$this->name.'/backward_compatibility/backward.php');
	}

	/**
	 * @brief Installation method
	 */
	public function install()
	{
		Configuration::updateValue('AVALARATAX_URL', 'https://avatax.avalara.net');
		Configuration::updateValue('AVALARATAX_ADDRESS_VALIDATION', 1);
		Configuration::updateValue('AVALARATAX_TAX_CALCULATION', 1);
		Configuration::updateValue('AVALARATAX_TIMEOUT', 300);

		// Value possible : Development / Production
		Configuration::updateValue('AVALARATAX_MODE', 'Production');
		Configuration::updateValue('AVALARATAX_ADDRESS_NORMALIZATION', 1);
		Configuration::updateValue('AVALARATAX_COMMIT_ID', 5);
		Configuration::updateValue('AVALARATAX_CANCEL_ID', 6);
		Configuration::updateValue('AVALARATAX_REFUND_ID', 7);
		Configuration::updateValue('AVALARATAX_POST_ID', 2);
		Configuration::updateValue('AVALARATAX_STATE', 1);
		Configuration::updateValue('AVALARATAX_COUNTRY', 0);
		Configuration::updateValue('AVALARA_CACHE_MAX_LIMIT', 1); /* The values in cache will be refreshed every 1 minute by default */

		// Make sure Avalara Tables don't exist before installation
		Db::getInstance()->Execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'avalara_product_cache`;');
		Db::getInstance()->Execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'avalara_carrier_cache`;');
		Db::getInstance()->Execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'avalara_returned_products`;');
		Db::getInstance()->Execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'avalara_temp`;');

		if (!Db::getInstance()->Execute('
		CREATE TABLE `'._DB_PREFIX_.'avalara_product_cache` (
		`id_cache` int(10) unsigned NOT NULL auto_increment,
		`id_product` int(10) unsigned NOT NULL,
		`tax_rate` float(8, 2) unsigned NOT NULL,
		`region` varchar(2) NOT NULL,
		`id_address` int(10) unsigned NOT NULL,
		`update_date` datetime,
		PRIMARY KEY (`id_cache`),
		UNIQUE (`id_product`, `region`))
		ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8') ||
			!Db::getInstance()->Execute('
		CREATE TABLE `'._DB_PREFIX_.'avalara_carrier_cache` (
		`id_cache` int(10) unsigned NOT NULL auto_increment,
		`id_carrier` int(10) unsigned NOT NULL,
		`tax_rate` float(8, 2) unsigned NOT NULL,
		`amount` float(8, 2) unsigned NOT NULL,
		`update_date` datetime,
		`id_cart` int(10) unsigned NOT NULL,
		`cart_hash` varchar(32) DEFAULT NULL,
		PRIMARY KEY (`id_cache`),
		UNIQUE (`id_cart`))
		ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8')||
			!Db::getInstance()->Execute('
		CREATE TABLE `'._DB_PREFIX_.'avalara_returned_products` (
		`id_returned_product` int(10) unsigned NOT NULL auto_increment,
		`id_order` int(10) unsigned NOT NULL,
		`id_product` int(10) unsigned NOT NULL,
		`total` float(8, 2) unsigned NOT NULL,
		`quantity` int(10) unsigned NOT NULL,
		`name` varchar(255) NOT NULL,
		`description_short` varchar(255) NULL,
		`tax_code` varchar(255) NULL,
		PRIMARY KEY (`id_returned_product`))
		ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8')||
			!Db::getInstance()->Execute('
		CREATE TABLE `'._DB_PREFIX_.'avalara_temp` (
		`id_order` int(10) unsigned NOT NULL,
		`id_order_detail` int(10) unsigned NOT NULL)
		ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8')||
			!Db::getInstance()->Execute('
		CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'avalara_taxcodes` (
		`id_taxcode` int(10) unsigned NOT NULL auto_increment,
		`id_product` int(10) unsigned NOT NULL,
		`tax_code`  varchar(30) NOT NULL,
		`taxable` int(2) unsigned  NOT NULL DEFAULT 1,
		PRIMARY KEY (`id_taxcode`),
		UNIQUE (`id_product`))
		ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8'))
			return false;

		if (!parent::install() || !$this->registerHook('leftColumn') || !$this->registerHook('updateOrderStatus') ||
			!$this->registerHook('cancelProduct') || !$this->registerHook('adminOrder') || !$this->registerHook('backOfficeTop') ||
			!$this->registerHook('header') || !$this->overrideFiles())
			return false;
		return true;
	}

	public function uninstall()
	{
		if (!$this->removeOverrideFiles() || !parent::uninstall() ||
			!Configuration::deleteByName('AVALARATAX_URL') ||
			!Configuration::deleteByName('AVALARATAX_ADDRESS_VALIDATION') ||
			!Configuration::deleteByName('AVALARATAX_TAX_CALCULATION') ||
			!Configuration::deleteByName('AVALARATAX_TIMEOUT') ||
			!Configuration::deleteByName('AVALARATAX_MODE') ||
			!Configuration::deleteByName('AVALARATAX_ACCOUNT_NUMBER') ||
			!Configuration::deleteByName('AVALARATAX_COMPANY_CODE') ||
			!Configuration::deleteByName('AVALARATAX_LICENSE_KEY') ||
			!Configuration::deleteByName('AVALARATAX_ADDRESS_NORMALIZATION') ||
			!Configuration::deleteByName('AVALARATAX_ADDRESS_LINE1') ||
			!Configuration::deleteByName('AVALARATAX_ADDRESS_LINE2') ||
			!Configuration::deleteByName('AVALARATAX_CITY') ||
			!Configuration::deleteByName('AVALARATAX_STATE') ||
			!Configuration::deleteByName('AVALARATAX_ZIP_CODE') ||
			!Configuration::deleteByName('AVALARATAX_COUNTRY') ||
			!Configuration::deleteByName('AVALARATAX_COMMIT_ID') ||
			!Configuration::deleteByName('AVALARATAX_CANCEL_ID') ||
			!Configuration::deleteByName('AVALARATAX_REFUND_ID') ||
			!Configuration::deleteByName('AVALARA_CACHE_MAX_LIMIT') ||
			!Configuration::deleteByName('AVALARATAX_POST_ID') ||
			!Db::getInstance()->Execute('DROP TABLE `'._DB_PREFIX_.'avalara_product_cache`') ||
			!Db::getInstance()->Execute('DROP TABLE `'._DB_PREFIX_.'avalara_carrier_cache`') ||
			!Db::getInstance()->Execute('DROP TABLE `'._DB_PREFIX_.'avalara_returned_products`') ||
			!Db::getInstance()->Execute('DROP TABLE `'._DB_PREFIX_.'avalara_temp`'))
			return false;
		// Do not remove taxcode table
		return true;
	}

	/**
	 * @brief Describe the override schema
	 */
	protected static function getOverrideInfo()
	{
		return array(
			'Tax.php' => array(
				'source' => 'override-14x/classes/Tax.php',
				'dest' => 'override/classes/Tax.php',
				'md5' => array(
					'1.1' => '5d9e318d673bfa723b02f14f952e0a7a',
					'2.3' => '86c900cd6fff286aa6a52df2ff72228a',
					'3.0.2' => 'c558c0b15877980134e301af34e42c3e',
					'3.1.1' => '38acdbc8b4d57d7e5110d589a78796bc',
				)
			),
			'Cart.php' => array(
				'source' => 'override/classes/Cart.php',
				'dest' => 'override/classes/Cart.php',
				'md5' => array(
					'3.0.2' => 'e4b05425b6dc61f75aad434265f3cac8',
					'3.0.3' => 'f7388cb50fbfd300c9f81cc407b7be83',
				)
			),
			'AddressController.php' => array(
				'source' => 'override/controllers/front/AddressController.php',
				'dest' => 'override/controllers/AddressController.php',
				'md5' => array(
					'1.1' => 'ebc4f31298395c4b113c7e2d7cc41b4a',
					'3.0.2' => 'ff3d9cb2956c35f4229d5277cb2e92e6',
				)
			),
			'AuthController.php' => array(
				'source' => 'override/controllers/front/AuthController.php',
				'dest' => 'override/controllers/AuthController.php',
				'md5' => array(
					'1.1' => '7304d7af971b30f2dcd401b80bbdf805',
					'3.0.2' => '3eb86260a7c8d6cfa1d209fb3e8f8bd6',
				)
			),
		);
	}

	protected function removeOverrideFiles()
	{
		/** In v1.5, we do not remove override files */
		if (version_compare(_PS_VERSION_, '1.5', '<'))
			foreach (self::getOverrideInfo() as $key => $params)
			{
				if (!file_exists(_PS_ROOT_DIR_.'/'.$params['dest']))
					continue;

				$md5 = md5_file(_PS_ROOT_DIR_.'/'.$params['dest']);
				$removed = false;
				foreach ($params['md5'] as $hash)
					if ($md5 == $hash)
					{
						if (unlink(_PS_ROOT_DIR_.'/'.$params['dest']))
							$removed = true;
						break;
					}
				if (!$removed)
					$this->_errors[] = $this->l('Error while removing override: ').$key;
			}
		return !isset($this->_errors) || !$this->_errors || !count($this->_errors);
	}

	protected function overrideFiles()
	{
		/** In v1.5, we do not copy the override files */
		if (version_compare(_PS_VERSION_, '1.5', '<') && $this->removeOverrideFiles())
		{
			/** Check if the override directories exists */
			if (!is_dir(_PS_ROOT_DIR_.'/override/classes/'))
				mkdir(_PS_ROOT_DIR_.'/override/classes/', 0777, true);
			if (!is_dir(_PS_ROOT_DIR_.'/override/controllers/'))
				mkdir(_PS_ROOT_DIR_.'/override/controllers/', 0777, true);

			foreach (self::getOverrideInfo() as $key => $params)
				if (file_exists(_PS_ROOT_DIR_.'/'.$params['dest']))
					$this->_errors[] = $this->l('This override file already exists, please merge it manually: ').$key;
				elseif (!copy(_PS_MODULE_DIR_.'avalaratax/'.$params['source'], _PS_ROOT_DIR_.'/'.$params['dest']))
						$this->_erroors[] = $this->l('Error while copying the override file: ').$key;
		}
		return !isset($this->_errors) || !$this->_errors || !count($this->_errors);
	}

	/******************************************************************/
	/** Hook Methods **************************************************/
	/******************************************************************/

	public function hookAdminOrder($params)
	{
		$this->purgeTempTable();
	}

	public function hookCancelProduct($params)
	{
		if (isset($_POST['cancelProduct']))
		{
			$order = new Order((int)$_POST['id_order']);
			if (!Validate::isLoadedObject($order))
				return false;
			if ($order->invoice_number)
			{
				// Get all the cancel product's IDs
				$cancelledIdsOrderDetail = array();
				foreach ($_POST['cancelQuantity'] as $idOrderDetail => $qty)
					if ($qty > 0)
						$cancelledIdsOrderDetail[] = (int)$idOrderDetail;
				$cancelledIdsOrderDetail = implode(', ', $cancelledIdsOrderDetail);

				// Fill temp table
				Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'avalara_temp (`id_order`, `id_order_detail`)
										VALUES ('.(int)$_POST['id_order'].', '.(int)$params['id_order_detail'].')');
				// Check if we are at the end of the loop
				$totalLoop = Db::getInstance()->ExecuteS('SELECT COUNT(`id_order`) as totalLines
														FROM `'._DB_PREFIX_.'avalara_temp`
														WHERE `id_order_detail` IN ('.pSQL($cancelledIdsOrderDetail).')');

				if ($totalLoop[0]['totalLines'] != count(array_filter($_POST['cancelQuantity'])))
					return false;

				// Clean the temp table because we are at the end of the loop
				$this->purgeTempTable();

				// Get details for cancelledIdsOrderDetail (Grab the info to post to Avalara in English.)
				$cancelledProdIdsDetails = Db::getInstance()->ExecuteS('SELECT od.`product_id` as id_product, od.`id_order_detail`, pl.`name`,
																		pl.`description_short`, od.`product_price` as price, od.`reduction_percent`,
																		od.`reduction_amount`, od.`product_quantity` as quantity, atc.`tax_code`
																		FROM '._DB_PREFIX_.'order_detail od
																		LEFT JOIN '._DB_PREFIX_.'product p ON (p.id_product = od.product_id)
																		LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (pl.id_product = p.id_product)
																		LEFT JOIN '._DB_PREFIX_.'avalara_taxcodes atc ON (atc.id_product = p.id_product)
																		WHERE pl.`id_lang` = 1 AND od.`id_order` = '.(int)$_POST['id_order'].'
																		AND od.`id_order_detail` IN ('.pSQL($cancelledIdsOrderDetail).')');
				// Build the product list
				$products = array();
				foreach ($cancelledProdIdsDetails as $cancelProd)
					$products[] = array('id_product' => (int)$cancelProd['id_product'],
												'quantity' => (int)$_POST['cancelQuantity'][$cancelProd['id_order_detail']],
												'total' => pSQL($_POST['cancelQuantity'][$cancelProd['id_order_detail']] * ($cancelProd['price'] - ($cancelProd['price'] * ($cancelProd['reduction_percent'] / 100)) - $cancelProd['reduction_amount'])), // Including those product with discounts
												'name' => pSQL(Tools::safeOutput($cancelProd['name'])),
												'description_short' => pSQL(Tools::safeOutput($cancelProd['description_short']), true),
												'tax_code' => pSQL(Tools::safeOutput($cancelProd['tax_code'])));
				// Send to Avalara
				$commitResult = $this->getTax($products, array('type' => 'ReturnInvoice', 'DocCode' => (int)$_POST['id_order']));
				if ($commitResult['ResultCode'] == 'Warning' || $commitResult['ResultCode'] == 'Error' || $commitResult['ResultCode'] == 'Exception')
					echo $this->_displayConfirmation($this->l('The following error was generated while cancelling the orders you selected. <br /> - '.
							Tools::safeOutput($commitResult['Messages']['Summary'])), 'error');
				else
				{
					$this->commitToAvalara(array('id_order' => (int)$_POST['id_order']));
					echo $this->_displayConfirmation($this->l('The products you selected were cancelled.'));
				}
			}
		}
	}

	protected function getDestinationAddress($id_order)
	{
		$order = new Order((int)$id_order);
		if (!Validate::isLoadedObject($order))
			return false;

		$address = new Address((int)$order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
		if (!Validate::isLoadedObject($address))
			return false;

		$state = null;
		if (!empty($address->id_state))
		{
			$state = new State((int)$address->id_state);
			if (!Validate::isLoadedObject($state))
				return false;
		}

		return array($address, $state, $order);
	}

	public function hookUpdateOrderStatus($params)
	{
		list($params['address'], $params['state'], $params['order']) = self::getDestinationAddress((int)$params['id_order']);

		if ($params['newOrderStatus']->id == (int)Configuration::get('AVALARATAX_COMMIT_ID'))
			return $this->commitToAvalara($params);
		elseif ($params['newOrderStatus']->id == (int)Configuration::get('AVALARATAX_CANCEL_ID'))
		{
			$params['CancelCode'] = 'V';
			$this->cancelFromAvalara($params);
			return $this->cancelFromAvalara($params);
		}
		elseif ($params['newOrderStatus']->id == (int)Configuration::get('AVALARATAX_POST_ID'))
			return $this->postToAvalara($params);
		elseif ($params['newOrderStatus']->id == (int)Configuration::get('AVALARATAX_REFUND_ID'))
			return $this->commitToAvalara($params);

		return false;
	}

	public function hookBackOfficeTop()
	{
		if (Tools::isSubmit('submitAddproduct') || Tools::isSubmit('submitAddproductAndStay'))
			Db::getInstance()->Execute('REPLACE INTO `'._DB_PREFIX_.'avalara_taxcodes` (`id_product`, `tax_code`)
				VALUES ('.(isset($_GET['id_product']) ? (int)$_GET['id_product'] : 0).', \''.pSQL(Tools::safeOutput($_POST['tax_code'])).'\')');


		if ((isset($_GET['updateproduct']) || isset($_GET['addproduct'])) && isset($_GET['id_product']) && (int)$_GET['id_product'])
		{
			$r = Db::getInstance()->getRow('SELECT `tax_code`
														FROM `'._DB_PREFIX_.'avalara_taxcodes` atc
														WHERE atc.`id_product` = '.(int)Tools::getValue('id_product'));

			// JS for 1.4
			if (version_compare(_PS_VERSION_, '1.5', '<'))
				return '<script type="text/javascript">
			$(function() {
				// Add the Tax Code field
				$(\'<tr><td class="col-left">'.$this->l('Tax Code (Avalara)').':</td><td style="padding-bottom:5px;"><input type="text" style="width: 130px; margin-right: 5px;" value="'.
					($r ? Tools::safeOutput($r['tax_code']) : '').'" name="tax_code" maxlength="13" size="55"></td></tr>\').appendTo(\'#product #step1 table:eq(0) tbody\');

				// override original tax rules
				$(\'span #id_tax_rules_group\').parent().html(\'Avalara\');
			});
		</script>';
			// JS for 1.5
			return '<script type="text/javascript">
			$(function() {
				var done = false;
				// Add the Tax Code field
				$(\'#link-Informations\').click(function() {
								if (done == false) {
												done = true;
												$(\'<tr><td class="col-left"><label for="tax_code">'.$this->l('Tax Code:').'</label></td><td style="padding-bottom:5px;"><input type="text" style="width: 130px; margin-right: 5px;" value="'.
												($r ? Tools::safeOutput($r['tax_code']) : '').'" name="tax_code" maxlength="13" size="55"> <span class="small">(Avalara)</span></td></tr>\').appendTo(\'#step1 table:first tbody\');
								}
				});

				// override original tax rules
				$(\'#link-Prices\').click(function() {
								$(\'span #id_tax_rules_group\').parent().html(\'Avalara\');
				});
      });
		</script>';
		}
		elseif ((Tools::isSubmit('updatecarrier') || Tools::isSubmit('addcarrier')) && Tools::getValue('id_carrier'))
			return '<script type="text/javascript">
			$(function() {
				// override original tax rules
				$(\'div #id_tax_rules_group\').parent().html(\'<label class="t">Avalara</label>\');
			});
		</script>';

		if (Tools::getValue('tab') == 'AdminTaxes' || Tools::getValue('tab') == 'AdminTaxRulesGroup' || Tools::getValue('controller') == 'admintaxes' || Tools::getValue('controller') == 'admintaxrulesgroup')
		{
			// JS for 1.5
			if (version_compare(_PS_VERSION_, '1.5', '>'))
				return '<script type="text/javascript">
				$(function() {
								$(\'#content form\').hide();
								$(\'#desc-tax-new\').hide();
								$(\'#desc-tax-save\').hide();
								$(\'#content div:first\').append(\'<div class="warn">'.$this->l('Tax rules are overwritten by Avalara Tax Module.').'</div>\');
				});
				</script>';
			// JS for 1.4
			return '<script type="text/javascript">
				$(function() {
				if ($(\'#Taxes\').size() || $(\'#submitFiltertax_rules_group\').size())
					$(\'#content\').prepend(\'<div class="warn"><img src="../img/admin/warn2.png">'.
			$this->l('Tax rules are overwritten by Avalara Tax Module.').'</div>\');
				});
				</script>';
		}
		return '';
	}

	public function hookHeader()
	{
		if (!$this->context->cart || ((int)$this->context->cart->id_customer && !(int)$this->context->cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')}))
			$id_address = (int)(Db::getInstance()->getValue('SELECT `id_address` FROM `'._DB_PREFIX_.'address` WHERE `id_customer` = '.(int)($this->context->cart->id_customer).' AND `deleted` = 0 ORDER BY `id_address`'));
		else
			$id_address = $this->context->cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')};

		if (!(int)$id_address)
			return ;

		return '<script type="text/javascript">
				function refresh_taxes(count)
				{
								$.ajax({
												type : \'POST\',
												url : \''.$this->_path.'\' + \'ajax.php\',
												data : {
																\'id_cart\': "'.(int)$this->context->cart->id.'",
																\'id_lang\': "'.(int)$this->context->cookie->id_lang.'",
																\'id_address\': "'.(int)$id_address.'",
																\'ajax\': "getProductTaxRate",
																\'token\': "'.md5(_COOKIE_KEY_.Configuration::get('PS_SHOP_NAME')).'",
												},
												dataType: \'json\',
												success : function(d) {
																if (d.hasError == false && d.cached_tax == true)
																				$(\'#total_tax\').html($(\'body\').data(\'total_tax\'));
																else if (d.hasError == false && d.cached_tax == false)
																				$(\'#total_tax\').html(d.total_tax);
																else
																				$(\'#total_tax\').html(\''.$this->l('Error while calculating taxes').'\');
												}
								});
				}

		$(function() {
			/* ajax call to cache taxes product taxes that exist in the current cart */
			$(\'body\').data(\'total_tax\', $(\'#total_tax\').text());
			$(\'#total_tax\').html(\'<img src="img/loader.gif" alt="" />\');
			refresh_taxes(1);
		});
		</script>';
	}

	/******************************************************************/
	/** Main Form Methods *********************************************/
	/******************************************************************/
	public function getContent()
	{
		$buffer = '';
		
		if (version_compare(_PS_VERSION_,'1.5','>'))
			$this->context->controller->addJQueryPlugin('fancybox');
		else
			$buffer .= '<script type="text/javascript" src="'.__PS_BASE_URI__.'js/jquery/jquery.fancybox-1.3.4.js"></script>
		  	<link type="text/css" rel="stylesheet" href="'.__PS_BASE_URI__.'css/jquery.fancybox-1.3.4.css" />';

		if (Tools::isSubmit('SubmitAvalaraTaxSettings'))
		{
			Configuration::updateValue('AVALARATAX_ACCOUNT_NUMBER', Tools::getValue('avalaratax_account_number'));
			Configuration::updateValue('AVALARATAX_LICENSE_KEY', Tools::getValue('avalaratax_license_key'));
			Configuration::updateValue('AVALARATAX_URL', Tools::getValue('avalaratax_url'));
			Configuration::updateValue('AVALARATAX_COMPANY_CODE', Tools::getValue('avalaratax_company_code'));

			$buffer .= $this->_displayConfirmation();
		}
		elseif (Tools::isSubmit('SubmitAvalaraTaxOptions'))
		{
			Configuration::updateValue('AVALARATAX_ADDRESS_VALIDATION', Tools::getValue('avalaratax_address_validation'));
			Configuration::updateValue('AVALARATAX_TAX_CALCULATION', Tools::getValue('avalaratax_tax_calculation'));
			Configuration::updateValue('AVALARATAX_TIMEOUT', (int)Tools::getValue('avalaratax_timeout'));
			Configuration::updateValue('AVALARATAX_ADDRESS_NORMALIZATION', Tools::getValue('avalaratax_address_normalization'));
			Configuration::updateValue('AVALARATAX_TAX_OUTSIDE', Tools::getValue('avalaratax_tax_outside'));
			Configuration::updateValue('AVALARA_CACHE_MAX_LIMIT', Tools::getValue('avalara_cache_max_limit') < 1 ? 1 : Tools::getValue('avalara_cache_max_limit') > 23 ? 23 : Tools::getValue('avalara_cache_max_limit'));

			$buffer .= $this->_displayConfirmation();
		}
		elseif (Tools::isSubmit('SubmitAvalaraTestConnection'))
			$connectionTestResult = $this->_testConnection();
		elseif (Tools::isSubmit('SubmitAvalaraAddressOptions'))
		{
			/* Validate address*/
			$address = new Address();
			$address->address1 = Tools::getValue('avalaratax_address_line1');
			$address->address2 = Tools::getValue('avalaratax_address_line2');
			$address->city = Tools::getValue('avalaratax_city');
			$address->id_state = State::getIdByIso(Tools::getValue('avalaratax_state'));
			$address->id_country = Tools::getValue('avalaratax_country');
			$address->postcode = Tools::getValue('avalaratax_zip_code');

			$normalizedAddress = $this->validateAddress($address);
			if (isset($normalizedAddress['ResultCode']) && $normalizedAddress['ResultCode'] == 'Success')
			{
				$buffer .= $this->_displayConfirmation($this->l('The address you submitted has been validated.'));
				Configuration::updateValue('AVALARATAX_ADDRESS_LINE1', $normalizedAddress['Normalized']['Line1']);
				Configuration::updateValue('AVALARATAX_ADDRESS_LINE2', $normalizedAddress['Normalized']['Line2']);
				Configuration::updateValue('AVALARATAX_CITY', $normalizedAddress['Normalized']['City']);
				Configuration::updateValue('AVALARATAX_STATE', $normalizedAddress['Normalized']['Region']);
				Configuration::updateValue('AVALARATAX_COUNTRY', $normalizedAddress['Normalized']['Country']);
				Configuration::updateValue('AVALARATAX_ZIP_CODE', $normalizedAddress['Normalized']['PostalCode']);
			}
			else
			{
				$message = $this->l('The following error was generated while validating your address:');
				if (isset($normalizedAddress['Exception']['FaultString']))
					$message .= '<br /> - '.Tools::safeOutput($normalizedAddress['Exception']['FaultString']);
				if (isset($normalizedAddress['Messages']['Summary']))
					foreach ($normalizedAddress['Messages']['Summary'] as $summary)
						$message .= '<br /> - '.Tools::safeOutput($summary);
				$buffer .= $this->_displayConfirmation($message, 'error');

				Configuration::updateValue('AVALARATAX_ADDRESS_LINE1', Tools::getValue('avalaratax_address_line1'));
				Configuration::updateValue('AVALARATAX_ADDRESS_LINE2', Tools::getValue('avalaratax_address_line2'));
				Configuration::updateValue('AVALARATAX_CITY', Tools::getValue('avalaratax_city'));
				Configuration::updateValue('AVALARATAX_STATE', Tools::getValue('avalaratax_state'));
				Configuration::updateValue('AVALARATAX_ZIP_CODE', Tools::getValue('avalaratax_zip_code'));
			}
		}
		elseif (Tools::isSubmit('SubmitAvalaraTaxClearCache'))
		{
			Db::getInstance()->Execute('TRUNCATE TABLE `'._DB_PREFIX_.'avalara_product_cache`');
			Db::getInstance()->Execute('TRUNCATE TABLE `'._DB_PREFIX_.'avalara_carrier_cache`');

			$buffer .= $this->_displayConfirmation('Cache cleared!');
		}

		$confValues = Configuration::getMultiple(array(
										// Configuration
										'AVALARATAX_ACCOUNT_NUMBER', 'AVALARATAX_LICENSE_KEY', 'AVALARATAX_URL', 'AVALARATAX_COMPANY_CODE',
										// Options
										'AVALARATAX_ADDRESS_VALIDATION', 'AVALARATAX_TAX_CALCULATION', 'AVALARATAX_TIMEOUT',
										'AVALARATAX_ADDRESS_NORMALIZATION', 'AVALARATAX_TAX_OUTSIDE', 'AVALARATAX_COMMIT_ID', 'AVALARATAX_CANCEL_ID',
										'AVALARATAX_REFUND_ID', 'AVALARATAX_POST_ID', 'AVALARA_CACHE_MAX_LIMIT',
										// Default Address
										'AVALARATAX_ADDRESS_LINE1', 'AVALARATAX_ADDRESS_LINE2', 'AVALARATAX_CITY', 'AVALARATAX_STATE',
										'AVALARATAX_ZIP_CODE', 'AVALARATAX_COUNTRY'));

		$stateList = array();
		$stateList[] = array('id' => '0', 'name' => $this->l('Choose your state (if applicable)'), 'iso_code' => '--');
		foreach (State::getStates((int)$this->context->cookie->id_lang) as $state)
			$stateList[] = array('id' => $state['id_state'], 'name' => $state['name'], 'iso_code' => $state['iso_code']);

		$countryList = array();
		$countryList[] = array('id' => '0', 'name' => $this->l('Choose your country'), 'iso_code' => '--');
		foreach (Country::getCountries((int)$this->context->cookie->id_lang, false, null, false) as $country)
			$countryList[] = array('id' => $country['id_country'], 'name' => $country['name'], 'iso_code' => $country['iso_code']);

		$buffer .= '<link href="'.$this->_path.'css/avalara.css" rel="stylesheet" type="text/css">
		<script type="text/javascript">
			/* Fancybox */
			$(\'a.avalara-video-btn\').live(\'click\', function(){
			    $.fancybox({
			        \'type\' : \'iframe\',
			        \'href\' : this.href.replace(new RegExp("watch\\?v=", "i"), \'embed\') + \'?rel=0&autoplay=1\',
			        \'swf\': {\'allowfullscreen\':\'true\', \'wmode\':\'transparent\'},
			        \'overlayShow\' : true,
			        \'centerOnScroll\' : true,
			        \'speedIn\' : 100,
			        \'speedOut\' : 50,
			        \'width\' : 853,
			        \'height\' : 480
			    });
			    return false;
			});
		</script>
		<script type="text/javascript">
			$(document).ready(function(){
			    var height1 = 0;
			    var height = 0;
			     $(\'.field-height1\').each(function(){
				if (height1 < $(this).height())
				    height1 = $(this).height();
			    });
			    
			    $(\'.field-height\').each(function(){
				if (height < $(this).height())
				    height = $(this).height();
			    });
			
				$(\'.field-height1\').css({\'height\' : $(\'.field-height1\').css(\'height\', height1+\'px\')});
			    $(\'.field-height\').css({\'height\' : $(\'.field-height\').css(\'height\', height+\'px\')});

updateAvalaraTaxState($(\'#avalaratax_country\').val());

    $(\'#avalaratax_country\').change(function(){
updateAvalaraTaxState($(this).val());
    });


			});
function updateAvalaraTaxState(iso_code)
{

var default_state = "'.$confValues['AVALARATAX_STATE'].'";

$(\'#avalaratax_state\').html(\'\');
	$.ajax({
	    type : \'GET\',
	    url : \'../modules/avalaratax/states.php?country_iso_code=\'+iso_code,
	    dataType: \'JSON\',
	    success: function(data)
	    {
		if (data != 0)
		{
		    $.each(data[iso_code], function(i, item){
if (default_state == item.state_iso_code)
			$(\'#avalaratax_state\').append(\'<option  selected="selected" value="\'+item.state_iso_code+\'">\'+item.name+\'</option>\');
else
			$(\'#avalaratax_state\').append(\'<option  value="\'+item.state_iso_code+\'">\'+item.name+\'</option>\');
			$(\'#avalaratax_state\').show();
			$(\'#avalaratax_label_state\').show();
		    });
		}
		else
		{
		    $(\'#avalaratax_state\').hide();
		    $(\'#avalaratax_label_state\').hide();
		}
	    }
	});

}

		</script>
		<div class="avalara-wrap">
			<p class="avalara-intro"><a href="http://www.avalara.com/e-commerce/prestashop" class="avalara-logo" target="_blank"><img src="'.$this->_path.'img/avalara_logo.png" alt="Avalara" border="0" /></a><a href="http://www.avalara.com/e-commerce/prestashop" class="avalara-link" target="_blank">'.$this->l('Create an account').'</a>'.$this->l('Avalara and PrestaShop have partnered to provide the easiest way for you to accurately calculate and fill sales tax.').'</p>
			<div class="clear"></div>
			<div class="avalara-content">
				<div class="avalara-video">
					<h3>'.$this->l('No one likes dealing with sales tax.').'</h3>
					<p>'.$this->l('Sales tax isn\'t core to your business and should be automated. You may be doing it wrong, exposing your business to unnecessary audit risks, and don\'t even know it.').'</p>
					<a href="http://www.youtube.com/embed/tm1tENVdcQ8" class="avalara-video-btn"><img src="'.$this->_path.'img/avalara-video-screen.jpg" alt="Avalara Video" /><img src="'.$this->_path.'img/btn-video.png" alt="" class="video-icon" /></a>
				</div>
				<h3>'.$this->l('Doing sales tax right is simple with Avalara.').'</h3>
				<p>'.$this->l('We do all of the research and automate the process for you, ensuring that the system is up-to-date with the most recent sales tax and VAT rates and rules in every state and country, so you don’t have to.  As a cloud-based service, AvaTax eliminates ongoing maintenance and support.  It provides you with a complete solution to manage your sales tax needs.').'</p>
				<img src="'.$this->_path.'img/avatax_badge.png" alt="AvaTax Certified" class="avatax-badge" />
				<ul>
					<li>'.$this->l('Address Validation included').'</li>
					<li>'.$this->l('Rooftop Accurate Calculations').'</li>
					<li>'.$this->l('Product and Service Taxability Rules').'</li>
					<li>'.$this->l('Exemption Certificate Management').'</li>
					<li>'.$this->l('Out-of-the-Box Sales Tax Reporting').'</li>
				</ul>
				<a href="http://www.avalara.com/e-commerce/prestashop" class="avalara-link" target="_blank">'.$this->l('Create an account').'</a>
			</div>
			<fieldset class="field-height1 right-fieldset">
			<legend><img src="'.$this->_path.'img/icon-console.gif" alt="" />'.$this->l('AvaTax Admin Console').'</legend>
				<p><a href="https://admin-avatax.avalara.net/" target="_blank">'.$this->l('Log-in to AvaTax Admin Console').'</a></p>
				<a href="https://admin-avatax.avalara.net/" target="_blank"><img src="'.$this->_path.'img/avatax-logo.png" alt="AvaTax" class="avatax-logo" /></a>
			</fieldset>
			<form action="'.Tools::safeOutput($_SERVER['REQUEST_URI']).'" method="post" class="left-form">
				<fieldset class="field-height1">
					<legend><img src="'.$this->_path.'img/icon-config.gif" alt="" />'.$this->l('Configuration').'</legend>
					<h4>'.$this->l('AvaTax Credentials').'</h4>';	
					if (isset($connectionTestResult))
						$buffer .= '<div id="test_connection" style="background: '.Tools::safeOutput($connectionTestResult[1]).';">'.$connectionTestResult[0].'</div>';
			
					$buffer .= '<label>'.$this->l('Account Number').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_account_number" value="'.(isset($confValues['AVALARATAX_ACCOUNT_NUMBER']) ? Tools::safeOutput($confValues['AVALARATAX_ACCOUNT_NUMBER']) : '').'" />
					</div>
					<label>'.$this->l('License Key').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_license_key" value="'.(isset($confValues['AVALARATAX_LICENSE_KEY']) ? Tools::safeOutput($confValues['AVALARATAX_LICENSE_KEY']) : '').'" />
					</div>
					<label>'.$this->l('URL').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_url" value="'.(isset($confValues['AVALARATAX_URL']) ? Tools::safeOutput($confValues['AVALARATAX_URL']) : '').'" />
					</div>
					<label>'.$this->l('Company Code').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_company_code" value="'.(isset($confValues['AVALARATAX_COMPANY_CODE']) ? Tools::safeOutput($confValues['AVALARATAX_COMPANY_CODE']) : '').'" /> '.$this->l('Located in the top-right corner of your AvaTax Admin Console').'
					</div>
					<div class="margin-form">
						<input type="submit" class="button" name="SubmitAvalaraTaxSettings" value="'.$this->l('Save Settings').'" /><img src="'.$this->_path.'img/icon-connection.gif" alt="" class="icon-connection" /><input type="submit" id="avalaratax_test_connection" class="button" name="SubmitAvalaraTestConnection" value="'.$this->l('Click here to Test Connection').'" />
					</div>
				</fieldset>
			</form>
			<form action="'.Tools::safeOutput($_SERVER['REQUEST_URI']).'" method="post" class="form-half reset-label">
				<fieldset class="field-height MR7">
					<legend><img src="'.$this->_path.'img/icon-options.gif" alt="" />'.$this->l('Options').'</legend>
					<label>'.$this->l('Enable address validation').'</label>
					<div class="margin-form">
						<input type="checkbox" name="avalaratax_address_validation" value="1"'.(isset($confValues['AVALARATAX_ADDRESS_VALIDATION']) && $confValues['AVALARATAX_ADDRESS_VALIDATION'] ? ' checked="checked"' : '').' />
					</div>
					<label>'.$this->l('Enable tax calculation').'</label>
					<div class="margin-form">
						<input type="checkbox" name="avalaratax_tax_calculation" value="1" '.(isset($confValues['AVALARATAX_TAX_CALCULATION']) && $confValues['AVALARATAX_TAX_CALCULATION'] ? ' checked="checked"' : '').' />
					</div>
					<label>'.$this->l('Enable address normalization in uppercase').'</label>
					<div class="margin-form">
						<input type="checkbox" name="avalaratax_address_normalization" value="1" '.(isset($confValues['AVALARATAX_ADDRESS_NORMALIZATION']) && $confValues['AVALARATAX_ADDRESS_NORMALIZATION'] ? ' checked="checked"' : '').' />
					</div>
					<label>'.$this->l('Enable tax calculation outside of your state').'</label>
					<div class="margin-form">
						<input type="checkbox" name="avalaratax_tax_outside" value="1" '.(isset($confValues['AVALARATAX_TAX_OUTSIDE']) && $confValues['AVALARATAX_TAX_OUTSIDE'] ? ' checked="checked"' : '').' />
					</div>
					<label>'.$this->l('Request timeout').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_timeout" value="'.(isset($confValues['AVALARATAX_TIMEOUT']) ? Tools::safeOutput($confValues['AVALARATAX_TIMEOUT']) : '').'" style="width: 40px;" /> '.$this->l('seconds').'
					</div>
					<div style="display: none;"
						<label>'.$this->l('Refresh tax rate cache every: ').'</label>
						<div class="margin-form">
							<input type="text" name="avalara_cache_max_limit" value="'.(isset($confValues['AVALARA_CACHE_MAX_LIMIT']) ? Tools::safeOutput($confValues['AVALARA_CACHE_MAX_LIMIT']) : '').'" style="width: 40px;" /> '.$this->l('minutes').'
						</div>
					</div>
					<div class="margin-form">
						<input type="submit" class="button avalaratax_button" name="SubmitAvalaraTaxOptions" value="'.$this->l('Save Settings').'" />
						<input type="submit" class="button avalaratax_button" name="SubmitAvalaraTaxClearCache" value="'.$this->l('Clear Cache').'" style="display: none;"/>
					</div>
					<div class="sep"></div>
					<h4>'.$this->l('Default Post/Commit/Cancel/Refund Options').'</h4>
					<span class="avalara-info">'.$this->l('When an order\'s status is updated, the following options will be used to update Avalara\'s records.').'</span>';
	
			// Check if the order status exist
			$orderStatusList = array();
			foreach (Db::getInstance()->ExecuteS('SELECT `id_order_state`, `name` FROM `'._DB_PREFIX_.'order_state_lang` WHERE `id_lang` = '.(int)$this->context->cookie->id_lang) as $v)
				$orderStatusList[$v['id_order_state']] = Tools::safeOutput($v['name']);
			$buffer .= '<table class="avalara-table" cellspacing="0" cellpadding="0" width="100%">
						<th>'.$this->l('Action').'</th>
						<th>'.$this->l('Order status in your store').'</th>
						<tr>
							<td class="avalaratax_column">'.$this->l('Post order to Avalara').':</td>
							<td>'.(isset($orderStatusList[Configuration::get('AVALARATAX_POST_ID')]) ? html_entity_decode(Tools::safeOutput($orderStatusList[Configuration::get('AVALARATAX_POST_ID')])) :
								'<div style="color: red">'.$this->l('[ERROR] A default value was not found. Please, restore PrestaShop\'s default statuses.').'</div>').'
							</td>
						</tr>
						<tr>
							<td class="avalaratax_column">'.$this->l('Commit order to Avalara').':</td>
							<td>'.(isset($orderStatusList[Configuration::get('AVALARATAX_COMMIT_ID')]) ? html_entity_decode(Tools::safeOutput($orderStatusList[Configuration::get('AVALARATAX_COMMIT_ID')])) :
								'<div style="color: red">'.$this->l('[ERROR] A default value was not found. Please, restore PrestaShop\'s default statuses.').'</div>').'
							</td>
						</tr>
						<tr>
							<td class="avalaratax_column">'.$this->l('Delete order from Avalara').':</td>
							<td>'.(isset($orderStatusList[Configuration::get('AVALARATAX_CANCEL_ID')]) ? html_entity_decode(Tools::safeOutput($orderStatusList[Configuration::get('AVALARATAX_CANCEL_ID')])) :
								'<div style="color: red">'.$this->l('[ERROR] A default value was not found. Please, restore PrestaShop\'s default statuses.').'</div>').'
							</td>
						</tr>
						<tr>
							<td class="avalaratax_column last">'.$this->l('Void order in Avalara').':</td>
							<td class="last">'.(isset($orderStatusList[Configuration::get('AVALARATAX_REFUND_ID')]) ? html_entity_decode(Tools::safeOutput($orderStatusList[Configuration::get('AVALARATAX_REFUND_ID')])) :
								'<div style="color: red">'.$this->l('[ERROR] A default value was not found. Please, restore PrestaShop\'s default statuses.').'</div>').'
							</td>
						</tr>
					</table>
				</fieldset>
			</form>
			<form action="'.Tools::safeOutput($_SERVER['REQUEST_URI']).'" method="post" class="form-half">
				<fieldset class="field-height ML7">
					<legend><img src="'.$this->_path.'img/icon-address.gif" alt="" />'.$this->l('Default Origin Address').'</legend>
					<label>'.$this->l('Address Line 1').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_address_line1" value="'.(isset($confValues['AVALARATAX_ADDRESS_LINE1']) ? Tools::safeOutput($confValues['AVALARATAX_ADDRESS_LINE1']) : '').'" />
					</div>
					<label>'.$this->l('Address Line 2').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_address_line2" value="'.(isset($confValues['AVALARATAX_ADDRESS_LINE2']) ? Tools::safeOutput($confValues['AVALARATAX_ADDRESS_LINE2']) : '').'" />
					</div>
					<label>'.$this->l('City').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_city" value="'.(isset($confValues['AVALARATAX_CITY']) ? Tools::safeOutput($confValues['AVALARATAX_CITY']) : '').'" />
					</div>
					<label>'.$this->l('Zip Code').'</label>
					<div class="margin-form">
						<input type="text" name="avalaratax_zip_code" value="'.(isset($confValues['AVALARATAX_ZIP_CODE']) ? Tools::safeOutput($confValues['AVALARATAX_ZIP_CODE']) : '').'" />
					</div>
					<label>'.$this->l('Country').'</label>
					<div class="margin-form">
						<select name="avalaratax_country" id="avalaratax_country">';
			foreach ($countryList as $country)
				$buffer .= '<option value="'.substr(strtoupper($country['iso_code']), 0, 2).'" '.($country['iso_code'] == $confValues['AVALARATAX_COUNTRY'] ? ' selected="selected"' : '').'>'.Tools::safeOutput($country['name']).'</option>';
			$buffer .= '</select>
					</div>
					<label id="avalaratax_label_state" >'.$this->l('State').'</label>
					<div class="margin-form">
						<select name="avalaratax_state" id="avalaratax_state">';
			foreach ($stateList as $state)
				$buffer .= '<option value="'.substr(strtoupper($state['iso_code']), 0, 2).'" '.($state['iso_code'] == $confValues['AVALARATAX_STATE'] ? ' selected="selected"' : '').'>'.Tools::safeOutput($state['name']).'</option>';
			return $buffer .'</select>
					</div>
					<div class="margin-form">
						<input type="submit" class="button" name="SubmitAvalaraAddressOptions" value="'.$this->l('Save Settings').'" />
					</div>
				</fieldset>
			</form>
			<div class="clear"></div>
		</div>';
	}

	/*
	** Display a custom message for settings update
	** $text string Text to be displayed in the message
	** $type string (confirm|warn|error) Decides what color will the message have (green|yellow)
	*/
	private function _displayConfirmation($text = '', $type = 'confirm')
	{
		if ($type == 'confirm')
			$img = 'ok.gif';
		elseif ($type == 'warn')
			$img = 'warn2.png';
		elseif ($type == 'error')
			$img = 'disabled.gif';
		else
			die('Invalid type.');

		return '<div class="conf '.Tools::safeOutput($type).'">
			<img src="../img/admin/'.$img.'" alt="" title="" />
			'.(empty($text) ? $this->l('Settings updated') : $text).
			'<img src="http://www.prestashop.com/modules/avalaratax.png?sid='.urlencode(Configuration::get('AVALARATAX_ACCOUNT_NUMBER')).'" style="float: right;" />
		</div>';
	}

	/**
	 * @brief init the Avatax SDK
	 */
	private function _connectToAvalara()
	{
		$timeout = Configuration::get('AVALARATAX_TIMEOUT');
		if ((int)$timeout > 0)
			ini_set('max_execution_time', (int)$timeout);

		include_once(dirname(__FILE__).'/sdk/AvaTax.php');

		/* Just instanciate the ATConfig class to init the settings (mandatory...)*/
		new ATConfig(Configuration::get('AVALARATAX_MODE'), array('url' => Configuration::get('AVALARATAX_URL'), 'account' => Configuration::get('AVALARATAX_ACCOUNT_NUMBER'),
				'license' => Configuration::get('AVALARATAX_LICENSE_KEY'), 'trace' => false));
	}

	/**
	 * @brief Connect to Avalara to make sure everything is OK
	 */
	private function _testConnection()
	{
		$this->_connectToAvalara();
		try
		{
			$client = new TaxServiceSoap(Configuration::get('AVALARATAX_MODE'));
			$connectionTest = $client->ping();
			if ($connectionTest->getResultCode() == SeverityLevel::$Success)
			{
				try
				{
					$authorizedTest = $client->isAuthorized('GetTax');
					if ($authorizedTest->getResultCode() == SeverityLevel::$Success)
						$expirationDate = $authorizedTest->getexpires();
				}
				catch (SoapFault $exception)
				{
				}

				return array('<img src="../img/admin/ok.gif" alt="" /><strong style="color: green;">'.$this->l('Connection Test performed successfully.').'</strong><br /><br />'.$this->l('Ping version is:').' '.Tools::safeOutput($connectionTest->getVersion()).(isset($expirationDate) ? '<br /><br />'.$this->l('License Expiration Date:').' '.Tools::safeOutput($expirationDate) : ''), '#D6F5D6');
			}
		}
		catch (SoapFault $exception)
		{
			return array('<img src="../img/admin/forbbiden.gif" alt="" /><b style="color: #CC0000;">'.$this->l('Connection Test Failed.').'</b><br /><br />'.$this->l('Either the Account or License Key is incorrect. Please confirm the Account and License Key before testing the connection again.').'<br /><br /><strong style="color: #CC0000;">'.$this->l('Error(s):').' '.Tools::safeOutput($exception->faultstring).'</strong>', '#FFD8D8');
		}
	}

	/**
	 * @brief Validates a given address
	 */
	public function validateAddress(Address $address)
	{
		$this->_connectToAvalara();
		$client = new AddressServiceSoap(Configuration::get('AVALARATAX_MODE'));

		if (!empty($address->id_state))
			$state = new State((int)$address->id_state);
		if (!empty($address->id_country))
			$country = new Country((int)$address->id_country);

		$avalaraAddress = new AvalaraAddress($address->address1, $address->address2, null, $address->city,
											(isset($state) ? $state->iso_code : null), $address->postcode, (isset($country) ? $country->iso_code : null), 0);

		$buffer = array();
		try
		{
			$request = new ValidateRequest($avalaraAddress, TextCase::$Upper, false);
			$result = $client->Validate($request);
			$addresses = $result->ValidAddresses;

			$buffer['ResultCode'] = Tools::safeOutput($result->getResultCode());
			if ($result->getResultCode() != SeverityLevel::$Success)
				foreach ($result->getMessages() as $msg)
				{
					$buffer['Messages']['Name'][] = Tools::safeOutput($msg->getName());
					$buffer['Messages']['Summary'][] = Tools::safeOutput($msg->getSummary());
				}
			else
				foreach ($result->getvalidAddresses() as $valid)
				{
					$buffer['Normalized']['Line1'] = Tools::safeOutput($valid->getline1());
					$buffer['Normalized']['Line2'] = Tools::safeOutput($valid->getline2());
					$buffer['Normalized']['City']= Tools::safeOutput($valid->getcity());
					$buffer['Normalized']['Region'] = Tools::safeOutput($valid->getregion());
					$buffer['Normalized']['PostalCode'] = Tools::safeOutput($valid->getpostalCode());
					$buffer['Normalized']['Country'] = Tools::safeOutput($valid->getcountry());
					$buffer['Normalized']['County'] = Tools::safeOutput($valid->getcounty());
					$buffer['Normalized']['FIPS'] = Tools::safeOutput($valid->getfipsCode());
					$buffer['Normalized']['PostNet'] = Tools::safeOutput($valid->getpostNet());
					$buffer['Normalized']['CarrierRoute'] = Tools::safeOutput($valid->getcarrierRoute());
					$buffer['Normalized']['AddressType'] = Tools::safeOutput($valid->getaddressType());
				}
		}
		catch (SoapFault $exception)
		{
			$buffer['Exception']['FaultString'] = Tools::safeOutput($exception->faultstring);
			$buffer['Exception']['LastRequest'] = Tools::safeOutput($client->__getLastRequest());
			$buffer['Exception']['LastResponse'] = Tools::safeOutput($client->__getLastResponse());
		}
		return $buffer;
	}

	/**
	 * @brief Executes tax actions on documents
	 *
	 * @param Array $products Array of Product for which taxes need to be calculated
	 * @param Array $params
	 * 		type : (default SalesOrder) SalesOrder|SalesInvoice|ReturnInvoice
	 * 		cart : (required for SalesOrder and SalesInvoice) Cart object
	 * 		DocCode : (required in ReturnInvoice, and when 'cart' is not set) Specify the Document Code
	 *
	 */
	public function getTax($products = array(), $params = array())
	{
		$confValues = Configuration::getMultiple(array('AVALARATAX_COMPANY_CODE', 'AVALARATAX_ADDRESS_LINE1',
										'AVALARATAX_ADDRESS_LINE2', 'AVALARATAX_CITY', 'AVALARATAX_STATE', 'AVALARATAX_ZIP_CODE'));
		if (!isset($params['type']))
			$params['type'] = 'SalesOrder';
		$this->_connectToAvalara();
		$client = new TaxServiceSoap(Configuration::get('AVALARATAX_MODE'));
		$request = new GetTaxRequest();

		if (isset($params['cart']) && (int)$params['cart']->{Configuration::get('PS_TAX_ADDRESS_TYPE')})
			$address = new Address((int)$params['cart']->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
		elseif (isset($this->context->cookie) && isset($this->contract->cookie->id_customer) && $this->context->cookie->id_customer)
			$address = new Address((int)Db::getInstance()->getValue('SELECT `id_address` FROM `'._DB_PREFIX_.'address`	WHERE `id_customer` = '.(int)$this->context->cookie->id_customer.' AND active = 1 AND deleted = 0'));

		if (isset($address))
		{
			if (!empty($address->id_state))
				$state = new State((int)$address->id_state);
			$addressDest = array();
			$addressDest['Line1'] = $address->address1;
			$addressDest['Line2'] = $address->address2;
			$addressDest['City'] = $address->city;
			$addressDest['Region'] = isset($state) ? $state->iso_code : '';
			$addressDest['PostalCode'] = $address->postcode;
			$addressDest['Country'] = Country::getIsoById($address->id_country);


			// Try to normalize the address depending on option in the BO
			if (Configuration::get('AVALARATAX_ADDRESS_NORMALIZATION'))
				$normalizedAddress = $this->validateAddress($address);

			if (isset($normalizedAddress['Normalized']))
				$addressDest = $normalizedAddress['Normalized'];

			// Add Destination address (Customer address)
			$destination = new AvalaraAddress();
			$destination->setLine1($addressDest['Line1']);
			$destination->setLine2($addressDest['Line2']);
			$destination->setCity($addressDest['City']);
			$destination->setRegion($addressDest['Region']);
			$destination->setPostalCode($addressDest['PostalCode']);
			$destination->setCountry($addressDest['Country']);

			$request->setDestinationAddress($destination);
		}

		// Origin Address (Store Address or address setup in BO)
		$origin = new AvalaraAddress();
		$origin->setLine1(isset($confValues['AVALARATAX_ADDRESS_LINE1']) ? $confValues['AVALARATAX_ADDRESS_LINE1'] : '');
		$origin->setLine2(isset($confValues['AVALARATAX_ADDRESS_LINE2']) ? $confValues['AVALARATAX_ADDRESS_LINE2'] : '');
		$origin->setCity(isset($confValues['AVALARATAX_CITY']) ? $confValues['AVALARATAX_CITY'] : '');
		$origin->setRegion(isset($confValues['AVALARATAX_STATE']) ? $confValues['AVALARATAX_STATE'] : '');
		$origin->setPostalCode(isset($confValues['AVALARATAX_ZIP_CODE']) ? $confValues['AVALARATAX_ZIP_CODE'] : '');
		$request->setOriginAddress($origin);

		$request->setCompanyCode(isset($confValues['AVALARATAX_COMPANY_CODE']) ? $confValues['AVALARATAX_COMPANY_CODE'] : '');
		$orderId = isset($…