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");
}
}
