private function getAddrressFromGuiaRoji(Address $address) { $city = $address->getCity(); $neighborhood = $address->getNeighborhood(); $pc = $address->getPostalCode(); $guiaRojis = $this->getDoctrine()->getRepository("InodataFloraBundle:GuiaRoji")->createQueryBuilder('q')->where("q.neighborhood LIKE :neighborhood")->andWhere("q.city LIKE :city OR q.postal_code = :pc")->setParameters(array('neighborhood' => "%" . $neighborhood . "%", 'city' => "%" . $city . "%", 'pc' => $pc))->getQuery()->getResult(); if ($guiaRojis) { $guiaRoji = $guiaRojis[0]; return "Plano: " . $guiaRoji->getMap() . ", Coordenada: " . $guiaRoji->getCoordinate(); } return ""; }
/** * {@inheritDoc} */ public function load(ObjectManager $manager) { $address = new Address(); $address->setStreet('Rio Tamesi'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion1', $address); $address = new Address(); $address->setStreet('Lazaro Cardenas'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion2', $address); $address = new Address(); $address->setStreet('Av. Revolución'); $address->setNoInt('A'); $address->setNoExt('4562'); $address->setNeighborhood('Col. Altavista'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion3', $address); $address = new Address(); $address->setStreet('Av. Del Estado'); $address->setNoInt('123'); $address->setNoExt('4325'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion4', $address); $address = new Address(); $address->setStreet('Lazaro Cardenas'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion5', $address); $address = new Address(); $address->setStreet('Lazaro Cardenas'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion6', $address); $address = new Address(); $address->setStreet('Calle pelluelas'); $address->setNoInt('A'); $address->setNoExt('2345'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion7', $address); $address = new Address(); $address->setStreet('Luis Donaldo Colosio'); $address->setNoInt('A'); $address->setNoExt('901'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion8', $address); $address = new Address(); $address->setStreet('Abraham Lincoln'); $address->setNoInt('A'); $address->setNoExt('825'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion9', $address); $address = new Address(); $address->setStreet('Av Insurgentes'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion10', $address); $address = new Address(); $address->setStreet('Rio Tamesi'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion11', $address); $address = new Address(); $address->setStreet('Lazaro Cardenas'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion12', $address); $address = new Address(); $address->setStreet('Av. Revolución'); $address->setNoInt('A'); $address->setNoExt('4562'); $address->setNeighborhood('Col. Altavista'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion13', $address); $address = new Address(); $address->setStreet('Av. Del Estado'); $address->setNoInt('123'); $address->setNoExt('4325'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion14', $address); $address = new Address(); $address->setStreet('Lazaro Cardenas'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion15', $address); $address = new Address(); $address->setStreet('Lazaro Cardenas'); $address->setNoInt('A'); $address->setNoExt('1234'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion16', $address); $address = new Address(); $address->setStreet('Calle pelluelas'); $address->setNoInt('A'); $address->setNoExt('2345'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion17', $address); $address = new Address(); $address->setStreet('Luis Donaldo Colosio'); $address->setNoInt('A'); $address->setNoExt('901'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion18', $address); $address = new Address(); $address->setStreet('Abraham Lincoln'); $address->setNoInt('A'); $address->setNoExt('825'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion19', $address); $address = new Address(); $address->setStreet('Av Insurgentes'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Centro'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion20', $address); $address = new Address(); $address->setStreet('Av Universidad'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Centro'); $address->setCity('San Nicolas'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion21', $address); $address = new Address(); $address->setStreet('Av Garza Sada'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Monterrey'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion22', $address); $address = new Address(); $address->setStreet('Av Revolucion'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Monterrey'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion23', $address); $address = new Address(); $address->setStreet('Av Gonzalitos'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Monterrey'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion24', $address); $address = new Address(); $address->setStreet('Av Miguel Aleman'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Apodaca'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion25', $address); $address = new Address(); $address->setStreet('Av Sendero'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Escobedo'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion26', $address); $address = new Address(); $address->setStreet('Av Constitucion'); $address->setNoInt('A'); $address->setNoExt('600'); $address->setNeighborhood('Monterrey'); $address->setCity('Monterrey'); $address->setState('NLE'); $address->setPostalCode('64000'); $manager->persist($address); $manager->flush(); $this->addReference('direccion27', $address); }