if ($rowConditions["triggers"] != "") {
print "<u><i>" . _('Triggers') . "</i></u>: " . $rowConditions["triggers"] . "<br/>";
}
if ($rowConditions["reaction"] != "") {
print "<u><i>" . _('Reaction') . "</i></u>: " . $rowConditions["reaction"] . "<br/>";
}
if ($rowConditions["response"] != "") {
print "<u><i>" . _('Response') . "</i></u>: " . $rowConditions["response"] . "<br/>";
}
if ($rowConditions["medication"] != "") {
print "<u><i>" . _('Medication') . "</i></u>: " . $rowConditions["medication"] . "<br/>";
}
if ($rowConditions["lastEpisode"] != "" or $rowConditions["lastEpisodeTreatment"] != "") {
print "<u><i>" . _('Last Episode') . "</i></u>: ";
if ($rowConditions["lastEpisode"] != "") {
print dateConvertBack($guid, $rowConditions["lastEpisode"]);
}
if ($rowConditions["lastEpisodeTreatment"] != "") {
if ($rowConditions["lastEpisode"] != "") {
print " | ";
}
print $rowConditions["lastEpisodeTreatment"];
}
print "<br/>";
}
if ($rowConditions["comment"] != "") {
print "<u><i>" . _('Comment') . "</i></u>: " . $rowConditions["comment"] . "<br/>";
}
print "</td>";
print "</tr>";
$condCount++;
//Get details of last personal data form update
try {
$dataMedical = array("gibbonPersonID" => $row["gibbonPersonID"]);
$sqlMedical = "SELECT * FROM gibbonPersonUpdate WHERE gibbonPersonID=:gibbonPersonID AND status='Complete' ORDER BY timestamp DESC";
$resultMedical = $connection2->prepare($sqlMedical);
$resultMedical->execute($dataMedical);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultMedical->rowCount() > 0) {
$rowMedical = $resultMedical->fetch();
//Is last update more recent than 90 days?
if (substr($rowMedical["timestamp"], 0, 10) > date("Y-m-d", time() - 90 * 24 * 60 * 60)) {
print dateConvertBack($guid, substr($rowMedical["timestamp"], 0, 10));
} else {
print "<span style='color: #ff0000; font-weight: bold'>" . dateConvertBack($guid, substr($rowMedical["timestamp"], 0, 10)) . "</span>";
}
} else {
print "<span style='color: #ff0000; font-weight: bold'>" . _('NA') . "</span>";
}
print "</td>";
print "</tr>";
print "<tr class={$rowNum}>";
print "<td></td>";
print "<td style='border-top: 1px solid #aaa; vertical-align: top'>";
print "<b><i>" . _('Parents') . "</i></b><br/>";
try {
$dataFamily = array("gibbonPersonID" => $row["gibbonPersonID"]);
$sqlFamily = "SELECT gibbonFamilyID FROM gibbonFamilyChild WHERE gibbonPersonID=:gibbonPersonID";
$resultFamily = $connection2->prepare($sqlFamily);
$resultFamily->execute($dataFamily);
</td>
</tr>
<tr>
<td>
<b><?php
print _('Last Episode Date');
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print $_SESSION[$guid]["i18n"]["dateFormat"];
?>
</i></span>
</td>
<td class="right">
<input name="lastEpisode" id="lastEpisode" maxlength=10 value="<?php
print dateConvertBack($guid, $row["lastEpisode"]);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var lastEpisode=new LiveValidation('lastEpisode');
lastEpisode.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
<b><?php
print _('Sumbission Open Date');
?>
</b><br/>
<span style="font-size: 90%"><i>Format <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
print $_SESSION[$guid]["i18n"]["dateFormat"];
}
?>
<br/></i></span>
</td>
<td class="right">
<input name="homeworkSubmissionDateOpen" id="homeworkSubmissionDateOpen" maxlength=10 value="<?php
print dateConvertBack($guid, $row["homeworkSubmissionDateOpen"]);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var homeworkSubmissionDateOpen=new LiveValidation('homeworkSubmissionDateOpen');
homeworkSubmissionDateOpen.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
function receiptContents($guid, $connection2, $gibbonFinanceInvoiceID, $gibbonSchoolYearID, $currency = "", $email = FALSE)
{
$return = "";
try {
$data = array("gibbonSchoolYearID" => $gibbonSchoolYearID, "gibbonSchoolYearID2" => $gibbonSchoolYearID, "gibbonFinanceInvoiceID" => $gibbonFinanceInvoiceID);
$sql = "SELECT gibbonPerson.gibbonPersonID, studentID, surname, preferredName, gibbonFinanceInvoice.*, companyContact, companyName, companyAddress, gibbonRollGroup.name AS rollgroup FROM gibbonFinanceInvoice JOIN gibbonFinanceInvoicee ON (gibbonFinanceInvoice.gibbonFinanceInvoiceeID=gibbonFinanceInvoicee.gibbonFinanceInvoiceeID) JOIN gibbonPerson ON (gibbonFinanceInvoicee.gibbonPersonID=gibbonPerson.gibbonPersonID) JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID) JOIN gibbonRollGroup ON (gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID) WHERE gibbonStudentEnrolment.gibbonSchoolYearID=:gibbonSchoolYearID2 AND gibbonFinanceInvoice.gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$return = FALSE;
}
if ($result->rowCount() == 1) {
//Let's go!
$row = $result->fetch();
if ($email == TRUE) {
$return .= "<div style='width: 100%; text-align: right'>";
$return .= "<a target='_blank' href='" . $_SESSION[$guid]["absoluteURL"] . "'><img height='100px' width='400px' class='School Logo' alt='Logo' src='" . $_SESSION[$guid]["absoluteURL"] . "/" . $_SESSION[$guid]["organisationLogo"] . "'/></a>";
$return .= "</div>";
}
//Receipt Text
$receiptText = getSettingByScope($connection2, "Finance", "receiptText");
if ($receiptText != "") {
$return .= "<p>";
$return .= $receiptText;
$return .= "</p>";
}
$style = "";
$style2 = "";
$style3 = "";
$style4 = "";
if ($email == TRUE) {
$style = "border-top: 1px solid #333; ";
$style2 = "border-bottom: 1px solid #333; ";
$style3 = "background-color: #f0f0f0; ";
$style4 = "background-color: #f6f6f6; ";
}
//Receipt Details
$return .= "<table cellspacing='0' style='width: 100%'>";
$return .= "<tr>";
$return .= "<td style='padding-top: 15px; padding-left: 10px; vertical-align: top; {$style} {$style3}' colspan=3>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Receipt To') . " (" . $row["invoiceTo"] . ")</span><br/>";
if ($row["invoiceTo"] == "Company") {
$invoiceTo = "";
if ($row["companyContact"] != "") {
$invoiceTo .= $row["companyContact"] . ", ";
}
if ($row["companyName"] != "") {
$invoiceTo .= $row["companyName"] . ", ";
}
if ($row["companyAddress"] != "") {
$invoiceTo .= $row["companyAddress"] . ", ";
}
$return .= substr($invoiceTo, 0, -2);
} else {
try {
$dataParents = array("gibbonFinanceInvoiceeID" => $row["gibbonFinanceInvoiceeID"]);
$sqlParents = "SELECT parent.title, parent.surname, parent.preferredName, parent.email, parent.address1, parent.address1District, parent.address1Country, homeAddress, homeAddressDistrict, homeAddressCountry FROM gibbonFinanceInvoicee JOIN gibbonPerson AS student ON (gibbonFinanceInvoicee.gibbonPersonID=student.gibbonPersonID) JOIN gibbonFamilyChild ON (gibbonFamilyChild.gibbonPersonID=student.gibbonPersonID) JOIN gibbonFamily ON (gibbonFamilyChild.gibbonFamilyID=gibbonFamily.gibbonFamilyID) JOIN gibbonFamilyAdult ON (gibbonFamily.gibbonFamilyID=gibbonFamilyAdult.gibbonFamilyID) JOIN gibbonPerson AS parent ON (gibbonFamilyAdult.gibbonPersonID=parent.gibbonPersonID) WHERE gibbonFinanceInvoiceeID=:gibbonFinanceInvoiceeID AND (contactPriority=1 OR (contactPriority=2 AND contactEmail='Y')) ORDER BY contactPriority, surname, preferredName";
$resultParents = $connection2->prepare($sqlParents);
$resultParents->execute($dataParents);
} catch (PDOException $e) {
$return .= "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultParents->rowCount() < 1) {
$return .= "<div class='warning'>" . _('There are no family members available to send this receipt to.') . "</div>";
} else {
$return .= "<ul style='margin-top: 3px; margin-bottom: 3px'>";
while ($rowParents = $resultParents->fetch()) {
$return .= "<li>";
$invoiceTo = "";
$invoiceTo .= "<b>" . formatName(htmlPrep($rowParents["title"]), htmlPrep($rowParents["preferredName"]), htmlPrep($rowParents["surname"]), "Parent", false) . "</b>, ";
if ($rowParents["address1"] != "") {
$invoiceTo .= $rowParents["address1"] . ", ";
if ($rowParents["address1District"] != "") {
$invoiceTo .= $rowParents["address1District"] . ", ";
}
if ($rowParents["address1Country"] != "") {
$invoiceTo .= $rowParents["address1Country"] . ", ";
}
} else {
$invoiceTo .= $rowParents["homeAddress"] . ", ";
if ($rowParents["homeAddressDistrict"] != "") {
$invoiceTo .= $rowParents["homeAddressDistrict"] . ", ";
}
if ($rowParents["homeAddressCountry"] != "") {
$invoiceTo .= $rowParents["homeAddressCountry"] . ", ";
}
}
$return .= substr($invoiceTo, 0, -2);
$return .= "</li>";
}
$return .= "</ul>";
}
}
$return .= "</td>";
$return .= "</tr>";
$return .= "<tr>";
$return .= "<td style='width: 33%; padding-top: 15px; padding-left: 10px; vertical-align: top; {$style} {$style4}'>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Fees For') . "</span><br/>";
$return .= formatName("", htmlPrep($row["preferredName"]), htmlPrep($row["surname"]), "Student", true) . "<br/><span style='font-style: italic; font-size: 85%'>" . _('Roll Group') . " " . $row["rollgroup"] . "</span><br/>";
$return .= "</td>";
$return .= "<td style='width: 33%; padding-top: 15px; vertical-align: top; {$style} {$style4}'>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Status') . "</span><br/>";
$return .= $row["status"];
$return .= "</td>";
$return .= "<td style='width: 33%; padding-top: 15px; vertical-align: top; {$style} {$style4}'>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Schedule') . "</span><br/>";
if ($row["billingScheduleType"] == "Ad Hoc") {
$return .= _("Ad Hoc");
} else {
try {
$dataSched = array("gibbonFinanceBillingScheduleID" => $row["gibbonFinanceBillingScheduleID"]);
$sqlSched = "SELECT * FROM gibbonFinanceBillingSchedule WHERE gibbonFinanceBillingScheduleID=:gibbonFinanceBillingScheduleID";
$resultSched = $connection2->prepare($sqlSched);
$resultSched->execute($dataSched);
} catch (PDOException $e) {
$return .= "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultSched->rowCount() == 1) {
$rowSched = $resultSched->fetch();
$return .= $rowSched["name"];
}
}
$return .= "</td>";
$return .= "</tr>";
$return .= "<tr>";
$return .= "<td style='width: 33%; padding-top: 15px; padding-left: 10px; vertical-align: top; {$style} {$style2} {$style3}'>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Due Date') . "</span><br/>";
$return .= dateConvertBack($guid, $row["invoiceDueDate"]);
$return .= "</td>";
$return .= "<td style='width: 33%; padding-top: 15px; vertical-align: top; {$style} {$style2} {$style3}'>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Date Paid') . "</span><br/>";
$return .= dateConvertBack($guid, $row["paidDate"]);
$return .= "</td>";
$return .= "<td style='width: 33%; padding-top: 15px; vertical-align: top; {$style} {$style2} {$style3}'>";
$return .= "<span style='font-size: 115%; font-weight: bold'>" . _('Invoice Number') . "</span><br/>";
$invoiceNumber = getSettingByScope($connection2, "Finance", "invoiceNumber");
if ($invoiceNumber == "Person ID + Invoice ID") {
$return .= ltrim($row["gibbonPersonID"], "0") . "-" . ltrim($gibbonFinanceInvoiceID, "0");
} else {
if ($invoiceNumber == "Student ID + Invoice ID") {
$return .= ltrim($row["studentID"], "0") . "-" . ltrim($gibbonFinanceInvoiceID, "0");
} else {
$return .= ltrim($gibbonFinanceInvoiceID, "0");
}
}
$return .= "</td>";
$return .= "</tr>";
$return .= "</table>";
//Fee table
$return .= "<h3 style='padding-top: 40px; padding-left: 10px; margin: 0px; {$style4}'>";
$return .= _("Fee Table");
$return .= "</h3>";
$feeTotal = 0;
try {
$dataFees["gibbonFinanceInvoiceID"] = $row["gibbonFinanceInvoiceID"];
$sqlFees = "SELECT gibbonFinanceInvoiceFee.gibbonFinanceInvoiceFeeID, gibbonFinanceInvoiceFee.feeType, gibbonFinanceFeeCategory.name AS category, gibbonFinanceInvoiceFee.name AS name, gibbonFinanceInvoiceFee.fee, gibbonFinanceInvoiceFee.description AS description, NULL AS gibbonFinanceFeeID, gibbonFinanceInvoiceFee.gibbonFinanceFeeCategoryID AS gibbonFinanceFeeCategoryID, sequenceNumber FROM gibbonFinanceInvoiceFee JOIN gibbonFinanceFeeCategory ON (gibbonFinanceInvoiceFee.gibbonFinanceFeeCategoryID=gibbonFinanceFeeCategory.gibbonFinanceFeeCategoryID) WHERE gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID ORDER BY sequenceNumber";
$resultFees = $connection2->prepare($sqlFees);
$resultFees->execute($dataFees);
} catch (PDOException $e) {
$return .= "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultFees->rowCount() < 1) {
$return .= "<div class='error'>";
$return .= _("There are no records to display");
$return .= "</div>";
} else {
$return .= "<table cellspacing='0' style='width: 100%; {$style4}'>";
$return .= "<tr class='head'>";
$return .= "<th style='text-align: left; padding-left: 10px'>";
$return .= _("Name");
$return .= "</th>";
$return .= "<th style='text-align: left'>";
$return .= _("Category");
$return .= "</th>";
$return .= "<th style='text-align: left'>";
$return .= _("Description");
$return .= "</th>";
$return .= "<th style='text-align: left'>";
$return .= _("Fee") . "<br/>";
if ($currency != "") {
$return .= "<span style='font-style: italic; font-size: 85%'>" . $currency . "</span>";
}
$return .= "</th>";
$return .= "</tr>";
$count = 0;
$rowNum = "odd";
while ($rowFees = $resultFees->fetch()) {
if ($count % 2 == 0) {
$rowNum = "even";
} else {
$rowNum = "odd";
}
$count++;
$return .= "<tr style='height: 25px' class={$rowNum}>";
$return .= "<td style='padding-left: 10px'>";
$return .= $rowFees["name"];
$return .= "</td>";
$return .= "<td>";
$return .= $rowFees["category"];
$return .= "</td>";
$return .= "<td>";
$return .= $rowFees["description"];
$return .= "</td>";
$return .= "<td>";
if (substr($currency, 4) != "") {
$return .= substr($currency, 4) . " ";
}
$return .= number_format($rowFees["fee"], 2, ".", ",");
$feeTotal += $rowFees["fee"];
$return .= "</td>";
$return .= "</tr>";
}
$return .= "<tr style='height: 35px'>";
$return .= "<td colspan=3 style='text-align: right'>";
$return .= "<b>" . _('Invoice Total:') . "</b>";
$return .= "</td>";
$return .= "<td>";
if (substr($currency, 4) != "") {
$return .= substr($currency, 4) . " ";
}
$return .= "<b>" . number_format($feeTotal, 2, ".", ",") . "</b>";
$return .= "</td>";
$return .= "</tr>";
$return .= "<tr style='height: 35px' class='current'>";
$return .= "<td colspan=3 style='text-align: right; {$style2}'>";
$return .= "<b>" . _('Amount Paid:') . "</b>";
$return .= "</td>";
$return .= "<td style='{$style2}'>";
if (substr($currency, 4) != "") {
$return .= substr($currency, 4) . " ";
}
$return .= "<b>" . number_format($row["paidAmount"], 2, ".", ",") . "</b>";
$return .= "</td>";
$return .= "</tr>";
}
$return .= "</table>";
//Invoice Notes
$receiptNotes = getSettingByScope($connection2, "Finance", "receiptNotes");
if ($receiptNotes != "") {
$return .= "<h3 style='margin-top: 40px'>";
$return .= _("Notes");
$return .= "</h3>";
$return .= "<p>";
$return .= $receiptNotes;
$return .= "</p>";
}
return $return;
}
}
print "<b>" . $terms[$termCount][1] . "</b>";
print "</td>";
print "<td colspan=6>";
print dateConvertBack($guid, $terms[$termCount][0]);
print "</td>";
print "</tr>";
$termCount++;
}
}
if (@$terms[$termCount][0] != "") {
print "<tr class='dull'>";
print "<td>";
print "<b><u>" . $terms[$termCount][1] . "</u></b>";
print "</td>";
print "<td colspan=6>";
print dateConvertBack($guid, $terms[$termCount][0]);
print "</td>";
print "</tr>";
}
print "</table>";
}
}
}
}
}
}
}
}
}
}
if ($gibbonPersonID != "") {
include "./moduleFunctions.php";
//New PDO DB connection
try {
$connection2 = new PDO("mysql:host={$databaseServer};dbname={$databaseName};charset=utf8", $databaseUsername, $databasePassword);
$connection2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$connection2->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
echo $e->getMessage();
}
@session_start();
//Set timezone from session variable
date_default_timezone_set($_SESSION[$guid]["timezone"]);
$gibbonRollGroupID = $_POST["gibbonRollGroupID"];
$currentDate = $_POST["currentDate"];
$today = date("Y-m-d");
$URL = $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_POST["address"]) . "/attendance_take_byRollGroup.php&gibbonRollGroupID={$gibbonRollGroupID}¤tDate=" . dateConvertBack($guid, $currentDate);
if (isActionAccessible($guid, $connection2, "/modules/Attendance/attendance_take_byRollGroup.php") == FALSE) {
//Fail 0
$URL .= "&updateReturn=fail0";
header("Location: {$URL}");
} else {
//Proceed!
//Check if school year specified
if ($gibbonRollGroupID == "" and $currentDate == "") {
//Fail1
$URL .= "&updateReturn=fail1";
header("Location: {$URL}");
} else {
try {
$data = array("gibbonRollGroupID" => $gibbonRollGroupID);
$sql = "SELECT * FROM gibbonRollGroup WHERE gibbonRollGroupID=:gibbonRollGroupID";
print "<b>" . $_SESSION[$guid]["country"] . " " . _('Visa Expiry Date') . "</b><br/>";
}
print "<span style='font-size: 90%'><i>Format ";
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
print $_SESSION[$guid]["i18n"]["dateFormat"];
}
print ". " . _('If relevant.') . "</i></span>";
?>
</td>
<td class="right">
<?php
$value = "";
if ($row["visaExpiryDate"] != NULL and $row["visaExpiryDate"] != "" and $row["visaExpiryDate"] != "0000-00-00") {
$value = dateConvertBack($guid, $row["visaExpiryDate"]);
}
?>
<input name="visaExpiryDate" id="visaExpiryDate" maxlength=10 value="<?php
print $value;
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var visaExpiryDate=new LiveValidation('visaExpiryDate');
visaExpiryDate.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
?>
<br/></i></span>
</td>
<td class="right">
<?php
if ($viewBy == "date") {
?>
<input readonly name="date" id="date" maxlength=10 value="<?php
print dateConvertBack($guid, $date);
?>
" type="text" style="width: 300px">
<?php
} else {
?>
<input name="date" id="date" maxlength=10 value="<?php
print dateConvertBack($guid, $nextDate);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var date=new LiveValidation('date');
date.add(Validate.Presence);
date.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
if ($row["status"] == "Paid" or $row["status"] == "Refunded") {
?>
<tr>
<td>
<b><?php
print _('Date Paid');
?>
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Date of payment, not entry to system.');
?>
</i></span>
</td>
<td class="right">
<input readonly name="paidDate" id="paidDate" maxlength=10 value="<?php
print dateConvertBack($guid, $row["paidDate"]);
?>
" type="text" style="width: 300px">
</td>
</tr>
<tr>
<td>
<b><?php
print _('Amount Paid');
?>
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Final amount paid.');
?>
<?php
if ($_SESSION[$guid]["currency"] != "") {
$loanLength = 7;
}
?>
<td>
<b><?php
print _('Expected Return Date');
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print sprintf(_('Default loan length is %1$s day(s).'), $loanLength);
?>
</i></span>
</td>
<td class="right">
<input name="returnExpected" id="returnExpected" maxlength=10 value="<?php
print dateConvertBack($guid, date("Y-m-d", time() + 24 * 60 * 60 * $loanLength));
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var returnExpected=new LiveValidation('returnExpected');
returnExpected.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
try {
$dataYearGroup = array("gibbonRollGroupID" => $row["gibbonRollGroupID"]);
$sqlYearGroup = "SELECT * FROM gibbonRollGroup WHERE gibbonRollGroupID=:gibbonRollGroupID";
$resultYearGroup = $connection2->prepare($sqlYearGroup);
$resultYearGroup->execute($dataYearGroup);
} catch (PDOException $e) {
}
if ($resultYearGroup->rowCount() == 1) {
$rowYearGroup = $resultYearGroup->fetch();
if ($rowYearGroup["name"] != "") {
$body .= _("Roll Group") . ": " . $rowYearGroup["name"] . "\n";
}
}
}
if ($row["dateStart"] != "") {
$body .= _("Start Date") . ": " . dateConvertBack($guid, $row["dateStart"]) . "\n";
}
$headers = "From: " . $_SESSION[$guid]["organisationAdministratorEmail"];
if (mail($to, $subject, $body, $headers)) {
print "<div class='success'>";
print sprintf(_('A request to create a student email address and/or website address was successfully sent to %1$s.'), $_SESSION[$guid]["organisationAdministratorName"]);
print "</div>";
} else {
print "<div class='error'>";
print sprintf(_('A request to create a student email address and/or website address failed. Please contact %1$s to request these manually.'), $_SESSION[$guid]["organisationAdministratorName"]);
print "</div>";
}
}
//ATTEMPT AUTOMATIC HOUSE ASSIGNMENT
$gibbonHouseID = NULL;
$house = "";
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Final Payment Date.') . "<br/>" . _('Format:');
?>
<?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
print $_SESSION[$guid]["i18n"]["dateFormat"];
}
?>
<br/></i></span>
</td>
<td class="right">
<input name="invoiceDueDate" id="invoiceDueDate" maxlength=10 value="<?php
print dateConvertBack($guid, $row["invoiceDueDate"]);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var invoiceDueDate=new LiveValidation('invoiceDueDate');
invoiceDueDate.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
<td style='width: 275px'>
<b><?php
print _('Date');
?>
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Must be unique.');
?>
<?php
print _('This value cannot be changed.');
?>
</i></span>
</td>
<td class="right">
<input readonly name="date" id="date" maxlength=10 value="<?php
print dateConvertBack($guid, date("Y-m-d", $dateStamp));
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var date=new LiveValidation('date');
date.add(Validate.Presence);
date.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
print "<td>";
try {
$dataUpdater = array("gibbonPersonIDUpdater" => $row["gibbonPersonIDUpdater"]);
$sqlUpdater = "SELECT gibbonPerson.title, gibbonPerson.surname, gibbonPerson.preferredName FROM gibbonPerson WHERE gibbonPersonID=:gibbonPersonIDUpdater";
$resultUpdater = $connection2->prepare($sqlUpdater);
$resultUpdater->execute($dataUpdater);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultUpdater->rowCount() == 1) {
$rowUpdater = $resultUpdater->fetch();
print formatName($rowUpdater["title"], $rowUpdater["preferredName"], $rowUpdater["surname"], "Parent", false);
}
print "</td>";
print "<td>";
print dateConvertBack($guid, substr($row["timestamp"], 0, 10)) . " at " . substr($row["timestamp"], 11, 5);
print "</td>";
print "<td>";
print $row["status"];
print "</td>";
print "<td>";
if ($row["status"] == "Pending") {
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/data_finance_edit.php&gibbonFinanceInvoiceeUpdateID=" . $row["gibbonFinanceInvoiceeUpdateID"] . "'><img title='" . _('Edit') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/config.png'/></a> ";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/data_finance_delete.php&gibbonFinanceInvoiceeUpdateID=" . $row["gibbonFinanceInvoiceeUpdateID"] . "'><img title='" . _('Delete') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/garbage.png'/></a>";
}
print "</td>";
print "</tr>";
}
print "</table>";
if ($result->rowCount() > $_SESSION[$guid]["pagination"]) {
printPagination($guid, $result->rowCount(), $page, $_SESSION[$guid]["pagination"], "bottom");
function rubricView($guid, $connection2, $gibbonRubricID, $mark, $gibbonPersonID = "", $contextDBTable = "", $contextDBTableIDField = "", $contextDBTableID = "", $contextDBTableGibbonRubricIDField = "", $contextDBTableNameField = "", $contextDBTableDateField = "")
{
$output = false;
try {
$data = array("gibbonRubricID" => $gibbonRubricID);
$sql = "SELECT * FROM gibbonRubric WHERE gibbonRubricID=:gibbonRubricID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($result->rowCount() != 1) {
print "<div class='error'>";
print _("The specified record cannot be found.");
print "</div>";
} else {
$row = $result->fetch();
//Get rows, columns and cells
try {
$dataRows = array("gibbonRubricID" => $gibbonRubricID);
$sqlRows = "SELECT * FROM gibbonRubricRow WHERE gibbonRubricID=:gibbonRubricID ORDER BY sequenceNumber";
$resultRows = $connection2->prepare($sqlRows);
$resultRows->execute($dataRows);
} catch (PDOException $e) {
}
$rowCount = $resultRows->rowCount();
try {
$dataColumns = array("gibbonRubricID" => $gibbonRubricID);
$sqlColumns = "SELECT * FROM gibbonRubricColumn WHERE gibbonRubricID=:gibbonRubricID ORDER BY sequenceNumber";
$resultColumns = $connection2->prepare($sqlColumns);
$resultColumns->execute($dataColumns);
} catch (PDOException $e) {
}
$columnCount = $resultColumns->rowCount();
try {
$dataCells = array("gibbonRubricID" => $gibbonRubricID);
$sqlCells = "SELECT * FROM gibbonRubricCell WHERE gibbonRubricID=:gibbonRubricID";
$resultCells = $connection2->prepare($sqlCells);
$resultCells->execute($dataCells);
} catch (PDOException $e) {
}
$cellCount = $resultCells->rowcount();
if ($rowCount <= 0 or $columnCount <= 0) {
$output .= "<div class='error'>";
$output .= _("The rubric cannot be drawn.");
$output .= "</div>";
} else {
$count = 0;
$rows = array();
while ($rowRows = $resultRows->fetch()) {
$rows[$count][0] = $rowRows["gibbonRubricRowID"];
$rows[$count][1] = $rowRows["title"];
$rows[$count][2] = $rowRows["sequenceNumber"];
$rows[$count][3] = $rowRows["gibbonOutcomeID"];
$count++;
}
$count = 0;
$columns = array();
while ($rowColumns = $resultColumns->fetch()) {
$columns[$count][0] = $rowColumns["gibbonRubricColumnID"];
$columns[$count][1] = $rowColumns["title"];
$columns[$count][2] = $rowColumns["sequenceNumber"];
$columns[$count][3] = $rowColumns["gibbonScaleGradeID"];
$count++;
}
$cells = array();
while ($rowCells = $resultCells->fetch()) {
$cells[$rowCells["gibbonRubricRowID"]][$rowCells["gibbonRubricColumnID"]][0] = $rowCells["contents"];
$cells[$rowCells["gibbonRubricRowID"]][$rowCells["gibbonRubricColumnID"]][1] = $rowCells["gibbonRubricCellID"];
}
//Get other uses of this rubric in this context
$contexts = array();
$contextCount = 0;
if ($contextDBTable != "" and $contextDBTableIDField != "" and $contextDBTableID != "" and $contextDBTableGibbonRubricIDField != "" and $contextDBTableNameField != "" and $contextDBTableDateField != "") {
try {
$dataContext = array("gibbonPersonID" => $gibbonPersonID);
$sqlContext = "SELECT * FROM gibbonRubricEntry JOIN {$contextDBTable} ON (gibbonRubricEntry.contextDBTableID={$contextDBTable}.{$contextDBTableIDField} AND gibbonRubricEntry.gibbonRubricID={$contextDBTable}.{$contextDBTableGibbonRubricIDField}) JOIN gibbonRubricCell ON (gibbonRubricEntry.gibbonRubricCellID=gibbonRubricCell.gibbonRubricCellID) WHERE contextDBTable='{$contextDBTable}' AND gibbonRubricEntry.gibbonPersonID=:gibbonPersonID AND NOT {$contextDBTableDateField} IS NULL ORDER BY {$contextDBTableDateField} DESC";
$resultContext = $connection2->prepare($sqlContext);
$resultContext->execute($dataContext);
} catch (PDOException $e) {
print $e->getMessage();
}
while ($rowContext = $resultContext->fetch()) {
if (isset($cells[$rowContext["gibbonRubricRowID"]][$rowContext["gibbonRubricColumnID"]][2])) {
$cells[$rowContext["gibbonRubricRowID"]][$rowContext["gibbonRubricColumnID"]][2] .= $rowContext[$contextDBTableNameField] . " (" . dateConvertBack($guid, $rowContext[$contextDBTableDateField]) . ")<br/>";
} else {
$cells[$rowContext["gibbonRubricRowID"]][$rowContext["gibbonRubricColumnID"]][2] = $rowContext[$contextDBTableNameField] . " (" . dateConvertBack($guid, $rowContext[$contextDBTableDateField]) . ")<br/>";
}
}
}
if ($mark == TRUE) {
print "<p>";
print _("Click on any of the cells below to highlight them. Data is saved automatically after each click.");
print "</p>";
}
//Controls for viewing mode
if ($gibbonPersonID != "") {
$output .= "<script type='text/javascript'>";
$output .= "\$(document).ready(function(){";
$output .= "\$('div.historical').css('display','none');";
$output .= "\$('#type').change(function(){";
$output .= "if (\$('select.type option:selected').val()=='Current' ) {";
$output .= "\$('div.historical').css('display','none');";
$output .= "\$('div.currentView').css('display','block');";
$output .= "} ";
$output .= "else if (\$('select.type option:selected').val()=='Historical' ) {";
$output .= "\$('div.currentView').css('display','none');";
$output .= "\$('div.historical').css('display','block');";
$output .= "}";
$output .= "});";
$output .= "});";
$output .= "</script>";
$output .= "<div class='linkTop'>";
$output .= "Viewing Mode: <select name='type' id='type' class='type' style='width: 152px; float: none'>";
$output .= "<option id='type' name='type' value='Current'>" . _('Current') . "</option>";
$output .= "<option id='type' name='type' value='Historical'>" . _('Historical Data') . "</option>";
$output .= "</select>";
$output .= "</div>";
}
$output .= "<style type=\"text/css\">";
$output .= "table.rubric { width: 100%; border-collapse: collapse; border: 1px solid #000 }";
$output .= "table.rubric tr { border: 1px solid #000 }";
$output .= "table.rubric td { border: 1px solid #000 }";
$output .= "</style>";
$output .= "<form method='post' action='" . $_SESSION[$guid]['absoluteURL'] . "/modules/" . $_SESSION[$guid]["module"] . "/rubrics_data_editProcess.php?gibbonRubricID={$gibbonRubricID}&gibbonPersonID={$gibbonPersonID}'>";
$output .= "<table cellspacing='0' class='rubric'>";
//Create header
$output .= "<tr class='head'>";
$output .= "<td style='width: 100px; background: none; background-color: #ffffff; border-left: 1px solid #fff; border-top: 1px solid #fff'></td>";
for ($n = 0; $n < $columnCount; $n++) {
$output .= "<td style='vertical-align: bottom'>";
if ($columns[$n][3] != "") {
try {
$dataOutcome = array("gibbonScaleGradeID" => $columns[$n][3]);
$sqlOutcome = "SELECT * FROM gibbonScaleGrade WHERE gibbonScaleGradeID=:gibbonScaleGradeID";
$resultOutcome = $connection2->prepare($sqlOutcome);
$resultOutcome->execute($dataOutcome);
} catch (PDOException $e) {
}
if ($resultOutcome->rowCount() != 1) {
print _("Error");
} else {
$rowOutcome = $resultOutcome->fetch();
$output .= "<b>" . _($rowOutcome["descriptor"]) . " (" . _($rowOutcome["value"]) . ")</b><br/>";
//Try to get scale name
if ($row["gibbonScaleID"] != "") {
try {
$dataScale = array("gibbonScaleID" => $row["gibbonScaleID"]);
$sqlScale = "SELECT * FROM gibbonScale WHERE gibbonScaleID=:gibbonScaleID";
$resultScale = $connection2->prepare($sqlScale);
$resultScale->execute($dataScale);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultScale->rowCount() == 1) {
$rowScale = $resultScale->fetch();
}
}
if ($rowScale["name"] != "") {
$output .= "<span style='font-size: 85%'><i>" . _($rowScale["name"]) . " Scale</i></span><br/>";
}
}
} else {
$output .= "<b>" . $columns[$n][1] . "</b><br/>";
}
$output .= "</td>";
}
$output .= "</tr>";
//Create body
for ($i = 0; $i < $rowCount; $i++) {
$output .= "<tr style='height: auto'>";
$output .= "<td style='background: none!important; background-color: #666!important; color: #fff; vertical-align: top; padding: 0px!important'>";
if ($rows[$i][3] != "") {
try {
$dataOutcome = array("gibbonOutcomeID" => $rows[$i][3]);
$sqlOutcome = "SELECT * FROM gibbonOutcome WHERE gibbonOutcomeID=:gibbonOutcomeID";
$resultOutcome = $connection2->prepare($sqlOutcome);
$resultOutcome->execute($dataOutcome);
} catch (PDOException $e) {
}
if ($resultOutcome->rowCount() != 1) {
print _("Error");
} else {
$rowOutcome = $resultOutcome->fetch();
//Check if outcome is specified in unit
if ($contextDBTable != "" and $contextDBTableID != "" and $contextDBTableIDField != "") {
try {
$dataOutcome2 = array("gibbonOutcomeID" => $rows[$i][3], "contextDBTableID" => $contextDBTableID);
$sqlOutcome2 = "SELECT * FROM gibbonOutcome JOIN gibbonUnitOutcome ON (gibbonUnitOutcome.gibbonOutcomeID=gibbonOutcome.gibbonOutcomeID) JOIN {$contextDBTable} ON ({$contextDBTable}.gibbonUnitID=gibbonUnitOutcome.gibbonUnitID) WHERE gibbonOutcome.gibbonOutcomeID=:gibbonOutcomeID AND {$contextDBTableIDField}=:contextDBTableID";
$resultOutcome2 = $connection2->prepare($sqlOutcome2);
$resultOutcome2->execute($dataOutcome2);
} catch (PDOException $e) {
}
if ($resultOutcome2->rowCount()) {
$output .= "<img style='float: right' title='This outcome is one of the unit outcomes.' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/iconTick.png'/> ";
}
}
if ($rowOutcome["category"] == "") {
$output .= "<span title='" . htmlprep($rowOutcome["description"]) . "'><b>" . $rowOutcome["name"] . "</b></span><br/>";
} else {
$output .= "<span title='" . htmlprep($rowOutcome["description"]) . "'><b>" . $rowOutcome["name"] . "</b><i> - " . $rowOutcome["category"] . "</i></span><br/>";
}
$output .= "<span style='font-size: 85%'><i>" . $rowOutcome["scope"] . " " . _('Outcome') . "</i></span><br/>";
}
} else {
$output .= "<b>" . $rows[$i][1] . "</b><br/>";
}
$output .= "</td>";
for ($n = 0; $n < $columnCount; $n++) {
if ($mark == TRUE) {
$output .= "<script type='text/javascript'>";
$output .= "\$(document).ready(function(){";
$output .= "\$(\"#" . $rows[$i][0] . "-" . $columns[$n][0] . "\").click(function(){";
$output .= "if (\$(\"#" . $rows[$i][0] . "-" . $columns[$n][0] . "\").css('background-color')==\"rgb(251, 251, 251)\" ) {";
$output .= "\$(\"#" . $rows[$i][0] . "-" . $columns[$n][0] . "\").css('background', 'none').css('background-color', '#79FA74');";
$output .= "var request=\$.ajax({ url: \"" . $_SESSION[$guid]["absoluteURL"] . "/modules/Rubrics/rubrics_data_saveAjax.php\", type: \"GET\", data: {mode: \"Add\", gibbonRubricID : \"" . $gibbonRubricID . "\", gibbonPersonID : \"" . $gibbonPersonID . "\",gibbonRubricCellID : \"" . $cells[$rows[$i][0]][$columns[$n][0]][1] . "\",contextDBTable : \"" . $contextDBTable . "\",contextDBTableID : \"" . $contextDBTableID . "\"}, dataType: \"html\"});";
$output .= "}";
$output .= "else {";
$output .= "\$(\"#" . $rows[$i][0] . "-" . $columns[$n][0] . "\").css('background', 'none').css('background-color', '#fbfbfb');";
$output .= "var request=\$.ajax({ url: \"" . $_SESSION[$guid]["absoluteURL"] . "/modules/Rubrics/rubrics_data_saveAjax.php\", type: \"GET\", data: {mode: \"Remove\", gibbonRubricID : \"" . $gibbonRubricID . "\", gibbonPersonID : \"" . $gibbonPersonID . "\",gibbonRubricCellID : \"" . $cells[$rows[$i][0]][$columns[$n][0]][1] . "\",contextDBTable : \"" . $contextDBTable . "\",contextDBTableID : \"" . $contextDBTableID . "\"}, dataType: \"html\"});";
$output .= "}";
$output .= "});";
$output .= "});";
$output .= "</script>";
}
try {
$dataEntry = array("gibbonRubricCellID" => $cells[$rows[$i][0]][$columns[$n][0]][1], "gibbonPersonID" => $gibbonPersonID, "contextDBTable" => $contextDBTable, "contextDBTableID" => $contextDBTableID);
$sqlEntry = "SELECT * FROM gibbonRubricEntry WHERE gibbonRubricCellID=:gibbonRubricCellID AND gibbonPersonID=:gibbonPersonID AND contextDBTable=:contextDBTable AND contextDBTableID=:contextDBTableID";
$resultEntry = $connection2->prepare($sqlEntry);
$resultEntry->execute($dataEntry);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
$bgcolor = "#fbfbfb";
if ($resultEntry->rowCount() == 1) {
$bgcolor = "#79FA74";
}
$output .= "<td id='" . $rows[$i][0] . "-" . $columns[$n][0] . "' style='background: none; background-color: {$bgcolor}; height: 100%; vertical-align: top'>";
$output .= "<div class='currentView' style='font-size: 90%'>" . $cells[$rows[$i][0]][$columns[$n][0]][0] . "</div>";
$output .= "<div class='historical' style='font-size: 90%'>";
if (isset($cells[$rows[$i][0]][$columns[$n][0]][2])) {
$arrayHistorical = explode("<br/>", $cells[$rows[$i][0]][$columns[$n][0]][2]);
$countHistorical = count($arrayHistorical) - 1;
} else {
$arrayHistorical = array();
$countHistorical = 0;
}
$countHistorical = count($arrayHistorical) - 1;
if ($countHistorical > 0) {
$output .= "<b><u>" . _('Total Occurences:') . " " . $countHistorical . "</u></b><br/>";
for ($h = 0; $h < $countHistorical; $h++) {
if ($h < 7) {
$output .= $h + 1 . ") " . $arrayHistorical[$h] . "<br/>";
}
}
if ($countHistorical > 7) {
$output .= "<b>" . _('Older occurrences not shown...') . "</b>";
}
}
$output .= "</div>";
$output .= "<input type='hidden' name='gibbonRubricColumnID[]' value='" . $columns[$n][0] . "'>";
$output .= "<input type='hidden' name='gibbonRubricRowID[]' value='" . $rows[$i][0] . "'>";
$output .= "<input type='hidden' name='gibbonRubricCellID[]' value='" . $cells[$rows[$i][0]][$columns[$n][0]][1] . "'>";
$output .= "</td>";
}
$output .= "</tr>";
}
$output .= "</table>";
$output .= "</form>";
}
}
return $output;
}
<span style="font-size: 90%"><i></i></span>
</td>
<td class="right">
<input checked type='checkbox' name='dates[]' value='<?php
print $dateTemp;
?>
'>
</td>
</tr>
<?php
} else {
?>
<tr class='error'>
<td>
<b><?php
print dateConvertBack($guid, $dateTemp);
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print _('Not Available');
?>
</i></span>
</td>
<td class="right">
<input disabled type='checkbox' name='dates[]' value='<?php
print $dateTemp;
?>
'>
</td>
</tr>
<?php
?>
<?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
print $_SESSION[$guid]["i18n"]["dateFormat"];
}
?>
<br/><?php
print _('2. Column is hidden until date is reached.');
?>
</i></span>
</td>
<td class="right">
<input name="completeDate" id="completeDate" maxlength=10 value="<?php
print dateConvertBack($guid, $row2["completeDate"]);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var completeDate=new LiveValidation('completeDate');
completeDate.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
$sqlLog = "SELECT * FROM gibbonAttendanceLogRollGroup, gibbonPerson WHERE gibbonAttendanceLogRollGroup.gibbonPersonIDTaker=gibbonPerson.gibbonPersonID AND gibbonRollGroupID=:gibbonRollGroupID AND date LIKE :date ORDER BY timestampTaken";
$resultLog = $connection2->prepare($sqlLog);
$resultLog->execute($dataLog);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultLog->rowCount() < 1) {
print "<div class='error'>";
print _("Attendance has not been taken for this group yet for the specified date. The entries below are a best-guess based on defaults and information put into the system in advance, not actual data.");
print "</div>";
} else {
print "<div class='success'>";
print _("Attendance has been taken at the following times for the specified date for this group:");
print "<ul>";
while ($rowLog = $resultLog->fetch()) {
print "<li>" . sprintf(_('Recorded at %1$s on %2$s by %3$s.'), substr($rowLog["timestampTaken"], 11), dateConvertBack($guid, substr($rowLog["timestampTaken"], 0, 10)), formatName("", $rowLog["preferredName"], $rowLog["surname"], "Staff", false, true)) . "</li>";
}
print "</ul>";
print "</div>";
}
//Show roll group grid
try {
$dataRollGroup = array("gibbonRollGroupID" => $gibbonRollGroupID);
$sqlRollGroup = "SELECT * FROM gibbonStudentEnrolment INNER JOIN gibbonPerson ON gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID WHERE gibbonRollGroupID=:gibbonRollGroupID AND status='Full' AND (dateStart IS NULL OR dateStart<='" . date("Y-m-d") . "') AND (dateEnd IS NULL OR dateEnd>='" . date("Y-m-d") . "') ORDER BY rollOrder, surname, preferredName";
$resultRollGroup = $connection2->prepare($sqlRollGroup);
$resultRollGroup->execute($dataRollGroup);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultRollGroup->rowCount() < 1) {
print "<div class='error'>";
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Select up to three individual dates.');
?>
</br>Format <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
print $_SESSION[$guid]["i18n"]["dateFormat"];
}
?>
.<br/></i></span>
</td>
<td class="right">
<input name="date1" id="date1" maxlength=10 value="<?php
print dateConvertBack($guid, date("Y-m-d"));
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var date1=new LiveValidation('date1');
date1.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
</td>
</tr>
<tr>
<td>
<b><?php
print _('Last Day');
?>
*</b><br/>
<span style="font-size: 90%"><i><?php
print $_SESSION[$guid]["i18n"]["dateFormat"];
?>
</i></span>
</td>
<td class="right">
<input name="lastDay" id="lastDay" maxlength=10 value="<?php
print dateConvertBack($guid, $row["lastDay"]);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var lastDay=new LiveValidation('lastDay');
lastDay.add(Validate.Presence);
lastDay.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
<?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
} else {
print $_SESSION[$guid]["i18n"]["dateFormat"];
}
?>
<br/><?php
print _('Default: last day of the next term.');
?>
</i></span>
</td>
<td class="right">
<input name="programEnd" id="programEnd" maxlength=10 value="<?php
if ($programEnd != "") {
print dateConvertBack($guid, $programEnd);
}
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var programEnd=new LiveValidation('programEnd');
programEnd.add( Validate.Format, {pattern: <?php
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
print "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
print $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
?>
, failureMessage: "Use <?php
if ($_SESSION[$guid]["i18n"]["dateFormat"] == "") {
print "dd/mm/yyyy";
print "<tr class={$rowNum}>";
print "<td>";
print "<b>" . $row["title"] . "</b><br/>";
print "<span style='font-size: 85%; font-style: italic'>" . $row["budget"] . "</span>";
print "</td>";
print "<td>";
print formatName("", $row["preferredName"], $row["surname"], "Staff", false, true);
print "</td>";
print "<td>";
print $row["status"];
print "</td>";
print "<td>";
print number_format($row["cost"], 2, ".", ",");
print "</td>";
print "<td>";
print dateConvertBack($guid, substr($row["timestampCreator"], 0, 10));
print "</td>";
print "<td>";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/expenses_manage_view.php&gibbonFinanceExpenseID=" . $row["gibbonFinanceExpenseID"] . "&gibbonFinanceBudgetCycleID={$gibbonFinanceBudgetCycleID}&status={$status}&gibbonFinanceBudgetID={$gibbonFinanceBudgetID}'><img title='" . _('View') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/plus.png'/></a> ";
if ($row["status"] == "Requested") {
if (approvalRequired($guid, $_SESSION[$guid]["gibbonPersonID"], $row["gibbonFinanceExpenseID"], $gibbonFinanceBudgetCycleID, $connection2, FALSE) == TRUE) {
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/expenses_manage_approve.php&gibbonFinanceExpenseID=" . $row["gibbonFinanceExpenseID"] . "&gibbonFinanceBudgetCycleID={$gibbonFinanceBudgetCycleID}&status={$status}&gibbonFinanceBudgetID=" . $row["gibbonFinanceBudgetID"] . "'><img title='" . _('Approve/Reject') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/iconTick.png'/></a> ";
}
}
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/expenses_manage_print.php&gibbonFinanceExpenseID=" . $row["gibbonFinanceExpenseID"] . "&gibbonFinanceBudgetCycleID={$gibbonFinanceBudgetCycleID}&status={$status}&gibbonFinanceBudgetID=" . $row["gibbonFinanceBudgetID"] . "'><img title='Print' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/print.png'/></a>";
if ($row["status"] == "Requested" or $row["status"] == "Approved" or $row["status"] == "Ordered") {
print "<a style='margin-left: 4px' href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/expenses_manage_edit.php&gibbonFinanceExpenseID=" . $row["gibbonFinanceExpenseID"] . "&gibbonFinanceBudgetCycleID={$gibbonFinanceBudgetCycleID}&status={$status}&gibbonFinanceBudgetID=" . $row["gibbonFinanceBudgetID"] . "'><img title='" . _('Edit') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/config.png'/></a> ";
}
print "</td>";
print "<td>";
print "<input style='margin-left: -6px' type='checkbox' name='gibbonFinanceExpenseIDs[]' value='" . $row["gibbonFinanceExpenseID"] . "'>";
</td>
</tr>
<tr id="paymentDateRow">
<td>
<b><?php
print _('Date Paid');
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print _('Date of payment, not entry to system.');
?>
</i></span>
</td>
<td class="right">
<input readonly name="paymentDate" id="paymentDate" maxlength=10 value="<?php
print dateConvertBack($guid, $row["paymentDate"]);
?>
" type="text" style="width: 300px">
</td>
</tr>
<tr id="paymentAmountRow">
<td>
<b><?php
print _('Amount Paid');
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print _('Final amount paid.');
?>
<?php
if ($_SESSION[$guid]["currency"] != "") {
}
$count++;
//COLOR ROW BY STATUS!
print "<tr class={$rowNum}>";
print "<td>";
print formatName("", $row["preferredName"], $row["surname"], "Student", true);
print "</td>";
print "<td>";
print $row["email"];
print "</td>";
print "<td>";
print "<b>" . $row["name"] . "</b><br/>";
print "<span style='font-size: 85%; font-style: italic'>" . $row["producer"] . "</span>";
print "</td>";
print "<td>";
print dateConvertBack($guid, $row["returnExpected"]);
print "</td>";
print "<td>";
print (strtotime($today) - strtotime($row["returnExpected"])) / (60 * 60 * 24);
print "</td>";
print "<td>";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/library_lending_item.php&gibbonLibraryItemID=" . $row["gibbonLibraryItemID"] . "&name=&gibbonLibraryTypeID=&gibbonSpaceID=&status='><img title='" . _('Edit') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/config.png'/></a> ";
print "</td>";
print "</tr>";
}
if ($count == 0) {
print "<tr class={$rowNum}>";
print "<td colspan=4>";
print _("There are no records to display.");
print "</td>";
print "</tr>";
$resultPage = $connection2->prepare($sqlPage);
$resultPage->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
while ($row = $resultPage->fetch()) {
if ($count % 2 == 0) {
$rowNum = "even";
} else {
$rowNum = "odd";
}
$count++;
//COLOR ROW BY STATUS!
print "<tr class={$rowNum}>";
print "<td>";
print dateConvertBack($guid, $row["date"]);
print "</td>";
print "<td>";
print $row["course"] . "." . $row["class"];
print "</td>";
print "<td>";
print $row["spaceOld"];
print "</td>";
print "<td>";
print $row["spaceNew"];
print "</td>";
print "<td>";
print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/spaceChange_manage_delete.php&gibbonTTSpaceChangeID=" . $row["gibbonTTSpaceChangeID"] . "'><img title='" . _('Delete') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/garbage.png'/></a>";
print "</td>";
print "</tr>";
}
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($result->rowCount() != 1) {
print "<div class='warning'>";
print _("The selected record does not exist, or you do not have access to it.");
print "</div>";
} else {
$row = $result->fetch();
$extra = "";
if ($viewBy == "class") {
$extra = $row["course"] . "." . $row["class"];
} else {
$extra = dateConvertBack($guid, $date);
}
$params = "";
if ($_GET["date"] != "") {
$params = $params . "&date=" . $_GET["date"];
}
if ($_GET["viewBy"] != "") {
$params = $params . "&viewBy=" . $_GET["viewBy"];
}
if ($_GET["gibbonCourseClassID"] != "") {
$params = $params . "&gibbonCourseClassID=" . $_GET["gibbonCourseClassID"];
}
$params = $params . "&subView={$subView}";
print "<div class='trail'>";
print "<div class='trailHead'><a href='" . $_SESSION[$guid]["absoluteURL"] . "'>" . _("Home") . "</a> > <a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_GET["q"]) . "/" . getModuleEntry($_GET["q"], $connection2, $guid) . "'>" . _(getModuleName($_GET["q"])) . "</a> > <a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_GET["q"]) . "/planner.php{$params}'>" . _('Planner') . " {$extra}</a> > <a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_GET["q"]) . "/planner_view_full.php{$params}&gibbonPlannerEntryID={$gibbonPlannerEntryID}'>" . _('View Lesson Plan') . "</a> > </div><div class='trailEnd'>" . _('Add Comment') . "</div>";
print "</div>";
<input readonly name="programStart" id="programStart" maxlength=10 value="<?php
print dateConvertBack($guid, $row["programStart"]);
?>
" type="text" style="width: 300px">
</td>
</tr>
<tr>
<td>
<b><?php
print _('Program End Date');
?>
</b><br/>
</td>
<td class="right">
<input readonly name="programEnd" id="programEnd" maxlength=10 value="<?php
print dateConvertBack($guid, $row["programEnd"]);
?>
" type="text" style="width: 300px">
</td>
</tr>
<?php
}
?>
<tr>
<td>
<b><?php
print _('Cost');
?>
</b><br/>
<span style="font-size: 90%"><i><?php
print _('For entire programme') . ". " . $_SESSION[$guid]["currency"] . ".";
$dataPerson = array("gibbonPersonID" => $row["gibbonPersonIDOwnership"]);
$sqlPerson = "SELECT title, preferredName, surname FROM gibbonPerson WHERE gibbonPersonID=:gibbonPersonID";
$resultPerson = $connection2->prepare($sqlPerson);
$resultPerson->execute($dataPerson);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($resultPerson->rowCount() == 1) {
$rowPerson = $resultPerson->fetch();
print "<span style='font-size: 85%; font-style: italic'>" . formatName($rowPerson["title"], $rowPerson["preferredName"], $rowPerson["surname"], "Staff", FALSE, TRUE) . "</span>";
}
}
print "</td>";
print "<td>";
print $row["status"] . "<br/>";
print "<span style='font-size: 85%; font-style: italic'>" . $row["borrowable"] . "</span>";
print "</td>";
print "<td>";
if ($row["purchaseDate"] == "") {
print "<i>" . _('Unknown') . "</i><br/>";
} else {
print dateConvertBack($guid, $row["purchaseDate"]) . "<br/>";
}
print "<span style='font-size: 85%; font-style: italic'>" . $row["vendor"] . "</span>";
print "</td>";
print "</tr>";
$count++;
}
print "</table>";
}
}
while ($row = $result->fetch()) {
//Get all homework for the past week, ready for email
$homework = "";
$homework .= "<h2>" . _('Homework') . "</h2>";
try {
$dataHomework = array("gibbonPersonID1" => $row["gibbonPersonID"], "gibbonSchoolYearID1" => $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonPersonID2" => $row["gibbonPersonID"], "gibbonSchoolYearID2" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$sqlHomework = "\n\t\t\t\t\t\t\t(SELECT 'teacherRecorded' AS type, gibbonPlannerEntryID, gibbonUnitID, gibbonHookID, gibbonPlannerEntry.gibbonCourseClassID, gibbonCourse.nameShort AS course, gibbonCourseClass.nameShort AS class, gibbonPlannerEntry.name, date, timeStart, timeEnd, viewableStudents, viewableParents, homework, role, homeworkDueDateTime, homeworkDetails, homeworkSubmission, homeworkSubmissionRequired FROM gibbonPlannerEntry JOIN gibbonCourseClass ON (gibbonPlannerEntry.gibbonCourseClassID=gibbonCourseClass.gibbonCourseClassID) JOIN gibbonCourseClassPerson ON (gibbonCourseClass.gibbonCourseClassID=gibbonCourseClassPerson.gibbonCourseClassID) JOIN gibbonCourse ON (gibbonCourse.gibbonCourseID=gibbonCourseClass.gibbonCourseID) WHERE gibbonCourseClassPerson.gibbonPersonID=:gibbonPersonID1 AND NOT role='Student - Left' AND NOT role='Teacher - Left' AND homework='Y' AND gibbonSchoolYearID=:gibbonSchoolYearID1 AND date>'" . date('Y-m-d', strtotime("-1 week")) . "' AND date<='" . date("Y-m-d") . "')\n\t\t\t\t\t\t\tUNION\n\t\t\t\t\t\t\t(SELECT 'studentRecorded' AS type, gibbonPlannerEntry2.gibbonPlannerEntryID, gibbonUnitID, gibbonHookID, gibbonPlannerEntry2.gibbonCourseClassID, gibbonCourse2.nameShort AS course, gibbonCourseClass2.nameShort AS class, gibbonPlannerEntry2.name, date, timeStart, timeEnd, 'Y' AS viewableStudents, 'Y' AS viewableParents, 'Y' AS homework, role, gibbonPlannerEntryStudentHomework.homeworkDueDateTime AS homeworkDueDateTime, gibbonPlannerEntryStudentHomework.homeworkDetails AS homeworkDetails, 'N' AS homeworkSubmission, '' AS homeworkSubmissionRequired FROM gibbonPlannerEntry AS gibbonPlannerEntry2 JOIN gibbonCourseClass AS gibbonCourseClass2 ON (gibbonPlannerEntry2.gibbonCourseClassID=gibbonCourseClass2.gibbonCourseClassID) JOIN gibbonCourseClassPerson AS gibbonCourseClassPerson2 ON (gibbonCourseClass2.gibbonCourseClassID=gibbonCourseClassPerson2.gibbonCourseClassID) JOIN gibbonCourse AS gibbonCourse2 ON (gibbonCourse2.gibbonCourseID=gibbonCourseClass2.gibbonCourseID) JOIN gibbonPlannerEntryStudentHomework ON (gibbonPlannerEntryStudentHomework.gibbonPlannerEntryID=gibbonPlannerEntry2.gibbonPlannerEntryID AND gibbonPlannerEntryStudentHomework.gibbonPersonID=gibbonCourseClassPerson2.gibbonPersonID) WHERE gibbonCourseClassPerson2.gibbonPersonID=:gibbonPersonID2 AND NOT role='Student - Left' AND NOT role='Teacher - Left' AND gibbonSchoolYearID=:gibbonSchoolYearID2 AND date>'" . date('Y-m-d', strtotime("-1 week")) . "' AND date<='" . date("Y-m-d") . "')\n\t\t\t\t\t\t\tORDER BY date, timeStart";
$resultHomework = $connection2->prepare($sqlHomework);
$resultHomework->execute($dataHomework);
} catch (PDOException $e) {
$homework .= $e->getMessage();
}
if ($resultHomework->rowCount() > 0) {
$homework .= "<ul>";
while ($rowHomework = $resultHomework->fetch()) {
$homework .= "<li><b>" . $rowHomework["course"] . "." . $rowHomework["class"] . "</b> - " . $rowHomework["name"] . " - " . sprintf(_('Due on %1$s at %2$s.'), dateConvertBack($guid, substr($rowHomework["homeworkDueDateTime"], 0, 10)), substr($rowHomework["homeworkDueDateTime"], 11, 5)) . "</li>";
}
$homework .= "</ul><br/>";
} else {
$homework .= _("There are no records to display.") . "<br/><br/>";
}
$behaviour = "";
$parentWeeklyEmailSummaryIncludeBehaviour = getSettingByScope($connection2, "Planner", "parentWeeklyEmailSummaryIncludeBehaviour");
if ($parentWeeklyEmailSummaryIncludeBehaviour == "Y") {
//Get behaviour records for the past week, ready for email
$behaviour .= "<h2>" . _('Behaviour') . "</h2>";
try {
$dataBehaviourPositive = array("gibbonPersonID" => $row["gibbonPersonID"], "gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$sqlBehaviourPositive = "SELECT * FROM gibbonBehaviour WHERE gibbonPersonID=:gibbonPersonID AND gibbonSchoolYearID=:gibbonSchoolYearID AND type='Positive' AND date>'" . date('Y-m-d', strtotime("-1 week")) . "' AND date<='" . date("Y-m-d") . "'";
$resultBehaviourPositive = $connection2->prepare($sqlBehaviourPositive);
$resultBehaviourPositive->execute($dataBehaviourPositive);
