Blame | Last modification | View Log | Download | RSS feed
<?php
include_once( '../../header.php' );
include_once( '../../includes/functions.php' );
include_once( './functions.php' );
define ( 'DEBUG', false );
?>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Computer Asset Management Program - Backups - PAGE NAME</title>
<link rel="stylesheet" type="text/css" href="../../camp.css">
</head>
<body>
<?php include_once('../../menu.php'); ?>
<div id="content">
<?php
include_once( 'functions.php' );
/* $sql = "select
backups.backups_id 'ID',
device.name 'Device',
server_device.name 'Server',
round ( backups.allocated_size / 1024 / 1024, 0 ) 'Size (M)',
backups.start_time 'Start Time',
backups.bandwidth_allocated 'Bandwidth (Mb/s)',
backups.responsible_party 'Responsible'
from
backups join device using (device_id)
join (
backups_server join device server_device using (device_id)
)
using ( backups_server_id )
where
backups.removed_date is null
order by
server_device.name,
device.name
";
*/
$sql = insertValuesIntoQuery(SQL_GET_BACKUPS,
array('whereClause' => setAuth(implode( ' and ',
array("backups.removed_date is null"
)))));
/*
* if ( $client_id ) { // we have a client, show sites
$sql = insertValuesIntoQuery(SQL_SHOW_SITES,
array('whereClause' => setAuth(implode( ' and ',
array("site.client_id = $client_id"
)))));
$currentScreen = '<a href="edit.html?command=add_site">Add Site</a>';
$callables = callableOutput( 'client view', array( 'client_id' => $client_id ) );
} elseif ($site_id) { // we have a site, show devices
$sql = insertValuesIntoQuery(SQL_SHOW_DEVICES,
array('whereClause' => setAuth(implode( ' and ',
array("device.site_id = $site_id"
)))));
$currentScreen = '<a href="edit.html?command=add_device">Add Device</a>';
$callables = callableOutput( 'site view', array( 'site_id' => $site_id ) );
} else { // we have nothing, show client list
$sql = insertValuesIntoQuery(SQL_SHOW_CLIENTS,
array('whereClause' => setAuth('1')));
$currentScreen = '<a href="edit.html?command=add_client">Add Client</a>';
}
*/
//print "<pre>\n$sql\n</pre>";
print queryToTable( $sql );
// print $currentScreen;
// print $callables;
?>
</div>
</body>
</html>