// According to userid, pasrse the teamrecord data group by user and assignmentid
public List<TaskData> parseTaskData(List<TeamRecord> records) throws SQLException {
Map<String, TaskData> ticket_map = new HashMap<String, TaskData>();
for (TeamRecord rcd : records) {
// If this line's rmlogin is not in the database, we need to delete this line
if (!rmLoginNames.contains(rcd.getRmlogin())) {
// need to add a log
continue;
}
// to find userid according rmlogin, rmlogin is the remedy's name
// useridtd is String array, useridtd[0] is userId, useridtd[1] is
// timesheetid, useridtd[2] is staffid
String[] strs = trackingTicketScriptDao.findUserId(rcd.getRmlogin(), startDate, endDate);
String uid = strs[0];
String tid = strs[1];
String sid = strs[2];
String assignmentid = trackingTicketScriptDao.findassignmentId(rcd.getTask());
// distinguish the data by assignmentid and id, to confirm each task's ticket_id
if (!ticket_map.containsKey(assignmentid + ":" + uid)) {
TaskData taskdata = new TaskData();
taskdata.setAssignmentid(assignmentid);
ticket_map.put(assignmentid + ":" + uid, taskdata);
}
TaskData taskdata = ticket_map.get(assignmentid + ":" + uid);
taskdata.setRmlogin(rcd.getRmlogin());
TicketInfo ticketinfo = new TicketInfo();
ticketinfo.setDescription(rcd.getTask());
ticketinfo.setAssignee(uid);
ticketinfo.setTicket_id(rcd.getTicketNumber());
String ticket_id =
new Integer(trackingTicketScriptDao.getticket_id(rcd.getTicketNumber())).toString();
// gain the TicketInfo data information from excel
ticketinfo.setId(ticket_id);
ticketinfo.setFunctionPoint(rcd.getFp());
ticketinfo.setEstimation(rcd.getEst());
ticketinfo.setProgress(rcd.getProgress());
ticketinfo.setInternalCommentsCount(rcd.getInternal_Comments());
ticketinfo.setWmCommentsCount(rcd.getWm_Comments());
ticketinfo.setInternalReviewEffort(rcd.getInternal_Review_Effort());
ticketinfo.setInternalReworkEffort(rcd.getInternal_Rework_Effort());
ticketinfo.setExternalReworkEffort(rcd.getExternal_Rework_Effort());
ticketinfo.setTransactionCount(rcd.getTransaction());
ticketinfo.setUpdateBy(sid);
// gain the TicketLog data information from excel
TicketLog ticketLog = new TicketLog();
ticketLog.setAssignmentId(trackingTicketScriptDao.findassignmentId(rcd.getTask()));
ticketLog.setHourSpends(rcd.getDays());
ticketLog.setTimesheetId(tid);
ticketLog.setAssigneeId(sid);
ticketLog.setTicketId(ticket_id);
ticketLog.setComment(rcd.getComment());
taskdata.ticketinfos.add(ticketinfo);
taskdata.ticketLogs.add(ticketLog);
taskdata.setWrong_log(rcd.getWrong_log());
}
List<TaskData> list = new ArrayList<TaskData>(ticket_map.values());
return list;
}
