/**
*
* @param Request $req
* @return type
*/
public function userAdressAddAction(Request $req)
{
$user = $this->getUser();
$adresses = $user->getUserAdresses();
$adress = new Adress();
$adress->setAdressUser($user);
$form = $this->createForm(new AdressType(), $adress, array('action' => $this->generateUrl('User_Adre_Add')));
$form->handleRequest($req);
if ($form->isValid()) {
$em = $this->getDoctrine()->getManager();
$em->persist($adress);
$em->flush();
$req->getSession()->getFlashBag()->add('success', 'Adresse enregistrée');
return $this->redirect($this->generateUrl('User_Adre_Add'));
}
return $this->render('FrontEndBundle:Page:userAdress.html.twig', array('form' => $form->createView()));
}
public function readByAdress(Adress $adress)
{
$id = $adress->getId();
$query = 'SELECT * FROM user WHERE id_adress = ' . $id . ' ORDER BY id_adress DESC';
$res = $this->db->query($query);
if ($res) {
$users = $res->fetchAll(PDO::FETCH_CLASS, 'User', array($this->db));
return $users;
} else {
throw new Exception('Database error');
}
}
/**
*
* @param \Cbfk\Tf\UserBundle\Entity\Adress $adress
*/
public function addUserAdresses(Adress $adress)
{
$adress->setAdressUser($this);
if (!$this->userAdresses->contains($adress)) {
$this->userAdresses->add($adress);
}
}
