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);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
print "<div class='linkTop'>";
if ($nextYear != FALSE) {
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/modules/" . $_SESSION[$guid]["module"] . "/rollGroup_manage_copyProcess.php?gibbonSchoolYearID={$gibbonSchoolYearID}&gibbonSchoolYearIDNext={$nextYear}'> " . _('Copy All To Next Year') . "<img style='margin-left: 3px' title='" . _('Copy All To Next Year') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/copy.png'/></a> | ";
$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";
} else {
if ($highestAction == "Unit Planner_learningAreas") {
$data = array("gibbonSchoolYearID" => $gibbonSchoolYearID, "gibbonCourseID" => $gibbonCourseID, "gibbonPersonID" => $_SESSION[$guid]["gibbonPersonID"]);
$sql = "SELECT gibbonCourseID, gibbonCourse.name, gibbonCourse.nameShort FROM gibbonCourse JOIN gibbonDepartment ON (gibbonCourse.gibbonDepartmentID=gibbonDepartment.gibbonDepartmentID) JOIN gibbonDepartmentStaff ON (gibbonDepartmentStaff.gibbonDepartmentID=gibbonDepartment.gibbonDepartmentID) WHERE gibbonDepartmentStaff.gibbonPersonID=:gibbonPersonID AND (role='Coordinator' OR role='Assistant Coordinator' OR role='Teacher (Curriculum)') AND gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonCourseID=:gibbonCourseID ORDER BY gibbonCourse.nameShort";
}
}
}
if ($resultNext->rowCount() == 1) {
$rowNext = $resultNext->fetch();
}
$nameNext = $rowNext["name"];
$sequenceNext = $rowNext["sequenceNumber"];
if ($nameNext == "" or $sequenceNext == "") {
print "<div class='error'>";
print _("The next school year cannot be determined, so this action cannot be performed.");
print "</div>";
} else {
print "<h3>";
print _("Step 3");
print "</h3>";
//ADD YEAR FOLLOWING NEXT
if (getNextSchoolYearID($nextYear, $connection2) == FALSE) {
//ADD YEAR FOLLOWING NEXT
print "<h4>";
print sprintf(_('Add Year Following %1$s'), $nameNext);
print "</h4>";
$name = $_POST["nextname"];
$status = $_POST["next-status"];
$sequenceNumber = $_POST["next-sequenceNumber"];
$firstDay = dateConvert($guid, $_POST["nextfirstDay"]);
$lastDay = dateConvert($guid, $_POST["nextlastDay"]);
if ($name == "" or $status == "" or $sequenceNumber == "" or is_numeric($sequenceNumber) == FALSE or $firstDay == "" or $lastDay == "") {
print "<div class='error'>";
print _("Your request failed because your inputs were invalid.");
print "</div>";
} else {
//Check unique inputs for uniqueness
</td>
</tr>
<tr>
<td>
<b><?php
print _('Next Roll Group');
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print _('Sets student progression on rollover.');
?>
</i></span>
</td>
<td class="right">
<?php
$nextYear = getNextSchoolYearID($gibbonSchoolYearID, $connection2);
if ($nextYear == "") {
print "<div class='warning'>";
print "The next school year cannot be determined, so this value cannot be set.";
print "</div>";
} else {
print "<select style='width: 302px' name='gibbonRollGroupIDNext'>";
print "<option value=''></option>";
try {
$dataSelect = array("gibbonSchoolYearID" => $nextYear);
$sqlSelect = "SELECT * FROM gibbonRollGroup WHERE gibbonRollGroup.gibbonSchoolYearID=:gibbonSchoolYearID ORDER BY name";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
print "<td>";
print "<span style='font-size: 90%'><i>* " . _("denotes a required field") . "</i></span>";
print "</td>";
print "<td class='right'>";
print "<input type='hidden' name='nextYear' value='{$nextYear}'>";
print "<input type='submit' value='Proceed'>";
print "</td>";
print "</tr>";
print "</table>";
print "</form>";
}
}
} else {
if ($step == 3) {
$nextYear = $_POST["nextYear"];
if ($nextYear == "" or $nextYear != getNextSchoolYearID($_SESSION[$guid]["gibbonSchoolYearID"], $connection2)) {
print "<div class='error'>";
print _("The next school year cannot be determined, so this action cannot be performed.");
print "</div>";
} else {
try {
$dataNext = array("gibbonSchoolYearID" => $nextYear);
$sqlNext = "SELECT * FROM gibbonSchoolYear WHERE gibbonSchoolYearID=:gibbonSchoolYearID";
$resultNext = $connection2->prepare($sqlNext);
$resultNext->execute($dataNext);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultNext->rowCount() == 1) {
$rowNext = $resultNext->fetch();
}
}
}
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"] . "/courseEnrolment_manage_byPerson.php&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"] . "/courseEnrolment_manage_byPerson.php&gibbonSchoolYearID=" . getNextSchoolYearID($gibbonSchoolYearID, $connection2) . "'>" . _('Next Year') . "</a> ";
} else {
print _("Next Year") . " ";
}
print "</div>";
$allUsers = "";
if (isset($_GET["allUsers"])) {
$allUsers = $_GET["allUsers"];
}
$search = "";
if (isset($_GET["search"])) {
$search = $_GET["search"];
}
print "<h3>";
print _("Filters");
print "</h3>";
}
}
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";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($result->rowCount() < 1) {
}
}
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;
if (isset($_GET['badgesBadgeID2'])) {
$badgesBadgeID2 = $_GET['badgesBadgeID2'];
}
$gibbonYearGroupID = null;
if (isset($_GET['gibbonYearGroupID'])) {
$gibbonYearGroupID = $_GET['gibbonYearGroupID'];
