public function changeStatusTo($newStatusId, $details = "", $sendMail = true, $includeDetailsInMail = false)
{
$database = database::instance();
//$clearStatusQueryString = $clearDetails ? demande::STATUS_DETAILS_DB_FIELD." = '".$newStatusId."', " : "";
$database->requete("UPDATE st_demande SET " . demande::STATUS_DETAILS_DB_FIELD . " = '" . mysql_real_escape_string($details) . "'," . demande::STATUS_DB_FIELD . " = '" . $newStatusId . "' \n WHERE " . demande::MATRICULE_DB_FIELD . " = '" . $this->matricule . "'");
$this->statusId = $newStatusId;
if (!$sendMail) {
return true;
}
if (!$includeDetailsInMail) {
$details = "";
}
$this->loadStatusData($this->matricule);
$user = new userData($this->matricule);
if ($user->getUserData($this->matricule)) {
$preg = array(array('key' => '/@@FIRSTNAME@@/', 'value' => $user->getFirstName()), array('key' => '/@@LASTNAME@@/', 'value' => $user->getLastName()), array('key' => '/@@STATUS@@/', 'value' => $this->getName()), array('key' => '/@@DETAILS@@/', 'value' => $details));
return util::sendEmail($user->getEmail(), 'email_status.txt', $preg, "Changement de status de votre demande");
}
}
require_once "header.php";
require_once "class.util.php";
require_once "class.userData.php";
require_once "class.validation.php";
require_once "class.database.php";
$message = "";
if (isset($_GET['sendmail']) && $_GET['sendmail'] == 1) {
$matricule = $_POST['matricule'];
if (isset($matricule) && validation::matricule($matricule)) {
$user = new userData($_POST['matricule']);
if ($user->getExist()) {
$password = util::generatePassword();
$pregArray = array(array('key' => "/@@FIRSTNAME@@/", 'value' => $user->getFirstName()), array('key' => "/@@LASTNAME@@/", 'value' => $user->getLastName()), array('key' => "/@@PASSWORD@@/", 'value' => $password));
$database = database::instance();
$database->requete("UPDATE st_authentication SET password='******' WHERE matricule='" . $matricule . "'");
util::sendEmail($user->getEmail(), 'accessrecovery.txt', $pregArray, "Stationnement AEP - Demande de nouveau mot de passe");
$message = util::UTF8toISO8859("Un courriel avec votre nouveau mot de passe vous a été envoyé");
} else {
$message = 'Utilisateur non existant';
}
} else {
$message = 'Matricule invalide';
}
}
?>
<div>
<?php
if ($message != "") {
echo $message . '</br></br>';
}
?>
require_once "class.userData.php";
$matricules = array();
if (isset($_POST['matricules'])) {
$list_raw = explode("\r\n", $_POST['matricules']);
$database = database::instance();
$result = $database->requete("SELECT matricule FROM st_authentication");
$matricules_db = array();
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
array_push($matricules_db, $row);
}
echo "<h4>Liste des matricules invalides</h4>";
echo "<ul>";
foreach ($matricules_db as $matricule) {
if (!in_array($matricule[0], $list_raw)) {
$user = new userData($matricule[0]);
echo '<li>' . $matricule[0] . ' | ' . util::UTF8toISO8859($user->getFirstName()) . ' ' . util::UTF8toISO8859($user->getLastName()) . ' | ' . $user->getEmail() . '</li>';
}
}
echo "</ul>";
}
?>
<div>
<h4>Entrez les matricules a verifier dans le champ suivant</h4>
<span>note: 1 matricule par ligne</span>
<form id ="form-list" name="form1" method="post" action="?list=1">
<textarea name="matricules" form="form-list" id="textarea-list" rows="20" cols="30"></textarea>
<input type="submit" name="button" id="button-list" value="send"/>
</form>
</div>
<?php
updateTripInfo($address, $city, $postalCode, $matricule);
$database->commitTransaction();
}
} catch (Exception $e) {
$database->abortTransaction();
}
}
}
require_once 'header.php';
require_once 'class.authentification.php';
require_once 'class.userData.php';
$objAuth = authentification::instance();
$user = new userData($objAuth->getUsager());
if ($user->getCurrentUserData()) {
$matricule = $user->getMatricule();
$email = $user->getEmail();
$firstName = $user->getFirstName();
$lastName = $user->getLastName();
$phone = $user->getPhone();
$address = $user->getAddress();
$city = $user->getCity();
$postalCode = $user->getZipCode();
$submissionValue = 'update';
$readonly = 'readonly';
}
print '<fieldset >
<legend> <h3>Informations</h3> </legend>
<div style="float:left" >
<form method="post" name="register">
<input type="hidden" name="submissionType" value="' . $submissionValue . '"/>';
print createRegisterTextField('Matricule', 'user', 7, 'user', $matricule, $errMessagesArray['matricule'], $readonly);
<img src="AEP.gif"/>
<h2>Demande de stationnement</h2>
<p>
<fieldset>
<legend><h3>Informations personnelles</h3></legend>
<div style="display:block;margin-top:10px">
<table>
<?php
printTableRow("Matricule", $user->getMatricule());
printTableRow("Nom", $user->getLastName());
printTableRow("Prenom", $user->getFirstName());
printTableRow("Adresse", $user->getAddress());
printTableRow("Ville", $user->getCity());
printTableRow("Code postal", $user->getZipCode());
printTableRow("Tel", $user->getPhone());
printTableRow("Courriel", $user->getEmail());
?>
</table>
</div>
</fieldset>
<fieldset>
<legend><h3>Informations sur la demande</h3></legend>
<div style="display:block;margin-top:10px">
<table>
<?php
printTableRow("Date de la demande", date("d/m/Y", strtotime($demande->getModificationDate())));
printTableRow("Status", util::cleanUTF8($demande->getStatus()->getName()));
printTableRow("Paiement", util::cleanUTF8($demande->getPaymentMethodString()));
printTableRow("Note", util::cleanUTF8($demande->getDetails()));
?>
