?> /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);