1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| public Number countTicketResolved(Date start, Date end,String resolved)
{
String query = "select count(ticket.id) from TicketEntity ticket where lower(ticket.status)='"+resolved.toLowerCase()+"'"+" and ticket.dateCreation >= :debut and ticket.dateCreation<= :fin";
javax.persistence.Query q = ticketDao.getEntityManager().createQuery(query);
q.setParameter("debut", start);
q.setParameter("fin", end);
Number countResult = (Number)q.getSingleResult();
System.out.println("Count resolved ticket result:" + countResult);
return countResult;
}
public Number countTicketInvalid(Date start, Date end,String invalid)
{
String query = "select count(ticket.id) from TicketEntity ticket where lower(ticket.status)='"+invalid.toLowerCase()+"'"+" and ticket.dateCreation >= :debut and ticket.dateCreation<= :fin";
javax.persistence.Query q = ticketDao.getEntityManager().createQuery(query);
q.setParameter("debut", start);
q.setParameter("fin", end);
Number countResult = (Number) q.getSingleResult();
System.out.println("Count invalid ticket result:" + countResult);
return countResult;
}
public Number countTicketClosed(Date start, Date end,String closed)
{
String query = "select count(ticket.id) from TicketEntity ticket where lower(ticket.status) ='"+closed.toLowerCase()+"'"+" and ticket.dateCreation between :debut and :fin";
javax.persistence.Query q = ticketDao.getEntityManager().createQuery(
query);
q.setParameter("debut", start);
q.setParameter("fin", end);
Number countResult = (Number) q.getSingleResult();
System.out.println("Count closed ticket result:" + countResult);
return countResult;
} |
Partager