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
// ===============================================================
$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');
// 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
// ===============================================================
$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');
$vols_by_pool[] = array($pool['name'], $pool['numvols']);
}
if ($pools_count > $max_pools) {
$vols_by_pool[] = array('Others', $sum_vols['sum_vols']);
}
$graph->SetData($vols_by_pool, 'pie');
// Graph rendering
$view->assign('graph_pools', $graph->Render());
unset($graph);
// ==============================================================
// Last 7 days stored Bytes widget
// ==============================================================
$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");
