public function listar() { $dql = 'SELECT m, u.apelido FROM Models\\Mensagem m ' . 'JOIN m.usuario u ORDER BY m.dataTs DESC'; $messages = $this->em->createQuery($dql)->setMaxResults(10)->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY); $s = Container::getSession(); $k = $s->get("key"); $iv = $s->get("iv"); foreach ($messages as $msg) { $encrypted = mcrypt_encrypt(MCRYPT_3DES, safeHexToString($k), trim($msg[0]["conteudo"]), MCRYPT_MODE_CBC, safeHexToString($iv)); $item = ["nick" => trim($msg["apelido"]), "mensagem" => stringToHex($encrypted), "hora" => $msg[0]["dataTs"]->format('d/m/y H:i:s')]; $resp[] = $item; } echo json_encode($resp, JSON_UNESCAPED_UNICODE); return ""; }
public function postLoguot(Router $r) { $r->post("/ajax/ControleUsuario/logout", function () { $sessao = Container::getSession(); $sessao->unsetKey("usuario"); echo "Loged out"; }); }