public function getprojetosAction()
{
/*$usuarioProjetos = $this->getEm()->getRepository('MyClasses\Entities\AclUsuario')
->findOneBy(array("id" => 1));
$equipeAdm = $this->getEm()->getRepository('MyClasses\Entities\AclPerfil')
->findOneBy(array("id" => 1));
$ultimaSincronizacao = new \DateTime("2025/01/01 09:00:00");
$query = $this->getEm()->createQueryBuilder();
$query->select("p")
->from('MyClasses\Entities\Projeto', 'p')
->where($query->expr()->gt("p.modificado", "'".$ultimaSincronizacao->format("Y/m/d H:i:s")."'"))
->setMaxResults(1);
if (count($query->getQuery()->getResult())>0){
$query = $this->getEm()->createQueryBuilder();
$query->select("p")->from('MyClasses\Entities\Projeto', 'p');
if ($usuarioProjetos->getEquipes()->contains($equipeAdm)) {
$query->Where($query->expr()->orX(
$query->expr()->eq("p.usuario", 1),
$query->expr()->isNull("p.usuario")
)
);
}else
$query->Where($query->expr()->eq("p.usuario", 1));
print_r($query->getQuery()->getResult(\Doctrine\ORM\AbstractQuery::HYDRATE_ARRAY));
}else echo "nenhum projeto novo";*/
/*$rsm = new ResultSetMappingBuilder($this->getEm());
$rsm->addEntityResult("MyClasses\Entities\Projeto", "p");
$rsm->addFieldResult("p", "id", "id");
$rsm->addFieldResult("p", "nome", "nome");
$sql = "SELECT
IF ((modificado > '".$ultimaSincronizacao->format("Y/m/d H:i:s")."'),
id,
NULL)
AS id,
IF ((modificado > '".$ultimaSincronizacao->format("Y/m/d H:i:s")."'),
nome,
NULL)
AS nome
FROM Projeto
WHERE usuario_id=1";
if ($usuarioProjetos->getEquipes()->contains($equipeAdm)) {
$sql .=" OR usuario_id IS NULL";
}
$query = $this->getEm()->createNativeQuery($sql." ORDER BY nome ASC", $rsm);
echo $query->getSql();
print_r($query->getResult(\Doctrine\ORM\AbstractQuery::HYDRATE_ARRAY));*/
$cliente = new SoapClient($this->_WSDL_URI . '/wsdl');
$response = $this->getResponse();
$response->getHeaders()->addHeaders(array('Content-type' => 'text/xml'));
$xml = $response->setContent($cliente->getProjetos(1, "2015/01/01 09:00:00"));
return $xml;
}
