<?php

//so session vars can be used
session_start(); 

//clientLogin: try to log in user
if(isset($_POST['email']) && isset($_POST['password'])){
	$_SESSION['sessionToken'] = googleLogin($_POST['email'],$_POST['password']);
}
//AuthSub: exchange token for session token so multiple calls can be made to api
if(isset($_REQUEST['token'])){
	$_SESSION['authSub'] = true;
	$_SESSION['sessionToken'] = get_session_token($_REQUEST['token']);
}

if(isset($_REQUEST['logout'])){
	//clear session vars to start fresh
	session_unset(); 
}
//set form vars
if(isset($_POST['tableId'])){	
	$start_date = $_POST['startdate'];
	$end_date = $_POST['enddate'];
	
	$table_Id = substr($_POST['tableId'],0,strpos($_POST['tableId'],"|"));
	$graph_type = $_POST['graphtype'];
}
else
{
//default start and end dates
	$start_date  = date("Y-m-d",mktime(0, 0, 0, date("m")  , date("d")-31, date("Y")));
	$end_date  = date("Y-m-d",mktime(0, 0, 0, date("m")  , date("d")-1, date("Y")));
}	

//format date inputs for output on page
$start_date_parts = explode("-",$start_date);
$end_date_parts = explode("-",$end_date);
		
$full_start_date = date("d-F-y",mktime(0, 0, 0, $start_date_parts[1]  , $start_date_parts[2], $start_date_parts[0]));
$ga_start_date = date("Y-m-d",mktime(0, 0, 0, $start_date_parts[1]  , $start_date_parts[2], $start_date_parts[0]));
	
$full_end_date = date("d-F-y",mktime(0, 0, 0, $end_date_parts[1]  , $end_date_parts[2], $end_date_parts[0]));
$ga_end_date = date("Y-m-d",mktime(0, 0, 0, $end_date_parts[1]  , $end_date_parts[2], $end_date_parts[0]));

//checks for valid date
function checkdaterange($start_date,$end_date){
	$errormsg = "valid";

	if ($start_date > $end_date)
		$errormsg = "invalid";
		
	return $errormsg;
}

//returns sessionToken for multiple calls to API
function googleLogin($email,$passwd){
	
	$clientlogin_url = "https://www.google.com/accounts/ClientLogin";
	$clientlogin_post = array(
    "accountType" => "GOOGLE",
    "Email" => $email,
    "Passwd" => $passwd,
    "service" => "analytics",
    "source" => "my-analytics"
	);
 
	$curl = curl_init($clientlogin_url);

	curl_setopt($curl, CURLOPT_POST, true);
	curl_setopt($curl, CURLOPT_POSTFIELDS, $clientlogin_post);
	curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
	curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
	curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

	$response = curl_exec($curl);
 
	preg_match("/Auth=([a-z0-9_\-]+)/i", $response, $matches);
	$sessionToken = $matches[1];

	if (strlen($sessionToken) == 0){
		$sessionToken = "Authentication Failed.";
	}
	 
 	return $sessionToken;
}

//returns session token for multiple calls to API
	function get_session_token($onetimetoken) {
		$output = call_api($onetimetoken, "https://www.google.com/accounts/AuthSubSessionToken");
				
		if (preg_match("/Token=(.*)/", $output, $matches))
		{
			$sessionToken = $matches[1];
		} else {
			echo "Error authenticating with Google.";
			exit;
		}
		
		return $sessionToken;
	}

//gets the data
function call_api($sessionToken,$url){
	$curl = curl_init($url);
 
	curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);	
	if (isset($_SESSION['authSub'])){
		$curlheader[0] = sprintf("Authorization: AuthSub token=\"%s\"/n", $sessionToken);
	} else {
		$curlheader[0] = "Authorization: GoogleLogin auth=" . $sessionToken;
	}
	curl_setopt($curl, CURLOPT_HTTPHEADER, $curlheader);

	$response = curl_exec($curl);
	curl_close($curl);

	return $response;	    
}

//returns accounts list as array	
function parse_account_list($xml){
	$doc = new DOMDocument();
	if(stripos($xml,"<") !== FALSE)
	{
		$doc->loadXML($xml);
	
		$entries = $doc->getElementsByTagName('entry');
		$i = 0;
		$profiles= array();
		foreach($entries as $entry)
		{
			$profiles[$i] = array();

			$properties = $entry->getElementsByTagName('property');
			foreach($properties as $property)
			{
				if (strcmp($property->getAttribute('name'), 'ga:accountId') == 0)
					$profiles[$i]["accountId"] = $property->getAttribute('value');

				if (strcmp($property->getAttribute('name'), 'ga:profileName') == 0)
					$profiles[$i]["title"] = $property->getAttribute('value');

				if (strcmp($property->getAttribute('name'), 'dxp:tableId') == 0)
					$profiles[$i]["tableId"] = $property->getAttribute('value');
			}
				
			$i++;
		}
		
		return $profiles;
	} else {
		$sessionToken = "Authentication Failed.";
	}
}
//returns data as array	
function parse_data($xml){
		$doc = new DOMDocument();
		$doc->loadXML($xml);

		$entries = $doc->getElementsByTagName('entry');
		$i = 0;
		$results = array();
		foreach($entries as $entry)
		{
			
			$dimensions = $entry->getElementsByTagName('dimension');
			foreach($dimensions as $dimension)
			{
				$results[$i][ltrim($dimension->getAttribute("name"),"ga:")] =  $dimension->getAttribute('value');
			}
			
			$metrics = $entry->getElementsByTagName('metric');
			foreach($metrics as $metric)
			{
				$results[$i][ltrim($metric->getAttribute('name'),"ga:")] =  $metric->getAttribute('value');
			}
			
			$i++;
		}
		return $results;
}

?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>Google Analytics with Google Charts - PHP</title>

<script src="//www.google.com/jsapi"></script>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>

<link rel="stylesheet" type="text/css" href="//ajax.googleapis.com/ajax/libs/jqueryui/1/themes/redmond/jquery-ui.css" media="screen" />
<link rel="stylesheet" type="text/css" href="css/960.css" media="screen" />
<link rel="stylesheet" type="text/css" href="css/style.css" media="screen" />

<script language="javascript">
$(function() {
		$("#startdate, #enddate").datepicker({showOn: 'button', buttonImage: 'SmallCalendar.gif', buttonImageOnly: true, dateFormat: 'dd-MM-yy', altFormat: 'yy-mm-dd', maxDate: -1});
		
		$("#startdate").datepicker("option",{altField: '#start_alternate', minDate: new Date(2009, 8 - 1, 1)});
		$("#enddate").datepicker("option", {altField: '#end_alternate', minDate: new Date(2009, 8 - 1, 2)});		
});
</script>

</head>
<body>
<div id="wrapper">
	
	<div id="header" class="container_16">
		<h1><span>Google Analytics</span> Web Stats &amp; Google Charts <span>PHP</span></h1>
	</div>
    
<div id="content-wrap" class="container_16">   

<?php
if (!isset($_SESSION['sessionToken']) || (isset($_SESSION['sessionToken']) && $_SESSION['sessionToken'] == "Authentication Failed.")){
?>
	<div class="grid_8 prefix_4 suffix_4"> 
		<h2>Sign In</h2>
         <p><a class="button" href="https://www.google.com/accounts/AuthSubRequest?next=http://YOUR-SITE/YOUR-PATH/&scope=https://www.googleapis.com/auth/analytics.readonly&secure=0&session=1">Authenticate using AuthSub through Google.</a></p>
		
		<form name="loginForm" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
		    <label for="email">Gmail:</label>
		    <input id="email" type="text" name="email" />
		    <label for="password">Password:</label>
		    <input type="password" name="password" id="password" />
		    <br /><br />
		    <button type="submit" id="submitLogin">Submit</button>
		</form>
	</div>
<?php
	if (isset($_SESSION['sessionToken']) && $_SESSION['sessionToken'] == "Authentication Failed."){
		echo "<div class='container'><p class='errorMessage'>Authentication Failed. Please check your log in credentials and try again.</p></div>";
		session_unset();
		exit;
	}
}
else
{
	$accountxml = call_api($_SESSION['sessionToken'],"https://www.googleapis.com/analytics/v2.4/management/accounts/~all/webproperties/~all/profiles?key=AIzaSyDs9zxyj9yyPNb6o3N45poX-M4xcKtLSo4");
	// Get an array with the available accounts
	//echo $accountxml;

	$profiles = parse_account_list($accountxml);

		echo "<div class='grid_6 prefix_5 suffix_5'>";
		echo "<div id='logout'><a href='" . $_SERVER['PHP_SELF'] . "?logout=1'>Log out</a></div>";
		echo "<h2>Select Site and Date Range</h2>";

		echo "<form name='siteSelect' id='siteSelect' method='post' action='" . $_SERVER['PHP_SELF'] . "'><p><label for='tableId'>Select Site:</label><select name='tableId' id='tableId'>";
		foreach($profiles as $profile)
		{
			if($profile["tableId"] == $table_Id)
				$selected = "selected='selected'";
				echo "<option value='" . $profile["tableId"] . "|" . $profile["title"] . "'" . $selected  . ">" . $profile["title"] . "</option>";
				$selected = " ";
		}
		echo "</select></p>";
	
	?>

	    <p><label for='startdate'>Start Date:</label>
	    <input id='startdate' readonly='readonly' type='text' value='<?php echo $full_start_date; ?>' /><input type='hidden' name='startdate' id='start_alternate' value='<?php echo $ga_start_date; ?>' /></p>
	    <p><label for='enddate'>End Date:</label>
	    <input id='enddate' readonly='readonly' type='text' value='<?php echo $full_end_date; ?>' /><input type='hidden' name='enddate' id='end_alternate' value='<?php echo $ga_end_date; ?>' /></p>
	    <p><label for='graphtype'>Visitor Graph Type:</label>
	    <input id="radio_month" type="radio" name="graphtype" value="month" checked="checked" />Month
	    <input id="radio_day" type="radio" name="graphtype" value="date" <?php if($graph_type == 'date') echo "checked='checked'"; ?> />Day</p>
		<p><input type='submit' value='Submit' /></p></form>
        
		</div>
<?php	
	}
	
if(isset($_POST['tableId'])){
	echo "<div class='grid_16' style='margin-top: 1em;'>";
	
	$website = substr(strrchr($_POST['tableId'],"|"),1);
	$tableId = substr($_POST['tableId'],0,strpos($_POST['tableId'],"|"));
	
	if (checkdaterange($start_date,$end_date) == "invalid"){
		echo "<p class='errorMessage'>Date range of " . $full_start_date . " to " . $full_end_date . " is invalid. Please reselect the dates.</p>";
		exit;
	}
	else
	{

	$visits_graph_type = $_POST['graphtype'];

	echo "<h1 style='text-transform:uppercase'>".$website."<br /><span style='color: #999999'>";
	echo "" . $full_start_date . " to " . $full_end_date . "</span></h1>";
	
	// For each website, get visits and visitors
				$requrlvisits = sprintf("https://www.googleapis.com/analytics/v2.4/data?ids=%s&metrics=ga:visits,ga:visitors&start-date=%s&end-date=%s",$tableId,$start_date,$end_date);
				
				$visitsxml = call_api($_SESSION['sessionToken'],$requrlvisits);	
				//echo $visitsxml;

				$visits = parse_data($visitsxml);
								
				foreach($visits as $visit)
				{
				echo "<h2>Visits: ".number_format($visit["visits"])."</h2><h2>Visitors: ".number_format($visit["visitors"])."</h2>";
				}
		
	echo "<div id='barchart_div'></div>";
	echo "<div id='piechart_div'></div>";

				// For each website, get referrals
				$requrl = sprintf("https://www.googleapis.com/analytics/v2.4/data?ids=%s&dimensions=ga:source&metrics=ga:visits&filters=ga:medium==referral&start-date=%s&end-date=%s&sort=-ga:visits&max-results=10",$tableId,$start_date,$end_date);
				
				$referralsxml = call_api($_SESSION['sessionToken'],$requrl);				
				$referrers = parse_data($referralsxml);
				
				echo "<h1>Referrers</h1>";
							
				echo "<table width='75%' class='dataTable listTable'><tr class='headerRow'><th>Referrer</th><th>Visits</th></tr>";
				$table_row = 0;
				foreach($referrers as $referrer)
				{
				if ($table_row % 2){
					echo "<tr><td>";
				}else{
					echo "<tr class='oddrow'><td>";
				}
				echo $referrer["source"] . "</td><td class='visits'>"  . number_format($referrer["visits"]) . "</td.</tr>";
				$table_row++;
				
				}
				echo "</table>";	
				
				// For each website, get visits graph data
				if ($visits_graph_type == "date"){
					$requrlvisitsgraph = sprintf("https://www.googleapis.com/analytics/v2.4/data?ids=%s&dimensions=ga:date&metrics=ga:visits&start-date=%s&end-date=%s",$tableId,$start_date,$end_date);
					}
					else
					{
					$requrlvisitsgraph = sprintf("https://www.googleapis.com/analytics/v2.4/data?ids=%s&dimensions=ga:month,ga:year&metrics=ga:visits&sort=ga:year&start-date=%s&end-date=%s",$tableId,$start_date,$end_date);
					}
				
				$visitsgraphxml = call_api($_SESSION['sessionToken'],$requrlvisitsgraph);				
				$visitsgraph = parse_data($visitsgraphxml);				
			?>

<script>      
function drawPieChart() {
	var data = new google.visualization.DataTable();
    data.addColumn('string', 'Referrer');
    data.addColumn('number', 'Visits');
    data.addRows(<?php echo sizeof($referrers) ?>);
    <?php
    $row = 0;
    foreach($referrers as $referrer)
		{
	?>
	data.setValue(<?php echo $row ?>,0,'<?php echo $referrer["source"] ?>');
	data.setValue(<?php echo $row ?>,1,<?php echo $referrer["visits"] ?>);
	<?php	
	$row++;
	}
	?>

	var chart = new google.visualization.PieChart(document.getElementById('piechart_div'));
    chart.draw(data, {width: 600, height: 440, is3D: true, title: 'Referrer/Visits'});
}

function drawBarChart() {
	var data = new google.visualization.DataTable();
    data.addColumn('string', 'Day');
    data.addColumn('number', 'Visits');
    data.addRows(<?php echo sizeof($visitsgraph) ?>);
	<?php
    $row = 0;
    foreach($visitsgraph as $visits)
		{
	?>
		data.setValue(<?php echo $row ?>,0,'<?php if ($visits_graph_type === "month"){echo date("M", mktime(0, 0, 0, $visits["month"]))." ".$visits["year"];}else{echo substr($visits['date'],6,2)."-".date('M', mktime(0, 0, 0, substr($visits['date'],4,2)))."-".substr($visits['date'],0,4);} ?>');
		data.setValue(<?php echo $row ?>,1,<?php echo $visits["visits"] ?>);
		<?php 
		$row++; 
		}
		?>
    var chart = new google.visualization.ColumnChart(document.getElementById('barchart_div'));
    chart.draw(data, {'width': 700, 'height': 400, 'is3D': true, 'title': 'Visits'});
}

google.load("visualization", "1.0", {packages:["corechart"]});
google.setOnLoadCallback(drawPieChart);
google.setOnLoadCallback(drawBarChart);

</script>

<?php
	}
}	
?>
	</div>
</div>

</div>
</body>
</html>