/[libdata]/trunk/rqs.phtml
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /trunk/rqs.phtml

Parent Directory Parent Directory | Revision Log Revision Log


Revision 72 - (show annotations)
Thu Mar 18 20:33:37 2004 UTC (17 years, 4 months ago) by dpavlin
File size: 14291 byte(s)
changes made in version 2.00

1 <?php
2 // Load globals
3 require_once ("global_vars.php");
4
5
6 // Includes
7 require_once ("db_connect.php");
8 require_once ("public_controls.php");
9
10
11 // HTML header
12 printf("<html>\n");
13 printf("<head>\n");
14 printf("<title>Research QuickStart: Subject Page</title>\n");
15 printf("<link rel=\"stylesheet\" href=\"libdata.css\" type=\"text/css\">\n");
16 printf("</head>\n");
17 printf("<body marginheight = \"0\" marginwidth = \"0\" leftmargin = \"0\" topmargin = \"0\">\n");
18
19 // if printer friendly version, omit the standard header
20 if ($pf == 1) {
21 printf("<h3>Research QuickStart</h3>\n");
22 }
23
24 else {
25 // Page header
26 require_once ("header.phtml");
27 }
28
29 // Initialize
30 if ($core < 1) $core = 0;
31
32
33 /****************************
34 ** Increment subject stats **
35 ****************************/
36
37 // Initialize
38 $subject_id = (int) $subject_id;
39 $exists = 0;
40 $exists = existsRow("subject", "subject_id", $subject_id);
41
42 // If this subject is valid, increment stats
43 if ($subject_id > 1 && $exists == 1) subLoadStats($subject_id);
44
45
46 /***********************************
47 ** Generate the table of contents **
48 ***********************************/
49
50 // Determine if there are related PageScribe or RQS pages
51 $other_ps = existsRow("sub_page", "subject_id", $subject_id);
52 $other_rqs = existsRow("sub_othersub", "subject_id", $subject_id);
53
54
55 // if printer friendly version don't print the TOC
56 if ($pf != 1) {
57 printf("<table border=\"0\" width=\"100%%\" cellspacing=\"0\" cellpadding=\"0\"><tr>\n");
58 printf("<td width=\"3\" bgcolor=\"#000000\"></td><td valign=\"top\" width=\"200\" class=\"backLight\">\n");
59 printf("<table cellpadding=\"5\" border=\"0\"><tr><td>\n");
60 printf("<p class=\"small\"><b>Contents of this page:</b></p>\n");
61
62 // Generate the list
63 $sql = "SELECT DISTINCT mi.masterinfotype_id, mi.masterinfotype, i.infotype_id, i.infotype FROM
64 res_sub_infotype rsi,
65 infotype i,
66 masterinfotype mi
67
68 WHERE
69 rsi.subject_id = "
70 . $subject_id
71 . " AND mi.masterinfotype_id = i.masterinfotype_id AND
72 rsi.infotype_id = i.infotype_id";
73
74 //if core selected, only print out the core TOC
75 if ($core == "1") {
76 $sql .= " AND rsi.highlighted = '1'";
77 }
78
79 $sql .= " ORDER BY mi.masterinfotype, i.infotype";
80 $rs = xx_tryquery($sql);
81 $rows = xx_num_rows($rs);
82
83 // initialize
84 $last_masterinfotype_id = 0;
85 $rowcount = 0;
86
87 while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
88
89 // Fetch information types for this subject
90 $infotype_id = $row["infotype_id"];
91 $infotype = $row["infotype"];
92 $masterinfotype_id = $row["masterinfotype_id"];
93 $masterinfotype = $row["masterinfotype"];
94
95 if ($last_masterinfotype_id == 0 || ($last_masterinfotype_id != $masterinfotype_id)) {
96 printf("</ul><b><span class=\"small\"><a href=\"rqs.phtml?subject_id=%d#m%d\">%s</a></b></span><br>\n", $subject_id, $masterinfotype_id, $masterinfotype);
97 printf("<ul>\n");
98 }
99
100 printf("<li><span class=\"small\"><b><a href=\"#i%d\">%s</a></b></span></li>\n", $infotype_id, $infotype);
101
102 // Swap & increment
103 $last_masterinfotype_id = $masterinfotype_id;
104 $rowcount++;
105
106 };
107
108 printf("</ul><span class=\"small\"><b><a href=\"rqs.phtml?subject_id=%d#lib\">Library Information</a></b></span><br>\n", $subject_id);
109 printf("</ul>\n");
110
111 if ($other_ps || $other_rqs) printf("<p class=\"small\"><b><a href=\"rqs.phtml?subject_id=%d#related\">Related Pages</a></b></p>\n", $subject_id);
112
113 printf("<p class=\"small\"><b><a href=\"rqs.phtml?subject_id=$subject_id&pf=1&core=$core\">Printer-friendly version of this page</a></b></p>\n");
114 printf("</td></tr></table>\n");
115 printf("</td><td width=\"3\" class=\"backLight\">&nbsp;</td><td valign=\"top\">\n");
116
117 }
118
119 /**********************************
120 ** Display user's subject choice **
121 **********************************/
122
123 $sql = "SELECT subject, subject_descr FROM subject WHERE subject_id = "
124 . $subject_id;
125
126 $rs = xx_tryquery($sql);
127 $row = xx_fetch_array ($rs, xx_ASSOC);
128 $subject = $row["subject"];
129 $subject_descr = $row["subject_descr"];
130
131 printf("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%%\"><tr>\n");
132
133 // Remove the subject cell bgcolor if printer-friendly
134 if ($pf == 1) {
135 printf("<td>\n");
136 }
137
138 else {
139 printf("<td class=\"backLight\" valign=\"top\">\n");
140 }
141
142 printf("<table cellpadding=\"3\"><tr><td>\n");
143 printf("<p><span class=\"bigDark\">Selected Resources for: %s</span>", $subject);
144
145 if ($core == 1) {
146 printf("<span class=\"small\">Display all <a href=\"rqs.phtml?subject_id=$subject_id\">resources</a></span>).</p>\n");
147 }
148
149 else {
150 printf(" (<span class=\"small\">Display only the <a href=\"rqs.phtml?core=1&subject_id=%d\">highlighted/core resources</a></span>).</p>\n", $subject_id);
151 }
152 printf("</td></tr></table></td></tr></table>\n");
153
154 /************************
155 /* Table for main body **
156 ************************/
157
158 printf("<table cellpadding=\"10\" border=\"0\"><tr><td valign=\"top\">\n");
159 printf("<p class=\"small\"><b>Subject Description:</b> %s</p>", $subject_descr);
160 printf("</td></tr>");
161
162 /***************************
163 ** Generate the resources **
164 ***************************/
165
166 printf("<tr><td>\n");
167
168 $sql = "SELECT
169 rsi.description,
170 m.masterinfotype,
171 m.masterinfotype_id,
172 i.infotype,
173 i.infotype_id,
174 r.resource_id,
175 r.title,
176 r.author,
177 r.annotation,
178 r.url,
179 r.call_no,
180 r.coverage_detail,
181 r.cat_num,
182 r.guide_url,
183 r.resource_status,
184 r.resource_message,
185 v.vendor_status,
186 v.vendor_message
187 FROM res_sub_infotype rsi,
188 infotype i, masterinfotype m, resource r
189 LEFT JOIN vendor v on r.vendor_id = v.vendor_id
190 WHERE
191 rsi.subject_id = "
192 . $subject_id
193 . " AND rsi.masterinfotype_id = m.masterinfotype_id AND";
194 // if core selected, only print out the core resources selected for this subject
195 if ($core == "1") {
196 $sql .= " rsi.highlighted = 1 AND";
197 }
198 $sql .= " rsi.infotype_id = i.infotype_id AND
199 rsi.masterinfotype_id = m.masterinfotype_id AND
200 rsi.resource_id = r.resource_id
201 ORDER BY m.masterinfotype, i.infotype, r.title";
202
203 $rs = xx_tryquery($sql);
204
205 while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
206
207 // Fetch information types for this subject
208 $masterinfotype = $row["masterinfotype"];
209 $masterinfotype_id = $row["masterinfotype_id"];
210 $infotype = $row["infotype"];
211 $infotype_id = $row["infotype_id"];
212 $title = $row["title"];
213 $author = $row["author"];
214 $annotation = $row["annotation"];
215 $resource_id = $row["resource_id"];
216 $url = $row["url"];
217 $cat_num = $row["cat_num"];
218 $call_no = $row["call_no"];
219 $coverage = $row["coverage_detail"];
220 $description = $row["description"];
221
222 $guide_url = $row["guide_url"];
223 $resource_message = $row["resource_message"];
224 $resource_status = $row["resource_status"];
225 $vendor_message = $row["vendor_message"];
226 $vendor_status = $row["vendor_status"];
227
228 if (strlen($description) > 0) $annotation = $description;
229
230 // Header info
231 if ($last_m != $masterinfotype) printf("<a name=\"m%d\"><h3>%s</h3></a>", $masterinfotype_id, $masterinfotype);
232 if ($last_i != $infotype) printf("<p>&nbsp;&nbsp;&nbsp;&nbsp;<a name=\"i%d\"><b><i>%s</i></b></a></p>", $infotype_id, $infotype);
233
234 printf("<table><tr><td width=\"20\">&nbsp;</td>\n");
235 printf("<td valign=\"top\"><img src=\"images/bullet.gif\" alt=\"\"></td>\n");
236 printf("<td>\n");
237
238 // Display the resource
239 if (strlen($url) > 0 ) {
240 printf("<b><a href=\"%s\">%s</a></b>\n", $url, $title);
241
242 }
243 else {
244 printf("<b>%s</b>", $title);
245 }
246
247 // Lookup features
248 $f_sql = "SELECT * FROM res_feature rf, feature f
249 WHERE rf.resource_id = "
250 . $resource_id
251 . " AND rf.feature_id = f.feature_id";
252
253 $f_rs = xx_tryquery($f_sql);
254
255
256 while ($f_row = xx_fetch_array ($f_rs, xx_ASSOC)) {
257 $image_path = $f_row["image_path"];
258 $image_alt = $f_row["image_alt"];
259 printf("<img src=\"%s\" alt=\"%s\">&nbsp;", $image_path, $image_alt);
260 }
261
262 // If print-friendly display the URL
263 if (($url) && ($pf == 1)) {
264 printf("<br>%s\n", $url);
265 }
266
267 // Handle down/alert messages
268 if ($vendor_status > 0 || $resource_status > 0) {
269
270 printf("<br><img src =\"images/chain.jpg\" alt=\"Resource Temporarily Unavailable\">\n");
271 printf("<span class=\"error\">\n");
272 if (strlen($vendor_message) > 1) printf("%s<br>\n", $vendor_message);
273 else if (strlen($resource_message) > 1) printf("%s<br>\n", $resource_message);
274 printf("</span>\n");
275 }
276
277 // Display other items
278 if (strlen($coverage) > 0) printf("<br>&nbsp;&nbsp;&nbsp;&nbsp;<i>%s</i>", $coverage);
279 if (strlen($annotation) > 0) printf("<br>%s", $annotation);
280 if (strlen($call_no) > 0) printf("<br><b>Location</b>: %s", $call_no);
281
282 // Link to library holdings if something was supplied for catalog number
283 if (strlen($cat_num) > 0)
284 printf("<BR><a href=\"yourlibrarycatalog.here.edu\">Check Catalog</a>", $cat_num);
285
286 // Swap variables
287 $last_m = $masterinfotype;
288 $last_i = $infotype;
289 printf("</td></tr></table>\n");
290 }
291
292 printf( "<p><hr noshade=\"noshade\" width=\"75%%\" align=\"left\"></p>\n");
293
294 /*****************************
295 ** Primary subject location **
296 *****************************/
297
298 printf("<p><span class=\"bigDark\"><a name=\"lib\">Library Information</a></span></p>\n");
299
300 // Generate the sql
301 $sql = "SELECT *
302 FROM subject, location
303 WHERE subject.subject_id = " . $subject_id . " AND
304 subject.sublocation_id = location.location_id";
305
306 // Fetch the values
307 $rs = xx_tryquery($sql);
308 $row = xx_fetch_array ($rs, xx_ASSOC);
309 $location_id = $row["location_id"];
310 $location = $row["location"];
311 $location_descr = $row["location_descr"];
312 $campus = $row["campus"];
313 $address1 = $row["address1"];
314 $address2 = $row["address2"];
315 $address3 = $row["address3"];
316 $address4 = $row["address4"];
317 $telephone = $row["telephone"];
318 $mainURL = $row["mainURL"];
319 $referenceURL = $row["referenceURL"];
320 $mapURL = $row["mapURL"];
321 $hoursURL = $row["hoursURL"];
322
323 if ($location_id > 1) {
324
325 printf("<p><span class=\"bigDark\">Primary Subject Location(s)</span></p>\n");
326
327 if (strlen($mainURL) > 1) printf("<a href=\"%s\"><b>%s</b></a><br>\n", $mainURL, $location);
328 else printf("<b>%s</b><br>\n", $location);
329
330 if (strlen($location_descr) > 1) printf("%s<br>\n", $location_descr);
331 if (strlen($campus) > 1) printf("<b>Campus:</b> %s<br>\n", $campus);
332 if (strlen($address1) > 1) printf("<b>Address Line 1:</b> %s<br>\n", $address1);
333 if (strlen($address2) > 1) printf("<b>Address Line 2:</b> %s<br>\n", $address2);
334 if (strlen($address3) > 1) printf("<b>Address Line 3:</b> %s<br>\n", $address3);
335 if (strlen($address4) > 1) printf("<b>Address Line 4:</b> %s<br>\n", $address4);
336 if (strlen($telephone) > 1) printf("<b>Telephone:</b> %s<br>\n", $telephone);
337 if (strlen($mainURL) > 1) printf("<b>Main URL:</b> <a href= \"%s\">%s</a><br>\n", $mainURL, $mainURL);
338 if (strlen($referenceURL) > 1) printf("<b>Reference URL:</b> <a href=\"%s\">%s</a><br>\n", $referenceURL, $referenceURL);
339 if (strlen($mapURL) > 1) printf("<b>Map URL:</b> <a href=\"%s\">%s</a><br>\n", $mapURL, $mapURL);
340 if (strlen($hoursURL) > 1) printf("<b>Hours URL:</b> <a href= \"%s\">%s</a><br>\n", $hoursURL, $hoursURL);
341 }
342
343 printf("<br>\n");
344
345 /**********************************
346 ** Secondary subject location(s) **
347 **********************************/
348
349 // Generate the sql
350 $sql = "SELECT *
351 FROM sub_loc, location
352 WHERE sub_loc.subject_id = " . $subject_id . " AND
353 sub_loc.location_id = location.location_id";
354
355 // Fetch the values
356 $rs = xx_tryquery($sql);
357
358 // Initialize
359 $rowcount = 0;
360
361 while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
362
363 $location_id = $row["location_id"];
364 $location = $row["location"];
365 $location_descr = $row["location_descr"];
366 $campus = $row["campus"];
367 $address1 = $row["address1"];
368 $address2 = $row["address2"];
369 $address3 = $row["address3"];
370 $address4 = $row["address4"];
371 $telephone = $row["telephone"];
372 $mainURL = $row["mainURL"];
373 $referenceURL = $row["referenceURL"];
374 $mapURL = $row["mapURL"];
375 $hoursURL = $row["hoursURL"];
376
377 // Increment
378 $rowcount++;
379
380 // Display the values if present
381 if ($rowcount == 1) printf("<p><span class=\"bigDark\">Secondary Subject Location(s)</span></p>\n");
382
383 if (strlen($mainURL) > 1) printf("<a href=\"%s\"><b>%s</b></a><br>\n", $mainURL, $location);
384 else printf("<b>%s</b><br>\n", $location);
385
386 if (strlen($location_descr) > 1) printf("%s<br>\n", $location_descr);
387 if (strlen($campus) > 1) printf("<b>Campus:</b> %s<br>\n", $campus);
388 if (strlen($address1) > 1) printf("<b>Address Line 1:</b> %s<br>\n", $address1);
389 if (strlen($address2) > 1) printf("<b>Address Line 2:</b> %s<br>\n", $address2);
390 if (strlen($address3) > 1) printf("<b>Address Line 3:</b> %s<br>\n", $address3);
391 if (strlen($address4) > 1) printf("<b>Address Line 4:</b> %s<br>\n", $address4);
392 if (strlen($telephone) > 1) printf("<b>Telephone:</b> %s<br>\n", $telephone);
393 if (strlen($mainURL) > 1) printf("<b>Main URL:</b> <a href= \"%s\">%s</a><br>\n", $mainURL, $mainURL);
394 if (strlen($referenceURL) > 1) printf("<b>Reference URL:</b> <a href=\"%s\">%s</a><br>\n", $referenceURL, $referenceURL);
395 if (strlen($mapURL) > 1) printf("<b>Map URL:</b> <a href=\"%s\">%s</a><br>\n", $mapURL, $mapURL);
396 if (strlen($hoursURL) > 1) printf("<b>Hours URL:</b> <a href= \"%s\">%s</a><br>\n", $hoursURL, $hoursURL);
397
398 printf("<br>");
399
400 }
401 printf("</td></tr>\n");
402
403
404 printf("<tr>\n");
405 printf("<td align=\"left\">\n");
406
407 if ($other_ps || $other_rqs) printf("<a name=\"related\"></a>\n");
408
409 /****************************************************************
410 ** Hunt for related subject pages & display them if they exist **
411 ****************************************************************/
412 $othersubs = existsRow("sub_othersub", "subject_id", $subject_id);
413
414 if ($othersubs > 0) {
415 printf("<table cellpadding=\"10\"><tr><td bgcolor=\"#dcdcdc\" class=\"small\"><h4>Related RQS Pages</h4>\n");
416 displayRelatedSubjects($subject_id);
417 print "</td></tr></table><br>\n";
418 }
419
420
421 /*******************************************************************
422 ** Hunt for related PageScribe pages & display them if they exist **
423 *******************************************************************/
424 $pages = existsRow("sub_page", "subject_id", $subject_id);
425
426 if ($pages > 0) {
427 printf("<table cellpadding=\"10\"><tr><td bgcolor=\"#dcdcdc\" class=\"small\"><h4>Related PageScribe Pages</h4>\n");
428 displayRelatedPages($subject_id);
429 print "</td></tr></table>\n";
430 }
431
432 // main body table
433 printf("</td></tr></table>\n");
434
435 // outer table
436 printf("</td></tr></table>\n");
437
438 // Page footer
439 require_once ("footer.phtml");
440 ?>
441
442 </body>
443 </html>

  ViewVC Help
Powered by ViewVC 1.1.26