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");