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();
}
}
