$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'); $result = CDBUtils::runQuery($query, $dbSql->db_link); foreach ($result->fetchAll() as $job) { // Job level description $job['joblevel'] = $joblevel[$job['level']];