function printClassGroupTable($guid, $gibbonCourseClassID, $columns, $connection2) { try { $dataClassGroup = array("gibbonCourseClassID" => $gibbonCourseClassID); $sqlClassGroup = "SELECT * FROM gibbonCourseClassPerson INNER JOIN gibbonPerson ON gibbonCourseClassPerson.gibbonPersonID=gibbonPerson.gibbonPersonID WHERE gibbonCourseClassID=:gibbonCourseClassID AND status='Full' AND (dateStart IS NULL OR dateStart<='" . date("Y-m-d") . "') AND (dateEnd IS NULL OR dateEnd>='" . date("Y-m-d") . "') AND (NOT role='Student - Left') AND (NOT role='Teacher - Left') ORDER BY role DESC, surname, preferredName"; $resultClassGroup = $connection2->prepare($sqlClassGroup); $resultClassGroup->execute($dataClassGroup); } catch (PDOException $e) { } print "<table class='noIntBorder' cellspacing='0' style='width:100%'>"; $count = 0; while ($rowClassGroup = $resultClassGroup->fetch()) { if ($count % $columns == 0) { print "<tr>"; } print "<td style='width:20%; text-align: center; vertical-align: top'>"; //Alerts, if permission allows print getAlertBar($guid, $connection2, $rowClassGroup["gibbonPersonID"], $rowClassGroup["privacy"]); //User photo print getUserPhoto($guid, $rowClassGroup["image_240"], 75); //HEY SHORTY IT'S YOUR BIRTHDAY! $daysUntilNextBirthday = daysUntilNextBirthday($rowClassGroup["dob"]); if ($daysUntilNextBirthday == 0) { print "<img title='" . sprintf(_('%1$s birthday today!'), $rowClassGroup["preferredName"] . "'s") . "' style='z-index: 99; margin: -20px 0 0 74px; width: 25px; height: 25px' src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/gift_pink.png'/>"; } else { if ($daysUntilNextBirthday > 0 and $daysUntilNextBirthday < 8) { print "<img title='{$daysUntilNextBirthday} "; if ($daysUntilNextBirthday != 1) { print sprintf(_('days until %1$s birthday!'), $rowClassGroup["preferredName"] . "'s"); } else { print sprintf(_('day until %1$s birthday!'), $rowClassGroup["preferredName"] . "'s"); } print "' style='z-index: 99; margin: -20px 0 0 74px; width: 25px; height: 25px' src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/gift.png'/>"; } } if ($rowClassGroup["role"] == "Student") { print "<div style='padding-top: 5px'><b><a href='index.php?q=/modules/Students/student_view_details.php&gibbonPersonID=" . $rowClassGroup["gibbonPersonID"] . "'>" . formatName("", $rowClassGroup["preferredName"], $rowClassGroup["surname"], "Student") . "</a></b><br/>"; } else { print "<div style='padding-top: 5px'><b>" . formatName($rowClassGroup["title"], $rowClassGroup["preferredName"], $rowClassGroup["surname"], "Staff") . "</b><br/>"; } print "<i>" . $rowClassGroup["role"] . "</i><br/><br/></div>"; print "</td>"; if ($count % $columns == $columns - 1) { print "</tr>"; } $count++; } for ($i = 0; $i < $columns - $count % $columns; $i++) { print "<td></td>"; } if ($count % $columns != 0) { print "</tr>"; } print "</table>"; }
$_SESSION[$guid]["sidebarExtra"] .= getAlertBar($guid, $connection2, $rowClassGroup["gibbonPersonID"], $rowClassGroup["privacy"], "id='confidentialPlan{$count}'"); } //Get photos $_SESSION[$guid]["sidebarExtra"] .= "<div>"; $_SESSION[$guid]["sidebarExtra"] .= getUserPhoto($guid, $rowClassGroup["image_75"], 75); if ($row["role"] == "Teacher" and $teacher == TRUE) { if ($rowClassGroup["role"] == "Student") { try { $dataLike = array("gibbonPlannerEntryID" => $row["gibbonPlannerEntryID"], "gibbonPersonID" => $rowClassGroup["gibbonPersonID"]); $sqlLike = "SELECT * FROM gibbonBehaviour WHERE type='Positive' AND gibbonPlannerEntryID=:gibbonPlannerEntryID AND gibbonPersonID=:gibbonPersonID"; $resultLike = $connection2->prepare($sqlLike); $resultLike->execute($dataLike); } catch (PDOException $e) { } //HEY SHORTY IT'S YOUR BIRTHDAY! $daysUntilNextBirthday = daysUntilNextBirthday($rowClassGroup["dob"]); if ($daysUntilNextBirthday == 0) { $_SESSION[$guid]["sidebarExtra"] .= "<img title='" . sprintf(_('%1$s\'s birthday today!'), $rowClassGroup["preferredName"]) . " style='margin: -24px 0 0 0; width: 25px; height: 25px' src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/gift_pink.png'/>"; } else { if ($daysUntilNextBirthday > 0 and $daysUntilNextBirthday < 8) { $_SESSION[$guid]["sidebarExtra"] .= "<img title='{$daysUntilNextBirthday} day"; if ($daysUntilNextBirthday != 1) { $_SESSION[$guid]["sidebarExtra"] .= "s"; } $_SESSION[$guid]["sidebarExtra"] .= " until " . $rowClassGroup["preferredName"] . "'s birthday!' style='margin: -24px 0 0 0; width: 25px; height: 25px' src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/gift.png'/>"; } } $_SESSION[$guid]["sidebarExtra"] .= "<div id='star" . $rowClassGroup["gibbonPersonID"] . "'>"; $_SESSION[$guid]["sidebarExtra"] .= "<script type=\"text/javascript\">"; $_SESSION[$guid]["sidebarExtra"] .= "\$(document).ready(function(){"; $_SESSION[$guid]["sidebarExtra"] .= "\$(\"#starAdd" . $rowClassGroup["gibbonPersonID"] . "\").click(function(){";