/[libdata]/trunk/admin/include/forms.php
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/admin/include/forms.php

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1 - (show annotations)
Fri Dec 5 18:34:18 2003 UTC (20 years, 4 months ago) by dpavlin
File size: 109452 byte(s) 
Initial revision
1 <?php
2 /**********************************************************
3 Function Library: forms.php
4 Original Author: Paul Bramscher <brams006@tc.umn.edu>
5 Last Modified: 11.06.2003 by Paul Bramscher
6 ***********************************************************
7 Comments:
8 Functions here include most data-entry forms. Note that
9 the same form controls both "new" and "edit" functionality.
10 The standard convention used is to call a form with a
11 zero "0" if it is a new record, or a positive integer
12 corresponding to the primary key of the row to edit an
13 existing record.
14
15 Assignment-type forms are those which build a composite
16 primary key to a bridging table. These allow for both the
17 creation of new associations and the deletion of existing
18 associations, depending on which transaction the user
19 selects. Boxes are mutually exclusive, with available
20 options in one box, selected options in another. These
21 combo boxes allow multiple selections (or deselections).
22 ***********************************************************
23 Table of Contents:
24 formAssignLibunitStaff
25 formAssignResFeature
26 formAssignResLoc
27 formAssignResMastersubject
28 formAssignServLoc
29 formAssignServServtype
30 formAssignStaffLibunit
31 formAssignStaffSub
32 formAssignSubCoursesub
33 formAssignSubLoc
34 formAssignSubMaster
35 formAssignSubOtherSub
36 formAssignSubPage
37 formAssignSubStaff
38 formEditSingleField
39 formCoursesub
40 formFaculty
41 formFeature
42 formInfotype
43 formLibunit
44 formLocation
45 formNewSingleField
46 formPassword
47 formResource
48 formService
49 formStaff
50 formStyle
51 formSubject
52 **********************************************************/
53
54
55 /**********************************************************
56 Function: formAssignResFeature
57 Author: Paul Bramscher
58 Last Modified: 07.03.2003
59 ***********************************************************
60 Purpose:
61 Draws an HTML combo box with multiple selection capability
62 to assign features to the supplied resource id.
63 **********************************************************/
64 function formAssignResFeature($con, $resource_id){
65
66 // Table definition
67 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
68
69 // Form of available features to select
70 printf("<form method = \"POST\" action = \"assign.phtml#ResFea\" >");
71 printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
72 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResFeature\" >");
73
74 // Omit the '(N/A)' feature
75 $omit_string = "WHERE feature_id > 1";
76
77 // Omit any pre-selected features in res_feature
78 $in_string = getNotIn($con, "feature_id", "resource_id", $resource_id, "res_feature");
79 if (strlen($in_string) > 0) $omit_string .= " AND feature_id NOT IN " . $in_string;
80
81 // Draw the combo box
82 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
83 printf("Assign Features");
84 printf("</td></tr>\n");
85 printf("<tr><td valign = \"top\" >\n");
86 printf("<br><strong>Available Features(s):<br></strong>\n");
87 printf("<select name = \"feature_id_array[]\" multiple size = \"5\" >");
88 dropDownFieldOmit($con, "feature", "feature", "feature_id", $omit_string);
89 printf("</select><br><br>");
90
91 // Close things
92 printf("<center>");
93 printf("<input type = \"Submit\" value = \" >> \" >");
94 printf("</form>");
95 printf("</center>");
96 printf("</td>");
97
98 // Form of current features to deselect
99 printf("<td valign = \"top\" >\n");
100 printf("<form method = \"POST\" action = \"delete.phtml\" >");
101 printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
102 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResFeature\" >");
103 printf("<br><strong>Selected feature(s):</strong><br>\n");
104 printf("<select name =\"key_list_array[]\" multiple size = 5>");
105
106 $sql = "SELECT f.feature, f.feature_id FROM
107 feature f,
108 res_feature rf,
109 resource r
110 WHERE
111 r.resource_id = " . $resource_id . " AND
112 rf.resource_id = r.resource_id AND
113 rf.feature_id = f.feature_id ORDER BY feature";
114
115 // Fetch the current selections
116 $rs = mysql_query($sql, $con);
117 while ($row = mysql_fetch_array ($rs)) {
118 $feature = $row["feature"];
119 $feature_id = $row["feature_id"];
120 printf("<option value = \"%s\">%s</option>", $feature_id, $feature);
121 }
122
123 // Close things
124 printf("</select><br><br>");
125 printf("<center>");
126 printf("<input type = \"Submit\" value =\" << \">");
127 printf("</center>");
128 printf("</form>");
129 printf("</td></tr>");
130
131 // Close off table
132 printf("</td></tr></table>");
133 }
134
135
136 /**********************************************************
137 Function: formAssignResLoc
138 Author: Paul Bramscher
139 Last Modified: 07.03.2003
140 ***********************************************************
141 Purpose:
142 Draws an HTML combo box with multiple selection capability
143 to assign locations to the supplied resource id.
144 **********************************************************/
145 function formAssignResLoc($con, $resource_id){
146
147 // Table definition
148 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
149
150 // Form of available locations to select
151 printf("<form method = \"POST\" action = \"assign.phtml#ResLoc\" >");
152 printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
153 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResLoc\" >");
154
155 // Omit the '(N/A)' location
156 $omit_string = "WHERE location_id > 1";
157
158 // Omit any pre-selected locations in res_loc
159 $in_string = getNotIn($con, "location_id", "resource_id", $resource_id, "res_loc");
160 if (strlen($in_string) > 0) $omit_string .= " AND location_id NOT IN " . $in_string;
161
162 // Draw the combo box
163 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
164 printf("Assign Locations");
165 printf("</td></tr>\n");
166 printf("<tr><td valign = \"top\" >\n");
167 printf("<br><strong>Available Location(s):<br></strong>\n");
168 printf("<select name = \"location_id_array[]\" multiple size = \"5\" >");
169 dropDownFieldOmit($con, "location", "location", "location_id", $omit_string);
170 printf("</select><br><br>");
171
172 // Close things
173 printf("<center>");
174 printf("<input type = \"Submit\" value = \" >> \" >");
175 printf("</center>");
176 printf("</form>");
177 printf("</td>");
178
179 // Current locations to deselect
180 printf("<td valign = \"top\" >\n");
181 printf("<form method = \"POST\" action = \"delete.phtml\" >");
182 printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
183 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResLoc\" >");
184 printf("<br><strong>Selected Location(s):</strong><br>\n");
185 printf("<select name =\"key_list_array[]\" multiple size = 5>");
186
187 $sql = "SELECT l.location, l.location_id FROM
188 location l,
189 res_loc rl,
190 resource r
191 WHERE
192 r.resource_id = " . $resource_id . " AND
193 rl.resource_id = r.resource_id AND
194 rl.location_id = l.location_id ORDER BY location";
195
196 // Fetch the values
197 $rs = mysql_query($sql, $con);
198 while ($row = mysql_fetch_array ($rs)) {
199 $location = $row["location"];
200 $location_id = $row["location_id"];
201 printf("<option value = \"%s\">%s</option>", $location_id, $location);
202 }
203
204 // Close things
205 printf("</select><br><br>");
206 printf("<center>");
207 printf("<input type = \"Submit\" value =\" << \">");
208 printf("</center>");
209 printf("</form>");
210 printf("</td></tr>");
211
212 // Close off table
213 printf("</td></tr></table>");
214 }
215
216
217 /**********************************************************
218 Function: formAssignResMastersubject
219 Author: Paul Bramscher
220 Last Modified: 07.03.2003
221 ***********************************************************
222 Purpose:
223 Draws an HTML combo box with multiple selection capability
224 to assign master subjects to the supplied resource id.
225 **********************************************************/
226 function formAssignResMastersubject($con, $resource_id){
227
228 // Table definition
229 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
230
231 // Form of available master subjects to select
232 printf("<form method = \"POST\" action = \"assign.phtml#ResMaster\" >");
233 printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
234 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignResMastersubject\" >");
235
236 // Omit the '(N/A)' mastersubjects
237 $omit_string = "WHERE mastersubject_id > 2";
238
239 // Omit any pre-selected locations in res_mastersubject
240 $in_string = getNotIn($con, "mastersubject_id", "resource_id", $resource_id, "res_mastersubject");
241 if (strlen($in_string) > 0) $omit_string .= " AND mastersubject_id NOT IN " . $in_string;
242
243 // Draw the combo box
244 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
245 printf("Assign Master Subjects");
246 printf("</td></tr>\n");
247 printf("<tr><td valign = \"top\" >\n");
248 printf("<br><strong>Available Mastersubjects(s):<br></strong>\n");
249 printf("<select name = \"mastersubject_id_array[]\" multiple size = \"5\" >");
250 dropDownFieldOmit($con, "mastersubject", "mastersubject", "mastersubject_id", $omit_string);
251 printf("</select><br><br>");
252
253 // Close things
254 printf("<center>");
255 printf("<input type = \"Submit\" value = \" >> \" >");
256 printf("</center>");
257 printf("</form>");
258 printf("</td>");
259
260 // Current master subjects to deselect
261 printf("<td valign = \"top\" >\n");
262 printf("<form method = \"POST\" action = \"delete.phtml\" >");
263 printf("<input type = \"Hidden\" name = \"resource_id\" value = \"%d\" >", $resource_id);
264 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteResMastersubject\" >");
265 printf("<br><strong>Selected Mastersubjects(s):</strong><br>\n");
266 printf("<select name =\"key_list_array[]\" multiple size = 5>");
267
268 $sql = "SELECT m.mastersubject, m.mastersubject_id FROM
269 mastersubject m,
270 res_mastersubject rm,
271 resource r
272 WHERE
273 r.resource_id = " . $resource_id . " AND
274 rm.resource_id = r.resource_id AND
275 rm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";
276
277 // Fetch the values
278 $rs = mysql_query($sql, $con);
279 while ($row = mysql_fetch_array ($rs)) {
280 $mastersubject = $row["mastersubject"];
281 $mastersubject_id = $row["mastersubject_id"];
282 printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject);
283 }
284
285 // Close things
286 printf("</select><br><br>");
287 printf("<center>");
288 printf("<input type = \"Submit\" value =\" << \">");
289 printf("</center>");
290 printf("</form>");
291 printf("</td></tr>");
292
293 // Close off table
294 printf("</td></tr></table>");
295 }
296
297
298 /**********************************************************
299 Function: formAssignServLoc
300 Author: Paul Bramscher
301 Last Modified: 07.02.2003
302 ***********************************************************
303 Purpose:
304 Draws an HTML combo box with multiple selection capability
305 to assign locations to the supplied service id.
306 **********************************************************/
307 function formAssignServLoc($con, $service_id){
308
309 // Table definition
310 printf("<br><br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">");
311
312 // Form of available locations to select
313 printf("<form method = \"POST\" action = \"assign.phtml\" >");
314 printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
315 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignServLoc\" >");
316
317 // Box header
318 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
319 printf("Assign Service Locations");
320 printf("</td></tr>\n");
321
322 // Omit the '(N/A)' location
323 $omit_string = "WHERE location_id > 1";
324
325 // Omit any pre-selected locations in service_location
326 $in_string = getNotIn($con, "location_id", "service_id", $service_id, "serv_loc");
327 if (strlen($in_string) > 0) $omit_string .= " AND location_id NOT IN " . $in_string;
328
329 // Draw the combo box
330 printf("<tr><td valign = \"top\" >\n");
331 printf("<br><strong>Available Location(s):<br></strong>\n");
332 printf("<select name = \"location_id_array[]\" multiple size = \"5\" >");
333 dropDownFieldOmit($con, "location", "location", "location_id", $omit_string);
334 printf("</select><br><br>");
335
336 // Close things
337 printf("<center>");
338 printf("<input type = \"Submit\" value = \" >> \" >");
339 printf("</form>");
340 printf("</center>");
341 printf("</td>");
342
343 // Current locations to deselect
344 printf("<td valign = \"top\" >\n");
345 printf("<form method = \"POST\" action = \"delete.phtml\" >");
346 printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
347 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteServLoc\" >");
348 printf("<br><strong>Selected Location(s):</strong><br>\n");
349 printf("<select name =\"key_list_array[]\" multiple size = 5>");
350
351 $sql = "SELECT l.location, l.location_id FROM
352 location l,
353 serv_loc sl,
354 service s
355 WHERE
356 s.service_id = " . $service_id . " AND
357 sl.service_id = s.service_id AND
358 sl.location_id = l.location_id ORDER BY location";
359
360 // Fetch the values
361 $rs = mysql_query($sql, $con);
362 while ($row = mysql_fetch_array ($rs)) {
363 $location = $row["location"];
364 $location_id = $row["location_id"];
365 printf("<option value = \"%s\">%s</option>", $location_id, $location);
366 }
367
368 // Close things
369 printf("</select><br><br>");
370 printf("<center>");
371 printf("<input type = \"Submit\" value =\" << \">");
372 printf("</center>");
373 printf("</form>");
374 printf("</td></tr>");
375
376 // Close off the table
377 printf("</td></tr></table>");
378 }
379
380
381 /**********************************************************
382 Function: formAssignServServtype
383 Author: Paul Bramscher
384 Last Modified: 07.02.2003
385 ***********************************************************
386 Purpose:
387 Draws an HTML combo box with multiple selection capability
388 to assign service types to the supplied service id.
389 **********************************************************/
390 function formAssignServServtype($con, $service_id){
391
392 // Table definition
393 printf("<br><br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">");
394
395 // Form of available service types to select
396 printf("<form method = \"POST\" action = \"assign.phtml\" >");
397 printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
398 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignServServtype\" >");
399
400 // Box header
401 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
402 printf("Assign Service Types");
403 printf("</td></tr>\n");
404
405 // Omit the '(N/A)' type
406 $omit_string = "WHERE servicetype_id > 1";
407
408 // Omit any pre-selected servive types in serv_servtype
409 $in_string = getNotIn($con, "servicetype_id", "service_id", $service_id, "serv_servtype");
410 if (strlen($in_string) > 0) $omit_string .= " AND servicetype_id NOT IN " . $in_string;
411
412 // Draw the combo box
413 printf("<tr><td valign = \"top\" >\n");
414 printf("<br><strong>Available Service Types(s):<br></strong>\n");
415 printf("<select name = \"servicetype_id_array[]\" multiple size = \"5\" >");
416 dropDownFieldOmit($con, "servicetype", "servicetype", "servicetype_id", $omit_string);
417 printf("</select><br><br>");
418
419 // Close things
420 printf("<center>");
421 printf("<input type = \"Submit\" value = \" >> \" >");
422 printf("</form>");
423 printf("</center>");
424 printf("</td>");
425
426 // Current servicetypes to deselect
427 printf("<td valign = \"top\" >\n");
428 printf("<form method = \"POST\" action = \"delete.phtml\" >");
429 printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" >", $service_id);
430 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteServServtype\" >");
431 printf("<br><strong>Selected Service Types(s):</strong><br>\n");
432 printf("<select name =\"key_list_array[]\" multiple size = 5>");
433
434 $sql = "SELECT t.servicetype, t.servicetype_id FROM
435 servicetype t,
436 serv_servtype st,
437 service s
438 WHERE
439 s.service_id = " . $service_id . " AND
440 st.service_id = s.service_id AND
441 st.servicetype_id = t.servicetype_id ORDER BY servicetype";
442
443 // Fetch the values
444 $rs = mysql_query($sql, $con);
445 while ($row = mysql_fetch_array ($rs)) {
446 $servicetype = $row["servicetype"];
447 $servicetype_id = $row["servicetype_id"];
448 printf("<option value = \"%s\">%s</option>", $servicetype_id, $servicetype);
449 }
450
451 // Close things
452 printf("</select><br><br>");
453 printf("<center>");
454 printf("<input type = \"Submit\" value =\" << \">");
455 printf("</center>");
456 printf("</form>");
457 printf("</td></tr>");
458
459 // Close off the table
460 printf("</td></tr></table>");
461 }
462
463
464 /**********************************************************
465 Function: formAssignSubCoursesub
466 Author: Paul Bramscher
467 Last Modified: 06.26.2003
468 ***********************************************************
469 Purpose:
470 Draws an HTML combo box with multiple selection capability
471 to assign course subjects (with cip codes) to the supplied
472 subject id.
473 **********************************************************/
474 function formAssignSubCoursesub($con, $subject_id){
475
476 // Table definition
477 printf("<br><br>\n");
478 printf("<table width=\"90%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\" >");
479
480 // Form of available course subjects to select
481 printf("<form method = \"POST\" action = \"assign.phtml\" >");
482 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
483 printf("Map to Course Subjects / CIP Codes");
484 printf("</td></tr>\n");
485
486 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
487 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubCoursesub\" >");
488
489 // Omit the '(N/A)' course subject
490 $omit_string = "WHERE coursesub_id > 1";
491
492 // Omit any pre-selected locations in sub_coursesub
493 $in_string = getNotIn($con, "coursesub_id", "subject_id", $subject_id, "sub_coursesub");
494 if (strlen($in_string) > 0) $omit_string .= " AND coursesub_id NOT IN " . $in_string;
495
496 // Draw the combo box
497 printf("<tr><td valign = \"top\" >\n");
498 printf("<br><b>Available Course Subjects(s):<br></b>\n");
499 printf("<select name = \"coursesub_id_array[]\" multiple size = \"20\" >");
500 dropDownCoursesubOmit($con, $omit_string);
501 printf("</select><br><br>");
502
503 // Close things
504 printf("<center>");
505 printf("<input type = \"Submit\" value = \" >> \" >");
506 printf("</form>");
507 printf("</center>");
508 printf("</td>");
509
510 // Current coursesubs to deselect
511 printf("<td valign = \"top\" >\n");
512 printf("<form method = \"POST\" action = \"delete.phtml\" >");
513 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
514 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubCoursesub\" >");
515 printf("<br><b>Selected Course Subject(s):</b><br>\n");
516 printf("<select name =\"key_list_array[]\" multiple size = \"20\">");
517
518 $sql = "SELECT c.coursesub, c.coursesub_descr, c.coursesub_id, c.cip_code FROM
519 coursesub c,
520 sub_coursesub sc,
521 subject s
522 WHERE
523 s.subject_id = " . $subject_id . " AND
524 sc.subject_id = s.subject_id AND
525 sc.coursesub_id = c.coursesub_id ORDER BY coursesub_descr";
526
527 // Fetch the values
528 $rs = mysql_query($sql, $con);
529 while ($row = mysql_fetch_array ($rs)) {
530 $coursesub = $row["coursesub"];
531 $coursesub_id = $row["coursesub_id"];
532 $coursesub_descr = $row["coursesub_descr"];
533 $cip_code = $row["cip_code"];
534
535 // Limit length
536 if (strlen($coursesub_descr) > 30) $coursesub_descr = substr($coursesub_descr, 0, 30) . "...";
537
538 printf("<option value = \"%s\">%s | %s [%s]</option>", $coursesub_id, $coursesub, $coursesub_descr, $cip_code);
539 }
540
541 // Close things
542 printf("</select><br><br>");
543 printf("<center>");
544 printf("<input type = \"Submit\" value =\" << \">");
545 printf("</center>");
546 printf("</form>");
547 printf("</td></tr>");
548
549 // Close off the table
550 printf("</td></tr></table>");
551 }
552
553
554 /**********************************************************
555 Function: formAssignSubLoc
556 Author: Paul Bramscher
557 Last Modified: 06.26.2003
558 ***********************************************************
559 Purpose:
560 Draws an HTML combo box with multiple selection capability
561 to assign locations to the supplied subject id.
562 **********************************************************/
563 function formAssignSubLoc($con, $subject_id){
564
565 // Table definition
566 printf("<br><br>\n");
567 printf("<table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">");
568
569 // Form of available locations to select
570 printf("<form method = \"POST\" action = \"assign.phtml\" >");
571 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
572 printf("Assign Secondary Locations");
573 printf("</td></tr>\n");
574
575 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
576 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubLoc\" >");
577
578 // Omit the '(N/A)' location
579 $omit_string = "WHERE location_id > 1";
580
581 // Omit any pre-selected locations in sub_loc
582 $in_string = getNotIn($con, "location_id", "subject_id", $subject_id, "sub_loc");
583 if (strlen($in_string) > 0) $omit_string .= " AND location_id NOT IN " . $in_string;
584
585 // Draw the combo box
586 printf("<tr><td valign = \"top\" >\n");
587 printf("<br><b>Available Location(s):<br></b>\n");
588 printf("<select name = \"location_id_array[]\" multiple size = \"5\" >");
589 dropDownFieldOmit($con, "location", "location", "location_id", $omit_string);
590 printf("</select><br><br>");
591
592 // Close things
593 printf("<center>");
594 printf("<input type = \"Submit\" value = \" >> \" >");
595 printf("</form>");
596 printf("</center>");
597 printf("</td>");
598
599 // Current locations to deselect
600 printf("<td valign = \"top\" >\n");
601 printf("<form method = \"POST\" action = \"delete.phtml\" >");
602 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
603 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubLoc\" >");
604 printf("<br><b>Selected Location(s):</b><br>\n");
605 printf("<select name =\"key_list_array[]\" multiple size = 5>");
606
607 $sql = "SELECT l.location, l.location_id FROM
608 location l,
609 sub_loc sl,
610 subject s
611 WHERE
612 s.subject_id = " . $subject_id . " AND
613 sl.subject_id = s.subject_id AND
614 sl.location_id = l.location_id ORDER BY location";
615
616 // Fetch the values
617 $rs = mysql_query($sql, $con);
618 while ($row = mysql_fetch_array ($rs)) {
619 $location = $row["location"];
620 $location_id = $row["location_id"];
621 printf("<option value = \"%s\">%s</option>", $location_id, $location);
622 }
623
624 // Close things
625 printf("</select><br><br>");
626 printf("<center>");
627 printf("<input type = \"Submit\" value =\" << \">");
628 printf("</center>");
629 printf("</form>");
630 printf("</td></tr>");
631
632 // Close off the table
633 printf("</td></tr></table>");
634 }
635
636
637 /**********************************************************
638 Function: formAssignSubMaster
639 Author: Paul Bramscher
640 Last Modified: 06.26.2003
641 ***********************************************************
642 Purpose:
643 Draws an HTML combo box with multiple selection capability
644 to assign master subjects to the supplied subject id.
645 **********************************************************/
646 function formAssignSubMaster($con, $subject_id){
647
648 // Table definition
649 printf("<br><br>\n");
650 printf("<table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
651
652 // Form of available master subjects to select
653 printf("<form method = \"POST\" action = \"assign.phtml\" >");
654
655 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
656 printf("Assign Master Subjects");
657 printf("</td></tr>\n");
658 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
659 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubMaster\" >");
660
661 // Omit the '(N/A)' location
662 $omit_string = "WHERE mastersubject_id > 1";
663
664 // Omit any pre-selected locations in sub_mastersubject
665 $in_string = getNotIn($con, "mastersubject_id", "subject_id", $subject_id, "sub_mastersubject");
666 if (strlen($in_string) > 0) $omit_string .= " AND mastersubject_id NOT IN " . $in_string;
667
668 // Draw the combo box
669 printf("<tr><td valign = \"top\" >\n");
670 printf("<br><b>Available Master Subjects(s):<br></b>\n");
671 printf("<select name = \"mastersubject_id_array[]\" multiple size = \"5\" >");
672 dropDownFieldOmit($con, "mastersubject", "mastersubject", "mastersubject_id", $omit_string);
673 printf("</select><br><br>");
674
675 // Close things
676 printf("<center>");
677 printf("<input type = \"Submit\" value = \" >> \" >");
678 printf("</form>");
679 printf("</center>");
680 printf("</td>");
681
682 // Current mastersubjects to deselect
683 printf("<td valign = \"top\" >\n");
684 printf("<form method = \"POST\" action = \"delete.phtml\" >");
685 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
686 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubMaster\" >");
687 printf("<br><b>Selected Master Subject(s):</b><br>\n");
688 printf("<select name =\"key_list_array[]\" multiple size = 5>");
689
690 $sql = "SELECT m.mastersubject, m.mastersubject_id FROM
691 mastersubject m,
692 sub_mastersubject sm,
693 subject s
694 WHERE
695 s.subject_id = " . $subject_id . " AND
696 sm.subject_id = s.subject_id AND
697 sm.mastersubject_id = m.mastersubject_id ORDER BY mastersubject";
698
699 // Fetch the values
700 $rs = mysql_query($sql, $con);
701 while ($row = mysql_fetch_array ($rs)) {
702 $mastersubject = $row["mastersubject"];
703 $mastersubject_id = $row["mastersubject_id"];
704 printf("<option value = \"%s\">%s</option>", $mastersubject_id, $mastersubject);
705 }
706
707 // Close things
708 printf("</select><br><br>");
709 printf("<center>");
710 printf("<input type = \"Submit\" value =\" << \">");
711 printf("</center>");
712 printf("</form>");
713 printf("</td></tr>");
714
715 // Close off the table
716 printf("</td></tr></table>");
717 }
718
719
720 /**********************************************************
721 Function: formAssignSubOtherSub
722 Author: Paul Bramscher
723 Last Modified: 11.06.2003
724 ***********************************************************
725 Purpose:
726 Draws an HTML combo box with multiple selection capability
727 to assign other subject pages to the supplied subject id.
728 **********************************************************/
729 function formAssignSubOtherSub($con, $subject_id){
730
731 // Table definition
732 printf("<table width=\"75%%\" border=\"2\" class=\"backLight\" cellpadding=\"4\" >");
733
734 // Form of available master subjects to select
735 printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
736 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
737 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubOtherSub\" >");
738
739 // Free-form pages only
740 $omit_string = "WHERE subject_id > 1 AND subject_id <> " . $subject_id;
741
742 // Omit any pre-selected other subjects in sub_othersub
743 $in_string = getNotIn($con, "othersub_id", "subject_id", $subject_id, "sub_othersub");
744 if (strlen($in_string) > 0) $omit_string .= " AND subject_id NOT IN " . $in_string;
745
746 // Draw the combo box
747 // Header
748 printf("<tr><td class=\"cellPlain\" colspan=\"2\">Related RQS Subjects</td></tr>\n");
749
750
751 printf("<tr><td valign = \"top\" >\n");
752 printf("<br><strong>Available Subject(s):<br></strong>\n");
753 printf("<select name = \"subject_id_array[]\" multiple size = \"5\" >");
754 dropDownFieldOmit($con, "subject", "subject", "subject_id", $omit_string);
755 printf("</select><br><br>");
756
757 // Close things
758 printf("<center>");
759 printf("<input type = \"Submit\" value = \" Add \" >");
760 printf("</form>");
761 printf("</center>");
762 printf("</td></tr>");
763
764 // Current rqs subjects to deselect
765 printf("<tr><td valign = \"top\" >\n");
766 printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
767 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
768 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubOtherSub\" >");
769 printf("<br><strong>Selected Subject(s):</strong><br>\n");
770 printf("<select name =\"key_list_array[]\" multiple size = \"3\">");
771
772 $sql = "SELECT so.othersub_id, s.subject FROM
773 subject s,
774 sub_othersub so
775 WHERE
776 so.subject_id = " . $subject_id . " AND
777 so.othersub_id = s.subject_id
778 ORDER BY s.subject";
779
780 // Fetch the values
781 $rs = mysql_query($sql, $con);
782 while ($row = mysql_fetch_array ($rs)) {
783 $othersub = $row["subject"];
784 $othersub_id = $row["othersub_id"];
785
786 printf("<option value = \"%s\">%s</option>", $othersub_id, $othersub);
787 }
788
789 // Close things
790 printf("</select><br><br>");
791 printf("<center>");
792 printf("<input type = \"Submit\" value =\" Remove \">");
793 printf("</center>");
794 printf("</form>");
795 printf("</td></tr>");
796
797 // Close off the table
798 printf("</td></tr></table>");
799 }
800
801
802 /**********************************************************
803 Function: formAssignSubPage
804 Author: Paul Bramscher
805 Last Modified: 11.06.2003
806 ***********************************************************
807 Purpose:
808 Draws an HTML combo box with multiple selection capability
809 to assign PageScribe Pages to the supplied subject id.
810 **********************************************************/
811 function formAssignSubPage($con, $subject_id){
812
813 // Table definition
814 printf("<table width=\"75%%\" border=\"2\" class=\"backLight\" cellpadding=\"4\" >");
815
816 // Form of available master subjects to select
817 printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
818 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
819 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubPage\" >");
820
821 // Free-form pages only
822 $omit_string = "WHERE pagetype_id = 2";
823
824 // Omit any pre-selected pages in sub_page
825 $in_string = getNotIn($con, "page_id", "subject_id", $subject_id, "sub_page");
826 if (strlen($in_string) > 0) $omit_string .= " AND page_id NOT IN " . $in_string;
827
828 // Draw the combo box
829 // Header
830 printf("<tr><td class=\"cellPlain\" colspan=\"2\">Related PageScribe Pages</td></tr>\n");
831
832
833 printf("<tr><td valign = \"top\" >\n");
834 printf("<br><strong>Available Page(s):<br></strong>\n");
835 printf("<select name = \"page_id_array[]\" multiple size = \"5\" >");
836 dropDownFieldOmit($con, "page", "page_title", "page_id", $omit_string);
837 printf("</select><br><br>");
838
839 // Close things
840 printf("<center>");
841 printf("<input type = \"Submit\" value = \" Add \" >");
842 printf("</form>");
843 printf("</center>");
844 printf("</td></tr>");
845
846 // Current mastersubjects to deselect
847 printf("<tr><td valign = \"top\" >\n");
848 printf("<form method = \"POST\" action = \"subject_transaction.phtml\" >");
849 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
850 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubPage\" >");
851 printf("<br><strong>Selected Page(s):</strong><br>\n");
852 printf("<select name =\"key_list_array[]\" multiple size = \"3\">");
853
854 $sql = "SELECT p.page_title, p.page_id FROM
855 page p,
856 sub_page sp
857 WHERE
858 sp.subject_id = " . $subject_id . " AND
859 sp.page_id = p.page_id
860 ORDER BY p.page_title";
861
862 // Fetch the values
863 $rs = mysql_query($sql, $con);
864 while ($row = mysql_fetch_array ($rs)) {
865 $page_title = $row["page_title"];
866 $page_id = $row["page_id"];
867
868 // Pull out any HTML
869 $page_title = strip_tags($page_title);
870
871 printf("<option value = \"%s\">%s</option>", $page_id, $page_title);
872 }
873
874 // Close things
875 printf("</select><br><br>");
876 printf("<center>");
877 printf("<input type = \"Submit\" value =\" Remove \">");
878 printf("</center>");
879 printf("</form>");
880 printf("</td></tr>");
881
882 // Close off the table
883 printf("</td></tr></table>");
884 }
885
886
887 /**********************************************************
888 Function: formAssignSubStaff
889 Author: Paul Bramscher
890 Last Modified: 06.26.2003
891 ***********************************************************
892 Purpose:
893 Draws an HTML combo box with multiple selection capability
894 to assign staffpersons to the supplied subject id.
895 **********************************************************/
896 function formAssignSubStaff($con, $subject_id){
897
898 // Table definition
899 printf("<br><br>\n");
900 printf("<table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
901
902 // Form of available staff to select
903 printf("<form method = \"POST\" action = \"assign.phtml\" >");
904 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
905 printf("Assign Staff");
906 printf("</td></tr>\n");
907
908 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
909 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignSubStaff\" >");
910
911 // Omit the '(N/A)' staff
912 $omit_string = "WHERE staff_id > 1";
913
914 // Omit any pre-selected staff in sub_staff
915 $in_string = getNotIn($con, "staff_id", "subject_id", $subject_id, "sub_staff");
916 if (strlen($in_string) > 0) $omit_string .= " AND staff_id NOT IN " . $in_string;
917
918 // Draw the combo box
919 printf("<tr><td valign = \"top\" >\n");
920 printf("<br><b>Available Staff:<br></b>\n");
921 printf("<select name = \"staff_id_array[]\" multiple size = \"5\" >");
922 dropDownStaffOmit($con, $omit_string);
923 printf("</select><br><br>");
924
925 // Close things
926 printf("<center>");
927 printf("<input type = \"Submit\" value = \" >> \" >");
928 printf("</form>");
929 printf("</center>");
930 printf("</td>");
931
932 // Current staff to deselect
933 printf("<td valign = \"top\" >\n");
934 printf("<form method = \"POST\" action = \"delete.phtml\" >");
935 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" >", $subject_id);
936 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteSubStaff\" >");
937 printf("<br><b>Selected Staff:</b><br>\n");
938 printf("<select name =\"key_list_array[]\" multiple size = 5>");
939
940 $sql = "SELECT t.staff_id, t.last_name, t.first_name FROM
941 staff t,
942 sub_staff st,
943 subject s
944 WHERE
945 s.subject_id = " . $subject_id . " AND
946 st.subject_id = s.subject_id AND
947 st.staff_id = t.staff_id ORDER BY last_name, first_name";
948
949 // Fetch the values
950 $rs = mysql_query($sql, $con);
951 while ($row = mysql_fetch_array ($rs)) {
952 $first_name = $row["first_name"];
953 $last_name = $row["last_name"];
954 $staff_id = $row["staff_id"];
955 printf("<option value = \"%d\">%s, %s</option>", $staff_id, $last_name, $first_name);
956 }
957
958 // Close things
959 printf("</select><br><br>");
960 printf("<center>");
961 printf("<input type = \"Submit\" value =\" << \">");
962 printf("</center>");
963 printf("</form>");
964 printf("</td></tr>");
965
966 // Close off table
967 printf("</td></tr></table>");
968 }
969
970
971 /**********************************************************
972 Function: formCoursesub
973 Author: Paul Bramscher
974 Last Modified: 07.02.2003
975 ***********************************************************
976 Purpose:
977 Draws an HTML form to edit the supplied feature id, or to
978 create a new feature if the incoming id is less than 1.
979 **********************************************************/
980 function formCoursesub($con, $coursesub_id) {
981
982 // Cast as integer to be sure
983 $coursesub_id = (int) $coursesub_id;
984
985 // Get descriptive title
986 $coursesub = lookupField($con, "coursesub", "coursesub_id", $coursesub_id, "coursesub");
987
988 // Check to see if coursesub actually exists
989 $exists = existsRow($con, "coursesub", "coursesub_id", $coursesub_id);
990
991 // Houston, we have a problem
992 if ($key_id > 0 && $exists == 0) {
993 $problem = 1;
994 printf("<h3>Course Subject #%d Not Found</h3>", $coursesub_id);
995 }
996
997 // Check to see if there are affected courselib pages
998 $exists_courselib = existsRow($con, "course", "coursesub_id", $coursesub_id);
999 if ($exists_courselib > 0) {
1000
1001 $problem = 1;
1002
1003 // Table definition
1004 printf("<center><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
1005 printf("<tr><td><br>\n");
1006 printf("<b>Messages:</b><br>");
1007 printf("This course subject is currently used on one or more course pages. ");
1008 printf("It may not be edited or deleted until all affected courses are moved to ");
1009 printf("an alternate course subject. Follow the link below for a list of ");
1010 printf("affected pages. Course titles are composed, in part, based on this ");
1011 printf("value.<br><br>");
1012 printf("<a href=\"page_results_brief.phtml?coursesub_id=%s\">", $coursesub_id);
1013 printf("page_results_brief.phtml?coursesub_id=%s", $coursesub_id);
1014 printf("</a><br><br>");
1015 printf("</td></tr></table></center>\n");
1016 }
1017
1018
1019
1020
1021 // If no problems, then go for landing
1022 if ($problem != 1) {
1023
1024 // Initialization
1025 $coursesub = "";
1026 $coursesub_descr = "";
1027 $campus_id = "";
1028 $cip_code = "";
1029
1030 // If the user is editing an existing record, fetch previous values
1031 if ($coursesub_id > 0 && $exists == 1) {
1032 $sql = "SELECT * FROM coursesub WHERE coursesub_id = " . $coursesub_id;
1033 $rs = mysql_query($sql, $con);
1034 $row = mysql_fetch_array ($rs);
1035
1036 // Fetch existing values
1037 $coursesub_id = $row["coursesub_id"];
1038 $coursesub = $row["coursesub"];
1039 $coursesub_descr = $row["coursesub_descr"];
1040 $cip_code = $row["cip_code"];
1041 $campus_id = $row["campus_id"];
1042
1043 // Run strings through the HTML cleaner for output
1044 $coursesub = textOutHTML($coursesub);
1045 $coursesub_descr = textOutHTML($coursesub_descr);
1046 $cip_code = textOutHTML($cip_code);
1047
1048 };
1049
1050 // Table definition
1051 printf("<center><table width=\"75%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
1052
1053 // If new insert
1054 if ($coursesub_id <1) {
1055 printf("<form method = \"POST\" action = \"insert.phtml\" >");
1056 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1057 printf("Enter New Course Subject");
1058 printf("</td></tr>\n");
1059 }
1060
1061 // Else update
1062 else {
1063 printf("<form method = \"POST\" action = \"update.phtml\" >");
1064 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1065 printf("Edit Course Subject: %s (#%d)", $coursesub, $coursesub_id);
1066 printf("</td></tr>\n");
1067 }
1068
1069
1070 // Coursesub abbrev.
1071 printf("<tr>\n");
1072 printf("<td><b>Course Subject Abbrev:</b></td>\n");
1073 printf("<td><input type = \"text\" name = \"coursesub\" size = \"10\" value = \"%s\" ></td>\n", $coursesub);
1074 printf("</tr>\n");
1075
1076 // Coursesub descr
1077 printf("<tr>\n");
1078 printf("<td><b>Course Subject Description:</b></td>\n");
1079 printf("<td><input type = \"text\" name = \"coursesub_descr\" size = \"60\" value = \"%s\" ></td>\n", $coursesub_descr);
1080 printf("</tr>\n");
1081
1082 // Campus
1083 printf("<tr>\n");
1084 printf("<td><b>Campus:</b></td>\n");
1085 printf("<td><select name =\"campus_id\">");
1086 dropDownFieldSelected($con, "campus", "campus", "campus_id", "WHERE campus_id >= 0", $campus_id);
1087 printf("</select></td>\n");
1088 printf("</tr>\n");
1089
1090 // CIP code
1091 printf("<tr>\n");
1092 printf("<td><b>CIP Code:</b></td>\n");
1093 printf("<td><input type = \"text\" name = \"cip_code\" size = \"25\" value = \"%s\" ></td>\n", $cip_code);
1094 printf("</tr>\n");
1095
1096 // Buttons
1097 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1098
1099 // If this is an existing course subject
1100 if ($coursesub_id > 0) {
1101 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateCoursesub\" > ");
1102 printf("<input type = \"Submit\" value = \"Update Course Subject\" > ");
1103 printf("<input type = \"Hidden\" name = \"coursesub_id\" value = \"%d\" > ", $coursesub_id);
1104 }
1105 // Editing a new course subject
1106 else {
1107 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertCoursesub\" > ");
1108 printf("<input type = \"Submit\" value = \"Save New Course Subject\"> ");
1109 }
1110
1111 // Common button
1112 printf("<input type = \"Reset\" value = \"Reset\" >\n");
1113
1114 // Close things
1115 printf("</form>\n");
1116 printf("</td></tr></table></center>\n");
1117
1118 } // No problems
1119 }
1120
1121
1122 /**********************************************************
1123 Function: formEditSingleField($con, $display, $display_field,
1124 $key_field, $key_id, $table);
1125 Author: Paul Bramscher
1126 Last Modified: 07.03.2003
1127 ***********************************************************
1128 Incoming:
1129 $con Database connection string
1130 $table Table name to operate against
1131 $display A display to the user, typically
1132 similar to $display_field
1133 $display_field Field name within $table to generate
1134 displayed values from
1135 $key_field Name of primary key field in $table
1136 $key_id Value of $key_field
1137 ***********************************************************
1138 Outgoing:
1139 None
1140 ***********************************************************
1141 Purpose:
1142 This is a generic form function to create a new entry in a
1143 table. The table's primary key must not involve a
1144 composite key -- since this form won't handle that.
1145 **********************************************************/
1146 function formEditSingleField($con, $display, $display_field, $key_field, $key_id,
1147 $size, $table) {
1148
1149 // Make sure we have a positive integer to work with
1150 if ($key_id > 1){
1151
1152 // Fetch previous value
1153 $sql = "SELECT "
1154 . $display_field
1155 . " FROM "
1156 . $table
1157 . " WHERE "
1158 . $key_field
1159 . " = "
1160 . $key_id;
1161
1162 $rs = mysql_query($sql, $con);
1163 $row = mysql_fetch_array($rs);
1164 $oldValue = Trim($row[$display_field]);
1165
1166 // Table definition
1167 printf("<center>\n");
1168 printf("<table width = \"60%%\" border = \"1\" cellpadding =\"4\" class=\"backLight\"");
1169 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1170 printf("Edit %s: %s (#%d)", $display, $oldValue, $key_id);
1171 printf("</td></tr>\n");
1172
1173 // Form to handle any single field
1174 printf("<form method = \"POST\" action = \"update.phtml\" >");
1175 printf("<tr><td>");
1176 printf("<b>%s:</b> ", $display);
1177 printf("</td>\n");
1178 printf("<td>\n");
1179 printf("<input type = \"text\" name = \"newValue\" size=\"%d\" value =\"%s\" >", $size, $oldValue);
1180 printf("<input type = \"Hidden\" name = \"display\" value = \"%s\" >", $display);
1181 printf("<input type = \"Hidden\" name = \"display_field\" value = \"%s\" >", $display_field);
1182 printf("<input type = \"Hidden\" name = \"key_field\" value = \"%s\" >", $key_field);
1183 printf("<input type = \"Hidden\" name = \"key_id\" value = \"%s\" >", $key_id);
1184 printf("<input type = \"Hidden\" name = \"table\" value = \"%s\" >", $table);
1185 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateSingleField\" >");
1186 printf("</td></tr>\n");
1187 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1188 printf("<input type = \"Submit\" value = \"Save Changes To %s\" > ", $display);
1189 printf("<input type = \"Reset\" value = \"Reset\" >");
1190
1191 // Close things
1192 printf("</form><BR>");
1193 printf("</td></tr>");
1194 printf("</table></center>");
1195
1196 }
1197
1198 else printf("Nothing selected. Operation cancelled.");
1199 }
1200
1201
1202 /**********************************************************
1203 Function: formFaculty
1204 Author: Paul Bramscher
1205 Last Modified: 07.03.2003
1206 ***********************************************************
1207 Purpose:
1208 Draws an HTML form to edit the supplied faculty id, or to
1209 create a new faculty person if the incoming id is less than
1210 1.
1211 **********************************************************/
1212 function formFaculty($con, $faculty_id){
1213
1214 // Initialize variables
1215 $faculty_id = (int) $faculty_id;
1216 $faculty_lastname ="";
1217 $faculty_firstname = "";
1218 $faculty_account = "";
1219 $faculty_email = "";
1220
1221 // If editing an existing faculty member load previous values
1222 if ($faculty_id > 1){
1223 $sql = "SELECT
1224 f.faculty_firstname,
1225 f.faculty_lastname,
1226 f.faculty_account,
1227 f.faculty_email
1228 FROM faculty f
1229 WHERE
1230 faculty_id = " . $faculty_id;
1231
1232 $rs = mysql_query($sql, $con);
1233 $row = mysql_fetch_array($rs);
1234
1235 // Fetch results
1236 $faculty_firstname = Trim($row["faculty_firstname"]);
1237 $faculty_lastname = Trim($row["faculty_lastname"]);
1238 $faculty_account = Trim($row["faculty_account"]);
1239 $faculty_email = Trim($row["faculty_email"]);
1240
1241 // Run strings through the HTML cleaner for output
1242 $faculty_lastname = textOutHTML($faculty_lastname);
1243 $faculty_firstname = textOutHTML($faculty_firstname);
1244 }
1245
1246 // Table definition
1247 printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
1248
1249 // If new faculty
1250 if ($faculty_id < 1) {
1251 printf("<form method = \"POST\" action = \"insert.phtml\" >");
1252 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1253 printf("Enter New Faculty");
1254 printf("</td></tr>\n");
1255 }
1256
1257 // Else update
1258 else {
1259 printf("<form method = \"POST\" action = \"update.phtml\" >");
1260 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1261 printf("Edit Faculty: %s %s (#%d)", $faculty_firstname, $faculty_lastname, $faculty_id);
1262 printf("</td></tr>\n");
1263 }
1264
1265 // Last name
1266 printf("<tr>\n");
1267 printf("<td width=\"40%%\"><b>Last Name:</b></td>\n");
1268 printf("<td><input type = \"text\" name = \"faculty_lastname\" size = \"40\" value = \"%s\" ></td>\n", $faculty_lastname);
1269 printf("</tr>\n");
1270
1271 // First name
1272 printf("<tr>\n");
1273 printf("<td><b>First Name:</b></td>\n");
1274 printf("<td><input type = \"text\" name = \"faculty_firstname\" size = \"40\" value = \"%s\"></td>\n", $faculty_firstname);
1275 printf("</tr>\n");
1276
1277 // Faculty account (x500 if applicable)
1278 printf("<tr>\n");
1279 printf("<td><b>Faculty account (x500 if applicable):</b></td>\n");
1280 printf("<td><input type = \"text\" name = \"faculty_account\" size = \"15\" value =\"%s\"></td>\n", $faculty_account);
1281 printf("</tr>\n");
1282
1283 // Email
1284 printf("<tr>\n");
1285 printf("<td><b>Email:</b></td>\n");
1286 printf("<td><input type = \"text\" name = \"faculty_email\" size = \"40\" value =\"%s\"></td>\n", $faculty_email);
1287 printf("</tr>\n");
1288
1289 // Buttons
1290 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1291 // If new faculty
1292 if ($faculty_id < 1) {
1293 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertFaculty\" >");
1294 printf("<input type = \"Submit\" value = \"Save New Faculty\" > ");
1295 }
1296 // Editing an existing faculty person
1297 else {
1298 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateFaculty\" >");
1299 printf("<input type = \"Hidden\" name = \"faculty_id\" value = \"%d\" >", $faculty_id);
1300 printf("<input type = \"Submit\" value = \"Save Faculty Changes\" > ");
1301 }
1302 printf("<input type = \"Reset\" value = \"Reset\" >");
1303
1304 // Close things
1305 printf("</form>");
1306 printf("</td></tr></table>");
1307 printf("</center><br>");
1308 }
1309
1310
1311 /**********************************************************
1312 Function: formFeature
1313 Author: Paul Bramscher
1314 Last Modified: 07.01.2003
1315 ***********************************************************
1316 Purpose:
1317 Draws an HTML form to edit the supplied feature id, or to
1318 create a new feature if the incoming id is less than 1.
1319 **********************************************************/
1320 function formFeature($con, $key_id) {
1321
1322 // Cast as integer to be sure
1323 $key_id = (int) $key_id;
1324
1325 // Check to see if feature actually exists
1326 $exists = existsRow($con, "feature", "feature_id", $key_id);
1327
1328 // Header
1329 printf("<center>");
1330 if ($key_id > 0 && $exists == 1) {
1331
1332 // Initialization
1333 $feature = "";
1334 $feature_id = "";
1335
1336 // Fetch existing values
1337 $sql = "SELECT * FROM feature WHERE feature_id = " . $key_id;
1338 $rs = mysql_query($sql, $con);
1339 $row = mysql_fetch_array ($rs);
1340 $feature_id = $row["feature_id"];
1341 $feature = $row["feature"];
1342 $image_path = $row["image_path"];
1343 $image_alt = $row["image_alt"];
1344
1345 // Run strings through the HTML cleaner for output
1346 $feature = textOutHTML($feature);
1347 $image_path = textOutHTML($image_path);
1348 $image_alt = textOutHTML($image_alt);
1349 }
1350
1351 // Houston, we have a problem
1352 if ($key_id > 0 && $exists == 0) {
1353 $problem = 1;
1354 printf("<h3>Feature #%d Not Found</h3>", $key_id);
1355 }
1356
1357 // If no problems, then go for landing
1358 if ($problem != 1) {
1359
1360 // Table definition
1361 printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
1362
1363 // Form to handle feature
1364 // If new insert
1365 if ($key_id <1) {
1366 printf("<form method = \"POST\" action = \"insert.phtml\" >");
1367 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1368 printf("Enter New Feature");
1369 printf("</td></tr>\n");
1370 }
1371
1372 // Else update
1373 else {
1374 printf("<form method = \"POST\" action = \"update.phtml\" >");
1375 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1376 printf("Edit Feature: %s (#%d)", $feature, $feature_id);
1377 printf("</td></tr>\n");
1378 }
1379
1380 // Feature name
1381 printf("<tr>\n");
1382 printf("<td><b>Feature:</b></td>");
1383 printf("<td><input type = \"text\" name = \"feature\" size = \"40\" value = \"%s\" ></td>\n", $feature);
1384 printf("</tr>\n");
1385
1386 // Image path
1387 printf("<tr>\n");
1388 printf("<td><b>Image Path:</b></td>\n");
1389 printf("<td><input type = \"text\" name = \"image_path\" size = \"50\" value = \"%s\" ></td>\n", $image_path);
1390 printf("</tr>\n");
1391
1392 // Image alt text
1393 printf("<tr>\n");
1394 printf("<td><b>Image Alt Text:</b></td>\n");
1395 printf("<td><input type = \"text\" name = \"image_alt\" size = \"50\" value = \"%s\" ></td>\n", $image_alt);
1396
1397 // Buttons
1398 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1399 // If this is an existing feature
1400 if ($key_id > 0) {
1401 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateFeature\" > ");
1402 printf("<input type = \"Submit\" value = \"Update Feature\" > ");
1403 printf("<input type = \"Hidden\" name = \"feature_id\" value = \"%d\" > ", $feature_id);
1404 }
1405 // Editing a new feature
1406 else {
1407 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertFeature\" > ");
1408 printf("<input type = \"Submit\" value = \"Save New Feature\"> ");
1409 }
1410
1411 // Common button
1412 printf("<input type = \"Reset\" value = \"Reset\" >\n");
1413
1414 // Close things
1415 printf("</form>\n");
1416 printf("</td></tr></table></center>\n");
1417
1418 } // No problems
1419 }
1420
1421
1422 /**********************************************************
1423 Function: formInfotype
1424 Author: Paul Bramscher
1425 Last Modified: 06.26.2003
1426 ***********************************************************
1427 Purpose:
1428 Draws an HTML form to edit the supplied information type id,
1429 or to create a new information type if the incoming id is
1430 less than 1.
1431 **********************************************************/
1432 function formInfotype($con, $key_id) {
1433
1434 // Cast as integer to be sure
1435 $key_id = (int) $key_id;
1436
1437 // Check to see if infotype actually exists
1438 $exists = existsRow($con, "infotype", "infotype_id", $key_id);
1439
1440 // Header
1441 printf("<center>");
1442 if ($key_id > 0 && $exists == 1) {
1443
1444 // Initialization
1445 $infotype = "";
1446 $infotype_id = "";
1447 $masterinfotype_id = "";
1448 $mastersubject_id = "";
1449
1450 // Fetch existing values
1451 $sql = "SELECT * from infotype where infotype_id = " . $key_id;
1452 $rs = mysql_query($sql, $con);
1453 $row = mysql_fetch_array ($rs);
1454 $infotype_id = $row["infotype_id"];
1455 $infotype = $row["infotype"];
1456 $masterinfotype_id = $row["masterinfotype_id"];
1457 $mastersubject_id = $row["mastersubject_id"];
1458
1459 // Run strings through the HTML cleaner for output
1460 $infotype = textOutHTML($infotype);
1461
1462 }
1463
1464 // Houston, we have a problem
1465 if ($key_id > 0 && $exists == 0) {
1466 $problem = 1;
1467 printf("<h3>Information Type #%d Not Found</h3>", $key_id);
1468 }
1469
1470 // If no problems, then go for landing
1471 if ($problem != 1) {
1472
1473 // Table
1474 printf("<center><table width=\"75%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
1475
1476 // If new insert
1477 if ($key_id < 1) {
1478 printf("<form method = \"POST\" action = \"insert.phtml\" >");
1479 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1480 printf("Enter New Information Type");
1481 printf("</td></tr>\n");
1482
1483 }
1484
1485 // Else update
1486 else {
1487 printf("<form method = \"POST\" action = \"update.phtml\" >");
1488 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1489 printf("Edit Information Type: %s (#%d)", $infotype, $infotype_id);
1490 printf("</td></tr>\n");
1491 }
1492
1493 // Infotype
1494 printf("<tr>\n");
1495 printf("<td><b>Information Type:</b></td>\n");
1496 printf("<td><input type = \"text\" name = \"infotype\" size = \"60\" value = \"%s\" ></td>\n", $infotype);
1497 printf("</tr>\n");
1498
1499 // Masterinfotype
1500 printf("<tr>\n");
1501 printf("<td><b>Master Information Type:</b></td>\n");
1502 printf("<td>\n");
1503 printf("<select name =\"masterinfotype_id\">");
1504 dropDownFieldSelected($con, "masterinfotype", "masterinfotype", "masterinfotype_id", "WHERE masterinfotype_id >= 0", $masterinfotype_id);
1505 printf("</select>\n");
1506 printf("</td></tr>\n");
1507
1508 // Mastersubject
1509 printf("<tr>\n");
1510 printf("<td><b>Master Subject:</b></td>");
1511 printf("<td>\n");
1512 printf("<select name =\"mastersubject_id\">");
1513 dropDownFieldSelected($con, "mastersubject", "mastersubject", "mastersubject_id", "WHERE mastersubject_id >= 0", $mastersubject_id);
1514 printf("</select>\n");
1515 printf("</td></tr>\n");
1516
1517 // Buttons
1518 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1519
1520 // If this is an existing infotype
1521 if ($key_id > 0) {
1522 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateInfotype\" > ");
1523 printf("<input type = \"Submit\" value = \"Update Info Type\" > ");
1524 printf("<input type = \"Hidden\" name = \"infotype_id\" value = \"%d\" > ", $infotype_id);
1525 }
1526 // Editing a new infotype
1527 else {
1528 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertInfotype\" > ");
1529 printf("<input type = \"Submit\" value = \"Save New Info Type\"> ");
1530 }
1531
1532 // Common button
1533 printf("<input type = \"Reset\" value = \"Reset\" >\n");
1534
1535 // Close things
1536 printf("</form>\n");
1537 printf("</td></tr></table></center>\n");
1538
1539
1540 } // No problems
1541 }
1542
1543
1544 /**********************************************************
1545 Function: formLocation
1546 Author: Paul Bramscher
1547 Last Modified: 06.26.2003
1548 ***********************************************************
1549 Draws an HTML form to edit the supplied location id, or to
1550 create a new location if the incoming id is less than 1.
1551 **********************************************************/
1552 function formLocation($con, $key_id) {
1553
1554 // Cast as integer to be sure
1555 $key_id = (int) $key_id;
1556
1557 // Check to see if location actually exists
1558 $exists = existsRow($con, "location", "location_id", $key_id);
1559
1560 // Header
1561 printf("<center>");
1562 if ($key_id > 0 && $exists == 1) {
1563
1564 // Initialization
1565 $location = "";
1566 $location_descr = "";
1567 $campus = "";
1568 $address1 = "";
1569 $address2 = "";
1570 $address3 = "";
1571 $address4 = "";
1572 $mainURL = "";
1573 $referenceURL = "";
1574 $mapURL = "";
1575 $hoursURL = "";
1576 $telephone = "";
1577
1578 // Fetch existing values
1579 $sql = "SELECT * from location where location_id = " . $key_id;
1580 $rs = mysql_query($sql, $con);
1581 $row = mysql_fetch_array ($rs);
1582 $location_id = $row["location_id"];
1583 $location = $row["location"];
1584 $location_descr = $row["location_descr"];
1585 $campus = $row["campus"];
1586 $address1 = $row["address1"];
1587 $address2 = $row["address2"];
1588 $address3 = $row["address3"];
1589 $address4 = $row["address4"];
1590 $mainURL = $row["mainURL"];
1591 $referenceURL = $row["referenceURL"];
1592 $mapURL = $row["mapURL"];
1593 $hoursURL = $row["hoursURL"];
1594 $telephone = $row["telephone"];
1595
1596 // Run strings through the HTML cleaner for output
1597 $location = textOutHTML($location);
1598 $location_descr = textOutHTML($location_descr);
1599 $campus = textOutHTML($campus);
1600 $address1 = textOutHTML($address1);
1601 $address2 = textOutHTML($address2);
1602 $address3 = textOutHTML($address3);
1603 $address4 = textOutHTML($address4);
1604
1605 }
1606
1607 // Houston, we have a problem
1608 if ($key_id > 0 && $exists == 0) {
1609 $problem = 1;
1610 printf("<h3>Location #%d Not Found</h3>", $key_id);
1611 }
1612
1613 // If no problems, then go for landing
1614 if ($problem != 1) {
1615
1616 // Table definition
1617 printf("<center><table width=\"75%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
1618
1619 // If new insert
1620 if ($key_id <1) {
1621 printf("<form method = \"POST\" action = \"insert.phtml\" >");
1622 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1623 printf("Enter New Location");
1624 printf("</td></tr>\n");
1625 }
1626
1627 // Else update
1628 else {
1629 printf("<form method = \"POST\" action = \"update.phtml\" >");
1630 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1631 printf("Edit Location: %s (#%d)", $location, $location_id);
1632 printf("</td></tr>\n");
1633 }
1634
1635 // Location/Library
1636 printf("<tr>\n");
1637 printf("<td><b>Location/Library:</b></td>");
1638 printf("<td>\n");
1639 printf("<input type = \"text\" name = \"location\" size = \"60\" value = \"%s\" >", $location);
1640 printf("</td></tr>\n");
1641
1642 // Description
1643 printf("<tr><td colspan=\"2\"><br>\n");
1644 printf("<b>Description:</b><br>\n");
1645 printf("<textarea name = \"location_descr\" rows = \"5\" cols = \"70\" >\n");
1646 printf("%s", $location_descr);
1647 printf("</textarea><br><br><br>\n");
1648 printf("</td></tr>\n");
1649
1650 // Campus
1651 printf("<tr>\n");
1652 printf("<td><b>Campus:</b></td>\n");
1653 printf("<td>\n");
1654 printf("<input type = \"text\" name = \"campus\" size = \"50\" value = \"%s\" >", $campus);
1655 printf("</td></tr>\n");
1656
1657 // Address1
1658 printf("<tr>\n");
1659 printf("<td><b>Address Line 1:</b></td>\n");
1660 printf("<td>\n");
1661 printf("<input type = \"text\" name = \"address1\" size = \"50\" value = \"%s\" >", $address1);
1662 printf("</td></tr>\n");
1663
1664 // Address2
1665 printf("<tr>\n");
1666 printf("<td><b>Address Line 2:</b></td>\n");
1667 printf("<td>\n");
1668 printf("<input type = \"text\" name = \"address2\" size = \"50\" value = \"%s\" >", $address2);
1669 printf("</td></tr>\n");
1670
1671 // Address3
1672 printf("<tr>\n");
1673 printf("<td><b>Address Line 3:</b></td>\n");
1674 printf("<td>\n");
1675 printf("<input type = \"text\" name = \"address3\" size = \"50\" value = \"%s\" >", $address3);
1676 printf("</td></tr>\n");
1677
1678 // Address4
1679 printf("<tr>\n");
1680 printf("<td><b>Address Line 4:</b></td>\n");
1681 printf("<td>\n");
1682 printf("<input type = \"text\" name = \"address4\" size = \"50\" value = \"%s\" >", $address4);
1683 printf("</td></tr>\n");
1684
1685 // Telephone
1686 printf("<tr>\n");
1687 printf("<td><b>Telephone:</b></td>\n");
1688 printf("<td>\n");
1689 printf("<input type = \"text\" name = \"telephone\" size = \"25\" value = \"%s\" >", $telephone);
1690 printf("</td></tr>\n");
1691
1692 // mainURL
1693 printf("<tr>\n");
1694 printf("<td><b>Main URL:</b></td>\n");
1695 printf("<td>\n");
1696 printf("<input type = \"text\" name = \"mainURL\" size = \"70\" value = \"%s\" >", $mainURL);
1697 printf("</td></tr>\n");
1698
1699 // referenceURL
1700 printf("<tr>\n");
1701 printf("<td><b>Reference URL:</b></td>\n");
1702 printf("<td>\n");
1703 printf("<input type = \"text\" name = \"referenceURL\" size = \"70\" value = \"%s\" >",
1704 $referenceURL);
1705 printf("</td></tr>\n");
1706
1707 // hoursURL
1708 printf("<tr>\n");
1709 printf("<td><b>Hours URL:</b></td>\n");
1710 printf("<td>\n");
1711 printf("<input type = \"text\" name = \"hoursURL\" size = \"70\" value = \"%s\" >",
1712 $hoursURL);
1713 printf("</td></tr>\n");
1714
1715 // mapURL
1716 printf("<tr>\n");
1717 printf("<td><b>Map URL:</b></td>\n");
1718 printf("<td>\n");
1719 printf("<input type = \"text\" name = \"mapURL\" size = \"70\" value = \"%s\" >", $mapURL);
1720 printf("</td></tr>\n");
1721
1722 // Buttons
1723 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1724
1725 // If this is an existing location
1726 if ($key_id > 0) {
1727 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateLocation\" > ");
1728 printf("<input type = \"Submit\" value = \"Update Location\" > ");
1729 printf("<input type = \"Hidden\" name = \"location_id\" value = \"%d\" > ", $location_id);
1730 }
1731 // Editing a new location
1732 else {
1733 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertLocation\" > ");
1734 printf("<input type = \"Submit\" value = \"Save New Location\" > ");
1735 }
1736
1737 // Common button
1738 printf("<input type = \"Reset\" value = \"Reset\" >\n");
1739
1740 // Close things
1741 printf("</form>\n");
1742 printf("</td></tr></table></center>\n");
1743
1744 } // No problems
1745 }
1746
1747
1748 /**********************************************************
1749 Function: formNewSingleField($con, $display, $field,
1750 $size, $table);
1751 Author: Paul Bramscher
1752 Last Modified: 07.03.2003
1753 ***********************************************************
1754 Incoming:
1755 $con Database connection string
1756 $table Table name to operate against
1757 $field Field name within $table
1758 $display A display to the user, typically
1759 identical to $field
1760 $size The size of the HTML input box
1761 ***********************************************************
1762 Outgoing:
1763 None
1764 ***********************************************************
1765 Purpose:
1766 This is a generic form function to create a new entry in a
1767 table. The table's primary key must not involve a
1768 composite key since this form won't handle that.
1769 **********************************************************/
1770 function formNewSingleField($con, $display, $field, $size, $table) {
1771
1772 // Draw Box
1773 printf("<center>\n");
1774 printf("<table width = \"60%%\" border = \"1\" cellpadding =\"4\" class=\"backLight\">");
1775 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
1776 printf("Enter New %s", $display);
1777 printf("</td></tr>\n");
1778
1779 // Form for the new field value
1780 printf("<form method = \"POST\" action = \"insert.phtml\" >");
1781 printf("<tr>\n");
1782 printf("<td><b>%s:</b></td>\n", $display);
1783 printf("<td>");
1784 printf("<input type = \"text\" name = \"newValue\" size = \"%d\" >", $size);
1785 printf("<input type = \"Hidden\" name = \"table\" value = \"%s\" >", $table);
1786 printf("<input type = \"Hidden\" name = \"field\" value = \"%s\" >", $field);
1787 printf("<input type = \"Hidden\" name = \"display\" value = \"%s\" >", $display);
1788 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertSingleField\" >");
1789 printf("</td></tr>\n");
1790 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
1791 printf("<input type = \"Submit\" value = \"Save New %s\" > ", $display);
1792 printf("<input type = \"Reset\" value = \"Reset\" >");
1793
1794 // Close things
1795 printf("</form><br>");
1796 printf("</td></tr>");
1797 printf("</table><br></center>");
1798 }
1799
1800
1801 /**********************************************************
1802 Function: formResource
1803 Author: Paul Bramscher
1804 Last Modified: 06.19.2003 by Paul Bramscher
1805 ***********************************************************
1806 Draws an HTML form to edit the supplied resource id, or to
1807 create a new resource if the incoming id is less than 1.
1808 Note also that there are incoming masterinfotype id,
1809 mastersubject id, an title parameters.
1810 **********************************************************/
1811 function formResource($con, $key_id, $masterinfotype_id, $mastersubject_id, $title) {
1812
1813 // Cast as integer to be sure
1814 $key_id = (int) $key_id;
1815
1816 // Check to see if record actually exists
1817 $exists = existsRow($con, "resource", "resource_id", $key_id);
1818
1819 // Houston, we have a problem
1820 if ($key_id > 0 && $exists == 0) {
1821 $problem = 1;
1822 printf("<h3>Resource #%d Not Found</h3>", $key_id);
1823 }
1824
1825
1826 // If no problems, then go for landing
1827 if ($problem != 1) {
1828 // Initialization
1829 if (strlen($title) > 0) {
1830 // Decode the title and strip slashes -- twice to be sure
1831 $title = urldecode($title);
1832 $title = stripslashes($title);
1833 $title = stripslashes($title);
1834 }
1835 $other_title = "";
1836 $coverage_detail = "";
1837 $sources_indexed = "";
1838 $location_id = "";
1839 $author = "";
1840 $format_id = 0;
1841 $pub_loc = "";
1842 $publisher = "";
1843 $pub_date = "";
1844 $edition = "";
1845 $call_no = "";
1846 $cat_num = "";
1847 $site_title = "";
1848 $url = "";
1849 $visited = "";
1850 $annotation ="";
1851
1852 // If the user is editing an existing record, fetch previous values
1853 if ($key_id > 0 && $exists == 1) {
1854
1855 $sql = "SELECT * from resource where resource_id = " . $key_id;
1856 $rs = mysql_query($sql, $con);
1857 $row = mysql_fetch_array ($rs);
1858
1859 // Fetch existing values
1860 $resource_id = $row["resource_id"];
1861 $date_created = $row["date_created"];
1862 $date_modified = $row["date_modified"];
1863 $account_created = $row["account_created"];
1864 $account_modified = $row["account_modified"];
1865 $title = $row["title"];
1866 $author = $row["author"];
1867 $format_id = $row["format_id"];
1868 $pub_loc = $row["pub_loc"];
1869 $publisher = $row["publisher"];
1870 $pub_date = $row["pub_date"];
1871 $edition = $row["edition"];
1872 $call_no = $row["call_no"];
1873 $cat_num = $row["cat_num"];
1874 $site_title = $row["site_title"];
1875 $url = $row["url"];
1876 $visited = $row["visited"];
1877 $annotation = $row["annotation"];
1878 $infotype_id = $row["infotype_id"];
1879 $other_title = $row["other_title"];
1880 $coverage_detail = $row["coverage_detail"];
1881 $sources_indexed = $row["sources_indexed"];
1882 $location_id = $row["location_id"];
1883
1884 // Run strings through the HTML cleaner for output
1885 $title = textOutHTML($title);
1886 $author = textOutHTML($author);
1887 $publisher = textOutHTML($publisher);
1888 $pub_date = textOutHTML($pub_date);
1889 $edition = textOutHTML($edition);
1890 $call_no = textOutHTML($call_no);
1891 $cat_num = textOutHTML($cat_num);
1892 $site_title = textOutHTML($site_title);
1893 $other_title = textOutHTML($other_title);
1894 $coverage_detail = textOutHTML($coverage_detail);
1895 $sources_indexed = textOutHTML($sources_indexed);
1896 };
1897
1898 // Display feedback to the user if resource was entered today
1899
1900 // Fetch today's date
1901 $today = getdate();
1902 $mon = $today[mon];
1903 $mday = $today[mday];
1904 $year = $today[year];
1905
1906 // Back-fill in case we have single-digits.
1907 if (strlen($mday) < 2) $mday = "0" . $mday;
1908 if (strlen($mon) < 2) $mon = "0" . $mon;
1909
1910 // Generate a mySQL-friendly datetime for today's stamp
1911 $today_stamp = $year . "-" . $mon . "-" . $mday;
1912
1913 if (substr($date_created, 0, 10) == $today_stamp) {
1914 printf("<center>\n");
1915 printf("Resource <b>'%s'</b> successfully added today by <b>%s</b>.<br>\n", $title, $account_created);
1916 printf("Scroll <a href=\"#additional\">down</a> to edit further attributes for this resource.<br><br>\n");
1917 printf("</center><br>\n");
1918 }
1919
1920
1921 // Exterior table for border
1922 printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellspacing=\"2\" cellpadding=\"0\" ><tr><td>\n");
1923
1924 // Table definition
1925 printf("<table width=\"100%%\" border=\"0\" cellspacing =\"2\" cellpadding=\"2\">\n");
1926
1927 // Form header
1928 printf("<tr><td colspan=\"4\" class=\"cellPlain\" >");
1929 if ($key_id > 0 && $exists == 1) printf("Edit Resource #%d", $key_id);
1930 if ($key_id <= 0) printf("Enter New Resource\n");
1931 printf("</td></tr>\n");
1932
1933 // If new insert
1934 if ($key_id <1) printf("<form method = \"POST\" action = \"insert.phtml\" >");
1935
1936 // Else update
1937 else printf("<form method = \"POST\" action = \"update.phtml\" >");
1938
1939 // Account & Time/date information if this is not a new resource
1940 if ($key_id > 0) {
1941 printf("<tr>\n<td colspan = \"1\">\n");
1942 printf("<br><B>Date Created:</b>");
1943 printf("</td><td colspan =\"3\">\n");
1944 printf("<BR>%s</td></tr>", $date_created);
1945 printf("<tr>\n<td colspan = \"1\">\n");
1946 printf("<B>Date Modified:</b>");
1947 printf("</td><td colspan =\"3\">\n");
1948 printf("%s</td></tr>", $date_modified);
1949
1950 printf("<tr>\n<td colspan = \"1\">\n");
1951 printf("<br><B>Creator:</b>");
1952 printf("</td><td colspan =\"3\">\n");
1953 printf("<BR>%s</td></tr>", $account_created);
1954 printf("<tr>\n<td colspan = \"1\">\n");
1955 printf("<B>Last Modified by:</b>");
1956 printf("</td><td colspan =\"3\">\n");
1957 printf("%s</td></tr>", $account_modified);
1958 }
1959
1960 // Title
1961 printf("<tr><td colspan =\"1\" >\n");
1962 printf("<br><strong>Title:</strong> ");
1963 printf("</td><td colspan =\"3\">\n");
1964 printf("<br><input type = \"text\" name = \"title\" size = \"60\" value =\"%s\" >", $title);
1965 printf("</td></tr>\n");
1966
1967 // Other Title
1968 printf("<tr><td colspan =\"1\" >\n");
1969 printf("<strong>Other Title:</strong> ");
1970 printf("</td><td colspan =\"3\">\n");
1971 printf("<input type = \"text\" name = \"other_title\" size = \"60\" value =\"%s\" >", $other_title);
1972 printf("</td></tr>\n");
1973
1974 // Author(s)
1975 printf("<tr><td colspan =\"1\" >\n");
1976 printf("<br><strong>Author(s):</strong> ");
1977 printf("</td><td colspan =\"3\">\n");
1978 printf("<br><input type = \"text\" name = \"author\" size = \"60\" value =\"%s\" >", $author);
1979 printf("<br><i>(if applicable)</i></td></tr>\n");
1980
1981 // Coverage detail
1982 printf("<tr><td colspan = \"1\" valign=\"top\">\n");
1983 printf("<strong>Coverage Detail:</strong>");
1984 printf("</td><td colspan =\"3\">\n");
1985 printf("<textarea name = \"coverage_detail\" cols = \"40\" rows = \"2\">");
1986 printf("%s", $coverage_detail);
1987 printf("</textarea>");
1988 printf("<br><i>(enter year, i.e. 1966 - 1985, or 1984 - present)</i>");
1989 printf("<br><br></td></tr>\n");
1990
1991 // Sources Indexed
1992 printf("<tr><td colspan =\"1\" valign=\"top\">\n");
1993 printf("<strong>Sources Indexed:</strong> ");
1994 printf("</td><td colspan =\"3\">\n");
1995 printf("<input type = \"text\" name = \"sources_indexed\" size = \"60\" value =\"%s\" >", $sources_indexed);
1996 printf("<br><i>(enter link to vendor page)</i>");
1997 printf("</td></tr>\n");
1998
1999 // URL
2000 printf("<tr><td colspan = \"1\" valign=\"top\">\n");
2001 printf("<strong>URL</a>:</strong>");
2002 printf("</td><td colspan =\"3\">\n");
2003 printf("<textarea name = \"url\" rows = \"4\" cols = \"51\" >");
2004 printf("%s", $url);
2005 printf("</textarea><br><br><br>\n");
2006 printf("</td></tr>\n");
2007
2008 // Publisher
2009 printf("<tr><td colspan = \"1\" >\n");
2010 printf("<strong>Publisher:</strong> ");
2011 printf("</td><td colspan =\"3\">\n");
2012 printf("<input type = \"text\" name = \"publisher\" size = \"50\" value =\"%s\" >", $publisher);
2013 printf("</td></tr>\n");
2014
2015 // Publish date
2016 printf("<td colspan = \"1\" >\n");
2017 printf("<strong>Publish Date:</strong> ");
2018 printf("</td><td colspan =\"3\">\n");
2019 printf("<input type = \"text\" name = \"pub_date\" size = \"50\" value = \"%s\" >", $pub_date);
2020 printf("</td></tr>\n");
2021
2022 // Edition
2023 printf("<tr><td colspan = \"1\" >\n");
2024 printf("<strong>Edition:</strong> ");
2025 printf("</td><td colspan =\"3\">\n");
2026 printf("<input type = \"text\" name = \"edition\" size = \"20\" value = \"%s\" >", $edition);
2027 printf("</td></tr>\n");
2028
2029 // Library Location / Call number
2030 printf("<td colspan = \"1\" valign=\"top\">\n");
2031 printf("<strong>Library Location and Call No.:</strong> ");
2032 printf("</td><td colspan =\"3\">\n");
2033 printf("<textarea rows=\"4\" cols = \"50\" name = \"call_no\">\n");
2034 printf($call_no);
2035 printf("</textarea></td></tr>\n");
2036
2037 // Catalog Number
2038 printf("<tr><td colspan = \"1\" >\n");
2039 printf("<strong>Aleph No.:</strong> ");
2040 printf("</td><td colspan =\"3\">\n");
2041 printf("<input type = \"text\" name = \"cat_num\" size = \"25\" value = \"%s\" >", $cat_num);
2042 printf("</td></tr>\n");
2043
2044 // Master subject
2045 if ($mastersubject_id > 1 && $mastersubject_id != 2) {
2046 $mastersubject = lookupField($con, "mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");
2047 printf("<tr><td colspan =\"1\" >\n");
2048 printf("<strong>Master subject:</strong> ");
2049 printf("</td><td colspan =\"3\">\n");
2050 printf("%s", $mastersubject);
2051 printf("</td></tr>\n");
2052 }
2053
2054 // Masterinfotype
2055 if ($masterinfotype_id > 1) {
2056 printf("<tr><td colspan = \"1\" >\n");
2057 printf("<strong>Master Information Type:</strong> ");
2058 printf("</td><td colspan =\"3\">\n");
2059 $masterinfotype = lookupField($con, "masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype");
2060 printf("%s", $masterinfotype);
2061 printf("</td></tr>\n");
2062 }
2063
2064 // Drop down box for default information type
2065 printf("<td colspan = \"1\" >\n");
2066 printf("<strong>Base Information Type:</strong>");
2067 printf("</td><td colspan =\"3\">\n");
2068 printf("<select name = \"infotype_id\" >");
2069
2070 $limit = " WHERE infotype_id >= 0 ";
2071
2072 // Limit to a mastersubject's information types
2073 if ($mastersubject_id > 0 && $mastersubject_id != 2) {
2074 $limit .= " AND (mastersubject_id < 3 OR mastersubject_id = " . $mastersubject_id . ")";
2075 }
2076
2077 // Limit to a master information type's information types
2078 if ($masterinfotype_id > 1) {
2079 $limit .= " AND (masterinfotype_id < 2 OR masterinfotype_id = " . $masterinfotype_id . ")";
2080 }
2081
2082 dropDownFieldSelected($con, "infotype", "infotype", "infotype_id", $limit, $infotype_id);
2083 printf("</select>");
2084 printf("</td></tr>\n");
2085
2086
2087 // Annotation
2088 printf("<tr><td colspan = \"4\">\n");
2089 printf("<br><strong><a name=\"additional\">Annotation</a>:</strong><br>");
2090 printf("<textarea name = \"annotation\" rows = \"5\" cols = \"51\" >");
2091 printf("%s", $annotation);
2092 printf("</textarea><br><br><br>\n");
2093
2094 // Buttons
2095
2096 // If this is an existing resource
2097 if ($key_id > 0) {
2098 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateResource\" > ");
2099 printf("<input type = \"Submit\" value = \"Update Resource\" > ");
2100 printf("<input type = \"Hidden\" name = \"key_id\" value = \"%d\" > ", $key_id);
2101 }
2102 // A new resource
2103 else {
2104 printf("<input type = \"Hidden\" name = \"mastersubject_id\" value = \"%d\" > ", $mastersubject_id);
2105 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertResource\" > ");
2106 printf("<input type = \"Submit\" value = \"Save New Resource\" > ");
2107 }
2108
2109 // Common button
2110 printf("<input type = \"Reset\" value = \"Reset\" >\n");
2111
2112 // Close things
2113 printf("</form><br>\n");
2114 printf("</td></tr></table>\n");
2115
2116 // Exterior table
2117 printf("</td></tr></table>\n");
2118
2119 // Other forms - only if editing an existing resource
2120 if ($key_id > 0) {
2121
2122 formAssignResLoc($con, $key_id);
2123 formAssignResFeature($con, $key_id);
2124 formAssignResMastersubject($con, $key_id);
2125
2126 // Offer a delete resource button
2127 printf("<BR>");
2128 printf("<form method=\"POST\" action=\"delete.phtml\">\n");
2129 printf("<input type=\"Hidden\" name=\"transaction\" value=\"deleteResourceConfirm\">\n");
2130 printf("<input type=\"Hidden\" name=\"resource_id\" value=\"%d\">\n", $key_id);
2131 printf("<input type=\"submit\" value=\"Delete Resource!\">\n");
2132 printf("</form>\n");
2133 }
2134
2135 } // No problems
2136 }
2137
2138
2139 /**********************************************************
2140 Function: formService
2141 Author: Paul Bramscher
2142 Last Modified: 07.02.2003
2143 ***********************************************************
2144 Draws an HTML form to edit the supplied service id, or to
2145 create a new service if the incoming id is less than 1.
2146 **********************************************************/
2147 function formService($con, $key_id) {
2148
2149 // Cast as integer to be sure
2150 $key_id = (int) $key_id;
2151
2152 // Check to see if service actually exists
2153 $exists = existsRow($con, "service", "service_id", $key_id);
2154
2155 // Header
2156 printf("<center>");
2157 if ($key_id > 0 && $exists == 1) {
2158
2159 // Initialization
2160 $service = "";
2161 $serviceURL = "";
2162 $serviceDescr = "";
2163 $address1 = "";
2164 $address2 = "";
2165 $address3 = "";
2166 $address4 = "";
2167 $telephone = "";
2168 $fax = "";
2169 $email = "";
2170 $nonaff = "";
2171
2172 // Fetch existing values
2173 $sql = "SELECT * from service where service_id = " . $key_id;
2174 $rs = mysql_query($sql, $con);
2175 $row = mysql_fetch_array ($rs);
2176 $service_id = $row["service_id"];
2177 $service = $row["service"];
2178 $serviceURL = $row["serviceURL"];
2179 $serviceDescr = $row["serviceDescr"];
2180 $address1 = $row["address1"];
2181 $address2 = $row["address2"];
2182 $address3 = $row["address3"];
2183 $address4 = $row["address4"];
2184 $telephone = $row["telephone"];
2185 $fax = $row["fax"];
2186 $email = $row["email"];
2187 $nonaff = $row["nonaff"];
2188
2189 // Run strings through the HTML cleaner for output
2190 $service = textOutHTML($service);
2191 $serviceDescr = textOutHTML($serviceDescr);
2192 $address1 = textOutHTML($address1);
2193 $address2 = textOutHTML($address2);
2194 $address3 = textOutHTML($address3);
2195 $address4 = textOutHTML($address4);
2196
2197 }
2198
2199 // Houston, we have a problem
2200 if ($key_id > 0 && $exists == 0) {
2201 $problem = 1;
2202 printf("<h3>Service #%d Not Found</h3>", $key_id);
2203 }
2204
2205 // If no problems, then go for landing
2206 if ($problem != 1) {
2207
2208 // Table definition
2209 printf("<center><table width=\"75%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
2210
2211 // If new insert
2212 if ($key_id <1) {
2213 printf("<form method = \"POST\" action = \"insert.phtml\" >");
2214 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2215 printf("Enter New Service");
2216 printf("</td></tr>\n");
2217 }
2218
2219 // Else update
2220 else {
2221 printf("<form method = \"POST\" action = \"update.phtml\" >");
2222 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2223 printf("Edit Service: %s (#%d)", $service, $service_id);
2224 printf("</td></tr>\n");
2225 }
2226
2227
2228 // Service Name
2229 printf("<tr>\n");
2230 printf("<td><b>Service Name:</b></td>\n");
2231 printf("<td><input type = \"text\" name = \"service\" size = \"40\" value = \"%s\" ></td>\n", $service);
2232 printf("</tr>\n");
2233
2234 // Description
2235 printf("<tr>\n");
2236 printf("<td colspan=\"2\"><b>Description:</b><br>\n");
2237 printf("<textarea name = \"serviceDescr\" rows = \"5\" cols = \"70\" >");
2238 printf("%s", $serviceDescr);
2239 printf("</textarea><br>\n");
2240 printf("</td></tr>\n");
2241
2242 // URL
2243 printf("<tr>\n");
2244 printf("<td><b>Service URL:</b></td>\n");
2245 printf("<td><input type = \"text\" name = \"serviceURL\" size = \"50\" value = \"%s\" ></td>",
2246 $serviceURL);
2247 printf("</tr>\n");
2248
2249 // Address1
2250 printf("<tr>\n");
2251 printf("<td><b>Address Line 1:</b></td>\n");
2252 printf("<td><input type = \"text\" name = \"address1\" size = \"35\" value = \"%s\" ></td>\n", $address1);
2253 printf("</tr>\n");
2254
2255 // Address2
2256 printf("<tr>\n");
2257 printf("<td><b>Address Line 2:</b></td>\n");
2258 printf("<td><input type = \"text\" name = \"address2\" size = \"35\" value = \"%s\" ></td>\n", $address2);
2259 printf("</tr>\n");
2260
2261 // Address3
2262 printf("<tr>\n");
2263 printf("<td><b>Address Line 3:</b></td>\n");
2264 printf("<td><input type = \"text\" name = \"address3\" size = \"35\" value = \"%s\" ></td>\n", $address3);
2265 printf("</tr>\n");
2266
2267 // Address4
2268 printf("<tr>\n");
2269 printf("<td><b>Address Line 4:</b></td>\n");
2270 printf("<td><input type = \"text\" name = \"address4\" size = \"35\" value = \"%s\" ></td>\n", $address4);
2271 printf("</tr>\n");
2272
2273 // Telephone
2274 printf("<tr>\n");
2275 printf("<td><b>Telephone:</b></td>\n");
2276 printf("<td><input type = \"text\" name = \"telephone\" size = \"25\" value = \"%s\" ></td>\n", $telephone);
2277 printf("</tr>\n");
2278
2279 // Fax
2280 printf("<tr>\n");
2281 printf("<td><b>Fax:</b></td>\n");
2282 printf("<td><input type = \"text\" name = \"fax\" size = \"25\" value = \"%s\" ></td>\n", $fax);
2283 printf("</tr>\n");
2284
2285 // Email
2286 printf("<tr>\n");
2287 printf("<td><b>E-mail Address:</b></td>\n");
2288 printf("<td><input type = \"text\" name = \"email\" size = \"25\" value = \"%s\" ></td>\n",
2289 $email);
2290 printf("</tr>\n");
2291
2292 // Nonaffil
2293 $nonaff_yes = "";
2294 $nonadd_no = "";
2295 if ($nonaff == 1) $nonaff_yes = " CHECKED ";
2296 else $nonaff_no = " CHECKED ";
2297
2298 printf("<tr>\n");
2299 printf("<td><b>Open to Nonaffiliated Users?</b></td>\n");
2300 printf("<td>Yes <input type = \"radio\" name = \"nonaff\" value = \"1\" %s> ", $nonaff_yes);
2301 printf("No <input type = \"radio\" name = \"nonaff\" value = \"0\" %s></td>\n", $nonaff_no);
2302 printf("</tr>\n");
2303
2304 // Buttons
2305 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
2306 // If this is an existing service
2307 if ($key_id > 0) {
2308 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateService\" > ");
2309 printf("<input type = \"Submit\" value = \"Update Service\" > ");
2310 printf("<input type = \"Hidden\" name = \"service_id\" value = \"%d\" > ", $service_id);
2311 }
2312 // Editing a new service
2313 else {
2314 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertService\" > ");
2315 printf("<input type = \"Submit\" value = \"Save New Service\" > ");
2316 }
2317
2318 // Common button
2319 printf("<input type = \"Reset\" value = \"Reset\" >\n");
2320
2321 // Close things
2322 printf("</form>\n");
2323 printf("</td></tr></table></center>\n");
2324
2325 // Change service-location assignments
2326
2327 if ($service_id > 0) {
2328 formAssignServServtype($con, $service_id);
2329 formAssignServLoc($con, $service_id);
2330 }
2331
2332 printf("<BR>\n");
2333
2334 } // No problems
2335 }
2336
2337
2338 /**********************************************************
2339 Function: formStyle
2340 Author: Paul Bramscher
2341 Last Modified: 07.03.2003
2342 ***********************************************************
2343 Draws an HTML form to edit the supplied style id, or to
2344 create a new style if the incoming id is less than 1.
2345
2346 Note that neither this form, nor the SQL insert/update
2347 counterpart functions, do any error checking to see
2348 whether the supplied values for filenames exist, or have
2349 proper permissions. This must be done separately by
2350 someone with OS access.
2351 **********************************************************/
2352 function formStyle($con, $key_id) {
2353
2354 // Cast as integer to be sure
2355 $key_id = (int) $key_id;
2356
2357 // Check to see if feature actually exists
2358 $exists = existsRow($con, "style", "style_id", $key_id);
2359
2360 // Header
2361 printf("<center>");
2362 if ($key_id > 0 && $exists == 1) {
2363
2364 // Initialization
2365 $style_title = "";
2366 $style_id = "";
2367
2368 // Fetch existing values
2369 $sql = "SELECT * from style where style_id = " . $key_id;
2370 $rs = mysql_query($sql, $con);
2371 $row = mysql_fetch_array ($rs);
2372 $style_id = $row["style_id"];
2373 $style_title = $row["style_title"];
2374 $header_file = $row["header_file"];
2375 $footer_file = $row["footer_file"];
2376 $css_file = $row["css_file"];
2377
2378 // Run strings through the HTML cleaner for output
2379 $style_title = textOutHTML($style_title);
2380 $header_file = textOutHTML($header_file);
2381 $footer_file = textOutHTML($footer_file);
2382 $css_file = textOutHTML($css_file);
2383 }
2384
2385 // Houston, we have a problem
2386 if ($key_id > 0 && $exists == 0) {
2387 $problem = 1;
2388 printf("<h3>Style #%d Not Found</h3>", $key_id);
2389 }
2390
2391 // If no problems, then go for landing
2392 if ($problem != 1) {
2393
2394 // Table definition
2395 printf("<center><table width=\"75%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
2396
2397 // If new insert
2398 if ($key_id <1) {
2399 printf("<form method = \"POST\" action = \"insert.phtml\" >");
2400 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2401 printf("Enter New Style");
2402 printf("</td></tr>\n");
2403 }
2404
2405 // Else update
2406 else {
2407 printf("<form method = \"POST\" action = \"update.phtml\" >");
2408 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2409 printf("Edit Style: %s (#%d)", $style, $style_id);
2410 printf("</td></tr>\n");
2411 }
2412
2413 // Style Title
2414 printf("<tr>\n");
2415 printf("<td><b>Style Title:</b></td>\n");
2416 printf("<td><input type = \"text\" name = \"style_title\" size = \"40\" value = \"%s\" ></td>\n", $style_title);
2417 printf("</tr>\n");
2418
2419 // Header File
2420 printf("<tr>\n");
2421 printf("<td><b>Header File:</b></td>\n");
2422 printf("<td><input type = \"text\" name = \"header_file\" size = \"60\" value = \"%s\" ></td>\n", $header_file);
2423 printf("</tr>\n");
2424
2425 // Footer File
2426 printf("<tr>\n");
2427 printf("<td><b>Footer File:</td>\n");
2428 printf("<td><input type = \"text\" name = \"footer_file\" size = \"60\" value = \"%s\" ></td>\n", $footer_file);
2429 printf("</tr>\n");
2430
2431 // CSS File
2432 printf("<tr>\n");
2433 printf("<td><b>CSS File:</b></td>\n");
2434 printf("<td><input type = \"text\" name = \"css_file\" size = \"60\" value = \"%s\" ></td>\n", $css_file);
2435 printf("</tr>\n");
2436
2437 // Buttons
2438 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
2439 // If this is an existing style
2440 if ($key_id > 0) {
2441 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateStyle\" > ");
2442 printf("<input type = \"Submit\" value = \"Update Style\" > ");
2443 printf("<input type = \"Hidden\" name = \"style_id\" value = \"%d\" > ", $style_id);
2444 }
2445 // Editing a new style
2446 else {
2447 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertStyle\" > ");
2448 printf("<input type = \"Submit\" value = \"Save New Style\"> ");
2449 }
2450
2451 // Common button
2452 printf("<input type = \"Reset\" value = \"Reset\" >\n");
2453
2454 // Close things
2455 printf("</form>\n");
2456 printf("<br></td></tr></table></center>\n");
2457
2458 } // No problems
2459 }
2460
2461
2462 /**********************************************************
2463 Function: formSubject
2464 Author: Paul Bramscher
2465 Last Modified: 06.25.2003
2466 ***********************************************************
2467 Draws an HTML form to edit the supplied subject id, or to
2468 create a new subject if the incoming id is less than 1.
2469 **********************************************************/
2470 function formSubject($con, $key_id) {
2471
2472 // Cast as integer to be sure
2473 $key_id = (int) $key_id;
2474
2475 // Check to see if location actually exists
2476 $exists = existsRow($con, "subject", "subject_id", $key_id);
2477
2478 // Header
2479 printf("<center>");
2480 if ($key_id > 0 && $exists == 1) {
2481
2482 // Initialization
2483 $subject = "";
2484 $subject_id = "";
2485 $sublocation_id = "";
2486
2487 // If the user is editing an existing record, fetch previous values
2488 $sql = "SELECT * from subject where subject_id = " . $key_id;
2489 $rs = mysql_query($sql, $con);
2490 $row = mysql_fetch_array ($rs);
2491
2492 // Fetch existing values
2493 $subject_id = $row["subject_id"];
2494 $subject = $row["subject"];
2495 $sublocation_id = $row["sublocation_id"];
2496 $subject_descr = $row["subject_descr"];
2497
2498 // Run strings through the HTML cleaner for output
2499 $subject = textOutHTML($subject);
2500 }
2501
2502 // Houston, we have a problem
2503 if ($key_id > 0 && $exists == 0) {
2504 $problem = 1;
2505 printf("<h3>Subject #%d Not Found</h3>", $key_id);
2506 }
2507
2508 // If no problems, then go for landing
2509 if ($problem != 1) {
2510
2511 // Table definition
2512 printf("<center><table width=\"75%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\">\n");
2513
2514 // If new insert
2515 if ($key_id <1) {
2516 printf("<form method = \"POST\" action = \"insert.phtml\" >");
2517 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2518 printf("Enter New Subject");
2519 printf("</td></tr>\n");
2520 }
2521
2522 // Else update
2523 else {
2524 printf("<form method = \"POST\" action = \"update.phtml\" >");
2525 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2526 printf("Update Subject: %s (#%d)", $subject, $subject_id);
2527 printf("</td></tr>\n");
2528 }
2529
2530 // Subject
2531 printf("<tr><td>\n");
2532 printf("<b>Subject:</b>");
2533 printf("</td>\n");
2534 printf("<td>\n");
2535 printf("<input type = \"text\" name = \"subject\" size = \"65\" value = \"%s\" >", $subject);
2536 printf("</td></tr>\n");
2537
2538 // Primary location
2539 printf("<tr>\n");
2540 printf("<td><b>Primary Location:</b></td>\n");
2541 printf("<td>\n");
2542 printf("<select name = \"sublocation_id\">");
2543 dropDownFieldSelected($con, "location", "location", "location_id", "WHERE location_id > 0", $sublocation_id);
2544 printf("</select>\n");
2545 printf("</td></tr>\n");
2546
2547 // Description
2548 printf("<tr>\n");
2549 printf("<td colspan=\"2\">\n");
2550 printf("<b>Description:</b><br>");
2551 printf("<textarea name = \"subject_descr\" rows = \"5\" cols = \"65\" >");
2552 printf("%s", $subject_descr);
2553 printf("</textarea></td></tr>\n");
2554
2555 // Buttons
2556 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
2557
2558 // If this is an existing subject
2559 if ($key_id > 0) {
2560 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateSubject\" > ");
2561 printf("<input type = \"Submit\" value = \"Update Subject\" > ");
2562 printf("<input type = \"Hidden\" name = \"subject_id\" value = \"%d\" > ", $subject_id);
2563 }
2564 // Editing a new subject
2565 else {
2566 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertSubject\" > ");
2567 printf("<input type = \"Submit\" value = \"Save New Subject\" > ");
2568 }
2569
2570 // Common button
2571 printf("<input type = \"Reset\" value = \"Reset\" >\n");
2572
2573 // Close things
2574 printf("</form>\n");
2575 printf("</td></tr></table></center>\n");
2576
2577 // Change subject-location assignments
2578
2579 if ($subject_id > 0) {
2580 formAssignSubMaster($con, $subject_id);
2581 formAssignSubLoc($con, $subject_id);
2582 formAssignSubStaff($con, $subject_id);
2583 formAssignSubCoursesub($con, $subject_id);
2584 }
2585
2586 } // No problems
2587
2588 printf("<BR>\n");
2589 }
2590
2591
2592
2593 /**********************************************************
2594 Function: formAssignLibunitStaff
2595 Author: Paul Bramscher
2596 Last Modified: 07.03.2003
2597 ***********************************************************
2598 Purpose:
2599 Assigns staff (possibly multiple) to a given library unit.
2600 **********************************************************/
2601 function formAssignLibunitStaff($con, $libunit_id){
2602
2603 // Table definition
2604 printf("<br><table width=\"60%%\" border=\"1\" cellpadding=\"4\" class=\"backLight\" bgcolor =\"#ffffff\" >");
2605
2606 // Form
2607 printf("<form method = \"POST\" action = \"assign.phtml\" >");
2608 printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >", $libunit_id);
2609 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignLibunitStaff\" >");
2610
2611 // Available staff
2612 // Omit the '(N/A)' staff
2613 $omit_string = "WHERE staff_id > 1";
2614
2615 // Omit any pre-selected staff in libunit_staff
2616 $in_string = getNotIn($con, "staff_id", "libunit_id", $libunit_id, "libunit_staff");
2617 if (strlen($in_string) > 0) $omit_string .= " AND staff_id NOT IN " . $in_string;
2618
2619 // Draw the box
2620 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2621 printf("Assign Staff to Library Unit");
2622 printf("</td></tr>\n");
2623 printf("<tr><td valign = \"top\" >\n");
2624 printf("<br><strong>Available Staff:<br></strong>\n");
2625 printf("<select name = \"staff_id_array[]\" multiple size = \"5\" >");
2626 dropDownStaffOmit($con, $omit_string);
2627 printf("</select><br><br>");
2628
2629 // Close off form
2630 printf("<center>");
2631 printf("<input type = \"Submit\" value = \" >> \" >");
2632 printf("</form>");
2633 printf("</center>");
2634 printf("</td>");
2635
2636 // Current staff
2637 printf("<td valign = \"top\" >\n");
2638 printf("<form method = \"POST\" action = \"delete.phtml\" >");
2639 printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >", $libunit_id);
2640 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteLibunitStaff\" >");
2641 printf("<br><strong>Selected Staff:</strong><br>\n");
2642 printf("<select name =\"key_list_array[]\" multiple size = 5>");
2643
2644 $sql = "SELECT s.staff_id, s.last_name, s.first_name FROM
2645 staff s,
2646 libunit_staff ls
2647 WHERE
2648 ls.libunit_id = " . $libunit_id . " AND
2649 s.staff_id = ls.staff_id
2650 ORDER BY last_name, first_name";
2651
2652 // Fetch the values
2653 $rs = mysql_query($sql, $con);
2654 while ($row = mysql_fetch_array ($rs)) {
2655 $first_name = $row["first_name"];
2656 $last_name = $row["last_name"];
2657 $staff_id = $row["staff_id"];
2658 printf("<option value = \"%d\">%s, %s</option>", $staff_id, $last_name, $first_name);
2659 }
2660
2661 printf("</select><br><br>");
2662 printf("<center>");
2663 printf("<input type = \"Submit\" value =\" << \">");
2664 printf("</center>");
2665 printf("</form>");
2666 printf("</td></tr>");
2667
2668 // Close off table
2669 printf("</td></tr></table>");
2670
2671 }
2672
2673
2674 /**********************************************************
2675 Function: formAssignStaffLibunit
2676 Author: Paul Bramscher
2677 Last Modified: 07.03.2003
2678 ***********************************************************
2679 Purpose:
2680 Assigns library units (possibly multiple) to a given
2681 staffperson.
2682 **********************************************************/
2683 function formAssignStaffLibunit($con, $staff_id){
2684
2685 // Table definition
2686 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >");
2687
2688 // Form
2689 printf("<form method = \"POST\" action = \"assign.phtml\" >");
2690 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
2691 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignStaffLibunit\" >");
2692
2693 // Available libunits
2694 // Omit the '(N/A)' libunit
2695 $omit_string = "WHERE libunit_id > 1";
2696
2697 // Omit any pre-selected libunits in libunit_staff
2698 $in_string = getNotIn($con, "libunit_id", "staff_id", $staff_id, "libunit_staff");
2699 if (strlen($in_string) > 0) $omit_string .= " AND libunit_id NOT IN " . $in_string;
2700
2701 // Draw the box
2702 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2703 printf("Assign Library Unit to Staff");
2704 printf("</td></tr>\n");
2705 printf("<tr><td valign = \"top\" >\n");
2706 printf("<br><strong>Available Library Unit(s):<br></strong>\n");
2707 printf("<select name = \"libunit_id_array[]\" multiple size = \"5\" >");
2708 dropDownFieldOmit($con, "libunit", "libunit", "libunit_id", $omit_string);
2709 printf("</select><br><br>");
2710
2711 // Close off form
2712 printf("<center>");
2713 printf("<input type = \"Submit\" value = \" >> \" >");
2714 printf("</form>");
2715 printf("</center>");
2716 printf("</td>");
2717
2718 // Current libunits
2719 printf("<td valign = \"top\" >\n");
2720 printf("<form method = \"POST\" action = \"delete.phtml\" >");
2721 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
2722 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteStaffLibunit\" >");
2723 printf("<br><strong>Selected Library Unit(s):</strong><br>\n");
2724 printf("<select name =\"key_list_array[]\" multiple size = 5>");
2725
2726 $sql = "SELECT l.libunit, l.libunit_id FROM
2727 staff s,
2728 libunit_staff ls,
2729 libunit l
2730 WHERE
2731 s.staff_id = " . $staff_id . " AND
2732 ls.staff_id = s.staff_id AND
2733 ls.libunit_id = l.libunit_id
2734 ORDER BY l.libunit";
2735
2736 // Fetch the values
2737 $rs = mysql_query($sql, $con);
2738 while ($row = mysql_fetch_array ($rs)) {
2739 $libunit = $row["libunit"];
2740 $libunit_id = $row["libunit_id"];
2741 printf("<option value = \"%s\">%s</option>", $libunit_id, $libunit);
2742 }
2743
2744 printf("</select><br><br>");
2745 printf("<center>");
2746 printf("<input type = \"Submit\" value =\" << \">");
2747 printf("</center>");
2748 printf("</form>");
2749 printf("</td></tr>");
2750
2751 // Close off table
2752 printf("</td></tr></table>");
2753
2754 }
2755
2756
2757 /**********************************************************
2758 Function: formAssignStaffSub
2759 Author: Paul Bramscher
2760 Last Modified: 08.26.2003
2761 ***********************************************************
2762 Purpose:
2763 Assigns subjects (possibly multiple) to a given
2764 staffperson.
2765 **********************************************************/
2766 function formAssignStaffSub($con, $staff_id){
2767
2768 // Table definition
2769 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\" >\n");
2770
2771 // Form
2772 printf("<form method = \"POST\" action = \"assign.phtml\" >\n");
2773 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
2774 printf("<input type = \"Hidden\" name = \"transaction\" value = \"assignStaffSub\" >\n");
2775
2776 // Available subjects
2777 // Omit the '(N/A)' subject
2778 $omit_string = "WHERE subject_id > 1";
2779
2780 // Omit any pre-selected subjects in sub_staff
2781 $in_string = getNotIn($con, "subject_id", "staff_id", $staff_id, "sub_staff");
2782 if (strlen($in_string) > 0) $omit_string .= " AND subject_id NOT IN " . $in_string;
2783
2784 // Draw the box
2785 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2786 printf("Assign Subjects");
2787 printf("</td></tr>\n");
2788 printf("<tr><td valign = \"top\" >\n");
2789 printf("<br><strong>Available Subject(s):<br></strong>\n");
2790 printf("<select name = \"subject_id_array[]\" multiple size = \"5\" >\n");
2791 dropDownFieldOmit($con, "subject", "subject", "subject_id", $omit_string);
2792 printf("</select><br><br>\n");
2793
2794 // Close off form
2795 printf("<center>\n");
2796 printf("<input type = \"Submit\" value = \" >> \" >\n");
2797 printf("</form>\n");
2798 printf("</center>\n");
2799 printf("</td>\n");
2800
2801 // Current subjects
2802 printf("<td valign = \"top\" >\n");
2803 printf("<form method = \"POST\" action = \"delete.phtml\" >\n");
2804 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
2805 printf("<input type = \"Hidden\" name = \"transaction\" value = \"deleteStaffSub\" >\n");
2806 printf("<br><strong>Selected Subject(s):</strong><br>\n");
2807 printf("<select name =\"key_list_array[]\" multiple size = 5>\n");
2808
2809 $sql = "SELECT s.subject, s.subject_id FROM
2810 staff t,
2811 sub_staff st,
2812 subject s
2813 WHERE
2814 t.staff_id = " . $staff_id . " AND
2815 st.staff_id = t.staff_id AND
2816 st.subject_id = s.subject_id
2817 ORDER BY s.subject";
2818
2819 // Fetch the values
2820 $rs = mysql_query($sql, $con);
2821 while ($row = mysql_fetch_array ($rs)) {
2822 $subject = $row["subject"];
2823 $subject_id = $row["subject_id"];
2824 printf("<option value = \"%s\">%s</option>\n", $subject_id, $subject);
2825 }
2826
2827 printf("</select><br><br>\n");
2828 printf("<center>\n");
2829 printf("<input type = \"Submit\" value =\" << \">\n");
2830 printf("</center>\n");
2831 printf("</form>\n");
2832 printf("</td></tr>\n");
2833
2834 // Close off table
2835 printf("</td></tr></table>\n");
2836
2837 }
2838
2839
2840 /**********************************************************
2841 Function: formLibunit
2842 Author: Paul Bramscher
2843 Last Modified: 07.03.2003
2844 ***********************************************************
2845 Purpose:
2846 Handles the creation of new (or editing of existing)
2847 library units.
2848 **********************************************************/
2849 function formLibunit($con, $key_id){
2850
2851 // Initialize variables
2852 $libunit_id = (int) $key_id;
2853 $libunit ="";
2854 $libunit_abbrev = "";
2855
2856 // If editing an existing library unit load previous values
2857 if ($libunit_id > 1){
2858 $sql = "SELECT
2859 l.libunit,
2860 l.libunit_abbrev,
2861 l.head_staff_id
2862 FROM libunit l
2863 WHERE
2864 libunit_id = " . $libunit_id;
2865
2866 $rs = mysql_query($sql, $con);
2867 $row = mysql_fetch_array($rs);
2868
2869 // Fetch values
2870 $libunit = Trim($row["libunit"]);
2871 $libunit_abbrev = Trim($row["libunit_abbrev"]);
2872 $head_staff_id = $row["head_staff_id"];
2873
2874 // Run strings through the HTML cleaner for output
2875 $libunit = textOutHTML($libunit);
2876 $libunit_abbrev = textOutHTML($libunit_abbrev);
2877
2878 }
2879
2880 // Table definition
2881 printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
2882
2883 // If new insert
2884 if ($key_id <1) {
2885 printf("<form method = \"POST\" action = \"insert.phtml\" >");
2886 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2887 printf("Enter New Library Unit");
2888 printf("</td></tr>\n");
2889 }
2890
2891 // Else update
2892 else {
2893 printf("<form method = \"POST\" action = \"update.phtml\" >");
2894 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2895 printf("Edit Library Unit: %s (#%d)", $libunit, $libunit_id);
2896 printf("</td></tr>\n");
2897 }
2898
2899 // Libunit
2900 printf("<td><b>Library Unit:</b></td>\n");
2901 printf("<td><input type = \"text\" name = \"libunit\" size = \"60\" value = \"%s\" ></td>\n", $libunit);
2902 printf("</td></tr>");
2903
2904 // Libunit abbrev.
2905 printf("<tr>\n");
2906 printf("<td><b>Abbreviation:</b></td>\n");
2907 printf("<td><input type = \"text\" name = \"libunit_abbrev\" size = \"20\" value = \"%s\"></td>\n", $libunit_abbrev);
2908 printf("</tr>\n");
2909
2910 // Libunit lead
2911 printf("<tr>\n");
2912 printf("<td><b>Unit Lead:</b></td>\n");
2913 printf("<td><select name = \"head_staff_id\" >");
2914 dropDownStaffSelected($con, $head_staff_id);
2915 printf("</select></td>\n");
2916 printf("</tr>\n");
2917
2918 // Buttons
2919 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
2920
2921 // If new libunit
2922 if ($libunit_id < 2) {
2923 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertLibunit\" >");
2924 printf("<input type = \"Submit\" value = \"Save New Library Unit\" > ");
2925 }
2926 // Editing an existing libunit
2927 else {
2928 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateLibunit\" >");
2929 printf("<input type = \"Hidden\" name = \"libunit_id\" value = \"%d\" >", $libunit_id);
2930 printf("<input type = \"Submit\" value = \"Save Library Unit Changes\" > ");
2931 }
2932 printf("<input type = \"Reset\" value = \"Reset\" >");
2933
2934 // Close the form and table
2935 printf("</form>");
2936 printf("</td></tr></table>");
2937
2938 // Other forms - only if editing an existing libunit
2939
2940 if ($libunit_id > 0) {
2941 formAssignLibunitStaff($con, $libunit_id);
2942 }
2943
2944 printf("</center><br>");
2945 }
2946
2947
2948 /**********************************************************
2949 Function: formPassword
2950 Author: Paul Bramscher
2951 Last Modified: 07.03.2003
2952 ***********************************************************
2953 Purpose:
2954 Creates a new password for the supplied staff id. Note
2955 that this is a locally stored (in mySQL) and encrypted
2956 password. It is never visible in plaintext, nor is it
2957 ever brought to an HTML form, neither in plaintext nor
2958 in a "password" type HTML form field.
2959 **********************************************************/
2960 function formPassword($con, $staff_id){
2961
2962 /*****************************************
2963 ** If using native mySQL authentication **
2964 *****************************************/
2965
2966 // Table definition
2967 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">");
2968
2969 // Form
2970 printf("<form method = \"POST\" action = \"update.phtml\" >");
2971 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
2972 printf("Local Authentication Password - See Note Below");
2973 printf("</td></tr>\n");
2974
2975 // Staff password - for mySQL authentication only. Ignored if x500 account is present.
2976 printf("<tr><td colspan=\"2\">\n");
2977 printf("<b>Note:</b> Supply if utilizing mySQL authentication, otherwise leave blank. ");
2978 printf("This will replace the password (if any) currently assigned to this account.");
2979 printf("</td></tr>\n");
2980
2981 // First type
2982 printf("<tr>\n");
2983 printf("<td><b>New Password (6 char. minimum):</b></td>\n");
2984 printf("<td><input type = \"password\" name = \"password\" size = \"25\"></td>\n");
2985 printf("</tr>\n");
2986
2987 // Confirm type
2988 printf("<tr>\n");
2989 printf("<td><b>Confirm password (type again):</b></td>\n");
2990 printf("<td><input type = \"password\" name = \"password_confirm\" size = \"25\"></td>\n");
2991 printf("</tr>\n");
2992
2993 // Buttons
2994 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
2995 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >\n", $staff_id);
2996 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updatePassword\" >\n");
2997 printf("<input type = \"Submit\" value = \"Save Local Password\" > ");
2998
2999 // Close the form and table
3000 printf("</form>\n");
3001 printf("</td></tr></table>\n");
3002
3003
3004 /*******************************************
3005 ** Determine if a password already exists **
3006 *******************************************/
3007
3008
3009 // Initialize variables
3010 $pass_set = 0;
3011
3012 // Determine whether a password exists
3013 $sql = "SELECT COUNT(*) as pass_set
3014 FROM staff s
3015 WHERE s.password IS NOT NULL and staff_id = " . $staff_id;
3016
3017 $rs = mysql_query($sql, $con);
3018 $row = mysql_fetch_array($rs);
3019
3020 // Fetch values
3021 $pass_set = Trim($row["pass_set"]);
3022
3023
3024 // If some password already exists, offer this form
3025 if ($pass_set > 0) {
3026
3027 // Table definition
3028 printf("<br><table width=\"60%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">");
3029
3030 // Form
3031 printf("<tr><td class=\"cellPlain\">");
3032 printf("Local Password Found");
3033 printf("</td></tr>\n");
3034 printf("<form method = \"POST\" action = \"update.phtml\" >");
3035
3036 // Purge existing password
3037 printf("<tr><td>\n");
3038 printf("<br><b>Purge password to null?</b><br><br>\n");
3039 printf("<b>Note:</b> It appears that this account currently has a password assigned to it.");
3040 printf("This option will clear out any existing password, and leave the value NULL.");
3041 printf("The staffperson may not login until a new password is supplied.<br><br>\n");
3042
3043 // Buttons
3044 printf("<center>\n");
3045 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
3046 printf("<input type = \"Hidden\" name = \"transaction\" value = \"purgePassword\" >");
3047 printf("<input type = \"Submit\" value = \"Purge Password!\" > ");
3048
3049 // Close the form and table
3050 printf("</form>");
3051 printf("</center></td></tr></table><br>\n");
3052
3053 } // end password purge form
3054
3055 } // end function
3056
3057
3058 /**********************************************************
3059 Function: formStaff
3060 Author: Paul Bramscher
3061 Last Modified: 07.03.2003
3062 ***********************************************************
3063 Purpose:
3064 Form to create a new staff person, or update the existing
3065 staff id.
3066 **********************************************************/
3067 function formStaff($con, $staff_id){
3068
3069 // Initialize variables
3070 $staff_id = (int) $staff_id;
3071 $last_name ="";
3072 $first_name = "";
3073 $staff_account = "";
3074 $staff_email = "";
3075 $password = "";
3076 $access = "";
3077 $access_id = 1;
3078
3079 // If editing an existing staff member load previous values
3080 if ($staff_id > 1){
3081 $sql = "SELECT
3082 s.first_name,
3083 s.last_name,
3084 s.staff_account,
3085 s.staff_email,
3086 s.access_id,
3087 t.stafftitle,
3088 t.stafftitle_id,
3089 a.access_id,
3090 a.access_level,
3091 a.access
3092 FROM staff s, access a, stafftitle t
3093 WHERE
3094 s.access_id = a.access_id AND
3095 s.stafftitle_id = t.stafftitle_id AND
3096 staff_id=" . $staff_id;
3097
3098 $rs = mysql_query($sql, $con);
3099 $row = mysql_fetch_array($rs);
3100
3101 // Fetch results
3102 $first_name = Trim($row["first_name"]);
3103 $last_name = Trim($row["last_name"]);
3104 $staff_account = Trim($row["staff_account"]);
3105 $staff_email = Trim($row["staff_email"]);
3106 $access = Trim($row["access"]);
3107 $access_id = Trim($row["access_id"]);
3108 $stafftitle = Trim($row["stafftitle"]);
3109 $stafftitle_id = Trim($row["stafftitle_id"]);
3110
3111 // Run strings through the HTML cleaner for output
3112 $first_name = textOutHTML($first_name);
3113 $last_name = textOutHTML($last_name);
3114 $staff_account = textOutHTML($staff_account);
3115
3116 }
3117
3118
3119 // Table definition
3120 printf("<center><table width=\"75%%\" border=\"1\" class=\"backLight\" cellpadding=\"4\">\n");
3121
3122 // If new insert
3123 if ($staff_id <1) {
3124 printf("<form method = \"POST\" action = \"insert.phtml\" >");
3125 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
3126 printf("Enter New Staff Person");
3127 printf("</td></tr>\n");
3128 }
3129
3130 // Else update
3131 else {
3132 printf("<form method = \"POST\" action = \"update.phtml\" >");
3133 printf("<tr><td colspan=\"2\" class=\"cellPlain\">\n");
3134 printf("Edit Staff Person: %s %s (#%d)", $first_name, $last_name, $staff_id);
3135 printf("</td></tr>\n");
3136 }
3137
3138 // Last name
3139 printf("<tr>\n");
3140 printf("<td><b>Last Name:</b></td>\n");
3141 printf("<td><input type = \"text\" name = \"last_name\" size = \"40\" value = \"%s\" ></td>\n", $last_name);
3142 printf("</tr>\n");
3143
3144 // First name
3145 printf("<tr>\n");
3146 printf("<td><b>First Name:</b></td>\n");
3147 printf("<td><input type = \"text\" name = \"first_name\" size = \"30\" value = \"%s\"></td>\n", $first_name);
3148 printf("</tr>\n");
3149
3150 // staff account - must be unique, may match against staff_account
3151 printf("<tr>\n");
3152 printf("<td><b>Staff Account (x500 if applicable, 20 char max.):</b></td>");
3153 printf("<td><input type = \"text\" name = \"staff_account\" size = \"20\" value =\"%s\"></td>\n", $staff_account);
3154 printf("</tr>\n");
3155
3156 // Staff email - whether or not x500 authentication is used
3157 printf("<tr>\n");
3158 printf("<td><b>Staff E-Mail:</b></td>\n");
3159 printf("<td><input type = \"text\" name = \"staff_email\" size = \"50\" value =\"%s\"></td>\n", $staff_email);
3160 printf("</tr>\n");
3161
3162 // Title
3163 printf("<tr>\n");
3164 printf("<td><b>Job Title:</b></td>\n");
3165 printf("<td><select name = \"stafftitle_id\">");
3166 dropDownFieldSelected($con, "stafftitle", "stafftitle", "stafftitle_id", "WHERE stafftitle_id > 0", $stafftitle_id);
3167 printf("</select></td>\n");
3168 printf("</tr>\n");
3169
3170 // Access
3171 printf("<tr>\n");
3172 printf("<td><b>Access Level:</b></td>\n");
3173 printf("<td><select name = \"access_id\">\n");
3174 dropDownFieldSelected($con, "access", "access", "access_id", "WHERE access_id > 0", $access_id);
3175 printf("</select></td>\n");
3176 printf("</tr>\n");
3177
3178 // Buttons
3179 printf("<tr><td colspan=\"2\" align=\"center\"><br>\n");
3180
3181 // If new staff
3182 if ($staff_id < 2) {
3183 printf("<input type = \"Hidden\" name = \"transaction\" value = \"insertStaff\" >");
3184 printf("<input type = \"Submit\" value = \"Save New Staff\" > ");
3185 }
3186 // Editing an existing staffperson
3187 else {
3188 printf("<input type = \"Hidden\" name = \"transaction\" value = \"updateStaff\" >");
3189 printf("<input type = \"Hidden\" name = \"staff_id\" value = \"%d\" >", $staff_id);
3190 printf("<input type = \"Submit\" value = \"Save Staff Changes\" > ");
3191 }
3192 printf("<input type = \"Reset\" value = \"Reset\" >\n");
3193
3194 // Close the form and table
3195 printf("</form>\n");
3196
3197 printf("</td></tr></table>\n");
3198
3199 // If editing existing staff, draw other forms
3200 if ($staff_id > 0) {
3201 formPassword($con, $staff_id);
3202 formAssignStaffLibunit($con, $staff_id);
3203 formAssignStaffSub($con, $staff_id);
3204 }
3205
3206 printf("</center><br>\n");
3207 }
3208 ?>
  ViewVC Help
Powered by ViewVC 1.1.26