<%@page contentType="text/html; charset=UTF-8"%> <%@ page import = "com.csc.library.databean.workload.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,java.util.*" %> <%@ page import="java.text.DecimalFormat" %> <% com.csc.library.utilities.UProfile up=(com.csc.library.utilities.UProfile)session.getAttribute("userprofile"); String users[]=request.getParameterValues("user_code"); String start=request.getParameter("start"); String end=request.getParameter("end"); WorkloadStatisticReport wr=new WorkloadStatisticReport(up); Vector v=wr.getWorkStatisticReport(users,start,end); DecimalFormat df = new DecimalFormat("0.00"); %> <html> <head> <title>Workload Statistic</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <script language="JavaScript" type="text/JavaScript"> <!-- function Start(page) { OpenWin = this.open(page, "CtrlWindow", "toolbar=no,menubar=no,location=no,scrollbars=no,resizable=no" ); } function showGraph() { document.cscform.action = "STATISTIC_GRAPH.jsp"; document.cscform.submit(); } //--> </script> <link rel="stylesheet" href="CSS/PRINTPAGE.css" type="text/css"> <script language="JavaScript"> var linkset=new Array(); linkset[0]='<table width=\"75%\" border=\"0\" cellpadding=\"1\" cellspacing=\"2\">' linkset[0]+='<td nowrap><font size="2"><a href="javascript:window.print()"><IMG SRC="images/arrow.gif" WIDTH="12" HEIGHT="12" BORDER="0" HSPACE="0" VSPACE="0" > พิมพ์</a></font></td>' linkset[0]+='</table>' </script> <script language="JavaScript1.2" src="JS/PRINTPAGE.js"></script> </head> <body> <div align="center"> <form name="cscform" method="post" action=""> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <table width="733" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="733" bgcolor="#336699" ><div align="right"><font color="#FFFFFF" size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong>Workload Statistic</strong></font></div> </td> </tr> </table> <table width="735" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC"> <tr> <td width="735" bgcolor="#FFFFFF"><div align="right"> <% StringBuffer concat_=new StringBuffer(); for( int i=0;i<users.length;i++) { concat_.append("user_code="+users[i]+"&"); %> <input type="hidden" name="user_code" value="<%=users[i]%>"> <% } concat_.deleteCharAt(concat_.indexOf("&")); %> <input type="hidden" name="start" value="<%= start%>"> <input type="hidden" name="end" value="<%= end%>"> <!--<input type="button" name="Submit2" value="Print" onClick="Start('PRINT_STATISTIC.jsp?<%= concat_.toString() %>&start=<%= start%>&end=<%= end%>')">--> <input type="button" name="Submit" value="Graph" onClick="showGraph()"> </div> </td> </tr> </table> </form> <table width="735" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC"> <tr> <td bgcolor="#F3F3F3"><div align="center"><strong><font size="2">Duration</font></strong> : <font size="2"><strong><font color="#FF0000"><%= start%></font> - <font color="#FF0000"><%= end%></font></strong></font></div></td> </tr> </table> </div> <% WorkloadStatistic wk=null; HashMap hm=null; Set s=null; Iterator it=null; String uname=""; boolean ishead=true; int percent_total=0; long total_amount=0; long total_NS=0,total_NA=0,total_NR=0,total_NAs=0,total_NT=0; long total_ES=0,total_EA=0,total_ER=0,total_EAs=0,total_ET=0; long total_LS=0,total_LA=0,total_LR=0,total_LAs=0,total_LT=0; double percent_N=0,percent_E=0,percent_L=0; for( int i=0;i<v.size();i++ ){ hm=(HashMap)v.get(i); s=hm.keySet(); it=s.iterator(); %> <div align="center"> <table width="736" border="1" cellpadding="1" cellspacing="1" bgcolor="#000000" onMouseover="showmenu(event,linkset[0])" onMouseout="delayhidemenu()" > <tr bgcolor="#CCCCCC"> <td width="30" rowspan="2"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">order</font></strong></div></td> <td width="116" rowspan="2"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">User Name</font></strong></div></td> <td width="92" rowspan="2"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">Workflow Name</font></strong></div></td> <td width="46" rowspan="2"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">Amount</font></strong></div></td> <td height="15" colspan="5" bgcolor="#00FF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">Normal</font></strong></div></td> <td colspan="5" bgcolor="#FFFF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">Extension</font></strong></div></td> <td colspan="5" bgcolor="#FF0000"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">Late</font></strong></div></td> </tr> <tr bgcolor="#FFFFFF"> <td width="26" bgcolor="#00FF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">S</font></strong></div></td> <td width="26" bgcolor="#00FF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">A</font></strong></div></td> <td width="26" bgcolor="#00FF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">R</font></strong></div></td> <td width="26" height="15" bgcolor="#00FF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">As</font></strong></div></td> <td width="26" bgcolor="#00FF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">T</font></strong></div></td> <td width="26" bgcolor="#FFFF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">S</font></strong></div></td> <td width="26" bgcolor="#FFFF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">A</font></strong></div></td> <td width="26" bgcolor="#FFFF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">R</font></strong></div></td> <td width="26" bgcolor="#FFFF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">As</font></strong></div></td> <td width="26" bgcolor="#FFFF00"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">T</font></strong></div></td> <td width="26" bgcolor="#FF0000"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">S</font></strong></div></td> <td width="26" bgcolor="#FF0000"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">A</font></strong></div></td> <td width="26" bgcolor="#FF0000"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">R</font></strong></div></td> <td width="26" bgcolor="#FF0000"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">As</font></strong></div></td> <td width="30" bgcolor="#FF0000"><div align="center"><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">T</font></strong></div></td> </tr> <% total_amount=0; total_NS=0;total_NA=0;total_NR=0;total_NAs=0;total_NT=0; total_ES=0;total_EA=0;total_ER=0;total_EAs=0;total_ET=0; total_LS=0;total_LA=0;total_LR=0;total_LAs=0;total_LT=0; while( it.hasNext() ){ wk=(WorkloadStatistic)hm.get(it.next()); if( !uname.equalsIgnoreCase(wk.getUser_name()) ) uname=wk.getUser_name(); total_amount+=wk.getTotal(); total_NS+=wk.getNS();total_NA+=wk.getNA();total_NR+=wk.getNR();total_NAs+=wk.getNAs();total_NT+=wk.getNT(); total_ES+=wk.getES();total_EA+=wk.getEA();total_ER+=wk.getER();total_EAs+=wk.getEAs();total_ET+=wk.getET(); total_LS+=wk.getLS();total_LA+=wk.getLA();total_LR+=wk.getLR();total_LAs+=wk.getLAs();total_LT+=wk.getLT(); if( ishead ){ %> <tr bgcolor="#F3F3F3"> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= i+1 %></font></div></td> <td height="15"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= uname%></font></td> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getWf_name()%></font></div></td> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getTotal()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNS()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNA()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNR()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNAs()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNT()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getES()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getEA()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getER()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getEAs()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getET()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLS()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLA()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLR()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLAs()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLT()%></font></div></td> </tr> <% ishead=false; }else{ %> <tr bgcolor="#F3F3F3"> <td><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> </font></td> <td height="22"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"> </font></td> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getWf_name()%></font></div></td> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getTotal()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNS()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNA()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNR()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNAs()%></font></div></td> <td bgcolor="#DEFFDD"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getNT()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getES()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getEA()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getER()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getEAs()%></font></div></td> <td bgcolor="#FFFFE1"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getET()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLS()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLA()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLR()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLAs()%></font></div></td> <td bgcolor="#FFE8E8"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= wk.getLT()%></font></div></td> </tr> <% } } ishead=true; if( total_amount==0 ){ percent_N=0; percent_E=0; percent_L=0; percent_total=0; }else{ double[] N = {total_NS,total_NA,total_NR,total_NAs,total_NT}; double[] E = {total_ES,total_EA,total_ER,total_EAs,total_ET}; double[] L = {total_LS,total_LA,total_LR,total_LAs,total_LT}; percent_N=((N[0]+N[1]+N[2]+N[3]+N[4])*100/total_amount); percent_E=((E[0]+E[1]+E[2]+E[3]+E[4])*100/total_amount); percent_L=((L[0]+L[1]+L[2]+L[3]+L[4])*100/total_amount); percent_total=100; } %> <tr bgcolor="#EFEFEF"> <td height="15" colspan="3"><div align="right"><font size="1" face="MS Sans Serif, Tahoma, sans-serif">Total</font></div></td> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_amount %></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_NS %></font></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_NA%></font></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_NR%></font></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_NAs%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_NT%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_ES%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_EA%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_ER%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_EAs%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_ET%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_LS%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_LA%></font></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_LR%></font></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_LAs%></font></div></td> <td bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= total_LT%></font></div></td> </tr> <tr bgcolor="#EFEFEF"> <td height="15" colspan="3"><div align="right"><font size="1" face="MS Sans Serif, Tahoma, sans-serif">%Total</font></div></td> <td><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= percent_total+"%" %></font></div></td> <td colspan="5" bgcolor="#EFEFEF"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= df.format(percent_N)+"%"%></font></div></td> <td colspan="5"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= df.format(percent_E)+"%"%></font></div> </td> <td colspan="5"><div align="center"><font size="1" face="MS Sans Serif, Tahoma, sans-serif"><%= df.format(percent_L)+"%"%></font></div> </td> </tr> </table> <br> <% } %> </div> <hr width="736"> <div align="center"> <table width="600" border="0" cellspacing="0" cellpadding="0"> <tr> <td><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">S= Send </font></strong></td> <td><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">A=Abort</font></strong></td> <td><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">R=Return</font></strong></td> <td><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">As=Assigning</font></strong></td> <td><strong><font size="1" face="MS Sans Serif, Tahoma, sans-serif">T=Take Over</font></strong></td> </tr> </table> </div> </body> </html> <div align="left" id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)"> </div>