public function update(Projet $projet)
{
$query = $this->_db->prepare('UPDATE t_projet SET nom=:nom, titre=:titre, adresse=:adresse, superficie=:superficie, description=:description,
budget=:budget, updatedBy=:updatedBy, updated=:updated WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $projet->id());
$query->bindValue(':nom', $projet->nom());
$query->bindValue(':titre', $projet->titre());
$query->bindValue(':adresse', $projet->adresse());
$query->bindValue(':description', $projet->description());
$query->bindValue(':superficie', $projet->superficie());
$query->bindValue(':budget', $projet->budget());
$query->bindValue(':updated', $projet->updated());
$query->bindValue(':updatedBy', $projet->updatedBy());
$query->execute();
$query->closeCursor();
}
public function frmAction($id = NULL)
{
$message = $this->getInstance($id);
$projects = Projet::find();
$users = User::find();
$this->view->setVars(array("message" => $message, "users" => $users, "projects" => $projects));
parent::frmAction($id);
}
public function update(Projet $projet)
{
$query = $this->_db->prepare('UPDATE t_projet SET
name=:name, description=:description, adresse=:adresse,
dateCreation=:dateCreation, avancementConstruction=:avancementConstruction,
avancementFinition=:avancementFinition, updated=:updated, updatedBy=:updatedBy
WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $projet->id());
$query->bindValue(':name', $projet->name());
$query->bindValue(':description', $projet->description());
$query->bindValue(':adresse', $projet->adresse());
$query->bindValue(':dateCreation', $projet->dateCreation());
$query->bindValue(':avancementConstruction', $projet->avancementConstruction());
$query->bindValue(':avancementFinition', $projet->avancementFinition());
$query->bindValue(':updated', $projet->updated());
$query->bindValue(':updatedBy', $projet->updatedBy());
$query->execute();
$query->closeCursor();
}
public function frmAction($id = NULL)
{
$usecase = Usecase::findFirst("code='" . $id . "'");
$projects = Projet::find();
$users = User::find("idRole=2");
$this->view->setVars(array("usecase" => $usecase, "users" => $users, "projects" => $projects));
$_SESSION['bread']['object'] = $usecase;
$this->jquery->exec("\$('input[type=\"range\"]').rangeslider({\n \t\t\t\t\t\t\t\tpolyfill: false,\n\t\t\t\t\t\t\t\tonSlide: function(position, value) {\n\t\t\t\t\t\t\t\t\t\$('.avancement').html(value.toString()+'%');\n\t\t\t\t\t\t\t\t},\n\t\t\t\t\t\t\t});", true);
parent::frmAction($id);
}
public function managerIndex()
{
$user = $this->session->get("user");
$idUser = $user->getId();
$projectsManager = Projet::find("idManager=" . $idUser);
$projectsDvlp = $this->modelsManager->createBuilder()->from('Projet')->join('Usecase', 'Usecase.idProjet = Projet.id')->where("Usecase.idDev = " . $idUser)->groupBy("Projet.id")->getQuery()->execute();
$this->view->pick("index/manager");
$this->jquery->getOnClick("a.list-group-item", "", "#content", array("attr" => "data-ajax"));
$this->jquery->compile($this->view);
$this->view->setVars(array("projectsManager" => $projectsManager, "projectsDvlp" => $projectsDvlp, "user" => $user->getIdentite()));
}
public function projectAction($id = NULL)
{
$p = Projet::findFirst("id=" . $id);
$user = User::findFirst("id=" . $p->getIdAuthor());
//g�n�ration des progress barre pour chaque usecase
foreach ($usecases as $u) {
//progressbar
$avancement = $u->getAvancement();
$this->jquery->bootstrap()->htmlProgressbar($u->getCode(), "success", $avancement)->setStriped(true)->setActive(true)->showcaption(true);
}
//image a mettre
if ($p->getImage() == NULL) {
$source = "../../public/img/increase.png";
} else {
$source = $p->getImage();
}
$this->jquery->getOnClick(".afficher", "", "#detailProject", array("attr" => "data-ajax", "jsCallback" => "\$('#detailProject').slideToggle('slow');"));
$this->jquery->compile($this->view);
$this->view->setVars(array("project" => $p, "user" => $user, "source" => $source, "siteUrl" => $this->url->getBaseUri(), "baseHref" => "Projects"));
}
public function equipeAction($id = NULL)
{
$devs = User::find();
$p = Projet::findFirst("id=" . $id);
$usecases = Usecase::find("idProjet=" . $p->getId());
$dev = array();
$poids = array();
$totalUc = 0;
foreach ($usecases as $uc) {
$totalUc = $totalUc + $uc->getPoids();
}
foreach ($usecases as $uc) {
$u = User::findFirst("id=" . $uc->getIdDev());
$dev[$u->getId()] = $u;
$poids[$u->getId()] = $poids[$u->getId()] + $uc->getPoids();
}
foreach ($devs as $de) {
$poids[$de->getId()] = floor($poids[$de->getId()] / $totalUc * 100);
}
$this->view->setVars(array("dev" => $dev, "poids" => $poids, "p" => $totalUc));
}
public function projectAction($id = NULL)
{
$p = Projet::findFirst("id=" . $id);
$user = User::findFirst("id=" . $p->getId());
//image a mettre
if ($p->getImage() == NULL) {
$source = "../../public/img/increase.png";
} else {
$source = $p->getImage();
}
$message = Message::find("idProjet=" . $p->getId() . " AND idFil is NULL");
$nbMsg = 0;
foreach ($message as $msg) {
$nbMsg = $nbMsg + 1;
}
$this->view->setVars(array("project" => $p, "user" => $user, "source" => $source, "nbMsg" => $nbMsg));
$this->jquery->get("Projects/equipe/" . $p->getId(), "#detailProject");
$this->jquery->click(".btnMessages", "\$('#divMessages').slideToggle('slow');");
$this->jquery->get("Projects/messages/" . $p->getId(), "#divMessages");
$this->jquery->compile($this->view);
}
break;
case $ACTION_projetDelete:
if (isset($_GET["projet"]) && $_GET["projet"] != -1) {
$tempProjet = new Projet($_GET["projet"]);
$tempProjet->delete();
$_SESSION["projet"] = -1;
} elseif (isset($_GET["projet"]) && $_GET["projet"] == -1) {
$_SESSION["projet"] = -1;
}
break;
case $ACTION_projetCreate:
$tempProjet = new Projet(0, $_POST["project_name"], $_POST["project_description"], new Client($_POST["select_project_client"]), new Personne($_POST["select_project_respo"]));
$_SESSION["projet"] = $tempProjet->create();
break;
case $ACTION_projetSave:
$tempProjet = new Projet($_POST["projet"], $_POST["project_name"], $_POST["project_description"], new Client($_POST["select_project_client"]), new Personne($_POST["select_project_respo"]));
$tempProjet->save();
$_SESSION["projet"] = $tempProjet->getId();
break;
case $ACTION_tacheView:
if (isset($_GET["tache"]) && $_GET["tache"] != -1) {
$_SESSION["tache"] = $_GET["tache"];
} elseif (isset($_GET["tache"]) && $_GET["tache"] == -1) {
$_SESSION["tache"] = -1;
}
break;
case $ACTION_tacheDelete:
if (isset($_GET["tache"]) && $_GET["tache"] != -1) {
$tacheTemp = new Tache($_GET["tache"]);
$tacheTemp->delete();
}
public function update(Projet $projet)
{
$query = $this->_db->prepare(' UPDATE t_projet SET
nom=:nom,numeroTitre=:numeroTitre,emplacement=:emplacement,
superficie=:superficie, description=:description,dateCreation=:dateCreation,
createdBy=:createdBy,created=:created, idSociete=:idSociete
WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $projet->id());
$query->bindValue(':nom', $projet->nom());
$query->bindValue(':numeroTitre', $projet->numeroTitre());
$query->bindValue(':emplacement', $projet->emplacement());
$query->bindValue(':superficie', $projet->superficie());
$query->bindValue(':description', $projet->description());
$query->bindValue(':dateCreation', $projet->dateCreation());
$query->bindValue(':createdBy', $projet->createdBy());
$query->bindValue(':created', $projet->created());
$query->bindValue(':idSociete', $projet->idSociete());
$query->execute();
$query->closeCursor();
}
public function __construct(\Projet $projets = null)
{
parent::__construct($projets ? $projets->getVars() : array());
$this->pk = 'id';
$this->table = 'projet';
}
require 'includes/ville.php';
$ville = $_POST['ville'];
$mieuxNotes = "projet.php";
$recherche = "rechercheProjet.php";
$ajouter = "ajoutProjet.php";
require 'includes/menu.php';
require 'includes/menuServices.php';
require 'includes/menuInfos.php';
require 'includes/themesProjet.php';
require 'includes/bbcodeTexte.php';
require 'objets/ObjetProjet.php';
echo '<section id="voirProjet"><h2>Les derniers projets dans cette ville</h2>';
$request = $bdd->query('SELECT * FROM freeCitizenProjet WHERE ville = "' . $ville . '" ORDER BY votes LIMIT 0, 10');
while ($donnees = $request->fetch(PDO::FETCH_ASSOC)) {
//appel au constructeur
$projet = new Projet($donnees);
//affichage du contenu de la bdd
echo $projet->id();
echo "</br>";
echo $projet->titre();
echo "</br>";
echo $projet->date();
echo "</br>";
echo $projet->ville();
echo "</br>";
echo $projet->theme();
echo "</br>";
echo $projet->idAuteur();
echo "</br>";
echo $projet->equipe();
echo "</br>";
public function manageTasksAction($id = null, $idUc = null)
{
$tache = Tache::findFirst($id);
if (!$tache) {
$tache = new Tache();
$tache->setAvancement(0);
$tache->setCodeUseCase($idUc);
}
$users = User::find("idRole<>3");
$this->view->setVars(array("tache" => $tache, "users" => $users, "baseHref" => $this->url->getBaseUri()));
$_SESSION['bread']['object'] = $tache;
$this->jquery->exec("\$('input[type=\"range\"]').rangeslider({\n \t\t\t\t\t\t\t\tpolyfill: false,\n\t\t\t\t\t\t\t\tonSlide: function(position, value) {\n\t\t\t\t\t\t\t\t\t\$('.avancementTasks').html(value.toString()+'%');\n\t\t\t\t\t\t\t\t},\n\t\t\t\t\t\t\t});", true);
$this->view->pick("projects/manageTasks");
$this->jquery->postFormOnClick(".validateTasks", "Taches/updateFromProject", "frmTasks", ".content");
$this->jquery->click(".cancelTask", "\$('.tasks').hide();");
$this->jquery->compile($this->view);
$uc = Usecase::findFirst("code='" . $tache->getCodeUseCase() . "'");
$_SESSION['bread']['object'] = Projet::findFirst($uc->getIdProjet());
}
