Esempio n. 1
0
     } 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);
Esempio n. 2
0
         $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";
Esempio n. 3
0
         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";
Esempio n. 4
0
 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>";
Esempio n. 5
0
         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;