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