/**
* Generate the dashboard with the google analytics graphs
*
* @return void
*/
public function indexAction()
{
$params = Zend_Registry::get('params');
$this->view->currentPage = 'dashboard';
try {
$email = $params->googleAnalytics->username;
$password = $params->googleAnalytics->password;
$profileID = $params->googleAnalytics->homeletProfileID;
$client = Zend_Gdata_ClientLogin::getHttpClient($email, $password, Zend_Gdata_Analytics::AUTH_SERVICE_NAME);
$service = new Zend_Gdata_Analytics($client);
$firstOfMonth = date("Y-m-d", strtotime(date('m') . '/01/' . date('Y') . ' 00:00:00'));
$today = date("Y-m-d");
$this->view->startDate = date("d/m/Y", strtotime($firstOfMonth));
$this->view->today = date("d/m/Y", strtotime($today));
// LINE CHART for visitors this month
$query = $service->newDataQuery()->setProfileId($profileID)->addDimension(Zend_Gdata_Analytics_DataQuery::DIMENSION_DAY)->addMetric(Zend_Gdata_Analytics_DataQuery::METRIC_VISITS)->setStartDate($firstOfMonth)->setEndDate($today)->setSort(Zend_Gdata_Analytics_DataQuery::DIMENSION_DAY, false)->setMaxResults(25);
$result = $service->getDataFeed($query);
$chartArray = array();
foreach ($result as $row) {
$chartArray[] = (int) $row->getValue('ga:visits')->getValue();
}
$visitorsChart = new gLineChart(800, 200);
$visitorsChart->addDataSet($chartArray);
$visitorsChart->setLegend(array('Site Visitors'));
$visitorsChart->setColors(array('FF6D1B'));
$visitorsChart->setVisibleAxes(array('x', 'y'));
$visitorsChart->setDataRange(0, 7000);
$visitorsChart->setLegendPosition('t');
$visitorsChart->addAxisRange(0, 0, count($chartArray), 2);
$visitorsChart->addAxisRange(1, 0, 7000);
$visitorsChart->setGridLines(7, 1000);
$this->view->visitorGraphUrl = $visitorsChart->getUrl();
// PIE CHART for sources
$query = $service->newDataQuery()->setProfileId($profileID)->addDimension(Zend_Gdata_Analytics_DataQuery::DIMENSION_MEDIUM)->addMetric(Zend_Gdata_Analytics_DataQuery::METRIC_VISITS)->setStartDate($firstOfMonth)->setEndDate($today)->setSort(Zend_Gdata_Analytics_DataQuery::DIMENSION_MEDIUM, false)->setMaxResults(500);
$result = $service->getDataFeed($query);
$chartArray = array();
$colorArray = array();
$labelArray = array();
foreach ($result as $row) {
$chartArray[] = (int) $row->getValue('ga:visits')->getValue();
switch ((string) $row->getValue('ga:medium')->getValue()) {
case '(none)':
$medium = 'Direct';
$color = 'FF6F1C';
break;
case 'email':
$medium = 'Email Campaign';
$color = 'FDBB30';
break;
case 'organic':
$medium = 'Search Engines';
$color = '7AC142';
break;
case 'referral':
$medium = 'Referring Site';
$color = 'E60E64';
break;
default:
$medium = (string) $row->getValue('ga:medium')->getValue();
}
$labelArray[] = $medium;
$colorArray[] = $color;
}
$sourcesChart = new gPieChart(380, 200);
$sourcesChart->addDataSet($chartArray);
$sourcesChart->setLegend($labelArray);
$sourcesChart->setColors($colorArray);
$this->view->sourcesGraphUrl = $sourcesChart->getUrl();
// Table of top 20 keywords
$query = $service->newDataQuery()->setProfileId($profileID)->addDimension(Zend_Gdata_Analytics_DataQuery::DIMENSION_KEYWORD)->addMetric(Zend_Gdata_Analytics_DataQuery::METRIC_VISITS)->setStartDate($firstOfMonth)->setEndDate($today)->setSort(Zend_Gdata_Analytics_DataQuery::METRIC_VISITS, true)->setMaxResults(20);
$result = $service->getDataFeed($query);
$keywordArray = array();
foreach ($result as $row) {
$keyword = (string) $row->getValue('ga:keyword')->getValue();
if ($keyword == '(not set)') {
$keyword = '-';
}
$keywordArray[$keyword] = (int) $row->getValue('ga:visits')->getValue();
}
$this->view->keywordList = $keywordArray;
// PIE CHART for new/returning visitors
$query = $service->newDataQuery()->setProfileId($profileID)->addDimension(Zend_Gdata_Analytics_DataQuery::DIMENSION_VISITOR_TYPE)->addMetric(Zend_Gdata_Analytics_DataQuery::METRIC_VISITS)->setStartDate($firstOfMonth)->setEndDate($today)->setSort(Zend_Gdata_Analytics_DataQuery::METRIC_VISITS, true)->setMaxResults(2);
$result = $service->getDataFeed($query);
$chartArray = array();
$colorArray = array();
$labelArray = array();
foreach ($result as $row) {
$chartArray[] = (int) $row->getValue('ga:visits')->getValue();
$labelArray[] = (string) $row->getValue('ga:visitorType')->getValue();
switch ((string) $row->getValue('ga:visitorType')->getValue()) {
case 'Returning Visitor':
$color = 'FF6F1C';
break;
case 'New Visitor':
$color = '7AC142';
break;
default:
}
$colorArray[] = $color;
}
$newReturningChart = new gPieChart(380, 200);
$newReturningChart->addDataSet($chartArray);
$newReturningChart->setLegend($labelArray);
$newReturningChart->setColors($colorArray);
$this->view->newReturningUrl = $newReturningChart->getUrl();
} catch (Exception $e) {
$this->view->statsUnavailable = true;
}
}
<?php
require_once "gChart.php";
$lineChart = new gLineChart($_GET['width'], $_GET['height']);
$lineChart->addDataSet(array(120, 131, 135, 160, 129, 22, 190));
$lineChart->setLegend(array('Nice figures'));
$lineChart->setColors(array('ED237A'));
$lineChart->setVisibleAxes(array('x', 'y'));
$lineChart->setDataRange(0, 200);
$lineChart->setLegendPosition('t');
// axisnr, from, to, step
$lineChart->addAxisRange(0, 0, 28, 7);
$lineChart->addAxisRange(1, 0, 200);
$lineChart->setGridLines(25, 10);
$lineChart->renderImage($_GET['post']);
