print "<select name='{$count}-effortValue' id='{$count}-effortValue' style='width:50px'>";
try {
$dataSelect = array("gibbonScaleID" => $gibbonScaleIDEffort);
$sqlSelect = "SELECT * FROM gibbonScaleGrade WHERE gibbonScaleID=:gibbonScaleID ORDER BY sequenceNumber";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
print "<option value=''></option>";
$sequence = "";
$descriptor = "";
while ($rowSelect = $resultSelect->fetch()) {
if ($rowEntry["effortValue"] == $rowSelect["value"]) {
print "<option selected value='" . htmlPrep($rowSelect["value"]) . "'>" . htmlPrep(_($rowSelect["value"])) . "</option>";
} else {
print "<option value='" . htmlPrep($rowSelect["value"]) . "'>" . htmlPrep(_($rowSelect["value"])) . "</option>";
}
}
print "</select>";
}
print "<div style='height: 20px'>";
if ($row2["gibbonRubricIDEffort"] != "") {
print "<a class='thickbox' href='" . $_SESSION[$guid]["absoluteURL"] . "/fullscreen.php?q=/modules/" . $_SESSION[$guid]["module"] . "/markbook_view_rubric.php&gibbonRubricID=" . $row2["gibbonRubricIDEffort"] . "&gibbonCourseClassID={$gibbonCourseClassID}&gibbonMarkbookColumnID={$gibbonMarkbookColumnID}&gibbonPersonID=" . $rowStudents["gibbonPersonID"] . "&type=effort&width=1100&height=550'><img style='margin-top: 3px' title='" . _('Mark Rubric') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/rubric.png'/></a>";
}
print "</div>";
print "</td>";
}
if ($row2["comment"] == "Y" or $row2["uploadedResponse"] == "Y") {
print "<td style='text-align: right'>";
if ($row2["comment"] == "Y") {
print "<script type='text/javascript'>";
<optgroup label='--<?php
print _('All Enrolled Students by Alphabet');
?>
--'>
<?php
$students = array();
$count = 0;
try {
$dataSelect = array("gibbonSchoolYearID" => $gibbonSchoolYearID);
$sqlSelect = "SELECT gibbonFinanceInvoiceeID, preferredName, surname, gibbonRollGroup.name AS name, dayType FROM gibbonPerson, gibbonStudentEnrolment, gibbonRollGroup, gibbonFinanceInvoicee WHERE gibbonPerson.gibbonPersonID=gibbonStudentEnrolment.gibbonPersonID AND gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID AND gibbonFinanceInvoicee.gibbonPersonID=gibbonPerson.gibbonPersonID AND status='FULL' AND gibbonRollGroup.gibbonSchoolYearID=:gibbonSchoolYearID ORDER BY surname, preferredName";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
print "<option value='" . $rowSelect["gibbonFinanceInvoiceeID"] . "'>" . formatName("", htmlPrep($rowSelect["preferredName"]), htmlPrep($rowSelect["surname"]), "Student", true) . " - " . htmlPrep($rowSelect["name"]) . "</option>";
}
?>
</optgroup>
</select>
</td>
</tr>
<?php
//BILLING TYPE CHOOSER
?>
<tr>
<td>
<b><?php
print _('Scheduling');
?>
name2.add(Validate.Presence);
</script>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Short Name');
?>
*</b><br/>
<span style="font-size: 90%"><i></i></span>
</td>
<td class="right">
<input name="nameShort" id="nameShort" maxlength=10 value="<?php
if (isset($row["nameShort"])) {
print htmlPrep(_($row["nameShort"]));
}
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var nameShort=new LiveValidation('nameShort');
nameShort.add(Validate.Presence);
</script>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Description');
?>
*</b><br/>
$sqlSelect = "SELECT * FROM gibbonScaleGrade WHERE gibbonScaleID=:gibbonScaleID ORDER BY sequenceNumber";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
print "<option value=''></option>";
$sequence = "";
$descriptor = "";
while ($rowSelect = $resultSelect->fetch()) {
$selected = "";
if (!is_null($rowEntry)) {
if ($rowEntry["value"] == $rowSelect["value"]) {
$selected = "selected";
}
}
print "<option {$selected} value='" . $rowSelect["gibbonScaleGradeID"] . "'>" . htmlPrep(_($rowSelect["value"])) . "</option>";
}
print "</select>";
print "</td>";
}
}
?>
<tr>
<td colspan=2 class="right">
<input name="count" id="count" value="<?php
print $count;
?>
" type="hidden">
<input type="submit" value="<?php
print _("Submit");
?>
$output .= "field" . $fieldName . ".add( Validate.Format, {pattern:";
if ($_SESSION[$guid]["i18n"]["dateFormatRegEx"] == "") {
$output .= "/^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\\d\\d\$/i";
} else {
$output .= $_SESSION[$guid]["i18n"]["dateFormatRegEx"];
}
$output .= ", failureMessage: 'Use " . $_SESSION[$guid]["i18n"]["dateFormat"] . ".' } );";
$output .= "</script>";
$output .= "<script type='text/javascript'>";
$output .= "\$(function() {";
$output .= "\$( '#field" . $fieldName . "' ).datepicker();";
$output .= "});";
$output .= "</script>";
} else {
if ($field["type"] == "URL") {
$output .= "<input maxlength='" . $field["options"] . "' name='field" . $fieldName . "' id='field" . $fieldName . "' value='" . htmlPrep($field["default"]) . "' type='text' style='width: 300px'>";
$output .= "<script type='text/javascript'>";
$output .= "var field" . $fieldName . "=new LiveValidation('field" . $fieldName . "');";
$output .= "field" . $fieldName . ".add( Validate.Format, { pattern: /(http|https):\\/\\/(\\w+:{0,1}\\w*@)?(\\S+)(:[0-9]+)?(\\/|\\/([\\w#!:.?+=&%@!\\-\\/]))?/, failureMessage: \"Must start with http://\" } );";
$output .= "</script>";
}
}
}
}
}
$output .= "</td>";
$output .= "</tr>";
//NEED LIVE VALIDATION
if ($field["required"] == "Y") {
if ($field["type"] == "Text" or $field["type"] == "Textarea" or $field["type"] == "Date" or $field["type"] == "URL") {
$output .= "<script type='text/javascript'>";
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;
}
}
<form method="post" action="<?php
print $_SESSION[$guid]["absoluteURL"] . "/modules/" . $_SESSION[$guid]["module"] . "/family_manage_edit_editChildProcess.php?gibbonFamilyID={$gibbonFamilyID}&gibbonPersonID={$gibbonPersonID}&search={$search}";
?>
">
<table class='smallIntBorder' cellspacing='0' style="width: 100%">
<tr>
<td style='width: 275px'>
<b><?php
print _('Child\'s Name');
?>
*</b><br/>
<span style="font-size: 90%"><i></i></span>
</td>
<td class="right">
<input readonly name="child" id="child" maxlength=200 value="<?php
print formatName("", htmlPrep($row["preferredName"]), htmlPrep($row["surname"]), "Student");
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var child=new LiveValidation('child');
child.add(Validate.Exclusion, { within: ['Please select...'], failureMessage: "<?php
print _('Select something!');
?>
"});
</script>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Comment');
print _('This value cannot be changed.');
?>
</i></span>
</td>
<td class="right">
<?php
try {
$dataSelect = array("gibbonPersonID" => $row["gibbonPersonIDStatusResponsible"]);
$sqlSelect = "SELECT gibbonPersonID, surname, preferredName, status FROM gibbonPerson WHERE gibbonPersonID=:gibbonPersonID ORDER BY surname, preferredName";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
if ($resultSelect->rowCount() == 1) {
$rowSelect = $resultSelect->fetch();
print "<input readonly name='gibbonPersonIDStatusResponsiblename' id='gibbonPersonIDStatusResponsiblename' value='" . formatName("", htmlPrep($rowSelect["preferredName"]), htmlPrep($rowSelect["surname"]), "Student", true) . "' type='text' style='width: 300px'>";
print "<input name='gibbonPersonIDStatusResponsible' id='gibbonPersonIDStatusResponsible' value='" . $row["gibbonPersonIDStatusResponsible"] . "' type='hidden' style='width: 300px'>";
}
?>
</td>
</tr>
<tr>
<?php
$loanLength = getSettingByScope($connection2, "Library", "defaultLoanLength");
if (is_numeric($loanLength) == FALSE or $loanLength < 0) {
$loanLength = 7;
}
?>
<td>
<b><?php
print _('Expected Return Date');
print getEditor($guid, TRUE, "body", $signature, 20, true, true, false, true);
?>
</td>
</tr>
<select name="roleCategories[]" id="roleCategories[]" multiple style="display: none">
<?php
try {
$dataSelect = array();
$sqlSelect = "SELECT DISTINCT category FROM gibbonRole ORDER BY category";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
print "<option selected value='" . $rowSelect["category"] . "'>" . htmlPrep(_($rowSelect["category"])) . "</option>";
}
?>
</select>
<tr>
<td>
<span style="font-size: 90%"><i>* <?php
print _("denotes a required field");
?>
</i></span>
</td>
<td class="right">
<input type="submit" value="<?php
print _("Submit");
?>
?>
<br/>
</i></span>
</td>
<td class="right">
<?php
$agreements = explode(",", $studentAgreementOptions);
$agreementChecks = explode(",", $row["studentAgreements"]);
foreach ($agreements as $agreement) {
$checked = "";
foreach ($agreementChecks as $agreementCheck) {
if (trim($agreement) == trim($agreementCheck)) {
$checked = "checked";
}
}
print $agreement . " <input {$checked} type='checkbox' name='studentAgreements[]' value='" . htmlPrep(trim($agreement)) . "'/><br/>";
}
?>
</td>
</tr>
<?php
}
}
//CUSTOM FIELDS
$fields = unserialize($row["fields"]);
$resultFields = getCustomFields($connection2, $guid, $student, $staff, $parent, $other);
if ($resultFields->rowCount() > 0) {
?>
<tr class='break'>
<td colspan=2>
var name2=new LiveValidation('name');
name2.add(Validate.Presence);
</script>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Description');
?>
</b><br/>
<span style="font-size: 90%"><i></i></span>
</td>
<td class="right">
<input name="description" id="description" maxlength=255 value="<?php
print htmlPrep($row["description"]);
?>
" type="text" style="width: 300px">
</td>
</tr>
<tr>
<td>
<b><?php
print _('School Opens');
?>
</b>
</td>
<td class="right">
<select style="width:100px" name="schoolOpenM" id="schoolOpenM">
<?php
print "<option value='Minutes'>" . _('Minutes') . "</option>";
</b>
<span style="font-size: 90%"><i><?php
print _('(CC Self?)');
?>
</i></span>
</td>
<td class="right">
<?php
print $_SESSION[$guid]["email"];
?>
<input type='checkbox' name='emails[]' value='<?php
print $_SESSION[$guid]["email"];
?>
'/>
<input type='hidden' name='names[]' value='<?php
print formatName("", htmlPrep($_SESSION[$guid]["preferredName"]), htmlPrep($_SESSION[$guid]["surname"]), "Parent", FALSE);
?>
'/>
</td>
</tr>
<?php
}
}
}
?>
<tr>
<td>
<span style="font-size: 90%"><i>* <?php
print _("denotes a required field");
?>
">
<table class='smallIntBorder' cellspacing='0' style="width: 100%">
<tr>
<td style='width: 275px'>
<b><?php
print _('Name');
?>
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Must be unique.');
?>
</i></span>
</td>
<td class="right">
<input name="name" id="name" maxlength=30 value="<?php
print htmlPrep($row["name"]);
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var name2=new LiveValidation('name');
name2.add(Validate.Presence);
</script>
</td>
</tr>
<tr>
<td>
<span style="font-size: 90%"><i>* <?php
print _("denotes a required field");
?>
</i></span>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Sequence Number');
?>
*</b><br/>
<span style="font-size: 90%"><i><?php
print _('Must be unique. Controls chronological ordering.');
?>
</i></span>
</td>
<td class="right">
<input name="sequenceNumber" id="sequenceNumber" maxlength=3 value="<?php
if (isset($row["sequenceNumber"])) {
print htmlPrep($row["sequenceNumber"]);
}
?>
" type="text" style="width: 300px">
<script type="text/javascript">
var sequenceNumber=new LiveValidation('sequenceNumber');
sequenceNumber.add(Validate.Numericality);
sequenceNumber.add(Validate.Presence);
</script>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Start Date');
?>
print _('Use Control, Command and/or Shift to select multiple.');
?>
</i></span>
</td>
<td class="right">
<select name="guests[]" id="guests[]" multiple style="width: 302px; height: 150px">
<?php
try {
$dataSelect = array();
$sqlSelect = "SELECT gibbonPersonID, title, preferredName, surname, category FROM gibbonPerson JOIN gibbonRole ON (gibbonPerson.gibbonRoleIDPrimary=gibbonRole.gibbonRoleID) WHERE status='Full' ORDER BY surname, preferredName";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
print "<option value='" . $rowSelect["gibbonPersonID"] . "'>" . formatName(htmlPrep($rowSelect["title"]), htmlPrep($rowSelect["preferredName"]), htmlPrep($rowSelect["surname"]), htmlPrep($rowSelect["category"]), true, true) . "</option>";
}
?>
</select>
</td>
<tr>
<td>
<b><?php
print _('Role');
?>
</b><br/>
</td>
<td class="right">
<select name="role" id="role" style="width: 302px">
<option value="Guest Student"><?php
print _('Guest Student');
}
print "</optgroup>";
print "<optgroup label='--" . _('All Users') . "--'>";
try {
$dataSelect = array();
$sqlSelect = "SELECT gibbonPersonID, surname, preferredName, status FROM gibbonPerson WHERE status='Full' ORDER BY surname, preferredName";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
$selected = "";
if ($row["gibbonPersonIDStatusResponsible"] == $rowSelect["gibbonPersonID"]) {
$selected = "selected";
}
print "<option {$selected} value='" . $rowSelect["gibbonPersonID"] . "'>" . formatName("", htmlPrep($rowSelect["preferredName"]), htmlPrep($rowSelect["surname"]), "Student", true) . "{$expected}</option>";
}
print "</optgroup>";
?>
</select>
</td>
<tr>
<td>
<b><?php
print _('Role');
?>
</b><br/>
</td>
<td class="right">
<select name="role" id="role" style="width: 302px">
<option value="Organiser"><?php
$effort = _($rowEntry["effortValue"]);
}
if ($rowEntry["effortValue"] == "Complete") {
$effort = _("Com");
} else {
if ($rowEntry["effortValue"] == "Incomplete") {
$effort = _("Inc");
}
}
print "<td style='text-align: center;'>";
print "<div {$styleEffort} title='" . htmlPrep($rowEntry["effortDescriptor"]) . "'>{$effort}";
print "</div>";
print "</td>";
print "<td style='text-align: center;'>";
$style = "";
if ($rowEntry["comment"] != "") {
print "<span {$style} title='" . htmlPrep($rowEntry["comment"]) . "'>" . substr($rowEntry["comment"], 0, 10) . "...</span>";
}
print "</td>";
} else {
print "<td style='text-align: center' colspan={$span}>";
print "</td>";
}
}
print "</tr>";
}
print "</table>";
}
}
}
$_SESSION[$guid]["exportToExcelParams"] = "";
<td class="right">
<select style="width: 302px" name="gibbonRollGroupID">
<?php
print "<option value=''></option>";
try {
$dataSelect = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$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()) {
if ($gibbonRollGroupID == $rowSelect["gibbonRollGroupID"]) {
print "<option selected value='" . $rowSelect["gibbonRollGroupID"] . "'>" . htmlPrep($rowSelect["name"]) . "</option>";
} else {
print "<option value='" . $rowSelect["gibbonRollGroupID"] . "'>" . htmlPrep($rowSelect["name"]) . "</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td colspan=2 class="right">
<input type="hidden" name="q" value="/modules/<?php
print $_SESSION[$guid]["module"];
?>
/report_classEnrolment_byRollGroup.php">
<input type="submit" value="<?php
print _("Submit");
$(function() {
$( "#lastEpisode" ).datepicker();
});
</script>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Last Episode Treatment');
?>
</b><br/>
</td>
<td class="right">
<input name="lastEpisodeTreatment" id="lastEpisodeTreatment" maxlength=255 value="<?php
print htmlPrep($row["lastEpisodeTreatment"]);
?>
" type="text" style="width: 300px">
</td>
</tr>
<tr>
<td>
<b><?php
print _('Comment');
?>
</b><br/>
</td>
<td class="right">
<textarea name="comment" id="comment" rows=8 style="width: 300px"><?php
print $row["comment"];
?>
</i></span>
</td>
<td class="right">
<?php
try {
$dataSelect = array("gibbonPersonID" => $row["gibbonPersonIDPayment"]);
$sqlSelect = "SELECT * FROM gibbonPerson JOIN gibbonStaff ON (gibbonPerson.gibbonPersonID=gibbonStaff.gibbonPersonID) WHERE gibbonPerson.gibbonPersonID=:gibbonPersonID ORDER BY surname, preferredName";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
if ($resultSelect->rowCount() == 1) {
$rowSelect = $resultSelect->fetch();
?>
<input readonly name="payee" id="payee" maxlength=10 value="<?php
print formatName(htmlPrep($rowSelect["title"]), $rowSelect["preferredName"], htmlPrep($rowSelect["surname"]), "Staff", true, true);
?>
" type="text" style="width: 300px">
<?php
}
?>
</td>
</tr>
<tr id="paymentMethodRow">
<td>
<b><?php
print _('Payment Method');
?>
</b><br/>
</td>
<span style="font-size: 90%"><i></i></span>
</td>
<td class="right">
<select name="gibbonSchoolYearID" id="gibbonSchoolYearID" style="width: 302px">
<?php
print "<option value='Please select...'>" . _('Please select...') . "</option>";
try {
$data = array();
$sql = "SELECT * FROM gibbonSchoolYear ORDER BY sequenceNumber";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
while ($row = $result->fetch()) {
print "<option value='" . $row["gibbonSchoolYearID"] . "'>" . htmlPrep($row["name"]) . "</option>";
}
?>
</select>
<script type="text/javascript">
var gibbonSchoolYearID=new LiveValidation('gibbonSchoolYearID');
gibbonSchoolYearID.add(Validate.Exclusion, { within: ['Please select...'], failureMessage: "<?php
print _('Select something!');
?>
"});
</script>
</td>
</tr>
<tr>
<td>
<?php
print "<option value='Please select...'>" . _('Please select...') . "</option>";
try {
if ($dateType != "Date") {
$dataSelect = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonPersonID" => $gibbonPersonID, "gibbonActivityID" => $gibbonActivityID);
$sqlSelect = "SELECT DISTINCT gibbonActivity.* FROM gibbonActivity JOIN gibbonStudentEnrolment ON (gibbonActivity.gibbonYearGroupIDList LIKE concat( '%', gibbonStudentEnrolment.gibbonYearGroupID, '%' )) WHERE gibbonActivity.gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonPersonID=:gibbonPersonID AND NOT gibbonActivityID=:gibbonActivityID AND NOT gibbonSchoolYearTermIDList='' AND active='Y' {$and} ORDER BY name";
} else {
$dataSelect = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonPersonID" => $gibbonPersonID, "gibbonActivityID" => $gibbonActivityID, "listingStart" => $today, "listingEnd" => $today);
$sqlSelect = "SELECT DISTINCT gibbonActivity.* FROM gibbonActivity JOIN gibbonStudentEnrolment ON (gibbonActivity.gibbonYearGroupIDList LIKE concat( '%', gibbonStudentEnrolment.gibbonYearGroupID, '%' )) WHERE gibbonActivity.gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonPersonID=:gibbonPersonID AND NOT gibbonActivityID=:gibbonActivityID AND listingStart<=:listingStart AND listingEnd>=:listingEnd AND active='Y' {$and} ORDER BY name";
}
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
print "<option value='" . $rowSelect["gibbonActivityID"] . "'>" . htmlPrep($rowSelect["name"]) . "</option>";
}
?>
</select>
<script type="text/javascript">
var gibbonActivityIDBackup=new LiveValidation('gibbonActivityIDBackup');
gibbonActivityIDBackup.add(Validate.Exclusion, { within: ['Please select...'], failureMessage: "<?php
print _('Select something!');
?>
"});
</script>
</td>
</tr>
<?php
}
} else {
?>
<optgroup label='--<?php
print _('All Classes');
?>
--'>
<?php
try {
$dataSelect = array("gibbonSchoolYearID" => $gibbonSchoolYearID);
$sqlSelect = "SELECT gibbonCourseClassID, gibbonCourse.name, gibbonCourse.nameShort AS course, gibbonCourseClass.nameShort AS class FROM gibbonCourse JOIN gibbonCourseClass ON (gibbonCourse.gibbonCourseID=gibbonCourseClass.gibbonCourseID) WHERE gibbonSchoolYearID=:gibbonSchoolYearID ORDER BY course, class";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
print "<option value='" . $rowSelect["gibbonCourseClassID"] . "'>" . htmlPrep($rowSelect["course"]) . "." . htmlPrep($rowSelect["class"]) . " - " . $rowSelect["name"] . "</option>";
}
?>
</optgroup>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td>
<b><?php
print _('Role');
?>
*</b><br/>
<select name="languageHomeSecondary" id="languageHomeSecondary" style="width: 302px">
<?php
print "<option value=''></option>";
try {
$dataSelect = array();
$sqlSelect = "SELECT name FROM gibbonLanguage ORDER BY name";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
$selected = "";
if ($row["languageHomeSecondary"] == $rowSelect["name"]) {
$selected = "selected";
}
print "<option {$selected} value='" . $rowSelect["name"] . "'>" . htmlPrep(_($rowSelect["name"])) . "</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>
<span style="font-size: 90%"><i>* <?php
print _("denotes a required field");
?>
</i></span>
</td>
<td class="right">
<?php
<td class="right">
<select name="gibbonScaleID" id="gibbonScaleID" style="width: 302px">
<?php
try {
$dataSelect = array();
$sqlSelect = "SELECT * FROM gibbonScale WHERE (active='Y') ORDER BY name";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
print "<option value='Please select...'>" . _('Please select...') . "</option>";
while ($rowSelect = $resultSelect->fetch()) {
if ($row["gibbonScaleID"] == $rowSelect["gibbonScaleID"]) {
print "<option selected value='" . $rowSelect["gibbonScaleID"] . "'>" . htmlPrep(_($rowSelect["name"])) . "</option>";
} else {
print "<option value='" . $rowSelect["gibbonScaleID"] . "'>" . htmlPrep(_($rowSelect["name"])) . "</option>";
}
}
?>
</select>
<script type="text/javascript">
var gibbonScaleID=new LiveValidation('gibbonScaleID');
gibbonScaleID.add(Validate.Exclusion, { within: ['Please select...'], failureMessage: "<?php
print _('Select something!');
?>
"});
</script>
</td>
</tr>
<tr>
<span style="font-size: 90%"><i><?php
if ($row["description"] != "") {
print _($row["description"]);
}
?>
</i></span>
</td>
<td class="right">
<input type='text' name="<?php
print $row["name"];
?>
" id="<?php
print $row["name"];
?>
"style="width: 300px" value='<?php
print htmlPrep($row["value"]);
?>
'>
<script type="text/javascript">
var <?php
print $row["name"];
?>
=new LiveValidation('<?php
print $row["name"];
?>
');
<?php
print $row["name"];
?>
.add( Validate.Format, { pattern: /(http|https):\/\/(\w+:{0,1}\w*@)?(\S+)(:[0-9]+)?(\/|\/([\w#!:.?+=&%@!\-\/]))?/, failureMessage: "Must start with http:// or https://" } );
</script>
}
}
foreach ($removers as $remove) {
if ($remove != "") {
$vacancies = str_replace($remove . ", ", "", $vacancies);
}
}
//Explode vacancies into array and sort, get ready to output
$vacancies = explode(",", substr($vacancies, 0, -2));
natcasesort($vacancies);
$vacanciesOutput = "";
foreach ($vacancies as $vacancy) {
$vacanciesOutput .= $vacancy . ", ";
}
$vacanciesOutput = substr($vacanciesOutput, 0, -2);
$day = $day . "<div title='" . htmlPrep($vacanciesOutput) . "' style='color: black; font-weight: normal; line-height: 0.9'>";
if (strlen($vacanciesOutput) <= 50) {
$day .= $vacanciesOutput;
} else {
$day .= substr($vacanciesOutput, 0, 50) . "...";
}
$day = $day . "</div>";
}
$day = $day . "</div>";
$zCount++;
}
}
}
$day = $day . "</td>";
}
} else {
if ($rowLog["reason"] == "Family") {
print "selected ";
}
print "value='Family'>" . _('Family') . "</option>";
print "<option ";
if ($rowLog["reason"] == "Medical") {
print "selected ";
}
print "value='Medical'>" . _('Medical') . "</option>";
print "<option ";
if ($rowLog["reason"] == "Other") {
print "selected ";
}
print "value='Other'>" . _('Other') . "</option>";
print "</select>";
print "<input type='text' maxlength=255 name='{$count}-comment' id='{$count}-comment' style='float: none; width:126px; margin-bottom: 3px' value='" . htmlPrep($rowLog["comment"]) . "'>";
if ($rowLog["type"] == "Present" or $rowLog["type"] == "Present - Late") {
$countPresent++;
}
print "<table cellspacing='0' style='width:134px; margin: 0 auto 3px auto; height: 35px' >";
print "<tr>";
for ($i = 4; $i >= 0; $i--) {
$link = "";
if ($i > $last5SchoolDaysCount - 1) {
$extraStyle = "color: #555; background-color: #eee;";
print "<td style='" . $extraStyle . "height: 25px; width: 20%'>";
print "<i>" . _('NA') . "</i>";
print "</td>";
} else {
try {
$dataLast5SchoolDays = array("gibbonPersonID" => $rowRollGroup["gibbonPersonID"], "date" => date("Y-m-d", dateConvertToTimestamp($last5SchoolDays[$i])) . "%");
<td class="right">
<select style="width: 302px" name="gibbonPersonID" id="gibbonPersonID">
<?php
print "<option value='Please select...'>" . _('Please select...') . "</option>";
try {
$dataSelect = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$sqlSelect = "SELECT * FROM gibbonPerson JOIN gibbonStudentEnrolment ON (gibbonPerson.gibbonPersonID=gibbonStudentEnrolment.gibbonPersonID) JOIN gibbonRollGroup ON (gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID) WHERE gibbonRollGroup.gibbonSchoolYearID=:gibbonSchoolYearID AND status='Full' ORDER BY surname, preferredName";
$resultSelect = $connection2->prepare($sqlSelect);
$resultSelect->execute($dataSelect);
} catch (PDOException $e) {
}
while ($rowSelect = $resultSelect->fetch()) {
if ($gibbonPersonID == $rowSelect["gibbonPersonID"]) {
print "<option selected value='" . $rowSelect["gibbonPersonID"] . "'>" . formatName("", htmlPrep($rowSelect["preferredName"]), htmlPrep($rowSelect["surname"]), "Student", true) . " (" . htmlPrep($rowSelect["nameShort"]) . ")</option>";
} else {
print "<option value='" . $rowSelect["gibbonPersonID"] . "'>" . formatName("", htmlPrep($rowSelect["preferredName"]), htmlPrep($rowSelect["surname"]), "Student", true) . " (" . htmlPrep($rowSelect["nameShort"]) . ")</option>";
}
}
?>
</select>
<script type="text/javascript">
var gibbonPersonID=new LiveValidation('gibbonPersonID');
gibbonPersonID.add(Validate.Exclusion, { within: ['Please select...'], failureMessage: "<?php
print _('Select something!');
?>
"});
</script>
</td>
</tr>
<tr>
}
print "</span>";
print "</td>";
print "<td>";
if ($row["type"] == "teacherRecorded") {
print "Teacher Recorded";
} else {
print "Student Recorded";
}
print "<br/>";
print "<span style='font-size: 85%; font-style: italic'>";
if ($row["homeworkDetails"] != "") {
if (strlen(strip_tags($row["homeworkDetails"])) < 21) {
print strip_tags($row["homeworkDetails"]);
} else {
print "<span {$style} title='" . htmlPrep(strip_tags($row["homeworkDetails"])) . "'>" . substr(strip_tags($row["homeworkDetails"]), 0, 20) . "...</span>";
}
}
print "</span>";
print "</td>";
print "<td>";
print dateConvertBack($guid, substr($row["homeworkDueDateTime"], 0, 10));
print "</td>";
print "<td>";
if ($row["homeworkSubmission"] == "Y") {
print "<b>" . $row["homeworkSubmissionRequired"] . "<br/></b>";
if ($row["role"] == "Student") {
try {
$dataVersion = array("gibbonPlannerEntryID" => $row["gibbonPlannerEntryID"], "gibbonPersonID" => $gibbonPersonID);
$sqlVersion = "SELECT * FROM gibbonPlannerEntryHomework WHERE gibbonPlannerEntryID=:gibbonPlannerEntryID AND gibbonPersonID=:gibbonPersonID ORDER BY count DESC";
$resultVersion = $connection2->prepare($sqlVersion);
