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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1 - (show annotations)
Fri Dec 5 18:34:18 2003 UTC (20 years, 3 months ago) by dpavlin
File size: 18231 byte(s)
Initial revision

1 <?php
2 /**********************************************************
3 Function Library: assign.php
4 Original Author: Paul Bramscher <brams006@tc.umn.edu>
5 Last Modified: 06.17.2003 by Paul Bramscher
6 ***********************************************************
7 Comments:
8 This library brings together all SQL assignment type
9 functions.
10 ***********************************************************
11 Table of Contents:
12
13 Handling bridging tables
14 ========================
15 assignResFeature
16 assignResLoc
17 assignResMastersubject
18 assignServLoc
19 assignServServtype
20 assignSubCoursesub
21 assignSubLoc
22 assignSubMaster
23 assignSubStaff
24
25
26 assignLibunitStaff
27 assignStaffLibunit
28 assignStaffSub
29
30
31 **********************************************************/
32
33
34 /**********************************************************
35 Function: assignResFeature
36 Author: Paul Bramscher
37 Last Modified: 04.21.2003
38 ***********************************************************
39 Purpose:
40 Assigns features (possibly multiple) to a given resource
41 and calls formResource back again.
42 **********************************************************/
43 function assignResFeature($con, $feature_id_array, $resource_id) {
44
45 // For all features in the array
46 for ($subscript = 0; $subscript < sizeof($feature_id_array); $subscript++ ) {
47
48 // Check to make sure that the feature isn't already assigned
49 $sql = "SELECT * FROM res_feature WHERE resource_id = "
50 . $resource_id
51 . " AND feature_id = "
52 . $feature_id_array[$subscript];
53
54 $rs = mysql_query($sql);
55 if (mysql_num_rows($rs) == 0) {
56
57 $sql = "INSERT INTO res_feature (resource_id, feature_id) VALUES ("
58 . $resource_id
59 . ", "
60 . $feature_id_array[$subscript]
61 . ")";
62
63 if (!mysql_query($sql, $con)){
64 sql_err($con);
65 mysql_query ("UNLOCK TABLES", $con);
66 bailout();
67 } // bad write
68 else {
69 mysql_query("UNLOCK TABLES", $con);
70
71 } // good write of res_feature
72
73 } // feature not already assigned
74
75 } // array of feature id's
76
77 // Call the resource form back
78 formResource($con, $resource_id, 0, 0, '');
79
80 } // function
81
82
83 /**********************************************************
84 Function: assignResLoc
85 Author: Paul Bramscher
86 Last Modified: 04.21.2003
87 ***********************************************************
88 Purpose:
89 Assigns locations (possibly multiple) to a given resource
90 and calls formResource back again.
91 **********************************************************/
92 function assignResLoc($con, $location_id_array, $resource_id) {
93
94 // For every location in the array
95 for ($subscript = 0; $subscript < sizeof($location_id_array); $subscript++ ) {
96
97 // Check to make sure that the location isn't already assigned
98 $sql = "SELECT * FROM res_loc WHERE resource_id = "
99 . $resource_id
100 . " AND location_id = "
101 . $location_id_array[$subscript];
102
103 $rs = mysql_query($sql);
104 if (mysql_num_rows($rs) == 0) {
105
106 $sql = "INSERT INTO res_loc (resource_id, location_id) VALUES ("
107 . $resource_id
108 . ", "
109 . $location_id_array[$subscript]
110 . ")";
111
112 if (!mysql_query($sql, $con)){
113 sql_err($con);
114 mysql_query ("UNLOCK TABLES", $con);
115 bailout();
116 } // bad write
117
118 else {
119 mysql_query("UNLOCK TABLES", $con);
120
121 } // good write of res_loc
122 } // location not already assigned
123
124 } // array of location id's
125
126 // Call the resource form back
127 formResource($con, $resource_id, 0, 0, '');
128
129 } // function
130
131
132 /**********************************************************
133 Function: assignResMastersubject
134 Author: Paul Bramscher
135 Last Modified: 04.21.2003
136 ***********************************************************
137 Purpose:
138 Assigns master subjects (possibly multiple) to a given
139 resource and calls formResource back again.
140 **********************************************************/
141 function assignResMastersubject($con, $mastersubject_id_array, $resource_id) {
142
143 // For every location in the array
144 for ($subscript = 0; $subscript < sizeof($mastersubject_id_array); $subscript++ ) {
145
146 // Check to make sure that the masterinfotype isn't already assigned
147 $sql = "SELECT * FROM res_mastersubject WHERE resource_id = "
148 . $resource_id
149 . " AND mastersubject_id = "
150 . $mastersubject_id_array[$subscript];
151
152 $rs = mysql_query($sql);
153 if (mysql_num_rows($rs) == 0) {
154
155 $sql = "INSERT INTO res_mastersubject (resource_id, mastersubject_id) VALUES ("
156 . $resource_id
157 . ", "
158 . $mastersubject_id_array[$subscript]
159 . ")";
160
161 if (!mysql_query($sql, $con)){
162 sql_err($con);
163 mysql_query ("UNLOCK TABLES", $con);
164 bailout();
165 } // bad write
166
167 else {
168 mysql_query("UNLOCK TABLES", $con);
169
170 } // good write of res_mastersubject
171 } // mastersubject not already assigned
172
173 } // array of mastersubject id's
174
175 // Call the resource form back
176 formResource($con, $resource_id, 0, 0, '');
177
178 } // function
179
180
181 /**********************************************************
182 Function: assignServLoc
183 Author: Paul Bramscher
184 Last Modified: 04.21.2003
185 ***********************************************************
186 Purpose:
187 Assigns locations (possibly multiple) to a given service
188 and calls formService back again.
189 **********************************************************/
190 function assignServLoc($con, $location_id_array, $service_id) {
191
192 // For every location, assign it to the selected service
193 for ($subscript = 0; $subscript < sizeof($location_id_array); $subscript++ ) {
194
195 // Check to make sure that the location isn't already assigned
196 $sql = "SELECT * FROM serv_loc where service_id = "
197 . $service_id
198 . " AND location_id = "
199 . $location_id_array[$subscript];
200
201 $rs = mysql_query($sql);
202 if (mysql_num_rows($rs) == 0) {
203
204 $sql = "INSERT INTO serv_loc (service_id, location_id) VALUES ("
205 . $service_id
206 . ", "
207 . $location_id_array[$subscript]
208 . ")";
209
210 if (!mysql_query($sql, $con)){
211 sql_err($con);
212 mysql_query ("UNLOCK TABLES", $con);
213 bailout();
214 } // bad write
215 else {
216 mysql_query("UNLOCK TABLES", $con);
217
218 } // good write of serv_loc
219
220 } // location not already assigned
221
222 } // array of location id's
223
224 // Call the service form back
225 formService($con, $service_id);
226
227 } // function
228
229
230 /**********************************************************
231 Function: assignServServtype
232 Author: Paul Bramscher
233 Last Modified: 04.21.2003
234 ***********************************************************
235 Purpose:
236 Assigns service types (possibly multiple) to a given
237 service and calls formService back again.
238 **********************************************************/
239 function assignServServtype($con, $servicetype_id_array, $service_id) {
240
241 // For every servicetype, assign it to the selected service
242 for ($subscript = 0; $subscript < sizeof($servicetype_id_array); $subscript++ ) {
243
244 // Check to make sure that the servicetype isn't already assigned
245 $sql = "SELECT * FROM serv_servtype WHERE service_id = "
246 . $service_id
247 . " AND servicetype_id = "
248 . $servicetype_id_array[$subscript];
249
250 $rs = mysql_query($sql);
251 if (mysql_num_rows($rs) == 0) {
252
253 $sql = "INSERT INTO serv_servtype (service_id, servicetype_id) VALUES ("
254 . $service_id
255 . ", "
256 . $servicetype_id_array[$subscript]
257 . ")";
258
259 if (!mysql_query($sql, $con)){
260 sql_err($con);
261 mysql_query ("UNLOCK TABLES", $con);
262 bailout();
263 } // bad write
264 else {
265 mysql_query("UNLOCK TABLES", $con);
266
267 } // good write of serv_servtype
268
269 } // servicetype not already assigned
270
271 } // array of servicetype id's
272
273 // Call the service form back
274 formService($con, $service_id);
275
276 } // function
277
278
279 /**********************************************************
280 Function: assignSubCoursesub
281 Author: Paul Bramscher
282 Last Modified: 06.04.2003
283 ***********************************************************
284 Purpose:
285 Assigns course subjects (possibly multiple) to a given subject
286 and calls formSubject back again.
287 **********************************************************/
288 function assignSubCoursesub($con, $coursesub_id_array, $subject_id) {
289
290 // For every coursesub, assign it to the selected subject
291 for ($subscript = 0; $subscript < sizeof($coursesub_id_array); $subscript++ ) {
292
293 // Check to make sure that the coursesub isn't already assigned
294 $sql = "SELECT * FROM sub_coursesub WHERE subject_id = "
295 . $subject_id
296 . " AND coursesub_id = "
297 . $coursesub_id_array[$subscript];
298
299 $rs = mysql_query($sql);
300 if (mysql_num_rows($rs) == 0) {
301
302 $sql = "INSERT INTO sub_coursesub (subject_id, coursesub_id) VALUES ("
303 . $subject_id
304 . ", "
305 . $coursesub_id_array[$subscript]
306 . ")";
307
308 if (!mysql_query($sql, $con)){
309 sql_err($con);
310 mysql_query ("UNLOCK TABLES", $con);
311 bailout();
312 } // bad write
313 else {
314 mysql_query("UNLOCK TABLES", $con);
315
316 } // good write of sub_coursesub
317
318 } // coursesub not already assigned
319
320 } // array of coursesub id's
321
322 // Call the subject form back
323 formSubject($con, $subject_id);
324
325 } // function
326
327
328 /**********************************************************
329 Function: assignSubLoc
330 Author: Paul Bramscher
331 Last Modified: 04.21.2003
332 ***********************************************************
333 Purpose:
334 Assigns locations (possibly multiple) to a given subject
335 and calls formSubject back again.
336 **********************************************************/
337 function assignSubLoc($con, $location_id_array, $subject_id) {
338
339 // For every location, assign it to the selected subject
340 for ($subscript = 0; $subscript < sizeof($location_id_array); $subscript++ ) {
341
342 // Check to make sure that the location isn't already assigned
343 $sql = "SELECT * FROM sub_loc WHERE subject_id = "
344 . $subject_id
345 . " AND location_id = "
346 . $location_id_array[$subscript];
347
348 $rs = mysql_query($sql);
349 if (mysql_num_rows($rs) == 0) {
350
351 $sql = "INSERT INTO sub_loc (subject_id, location_id) VALUES ("
352 . $subject_id
353 . ", "
354 . $location_id_array[$subscript]
355 . ")";
356
357 if (!mysql_query($sql, $con)){
358 sql_err($con);
359 mysql_query ("UNLOCK TABLES", $con);
360 bailout();
361 } // bad write
362 else {
363 mysql_query("UNLOCK TABLES", $con);
364
365 } // good write of sub_loc
366
367 } // location not already assigned
368
369 } // array of location id's
370
371 // Call the subject form back
372 formSubject($con, $subject_id);
373
374 } // function
375
376
377 /**********************************************************
378 Function: assignSubMaster
379 Author: Paul Bramscher
380 Last Modified: 04.21.2003
381 ***********************************************************
382 Purpose:
383 Assigns master subjects (possibly multiple) to a given
384 subject and calls formSubject back again.
385 **********************************************************/
386 function assignSubMaster($con, $mastersubject_id_array, $subject_id) {
387
388 // For every mastersubject, assign it to the selected subject
389 for ($subscript = 0; $subscript < sizeof($mastersubject_id_array); $subscript++ ) {
390
391 // Check to make sure that the mastersubject isn't already assigned
392 $sql = "SELECT * FROM sub_mastersubject WHERE subject_id = "
393 . $subject_id
394 . " AND mastersubject_id = "
395 . $mastersubject_id_array[$subscript];
396
397 $rs = mysql_query($sql);
398 if (mysql_num_rows($rs) == 0) {
399
400 $sql = "INSERT INTO sub_mastersubject (subject_id, mastersubject_id) VALUES ("
401 . $subject_id
402 . ", "
403 . $mastersubject_id_array[$subscript]
404 . ")";
405
406 if (!mysql_query($sql, $con)){
407 sql_err($con);
408 mysql_query ("UNLOCK TABLES", $con);
409 bailout();
410 } // bad write
411 else {
412 mysql_query("UNLOCK TABLES", $con);
413
414 } // good write of sub_mastersubject
415
416 } // location not already assigned
417
418 } // array of mastersubject id's
419
420 // Call the subject form back
421 formSubject($con, $subject_id);
422
423 } // function
424
425
426 /**********************************************************
427 Function: assignSubStaff
428 Author: Paul Bramscher
429 Last Modified: 04.21.2003
430 ***********************************************************
431 Purpose:
432 Assigns staff specialists (possibly multiple) to a given
433 subject and calls formSubject back again.
434 **********************************************************/
435 function assignSubStaff($con, $staff_id_array, $subject_id) {
436
437 // For every staff person selected
438 for ($subscript = 0; $subscript < sizeof($staff_id_array); $subscript++ ) {
439
440 // Check to make sure that the specialist isn't already assigned
441 $sql = "SELECT * FROM sub_staff WHERE subject_id = "
442 . $subject_id
443 . " AND staff_id = "
444 . $staff_id_array[$subscript];
445
446 $rs = mysql_query($sql);
447 if (mysql_num_rows($rs) == 0) {
448
449 $sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES ("
450 . $subject_id
451 . ", "
452 . $staff_id_array[$subscript]
453 . ")";
454
455 //mysql_query ("LOCK TABLE sub_staff WRITE", $con);
456 if (!mysql_query($sql, $con)){
457 sql_err($con);
458 mysql_query ("UNLOCK TABLES", $con);
459 bailout();
460 } // bad write
461 else {
462 mysql_query("UNLOCK TABLES", $con);
463 } // good write of sub_staff
464 }
465
466 } // array of staff id's
467
468 // Call the subject form back
469 formSubject($con, $subject_id);
470
471 } // function
472
473
474
475
476
477 /**********************************************************
478 Function: assignLibunitStaff
479 Author: Paul Bramscher
480 Last Modified: 04.29.2003
481 ***********************************************************
482 Purpose:
483 Assigns staff (possibly multiple) to a given library unit
484 and calls formLibunit back again.
485 **********************************************************/
486 function assignLibunitStaff($con, $staff_id_array, $libunit_id) {
487
488 // This function assigns staff to a given library unit and calls the formLibunit to display again
489
490 // For all staff in the array
491 for ($subscript = 0; $subscript < sizeof($staff_id_array); $subscript++ ) {
492
493 // Check to make sure that the staff isn't already assigned
494 $sql = "SELECT * FROM libunit_staff WHERE libunit_id = " . $libunit_id .
495 " AND staff_id = " . $staff_id_array[$subscript];
496 $rs = mysql_query($sql);
497 if (mysql_num_rows($rs) == 0) {
498
499 $sql = "INSERT INTO libunit_staff (libunit_id, staff_id) VALUES ("
500 . $libunit_id
501 . ", "
502 . $staff_id_array[$subscript]
503 . ")";
504
505 if (!mysql_query($sql, $con)){
506 sql_err($con);
507 mysql_query ("UNLOCK TABLES", $con);
508 bailout();
509 } // bad write
510 else {
511 mysql_query("UNLOCK TABLES", $con);
512
513 } // good write of libunit_staff
514
515 } // staff not already assigned
516
517 } // array of staff id's
518
519 // Call the Libunit form back
520 formLibunit($con, $libunit_id);
521
522 } // function
523
524
525 /**********************************************************
526 Function: assignStaffLibunit
527 Author: Paul Bramscher
528 Last Modified: 04.29.2003
529 ***********************************************************
530 Purpose:
531 Assigns library units (possibly multiple) to a given
532 staffperson and calls formStaff back again. This handles
533 the same bridging table as assignLibunitStaff, but from
534 the other side of the multiple pick list relationship.
535 **********************************************************/
536 function assignStaffLibunit($con, $libunit_id_array, $staff_id) {
537
538 // This function assigns library units to a selected staff person
539 for ($subscript = 0; $subscript < sizeof($libunit_id_array); $subscript++ ) {
540
541 // Check to make sure that the libunit isn't already assigned
542 $sql = "SELECT * FROM libunit_staff WHERE staff_id = "
543 . $staff_id
544 . " AND libunit_id = "
545 . $libunit_id_array[$subscript];
546
547 $rs = mysql_query($sql);
548 if (mysql_num_rows($rs) == 0) {
549
550 $sql = "INSERT INTO libunit_staff (libunit_id, staff_id) VALUES ("
551 . $libunit_id_array[$subscript]
552 . ", "
553 . $staff_id
554 . ")";
555
556 if (!mysql_query($sql, $con)){
557 sql_err($con);
558 mysql_query ("UNLOCK TABLES", $con);
559 bailout();
560 } // bad write
561 else {
562 mysql_query("UNLOCK TABLES", $con);
563
564 } // good write of libunit_staff
565
566 } // assignment didn't already exist
567
568 } // array of libunit id's
569
570 // Call the staff form back
571 formStaff($con, $staff_id);
572
573 } // function
574
575
576 /**********************************************************
577 Function: assignStaffSub
578 Author: Paul Bramscher
579 Last Modified: 04.29.2003
580 ***********************************************************
581 Purpose:
582 Assigns subjects (possibly multiple) to a given staffperson
583 and calls formStaff back again.
584 **********************************************************/
585 function assignStaffSub($con, $staff_id, $subject_id_array) {
586
587 // This function assigns subjects to a selected staff person
588 for ($subscript = 0; $subscript < sizeof($subject_id_array); $subscript++ ) {
589
590 // Check to make sure that the subject isn't already assigned
591 $sql = "SELECT * FROM sub_staff WHERE staff_id = "
592 . $staff_id
593 . " AND subject_id = "
594 . $subject_id_array[$subscript];
595
596 $rs = mysql_query($sql);
597 if (mysql_num_rows($rs) == 0) {
598
599 $sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES ("
600 . $subject_id_array[$subscript]
601 . ", "
602 . $staff_id
603 . ")";
604
605 if (!mysql_query($sql, $con)){
606 sql_err($con);
607 mysql_query ("UNLOCK TABLES", $con);
608 bailout();
609 } // bad write
610 else {
611 mysql_query("UNLOCK TABLES", $con);
612
613 } // good write of sub_staff
614
615 } // assignment didn't already exist
616
617 } // array of subject id's
618
619 // Call the staff form back
620 formStaff($con, $staff_id);
621
622 } // function
623 ?>

  ViewVC Help
Powered by ViewVC 1.1.26