17 |
printf("</HEAD>\n"); |
printf("</HEAD>\n"); |
18 |
|
|
19 |
|
|
20 |
|
// Default access settings |
21 |
|
$sess_time_human = ""; |
22 |
|
$sess_staff_account = ""; |
23 |
|
$sess_staff_id = 0; |
24 |
|
$sess_access_level = 0; |
25 |
|
$sess_access = ""; |
26 |
|
$sess_last_name = ""; |
27 |
|
$sess_first_name = ""; |
28 |
|
|
29 |
|
|
30 |
// Page header |
// Page header |
31 |
require_once ($GLOBAL_ADMIN_HEADER); |
require_once ($GLOBAL_ADMIN_HEADER); |
32 |
|
|
55 |
|
|
56 |
|
|
57 |
// Flag to make sure that the current user has sufficient access for this subject |
// Flag to make sure that the current user has sufficient access for this subject |
58 |
$auth_subject = authSubject($con, $sess_access_level, $sess_staff_id, $subject_id); |
$auth_subject = authSubject($sess_access_level, $sess_staff_id, $subject_id); |
59 |
|
|
60 |
|
|
61 |
// If the cookie is set and access level is appropriate |
// If the cookie is set and access level is appropriate |
71 |
** Display user's subject choice ** |
** Display user's subject choice ** |
72 |
**********************************/ |
**********************************/ |
73 |
|
|
74 |
$subject = lookupField($con, "subject", "subject_id", $subject_id, "subject"); |
$subject = lookupField("subject", "subject_id", $subject_id, "subject"); |
75 |
printf("<h2>Research QuickStart: %s</h2>", $subject); |
printf("<h2>Research QuickStart: %s</h2>", $subject); |
76 |
printf("</td></tr>\n"); |
printf("</td></tr>\n"); |
77 |
|
|
111 |
subject_id = " |
subject_id = " |
112 |
. $subject_id; |
. $subject_id; |
113 |
|
|
114 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
115 |
$row = mysql_fetch_array ($rs); |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
116 |
$rqs_date_modified = $row["rqs_date_modified"]; |
$rqs_date_modified = $row["rqs_date_modified"]; |
117 |
$rqs_date_created = $row["rqs_date_created"]; |
$rqs_date_created = $row["rqs_date_created"]; |
118 |
$rqs_account_created = $row["rqs_account_created"]; |
$rqs_account_created = $row["rqs_account_created"]; |
179 |
|
|
180 |
// User limited by masterinfotype, display it |
// User limited by masterinfotype, display it |
181 |
if ($masterinfotype_id > 0) { |
if ($masterinfotype_id > 0) { |
182 |
$masterinfotype = lookupField($con, "masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype"); |
$masterinfotype = lookupField("masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype"); |
183 |
printf(" within <b>%s</b>\n", $masterinfotype); |
printf(" within <b>%s</b>\n", $masterinfotype); |
184 |
} |
} |
185 |
|
|
186 |
// User limited by feature, display it |
// User limited by feature, display it |
187 |
if ($feature_id > 0) { |
if ($feature_id > 0) { |
188 |
$feature = lookupField($con, "feature", "feature_id", $feature_id, "feature"); |
$feature = lookupField("feature", "feature_id", $feature_id, "feature"); |
189 |
printf(" involving <b>%s</b>\n", $feature); |
printf(" involving <b>%s</b>\n", $feature); |
190 |
} |
} |
191 |
|
|
225 |
printf("<tr><td class = \"cellPlain\">Master Info Type:</td><td>\n"); |
printf("<tr><td class = \"cellPlain\">Master Info Type:</td><td>\n"); |
226 |
printf("<select name = \"masterinfotype_id\">\n"); |
printf("<select name = \"masterinfotype_id\">\n"); |
227 |
printf("<option value=\"0\">All</option>\n"); |
printf("<option value=\"0\">All</option>\n"); |
228 |
dropDownFieldSelected($con, "masterinfotype", "masterinfotype", "masterinfotype_id", " WHERE masterinfotype_id > 1 ", $masterinfotype_id); |
dropDownFieldSelected("masterinfotype", "masterinfotype", "masterinfotype_id", " WHERE masterinfotype_id > 1 ", $masterinfotype_id); |
229 |
printf("</select>\n"); |
printf("</select>\n"); |
230 |
printf(" and/or</td></tr>\n"); |
printf(" and/or</td></tr>\n"); |
231 |
|
|
236 |
printf("<tr><td class = \"cellPlain\" >Feature:</td><td>\n"); |
printf("<tr><td class = \"cellPlain\" >Feature:</td><td>\n"); |
237 |
printf("<select name = \"feature_id\">\n"); |
printf("<select name = \"feature_id\">\n"); |
238 |
printf("<option value=\"0\">All</option>\n"); |
printf("<option value=\"0\">All</option>\n"); |
239 |
dropDownFieldSelected($con, "feature", "feature", "feature_id", " WHERE feature_id > 1 ", $feature_id); |
dropDownFieldSelected("feature", "feature", "feature_id", " WHERE feature_id > 1 ", $feature_id); |
240 |
printf("</select>\n"); |
printf("</select>\n"); |
241 |
|
|
242 |
printf("<input type=\"submit\" value =\"Limit\"></form>\n"); |
printf("<input type=\"submit\" value =\"Limit\"></form>\n"); |
255 |
// Determine any limits and draw the box |
// Determine any limits and draw the box |
256 |
if (strlen($letter) > 0 && $letter != "All") $limit = $letter; |
if (strlen($letter) > 0 && $letter != "All") $limit = $letter; |
257 |
if (strlen($limitstring) > 0) $limit = $limitstring; |
if (strlen($limitstring) > 0) $limit = $limitstring; |
258 |
dropDownResource($con, 0, $limit, $masterinfotype_id, $feature_id); |
dropDownResource(0, $limit, $masterinfotype_id, $feature_id); |
259 |
printf("</select><br>\n"); |
printf("</select><br>\n"); |
260 |
|
|
261 |
printf("<input type =\"hidden\" name=\"subject_id\" value =\"%d\">\n", $subject_id); |
printf("<input type =\"hidden\" name=\"subject_id\" value =\"%d\">\n", $subject_id); |
276 |
*************************/ |
*************************/ |
277 |
|
|
278 |
printf("<td width=\"50%%\" valign=\"top\" align=\"right\">\n"); |
printf("<td width=\"50%%\" valign=\"top\" align=\"right\">\n"); |
279 |
formAssignSubOtherSub($con, $subject_id); |
formAssignSubOtherSub($subject_id); |
280 |
|
|
281 |
printf("<br>\n"); |
printf("<br>\n"); |
282 |
formAssignSubPage($con, $subject_id); |
formAssignSubPage($subject_id); |
283 |
|
|
284 |
// Close outer cell, row, and table |
// Close outer cell, row, and table |
285 |
printf("</td></tr></table>\n"); |
printf("</td></tr></table>\n"); |
311 |
rsi.infotype_id = i.infotype_id |
rsi.infotype_id = i.infotype_id |
312 |
ORDER BY mi.masterinfotype, i.infotype"; |
ORDER BY mi.masterinfotype, i.infotype"; |
313 |
|
|
314 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
315 |
|
|
316 |
$rows = mysql_num_rows($rs); |
$rows = mysql_num_rows($rs); |
317 |
|
|
319 |
$last_masterinfotype_id = 0; |
$last_masterinfotype_id = 0; |
320 |
|
|
321 |
$rowcount = 0; |
$rowcount = 0; |
322 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
323 |
|
|
324 |
// Fetch information types for this subject |
// Fetch information types for this subject |
325 |
$infotype_id = $row["infotype_id"]; |
$infotype_id = $row["infotype_id"]; |
379 |
rsi.resource_id = r.resource_id |
rsi.resource_id = r.resource_id |
380 |
ORDER BY m.masterinfotype, i.infotype, r.title"; |
ORDER BY m.masterinfotype, i.infotype, r.title"; |
381 |
|
|
382 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
383 |
|
|
384 |
// printf("sql was: %s<BR><BR>", $sql); |
// printf("sql was: %s<BR><BR>", $sql); |
385 |
|
|
386 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
387 |
|
|
388 |
// Fetch information types for this subject |
// Fetch information types for this subject |
389 |
$description = $row["description"]; |
$description = $row["description"]; |
406 |
|
|
407 |
|
|
408 |
// Edit mode |
// Edit mode |
409 |
if ($selected_resource_id == $resource_id && $selected_infotype_id == $infotype_id) { |
if ($selected_resource_id == $resource_id && $selected_infotype_id == $infotype_id && $operation == "editSubjectBuilder") { |
410 |
|
|
411 |
// Build an anchor |
// Build an anchor |
412 |
printf("<a name = \"%d\" > </a>\n", $resource_id); |
printf("<a name = \"%d\" > </a>\n", $resource_id); |
423 |
// Change information type |
// Change information type |
424 |
printf("<br><b>Information Type:</b><br>\n"); |
printf("<br><b>Information Type:</b><br>\n"); |
425 |
printf("<select name =\"infotype_id\">\n"); |
printf("<select name =\"infotype_id\">\n"); |
426 |
dropDownInfotype($con, $infotype_id, $subject_id); |
dropDownInfotype($infotype_id, $subject_id); |
427 |
printf("</select><BR><BR>\n"); |
printf("</select><BR><BR>\n"); |
428 |
|
|
429 |
// Set to highlighted status |
// Set to highlighted status |
484 |
|
|
485 |
} |
} |
486 |
|
|
487 |
|
// Prompt for removal |
488 |
|
else if ($selected_resource_id == $resource_id && $selected_infotype_id == $infotype_id && $operation == "deleteSubjectBuilder") { |
489 |
|
|
490 |
|
printf("<table border =\"1\" class=\"backLight\">\n"); |
491 |
|
printf("<tr><td class=\"cellPlain\"><a name=\"r%d\">Remove This Resource?</a></td></tr>\n", $resource_id); |
492 |
|
printf("<td class=\"backLight\">\n"); |
493 |
|
|
494 |
|
printf("<b>Title:</b> %s<br>\n", $title); |
495 |
|
if (strlen($url) > 0 ) printf ("<b>URL:</b> <a href=\"%s\">%s</a><BR>\n", $url, $url); |
496 |
|
printf("<b>Description:</b> "); |
497 |
|
if (strlen($description) > 0) printf("<i>%s</i> ", $description); |
498 |
|
else printf("<i>%s</i> ", $annotation); |
499 |
|
printf("<br><br>\n"); |
500 |
|
|
501 |
|
// Remove |
502 |
|
printf("<table><tr>\n"); |
503 |
|
printf("<form method =\"POST\" action=\"subject_transaction.phtml\" >\n"); |
504 |
|
printf("<td>\n"); |
505 |
|
printf("<input type=\"hidden\" name=\"transaction\" value=\"deleteSubjectBuilder\">\n"); |
506 |
|
printf("<input type=\"hidden\" name =\"resource_id\" value =\"%d\">\n", $selected_resource_id); |
507 |
|
printf("<input type=\"hidden\" name =\"subject_id\" value =\"%d\">\n", $subject_id); |
508 |
|
printf("<input type=\"hidden\" name =\"infotype_id\" value =\"%d\">\n", $selected_infotype_id); |
509 |
|
printf("<input type = \"submit\" value =\"Remove\">\n"); |
510 |
|
printf("</td></form>\n"); |
511 |
|
|
512 |
|
// Cancel |
513 |
|
printf("<form method=\"POST\" action=\"subject_builder.phtml?subject_id=%d#r%d\">", $subject_id, $resource_id); |
514 |
|
printf("<td>\n"); |
515 |
|
printf("<input type =\"submit\" value =\"Cancel\">\n"); |
516 |
|
printf("</td></form></tr>\n"); |
517 |
|
|
518 |
|
// Close things |
519 |
|
printf("</table></table><br>\n"); |
520 |
|
|
521 |
|
} |
522 |
|
|
523 |
// Display mode |
// Display mode |
524 |
else { |
else { |
525 |
|
|
526 |
|
if ($masterinfotype_id == 1 && $infotype_id == 1) { |
527 |
|
|
528 |
|
printf("<b>System Message: "); |
529 |
|
if (existsResSubNOTNA($resource_id, $subject_id)) printf("The following resource appears elsewhere on this page. Multiple instances must belong to unique information types. Please assign to a new information type or remove it."); |
530 |
|
else printf("The following resource lacked a default information type when it was added to this page. Please assign this instance to an information type. Also consider assigning a default information type to the base resource if it is still blank."); |
531 |
|
printf("</b><br><br>\n"); |
532 |
|
} |
533 |
|
|
534 |
printf("<a name=\"r%d\">Title:</a> %s<br>\n", $resource_id, $title); |
printf("<a name=\"r%d\">Title:</a> %s<br>\n", $resource_id, $title); |
535 |
if (strlen($url) > 0 ) printf ("URL: <a href=\"%s\">%s</a><BR>\n", $url, $url); |
if (strlen($url) > 0 ) printf ("URL: <a href=\"%s\">%s</a><BR>\n", $url, $url); |
536 |
printf("Description: "); |
printf("Description: "); |
559 |
printf("</td></form>\n"); |
printf("</td></form>\n"); |
560 |
|
|
561 |
// Remove this entry |
// Remove this entry |
562 |
printf("<form method =\"POST\" action=\"subject_transaction.phtml\" >\n"); |
printf("<form method=\"POST\" action=\"subject_builder.phtml?subject_id=%d#r%d\">", $subject_id, $resource_id); |
563 |
printf("<td>\n"); |
printf("<td>\n"); |
564 |
printf("<input type=\"hidden\" name=\"transaction\" value=\"deleteSubjectBuilder\">\n"); |
printf("<input type=\"hidden\" name=\"operation\" value=\"deleteSubjectBuilder\">\n"); |
565 |
printf("<input type=\"hidden\" name =\"resource_id\" value =\"%d\">\n", $resource_id); |
printf("<input type=\"hidden\" name =\"selected_resource_id\" value =\"%d\">\n", $resource_id); |
566 |
printf("<input type=\"hidden\" name =\"subject_id\" value =\"%d\">\n", $subject_id); |
printf("<input type=\"hidden\" name =\"subject_id\" value =\"%d\">\n", $subject_id); |
567 |
printf("<input type=\"hidden\" name =\"infotype_id\" value =\"%d\">\n", $infotype_id); |
printf("<input type=\"hidden\" name =\"selected_infotype_id\" value =\"%d\">\n", $infotype_id); |
568 |
printf("<input type = \"submit\" value =\"Remove\">\n"); |
printf("<input type = \"submit\" value =\"Remove\">\n"); |
569 |
printf("</td></form></tr></table><br><br>\n"); |
printf("</td></form></tr></table><br><br>\n"); |
570 |
|
|