public function getDataService($user, $type = 'json') { $queryBuilder = $this->em->createQueryBuilder()->select('cl, e, p, a, d, c')->from('Cliententity', 'cl')->where('cl.user = :user')->setParameter('user', $user)->leftJoin('cl.emails', 'e')->leftjoin('cl.phones', 'p')->leftJoin('cl.addresses', 'a')->leftjoin('cl.documents', 'd')->leftjoin('cl.custom', 'c'); $query = $queryBuilder->getQuery(); $results = $query->getArrayResult(); $results = $query->execute(array(), \Doctrine\ORM\Query::HYDRATE_ARRAY); if ($type == 'json') { return json_encode($results); } else { $this->load->library('XMLParser'); $return = XMLParser::encode($results); return $return->asXML(); } }