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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
<?
# 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-search.php3,v 1.6.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 - Search Results");
PRINT "Showing results where $field contains $contains in
$style view.<ht noshade>";
if ($style == "full")
{
$query = "SELECT * FROM software WHERE ($field LIKE '%$contains%') ORDER BY name";
# $query = "SELECT * FROM software WHERE ($field is '%$contains%')";
$result = $db->query($query);
$i = $goto;
$number = $db->numrows($result);
while ($i < $number)
{
$ID = $db->result($result, $i, "ID");
showSoftware($ID, 0);
if (($number - $i) < 5)
{
break;
}
$i++;
}
$backgoto = $goto - 5;
$forgoto = $goto + 5;
PRINT "<table border=0><tr><td>";
if ($backgoto > -1)
{
PRINT "<form><input type=hidden name=field value=\"$field\"><input
type=hidden name=contains value=\"$contains\"><input
type=hidden name=style value=\"$style\"><input type=hidden
name=goto value=$backgoto><input type=submit
value=\"Previous 5\"></form>";
}
PRINT "</td><td>";
PRINT "<form><input type=hidden name=field value=\"$field\"><input
type=hidden name=contains value=\"$contains\"><input
type=hidden name=style value=\"$style\"><input type=hidden
name=goto value=$forgoto><input type=submit
value=\"Next 5\"></form>";
PRINT "</td></tr></table>";
} elseif ($style == "list")
{
$query = "SELECT * FROM software WHERE ($field LIKE '%$contains%')";
$result = $db->query($query);
PRINT "<table border=1 width=100%><tr
bgcolor=#CCCCCC><th>Name</th><th>Platform</th><th>Licnses</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>";
}
PRINT "$remaining</font></b> Total: <b>$license</b></font></td>";
PRINT "</tr>";
$i++;
}
PRINT "</table>";
}
commonFooter();
?>
|
