/** Returns an ArrayList of Annotations with a TicketID. */
public static ArrayList<Annotation> getAnnotations(int ticketNum) {
DBHelper db = DBHelperFactory.createDBHelper();
ArrayList<Annotation> result = db.createAnnotationArrayListByTicket(ticketNum);
db.close();
return result;
}
/** Returns the last Annotation by date attached to a specified TicketID. */
public static Annotation getLastAnnotation(int ticketID) {
DBHelper db = DBHelperFactory.createDBHelper();
ArrayList<Annotation> temp = db.createAnnotationArrayListByTicket(ticketID);
Annotation result = temp.get(temp.size() - 1);
db.close();
return result;
}
/**
* Returns a formatted string that indicates the last time a Ticket was worked on (in other words,
* the date of the last annotation)
*/
public static String getLastActivity(int ticketNumber) {
DBHelper db = DBHelperFactory.createDBHelper();
ArrayList<Annotation> annos = db.createAnnotationArrayListByTicket(ticketNumber);
java.sql.Timestamp lastActivity = new java.sql.Timestamp(0L);
for (int i = 0; i < annos.size(); i++) {
java.sql.Timestamp ts = annos.get(i).getCreatedOn();
if (ts.after(lastActivity)) {
lastActivity.setTime(ts.getTime());
}
}
String result = getTime(lastActivity);
db.close();
return result;
}