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