Rev 1 | Rev 36 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed
<?php
include_once( 'header.php' );
include_once( 'DBDatabase.class.php' );
require_once( 'Template.class.php' );
$smarty = new SmartyTemplate();
$smarty->assign('name','Ned');
?>
<?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>Daily Data - Computer Asset Management Program</title>
<link rel="stylesheet" type="text/css" href="camp.css">
</head>
<body>
<?php
include_once('menu.php');
?>
<div id="content">
<?php
global $DATABASE_DEFINITION;
$camp = new DBDatabase( 'camp', $DATABASE_DEFINITION );
//print "<pre>\n" . print_r($camp, true) . "\n</pre>";
$i = $camp->getTable('devices')->SQLQuery( 'list', array( 'where' => array('devices.removed is null', 'devices.device_type_id in (select id from device_types where system = 1)') ) );
print "<pre>\n$i\n" . print_r( $camp->getTable('devices')->queries, true ) . '</pre>';
$i = $camp->getTable('device_types')->SQLQuery( 'list', array( 'where' => array('removed is null') ) );
print "<pre>\n$i\n" . print_r( $camp->getTable('device_types')->queries, true ) . '</pre>';
// print "<pre>\n$i\n" . print_r( $camp->getTable('owners')->queries, true );
?>
</div>
</body>
</html>
?>