<%@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" >&nbsp;พิมพ์</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">&nbsp;</font></td>
          <td height="22"><font size="1" face="MS Sans Serif, Tahoma, sans-serif">&nbsp;</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>