<?
/**
 * /lib/tracking.php
 *
 *  This file is ONLY included in the /lib/inc.php & /vx/lib/inc.php
 *
 * When including this file, be sure it is after the /vx/lib/ua.php
 *
 * The tracking will gather all information it can about a user's session
 * and store it in lc2systems.site_tracking
 *
 * This file will need to integrate the current tracking object
 *
 * @copyright 2016-2021 Synergy Pro Marketing
 * @author Aaron Campbell <aaron@synergymentoring.com>
 * @license None, All Rights Reserved
 * @package Tracking
 * @filesource
 * @since 11/20/2017
 * --- Aaron Campbell, created
 *
 */
if($siteCode != 'vxb')
{
	//$excludedIPAddreses = array('104.192.201.151', '174.19.101.245');
}

// start with checking for a session cookie
$trackingCookie = array();
$trackingCookie['name'] = $siteCode."_trx";
$function = "";
if(isset($_POST['f']))
{
	$function = $_POST['f'];
}
if(!empty($function))
{
	include($_SERVER['DOCUMENT_ROOT']."/vx/lib/inc.php");
}

$myIpaddress = $_SERVER['REMOTE_ADDR'];

if(isset($_POST['tc']))
{
	$trackingCode = $_POST['tc'];
}
if(empty($trackingCode) && isset($_REQUEST['tc']))
{
	$trackingCode = $_REQUEST['tc'];
}
if(empty($trackingCode) && isset($_GET['tc']))
{
	$trackingCode = $_GET['tc'];
}

/**
 * =================================================================================================
 * @var string $source Where is the current user logining in from
 *
 * This value must be saved in lc2systems.site_tracking to determine where users are logging in.
 * */
if(isset($_POST['source']))
{
	$source = $_POST['source'];
}
if(empty($source) && isset($_REQUEST['source']))
{
	$source = $_REQUEST['source'];
}
if(empty($source) && isset($_GET['source']))
{
	$source = $_GET['source'];
}
if(!empty($source))
{
	$_SESSION['source'] = $source;
}
if(empty($source) && isset($_SESSION['source']))
{
	$source = $_SESSION['source'];
}
if(empty($source)) {
	$source = '';
}
/**
 * =================================================================================================
 * */


$setCookie = false;
if(false && !isset($_COOKIE[$trackingCookie['name']]))
{
	$userExperience = $db->query("
									SELECT
											*
									FROM lc2{$siteCode}_lc.user_experience
									WHERE
											ip_address = '".clean($myIpaddress)."'
									");
	if(count($userExperience) > 0)
	{
		if(!empty($userExperience[0]['tracking_session']))
		{
			$trackingCookie['session'] = $userExperience[0]['tracking_session'];
		}
		else
		{
			$trackingCookie['session'] = siid();
		}
		$db->query("UPDATE lc2{$siteCode}_lc.user_experience SET tracking_session = '".$trackingCookie['session']."' WHERE experience = '".$userExperience[0]['experience']."' ");
	}
	else
	{
		$trackingCookie['session'] = siid();
	}

	$_SESSION['tracking_session'] = $trackingCookie['session'];
	setcookie($trackingCookie['name'], $trackingCookie['session'], (time() + 86400), "/");
	$setCookie = true;
}
else
{
	if(isset($trackingCookie['name']))
	{
		if(isset($_COOKIE[$trackingCookie['name']]))
		{
			$trackingCookie['session'] = $_COOKIE[$trackingCookie['name']];
		}
		$_SESSION['tracking_session'] = $trackingCookie['session'];
	}
}

if($setCookie)
{
	$siteVisits = $db->query("SELECT * FROM lc2systems.site_visits WHERE site_code = '$siteCode'");
	if(count($siteVisits) == 0)
	{
		$db->query("
									INSERT INTO lc2systems.site_visits
									SET
										site_code = '$siteCode',
										visits = 1
							");
	}
	else
	{
		$db->query("
									UPDATE lc2systems.site_visits
									SET
										visits = (visits + 1)
									WHERE
										site_code = '$siteCode'
							");
	}
}
$trackingSession = "";
if(isset($trackingCookie['session']))
{
	$trackingSession = $trackingCookie['session'];
	if(empty($trackingSession))
	{
		$trackingSession = $_SESSION['tracking_session'];
	}
}

if(!empty($trackingSession))
{
	// to be sure that we are grabbing this session's pages for today only
	$trackingData = $db->query("
								SELECT
										*
								FROM lc2systems.site_tracking
								WHERE
										tracking_session = '".clean($trackingSession)."'
									AND
										page_visited = '".clean($_SERVER['SCRIPT_FILENAME'])."'
									AND
										time_start > '".clean(date("Y-m-d 00:00:01"))."'
								");
	if(count($trackingData) == 0 )
	{
		if(empty($pageVersion)) {
			$pageVersion = '';
		}
		if(empty($subPageVersion)) {
			$subPageVersion = '';
		}
		if(empty($trackingCode)) {
			$trackingCode = '';
		}
		if(empty($seoPage)) {
			$seoPage = '';
		}
		// they user does not have a session in the database, insert a new record
		$db->query("
					INSERT INTO lc2systems.site_tracking
					SET
						site_code = '".clean($siteCode)."',
						tracking_session = '".clean($trackingSession)."',
						source = '".clean($source)."',
						ipaddress = '".clean($myIpaddress)."',
						cookie_id = '".clean($trackingCookie['name'])."',
						operating_system = '".clean($operatingSystem)."',
						page_visited = '".clean($_SERVER['SCRIPT_FILENAME'])."',
						version = '".clean($pageVersion)."',
						sub_version = '".clean($subPageVersion)."',
						referrer = '".clean($trackingCode)."',
						browser = '".clean($browser)."',
						browser_version = '".clean($ua['version'])."',
						user_agent = '".clean($ua['userAgent'])."',
						device_type = '".clean($device)."',
						seo = '".clean($seoPage)."',
						time_start = NOW(),
						created = NOW(),
						last_updated = NOW()
					");
		$trackingData = $db->query("SELECT * FROM lc2systems.site_tracking WHERE tracking_session = '".clean($trackingSession)."'");
		$validUserExperience = $db->query("
											SELECT
													*
											FROM
											lc2{$siteCode}_lc.user_experience
												WHERE
													ip_address = '".clean($myIpaddress)."'
											");
		if(count($validUserExperience) == 0)
		{
			if(isset($_SESSION['tracking_session']))
			{
				$db->query("
							INSERT INTO lc2{$siteCode}_lc.user_experience
							SET
								site_code = '".clean($siteCode)."',
								version = '".clean($pageVersion)."',
								sub_version = '".clean($subPageVersion)."',
								tracking_session = '".clean($_SESSION['tracking_session'])."',
								ip_address = '".clean($_SERVER['REMOTE_ADDR'])."',
								created = NOW()
						");
			}
		}
		else
		{
			if(isset($_SESSION['tracking_session']))
			{
				$db->query("
							UPDATE lc2{$siteCode}_lc.user_experience
							SET
								tracking_session = '".clean($_SESSION['tracking_session'])."'
							WHERE
								experience = '".$validUserExperience[0]['experience']."'
						");
			}
		}
	}
}
if(isset($trackingData))
{
	if(count($trackingData[0]) > 0)
	{
		$trackingData = $trackingData[0];
	}
}

//echoPre($trackingData);

/*
if($function == 'geolocation' && !empty($trackingSession) && count($trackingData) > 0 && !empty($siteCode))
{
	include_once($_SERVER['DOCUMENT_ROOT']."/vx/lib/xinc.php");
	$coords = $_POST['coords'];
	$db->query("
					UPDATE lc2systems.site_tracking
					SET
						accuracy = '".clean($coords['accuracy'])."',
						altitude = '".clean($coords['altitude'])."',
						altitude_accuracy = '".clean($coords['altitudeAccuracy'])."',
						heading = '".clean($coords['heading'])."',
						latitude = '".clean($coords['latitude'])."',
						longitude = '".clean($coords['longitude'])."',
						speed = '".clean($coords['speed'])."',
						last_updated = NOW()
					WHERE
							site_code = '".clean($siteCode)."'
						AND
							tracking_session = '".clean($trackingSession)."'
					");
}
*/
?>