/**
* Add activity in database
* @param : Activity object
* @return : false if the insert failed / else true
*/
public function add(Activity $activite)
{
$title = $activite->getTitle();
$descr = $activite->getDescription();
$pos = $activite->getGeoPos();
$type = $activite->getType();
$priority = $activite->getPriority();
$sd = $activite->getStartDate();
$ed = $activite->getEndDate();
$sh = $activite->getStartHour();
$eh = $activite->getEndHour();
$per = $activite->getPeriodic();
$nbOcc = $activite->getNbOccur();
$isInBreak = $activite->getIsInBreak();
$sub = $activite->getIsPossibleToSubscribe();
$public = $activite->getIsPublic();
$idAgenda = $activite->getIdAgenda();
$sql = "INSERT INTO activite (titre, description, positionGeographique, type, priorite, dateDebut, dateFin, heureDebut, heureFin, periodicite, nbOccurence, estEnPause, estPossibleDeSinscrire, estPublic, idAgenda)\n\t\t\tVALUES (:titre, :description, :positionGeographique, :type, :priorite, :dateDebut, :dateFin, :heureDebut, :heureFin, :periodicite, :nbOccurence, :estEnPause, :estPossibleDeSinscrire, :estPublic, :idAgenda)";
$req = $this->_db->prepare($sql);
$req->bindParam(':titre', $title, PDO::PARAM_STR);
$req->bindParam(':description', $descr, PDO::PARAM_STR);
$req->bindParam(':positionGeographique', $pos, PDO::PARAM_STR);
$req->bindParam(':type', $type, PDO::PARAM_STR);
$req->bindParam(':priorite', $priority, PDO::PARAM_INT);
$req->bindParam(':dateDebut', $sd, PDO::PARAM_STR);
$req->bindParam(':dateFin', $ed, PDO::PARAM_STR);
$req->bindParam(':heureDebut', $sh, PDO::PARAM_STR);
$req->bindParam(':heureFin', $eh, PDO::PARAM_STR);
$req->bindParam(':periodicite', $per, PDO::PARAM_STR);
$req->bindParam(':nbOccurence', $nbOcc, PDO::PARAM_INT);
$req->bindParam(':estEnPause', $isInBreak, PDO::PARAM_INT);
$req->bindParam(':estPossibleDeSinscrire', $sub, PDO::PARAM_INT);
$req->bindParam(':estPublic', $public, PDO::PARAM_INT);
$req->bindParam(':idAgenda', $idAgenda, PDO::PARAM_INT);
$req->execute();
$nbTupleInsere = $req->rowCount();
$req->closeCursor();
//check if insert has failed
if ($nbTupleInsere < 1) {
return false;
}
return true;
}
public function showActivity(Activity $act, $idUser)
{
$html = "";
$html .= '
<div class="row">
<div class="col-md-12">
<div class="center" id="successSub">
</div>
<div class="alert alert-info center" role="alert">
<div class="row">
<div class="col-md-6">
Priorité : ' . $act->getPriority() . '
</div>
<div class="col-md-6">
';
if ($act->getIsPublic()) {
$html .= 'Activité publique';
} else {
$html .= 'Activité privée';
}
$html .= '
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-8">
<h1>' . $act->getIdActivity() . ' - ' . $act->getTitle() . ' à ' . $act->getGeoPos() . '</h1>
</div>
<div class="col-md-4">
<div class="row">
<div class="col-md-12">
<div class="notationDiv">
<p>Notation : </p>
<script src="js/ListeEtoile.js"></script>
<div id="notation">
<script type="text/javascript">
CreateListeEtoile(\'notation\',5);
</script>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 center">
';
//if the event is private the button is disabled
if ($act->getIsPossibleToSubscribe()) {
$html .= '<button type="button" id="buttonInscriptionAct" data-idAct=' . $act->getIdActivity() . ' data-idUser='******' class="btn btn-default">S\'inscrire</button>';
} else {
$html .= '<button type="button" class="btn btn-default" disabled="disabled">S\'inscrire</button>';
}
$html .= '
</div>
</div>
</div>
</div>
<div class="row marginBot">
<div class="col-md-12">
Du : ' . $act->getStartDate() . ' au ' . $act->getEndDate() . ' <br/>
De : ' . $act->getStartHour() . ' à ' . $act->getEndHour() . ' <br/>
<br/>
<h3>Description : </h3>
' . $act->getDescription() . '
</div>
</div>
<div class="row">
<div class="col-md-12">
<div id="showComment2">
</div>
</div>
</div>
';
echo $html;
}
