$table = "`" . DATABASE_NAME . "`.`ar_book_chapter_mono`";
break;
case 10:
case 11:
$table = "`" . DATABASE_NAME . "`.`ar_poster_reports`";
break;
}
$query = "SELECT *\n\t\t\t\tFROM " . $table . ", `" . AUTH_DATABASE . "`.`user_data`\n\t\t\t\tWHERE `proxy_id` = " . $departmentMember . "\n\t\t\t\tAND `proxy_id` = `" . AUTH_DATABASE . "`.`user_data`.`id`\n\t\t\t\tAND `type_id` = '{$typeID}'" . $dateWhere;
if ($results = $db->GetAll($query)) {
if ($departmentMember != $lastMember) {
echo "<h2>" . $departmentMemberName . "</h2>";
$outputBreak = false;
} else {
$outputBreak = true;
}
$currentType = getPublicationTypesSpecificFromID($typeID);
if (substr($currentType, -1, 1) != "s") {
$currentType = $currentType . "s";
}
$publicationSidebar[] = $currentType;
echo "<a name=\"" . $departmentMemberName . "\"></a>";
if ($outputBreak == true) {
echo "<br>";
}
echo "<h3>" . $currentType . "</h3>\n";
display($results, $db);
$lastMember = $departmentMember;
}
}
}
/*if(isset($publicationSidebar)) {
function display($results, $db)
{
foreach ($results as $result) {
$formattedRec = "";
if ($formattedRec == "") {
if ($result["author_list"] != "") {
$formattedRec = html_encode($result["author_list"]) . ", ";
}
if ($result["title"] != "") {
$formattedRec = $formattedRec . html_encode($result["title"]) . ", ";
}
if (isset($result["status_date"]) && strlen($result["status_date"]) == 5) {
$month = substr($result["status_date"], 0, 1);
$year = substr($result["status_date"], 1, 4);
$formattedRec = $formattedRec . $month . "-" . $year . ", ";
} else {
if (isset($result["status_date"]) && strlen($result["status_date"]) == 6) {
$month = substr($result["status_date"], 0, 2);
$year = substr($result["status_date"], 2, 4);
$formattedRec = $formattedRec . $month . "-" . $year . ", ";
} else {
$formattedRec = $formattedRec . " Pending Approval, ";
}
}
if ($result["source"] != "") {
$formattedRec = $formattedRec . html_encode($result["source"]) . ", ";
}
if (isset($result["editor_list"])) {
$formattedRec . "Ed. " . html_encode($result["editor_list"]) . ", ";
}
if ($result["volume"] != "" && $result["edition"] != "") {
$formattedRec = $formattedRec . "Vol. " . html_encode($result["volume"]) . "(" . html_encode($result["edition"]) . "):";
} else {
if ($result["volume"] != "" && $result["edition"] == "") {
$formattedRec = $formattedRec . "Vol. " . html_encode($result["volume"]) . ", ";
} else {
if ($result["volume"] == "" && $result["edition"] != "") {
$formattedRec = $formattedRec . html_encode($result["edition"]) . ":";
}
}
}
if ($result["pages"] != "") {
$formattedRec = $formattedRec . html_encode($result["pages"]);
}
// Check for existance of extra comma or colon at the end of the record
// if there is one remove it
$lengthOfRec = strlen($formattedRec) - 2;
$lastChar = substr($formattedRec, $lengthOfRec, 1);
if ($lastChar == "," || $lastChar == ":") {
$formattedRec = substr($formattedRec, 0, $lengthOfRec);
}
$typeDesc = getPublicationTypesSpecificFromID($result["type_id"]);
$roleDesc = getPublicationRoleSpecificFromID($result["role_id"]);
$formattedRec .= " <b> - " . $roleDesc . " (" . $typeDesc . ")</b>";
}
$outputArray[$result["status"]][] = $formattedRec;
}
$keyHeader = "<b>(1) Published:</b><br>";
echo $keyHeader;
if (count($outputArray['Published']) > 0) {
for ($u = 0; $u < count($outputArray['Published']); $u++) {
$ctr = $u + 1;
$outputString = $outputArray['Published'][$u] . "<br /><br />";
echo $outputString;
}
} else {
echo "No Records.<br>";
}
$keyHeader = "<br><b>(2) In Press:</b><br>";
echo $keyHeader;
if (count($outputArray['In Press']) > 0) {
for ($u = 0; $u < count($outputArray['In Press']); $u++) {
$ctr = $u + 1;
$outputString = $outputArray['In Press'][$u] . "<br /><br />";
echo $outputString;
}
} else {
echo "No Records.<br>";
}
$keyHeader = "<br><b>(3) Submitted:</b><br>";
echo $keyHeader;
if (count($outputArray['Submitted']) > 0) {
for ($u = 0; $u < count($outputArray['Submitted']); $u++) {
$ctr = $u + 1;
$outputString = $outputArray['Submitted'][$u] . "<br /><br />";
echo $outputString;
}
} else {
echo "No Records.<br>";
}
unset($outputArray);
}
