} 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;