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