// Backup job name
if (!is_null(CHttpRequest::get_value('backupjob_name'))) {
$backupjob_name = CHttpRequest::get_value('backupjob_name');
} else {
throw new Exception("Error: Backup job name not specified");
}
// Generate Backup Job report period string
$backupjob_period = "From " . date("Y-m-d", NOW - WEEK) . " to " . date("Y-m-d", NOW);
// Stored Bytes on the defined period
$backupjob_bytes = Jobs_Model::getStoredBytes($dbSql->db_link, array(LAST_WEEK, NOW), $backupjob_name);
$backupjob_bytes = CUtils::Get_Human_Size($backupjob_bytes);
// Stored files on the defined period
$backupjob_files = Jobs_Model::getStoredFiles($dbSql->db_link, array(LAST_WEEK, NOW), $backupjob_name);
$backupjob_files = CUtils::format_Number($backupjob_files);
// Get the last 7 days interval (start and end)
$days = DateTimeUtil::getLastDaysIntervals(7);
// ===============================================================
// Last 7 days stored Bytes graph
// ===============================================================
$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
// ===============================================================
$query = 'SELECT Job.Name, Job.Jobid, Job.Level, Job.Endtime, Job.Jobbytes, Job.Jobfiles, Status.JobStatusLong FROM Job ';
$query .= "LEFT JOIN Status ON Job.JobStatus = Status.JobStatus ";
$query .= "WHERE Job.Name = '{$jobname}' AND Job.JobStatus = 'T' AND Job.Type = 'B' ";
$query .= 'ORDER BY Job.EndTime DESC ';
$query .= 'LIMIT 1';
$jobs_result = CDBUtils::runQuery($query, $dbSql->db_link);
foreach ($jobs_result->fetchAll() as $job) {
$job['level'] = $job_levels[$job['level']];
$job['jobfiles'] = CUtils::format_Number($job['jobfiles']);
$job['jobbytes'] = CUtils::Get_Human_Size($job['jobbytes']);
$backup_jobs[] = $job;
}
}
$view->assign('backup_jobs', $backup_jobs);
// Get the last n days interval (start and end)
$days = DateTimeUtil::getLastDaysIntervals($period);
// ===============================================================
// Last n days stored Bytes graph
// ===============================================================
$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
// ===============================================================