public function projetossemanaAction() { $cliente = new SoapClient($this->_WSDL_URI . '/wsdl'); //return new ViewModel(array("dados"=>$cliente->tarefas(1))); $response = $this->getResponse(); $response->getHeaders()->addHeaders(array('Content-type' => 'text/xml')); $xml = $response->setContent($cliente->projetosSemana(1, true)); return $xml; /*$nSemanaHoje = date("w"); $inicioSemana = new \DateTime("-".$nSemanaHoje." days"); $fimSemana = new \DateTime("+".(6-$nSemanaHoje)." days"); $usuario = $this->getEm()->getRepository('MyClasses\Entities\AclUsuario') ->findOneBy(array("id"=>3)); foreach ($usuario->getEquipes() as $equipe) $idsEquipes[] = $equipe->getId(); $query = $this->getEm()->createQueryBuilder(); $query->select("p, up, t, ut, c, uc") ->from("MyClasses\Entities\Projeto", "p") ->leftJoin("p.usuario", "up") ->leftJoin("p.tarefas", "t") ->leftJoin("t.usuario", "ut") ->leftJoin("t.comentarios", "c") ->leftJoin("c.usuario", "uc") ->where($query->expr()->between("t.vencimento", "'".$inicioSemana->format("Y/m/d")."'", "'".$fimSemana->format("Y/m/d")."'" ) ) ->andWhere( $query->expr()->orX( $query->expr()->eq("t.usuario", $usuario->getId()), $query->expr()->in("p.equipe", $idsEquipes) ) ); echo $query->getQuery()->getSql(); $projetos = $query->getQuery()->getResult(\Doctrine\ORM\AbstractQuery::HYDRATE_ARRAY); print_r($projetos);*/ }