try {
$dataChild = array("gibbonPersonID" => $gibbonPersonID, "gibbonPersonID2" => $_SESSION[$guid]["gibbonPersonID"]);
$sqlChild = "SELECT * FROM gibbonFamilyChild JOIN gibbonFamily ON (gibbonFamilyChild.gibbonFamilyID=gibbonFamily.gibbonFamilyID) JOIN gibbonFamilyAdult ON (gibbonFamilyAdult.gibbonFamilyID=gibbonFamily.gibbonFamilyID) JOIN gibbonPerson ON (gibbonFamilyChild.gibbonPersonID=gibbonPerson.gibbonPersonID) WHERE gibbonPerson.status='Full' AND (dateStart IS NULL OR dateStart<='" . date("Y-m-d") . "') AND (dateEnd IS NULL OR dateEnd>='" . date("Y-m-d") . "') AND gibbonFamilyChild.gibbonPersonID=:gibbonPersonID AND gibbonFamilyAdult.gibbonPersonID=:gibbonPersonID2 AND childDataAccess='Y'";
$resultChild = $connection2->prepare($sqlChild);
$resultChild->execute($dataChild);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultChild->rowCount() < 1) {
print "<div class='error'>";
print _("The selected record does not exist, or you do not have access to it.");
print "</div>";
} else {
$rowChild = $resultChild->fetch();
print getInternalAssessmentRecord($guid, $connection2, $gibbonPersonID, "parent");
}
}
}
} else {
//MY Internal Assessments
print "<div class='trail'>";
print "<div class='trailHead'><a href='" . $_SESSION[$guid]["absoluteURL"] . "'>" . _("Home") . "</a> > <a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_GET["q"]) . "/" . getModuleEntry($_GET["q"], $connection2, $guid) . "'>" . _(getModuleName($_GET["q"])) . "</a> > </div><div class='trailEnd'>" . _('View My Internal Assessments') . "</div>";
print "</div>";
print "<h3>";
print _("Internal Assessments");
print "</h3>";
print getInternalAssessmentRecord($guid, $connection2, $_SESSION[$guid]["gibbonPersonID"], "student");
}
}
}
}
print _("Your request failed because you do not have access to this action.");
print "</div>";
} else {
$highestAction = getHighestGroupedAction($guid, "/modules/Formal Assessment/internalAssessment_view.php", $connection2);
if ($highestAction == FALSE) {
print "<div class='error'>";
print _("The highest grouped action cannot be determined.");
print "</div>";
} else {
//Module includes
include "./modules/Formal Assessment/moduleFunctions.php";
if ($highestAction == "View Internal Assessments_all") {
print getInternalAssessmentRecord($guid, $connection2, $gibbonPersonID);
} else {
if ($highestAction == "View Internal Assessments_myChildrens") {
print getInternalAssessmentRecord($guid, $connection2, $gibbonPersonID, "parent");
}
}
}
}
} else {
if ($subpage == "External Assessment") {
if (isActionAccessible($guid, $connection2, "/modules/Formal Assessment/externalAssessment_details.php") == FALSE) {
print "<div class='error'>";
print _("Your request failed because you do not have access to this action.");
print "</div>";
} else {
//Module includes
include "./modules/Formal Assessment/moduleFunctions.php";
print externalAssessmentDetails($guid, $gibbonPersonID, $connection2);
}