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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<?
# 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: tracking-index.php3,v 1.9 2000/04/11 04:34:05 atrus Exp $
#
################################################################################
# CHANGELOG #
################################################################################
# 7/22/99 - Keith Schoenefeld: Cleaned up code, converted all IF(): to if(){. #
################################################################################
include("../irm.inc");
AuthCheck("post-only");
$db = new DB;
commonHeader("IRM Tracking");
$query = "SELECT advanced_tracking,tracking_order FROM prefs WHERE (user = '$IRMName')";
$result = $db->query($query);
$advanced_tracking = $db->result($result, 0, "advanced_tracking");
$tracking_order = $db->result($result, 0, "tracking_order");
if($tracking_order == "yes")
{
$tracking_order = "ASC";
} else
{
$tracking_order = "DESC";
}
if($advanced_tracking == "yes")
{
PRINT "<form method=\"get\" action=\"tracking-index.php3\">";
PRINT "<select name=\"show\" size=1>";
PRINT "<option ";
if($show == "all")
{
PRINT "selected";
}
PRINT " value=\"all\"> Show All Tracking</option>";
PRINT "<option ";
if($show == "individual")
{
PRINT "selected";
}
PRINT " value=\"individual\">Show only tracking assigned to you</option>";
PRINT "<option ";
if($show == "unassigned")
{
PRINT "selected";
}
PRINT " value=\"unassigned\">Show only tracking not assigned to
anyone</option>";
PRINT "</select>";
PRINT "<input type=submit value=\"Show\">";
PRINT "</form>";
}
PRINT "<br>\n";
?>
This is the IRM tracking system where you can post new jobs, keep tabs on old
jobs, post followups, etc. To add a job, first navigate to the appropiate
computer and click the add tracking button.
<hr noshade>
<form method=get action=tracking-search.php3>
Search all of tracking for the following term: <input type=text name=contains size=20> <input type=submit value=Search>
</form>
<hr noshade>
<h3>Outstanding Jobs</h3>
<hr noshade>
<?
if($advanced_tracking == "yes" && (($show == "individual") ||
($show == "unassigned")))
{
if($show == "individual")
{
$query = "SELECT ID FROM tracking WHERE (status = 'new') and
(assign = '$IRMName') ORDER BY date $tracking_order";
} else if ($show == "unassigned")
{
$query = "SELECT ID FROM tracking WHERE (status = 'new') and
(assign is null) ORDER BY date $tracking_order";
}
} else
{
$query = "SELECT ID FROM tracking WHERE (status = 'new') ORDER BY
date $tracking_order";
}
$result = $db->query($query);
$i = 0;
$number = $db->numrows($result);
PRINT "<center><table border=1 width=\"100%\">";
PRINT "<tr bgcolor=#DDDDDD><th>ID</th><th>Status</th><th>Date</th><th width=5>Pri</th>
<th>Author</th><th>Assigned</th><th>Computer</th><th colspan=2 width=70%>
Description</th></tr>";
while ($i < $number)
{
$ID = $db->result($result, $i, "ID");
Show_tracking($ID, 0);
$i++;
}
PRINT "</table></center>";
commonFooter();
?>
|
