} else { $row = $result->fetch(); $gibbonSchoolYearID = $row["gibbonSchoolYearID"]; $gibbonSchoolYearName = $row["name"]; } } if ($gibbonSchoolYearID != "") { print "<h2>"; print $gibbonSchoolYearName; print "</h2>"; print "<div class='linkTop'>"; //Print year picker $previousYear = getPreviousSchoolYearID($gibbonSchoolYearID, $connection2); $nextYear = getNextSchoolYearID($gibbonSchoolYearID, $connection2); if ($previousYear != FALSE) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/rollGroup_manage.php&gibbonSchoolYearID=" . getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . _('Previous Year') . "</a> "; } else { print _("Previous Year") . " "; } print " | "; if ($nextYear != FALSE) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/rollGroup_manage.php&gibbonSchoolYearID=" . getNextSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . _('Next Year') . "</a> "; } else { print _("Next Year") . " "; } print "</div>"; try { $data = array("gibbonSchoolYearID" => $gibbonSchoolYearID); $sql = "SELECT gibbonSchoolYear.gibbonSchoolYearID, gibbonRollGroupID, gibbonSchoolYear.name as yearName, gibbonRollGroup.name, gibbonRollGroup.nameShort, gibbonPersonIDTutor, gibbonPersonIDTutor2, gibbonPersonIDTutor3, gibbonSpace.name AS space, website FROM gibbonRollGroup JOIN gibbonSchoolYear ON (gibbonRollGroup.gibbonSchoolYearID=gibbonSchoolYear.gibbonSchoolYearID) LEFT JOIN gibbonSpace ON (gibbonRollGroup.gibbonSpaceID=gibbonSpace.gibbonSpaceID) WHERE gibbonSchoolYear.gibbonSchoolYearID=:gibbonSchoolYearID ORDER BY sequenceNumber, gibbonRollGroup.name"; $result = $connection2->prepare($sql); $result->execute($data);
$resultNext = $connection2->prepare($sqlNext); $resultNext->execute($dataNext); } catch (PDOException $e) { } if ($resultNext->rowCount() == 1) { $rowNext = $resultNext->fetch(); $gibbonCourseIDNext = $rowNext["gibbonCourseID"]; } } print "<h2>"; print $gibbonSchoolYearName; print "</h2>"; print "<div class='linkTop'>"; //Print year picker if (getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) != FALSE) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/units.php&gibbonSchoolYearID=" . getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) . "&gibbonCourseID={$gibbonCourseIDPrevious}'>" . _('Previous Year') . "</a> "; } else { print _("Previous Year") . " "; } print " | "; if (getNextSchoolYearID($gibbonSchoolYearID, $connection2) != FALSE) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/units.php&gibbonSchoolYearID=" . getNextSchoolYearID($gibbonSchoolYearID, $connection2) . "&gibbonCourseID={$gibbonCourseIDNext}'>" . _('Next Year') . "</a> "; } else { print _("Next Year") . " "; } print "</div>"; if ($gibbonCourseID != "") { try { if ($highestAction == "Unit Planner_all") { $data = array("gibbonSchoolYearID" => $gibbonSchoolYearID, "gibbonCourseID" => $gibbonCourseID); $sql = "SELECT * FROM gibbonCourse WHERE gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonCourseID=:gibbonCourseID";
print _("The specified record does not exist."); print "</div>"; } else { $row = $result->fetch(); $gibbonSchoolYearID = $row["gibbonSchoolYearID"]; $gibbonSchoolYearName = $row["name"]; } } if ($gibbonSchoolYearID != "") { print "<h2>"; print $gibbonSchoolYearName; print "</h2>"; print "<div class='linkTop'>"; //Print year picker if (getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) != FALSE) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/invoices_view.php&search={$gibbonPersonID}&gibbonSchoolYearID=" . getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . _('Previous Year') . "</a> "; } else { print _("Previous Year") . " "; } print " | "; if (getNextSchoolYearID($gibbonSchoolYearID, $connection2) != FALSE) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/invoices_view.php&search={$gibbonPersonID}&gibbonSchoolYearID=" . getNextSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . _('Next Year') . "</a> "; } else { print _("Next Year") . " "; } print "</div>"; try { //Add in filter wheres $data = array("gibbonSchoolYearID" => $gibbonSchoolYearID, "gibbonSchoolYearID2" => $gibbonSchoolYearID, "gibbonPersonID" => $gibbonPersonID); //SQL for NOT Pending $sql = "SELECT gibbonFinanceInvoice.gibbonFinanceInvoiceID, surname, preferredName, gibbonFinanceInvoice.invoiceTo, gibbonFinanceInvoice.status, gibbonFinanceInvoice.invoiceIssueDate, gibbonFinanceInvoice.invoiceDueDate, paidDate, paidAmount, billingScheduleType AS billingSchedule, gibbonFinanceBillingSchedule.name AS billingScheduleExtra, notes, gibbonRollGroup.name AS rollGroup FROM gibbonFinanceInvoice LEFT JOIN gibbonFinanceBillingSchedule ON (gibbonFinanceInvoice.gibbonFinanceBillingScheduleID=gibbonFinanceBillingSchedule.gibbonFinanceBillingScheduleID) JOIN gibbonFinanceInvoicee ON (gibbonFinanceInvoice.gibbonFinanceInvoiceeID=gibbonFinanceInvoicee.gibbonFinanceInvoiceeID) JOIN gibbonPerson ON (gibbonFinanceInvoicee.gibbonPersonID=gibbonPerson.gibbonPersonID) LEFT JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID) LEFT JOIN gibbonRollGroup ON (gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID) WHERE gibbonFinanceInvoice.gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonStudentEnrolment.gibbonSchoolYearID=:gibbonSchoolYearID AND NOT gibbonFinanceInvoice.status='Pending' AND gibbonFinanceInvoicee.gibbonPersonID=:gibbonPersonID ORDER BY invoiceIssueDate, surname, preferredName";
print _("Last School"); print "</th>"; print "<th>"; print _("Parents"); print "</th>"; print "</tr>"; $count = 0; $rowNum = "odd"; while ($row = $result->fetch()) { if ($count % 2 == 0) { $rowNum = "even"; } else { $rowNum = "odd"; } try { $data2 = array("gibbonSchoolYearID" => getPreviousSchoolYearID($_SESSION[$guid]["gibbonSchoolYearID"], $connection2), "gibbonPersonID" => $row["gibbonPersonID"]); $sql2 = "SELECT surname, preferredName, gibbonRollGroup.nameShort AS rollGroup, username FROM gibbonPerson JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID) JOIN gibbonRollGroup ON (gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID) WHERE gibbonStudentEnrolment.gibbonSchoolYearID=:gibbonSchoolYearID AND status='Full' AND gibbonPerson.gibbonPersonID=:gibbonPersonID ORDER BY rollGroup, surname, preferredName"; $result2 = $connection2->prepare($sql2); $result2->execute($data2); } catch (PDOException $e) { print "<div class='error'>" . $e->getMessage() . "</div>"; } if ($result2->rowCount() == 0) { $count++; print "<tr class={$rowNum}>"; print "<td>"; print $count; print "</td>"; print "<td>"; print formatName("", $row["preferredName"], $row["surname"], "Student", TRUE); print "</td>";
echo __($guid, 'The specified record does not exist.'); echo '</div>'; } else { $row = $result->fetch(); $gibbonSchoolYearID = $row['gibbonSchoolYearID']; $gibbonSchoolYearName = $row['name']; } } if ($gibbonSchoolYearID != '') { echo '<h2>'; echo $gibbonSchoolYearName; echo '</h2>'; echo "<div class='linkTop'>"; //Print year picker if (getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) != false) { echo "<a href='" . $_SESSION[$guid]['absoluteURL'] . '/index.php?q=/modules/' . $_SESSION[$guid]['module'] . '/badges_grant.php&gibbonSchoolYearID=' . getPreviousSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . __($guid, 'Previous Year') . '</a> '; } else { echo __($guid, 'Previous Year') . ' '; } echo ' | '; if (getNextSchoolYearID($gibbonSchoolYearID, $connection2) != false) { echo "<a href='" . $_SESSION[$guid]['absoluteURL'] . '/index.php?q=/modules/' . $_SESSION[$guid]['module'] . '/badges_grant.php&gibbonSchoolYearID=' . getNextSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . __($guid, 'Next Year') . '</a> '; } else { echo __($guid, 'Next Year') . ' '; } echo '</div>'; $gibbonPersonID2 = null; if (isset($_GET['gibbonPersonID2'])) { $gibbonPersonID2 = $_GET['gibbonPersonID2']; } $badgesBadgeID2 = null;