print "<div class='linkTop'>";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/User Admin/medicalForm_manage_add.php'>Add Medical Form<img style='margin: 0 0 -4px 3px' title='Add Medical Form' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/page_new.png'/></a> ";
print "</div>";
}
print "<div class='error'>";
print _("There are no records to display.");
print "</div>";
} else {
$rowMedical = $resultMedical->fetch();
if (isActionAccessible($guid, $connection2, "/modules/User Admin/medicalForm_manage.php") == TRUE) {
print "<div class='linkTop'>";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/User Admin/medicalForm_manage_edit.php&gibbonPersonMedicalID=" . $rowMedical["gibbonPersonMedicalID"] . "'>" . _('Edit') . "<img style='margin: 0 0 -4px 5px' title='" . _('Edit') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/config.png'/></a> ";
print "</div>";
}
//Medical alert!
$alert = getHighestMedicalRisk($gibbonPersonID, $connection2);
if ($alert != FALSE) {
$highestLevel = $alert[1];
$highestColour = $alert[3];
$highestColourBG = $alert[4];
print "<div class='error' style='background-color: #" . $highestColourBG . "; border: 1px solid #" . $highestColour . "; color: #" . $highestColour . "'>";
print "<b>" . sprintf(_('This student has one or more %1$s risk medical conditions'), strToLower($highestLevel)) . "</b>.";
print "</div>";
}
//Get medical conditions
try {
$dataCondition = array("gibbonPersonMedicalID" => $rowMedical["gibbonPersonMedicalID"]);
$sqlCondition = "SELECT * FROM gibbonPersonMedicalCondition WHERE gibbonPersonMedicalID=:gibbonPersonMedicalID ORDER BY name";
$resultCondition = $connection2->prepare($sqlCondition);
$resultCondition->execute($dataCondition);
} catch (PDOException $e) {
function getAlertBar($guid, $connection2, $gibbonPersonID, $privacy = "", $divExtras = "", $div = TRUE, $large = FALSE)
{
$output = "";
$width = "14";
$height = "13";
$fontSize = "12";
$totalHeight = "16";
if ($large) {
$width = "42";
$height = "35";
$fontSize = "39";
$totalHeight = "45";
}
$highestAction = getHighestGroupedAction($guid, "/modules/Students/student_view_details.php", $connection2);
if ($highestAction == "View Student Profile_full") {
if ($div == TRUE) {
$output .= "<div {$divExtras} style='width: 83px; text-align: right; height: " . $totalHeight . "px; padding: 3px 0px; margin: auto'><b>";
}
//Individual Needs
try {
$dataAlert = array("gibbonPersonID" => $gibbonPersonID);
$sqlAlert = "SELECT * FROM gibbonINPersonDescriptor JOIN gibbonAlertLevel ON (gibbonINPersonDescriptor.gibbonAlertLevelID=gibbonAlertLevel.gibbonAlertLevelID) WHERE gibbonPersonID=:gibbonPersonID ORDER BY sequenceNumber DESC";
$resultAlert = $connection2->prepare($sqlAlert);
$resultAlert->execute($dataAlert);
} catch (PDOException $e) {
}
if ($resultAlert->rowCount() > 0) {
$rowAlert = $resultAlert->fetch();
$highestLevel = _($rowAlert["name"]);
$highestColour = $rowAlert["color"];
$highestColourBG = $rowAlert["colorBG"];
if ($resultAlert->rowCount() == 1) {
$title = $resultAlert->rowCount() . " " . sprintf(_('Individual Needs alert is set, with an alert level of %1$s.'), $rowAlert["name"]);
} else {
$title = $resultAlert->rowCount() . " " . sprintf(_('Individual Needs alerts are set, up to a maximum alert level of %1$s.'), $rowAlert["name"]);
}
$output .= "<a style='font-size: " . $fontSize . "px; color: #" . $highestColour . "; text-decoration: none' href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Students/student_view_details.php&gibbonPersonID=" . $gibbonPersonID . "&subpage=Individual Needs'><div title='{$title}' style='float: right; text-align: center; vertical-align: middle; max-height: " . $height . "px; height: " . $height . "px; width: " . $width . "px; border-top: 2px solid #" . $highestColour . "; margin-right: 2px; background-color: #" . $highestColourBG . "'>" . _('IN') . "</div></a>";
}
//Academic
$gibbonAlertLevelID = "";
try {
$dataAlert = array("gibbonPersonIDStudent" => $gibbonPersonID, "gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$sqlAlert = "SELECT * FROM gibbonMarkbookEntry JOIN gibbonMarkbookColumn ON (gibbonMarkbookEntry.gibbonMarkbookColumnID=gibbonMarkbookColumn.gibbonMarkbookColumnID) JOIN gibbonCourseClass ON (gibbonMarkbookColumn.gibbonCourseClassID=gibbonCourseClass.gibbonCourseClassID) JOIN gibbonCourse ON (gibbonCourseClass.gibbonCourseID=gibbonCourse.gibbonCourseID) WHERE gibbonPersonIDStudent=:gibbonPersonIDStudent AND (attainmentConcern='Y' OR effortConcern='Y') AND complete='Y' AND gibbonSchoolYearID=:gibbonSchoolYearID";
$resultAlert = $connection2->prepare($sqlAlert);
$resultAlert->execute($dataAlert);
} catch (PDOException $e) {
$_SESSION[$guid]["sidebarExtra"] .= "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultAlert->rowCount() > 1 and $resultAlert->rowCount() <= 4) {
$gibbonAlertLevelID = 03;
} else {
if ($resultAlert->rowCount() > 4 and $resultAlert->rowCount() <= 8) {
$gibbonAlertLevelID = 02;
} else {
if ($resultAlert->rowCount() > 8) {
$gibbonAlertLevelID = 01;
}
}
}
if ($gibbonAlertLevelID != "") {
$alert = getAlert($connection2, $gibbonAlertLevelID);
if ($alert != FALSE) {
$title = sprintf(_('Student has a %1$s alert for academic concern in the current academic year.'), _($alert["name"]));
$output .= "<a style='font-size: " . $fontSize . "px; color: #" . $alert["color"] . "; text-decoration: none' href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Students/student_view_details.php&gibbonPersonID=" . $gibbonPersonID . "&subpage=Markbook&filter=" . $_SESSION[$guid]["gibbonSchoolYearID"] . "'><div title='{$title}' style='float: right; text-align: center; vertical-align: middle; max-height: " . $height . "px; height: " . $height . "px; width: " . $width . "px; border-top: 2px solid #" . $alert["color"] . "; margin-right: 2px; background-color: #" . $alert["colorBG"] . "'>" . _('A') . "</div></a>";
}
}
//Behaviour
$gibbonAlertLevelID = "";
try {
$dataAlert = array("gibbonPersonID" => $gibbonPersonID);
$sqlAlert = "SELECT * FROM gibbonBehaviour WHERE gibbonPersonID=:gibbonPersonID AND type='Negative' AND date>'" . date("Y-m-d", time() - 24 * 60 * 60 * 60) . "'";
$resultAlert = $connection2->prepare($sqlAlert);
$resultAlert->execute($dataAlert);
} catch (PDOException $e) {
$_SESSION[$guid]["sidebarExtra"] .= "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultAlert->rowCount() > 1 and $resultAlert->rowCount() <= 4) {
$gibbonAlertLevelID = 03;
} else {
if ($resultAlert->rowCount() > 4 and $resultAlert->rowCount() <= 8) {
$gibbonAlertLevelID = 02;
} else {
if ($resultAlert->rowCount() > 8) {
$gibbonAlertLevelID = 01;
}
}
}
if ($gibbonAlertLevelID != "") {
$alert = getAlert($connection2, $gibbonAlertLevelID);
if ($alert != FALSE) {
$title = sprintf(_('Student has a %1$s alert for behaviour over the past 60 days.'), _($alert["name"]));
$output .= "<a style='font-size: " . $fontSize . "px; color: #" . $alert["color"] . "; text-decoration: none' href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Students/student_view_details.php&gibbonPersonID=" . $gibbonPersonID . "&subpage=Behaviour'><div title='{$title}' style='float: right; text-align: center; vertical-align: middle; max-height: " . $height . "px; height: " . $height . "px; width: " . $width . "px; border-top: 2px solid #" . $alert["color"] . "; margin-right: 2px; background-color: #" . $alert["colorBG"] . "'>" . _('B') . "</div></a>";
}
}
//Medical
$alert = getHighestMedicalRisk($gibbonPersonID, $connection2);
if ($alert != FALSE) {
$highestLevel = $alert[1];
$highestColour = $alert[3];
$highestColourBG = $alert[4];
$title = sprintf(_('Medical alerts are set, up to a maximum of %1$s'), $highestLevel);
$output .= "<a style='font-size: " . $fontSize . "px; color: #" . $highestColour . "; text-decoration: none' href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Students/student_view_details.php&gibbonPersonID=" . $gibbonPersonID . "&subpage=Medical'><div title='{$title}' style='float: right; text-align: center; vertical-align: middle; max-height: " . $height . "px; height: " . $height . "px; width: " . $width . "px; border-top: 2px solid #" . $highestColour . "; margin-right: 2px; background-color: #" . $highestColourBG . "'><b>" . _('M') . "</b></div></a>";
}
//Privacy
$privacySetting = getSettingByScope($connection2, "User Admin", "privacy");
if ($privacySetting == "Y" and $privacy != "") {
$alert = getAlert($connection2, 01);
$title = sprintf(_('Privacy is required: %1$s'), $privacy);
$output .= "<div title='{$title}' style='font-size: " . $fontSize . "px; float: right; text-align: center; vertical-align: middle; max-height: " . $height . "px; height: " . $height . "px; width: " . $width . "px; border-top: 2px solid #" . $alert["color"] . "; margin-right: 2px; color: #" . $alert["color"] . "; background-color: #" . $alert["colorBG"] . "'>" . _('P') . "</div>";
}
if ($div == TRUE) {
$output .= "</div>";
}
}
return $output;
}