session_start();
include_once 'core/global.inc.php';
try {
// Initialise view and model
$view = new CView();
$dbSql = new Bweb($view);
require_once 'core/const.inc.php';
$backupjob_name = "";
$backupjob_bytes = 0;
$backupjob_files = 0;
$days = array();
$days_stored_bytes = array();
$days_stored_files = array();
// 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
break;
case STATUS_CANCELED:
$query .= "WHERE Job.JobStatus = 'A' ";
break;
case STATUS_ALL:
$query .= "WHERE Job.JobStatus != 'xxxx' ";
// This code must be improved
break;
}
$view->assign('job_status_filter', CHttpRequest::get_Value('status'));
}
// Selected client filter
if (!is_null(CHttpRequest::get_Value('client_id'))) {
$client_id = CHttpRequest::get_Value('client_id');
$view->assign('client_filter', $client_id);
if (!is_null(CHttpRequest::get_value('status'))) {
if ($client_id != 0) {
$query .= "AND Job.ClientId = '{$client_id}' ";
}
} else {
if ($client_id != 0) {
$query .= "WHERE Job.ClientId = '{$client_id}' ";
}
}
} else {
$view->assign('client_filter', 0);
}
$order_by = '';
$order_by_asc = 'DESC';
$result_order_asc_checked = '';
// Order result by