return items;
}
public static List<RelatorioVisitaVO> getListRelatorioAU(Date dataInicial, Date dataFinal, Telecentro telecentro) throws Exception {
List<RelatorioVisitaVO> items = new ArrayList<RelatorioVisitaVO>();
PersistentAccess pa = PersistentAccessFactory.getInstance();
HashMap<String, Object> params = new HashMap<String, Object>();
params.put("dataInicio", dataInicial);
params.put("dataFim", dataFinal);
params.put("telecentro", telecentro);
//TODO Quando a serializa��o de Arrays estiver funcionando, substituir o VO pela query abaixo
//"SELECT usario.nome, COUNT(visita), SUM(dataFim - dataInicio) FROM Visita visita WHERE dataInicio >= :dataInicio AND dataFim <= :dataFim",
List<Persistent> list = pa
.search(
"FROM Visita WHERE dataInicio >= :dataInicio AND dataFim <= :dataFim AND telecentro=:telecentro ORDER BY usuario.nome",
params);
Long idAnterior = new Long(-1);