bindVars($order_query, ':customersID', $_SESSION['customer_id'], 'integer');
$order = $db->Execute($order_query);
$google_analytics = array();
$totals = $db->Execute("select value, class from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order->fields['orders_id'] . "' and (class = 'ot_total' or class = 'ot_tax' or class = 'ot_shipping')");
while(!$totals->EOF) {
$google_analytics[$totals->fields['class']] = number_format($totals->fields['value'], 2, '.', '');
$totals->MoveNext();
}
switch(GOOGLE_ANALYTICS_TRACKING_TYPE) {
case 'ga.js':
?>
pageTracker._addTrans(
"fields['orders_id']; ?>",
"",
"",
"",
"",
"fields['city']; ?>",
"fields['state']; ?>",
"fields['country']; ?>"
);
_gaq.push(['_addTrans',
"fields['orders_id']; ?>",
"",
"",
"",
"",
"fields['city']; ?>",
"fields['state']; ?>",
"fields['country']; ?>"
]);
ga('require', 'ecommerce', 'ecommerce.js');
ga('ecommerce:addTransaction', {
"id": "fields['orders_id']; ?>",
"affiliation": "",
"revenue": "",
"tax": "",
"shipping": ""
});
Execute("select products_id, " . GOOGLE_ANALYTICS_SKU_CODE . " as skucode, products_name, final_price, products_quantity from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . $order->fields['orders_id'] . "'");
$items = "";
while(!$products->EOF) {
$category_query = "select cd.categories_name from " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on (cd.categories_id = p2c.categories_id) where p2c.products_id = '" . $products->fields['products_id'] . "' and cd.language_id = :languagesID limit 1";
$category_query = $db->bindVars($category_query, ':languagesID', $_SESSION['languages_id'], 'integer');
$category = $db->Execute($category_query);
switch(GOOGLE_ANALYTICS_TRACKING_TYPE) {
case 'ga.js':
?>
pageTracker._addItem(
"fields['orders_id']; ?>",
"fields['skucode']); ?>",
"fields['products_name']); ?>",
"fields['categories_name']); ?>",
"fields['final_price'], 2, '.', ''); ?>",
"fields['products_quantity']; ?>"
);
_gaq.push(['_addItem',
"fields['orders_id']; ?>",
"fields['skucode']); ?>",
"fields['products_name']); ?>",
"fields['categories_name']); ?>",
"fields['final_price'], 2, '.', ''); ?>",
"fields['products_quantity']; ?>"
]);
ga('ecommerce:addItem', {
"id": "fields['orders_id']; ?>",
"name": "fields['products_name']); ?>",
"sku": "fields['skucode']); ?>",
"category": "fields['categories_name']); ?>",
"price": "fields['final_price'], 2, '.', ''); ?>",
"quantity": "fields['products_quantity']; ?>"
});
MoveNext();
}
switch(GOOGLE_ANALYTICS_TRACKING_TYPE) {
case 'ga.js':
?>
pageTracker._trackTrans();
_gaq.push(['_trackTrans']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
ga('ecommerce:send');
; ?>&script=0)