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"); } }
<?php error_reporting(E_ALL); 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 != "") {
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
} } 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); if ($submissionValue == 'register') { print createRegisterPasswordField('Choisir mot de passe', 'passw', 128, 'password', "", $errMessagesArray['password'], $readonly);
$demande->getStatus()->setToPrinted(util::cleanUTF8($resultArray[demandStatus::STATUS_DESC_DB_FIELD])); print '<body>'; } else { print '<body onload="javascript:window.print()">'; } ?> <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>