'Differential', 'I' => 'Incremental', 'F' => 'Full' ); $http_post = CHttpRequest::getRequestVars( $_POST ); $http_get = CHttpRequest::getRequestVars( $_GET ); if( isset( $http_post['client_id'] ) ) $clientid = $http_post['client_id']; elseif( isset( $http_get['client_id'] ) ) $clientid = $http_get['client_id']; else die( "Application error: Client not specified " ); // Client informations $client = $dbSql->getClientInfos($clientid); // Client's backup jobs $query = 'SELECT Job.Name, Job.Jobid, Job.Level, Job.Jobbytes, Job.Jobfiles, Status.JobStatusLong FROM Job '; $query .= "LEFT JOIN Status ON Job.JobStatus = Status.JobStatus "; $query .= "WHERE Job.ClientId = '$clientid' AND Job.JobStatus = 'T' "; $query .= 'ORDER BY Job.EndTime DESC '; $query .= 'LIMIT 1'; try{ $jobs_result = $dbSql->db_link->runQuery($query); foreach( $jobs_result->fetchAll() as $job ) { $job['level'] = $job_levels[ $job['level'] ]; $job['jobfiles'] = number_format( $job['jobfiles'], 0, '.', "'"); $job['jobbytes'] = CUtils::Get_Human_Size( $job['jobbytes'] ); $backup_jobs[] = $job; } }catch(PDOException $e) { CDBError::raiseError($e); } $dbSql->tpl->assign( 'backup_jobs', $backup_jobs); $dbSql->tpl->assign( 'client_name', $client['name']); $dbSql->tpl->assign( 'client_os', $client['os']); $dbSql->tpl->assign( 'client_arch', $client['arch']); $dbSql->tpl->assign( 'client_version', $client['version']); // Process and display the template $dbSql->tpl->display('client-report.tpl'); ?>