Changes of Revision 86
| [-] | Changed | _service:set_version:inventory-system.spec |
|
x 1 2 %define pkgname inventory-system3 Name: inventory-system4 Release: 05 -Version: 0.0.rev42046 +Version: 0.0.rev42457 Url: http://www.linux-administrator.com/8 License: GPLv29 Group: System10 11 %config(noreplace) %{wwwdir}/config-custom.inc.php12 %config(noreplace) %{wwwdir}/db.inc.php13 %{wwwdir}/isdf.php14 +%{wwwdir}/search.php15 %{wwwdir}/status.php16 %{wwwdir}/dhcpconf.class.php17 %{wwwdir}/inet4.class.php18 |
||
| [-] | Changed | inventory-system.spec ^ |
|
9 1 2 %config(noreplace) %{wwwdir}/config-custom.inc.php3 %config(noreplace) %{wwwdir}/db.inc.php4 %{wwwdir}/isdf.php5 +%{wwwdir}/search.php6 %{wwwdir}/status.php7 %{wwwdir}/dhcpconf.class.php8 %{wwwdir}/inet4.class.php9 |
||
| [+] | Added | _service:recompress:tar_scm:inventory-system-0.0.rev4245.tar.bz2/server/search.php ^ |
| @@ -0,0 +1,104 @@ +<?php +/* +// isdf - inventory system search +// Author: Carsten Schoene +// +// $LastChangedDate: 2012-07-20 21:09:25 +0200 (Fr, 20. Jul 2012) $ +// $Rev: 1619 $ +*/ + +// define our name +define('MYNAME', "isdf-search"); +// open syslog connection +openlog(MYNAME,LOG_PID | LOG_ODELAY,LOG_MAIL); + +// check for required extensions +if ( ! extension_loaded("mysql") ) { + if ( ! dl("mysql") ) { + syslog(LOG_ERR,"mysql extension not loaded!"); + exit; + } +} + +// load additional files +define('BASE',dirname(__FILE__)); +require_once("MDB2.php"); +require_once(BASE . "/config.inc.php"); +require_once(BASE . "/config-custom.inc.php"); +require_once(BASE . "/db.inc.php"); + +echo '<html><head> +<title>inventory system - search web</title> +</head> +<body> +<form action="' . $_SERVER['PHP_SELF'] . '"><table> +<tr><td>Search property:</td> + <td><select name="systemid"> +'; +// create database connection +$dbh =& MDB2::singleton($config['isdf']['db'], $config['mdb2']['options'] ); + +//$uuidsql = "SELECT id,system_uuid FROM inv_system"; +// datakeys +$datakeysql = "select datakey from inv_system_properties GROUP BY datakey"; +$options = ""; +$res = $dbh->query($datakeysql); +if (PEAR::isError($res)) { + syslog(LOG_ERR, "MDB2 res: " . $res->getMessage()); +} else { + echo '<option value="all">All</option>'; + while (( $row = $res->fetchRow(MDB2_FETCHMODE_ASSOC) )) { + /* if ( isset($_GET['systemid'])) { + if ( $row['id'] == $_GET['systemid'] ) { + echo '<option selected value="' . $row['id'] . '">' . $row['system_uuid'] . '</option>'; + } else { + echo '<option value="' . $row['id'] . '">' . $row['system_uuid'] . '</option>'; + } + } else { */ + $options .= '<option value="' . $row['datakey'] . '">' . $row['datakey'] . '</option>'; + /* } */ + } +} +echo $options; +$options = preg_replace('#<option#','<option selected="selected"',$options); +echo ' +</select></td><td><input type="text" size="27" name="search"></td></tr> +<tr><td colspan="2" valign="top">Select fields for output result:</td><td><select name="output[]" multiple="multiple" size="5">'.$options.'</select></td></tr> +<tr><td colspan="3" align="right"><input type="submit" value="Search"></td></tr></table></form> +'; + +if ( isset($_GET['systemid']) && isset($_GET['search']) && isset($_GET['output'])) { + $systemid = $_GET['systemid']; + $search = $dbh->escape($_GET['search']); + $output = $_GET['output']; + if ( $systemid == "all" ) { + $idsql = "SELECT inv_system_id FROM inv_system_properties WHERE value LIKE '%$search%'"; + } else { + $idsql = "SELECT inv_system_id FROM inv_system_properties WHERE datakey = '$systemid' AND value LIKE '%$search%'"; + } + + $idres = $dbh->query($idsql); + if (PEAR::isError($idres)) { + syslog(LOG_ERR, "MDB2 idres: " . $idres->getMessage()); + } else { + while (( $idrow = $idres->fetchRow(MDB2_FETCHMODE_ASSOC) )) { + $datasql = "SELECT datakey, value FROM inv_system_properties WHERE inv_system_id = '". $idrow['inv_system_id'] . "'"; + $datares = $dbh->query($datasql); + if (PEAR::isError($datares)) { + syslog(LOG_ERR, "MDB2 datares: " . $datares->getMessage()); + } else { + echo '<table>'; + echo '<tr><th>Key:</th><th>Value:</th></tr>'; + while (( $row = $datares->fetchRow(MDB2_FETCHMODE_ASSOC) )) { + if ( in_array($row['datakey'], $output) ) { + echo '<tr><td valign="top">' . $row['datakey'] . '</td><td>' . $row['value'] . '</td></tr>'; + } + } + echo '</table>'; + } + } + } +} +echo '</body></html>'; +$dbh->disconnect(); +?> | ||