function index()
{
if ($this->perm_user->reports->access) {
/* Start Overall Worktype */
$this->load->model('worktype_model');
$worktypes = $this->worktype_model->select_multiple($this->session->userdata('company_id'));
$values = array();
$legends = array();
$labels = array();
foreach ($worktypes as $worktype) {
if ($worktype['segment_count']) {
$labels[] = $worktype['name'];
$legends[] = $worktype['name'] . ' (' . $worktype['hour_float'] . ')';
$values[] = $worktype['hour_float'];
}
}
$overall_worktype_chart = new gPieChart(500, 200);
#$overall_worktype_chart->set3D(true);
$overall_worktype_chart->addDataSet($values);
$overall_worktype_chart->setLegend($legends);
$overall_worktype_chart->setLabels($labels);
$overall_worktype_chart->setColors($this->colors);
$data['worktypes'] = $overall_worktype_chart->getUrl();
/* Start User Group By Time */
$usertimes = $this->statistics_model->select_users_groupby_time($this->session->userdata('company_id'));
$values = array();
$legends = array();
$labels = array();
foreach ($usertimes as $usertime) {
if ($usertime['segment_count']) {
$labels[] = $usertime['user_name'];
$legends[] = $usertime['user_name'] . ' (' . $usertime['hour_float'] . ')';
$values[] = $usertime['hour_float'];
}
}
$overall_usertime_chart = new gPieChart(500, 200);
#$overall_worktype_chart->set3D(true);
$overall_usertime_chart->addDataSet($values);
$overall_usertime_chart->setLegend($legends);
$overall_usertime_chart->setLabels($labels);
$overall_usertime_chart->setColors($this->colors);
$data['usertimes'] = $overall_usertime_chart->getUrl();
$this->load->view('statistics/xhr_overview', $data);
} else {
$data['error'] = $this->lang->line('error_low_perm');
$this->load->view('xhr_error', $data);
}
}
function test_PieChart()
{
$piChart = new gPieChart();
$piChart->setTitle("A Title");
$piChart->addDataSet(array(112, 315, 66, 40));
$piChart->setLegend(array("first", "second", "third", "fourth"));
$piChart->setLabels(array("first", "second", "third", "fourth"));
$piChart->setColors(array("ff3344", "11ff11", "22aacc", "3333aa"));
$text = <<<END
newPieChart:
setTitle: A Title
addDataSet: 112,315,66,40
setLegend: first, second, third, fourth
setLabels: first, second, third, fourth
setColors: ff3344, 11ff11, 22aacc, 3333aa
END;
$parser = new gChartPhpDSLParser();
$parser->parse($text);
$this->assertEqual($piChart->getUrl(), $parser->getUrl());
}
if (!empty($row["ID"])) {
if ($row['CAPTURED'] == 0 && $row['CAPTURED_ACK'] == '') {
$hold++;
} else {
if ($row['CAPTURED'] == 1) {
$success++;
} else {
if ($row['CAPTURED'] == 0 && $row['CAPTURED_ACK'] == 'Failed') {
$failed++;
}
}
}
}
}
}
$piChart3 = new gPieChart();
$piChart3->addDataSet(array($success, $hold, $failed));
$piChart3->setLegend(array($admin_language['success'] . '(' . $success . ')', $admin_language['hold'] . '(' . $hold . ')', $admin_language['failed'] . '(' . $failed . ')'));
?>
<img src="<?php
print $piChart3->getUrl();
?>
" />
<div class="fl" style="width:300px;text-align:center;margin-bottom:5px;"> <?php
echo $admin_language['transaction_status'];
?>
</div>
</div>
<?php
}
?>
<title>PHP Wrapper for Google Chart API Examples - 0.5</title>
<style type="text/css">
img { display:block; }
</style>
</head>
<body>
<h1>PHP Wrapper for Google Chart API Examples - 0.5</h1>
<h1>Quick examples.</h1>
<?php
require '../inc/gChartInit.php';
?>
<h2>Pie Chart</h2>
<?php
$piChart = new gPieChart();
$piChart->addDataSet(array(112, 315, 66, 40));
$piChart->setLegend(array("first", "second", "third", "fourth"));
$piChart->setLabels(array("first", "second", "third", "fourth"));
$piChart->setColors(array("ff3344", "11ff11", "22aacc", "3333aa"));
?>
<img src="<?php
print $piChart->getUrl();
?>
" /> <br> pie chart using the gPieChart class.
<p>
<em>code:</em><br>
<code>
$piChart = new gPieChar();<br>
$piChart->addDataSet(array(112,315,66,40));<br>
$piChart->setLegend(array("first", "second", "third","fourth"));<br>
$statustotal = $onlinecount + $offlinecount + $deadcount;
$admintotal = $admintruecount + $adminfalsecount;
$ostotal = $windows7count + $windowsvistacount + $windowsxpcount + $unknowncount;
$piChart1 = new gPieChart(250, 125);
$piChart1->addDataSet(array($onlinecount, $offlinecount, $deadcount));
$piChart1->setLegend(array("Online", "Offline", "Dead"));
$piChart1->setLabels(array(round($onlinecount / $statustotal * 100, 0) . "%", round($offlinecount / $statustotal * 100, 0) . "%", round($deadcount / $statustotal * 100, 0) . "%"));
$piChart1->setColors(array("5D8AA8", "B4CDCD", "E32636"));
$piChart1->addBackgroundFill('bg', '000000');
$piChart2 = new gPieChart(250, 125);
$piChart2->addDataSet(array($admintruecount, $adminfalsecount));
$piChart2->setLegend(array("Admin", "User"));
$piChart2->setLabels(array(round($admintruecount / $statustotal * 100, 0) . "%", round($adminfalsecount / $statustotal * 100, 0) . "%"));
$piChart2->setColors(array("5D8AA8", "B4CDCD"));
$piChart2->addBackgroundFill('bg', '000000');
$piChart3 = new gPieChart(250, 125);
$piChart3->addDataSet(array($windows7count, $windowsvistacount, $windowsxpcount, $unknowncount));
$piChart3->setLegend(array("7", "Vista", "XP", "Unknown"));
$piChart3->setLabels(array(round($windows7count / $statustotal * 100, 0) . "%", round($windowsvistacount / $statustotal * 100, 0) . "%", round($windowsxpcount / $statustotal * 100, 0) . "%", round($unknowncount / $statustotal * 100, 0) . "%"));
$piChart3->setColors(array("5D8AA8", "B4CDCD", "E32636", "EFDECD"));
$piChart3->addBackgroundFill('bg', '000000');
$cclist = array();
$ccvalues = array();
while ($row = mysql_fetch_array($ccs)) {
array_push($cclist, $row[0]);
$values = mysql_query("SELECT * FROM clients WHERE cc LIKE '{$row['0']}'");
array_push($ccvalues, mysql_num_rows($values) / $totalbots * 100);
}
$map1 = new gMapChart();
$map1->setZoomArea('world');
$map1->setStateCodes($cclist);
/**
* 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;
}
}
