public function add(Enchere $enchere) { $objetsManager = new ObjetManager($this->db); $datefin = $objetsManager->get($enchere->getIdUser())->getDateFin(); $today = date("d/m/Y"); //si la date n'est pas dépassée on autorise l'enchère if (strtotime($datefin) > strtotime($today)) { $last = $this->db->prepare('SELECT IFNULL(MAX(SOMME),0) as somme FROM enchere WHERE idobj = ?'); $last->execute(array($enchere->getIdObj())); $lastEnch = $last->fetch(); //si la nouvelle offre est supérieure à l'ancienne, on autorise l'ajout if ($lastEnch[0] < $enchere->getSomme()) { $enchere->setIdEnchere($this->db->query("SELECT MAX(IDENCHERE) AS MAXIMUM FROM enchere")->fetchColumn() + 1); //NOUVEL ID $req = "INSERT INTO enchere (idenchere,idobj,iduser,somme, dateenchere) VALUES(:idenchere, :idobj,:iduser,:somme, NOW())"; $add = $this->db->prepare($req); $added = $add->execute(array("idenchere" => $enchere->getIdEnchere(), "idobj" => $enchere->getIdObj(), "iduser" => $enchere->getIdUser(), "somme" => $enchere->getSomme())); return $added; } } }
} else { $categorie = ""; } $userco = $userManager->get($iduser); $categories = $categorieManager->getList(); //boucle pour avoir pour chaque objet le prix actuel foreach ($objets as $objet) { $enchere = $enchereManager->getLast($objet->getIdObj()); $objet->setPrix($enchere->getSomme()); } echo $twig->render('search.html.twig', array('objs' => $objets, 'cat' => $categorie, 'cats' => $categories, 'msg' => $nomObjCherch, 'accessuser' => $_SESSION["co"], 'userco' => $userco)); break; // detail d'un objet // detail d'un objet case "details": $objet = $objetsManager->get($_GET["idobj"]); $user = $userManager->get($_GET["iduser"]); $categorie = $categorieManager->get($objet->getIdCategorie()); $enchere = $enchereManager->getLast($_GET["idobj"]); $userco = $userManager->get($iduser); echo $twig->render('objet_details.html.twig', array('obj' => $objet, 'user' => $user, 'accessuser' => $_SESSION["co"], 'cat' => $categorie, 'userco' => $userco, 'enchere' => $enchere)); break; /////// CASES LIES A L'INSCRIPTION /////////// //affichage du formulaire d'inscription /////// CASES LIES A L'INSCRIPTION /////////// //affichage du formulaire d'inscription case "inscription": $userco = $userManager->get($iduser); echo $twig->render('inscription.html.twig', array('accessuser' => $_SESSION["co"], 'userco' => $userco)); break; // affichage du profil d'un utilisateur