コード例 #1
0
 // 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
 // ===============================================================
コード例 #2
0
ファイル: client-report.php プロジェクト: ektich/bacula-web
     $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
 // ===============================================================