1 |
<?php |
2 |
// Load globals |
3 |
require_once ("global_vars.php"); |
4 |
|
5 |
// Includes |
6 |
require_once ($GLOBAL_ADMIN_INC."sessionClass.php"); |
7 |
require_once ($GLOBAL_ADMIN_INC."accessClass.php"); |
8 |
require_once ($GLOBAL_ADMIN_INC."db_connect.php"); |
9 |
require_once ($GLOBAL_ADMIN_INC."app_controls.php"); |
10 |
|
11 |
|
12 |
// HTML header |
13 |
printf("<HTML>\n"); |
14 |
printf("<HEAD>\n"); |
15 |
printf("<title>RQS Staff Assignments</title>\n"); |
16 |
printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS); |
17 |
printf("</HEAD>\n"); |
18 |
|
19 |
|
20 |
// Page header |
21 |
require_once ($GLOBAL_ADMIN_HEADER); |
22 |
|
23 |
|
24 |
// Collect access information |
25 |
if(isset($libsession)) { |
26 |
|
27 |
// Fetch session information |
28 |
$sessionClass = new sessionClass("", $libsession, "", ""); |
29 |
$accessClass = new accessClass($sessionClass); |
30 |
|
31 |
// Load user session variables |
32 |
$sess_time_human = $sessionClass->time_human; |
33 |
$sess_staff_account = $sessionClass->staff_account; |
34 |
$sess_access_level = $accessClass->access_level; |
35 |
$sess_access = $accessClass->access; |
36 |
$sess_last_name = $accessClass->last_name; |
37 |
$sess_first_name = $accessClass->first_name; |
38 |
|
39 |
} |
40 |
|
41 |
|
42 |
|
43 |
|
44 |
// If the cookie is set and access level is appropriate |
45 |
if(isset($libsession) && $sess_access_level >= 100) { |
46 |
?> |
47 |
|
48 |
<body> |
49 |
|
50 |
<h3>RQS Staff Assignments</h3> |
51 |
<br><br> |
52 |
|
53 |
|
54 |
<center> |
55 |
<table border="1" width="95%"> |
56 |
<tr> |
57 |
<td class="cellPlain">RQS Subject</td> |
58 |
<td class="cellPlain">Created</td> |
59 |
<td class="cellPlain">Updated</td> |
60 |
<td class="cellPlain">Public?</td> |
61 |
<td class="cellPlain">Assigned Staff</td> |
62 |
</tr> |
63 |
|
64 |
|
65 |
|
66 |
<?php |
67 |
// Initialize |
68 |
$rowcount = 0; |
69 |
|
70 |
// Build the SQL |
71 |
$sql = "SELECT |
72 |
s.subject_id, |
73 |
s.subject, |
74 |
s.rqs_date_created, |
75 |
s.rqs_date_modified, |
76 |
s.rqs_account_created, |
77 |
s.rqs_account_modified, |
78 |
s.rqs_published, |
79 |
f.staff_id, |
80 |
f.last_name, |
81 |
f.first_name, |
82 |
f.staff_account |
83 |
FROM |
84 |
subject s |
85 |
LEFT JOIN sub_staff ss using (subject_id) |
86 |
LEFT JOIN staff f on ss.staff_id = f.staff_id |
87 |
WHERE s.subject_id > 1 |
88 |
ORDER BY |
89 |
s.subject, |
90 |
f.last_name, |
91 |
f.first_name"; |
92 |
|
93 |
// printf("sql was: %s<BR>", $sql); |
94 |
|
95 |
$rs = mysql_query($sql, $con); |
96 |
|
97 |
while ($row = mysql_fetch_array ($rs)) { |
98 |
|
99 |
// Increment counter |
100 |
$rowcount++; |
101 |
|
102 |
// Make every other third row colored |
103 |
if ($rowcount % 3 == 0) $color = " class=\"backLight\" "; |
104 |
else $color = ""; |
105 |
|
106 |
$subject = $row["subject"]; |
107 |
$subject_id = $row["subject_id"]; |
108 |
$rqs_date_created = $row["rqs_date_created"]; |
109 |
$rqs_date_modified = $row["rqs_date_modified"]; |
110 |
$rqs_account_created = $row["rqs_account_created"]; |
111 |
$rqs_account_modified = $row["rqs_account_modified"]; |
112 |
$rqs_published = $row["rqs_published"]; |
113 |
|
114 |
$staff_id = $row["staff_id"]; |
115 |
$staff_account = $row["staff_account"]; |
116 |
$last_name = $row["last_name"]; |
117 |
$first_name = $row["first_name"]; |
118 |
|
119 |
// Cleanup. Don't display hours, minutes, etc. on this summary page |
120 |
if (strlen($rqs_date_created) > 10) $rqs_date_created = substr($rqs_date_created, 0, 10); |
121 |
if (strlen($rqs_date_modified) > 10) $rqs_date_modified = substr($rqs_date_modified, 0, 10); |
122 |
|
123 |
|
124 |
$subject_link = "<a href=\"operation.phtml?operation=Edit&table=subject&key_id=" |
125 |
. $subject_id |
126 |
. "\"><b>" |
127 |
. $subject |
128 |
."</b></a>"; |
129 |
|
130 |
$staff_link = "<a href=\"operation.phtml?operation=Edit&table=staff&staff_id=" |
131 |
. $staff_id |
132 |
. "\"><b>" |
133 |
. $last_name . ", " . $first_name . " (" . $staff_account . ")" |
134 |
."</b></a>"; |
135 |
|
136 |
printf("<tr>\n"); |
137 |
|
138 |
|
139 |
// Check flag |
140 |
if ($subject_id != $last_subject_id) $new_sub = 1; |
141 |
else $new_sub = 0; |
142 |
|
143 |
|
144 |
// Subject |
145 |
if ($new_sub) printf("<td>%s</td>\n", $subject_link); |
146 |
else printf("<td> </td>\n"); |
147 |
|
148 |
// Created |
149 |
if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_created, $rqs_account_created); |
150 |
else printf("<td> </td>\n"); |
151 |
|
152 |
// Updated |
153 |
if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_modified, $rqs_account_modified); |
154 |
else printf("<td> </td>\n"); |
155 |
|
156 |
// Published |
157 |
if ($new_sub) { |
158 |
printf("<td>"); |
159 |
if ($rqs_published == "1") printf("Y"); |
160 |
else printf("N"); |
161 |
printf("</td>\n"); |
162 |
} |
163 |
else printf("<td> </td>\n"); |
164 |
|
165 |
// Assigned staff |
166 |
if ($staff_id > 0) printf("<td>%s</td>\n", $staff_link); |
167 |
else printf("<td>(none)</td>\n"); |
168 |
|
169 |
|
170 |
printf("</tr>\n"); |
171 |
|
172 |
$last_subject_id = $subject_id; |
173 |
|
174 |
|
175 |
}; |
176 |
|
177 |
printf("<tr><td colspan=\"5\" class=\"cellPlain\" align=\"center\"><br><b>Total Rows: %d</b><br><br></td></tr>\n", $rowcount); |
178 |
printf("</table>"); |
179 |
|
180 |
// Link to return to admin console |
181 |
adminReturn($sess_access_level); |
182 |
|
183 |
} // logged in |
184 |
|
185 |
// No access page |
186 |
else require_once ($GLOBAL_NO_ACCESS); |
187 |
|
188 |
|
189 |
// Page footer |
190 |
require_once ($GLOBAL_ADMIN_FOOTER); |
191 |
?> |
192 |
|
193 |
</body> |
194 |
</html> |