function my_reservations1()
{
?>
<form method="post">
<?php
$endosersTable = new ReservationTable();
$endosersTable->prepare_items();
$endosersTable->display();
?>
</form>
<?php
}
public function executeFormUpdate(sfWebRequest $request)
{
if (!$request->isXmlHttpRequest()) {
$this->forward404Unless(false);
}
$idSalle = $request->getParameter("idSalle", -1);
$UserID = $request->getParameter("UserID", -1);
$idResa = intval($request->getParameter("idResa", -1));
$reservation = ReservationTable::getInstance()->getReservationById($idResa)->fetchOne();
// On a pas l'id de la salle
// Donc on va la chercher via la reservation
if ($idSalle == -1) {
$idSalle = $reservation->getSalle()->getId();
}
$PoleId = SalleTable::getInstance()->getSalleById($idSalle)->fetchOne()->getIdPole();
$SalleName = SalleTable::getInstance()->getSalleById($idSalle)->fetchOne()->getName();
// création du tableau à passer au constructeur du formulaire de réservation
$values = array('UserID' => $UserID, 'idSalle' => $idSalle, 'PoleId' => $PoleId, 'SalleName' => $SalleName);
$this->form = new ReservationForm($reservation, $values);
//$PoleId= SalleTable::getInstance()->getSalleById($idSalle)->fetchOne()->getIdPole();
$this->form->setDefault('estvalide', 0);
$this->ok = false;
$this->afficherErreur = false;
return $this->renderPartial('reservation/formUpdate', array('form' => $this->form, 'idSalle' => $idSalle, 'PoleId' => $PoleId, 'SalleName' => $SalleName));
}
public function checkJourLibre($validator, $values)
{
if ($values['id'] != NULL) {
$q = ReservationTable::getInstance()->isJourLibreUpdate($values['date'], $values['id_salle'], $values['id']);
} else {
$q = ReservationTable::getInstance()->isJourLibre($values['date'], $values['id_salle']);
}
$r = $q->fetchOne();
$result = $r["count"];
if ($result > 0) {
throw new sfValidatorError($validator, 'Impossible de valider, cette salle a été réservée toute la journée.');
}
return $values;
}
public function executeStatMois(sfWebRequest $request)
{
$this->statMois = ReservationTable::getInstance()->getStatMois();
}
