$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']]; // Job execution execution time $job['elapsedtime'] = DateTimeUtil::Get_Elapsed_Time($job['starttime'], $job['endtime']); // Compression if ($job['jobbytes'] > 0) { $compression = 1 - $job['jobbytes'] / $job['readbytes']; $job['compression'] = number_format($compression, 2); } else { $job['compression'] = 'N/A'; } // Job speed $start = $job['starttime']; $end = $job['endtime']; $seconds = DateTimeUtil::get_ElaspedSeconds($end, $start); if ($seconds !== false && $seconds > 0) { $speed = $job['jobbytes'] / $seconds; $job['speed'] = CUtils::Get_Human_Size($speed, 2) . '/s'; } else {
case J_NOT_RUNNING: $job['Job_icon'] = "time"; break; } // end switch // Job start time, end time and elapsed time $start_time = $job['starttime']; $end_time = $job['endtime']; if ($start_time == '0000-00-00 00:00:00' or is_null($start_time) or $start_time == 0) { $job['starttime'] = 'n/a'; } if ($end_time == '0000-00-00 00:00:00' or is_null($end_time) or $end_time == 0) { $job['endtime'] = 'n/a'; } // Get the job elapsed time completion $job['elapsed_time'] = DateTimeUtil::Get_Elapsed_Time($start_time, $end_time); // Job Level $job['level'] = $job_levels[$job['level']]; // Job files $job['jobfiles'] = CUtils::format_Number($job['jobfiles']); // Set default Job speed and compression rate $job['speed'] = '0 Mb/s'; $job['compression'] = 'n/a'; switch ($job['jobstatus']) { case J_COMPLETED: case J_COMPLETED_ERROR: case J_NO_FATAL_ERROR: case J_CANCELED: // Job speed $seconds = DateTimeUtil::get_ElaspedSeconds($end_time, $start_time); if ($seconds !== false && $seconds > 0) {