?>
/rollGroups_details.php">
<input type="hidden" name="gibbonRollGroupID" value="<?php
print $gibbonRollGroupID;
?>
">
<input type="hidden" name="address" value="<?php
print $_SESSION[$guid]["address"];
?>
">
<?php
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/rollGroups_details.php&gibbonRollGroupID={$gibbonRollGroupID}'>" . _('Clear Filters') . "</a>";
?>
<input type="submit" value="<?php
print _("Submit");
?>
">
</td>
</tr>
</table>
</form>
<?php
print "<h3>";
print _("Students");
print "</h3>";
printRollGroupTable($guid, $gibbonRollGroupID, 5, $connection2, FALSE, $orderBy);
//Set sidebar
$_SESSION[$guid]["sidebarExtra"] = getUserPhoto($guid, $primaryTutor240, 240);
}
}
}
<div id="tabs-1">
<?php
//Students
$sqlWhere = "";
while ($row = $result->fetch()) {
$sqlWhere .= "gibbonRollGroupID=" . $row["gibbonRollGroupID"] . " OR ";
if ($result->fetch() > 1) {
print "<h4>";
print $row["name"];
print "</h4>";
}
print "<div class='linkTop' style='margin-top: 0px'>";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Attendance/attendance_take_byRollGroup.php&gibbonRollGroupID=" . $row["gibbonRollGroupID"] . "'>" . _('Take Attendance') . "<img style='margin-left: 5px' title='" . _('Take Attendance') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/attendance.png'/></a> | ";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/indexExport.php?gibbonRollGroupID=" . $row["gibbonRollGroupID"] . "'>" . _('Export to Excel') . "<img style='margin-left: 5px' title='" . _('Export to Excel') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/download.png'/></a>";
print "</div>";
printRollGroupTable($guid, $row["gibbonRollGroupID"], 5, $connection2);
}
$sqlWhere = substr($sqlWhere, 0, -4);
?>
</div>
<div id="tabs-2">
<?php
$plural = "s";
if ($result->rowCount() == 1) {
$plural = "";
}
try {
$data = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonSchoolYearID2" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$sql = "SELECT gibbonBehaviour.*, student.surname AS surnameStudent, student.preferredName AS preferredNameStudent, creator.surname AS surnameCreator, creator.preferredName AS preferredNameCreator, creator.title FROM gibbonBehaviour JOIN gibbonPerson AS student ON (gibbonBehaviour.gibbonPersonID=student.gibbonPersonID) JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonPersonID=student.gibbonPersonID) JOIN gibbonPerson AS creator ON (gibbonBehaviour.gibbonPersonIDCreator=creator.gibbonPersonID) WHERE gibbonStudentEnrolment.gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonBehaviour.gibbonSchoolYearID=:gibbonSchoolYearID2 AND ({$sqlWhere}) ORDER BY timestamp DESC";
$result = $connection2->prepare($sql);
$result->execute($data);
