$annonce = Annonce::with('vendeur', 'quartier', 'quartier.ville')->where("id_annonce", "=", $id)->get();
$types = Type::all();
$villes = Ville::all();
$types = Type::all();
$quartiers = Quartier::all();
$app->render('modification.twig', array('types' => $types, 'quartiers' => $quartiers, 'villes' => $villes, 'annonce' => $annonce));
})->name("modification");
//suppression d'annonce
$app->post('/suppression/:id', function ($id) use($app) {
$image = Image::with('annonce')->where("id_annonce", "=", $id)->delete();
$annonce = Annonce::with('vendeur')->where("id_annonce", "=", $id)->delete();
$app->redirect($app->urlFor("accueil"));
})->name("suppression");
//Validation modification dans bdd
$app->post('/modification/valider-modif/:id/', function ($id) use($app) {
$annonce = Annonce::with('vendeur', 'quartier', 'quartier.ville')->where("id_annonce", "=", $id)->first();
$annonce->description = $app->request->post('description');
$annonce->superficie = $app->request->post('superficie');
$annonce->loc_vente = $app->request->post('loc_vente');
$annonce->prix = $app->request->post('prix');
$annonce->nb_piece = $app->request->post('nb_piece');
$annonce->id_type = $app->request->post('type');
$annonce->id_vendeur = 1;
// ??
$annonce->id_quartier = $app->request->post('quartier');
$vendeur = new Vendeur();
$vendeur = Vendeur::where('mail', '=', $app->request->post('vendeur-email'))->first();
if ($vendeur == null) {
$vendeur = new Vendeur();
$vendeur->name = $app->request->post('vendeur');
$vendeur->mail = $app->request->post('vendeur-email');
public function update(Annonce $annonce)
{
$query = $this->_db->prepare('UPDATE annonce SET titre=:titre, description=:description,
image=:image, image2=:image2, image3=:image3, prix=:prix, ville=:ville, idCategorie=:idCategorie
WHERE id=:idAnnonce AND idUtilisateur=:idUtilisateur') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':idAnnonce', $annonce->id());
$query->bindValue(':titre', $annonce->titre());
$query->bindValue(':description', $annonce->description());
$query->bindValue(':image', $annonce->image());
$query->bindValue(':image2', $annonce->image2());
$query->bindValue(':image3', $annonce->image3());
$query->bindValue(':prix', $annonce->prix());
$query->bindValue(':ville', $annonce->ville());
$query->bindValue(':idCategorie', $annonce->idCategorie());
$query->bindValue(':idUtilisateur', $annonce->idUtilisateur());
$query->execute();
$query->closeCursor();
}
public function delete(Annonce $annonce)
{
$this->_db->exec('DELETE FROM annonce WHERE id=' . $annonce->id());
}
