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 "";
}
