1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
|
<?
# IRM - The Information Resource Manager
# Copyright (C) 1999 Yann Ramin
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License (in file COPYING) for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#
# $Id: software-index.php3,v 1.5.2.1 2000/08/23 01:04:48 atrus Exp $
#
################################################################################
# CHANGELOG #
################################################################################
# 7/22/99 - Keith Schoenefeld: Cleaned up code, converted all IF(): to if(){. #
################################################################################
include("../irm.inc");
AuthCheck("normal");
$db = new DB;
commonHeader("IRM Software");
?>
Welcome to the IRM Software section. This where you keep information about all
of your software. <a href="software-add-form.php3">Click here to add software</a>
<p>Or you might want to search through the software:
<br><form method=get action="software-search.php3"><select name="field" size=1>
<option value="ID">IRM ID</option>
<option value="name">Name</option>
<option value="platform">Platform</option>
<option value="location">Location</option>
<option value="version">Version</option>
<option value="serial">Serial Number</option>
<option value="otherserial">Other Number</option>
<option value="license">Number of Licenses</option>
<option value="comments">Comments</option>
</select> where that field contains
<input type=text size=30 name="contains"> and then show in <select name=style>
<option value=list selected>list view</option>
<option value=full>full view</option>
</select>. <input type=submit value="Search"></form>
<hr noshade>
<?
$query = "SELECT * FROM software ORDER BY name";
$result = $db->query($query);
PRINT "<table border=1 width=100%><tr bgcolor=#CCCCCC><th>
Name</th><th>Platform</th><th>Licenses</th></tr>";
$i = 0;
$number = $db->numrows($result);
while ($i < $number)
{
$ID = $db->result($result, $i, "ID");
$name = $db->result($result, $i, "name");
$platform = $db->result($result, $i, "platform");
$license = $db->result($result, $i, "license");
PRINT "<tr bgcolor=#DDDDDD><td><a href=\"software-info.php3?ID=$ID\">
$name ($ID)</a></td><td>$platform</td><td>";
$installed = Count_software($ID);
$remaining = $license - $installed;
PRINT "<font face=\"Arial, Helvetica\">Installed: <b>$installed</b> Remaining: <b>";
if ($remaining < 0) {
PRINT "<font color=red>";
} else if ($remaining == 0) {
PRINT "<font color=blue>";
} else {
PRINT "<font color=black>";
}
PRINT "$remaining</font></b> Total: <b>$license</b></font></td>";
PRINT "</tr>";
$i++;
}
PRINT "</table>";
commonFooter();
?>
|