public function action_validcom() { $com['idClient'] = $this->session->session_ouverte()->getIdClient(); $modm = new ModeleManager(DB::get_instance()); $mod = $modm->getByName($this->req->name); $com['idModele'] = $mod->getIdModele(); $com['contenu'] = $this->req->com; $com['note'] = $this->req->note - 1; $com['dateCom'] = date('Y-m-d', time() + 7200); $commentaire = new Commentaire($com); $comm = new CommentaireManager(DB::get_instance()); $comm->add($commentaire); Site::redirect("car", "index&name=" . $this->req->name); }
<?php function chargerClasse($classe) { require $classe . '.class.php'; // On inclue la classe correspondante au paramètre passé } spl_autoload_register('chargerClasse'); echo $_POST['note']; if (isset($_POST['note']) && isset($_POST['auteur']) && isset($_POST['comm']) && isset($_POST['voiture'])) { $rep['note'] = $_POST['note']; $rep['auteur'] = $_POST['auteur']; $rep['contenu'] = $_POST['comm']; $rep['voiture'] = $_POST['voiture']; $db = new PDO("mysql:host=localhost;dbname=location", "root", ""); $manage = new CommentaireManager($db); $comm = new Commentaire($rep); var_dump($comm); $manage->add($comm); } else { echo " un champs est mal renseigné!"; }
<?php require_once "../private/config.php"; require_once "../views/GeneralView.class.php"; require_once "../models/CommentaireManager.class.php"; require_once "../models/UserManager.class.php"; $userManager = new UserManager($db); $comManager = new CommentaireManager($db); $gView = new GeneralView(); $agendaId = htmlspecialchars($_GET['idAgenda']); $infosParent = array(); $infosSon = array(); $infosParent = $comManager->getParentCommentOfAgenda($agendaId); if ($infosParent) { foreach ($infosParent as $key => $comParent) { $infosSon[] = $comManager->getSonComment($comParent->getIdCommentaire()); } } else { $infosSon = false; } $gView->showComments($infosParent, $infosSon, $userManager);
<?php require_once "private/config.php"; require_once "views/GeneralView.class.php"; require_once "views/ErrorOrSuccessView.class.php"; require_once "models/Commentaire.class.php"; require_once "models/CommentaireManager.class.php"; $comManager = new CommentaireManager($db); $viewG = new GeneralView(); $viewG->header("Modification d'un commentaire"); $viewG->navBar("Modification d'un commentaire"); if (isset($_SESSION['login'])) { $com = $comManager->getComment(htmlspecialchars($_GET['idCom'])); } ?> <p>Modification du commentaire : <br/><br/> <form action="commentaireModified.php" method="post" class="form-group"> <input type="hidden" name="idCommentaire" value="<?php echo $com->getIdCommentaire(); ?> "/> <input type="hidden" name="idCommentaireParent" value="<?php echo $com->getIdCommentaireParent(); ?> "/> <input type="hidden" name="idActivite" value="<?php echo $com->getIdActivite(); ?> "/>
<html> <head> </head> <body> <form enctype="text/palin" method="post" action="valComm.php" name="f_comm" id="f_comm"> <fieldset> <input type="text" value="test" readonly="readonly" name="auteur" id="auteur"/> <label>Note</label><br /> <input type="radio" name="note" id="n1" value=1 />1 <input type="radio" name="note" id="n2" value=2 />2 <input type="radio" name="note" value=3 id="n3"/>3 <input type="radio" name="note" id="n4" value=4 />4 <input type="radio" name="note" value=5 id="n5"/>5<br /> Commentaires <br /> <textarea id="comme" name="comm"></textarea> <br /> <input type="text" value="porsche" readonly="readonly" name="voiture" id="voiture"/> <input type="submit" value="Envoyez"/> </fieldset> </form> <br /><br /> <?php $db = new PDO("mysql:host=localhost;dbname=location", "root", ""); $manage = new CommentaireManager($db); $manage->listing(); ?> </body> </html>
<?php require_once "private/config.php"; require_once "views/GeneralView.class.php"; require_once "views/ErrorOrSuccessView.class.php"; require_once "models/Commentaire.class.php"; require_once "models/CommentaireManager.class.php"; $manager = new CommentaireManager($db); $viewG = new GeneralView(); $viewG->header("Modification d'un commentaire"); $viewG->navBar("Modification d'un commentaire"); if (isset($_POST['idCommentaire']) && isset($_POST['idCommentaireParent']) && isset($_POST['idActivite']) && isset($_POST['commentaire']) && $_POST['EnvoyerModifCom'] == 'Envoyer') { $commentaire = new Commentaire($_POST); $manager->modify($commentaire); echo 'La modification de votre commentaire a bien été prise en compte.<br/>'; } $viewG->footer();
<?php require_once "private/config.php"; require_once "views/GeneralView.class.php"; require_once "views/ErrorOrSuccessView.class.php"; require_once "models/Commentaire.class.php"; require_once "models/CommentaireManager.class.php"; $manager = new CommentaireManager($db); $errV = new ErrorOrSuccessView(); $viewG = new GeneralView(); $viewG->header("Ajout d'un commentaire"); $viewG->navBar("Ajout d'un commentaire"); if (isset($_POST['commenter'])) { if ($_POST['commenter'] == "") { $data["commentaire"] = htmlspecialchars($_POST["commentUser"]); $data["dateCommentaire"] = date("Y-n-j"); $data["heureCommentaire"] = date("G:i:s"); $data["idCommentaireParent"] = ''; $data["idUtilisateur"] = $_SESSION["idUser"]; $data["idActivite"] = 2; $com = new Commentaire($data); $manager->add($com); $errV->successCreateComment(); } /*$commentaire = new Commentaire($_POST); $manager->add($commentaire); echo('Votre commentaire a bien été crée <br/>');*/ } $viewG->footer();
<?php require_once "../private/config.php"; require_once "../models/CommentaireManager.class.php"; require_once "../views/GeneralView.class.php"; require_once "../models/UserManager.class.php"; $userManager = new UserManager($db); $comManager = new CommentaireManager($db); $gView = new GeneralView(); //Comment part $infosParent = array(); $infosSon = array(); $idActivity = htmlspecialchars($_GET['idActivity']); $infosParent = $comManager->getParentCommentOfActivity($idActivity); if ($infosParent) { foreach ($infosParent as $key => $comParent) { $infosSon[] = $comManager->getSonComment($comParent->getIdCommentaire()); } } else { $infosSon = false; } $gView->showComments($infosParent, $infosSon, $userManager);
<?php require_once "private/config.php"; require_once "views/GeneralView.class.php"; require_once "views/ErrorOrSuccessView.class.php"; require_once "models/Agenda.class.php"; require_once "models/AgendaManager.class.php"; require_once "models/Commentaire.class.php"; require_once "models/CommentaireManager.class.php"; $agendaManager = new AgendaManager($db); $comManager = new CommentaireManager($db); $viewG = new GeneralView(); $viewG->header("Suppression d'un commentaire"); $viewG->navBar("Suppression d'un commentaire"); if (isset($_SESSION['login'])) { $comment = $comManager->getComment(htmlspecialchars($_GET['idCom'])); } if (isset($_GET['idCom'])) { $commentairesFils = $comManager->getSonComment($comment->getIdCommentaire()); if ($commentairesFils == false) { $comManager->remove($comment); } else { foreach ($commentairesFils as $fils) { $fils->setIdCommentaireParent($comment->getIdCommentaireParent()); } $comment->setIdCommentaireParent(null); $comManager->remove($comment); } echo 'Félicitations, le commentaire a bien été supprimé'; } $viewG->footer();
<?php require '../objects/Commentaire.class.php'; require '../managers/CommentaireManager.class.php'; require '../objects/Voiture.class.php'; require '../managers/VoitureManager.class.php'; require '../objects/Technicien.class.php'; require '../managers/TechnicienManager.class.php'; require '../objects/Facture.class.php'; require '../managers/FactureManager.class.php'; try { $db = new PDO('mysql:host=127.0.0.1; port=3307;dbname=atelier_garage', 'root', 'toor'); } catch (Exception $e) { die('Erreur : ' . $e->getMessage()); } $commentaireManager = new CommentaireManager($db); $technicienManager = new TechnicienManager($db); $voitureManager = new VoitureManager($db); $voiture = $voitureManager->get('abc-789-38'); $technicien = $technicienManager->get(213456); $commentaire = new Commentaire(['voiture' => $voiture->immatriculation(), 'technicien' => $technicien->numero(), 'date' => '', 'texte' => 'Cette voiture a l\'air en salle état']); print_r($commentaire); //on rajoute un commentaire en bdd $commentaireManager->add($commentaire); //on compte, doit retourner 1 //echo $commentaireManager->count(); //on test le get $commentaire = $commentaireManager->get($voiture, $technicien, '2016-01-13 17:21:32'); if (empty($commentaire)) { echo "c'est vide"; } else {
<?php require_once "views/GeneralView.class.php"; require_once "views/ErrorOrSuccessView.class.php"; require_once "private/config.php"; require_once "models/Agenda.class.php"; require_once "models/AgendaManager.class.php"; require_once "models/User.class.php"; require_once "models/UserManager.class.php"; require_once "models/Commentaire.class.php"; require_once "models/CommentaireManager.class.php"; $viewG = new GeneralView(); $manager = new AgendaManager($db); $userMan = new UserManager($db); $commentMan = new CommentaireManager($db); $viewG->header("CalendarFactory"); $viewG->navBar("Admin"); $dataTabAgenda = $manager->getAllAllAgenda(); $dataTabUser = $userMan->getAllUsers(); $dataTabComm = $commentMan->getAllComments(); $viewG->generateAdminPanel($dataTabUser, $dataTabAgenda, $dataTabComm); $viewG->footer();