}
ThreadList threadList = remote.getThreadList(individualId, tVO.getId());
threadList = setLinksfunction(threadList);
ListGenerator lg1 = ListGenerator.getListGenerator(dataSource);
HashMap hmDispLists = lg1.getDisplayLists();
if (hmDispLists != null) {
hmDispLists.put(new Long(threadList.getListID()), threadList);
}
Vector timeSlipColumns = new Vector();
timeSlipColumns.addElement("Description");
timeSlipColumns.addElement("Duration");
timeSlipColumns.addElement("CreatedBy");
timeSlipColumns.addElement("Date");
timeSlipColumns.addElement("StartTime");
timeSlipColumns.addElement("EndTime");
TimeSlipList timesliplist = new TimeSlipList();
ListGenerator lg = ListGenerator.getListGenerator(dataSource); //get the List Generator object for Listing
String searchTimeSlipString =
"ADVANCE:select ts.TimeSlipID, ts.Description, ts.CreatedBy, individual.FirstName,"
+ "individual.LastName, ts.BreakTime, ts.Date, ts.Start, ts.End "
+ "from timeslip ts left outer join individual on "
+ "ts.CreatedBy = individual.IndividualID where ts.ticketid="
+ ticketId;
timesliplist = (TimeSlipList)lg.getTimeSlipList(individualId, 1, 200, searchTimeSlipString, "Description");
timesliplist = setTimeSlipLinks(timesliplist, ticketId);
Vector expenseColumns = new Vector();
expenseColumns.addElement("Reference");
expenseColumns.addElement("Amount");
expenseColumns.addElement("Created");
expenseColumns.addElement("Creator");
ExpenseList expenselist = new ExpenseList();
String searchExpenseString =
"ADVANCE:select expense.ExpenseID,expense.Amount,expense.Created,entity.name as Reference ,expense.Status, concat(individual.firstname,' ',individual.lastname) as Creator,individual.IndividualID "
+ "from expense left outer join individual on expense.creator = individual.individualid left outer join entity on expense.entityid = entity.entityid "
+ " where expense.linestatus != 'deleted' and expense.ticket="
+ ticketId
+ " group by expense.ExpenseID,expense.Amount,expense.Created,Reference ,expense.Status, Creator";
expenselist = (ExpenseList)lg.getExpenseList(individualId, 1, 200, searchExpenseString, "Reference"); //called when the request for the list is for first time
expenselist = setExpenseLinks(expenselist, ticketId);
request.setAttribute("closeDate", tVO.getCloseDate());
request.setAttribute("openDate", tVO.getCreatedOn());
request.setAttribute("modifyDate", tVO.getModifiedOn());