} else {
$siblingSchoolJoiningDate2 = dateConvert($guid, $siblingSchoolJoiningDate2);
}
$siblingName3 = $_POST["siblingName3"];
$siblingDOB3 = $_POST["siblingDOB3"];
if ($siblingDOB3 == "") {
$siblingDOB3 = NULL;
} else {
$siblingDOB3 = dateConvert($guid, $siblingDOB3);
}
$siblingSchool3 = $_POST["siblingSchool3"];
$siblingSchoolJoiningDate3 = $_POST["siblingSchoolJoiningDate3"];
if ($siblingSchoolJoiningDate3 == "") {
$siblingSchoolJoiningDate3 = NULL;
} else {
$siblingSchoolJoiningDate3 = dateConvert($guid, $siblingSchoolJoiningDate3);
}
//GET PAYMENT FIELDS
$payment = $_POST["payment"];
$companyName = NULL;
if (isset($_POST["companyName"])) {
$companyName = $_POST["companyName"];
}
$companyContact = NULL;
if (isset($_POST["companyContact"])) {
$companyContact = $_POST["companyContact"];
}
$companyAddress = NULL;
if (isset($_POST["companyAddress"])) {
$companyAddress = $_POST["companyAddress"];
}
if ($AI != "") {
$gibbonPersonMedicalUpdateID = $AI;
} else {
$gibbonPersonMedicalUpdateID = NULL;
}
$name = $_POST["name"];
$gibbonAlertLevelID = NULL;
if ($_POST["gibbonAlertLevelID"] != "Please select...") {
$gibbonAlertLevelID = $_POST["gibbonAlertLevelID"];
}
$triggers = $_POST["triggers"];
$reaction = $_POST["reaction"];
$response = $_POST["response"];
$medication = $_POST["medication"];
if ($_POST["lastEpisode"] != "") {
$lastEpisode = dateConvert($guid, $_POST["lastEpisode"]);
} else {
$lastEpisode = NULL;
}
$lastEpisodeTreatment = $_POST["lastEpisodeTreatment"];
$comment = $_POST["comment"];
try {
$data = array("gibbonPersonMedicalUpdateID" => $gibbonPersonMedicalUpdateID, "gibbonPersonMedicalID" => $gibbonPersonMedicalID, "name" => $name, "gibbonAlertLevelID" => $gibbonAlertLevelID, "triggers" => $triggers, "reaction" => $reaction, "response" => $response, "medication" => $medication, "lastEpisode" => $lastEpisode, "lastEpisodeTreatment" => $lastEpisodeTreatment, "comment" => $comment, "gibbonPersonIDUpdater" => $_SESSION[$guid]["gibbonPersonID"]);
$sql = "INSERT INTO gibbonPersonMedicalConditionUpdate SET gibbonPersonMedicalUpdateID=:gibbonPersonMedicalUpdateID, gibbonPersonMedicalID=:gibbonPersonMedicalID, name=:name, gibbonAlertLevelID=:gibbonAlertLevelID, triggers=:triggers, reaction=:reaction, response=:response, medication=:medication, lastEpisode=:lastEpisode, lastEpisodeTreatment=:lastEpisodeTreatment, comment=:comment, gibbonPersonIDUpdater=:gibbonPersonIDUpdater";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$partialFail = TRUE;
}
}
}
if ($type == "Positive") {
$likeComment = "";
if ($descriptor != NULL) {
$likeComment .= $descriptor;
}
if ($descriptor != NULL and $comment != "") {
$likeComment .= ": ";
}
if ($comment != "") {
$likeComment .= $comment;
}
}
foreach ($gibbonPersonIDMulti as $gibbonPersonID) {
//Write to database
try {
$data = array("gibbonPersonID" => $gibbonPersonID, "date" => dateConvert($guid, $date), "type" => $type, "descriptor" => $descriptor, "level" => $level, "comment" => $comment, "followup" => $followup, "gibbonPersonIDCreator" => $_SESSION[$guid]["gibbonPersonID"], "gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"]);
$sql = "INSERT INTO gibbonBehaviour SET gibbonPersonID=:gibbonPersonID, date=:date, type=:type, descriptor=:descriptor, level=:level, comment=:comment, followup=:followup, gibbonPersonIDCreator=:gibbonPersonIDCreator, gibbonSchoolYearID=:gibbonSchoolYearID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$partialFail = TRUE;
}
$gibbonBehaviourID = $connection2->lastInsertID();
//Attempt to add like on positive behaviour
if ($type == "Positive") {
$return = setLike($connection2, "Behaviour", $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonBehaviourID", $gibbonBehaviourID, $_SESSION[$guid]["gibbonPersonID"], $gibbonPersonID, "Positive Behaviour", $likeComment);
}
if ($type == "Negative") {
try {
$dataDetail = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonPersonID" => $gibbonPersonID);
$sqlDetail = "SELECT gibbonPersonIDTutor, gibbonPersonIDTutor2, gibbonPersonIDTutor3, surname, preferredName FROM gibbonRollGroup JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID) JOIN gibbonPerson ON (gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID) WHERE gibbonStudentEnrolment.gibbonSchoolYearID=:gibbonSchoolYearID AND gibbonStudentEnrolment.gibbonPersonID=:gibbonPersonID";
//Get action with highest precendence
$highestAction = getHighestGroupedAction($guid, $_GET["q"], $connection2);
if ($highestAction == FALSE) {
print "<div class='error'>";
print _("The highest grouped action cannot be determined.");
print "</div>";
} else {
$viewBy = $_GET["viewBy"];
$subView = $_GET["subView"];
if ($viewBy != "date" and $viewBy != "class") {
$viewBy = "date";
}
if ($viewBy == "date") {
$date = $_GET["date"];
if ($_GET["dateHuman"] != "") {
$date = dateConvert($guid, $_GET["dateHuman"]);
}
if ($date == "") {
$date = date("Y-m-d");
}
list($dateYear, $dateMonth, $dateDay) = explode('-', $date);
$dateStamp = mktime(0, 0, 0, $dateMonth, $dateDay, $dateYear);
} else {
if ($viewBy == "class") {
$class = NULL;
if (isset($_GET["class"])) {
$class = $_GET["class"];
}
$gibbonCourseClassID = $_GET["gibbonCourseClassID"];
}
}
exit;
}
// busca os dados do usuário a ser editado
$PDO = db_connect();
$sql = "SELECT nomeCliente, dataCadastro, email FROM clientes WHERE idCliente = :id";
$stmt = $PDO->prepare($sql);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
$stmt->execute();
$cliente = $stmt->fetch(PDO::FETCH_ASSOC);
/* se o método fetch () não retornar um array
significa que o ID não corresponde a um usuário válido */
if (!is_array($cliente)) {
echo "Nenhum cliente encontrado";
exit;
}
$dataOK = dateConvert($cliente['dataCadastro']);
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<title>Edição de dados</title>
<meta charset="utf-8">
<link type="text/css" href="js/jquery-ui.css" rel="stylesheet"/>
<link type="text/css" href="style.css" rel="stylesheet"/>
<script type="text/javascript" src="js/jquery-2.1.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui.js"></script>
<script type="text/javascript" src="js/script.js"></script>
<script type ="text/javascript" src="js/datepicker-pt-BR.js"></script>
<script>
<tbody>
<?php
foreach ($Portfolio as $k => $v) {
echo $v->logical_delete == 1 ? '<tr class="danger">' : '<tr>';
echo '<td>';
if (!empty($v->image_path)) {
echo '<div class="btn-group">';
echo '<button class="btn dropdown-toggle btn-primary btn-xs" data-toggle="dropdown"><span class="glyphicon glyphicon-camera"></span></button>';
echo '<div class="dropdown-menu" style="margin:0;padding:0;border:0;">';
echo '<img src="' . Router::webroot($v->image_path) . '" class="img-thumbnail" style="width:200px;"/>';
echo '</div></div> | ';
}
echo truncateStringWords($v->name, 40);
echo '</td>';
echo '<td>' . $v->category . '</td>';
echo '<td>' . dateConvert($v->creation) . '</td>';
echo '<td class="text-right">';
echo $this->FormLink->visible('cockpit/portfolio/online/id:' . $v->id, $v->online);
echo $this->FormLink->consult('cockpit/portfolio/consult/id:' . $v->id) . ' ';
echo $this->FormLink->update('cockpit/portfolio/edit/id:' . $v->id) . ' ';
echo $this->FormLink->delete('cockpit/portfolio/delete/id:' . $v->id) . ' ';
echo '</td></tr>';
}
?>
</tbody>
</table>
</div>
<div class="panel-footer text-right">
<?php
echo $this->FormLink->back(COCKPIT);
?>
//Fail 2
$URL .= "&addReturn=fail2";
header("Location: {$URL}");
break;
}
//Proceed!
$surname = $_POST["surname"];
$firstName = $_POST["firstName"];
$preferredName = $firstName;
$officialName = $firstName . " " . $surname;
$gender = $_POST["gender"];
$dob = $_POST["dob"];
if ($dob == "") {
$dob = NULL;
} else {
$dob = dateConvert($guid, $dob);
}
$email = $_POST["email"];
$username = $_POST["username"];
$password = $_POST["password"];
$salt = getSalt();
$passwordStrong = hash("sha256", $salt . $password);
$status = getSettingByScope($connection2, 'User Admin', 'publicRegistrationDefaultStatus');
$gibbonRoleIDPrimary = getSettingByScope($connection2, 'User Admin', 'publicRegistrationDefaultRole');
$gibbonRoleIDAll = $gibbonRoleIDPrimary;
if ($surname == "" or $firstName == "" or $preferredName == "" or $officialName == "" or $gender == "" or $dob == "" or $email == "" or $username == "" or $password == "" or $gibbonRoleIDPrimary == "" or $gibbonRoleIDPrimary == "" or $status != "Pending Approval" and $status != "Full") {
//Fail 3
$URL .= "&addReturn=fail3";
header("Location: {$URL}");
} else {
//Check strength of password
$URL .= "&updateReturn=fail2";
header("Location: {$URL}");
} else {
$name = $_POST["name"];
$active = $_POST["active"];
$description = $_POST["description"];
$invoiceIssueDate = $_POST["invoiceIssueDate"];
$invoiceDueDate = $_POST["invoiceDueDate"];
if ($name == "" or $active == "" or $invoiceIssueDate == "" or $invoiceDueDate == "") {
//Fail 3
$URL .= "&addReturn=fail3";
header("Location: {$URL}");
} else {
//Write to database
try {
$data = array("gibbonSchoolYearID" => $gibbonSchoolYearID, "name" => $name, "active" => $active, "description" => $description, "invoiceIssueDate" => dateConvert($guid, $invoiceIssueDate), "invoiceDueDate" => dateConvert($guid, $invoiceDueDate), "gibbonPersonIDUpdate" => $_SESSION[$guid]["gibbonPersonID"], "gibbonFinanceBillingScheduleID" => $gibbonFinanceBillingScheduleID);
$sql = "UPDATE gibbonFinanceBillingSchedule SET gibbonSchoolYearID=:gibbonSchoolYearID, name=:name, active=:active, description=:description, invoiceIssueDate=:invoiceIssueDate, invoiceDueDate=:invoiceDueDate, gibbonPersonIDUpdate=:gibbonPersonIDUpdate, timestampUpdate='" . date("Y-m-d H:i:s") . "' WHERE gibbonFinanceBillingScheduleID=:gibbonFinanceBillingScheduleID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
//Fail 2
$URL .= "&updateReturn=fail2";
header("Location: {$URL}");
break;
}
//Success 0
$URL .= "&updateReturn=success0";
header("Location: {$URL}");
}
}
}
<tr>
<?php
echo '<th>' . BackendTranslate::getLabel('login') . '</th>';
echo '<th style="width:10%;">' . BackendTranslate::getLabel('categories') . '</th>';
echo '<th style="width:10%;">' . BackendTranslate::getLabel('login_last') . '</a></th>';
echo '<th style="width:30%;" class="text-right">' . BackendTranslate::getLabel('action') . '</th>';
?>
</tr>
</thead>
<tbody>
<?php
foreach ($User as $k => $v) {
echo $v->logical_delete == 1 ? '<tr class="danger">' : '<tr>';
echo '<td>' . $v->login . '</td>';
echo '<td>' . $v->category . '</td>';
echo '<td>' . dateConvert($v->login_last) . '</td>';
echo '<td class="text-right">';
echo $this->FormLink->consult('cockpit/user/consult/id:' . $v->id . '/name:' . $v->login) . ' ';
echo $this->FormLink->delete('cockpit/user/delete/id:' . $v->id . '/name:' . $v->login);
echo '</td></tr>';
}
?>
</tbody>
</table>
</div>
<div class="panel-footer text-right">
<?php
echo $this->FormLink->back(COCKPIT);
?>
</div>
</div>
@session_start();
//Set timezone from session variable
date_default_timezone_set($_SESSION[$guid]["timezone"]);
$URL = $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_POST["address"]) . "/schoolYear_manage_add.php";
if (isActionAccessible($guid, $connection2, "/modules/School Admin/schoolYear_manage_add.php") == FALSE) {
//Fail 0
$URL .= "&addReturn=fail0";
header("Location: {$URL}");
} else {
//Proceed!
//Validate Inputs
$name = $_POST["name"];
$status = $_POST["status"];
$sequenceNumber = $_POST["sequenceNumber"];
$firstDay = dateConvert($guid, $_POST["firstDay"]);
$lastDay = dateConvert($guid, $_POST["lastDay"]);
if ($name == "" or $status == "" or $sequenceNumber == "" or is_numeric($sequenceNumber) == FALSE or $firstDay == "" or $lastDay == "") {
//Fail 3
$URL .= "&addReturn=fail3";
header("Location: {$URL}");
} else {
//Check unique inputs for uniquness
try {
$data = array("name" => $name, "sequenceNumber" => $sequenceNumber);
$sql = "SELECT * FROM gibbonSchoolYear WHERE name=:name OR sequenceNumber=:sequenceNumber";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
//Fail 2
$URL .= "&addReturn=fail2";
header("Location: {$URL}");
if ($dateType == "Term") {
$gibbonSchoolYearTermIDList = "";
if (isset($_POST["gibbonSchoolYearTermID"])) {
$terms = $_POST["gibbonSchoolYearTermID"];
$gibbonSchoolYearTermIDList = "";
for ($i = 0; $i < count($terms); $i++) {
$gibbonSchoolYearTermIDList = $gibbonSchoolYearTermIDList . $terms[$i] . ",";
}
$gibbonSchoolYearTermIDList = substr($gibbonSchoolYearTermIDList, 0, -1);
}
} else {
if ($dateType == "Date") {
$listingStart = dateConvert($guid, $_POST["listingStart"]);
$listingEnd = dateConvert($guid, $_POST["listingEnd"]);
$programStart = dateConvert($guid, $_POST["programStart"]);
$programEnd = dateConvert($guid, $_POST["programEnd"]);
}
}
$gibbonYearGroupIDList = "";
for ($i = 0; $i < $_POST["count"]; $i++) {
if (isset($_POST["gibbonYearGroupIDCheck{$i}"])) {
if ($_POST["gibbonYearGroupIDCheck{$i}"] == "on") {
$gibbonYearGroupIDList = $gibbonYearGroupIDList . $_POST["gibbonYearGroupID{$i}"] . ",";
}
}
}
$gibbonYearGroupIDList = substr($gibbonYearGroupIDList, 0, strlen($gibbonYearGroupIDList) - 1);
$maxParticipants = $_POST["maxParticipants"];
$payment = $_POST["payment"];
$description = $_POST["description"];
if ($dateType == "" or $name == "" or $provider == "" or $active == "" or $registration == "" or $maxParticipants == "" or $payment == "" or $dateType == "Date" and ($listingStart == "" or $listingEnd == "" or $programStart == "" or $programEnd == "")) {
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
//Fail2
$URL .= "&editReturn=fail2";
header("Location: {$URL}");
break;
}
if ($result->rowCount() != 1) {
//Fail 0
$URL .= "&editReturn=fail0";
header("Location: {$URL}");
} else {
$row = $result->fetch();
//Get relevant
$paymentDate = dateConvert($guid, $_POST["paymentDate"]);
$paymentAmount = $_POST["paymentAmount"];
$gibbonPersonIDPayment = $_POST["gibbonPersonIDPayment"];
$paymentMethod = $_POST["paymentMethod"];
//Move attached file
$time = time();
$attachment = "";
//Check for folder in uploads based on today's date
$path = $_SESSION[$guid]["absolutePath"];
if (is_dir($path . "/uploads/" . date("Y", $time) . "/" . date("m", $time)) == FALSE) {
mkdir($path . "/uploads/" . date("Y", $time) . "/" . date("m", $time), 0777, TRUE);
}
$unique = FALSE;
$count = 0;
while ($unique == FALSE and $count < 100) {
$suffix = randomPassword(16);
if ($status == "On Loan") {
$type = "Loan";
} else {
if ($status == "Repair") {
$type = "Repair";
} else {
if ($status == "Reserved") {
$type = "Reserve";
}
}
}
}
}
$returnExpected = NULL;
if ($_POST["returnExpected"] != "") {
$returnExpected = dateConvert($guid, $_POST["returnExpected"]);
}
$returnAction = $_POST["returnAction"];
$gibbonPersonIDReturnAction = NULL;
if ($_POST["gibbonPersonIDReturnAction"] != "") {
$gibbonPersonIDReturnAction = $_POST["gibbonPersonIDReturnAction"];
}
//Write to database
try {
$data = array("gibbonLibraryItemEventID" => $gibbonLibraryItemEventID, "type" => $type, "status" => $status, "gibbonPersonIDOut" => $_SESSION[$guid]["gibbonPersonID"], "timestampOut" => date('Y-m-d H:i:s', time()), "returnExpected" => $returnExpected, "returnAction" => $returnAction, "gibbonPersonIDReturnAction" => $gibbonPersonIDReturnAction);
$sql = "UPDATE gibbonLibraryItemEvent SET type=:type, status=:status, gibbonPersonIDOut=:gibbonPersonIDOut, timestampOut=:timestampOut, returnExpected=:returnExpected, returnAction=:returnAction, gibbonPersonIDReturnAction=:gibbonPersonIDReturnAction WHERE gibbonLibraryItemEventID=:gibbonLibraryItemEventID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
//Fail 2
$URL .= "&addReturn=fail2" . $e->getMessage();
//Fail2
$URL .= "&deleteReturn=fail2";
header("Location: {$URL}");
break;
}
if ($result->rowCount() != 1) {
//Fail 2
$URL .= "&updateReturn=fail2";
header("Location: {$URL}");
} else {
//Validate Inputs
$name = $_POST["name"];
$status = $_POST["status"];
$sequenceNumber = $_POST["sequenceNumber"];
$dateStart = dateConvert($guid, $_POST["dateStart"]);
$dateEnd = dateConvert($guid, $_POST["dateEnd"]);
if ($name == "" or $status == "" or $sequenceNumber == "" or is_numeric($sequenceNumber) == FALSE or $dateStart == "" or $dateEnd == "") {
//Fail 3
$URL .= "&updateReturn=fail3";
header("Location: {$URL}");
} else {
//Check unique inputs for uniquness
try {
$data = array("name" => $name, "sequenceNumber" => $sequenceNumber, "gibbonFinanceBudgetCycleID" => $gibbonFinanceBudgetCycleID);
$sql = "SELECT * FROM gibbonFinanceBudgetCycle WHERE (name=:name OR sequenceNumber=:sequenceNumber) AND NOT gibbonFinanceBudgetCycleID=:gibbonFinanceBudgetCycleID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
//Fail 2
$URL .= "&updateReturn=fail2";
header("Location: {$URL}");
<br/>
<?php
$nextmatchP4 = $this->request(CALENDAR, 'getNextMatch', 2);
if (empty($nextmatchP4)) {
echo 'P4E Saison 2015-2016 terminée';
} else {
echo 'P4E <span>' . $nextmatchP4->game . ' le ' . dateConvert($nextmatchP4->dayofgame) . '</span>';
}
?>
<br/>
<?php
$nextmatchDame = $this->request(CALENDAR, 'getNextMatch', 8);
if (empty($nextmatchDame)) {
echo 'P2Dame Saison 2015-2016 terminée';
} else {
echo 'Dames <span>' . $nextmatchDame->game . ' le ' . dateConvert($nextmatchDame->dayofgame) . '</span>';
}
?>
</div>
</div>
<div class="panel panel-info">
<div class="panel-heading"><?php
echo FrontendTranslate::getLabel('last_result');
?>
</div>
<div class="panel-body">
<?php
$lastresultP3 = $this->request(CALENDAR, 'getLastResult', 1);
if (empty($lastresultP3)) {
echo 'Résultat P3B bientôt disponible';
} else {
$homework = $_POST["homework"];
if ($_POST["homework"] == "Yes") {
$homework = "Y";
$homeworkDetails = $_POST["homeworkDetails"];
if ($_POST["homeworkDueDateTime"] != "") {
$homeworkDueDateTime = $_POST["homeworkDueDateTime"] . ":59";
} else {
$homeworkDueDateTime = "21:00:00";
}
if ($_POST["homeworkDueDate"] != "") {
$homeworkDueDate = dateConvert($guid, $_POST["homeworkDueDate"]) . " " . $homeworkDueDateTime;
}
if ($_POST["homeworkSubmission"] == "Yes") {
$homeworkSubmission = "Y";
if ($_POST["homeworkSubmissionDateOpen"] != "") {
$homeworkSubmissionDateOpen = dateConvert($guid, $_POST["homeworkSubmissionDateOpen"]);
} else {
$homeworkSubmissionDateOpen = date("Y-m-d");
}
if (isset($_POST["homeworkSubmissionDrafts"])) {
$homeworkSubmissionDrafts = $_POST["homeworkSubmissionDrafts"];
}
$homeworkSubmissionType = $_POST["homeworkSubmissionType"];
$homeworkSubmissionRequired = $_POST["homeworkSubmissionRequired"];
if ($_POST["homeworkCrowdAssess"] == "Yes") {
$homeworkCrowdAssess = "Y";
if (isset($_POST["homeworkCrowdAssessOtherTeachersRead"])) {
$homeworkCrowdAssessOtherTeachersRead = "Y";
} else {
$homeworkCrowdAssessOtherTeachersRead = "N";
}
public function date($name)
{
$value = isset($this->controller->request->data->{$name}) ? stripslashes($this->controller->request->data->{$name}) : EMPTYSTRING;
$value = empty($value) ? dateConvert(dateInit()) : dateConvert($value);
$buffer = EMPTYSTRING;
$buffer .= $this->init($name);
$buffer .= '<div class="input-group date form_datetime col-md-5" id="input' . $name . 'picker" data-date="' . $value . '" data-date-format="dd/mm/yyyy hh:ii">';
$buffer .= '<input class="form-control" type="text" readonly value="' . $value . '" name="' . $name . '" required>';
$buffer .= '<span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>';
$buffer .= '</div>';
$buffer .= $this->end($name);
return $buffer;
}
require_once 'init.php';
// resgata os valores do formulário
$name = isset($_POST['name']) ? $_POST['name'] : null;
$email = isset($_POST['email']) ? $_POST['email'] : null;
$gender = isset($_POST['gender']) ? $_POST['gender'] : null;
$birthdate = isset($_POST['birthdate']) ? $_POST['birthdate'] : null;
$id = isset($_POST['id']) ? $_POST['id'] : null;
// validação (bem simples, mais uma vez)
if (empty($name) || empty($email) || empty($gender) || empty($birthdate)) {
echo "Volte e preencha todos os campos";
exit;
}
// a data vem no formato dd/mm/YYYY
// então precisamos converter para YYYY-mm-dd
$isoDate = dateConvert($birthdate);
// atualiza o banco
$PDO = db_connect();
$sql = "UPDATE users SET name = :name, email = :email, gender = :gender, birthdate = :birthdate WHERE id = :id";
$stmt = $PDO->prepare($sql);
$stmt->bindParam(':name', $name);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':gender', $gender);
$stmt->bindParam(':birthdate', $isoDate);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
if ($stmt->execute()) {
header('Location: index.php');
} else {
echo "Erro ao alterar";
print_r($stmt->errorInfo());
}
$sqlInvoiceFee = "INSERT INTO gibbonFinanceInvoiceFee SET gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID, feeType=:feeType, name=:name, description=:description, gibbonFinanceFeeCategoryID=:gibbonFinanceFeeCategoryID, fee=:fee, sequenceNumber={$count}";
}
$resultInvoiceFee = $connection2->prepare($sqlInvoiceFee);
$resultInvoiceFee->execute($dataInvoiceFee);
} catch (PDOException $e) {
$invoiceFeeFailCount++;
}
}
}
//Update invoice
try {
if ($scheduling == "Scheduled") {
$dataInvoiceAdd = array("gibbonPersonIDUpdate" => $_SESSION[$guid]["gibbonPersonID"], "notes" => $rowInvoice["notes"] . " " . $notes, "gibbonFinanceInvoiceID" => $rowInvoice["gibbonFinanceInvoiceID"]);
$sqlInvoiceAdd = "UPDATE gibbonFinanceInvoice SET gibbonPersonIDUpdate=:gibbonPersonIDUpdate, notes=:notes, timeStampUpdate='" . date("Y-m-d H:i:s") . "' WHERE gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID";
} else {
$dataInvoiceAdd = array("invoiceDueDate" => dateConvert($guid, $invoiceDueDate), "gibbonPersonIDUpdate" => $_SESSION[$guid]["gibbonPersonID"], "notes" => $rowInvoice["notes"] . " " . $notes, "gibbonFinanceInvoiceID" => $rowInvoice["gibbonFinanceInvoiceID"]);
$sqlInvoiceAdd = "UPDATE gibbonFinanceInvoice SET invoiceDueDate=:invoiceDueDate, gibbonPersonIDUpdate=:gibbonPersonIDUpdate, notes=:notes, timeStampUpdate='" . date("Y-m-d H:i:s") . "' WHERE gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID";
}
$resultInvoiceAdd = $connection2->prepare($sqlInvoiceAdd);
$resultInvoiceAdd->execute($dataInvoiceAdd);
} catch (PDOException $e) {
$invoiceFailCount++;
$thisInvoiceFailed = TRUE;
}
} else {
if ($thisInvoiceFailed == FALSE) {
$invoiceFailCount++;
$thisInvoiceFailed = TRUE;
}
}
}
public function dateText($name, $readonly, $required)
{
$value = isset($this->controller->request->data->{$name}) ? stripslashes($this->controller->request->data->{$name}) : EMPTYSTRING;
$value = empty($value) ? dateConvert(dateInit()) : dateConvert($value);
$buffer = EMPTYSTRING;
$buffer .= $this->init($name);
$buffer .= '<input type="text" id="input' . $name . '" name="' . $name . '" value="' . $value . '" class="form-control" ' . $this->readonly($readonly) . ' ' . $this->required($required) . '>';
$buffer .= $this->end();
return $buffer;
}
//Fail 0
$URL .= "&addReturn=fail0";
header("Location: {$URL}");
} else {
//Proceed!
$gibbonPersonID = $_POST["gibbonPersonID"];
$initials = $_POST["initials"];
if ($initials == "") {
$initials = NULL;
}
$type = $_POST["type"];
$jobTitle = $_POST["jobTitle"];
$firstAidQualified = $_POST["firstAidQualified"];
$firstAidExpiry = NULL;
if ($firstAidQualified == "Y" and $_POST["firstAidExpiry"] != "") {
$firstAidExpiry = dateConvert($guid, $_POST["firstAidExpiry"]);
}
$countryOfOrigin = $_POST["countryOfOrigin"];
$qualifications = $_POST["qualifications"];
$biographicalGrouping = $_POST["biographicalGrouping"];
$biographicalGroupingPriority = $_POST["biographicalGroupingPriority"];
$biography = $_POST["biography"];
//Validate Inputs
if ($gibbonPersonID == "" or $type == "") {
//Fail 3
$URL .= "&addReturn=fail3";
header("Location: {$URL}");
} else {
//Check unique inputs for uniquness
try {
if ($initials == "") {
//Check if we are OK to go
if ($type == "" or $locations[$result["location"]] == "" or $result["username"] != "" and $users[$result["username"]] == "" or $result["department"] != "" and $departments[$result["department"]] == "") {
//NOT OK!
print "<div class='error'>";
print sprintf(_('Record with ID %1$s had some information malformations.'), $data[2]);
print "</div>";
} else {
//OK!
//GET FIELDS READY
$name = $result["name"];
$id = $result["id"];
$producer = $result["producer"];
$vendor = $result["vendor"];
$purchaseDate = NULL;
if ($result["purchaseDate"] != "") {
$purchaseDate = dateConvert($guid, $result["purchaseDate"]);
}
$invoiceNumber = $result["invoiceNumber"];
$gibbonSpaceID = $locations[$result["location"]];
$locationDetail = $result["locationDetail"];
$ownershipType = $result["ownershipType"];
$gibbonPersonIDOwnership = NULL;
if ($result["username"] != "") {
$gibbonPersonIDOwnership = $users[$result["username"]];
}
$gibbonDepartmentID = NULL;
if ($result["department"] != "") {
$gibbonDepartmentID = $departments[$result["department"]];
}
$borrowable = $result["borrowable"];
$status = $result["status"];
print "<input name='address' value='" . $_GET["q"] . "' type='hidden'>";
print "</fieldset>";
print "</form>";
}
//SHOW CURRENT TIMETABLE IN EDIT VIEW
print "<a name='tt'></a>";
print "<h2>";
print "Current Timetable View";
print "</h2>";
$gibbonTTID = NULL;
if (isset($_GET["gibbonTTID"])) {
$gibbonTTID = $_GET["gibbonTTID"];
}
$ttDate = NULL;
if (isset($_POST["ttDate"])) {
$ttDate = dateConvertToTimestamp(dateConvert($guid, $_POST["ttDate"]));
}
$tt = renderTT($guid, $connection2, $gibbonPersonID, $gibbonTTID, FALSE, $ttDate, "/modules/Timetable Admin/courseEnrolment_manage_byPerson_edit.php", "&gibbonPersonID={$gibbonPersonID}&gibbonSchoolYearID={$gibbonSchoolYearID}&type={$type}#tt", FALSE, TRUE);
if ($tt != FALSE) {
print $tt;
} else {
print "<div class='error'>";
print _("There are no records to display.");
print "</div>";
}
//SHOW OLD ENROLMENT RECORDS
print "<h2>";
print "Old Enrolment";
print "</h2>";
try {
$data = array("gibbonSchoolYearID" => $gibbonSchoolYearID, "gibbonPersonID" => $gibbonPersonID);
?>
<?php
echo $v->logical_delete == 1 ? '<tr class="danger">' : '<tr>';
?>
<td style="text-align: center;"><a href="<?php
echo Router::generateURL('cockpit/slider/online/' . $v->id);
?>
" class="label label-<?php
echo $v->online == 1 ? SUCCESS : DANGER;
?>
"><?php
echo $v->online == 1 ? BackendTranslate::getLabel('yes') : BackendTranslate::getLabel('no');
?>
</a></td>
<td><?php
echo dateConvert($v->publication);
?>
</td>
<td><?php
echo truncateStringWords($v->name, 75);
?>
</td>
<td class="text-right">
<?php
echo $this->FormLink->consult('cockpit/slider/consult/' . $v->id);
?>
<?php
echo $this->FormLink->update('cockpit/slider/edit/' . $v->id);
?>
<?php
echo $this->FormLink->delete('cockpit/slider/delete/' . $v->id);
$emergency2Relationship = $_POST["emergency2Relationship"];
$profession = $_POST["profession"];
$employer = $_POST["employer"];
$jobTitle = $_POST["jobTitle"];
$gibbonHouseID = $_POST["gibbonHouseID"];
if ($gibbonHouseID == "") {
$gibbonHouseID = NULL;
} else {
$gibbonHouseID = $gibbonHouseID;
}
$studentID = $_POST["studentID"];
$dateStart = $_POST["dateStart"];
if ($dateStart == "") {
$dateStart = NULL;
} else {
$dateStart = dateConvert($guid, $dateStart);
}
$gibbonSchoolYearIDClassOf = $_POST["gibbonSchoolYearIDClassOf"];
if ($gibbonSchoolYearIDClassOf == "") {
$gibbonSchoolYearIDClassOf = NULL;
}
$lastSchool = $_POST["lastSchool"];
$transport = $_POST["transport"];
$transportNotes = $_POST["transportNotes"];
$lockerNumber = $_POST["lockerNumber"];
$vehicleRegistration = $_POST["vehicleRegistration"];
$privacyOptions = NULL;
if (isset($_POST["privacyOptions"])) {
$privacyOptions = $_POST["privacyOptions"];
}
$privacy = "";
">
</td>
</tr>
</table>
</form>
<?php
} else {
if ($step == 2) {
print "<h2>";
print _("Step 2 - Availability Check");
print "</h2>";
$gibbonSpaceID = NULL;
if (isset($_POST["gibbonSpaceID"])) {
$gibbonSpaceID = $_POST["gibbonSpaceID"];
}
$date = dateConvert($guid, $_POST["date"]);
$timeStart = $_POST["timeStart"];
$timeEnd = $_POST["timeEnd"];
$repeat = $_POST["repeat"];
$repeatDaily = NULL;
$repeatWeekly = NULL;
if ($repeat == "Daily") {
$repeatDaily = $_POST["repeatDaily"];
} else {
if ($repeat == "Weekly") {
$repeatWeekly = $_POST["repeatWeekly"];
}
}
try {
$dataSelect = array("gibbonSpace" => $gibbonSpaceID);
$sqlSelect = "SELECT * FROM gibbonSpace WHERE gibbonSpace.gibbonSpaceID=:gibbonSpace";
print "</p>";
try {
$data = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"], "gibbonTTID" => $gibbonTTID);
$sql = "SELECT * FROM gibbonTT WHERE gibbonTTID=:gibbonTTID AND gibbonSchoolYearID=:gibbonSchoolYearID";
$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 selected record does not exist, or you do not have access to it.");
print "</div>";
} else {
$row = $result->fetch();
$startDayStamp = strtotime(dateConvert($guid, $ttDate));
//Count back to first Monday before first day
while (date("D", $startDayStamp) != "Mon") {
$startDayStamp = $startDayStamp - 86400;
}
//Check which days are school days
$daysInWeek = 0;
$days = array();
$timeStart = "";
$timeEnd = "";
$days["Mon"] = "N";
$days["Tue"] = "N";
$days["Wed"] = "N";
$days["Thu"] = "N";
$days["Fri"] = "N";
$days["Sat"] = "N";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($result->rowCount() > 0) {
$row = $result->fetch();
$gibbonRollGroupID = $row["gibbonRollGroupID"];
}
} else {
$gibbonRollGroupID = $_GET["gibbonRollGroupID"];
}
if (isset($_GET["currentDate"]) == FALSE) {
$currentDate = date("Y-m-d");
} else {
$currentDate = dateConvert($guid, $_GET["currentDate"]);
}
$today = date("Y-m-d");
?>
<form method="get" action="<?php
print $_SESSION[$guid]["absoluteURL"];
?>
/index.php">
<table class='smallIntBorder' cellspacing='0' style="width: 100%">
<tr class='break'>
<td colspan=2>
<h3>
<?php
print _('Choose Roll Group');
?>
} else {
$gibbonPersonIDMulti = null;
}
$badgesBadgeID = $_POST['badgesBadgeID'];
$date = $_POST['date'];
$comment = $_POST['comment'];
if ($gibbonPersonIDMulti == null or $date == '' or $badgesBadgeID == '' or $gibbonSchoolYearID == '') {
//Fail 3
$URL .= '&return=error3';
header("Location: {$URL}");
} else {
$partialFail = false;
foreach ($gibbonPersonIDMulti as $gibbonPersonID) {
//Write to database
try {
$data = array('badgesBadgeID' => $badgesBadgeID, 'gibbonSchoolYearID' => $gibbonSchoolYearID, 'date' => dateConvert($guid, $date), 'gibbonPersonID' => $gibbonPersonID, 'comment' => $comment, 'gibbonPersonIDCreator' => $_SESSION[$guid]['gibbonPersonID']);
$sql = 'INSERT INTO badgesBadgeStudent SET badgesBadgeID=:badgesBadgeID, gibbonSchoolYearID=:gibbonSchoolYearID, date=:date, gibbonPersonID=:gibbonPersonID, comment=:comment, gibbonPersonIDCreator=:gibbonPersonIDCreator';
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$partialFail = true;
}
$badgesBadgeStudentID = $connection2->lastInsertID();
//Attempt to add like
$likeComment = '';
if ($comment != '') {
$likeComment .= $comment;
}
$return = setLike($connection2, 'Badges', $_SESSION[$guid]['gibbonSchoolYearID'], 'badgesBadgeStudentID', $badgesBadgeStudentID, $_SESSION[$guid]['gibbonPersonID'], $gibbonPersonID, 'Badges Granted', $likeComment);
//Notify User
$notificationText = __($guid, 'Someone has granted you a badge.');
/report_students_left.php">
<input type="submit" value="<?php
print _("Submit");
?>
">
</td>
</tr>
</table>
</form>
<?php
if ($endDateFrom != "" and $endDateTo != "") {
print "<h2>";
print _("Results");
print "</h2>";
try {
$data = array("endDateFrom" => dateConvert($guid, $endDateFrom), "endDateTo" => dateConvert($guid, $endDateTo));
if ($ignoreStatus == "on") {
$sql = "SELECT DISTINCT gibbonPerson.gibbonPersonID, surname, preferredName, username, dateEnd, nextSchool, departureReason FROM gibbonPerson JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID) WHERE dateEnd>=:endDateFrom AND dateEnd<=:endDateTo ORDER BY surname, preferredName";
} else {
$sql = "SELECT DISTINCT gibbonPerson.gibbonPersonID, surname, preferredName, username, dateEnd, nextSchool, departureReason FROM gibbonPerson JOIN gibbonStudentEnrolment ON (gibbonStudentEnrolment.gibbonPersonID=gibbonPerson.gibbonPersonID) WHERE dateEnd>=:endDateFrom AND dateEnd<=:endDateTo AND status='Left' ORDER BY surname, preferredName";
}
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
print "<div class='error'>" . $e->getMessage() . "</div>";
}
if ($result->rowCount() > 0) {
print "<table cellspacing='0' style='width: 100%'>";
print "<tr class='head'>";
print "<th>";
print _("Count");
