$graph->SetData($days_stored_bytes, 'bars', true);
// Graph rendering
$view->assign('graph_stored_bytes', $graph->Render());
unset($graph);
// ===============================================================
// Getting last 7 days stored files graph
// ===============================================================
$graph = new CGraph("backupjobreport-graph02.jpg");
foreach ($days as $day) {
$stored_files = Jobs_Model::getStoredFiles($dbSql->db_link, array($day['start'], $day['end']), $backupjob_name);
$days_stored_files[] = array(date("m-d", $day['start']), $stored_files);
}
$graph->SetData($days_stored_files, 'bars');
$graph->SetYTitle("Files");
// Graph rendering
$view->assign('graph_stored_files', $graph->Render());
unset($graph);
// Get last 10 jobs list
$query = "SELECT JobId, Level, JobFiles, JobBytes, ReadBytes, JobStatus, StartTime, EndTime, Name ";
$query .= "FROM Job ";
$query .= "WHERE Name = '{$backupjob_name}' ";
$query .= "ORDER BY EndTime DESC ";
$query .= "LIMIT 7 ";
$jobs = array();
$joblevel = array('I' => 'Incr', 'D' => 'Diff', 'F' => 'Full');
$result = CDBUtils::runQuery($query, $dbSql->db_link);
foreach ($result->fetchAll() as $job) {
// Job level description
$job['joblevel'] = $joblevel[$job['level']];
// Job execution execution time
$job['elapsedtime'] = DateTimeUtil::Get_Elapsed_Time($job['starttime'], $job['endtime']);
case 'db-connection':
$check['check_result'] = $icon_result[CDBUtils::isConnected($dbSql->db_link)];
break;
case 'php-timezone':
$timezone = ini_get('date.timezone');
if (!empty($timezone)) {
$check['check_result'] = $icon_result[true];
} else {
$check['check_result'] = $icon_result[false];
}
break;
}
}
// Testing graph capabilities
$data = array(array('test', 100), array('test1', 150), array('test1', 180), array('test1', 456));
// Pie graph
$pie_graph = new CGraph("testpage-graph03.jpg");
$pie_graph->SetData($data, 'pie');
$view->assign('pie_graph', $pie_graph->Render());
unset($pie_graph);
// Bar graph
$bar_graph = new CGraph("testpage-graph04.jpg");
$bar_graph->SetData($data, 'bars');
$view->assign('bar_graph', $bar_graph->Render());
unset($bar_graph);
// Set page name
$current_page = 'Test page';
$view->assign('page_name', $current_page);
// Template rendering
$view->assign('checks', $check_list);
$view->display('test.tpl');
