();
TemplateInfoBean bean = null;
String currentTemplateId = "";
// I'm gonna do a small trick here. Since the templates are coming in order, as the sql is grouped by template ID,
// I will keep a reference to TemplateInfoBean and template id created in the previous iteration. If the current
// template id is same as the earlier one, the the query is giving info about an existing bean. Else create
// a new bean.
while (workflowData.next()) {
String templateID = workflowData.getString(DBConstants.T_SUMMARY_TEMPLATE_ID);
if (!currentTemplateId.equals(templateID)) {
currentTemplateId = templateID;
bean = new TemplateInfoBean(templateID);
templateBeans.add(bean);
}
bean.addStatusInfo(workflowData.getString(DBConstants.T_SUMMARY_STATUS), workflowData.getInt("total"));
}
queryManager.close();
// now let's present the information we have
%>
Report on Workflow Templates
| Template Id |
Status |
Count |
Percentage |
|
<%
for (int i = 0; i < templateBeans.size(); i++) {
TemplateInfoBean infoBean = templateBeans.get(i);
List statsusNames = infoBean.getAllStatusNames();
List statusCounts = infoBean.getAllStatusCounts();
long totalStatusCount = infoBean.getTotalCount();
%>
| <%=infoBean.getTemplateID()%>
|
<%
for (int j = 0; j < statsusNames.size(); j++) {
long count = statusCounts.get(j);
if (j > 0) {
%>
<%
}
%>
| <%=statsusNames.get(j)%>
|
<%=count%>
|
<%=format.format(count * 100.00 / totalStatusCount)%>% |
<%
}
%>
<%
}
%>
<%
}
} else {
%>
There are no information available at this time about the Wokflows
<%
}
} catch (WorkflowMonitoringException e) {
%>
An error occurred while retreiving data. Please retry later.
<%
} catch (SQLException e) {
%>
An error occurred while retreiving data. Please retry later.
<%
}
%>