// ===============================================================
$graph = new CGraph("backupjobreport-graph01.jpg");
foreach ($days as $day) {
$stored_bytes = Jobs_Model::getStoredBytes($dbSql->db_link, array($day['start'], $day['end']), $backupjob_name);
$days_stored_bytes[] = array(date("m-d", $day['start']), $stored_bytes);
}
$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');
// ===============================================================
$graph = new CGraph("clientreport-graph01.jpg");
foreach ($days as $day) {
$stored_bytes = Jobs_Model::getStoredBytes($dbSql->db_link, array($day['start'], $day['end']), 'ALL', $clientid);
$days_stored_bytes[] = array(date("m-d", $day['start']), $stored_bytes);
}
$graph->SetData($days_stored_bytes, 'bars', true);
// Graph rendering
$view->assign('graph_stored_bytes', $graph->Render());
unset($graph);
// ===============================================================
// Getting last n days stored files graph
// ===============================================================
$graph = new CGraph("clientreport-graph03.jpg");
foreach ($days as $day) {
$stored_files = Jobs_Model::getStoredFiles($dbSql->db_link, array($day['start'], $day['end']), 'ALL', $clientid);
$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);
} catch (Exception $e) {
CErrorHandler::displayError($e);
}
$view->assign('period', $period);
$view->assign('client_name', $client['name']);
$view->assign('client_os', $client['os']);
$view->assign('client_arch', $client['arch']);
$view->assign('client_version', $client['version']);
} else {
$job['speed'] = 'n/a';
}
// Job compression
if ($job['jobbytes'] > 0 && $job['type'] == 'B') {
$compression = 1 - $job['jobbytes'] / $job['readbytes'];
$job['compression'] = number_format($compression, 2);
} else {
$job['compression'] = 'n/a';
}
break;
}
// end switch
// Job size
$job['jobbytes'] = CUtils::Get_Human_Size($job['jobbytes']);
// Job Pool
if (is_null($job['pool_name'])) {
$job['pool_name'] = 'n/a';
}
$last_jobs[] = $job;
}
// end foreach
$view->assign('last_jobs', $last_jobs);
// Count jobs
$view->assign('jobs_found', count($last_jobs));
$view->assign('total_jobs', Jobs_Model::count($dbSql->db_link));
// Set page name
$current_page = 'Jobs report';
$view->assign('page_name', $current_page);
// Process and display the template
$view->render('jobs.tpl');
$days_stored_bytes = array();
$days = DateTimeUtil::getLastDaysIntervals(7);
foreach ($days as $day) {
$days_stored_bytes[] = array(date("m-d", $day['start']), Jobs_Model::getStoredBytes($dbSql->db_link, array($day['start'], $day['end'])));
}
$graph = new CGraph("dashboard-graph03.jpg");
$graph->SetData($days_stored_bytes, 'bars', true);
// Graph rendering
$view->assign('graph_stored_bytes', $graph->Render());
// ==============================================================
// Last 7 days Stored Files widget
// ==============================================================
$days_stored_files = array();
$days = DateTimeUtil::getLastDaysIntervals(7);
foreach ($days as $day) {
$days_stored_files[] = array(date("m-d", $day['start']), Jobs_Model::getStoredFiles($dbSql->db_link, array($day['start'], $day['end'])));
}
unset($graph);
$graph = new CGraph("dashboard-graph04.jpg");
$graph->SetData($days_stored_files, 'bars');
// Graph rendering
$view->assign('graph_stored_files', $graph->Render());
unset($graph);
// ==============================================================
// Last used volumes widget
// ==============================================================
$last_volumes = array();
// Building SQL statment
$where = array();
$tmp = "(Media.Volstatus != 'Disabled') ";
switch (CDB::getDriverName()) {
