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(){";
