| 1 |
rodolico |
1 |
<?php
|
|
|
2 |
include_once( 'header.php' );
|
|
|
3 |
include_once( 'DBDatabase.class.php' );
|
|
|
4 |
require_once( 'Template.class.php' );
|
|
|
5 |
$smarty = new SmartyTemplate();
|
|
|
6 |
$smarty->assign('name','Ned');
|
|
|
7 |
?>
|
|
|
8 |
<?xml version="1.0" encoding="utf-8"?>
|
|
|
9 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
|
10 |
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
|
11 |
<head>
|
|
|
12 |
<title>Daily Data - Computer Asset Management Program</title>
|
|
|
13 |
<link rel="stylesheet" type="text/css" href="camp.css">
|
|
|
14 |
</head>
|
|
|
15 |
<body>
|
|
|
16 |
<?php
|
|
|
17 |
include_once('menu.php');
|
|
|
18 |
?>
|
|
|
19 |
<div id="content">
|
|
|
20 |
<?php
|
|
|
21 |
global $DATABASE_DEFINITION;
|
|
|
22 |
$camp = new DBDatabase( 'camp', $DATABASE_DEFINITION );
|
|
|
23 |
//print "<pre>\n" . print_r($camp, true) . "\n</pre>";
|
|
|
24 |
$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)') ) );
|
|
|
25 |
print "<pre>\n$i\n" . print_r( $camp->getTable('devices')->queries, true ) . '</pre>';
|
|
|
26 |
$i = $camp->getTable('device_types')->SQLQuery( 'list', array( 'where' => array('removed is null') ) );
|
|
|
27 |
print "<pre>\n$i\n" . print_r( $camp->getTable('device_types')->queries, true ) . '</pre>';
|
|
|
28 |
// print "<pre>\n$i\n" . print_r( $camp->getTable('owners')->queries, true );
|
|
|
29 |
?>
|
|
|
30 |
</div>
|
|
|
31 |
</body>
|
|
|
32 |
</html>
|
|
|
33 |
|
|
|
34 |
|
|
|
35 |
|
|
|
36 |
|
|
|
37 |
|
|
|
38 |
?>
|