/[libdata]/branches/paul/admin/page_search.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

Annotation of /branches/paul/admin/page_search.phtml

Parent Directory Parent Directory | Revision Log Revision Log


Revision 67 - (hide annotations)
Thu Mar 18 19:24:54 2004 UTC (20 years, 2 months ago) by dpavlin
File size: 10279 byte(s)
updated to libdata 2.00

1 dpavlin 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>CourseLib/PageScribe Search</title>\n");
16     printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS);
17     printf("</HEAD>\n");
18    
19    
20 dpavlin 67 // 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 dpavlin 1 // 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     // If the cookie is set and access level is appropriate
53     if(isset($libsession) && $sess_access_level >= 20) {
54     ?>
55    
56     <center>
57     <table width="80%" border="1" class="backLight" cellpadding="2">
58     <tr>
59    
60     <td colspan="4" class="cellPlain" align="center">
61     CourseLib/PageScribe Search
62     </td>
63    
64     </tr>
65    
66     <tr>
67     <form method="POST" action="page_results_brief.phtml">
68     <td colspan="4" align="center">
69     <input type ="Submit" value="Search"> <input type ="Reset" value= "Reset"><br>
70     </td>
71     </tr>
72    
73     <tr>
74     <td width="40%">
75     <b>Page Type:</b>
76     </td>
77    
78     <td colspan="3" align="left">
79     <select name ="pagetype_id">
80     <option value ="0">Unselected</option>
81 dpavlin 67 <?php dropDownFieldOmit("pagetype", "pagetype", "pagetype_id", "WHERE pagetype_id > 1"); ?>
82 dpavlin 1 </select>
83     <br>
84     </td>
85     </tr>
86    
87     <tr>
88     <td>
89     <b>Date Created (YYYY-MM-DD):</b>
90     </td>
91    
92     <td colspan="3" align="left">
93     <input type = "text" name="date_created" size="10"> substrings also: e.g. 2002, 2002-12<br>
94     </td>
95     </tr>
96    
97     <tr>
98     <td>
99     <b>Date Modified (YYYY-MM-DD):</b>
100     </td>
101    
102     <td colspan="3" align="left">
103     <input type = "text" name="date_modified" size="10"> substrings also: e.g. 2002, 2002-12<br>
104     </td>
105     </tr>
106    
107     <tr>
108     <td>
109     <b>Page Creator:</b>
110     </td>
111    
112     <td colspan="3" align="left">
113     <select name ="account_created">
114     <option value ="0">Unselected</option>
115 dpavlin 67 <?php dropDownAccountOmit(" WHERE staff_id > 1"); ?>
116 dpavlin 1 </select>
117     <br>
118     </td>
119     </tr>
120    
121    
122     <tr>
123     <td>
124     <b>Last Modified By:</b>
125     </td>
126    
127     <td colspan="3" align="left">
128     <select name ="account_modified">
129     <option value ="0">Unselected</option>
130 dpavlin 67 <?php dropDownAccountOmit(" WHERE staff_id > 1"); ?>
131 dpavlin 1 </select>
132     <br>
133     </td>
134     </tr>
135    
136     <tr>
137     <td>
138     <b>Page Coordinator:</b>
139     </td>
140    
141     <td colspan="3" align="left">
142     <select name ="staff_coordinator">
143     <option value ="0">Unselected</option>
144 dpavlin 67 <?php dropDownStaffOmit(" WHERE staff_id > 1"); ?>
145 dpavlin 1 </select>
146     <br>
147     </td>
148     </tr>
149    
150     <tr>
151     <td>
152     <b>Page Co-Maintainer:</b>
153     </td>
154    
155     <td colspan="3" align="left">
156     <select name ="comaintainer_id">
157     <option value ="0">Unselected</option>
158 dpavlin 67 <?php dropDownStaffOmit(" WHERE staff_id > 1"); ?>
159 dpavlin 1 </select>
160     <br>
161     </td>
162     </tr>
163    
164    
165     <tr>
166     <td>
167     <b>Page/Course Title:</b>
168     </td>
169     <td colspan="3" align="left">
170     <input type = "text" name="page_title" size="30"><br>
171     </td>
172     </tr>
173    
174     <tr>
175     <td colspan="4" class="cellPlain" align="center">
176     CourseLib Only
177     </td>
178    
179     <tr>
180    
181     <tr>
182     <td colspan="4">
183     Note that Faculty, Staff (as course instructor), and TA/Other are OR'd
184     together in this section due to data relationship issues.
185     </td>
186    
187     <tr>
188    
189     <tr>
190     <td>
191     <b>(Faculty Name:</b>
192     </td>
193    
194     <td colspan="3" align="left">
195     <select name ="faculty_id">
196     <option value ="0">Unselected</option>
197 dpavlin 67 <?php dropDownFacultyOmit(" WHERE faculty_id > 1"); ?>
198 dpavlin 1 </select>
199     <b>OR</b><br>
200     </td>
201     </tr>
202    
203     <tr>
204     <td>
205     <b>Library Staff (as instructor):</b>
206     </td>
207    
208     <td colspan="3" align="left">
209     <select name ="pers_staff_id">
210     <option value ="0">Unselected</option>
211 dpavlin 67 <?php dropDownStaffOmit(" WHERE staff_id > 1"); ?>
212 dpavlin 1 </select>
213     <b>OR</b><br>
214     </td>
215     </tr>
216    
217     <tr>
218     <td>
219     <b>TA/Other Instructor Last Name:</b>
220     </td>
221    
222     <td colspan="3" align="left">
223     <input type="text" name="pers_lastname" size="30">
224     )<br>
225     </td>
226     </tr>
227    
228     <tr>
229     <td>
230     <b>Course Subject/Dept:</b>
231     </td>
232    
233     <td colspan="3" align="left">
234     <select name ="coursesub_id">
235     <option value ="0">Unselected</option>
236 dpavlin 67 <?php dropDownFieldOmit("coursesub", "coursesub", "coursesub_id", "WHERE coursesub_id > 1"); ?>
237 dpavlin 1 </select>
238     <br>
239     </td>
240     </tr>
241    
242     <tr>
243     <td>
244     <b>Campus:</b>
245     </td>
246    
247     <td colspan="3" align="left">
248     <select name ="campus_id">
249     <option value ="0">Unselected</option>
250 dpavlin 67 <?php dropDownFieldOmit("campus", "campus", "campus_id", "WHERE campus_id > 1"); ?>
251 dpavlin 1 </select>
252     <br>
253     </td>
254     </tr>
255    
256     <tr>
257     <td>
258     <b>Term:</b>
259     </td>
260    
261     <td align="left">
262     <select name ="term_id">
263     <option value ="0">Unselected</option>
264 dpavlin 67 <?php dropDownFieldOmit("term", "term", "term_id", "WHERE term_id > 1"); ?>
265 dpavlin 1 </select>
266     <br>
267     </td>
268    
269     <td>
270     <b>Year:</b>
271     </td>
272    
273     <td align="left">
274     <input type="text" name="course_year" size=\"4\">
275     <br>
276     </td>
277    
278     </tr>
279    
280     <tr>
281     <td>
282     <b>Course Intro Text:</b>
283     </td>
284     <td colspan="3" align="left">
285     <input type = "text" name="intro_text" size="30"><br>
286     </td>
287     </tr>
288    
289    
290     <tr>
291     <td colspan="4" class="cellPlain" align="center">
292     Output Parameters
293     </td>
294    
295     <tr>
296     <td colspan="2">
297     <b>Order results by:</b>
298     </td>
299     <td colspan="2">
300     <b>Direction:</b>
301     </td>
302    
303     </tr>
304    
305     <tr>
306     <td width="25%">
307     Page/Course Title
308     </td>
309     <td width="8%">
310     <input type="radio" name="orderby" value="p.page_title" checked>
311     </td>
312     <td width="25%">
313     Ascending
314     </td>
315     <td width="8%">
316     <input type="radio" name="orderdir" value="ASC" checked>
317     </td>
318     </tr>
319    
320     <tr>
321     <td width="25%">
322     Date Created
323     </td>
324     <td width="8%">
325     <input type="radio" name="orderby" value="p.date_created">
326     </td>
327     <td width="25%">
328     Descending
329     </td>
330     <td width="8%">
331     <input type="radio" name="orderdir" value="DESC">
332     </td>
333     </tr>
334    
335     <tr>
336     <td width="25%">
337     Date Modified
338     </td>
339     <td colspan="3">
340     <input type="radio" name="orderby" value = "p.date_modified">
341     </td>
342     </tr>
343    
344     <tr>
345     <td width="25%">
346     Coordinator & Page/Course Title
347     </td>
348     <td colspan="3">
349     <input type="radio" name="orderby" value = "s.last_name, s.first_name, p.page_title, c.course_concat">
350     </td>
351     </tr>
352    
353     <tr>
354     <td align= "center" colspan="4">
355     <br><input type ="Submit" value="Search"> <input type ="Reset" value= "Reset">
356     </form>
357     </td>
358     </tr>
359     </table>
360    
361    
362     <br><br>
363    
364    
365     <table width="80%" border="1" class="backLight" cellpadding="2">
366     <tr>
367    
368     <td colspan="4" class="cellPlain" align="center">
369     CourseLib/PageScribe Elements Searches
370     </td>
371    
372     </tr>
373    
374     <tr>
375     <td width="20%">
376     <form method="POST" action="element_results_brief.phtml">
377     <br><b>Resource ID:</b> <input type = "text" name="resource_id" size="6"><br><br>
378     </td>
379    
380     <td width="60%" colspan = "3" align="center">
381     <input type ="Submit" value="Search"> <input type ="Reset" value= "Reset"><br>
382     </td>
383     </tr>
384    
385     <tr>
386     <td>
387     <b>Location/Library:</b>
388     </td>
389    
390     <td colspan="3" align="left">
391     <select name ="location_id">
392     <option value ="0">Unselected</option>
393 dpavlin 67 <?php dropDownFieldOmit("location", "location", "location_id", "WHERE location_id > 1"); ?>
394 dpavlin 1 </select>
395     <br>
396     </td>
397     </tr>
398    
399     <tr>
400     <td>
401     <b>Service:</b>
402     </td>
403    
404     <td colspan="3" align="left">
405     <select name ="service_id">
406     <option value ="0">Unselected</option>
407 dpavlin 67 <?php dropDownFieldOmit("service", "service", "service_id", "WHERE service_id > 1"); ?>
408 dpavlin 1 </select>
409     <br>
410     </td>
411     </tr>
412    
413    
414     <tr>
415     <td>
416     <b>Staff (as elements):</b>
417     </td>
418    
419     <td colspan="3" align="left">
420     <select name ="staff_id">
421     <option value ="0">Unselected</option>
422 dpavlin 67 <?php dropDownStaffOmit(" WHERE staff_id > 1"); ?>
423 dpavlin 1 </select>
424     <br>
425     </td>
426     </tr>
427    
428     <tr>
429     <td>
430     <b>Element Text Label:</b>
431     </td>
432     <td colspan="3" align="left">
433     <input type="text" name="label" size="50">
434     </td>
435     </tr>
436    
437     <tr>
438     <td>
439     <b>Element URL (full or partial):</b>
440     </td>
441     <td colspan="3" align="left">
442     <input type="text" name="label_url" size="50">
443     </td>
444     </tr>
445    
446     <tr>
447     <td>
448     <b>Element Description:</b>
449     </td>
450     <td colspan="3" align="left">
451     <input type="text" name="element_descr" size="50">
452     </td>
453     </tr>
454    
455     <tr>
456     <td colspan="4" class="cellPlain" align="center">
457     Output Parameters
458     </td>
459    
460     <tr>
461     <td colspan="2">
462     <b>Order results by:</b>
463     </td>
464     <td colspan="2">
465     <b>Direction:</b>
466     </td>
467    
468     </tr>
469    
470     <tr>
471     <td width="25%">
472     Page/Course Title
473     </td>
474     <td width="8%">
475     <input type="radio" name="orderby" value="p.page_title" checked>
476     </td>
477     <td width="25%">
478     Ascending
479     </td>
480     <td width="8%">
481     <input type="radio" name="orderdir" value="ASC" checked>
482     </td>
483     </tr>
484    
485     <tr>
486     <td width="25%">
487     Date Created
488     </td>
489     <td width="8%">
490     <input type="radio" name="orderby" value="p.date_created">
491     </td>
492     <td width="25%">
493     Descending
494     </td>
495     <td width="8%">
496     <input type="radio" name="orderdir" value="DESC">
497     </td>
498     </tr>
499    
500     <tr>
501     <td width="25%">
502     Date Modified
503     </td>
504     <td colspan="3">
505     <input type="radio" name="orderby" value = "p.date_modified">
506     </td>
507     </tr>
508    
509     <tr>
510     <td width="25%">
511     Coordinator & Page/Course Title
512     </td>
513     <td colspan="3">
514     <input type="radio" name="orderby" value = "t.staff_account, p.page_title, c.course_concat">
515     </td>
516     </tr>
517    
518     <tr>
519     <td align= "center" colspan="4">
520     <br><input type ="Submit" value="Search"> <input type ="Reset" value= "Reset">
521     </form>
522     </td>
523     </tr>
524     </table>
525    
526    
527     <?php
528    
529     // Link to return to admin console
530     adminReturn($sess_access_level);
531    
532     } // logged in
533    
534     // No access page
535     else require_once ($GLOBAL_NO_ACCESS);
536    
537    
538     // Page footer
539     require_once ($GLOBAL_ADMIN_FOOTER);
540     ?>
541    
542     </body>
543     </html>

  ViewVC Help
Powered by ViewVC 1.1.26