ganalytics.php

<?php
/**
 * 2007-2015 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-2015 PrestaShop SA
 *  @license   http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 *  International Registered Trademark & Property of PrestaShop SA
 */

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

class Ganalytics extends Module
{
	protected $js_state = 0;
	protected $eligible = 0;
	protected $filterable = 1;
	protected static $products = array();
	protected $_debug = 0;

	public function __construct()
	{
		$this->name = 'ganalytics';
		$this->tab = 'analytics_stats';
		$this->version = '2.3.4';
		$this->author = 'PrestaShop';
		$this->module_key = 'fd2aaefea84ac1bb512e6f1878d990b8';
		$this->bootstrap = true;

		parent::__construct();

		$this->displayName = $this->l('Google Analytics');
		$this->description = $this->l('Gain clear insights into important metrics about your customers, using Google Analytics');
		$this->confirmUninstall = $this->l('Are you sure you want to uninstall Google Analytics? You will lose all the data related to this module.');
		/* Backward compatibility */
		if (version_compare(_PS_VERSION_, '1.5', '<'))
			require(_PS_MODULE_DIR_.$this->name.'/backward_compatibility/backward.php');

		$this->checkForUpdates();
	}

	public function install()
	{
		if (version_compare(_PS_VERSION_, '1.5', '>=') && Shop::isFeatureActive())
			Shop::setContext(Shop::CONTEXT_ALL);

		if (!parent::install() || !$this->installTab() || !$this->registerHook('header') || !$this->registerHook('adminOrder')
			|| !$this->registerHook('footer') || !$this->registerHook('home')
			|| !$this->registerHook('productfooter') || !$this->registerHook('orderConfirmation')
			|| !$this->registerHook('backOfficeHeader'))
			return false;

		if (version_compare(_PS_VERSION_, '1.5', '>=')
			&& (!$this->registerHook('actionProductCancel') || !$this->registerHook('actionCartSave')))
			return false;

		Db::getInstance()->Execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'ganalytics`');

		if (!Db::getInstance()->Execute('
			CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'ganalytics` (
				`id_google_analytics` int(11) NOT NULL AUTO_INCREMENT,
				`id_order` int(11) NOT NULL,
				`id_customer` int(10) NOT NULL,
				`id_shop` int(11) NOT NULL,
				`sent` tinyint(1) DEFAULT NULL,
				`date_add` datetime DEFAULT NULL,
				PRIMARY KEY (`id_google_analytics`),
				KEY `id_order` (`id_order`),
				KEY `sent` (`sent`)
			) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=1'))
			return $this->uninstall();

		return true;
	}

	public function uninstall()
	{
		if (!$this->uninstallTab() || !parent::uninstall())
			return false;

		return Db::getInstance()->Execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'ganalytics`');
	}

	public function installTab()
	{
		if (version_compare(_PS_VERSION_, '1.5', '<'))
			return true;

		$tab = new Tab();
		$tab->active = 0;
		$tab->class_name = 'AdminGanalyticsAjax';
		$tab->name = array();
		foreach (Language::getLanguages(true) as $lang)
			$tab->name[$lang['id_lang']] = 'Google Analytics Ajax';
		$tab->id_parent = -1; //(int)Tab::getIdFromClassName('AdminAdmin');
		$tab->module = $this->name;
		return $tab->add();
	}

	public function uninstallTab()
	{
		if (version_compare(_PS_VERSION_, '1.5', '<'))
			return true;

		$id_tab = (int)Tab::getIdFromClassName('AdminGanalyticsAjax');
		if ($id_tab)
		{
			$tab = new Tab($id_tab);
			return $tab->delete();
		}

		return true;
	}

	public function displayForm()
	{
		// Get default language
		$default_lang = (int)Configuration::get('PS_LANG_DEFAULT');

		$helper = new HelperForm();

		// Module, token and currentIndex
		$helper->module = $this;
		$helper->name_controller = $this->name;
		$helper->token = Tools::getAdminTokenLite('AdminModules');
		$helper->currentIndex = AdminController::$currentIndex.'&configure='.$this->name;

		// Language
		$helper->default_form_language = $default_lang;
		$helper->allow_employee_form_lang = $default_lang;

		// Title and toolbar
		$helper->title = $this->displayName;
		$helper->show_toolbar = true;		// false -> remove toolbar
		$helper->toolbar_scroll = true;	  // yes - > Toolbar is always visible on the top of the screen.
		$helper->submit_action = 'submit'.$this->name;
		$helper->toolbar_btn = array(
			'save' =>
			array(
				'desc' => $this->l('Save'),
				'href' => AdminController::$currentIndex.'&configure='.$this->name.'&save'.$this->name.
				'&token='.Tools::getAdminTokenLite('AdminModules'),
			),
			'back' => array(
				'href' => AdminController::$currentIndex.'&token='.Tools::getAdminTokenLite('AdminModules'),
				'desc' => $this->l('Back to list')
			)
		);

		$fields_form = array();
		// Init Fields form array
		$fields_form[0]['form'] = array(
			'legend' => array(
				'title' => $this->l('Settings'),
			),
			'input' => array(
				array(
					'type' => 'text',
					'label' => $this->l('Google Analytics Tracking ID'),
					'name' => 'GA_ACCOUNT_ID',
					'size' => 20,
					'required' => true,
					'hint' => $this->l('This information is available in your Google Analytics account')
				),
				array(
					'type' => 'radio',
					'label' => $this->l('Enable User ID tracking'),
					'name' => 'GA_USERID_ENABLED',
					'hint' => $this->l('The User ID is set at the property level. To find a property, click Admin, then select an account and a property. From the Property column, click Tracking Info then User ID'),
					'values'    => array(
						array(
							'id' => 'ga_userid_enabled',
							'value' => 1,
							'label' => $this->l('Enabled')
						),
						array(
							'id' => 'ga_userid_disabled',
							'value' => 0,
							'label' => $this->l('Disabled')
						),
					),
				),
			),
			'submit' => array(
				'title' => $this->l('Save'),
			)
		);

		// Load current value
		$helper->fields_value['GA_ACCOUNT_ID'] = Configuration::get('GA_ACCOUNT_ID');
		$helper->fields_value['GA_USERID_ENABLED'] = Configuration::get('GA_USERID_ENABLED');

		return $helper->generateForm($fields_form);
	}

	/**
	 * back office module configuration page content
	 */
	public function getContent()
	{
		$output = '';
		if (Tools::isSubmit('submit'.$this->name))
		{
			$ga_account_id = Tools::getValue('GA_ACCOUNT_ID');
			if (!empty($ga_account_id))
			{
				Configuration::updateValue('GA_ACCOUNT_ID', $ga_account_id);
				Configuration::updateValue('GANALYTICS_CONFIGURATION_OK', true);
				$output .= $this->displayConfirmation($this->l('Account ID updated successfully'));
			}
			$ga_userid_enabled = Tools::getValue('GA_USERID_ENABLED');
			if (null !== $ga_userid_enabled)
			{
				Configuration::updateValue('GA_USERID_ENABLED', (bool)$ga_userid_enabled);
				$output .= $this->displayConfirmation($this->l('Settings for User ID updated successfully'));
			}
		}

		if (version_compare(_PS_VERSION_, '1.5', '>='))
			$output .= $this->displayForm();
		else
		{
			$this->context->smarty->assign(array(
				'account_id' => Configuration::get('GA_ACCOUNT_ID'),
			));
			$output .= $this->display(__FILE__, 'views/templates/admin/form-ps14.tpl');
		}

		return $this->display(__FILE__, 'views/templates/admin/configuration.tpl').$output;
	}

	protected function _getGoogleAnalyticsTag($back_office = false)
	{
		$user_id = null;
		if (Configuration::get('GA_USERID_ENABLED') &&
			$this->context->customer && $this->context->customer->isLogged()
		){
			$user_id = (int)$this->context->customer->id;
		}

		return '
			<script type="text/javascript">
				(window.gaDevIds=window.gaDevIds||[]).push(\'d6YPbH\');
				(function(i,s,o,g,r,a,m){i[\'GoogleAnalyticsObject\']=r;i[r]=i[r]||function(){
				(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
				m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
				})(window,document,\'script\',\'//www.google-analytics.com/analytics.js\',\'ga\');
				ga(\'create\', \''.Tools::safeOutput(Configuration::get('GA_ACCOUNT_ID')).'\', \'auto\');
				ga(\'require\', \'ec\');'
				.(($user_id && !$back_office) ? 'ga(\'set\', \'&uid\', \''.$user_id.'\');': '')
				.($back_office ? 'ga(\'set\', \'nonInteraction\', true);' : '')
			.'</script>';
	}

	public function hookHeader()
	{
		if (Configuration::get('GA_ACCOUNT_ID'))
		{
			$this->context->controller->addJs($this->_path.'views/js/GoogleAnalyticActionLib.js');

			return $this->_getGoogleAnalyticsTag();
		}
	}

	/**
	 * Return a detailed transaction for Google Analytics
	 */
	public function wrapOrder($id_order)
	{
		$order = new Order((int)$id_order);

		if (Validate::isLoadedObject($order))
			return array(
				'id' => $id_order,
				'affiliation' => Shop::isFeatureActive() ? $this->context->shop->name : Configuration::get('PS_SHOP_NAME'),
				'revenue' => $order->total_paid,
				'shipping' => $order->total_shipping,
				'tax' => $order->total_paid_tax_incl - $order->total_paid_tax_excl,
				'url' => $this->context->link->getAdminLink('AdminGanalyticsAjax'),
				'customer' => $order->id_customer);
	}

	/**
	 * To track transactions
	 */
	public function hookOrderConfirmation($params)
	{
		$order = $params['objOrder'];
		if (Validate::isLoadedObject($order) && $order->getCurrentState() != (int)Configuration::get('PS_OS_ERROR'))
		{
			$ga_order_sent = Db::getInstance()->getValue('SELECT id_order FROM `'._DB_PREFIX_.'ganalytics` WHERE id_order = '.(int)$order->id);
			if ($ga_order_sent === false)
			{
				Db::getInstance()->Execute('INSERT INTO `'._DB_PREFIX_.'ganalytics` (id_order, id_shop, sent, date_add) VALUES ('.(int)$order->id.', '.(int)$this->context->shop->id.', 0, NOW())');
				if ($order->id_customer == $this->context->cookie->id_customer)
				{
					$order_products = array();
					$cart = new Cart($order->id_cart);
					foreach ($cart->getProducts() as $order_product)
						$order_products[] = $this->wrapProduct($order_product, array(), 0, true);

					$transaction = array(
						'id' => $order->id,
						'affiliation' => (version_compare(_PS_VERSION_, '1.5', '>=') && Shop::isFeatureActive()) ? $this->context->shop->name : Configuration::get('PS_SHOP_NAME'),
						'revenue' => $order->total_paid,
						'shipping' => $order->total_shipping,
						'tax' => $order->total_paid_tax_incl - $order->total_paid_tax_excl,
						'url' => $this->context->link->getModuleLink('ganalytics', 'ajax', array(), true),
						'customer' => $order->id_customer);
					$ga_scripts = $this->addTransaction($order_products, $transaction);

					$this->js_state = 1;
					return $this->_runJs($ga_scripts);
				}
			}
		}
	}

	/**
	 * hook footer to load JS script for standards actions such as product clicks
	 */
	public function hookFooter()
	{
		$ga_scripts = '';
		$this->js_state = 0;

		if (isset($this->context->cookie->ga_cart))
		{
			$this->filterable = 0;

			$gacarts = unserialize($this->context->cookie->ga_cart);
			foreach ($gacarts as $gacart)
			{
				if ($gacart['quantity'] > 0)
					$ga_scripts .= 'MBG.addToCart('.Tools::jsonEncode($gacart).');';
				elseif ($gacart['quantity'] < 0)
				{
					$gacart['quantity'] = abs($gacart['quantity']);
					$ga_scripts .= 'MBG.removeFromCart('.Tools::jsonEncode($gacart).');';
				}
			}
			unset($this->context->cookie->ga_cart);
		}

		$controller_name = Tools::getValue('controller');
		$products = $this->wrapProducts($this->context->smarty->getTemplateVars('products'), array(), true);

		if ($controller_name == 'order' || $controller_name == 'orderopc')
		{
			$this->eligible = 1;
			$step = Tools::getValue('step');
			if (empty($step))
				$step = 0;
			$ga_scripts .= $this->addProductFromCheckout($products, $step);
			$ga_scripts .= 'MBG.addCheckout(\''.(int)$step.'\');';
		}

		if (version_compare(_PS_VERSION_, '1.5', '<'))
		{
			if ($controller_name == 'orderconfirmation')
				$this->eligible = 1;
		}
		else
		{
			$confirmation_hook_id = (int)Hook::getIdByName('orderConfirmation');
			if (isset(Hook::$executed_hooks[$confirmation_hook_id]))
				$this->eligible = 1;
		}

		if (isset($products) && count($products) && $controller_name != 'index')
		{
			if ($this->eligible == 0)
				$ga_scripts .= $this->addProductImpression($products);
			$ga_scripts .= $this->addProductClick($products);
		}

		return $this->_runJs($ga_scripts);
	}

	protected function filter($ga_scripts)
	{
		if ($this->filterable = 1)
			return implode(';', array_unique(explode(';', $ga_scripts)));

		return $ga_scripts;
	}

	/**
	 * hook home to display generate the product list associated to home featured, news products and best sellers Modules
	 */
	public function hookHome()
	{
		$ga_scripts = '';

		// Home featured products
		if ($this->isModuleEnabled('homefeatured'))
		{
			$category = new Category($this->context->shop->getCategory(), $this->context->language->id);
			$home_featured_products = $this->wrapProducts($category->getProducts((int)Context::getContext()->language->id, 1,
			(Configuration::get('HOME_FEATURED_NBR') ? (int)Configuration::get('HOME_FEATURED_NBR') : 8), 'position'), array(), true);
			$ga_scripts .= $this->addProductImpression($home_featured_products).$this->addProductClick($home_featured_products);
		}

		// New products
		if ($this->isModuleEnabled('blocknewproducts') && (Configuration::get('PS_NB_DAYS_NEW_PRODUCT')
				|| Configuration::get('PS_BLOCK_NEWPRODUCTS_DISPLAY')))
		{
			$new_products = Product::getNewProducts((int)$this->context->language->id, 0, (int)Configuration::get('NEW_PRODUCTS_NBR'));
			$new_products_list = $this->wrapProducts($new_products, array(), true);
			$ga_scripts .= $this->addProductImpression($new_products_list).$this->addProductClick($new_products_list);
		}

		// Best Sellers
		if ($this->isModuleEnabled('blockbestsellers') && (!Configuration::get('PS_CATALOG_MODE')
				|| Configuration::get('PS_BLOCK_BESTSELLERS_DISPLAY')))
		{
			$ga_homebestsell_product_list = $this->wrapProducts(ProductSale::getBestSalesLight((int)$this->context->language->id, 0, 8), array(), true);
			$ga_scripts .= $this->addProductImpression($ga_homebestsell_product_list).$this->addProductClick($ga_homebestsell_product_list);
		}

		$this->js_state = 1;
		return $this->_runJs($this->filter($ga_scripts));
	}

	/**
	 * hook home to display generate the product list associated to home featured, news products and best sellers Modules
	 */
	public function isModuleEnabled($name)
	{
		if (version_compare(_PS_VERSION_, '1.5', '>='))
			if(Module::isEnabled($name))
			{
				$module = Module::getInstanceByName($name);
				return $module->isRegisteredInHook('home');
			}
			else
				return false;
		else
		{
			$module = Module::getInstanceByName($name);
			return ($module && $module->active === true);
		}
	}

	/**
	 * wrap products to provide a standard products information for google analytics script
	 */
	public function wrapProducts($products, $extras = array(), $full = false)
	{
		$result_products = array();
		if (!is_array($products))
			return;

		$currency = new Currency($this->context->currency->id);
		$usetax = (Product::getTaxCalculationMethod((int)$this->context->customer->id) != PS_TAX_EXC);

		if (count($products) > 20)
			$full = false;
		else
			$full = true;

		foreach ($products as $index => $product)
		{
			if ($product instanceof Product)
				$product = (array)$product;

			if (!isset($product['price']))
				$product['price'] = (float)Tools::displayPrice(Product::getPriceStatic((int)$product['id_product'], $usetax), $currency);
			$result_products[] = $this->wrapProduct($product, $extras, $index, $full);
		}

		return $result_products;
	}

	/**
	 * wrap product to provide a standard product information for google analytics script
	 */
	public function wrapProduct($product, $extras, $index = 0, $full = false)
	{
		$ga_product = '';

		$variant = null;
		if (isset($product['attributes_small']))
			$variant = $product['attributes_small'];
		elseif (isset($extras['attributes_small']))
			$variant = $extras['attributes_small'];

		$product_qty = 1;
		if (isset($extras['qty']))
			$product_qty = $extras['qty'];
		elseif (isset($product['cart_quantity']))
			$product_qty = $product['cart_quantity'];

		$product_id = 0;
		if (!empty($product['id_product']))
			$product_id = $product['id_product'];
		else if (!empty($product['id']))
			$product_id = $product['id'];

		if (!empty($product['id_product_attribute']))
			$product_id .= '-'. $product['id_product_attribute'];

		$product_type = 'typical';
		if (isset($product['pack']) && $product['pack'] == 1)
			$product_type = 'pack';
		elseif (isset($product['virtual']) && $product['virtual'] == 1)
			$product_type = 'virtual';

		if ($full)
		{
			$ga_product = array(
				'id' => $product_id,
				'name' => Tools::jsonEncode($product['name']),
				'category' => Tools::jsonEncode($product['category']),
				'brand' => isset($product['manufacturer_name']) ? Tools::jsonEncode($product['manufacturer_name']) : '',
				'variant' => Tools::jsonEncode($variant),
				'type' => $product_type,
				'position' => $index ? $index : '0',
				'quantity' => $product_qty,
				'list' => Tools::getValue('controller'),
				'url' => isset($product['link']) ? urlencode($product['link']) : '',
				'price' => number_format($product['price'], '2')
			);
		}
		else
		{
			$ga_product = array(
				'id' => $product_id,
				'name' => Tools::jsonEncode($product['name'])
			);
		}
		return $ga_product;
	}

	/**
	 * add order transaction
	 */
	public function addTransaction($products, $order)
	{
		if (!is_array($products))
			return;

		$js = '';
		foreach ($products as $product)
			$js .= 'MBG.add('.Tools::jsonEncode($product).');';

		return $js.'MBG.addTransaction('.Tools::jsonEncode($order).');';
	}

	/**
	 * add product impression js and product click js
	 */
	public function addProductImpression($products)
	{
		if (!is_array($products))
			return;

		$js = '';
		foreach ($products as $product)
			$js .= 'MBG.add('.Tools::jsonEncode($product).",'',true);";

		return $js;
	}

	public function addProductClick($products)
	{
		if (!is_array($products))
			return;

		$js = '';
		foreach ($products as $product)
			$js .= 'MBG.addProductClick('.Tools::jsonEncode($product).');';

		return $js;
	}

	public function addProductClickByHttpReferal($products)
	{
		if (!is_array($products))
			return;

		$js = '';
		foreach ($products as $product)
			$js .= 'MBG.addProductClickByHttpReferal('.Tools::jsonEncode($product).');';

		return $js;
	}

	/**
	 * Add product checkout info
	 */
	public function addProductFromCheckout($products)
	{
		if (!is_array($products))
			return;

		$js = '';
		foreach ($products as $product)
			$js .= 'MBG.add('.Tools::jsonEncode($product).');';

		return $js;
	}

	/**
	 * hook product page footer to load JS for product details view
	 */
	public function hookProductFooter($params)
	{
		$controller_name = Tools::getValue('controller');
		if ($controller_name == 'product')
		{
			// Add product view
			$ga_product = $this->wrapProduct((array)$params['product'], null, 0, true);
			$js = 'MBG.addProductDetailView('.Tools::jsonEncode($ga_product).');';

			if (isset($_SERVER['HTTP_REFERER']) && strpos($_SERVER['HTTP_REFERER'], $_SERVER['HTTP_HOST']) > 0)
				$js .= $this->addProductClickByHttpReferal(array($ga_product));

			$this->js_state = 1;
			return $this->_runJs($js);
		}
	}

	/**
	 * Generate Google Analytics js
	 */
	protected function _runJs($js_code, $backoffice = 0)
	{
		if (Configuration::get('GA_ACCOUNT_ID'))
		{
			$runjs_code = '';
			if (!empty($js_code))
				$runjs_code .= '
				<script type="text/javascript">
					jQuery(document).ready(function(){
						var MBG = GoogleAnalyticEnhancedECommerce;
						MBG.setCurrency(\''.Tools::safeOutput($this->context->currency->iso_code).'\');
						'.$js_code.'
					});
				</script>';

			if (($this->js_state) != 1 && ($backoffice == 0))
				$runjs_code .= '
				<script type="text/javascript">
					ga(\'send\', \'pageview\');
				</script>';

			return $runjs_code;
		}
	}

	/**
	 * Hook admin order to send transactions and refunds details
	 */
	public function hookAdminOrder()
	{
		echo $this->_runJs($this->context->cookie->ga_admin_refund, 1);
		unset($this->context->cookie->ga_admin_refund);
	}

	/**
	 *  admin office header to add google analytics js
	 */
	public function hookBackOfficeHeader()
	{
		$js = '';
		if (strcmp(Tools::getValue('configure'), $this->name) === 0)
		{
			if (version_compare(_PS_VERSION_, '1.5', '>') == true)
			{
				$this->context->controller->addCSS($this->_path.'views/css/ganalytics.css');
				if (version_compare(_PS_VERSION_, '1.6', '<') == true)
					$this->context->controller->addCSS($this->_path.'views/css/ganalytics-nobootstrap.css');
			}
			else
			{
				$js .= '<link rel="stylesheet" href="'.$this->_path.'views/css/ganalytics.css" type="text/css" />\
						<link rel="stylesheet" href="'.$this->_path.'views/css/ganalytics-nobootstrap.css" type="text/css" />';
			}
		}

		$ga_account_id = Configuration::get('GA_ACCOUNT_ID');

		if (!empty($ga_account_id) && $this->active)
		{
			if (version_compare(_PS_VERSION_, '1.5', '>=') == true)
				$this->context->controller->addJs($this->_path.'views/js/GoogleAnalyticActionLib.js');
			else
				$js .= '<script type="text/javascript" src="'.$this->_path.'views/js/GoogleAnalyticActionLib.js"></script>';

			$this->context->smarty->assign('GA_ACCOUNT_ID', $ga_account_id);

			$ga_scripts = '';
			if ($this->context->controller->controller_name == 'AdminOrders')
			{
				if (Tools::getValue('id_order'))
				{
					$order = new Order((int)Tools::getValue('id_order'));
					if (Validate::isLoadedObject($order) && strtotime('+1 day', strtotime($order->date_add)) > time()) {
					    $ga_order_sent = Db::getInstance()->getValue('SELECT id_order FROM `'._DB_PREFIX_.'ganalytics` WHERE id_order = '.(int)Tools::getValue('id_order'));
					    if ($ga_order_sent === false)
						Db::getInstance()->Execute('INSERT IGNORE INTO `'._DB_PREFIX_.'ganalytics` (id_order, id_shop, sent, date_add) VALUES ('.(int)Tools::getValue('id_order').', '.(int)$this->context->shop->id.', 0, NOW())');
					}
				}
				else
				{
					$ga_order_records = Db::getInstance()->ExecuteS('SELECT * FROM `'._DB_PREFIX_.'ganalytics` WHERE sent = 0 AND id_shop = \''.(int)$this->context->shop->id.'\' AND DATE_ADD(date_add, INTERVAL 30 minute) < NOW()');

					if ($ga_order_records)
						foreach ($ga_order_records as $row)
						{
							$transaction = $this->wrapOrder($row['id_order']);
							if (!empty($transaction))
							{
								Db::getInstance()->execute('UPDATE `'._DB_PREFIX_.'ganalytics` SET date_add = NOW(), sent = 1 WHERE id_order = '.(int)$row['id_order'].' AND id_shop = \''.(int)$this->context->shop->id.'\'');
								$transaction = Tools::jsonEncode($transaction);
								$ga_scripts .= 'MBG.addTransaction('.$transaction.');';
							}
						}

				}
			}
			return $js.$this->_getGoogleAnalyticsTag(true).$this->_runJs($ga_scripts, 1);
		}
		else return $js;
	}

	/**
	 * Hook admin office header to add google analytics js
	 */
	public function hookActionProductCancel($params)
	{
		$qty_refunded = Tools::getValue('cancelQuantity');
		$ga_scripts = '';
		foreach ($qty_refunded as $orderdetail_id => $qty)
		{
			// Display GA refund product
			$order_detail = new OrderDetail($orderdetail_id);
			$ga_scripts .= 'MBG.add('.Tools::jsonEncode(
					array(
						'id' => empty($order_detail->product_attribute_id)?$order_detail->product_id:$order_detail->product_id.'-'.$order_detail->product_attribute_id,
						'quantity' => $qty)
					).');';
		}
		$this->context->cookie->ga_admin_refund = $ga_scripts.'MBG.refundByProduct('.Tools::jsonEncode(array('id' => $params['order']->id)).');';
	}

	/**
	 * hook save cart event to implement addtocart and remove from cart functionality
	 */
	public function hookActionCartSave()
	{
		if (!isset($this->context->cart))
			return;

		if (!Tools::getIsset('id_product'))
			return;

		$cart = array(
			'controller' => Tools::getValue('controller'),
			'addAction' => Tools::getValue('add') ? 'add' : '',
			'removeAction' => Tools::getValue('delete') ? 'delete' : '',
			'extraAction' => Tools::getValue('op'),
			'qty' => (int)Tools::getValue('qty', 1)
		);

		$cart_products = $this->context->cart->getProducts();
		if (isset($cart_products) && count($cart_products))
			foreach ($cart_products as $cart_product)
				if ($cart_product['id_product'] == Tools::getValue('id_product'))
					$add_product = $cart_product;

		if ($cart['removeAction'] == 'delete')
		{
			$add_product_object = new Product((int)Tools::getValue('id_product'), true, (int)Configuration::get('PS_LANG_DEFAULT'));
			if (Validate::isLoadedObject($add_product_object))
			{
				$add_product['name'] = $add_product_object->name;
				$add_product['manufacturer_name'] = $add_product_object->manufacturer_name;
				$add_product['category'] = $add_product_object->category;
				$add_product['reference'] = $add_product_object->reference;
				$add_product['link_rewrite'] = $add_product_object->link_rewrite;
				$add_product['link'] = $add_product_object->link_rewrite;
				$add_product['price'] = $add_product_object->price;
				$add_product['ean13'] = $add_product_object->ean13;
				$add_product['id_product'] = Tools::getValue('id_product');
				$add_product['id_category_default'] = $add_product_object->id_category_default;
				$add_product['out_of_stock'] = $add_product_object->out_of_stock;
				$add_product = Product::getProductProperties((int)Configuration::get('PS_LANG_DEFAULT'), $add_product);
			}
		}

		if (isset($add_product) && !in_array((int)Tools::getValue('id_product'), self::$products))
		{
			self::$products[] = (int)Tools::getValue('id_product');
			$ga_products = $this->wrapProduct($add_product, $cart, 0, true);

			if (array_key_exists('id_product_attribute', $ga_products) && $ga_products['id_product_attribute'] != '' && $ga_products['id_product_attribute'] != 0)
				$id_product = $ga_products['id_product_attribute'];
			else
				$id_product = Tools::getValue('id_product');

			if (isset($this->context->cookie->ga_cart))
				$gacart = unserialize($this->context->cookie->ga_cart);
			else
				$gacart = array();

			if ($cart['removeAction'] == 'delete')
				$ga_products['quantity'] = -1;
			elseif ($cart['extraAction'] == 'down')
			{
				if (array_key_exists($id_product, $gacart))
					$ga_products['quantity'] = $gacart[$id_product]['quantity'] - $cart['qty'];
				else
					$ga_products['quantity'] = $cart['qty'] * -1;
			}
			elseif (Tools::getValue('step') <= 0) // Sometimes cartsave is called in checkout
			{
				if (array_key_exists($id_product, $gacart))
					$ga_products['quantity'] = $gacart[$id_product]['quantity'] + $cart['qty'];
			}

			$gacart[$id_product] = $ga_products;
			$this->context->cookie->ga_cart = serialize($gacart);
		}
	}

	protected function checkForUpdates()
	{
		// Used by PrestaShop 1.3 & 1.4
		if (version_compare(_PS_VERSION_, '1.5', '<') && self::isInstalled($this->name))
			foreach (array('2.0.0', '2.0.4', '2.0.5', '2.0.6', '2.1.0') as $version)
			{
				$file = dirname(__FILE__).'/upgrade/Upgrade-'.$version.'.php';
				if (version_compare(Configuration::get('GANALYTICS'), $version, '<') && file_exists($file))
				{
					include_once($file);
					call_user_func('upgrade_module_'.str_replace('.', '_', $version), $this);
				}
			}
	}

	protected function _debugLog($function, $log)
	{
		if (!$this->_debug)
			return true;

		$myFile = _PS_MODULE_DIR_.$this->name.'/logs/analytics.log';
		$fh = fopen($myFile, 'a');
		fwrite($fh, date('F j, Y, g:i a').' '.$function."\n");
		fwrite($fh, print_r($log, true)."\n\n");
		fclose($fh);
	}
}