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
