<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"  %>
<%@ page import="java.util.*"%>
<jsp:useBean id="TAU318" class="com.csc.library.system.Task" scope="page" />

<%!
	public String chkdate(String ds){
	String t1,t2="";
        int i=0;
	StringTokenizer stChkFormula = new StringTokenizer(ds,"-");
		while (stChkFormula.hasMoreTokens()){
			t1 = stChkFormula.nextToken().toString();
			if(t1.length()==1){t1="0"+t1;}
                        t2=t2+t1;
                        if(i==0||i==1){t2=t2+"-";}
                        i++;
		}
                return t2;
	}
%>
<%
	TAU318.setChannel(request,response);
	UIManager screen = (UIManager) TAU318.process("MultiEntry","TAU318");
	MultiLine multi = screen.getMultiLine("Tadjtime0");
	multi.goFirst();
	
	String filter="",ds,de,emp,emptest,x1,x2;
	ds = request.getParameter("__dstart");
	de = request.getParameter("__dend");
	System.out.println("date--->"+ds+"<->"+de);

        emptest=screen.getUProfile().get("actor");
	System.out.println("employeeid--->"+emptest);

	DbTable table = multi.getTable();
	System.out.println("getTable-->"+multi.getTable());
	if(( ds==null)||ds.equals("") && ( de==null)||de.equals(""))
	{
	filter = "(doctype='O' or doctype='B')and employeeid="+"'"+emptest+"'";
	}
	else if(( ds!=null) && ( de!=null))
	{
	x1 = chkdate(ds);
	x2 = chkdate(de);
	filter = "(doctype='O' or doctype='B') and (docdate between "+"'"+x1+"' and '"+x2+"') and employeeid="+"'"+emptest+"'";
	}
	System.out.println("filter--->"+filter);
	table.setFilter(filter);
	table.setKeyOff();
	table.refresh();
	
	java.text.DecimalFormat df=new java.text.DecimalFormat("#0.00");
       

%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script type='text/javascript' src='../JS/DATEINPUT.js'></script>
<script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script>
<script language="javascript">getTitleName();</script>

<script language="JavaScript" type="text/JavaScript">
function chkDateTime1(valueSearch){
	var tmpval="";
	with(document.cscform){
		var valueSearch1=valueSearch.split("-");
		if(valueSearch1.length==3){
			if(valueSearch1[1].length==1){
				valueSearch1[1]="0"+valueSearch1[1];
			}
			if(valueSearch1[0].length==1){
				valueSearch1[0]="0"+valueSearch1[0];
			}
			valueSearch1[2]=parseInt(valueSearch1[2]);
        	return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0];
		 }
	}
}

function bdOnload() {
	with(document.cscform){
		var a=chkDateTime1(dstart.value);
		var b=chkDateTime1(dend.value);
		__dstart.value=a;
		__dend.value=b;
		__cmd.value="search";
		submit();
	}
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}


</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<% CscCalendar cs = new CscCalendar();%>
<form name="cscform" method="post" action="TAU318.jsp">
 

<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->

<input type="hidden" name="__screen" value="TAU318">
  <input type="hidden" name="__multiTable" value="Tadjtime0">
  <input type="hidden" name ="__headMulti" value="TAU318">
  <input type="hidden" name="__calendar">
  <script language="javascript">getInputFormatDate();</script>
  <input type="hidden" name="__help" value="">
  <input type="hidden" name="__helpReturn" value="">
  <input type="hidden" name="__helpName" value="">
  <input type="hidden" name="__pageCall" value="">
  <input name="__fixCon" type="hidden" value="companyid ='<%=screen.getUProfile().get("companyid")%>'">
  
  <input type="hidden" name="__cmd" value="">
  <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
  <input type="hidden" name="__notNull" value="<%=screen.getRequire()%>">

  <input name="__language" type="hidden" value="<%=screen.getUProfile().get("lang")%>">
   <% if (request.getParameter("__dstart")==null) { %>
  	<input type="hidden" name="__dstart" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>">
  	<% } else {%>
  	<input type="hidden" name="__dstart" value="<%=request.getParameter("__dstart")%>">
  	<%}%>
  	<% if (request.getParameter("__dend")==null) { %>
  	<input type="hidden" name="__dend" value="<%=cs.getDDMMYYYY()%>">
  	<% } else {%>
  	<input type="hidden" name="__dend" value="<%=request.getParameter("__dend")%>">
  	<%}%>

  <input type="hidden" name="__childFilter">

	<%
		String d_start="",d_end="";
		if (request.getParameter("__dstart")!=null) d_start=request.getParameter("__dstart");
		if (request.getParameter("__dend")!=null) d_end=request.getParameter("__dend");
	%>
     <div align="center">
    <br>
    <table cellpadding="0" cellspacing="0">
      <tr >
        <td width="640"  class="header">TAU318, <script language="javascript">swapLang('OT Statistic After Approve');</script>&nbsp;</td>
    </tr>
      <tr>
        <td colspan="2"> <div align="center">
            <center>
              <table cellpadding="0" cellspacing="0">
                <tr>
                  <td class="blankspace" colspan="2"></td>
                </tr>
                <tr>
                  <td class="columnlabel"><%=screen.getLabel("employeeid")%>&nbsp;</td>
                  <td width="482"><%=screen.getUProfile().get("actor")%></td>
                </tr>
                <tr>
					<td ><div align="right"><%=screen.getLabel("fname")%>&nbsp;</div></td>
					<td ><%=screen.getUProfile().get("fullname")%></td>
                </tr>

                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang('Time Period');</script>&nbsp;</td>
                  <td>
				  <% if (request.getParameter("dstart")==null) { %>
				  <input name="dstart" type="text" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>" size="10" >&nbsp;
				  <% } else {%>
				   <input name="dstart" type="text" value="<%=request.getParameter("dstart")%>" size="10" >&nbsp;
				  <% }%>
				  <a href="#" onMouseOut="MM_swapImgRestore()"
					onMouseOver="MM_swapImage('calendar1','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)">
                    <img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar1"
					width="20" height="20" border="0" align="absmiddle"
					onClick="viewCal('dstart')" alt="Calendar"></a>&nbsp;
					<% if (request.getParameter("dend")==null) { %>
				  <input name="dend" type="text" value="<%=cs.getDDMMYYYY()%>" size="10" >&nbsp;
				   <% } else {%>
				   <input name="dend" type="text" value="<%=request.getParameter("dend")%>" size="10" >&nbsp;
				  <% }%>
					<a href="#" onMouseOut="MM_swapImgRestore()"
					onMouseOver="MM_swapImage('calendar2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)">
                    <img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar2"
					width="20" height="20" border="0" align="absmiddle"
					onClick="viewCal('dend')" alt="Calendar"></a> <a
					href="javascript:bdOnload();"> <img src="../IMAGES/BUTTON/SUBMIT.gif"
					 border="0" align="absbottom"></a></td>
                </tr>
                <tr>
                  <td class="columnlabel">&nbsp;</td>
                  <td></td>
                </tr>
                <tr align="center">
                  <td height="21" colspan="2"> <table width="1191" border="0" cellpadding="0" cellspacing="0"
					class="inframe">
                      <tr bgcolor="#3366CC">
                        <td width="62" align="center" class="row3"><%=multi.getLabel("doctype")%></td>
                        <td width="148" align="center" class="row3"><%=multi.getLabel("docdate")%></td>
                        <td width="125" align="center" class="row3"><%=multi.getLabel("tm_bg")%></td>
                        <td width="121" align="center" class="row3"><%=multi.getLabel("tm_en")%></td>
                        <td width="112" align="center" class="row3"><script language="javascript">swapLang('OT Total');</script></td>
                        
                      </tr>
                      <%if(!multi.getDataLabel("doctype").trim().equals("")){
                      double total=0,tmbg=0,tmen=0;
					  do{
					 tmbg=Double.parseDouble(multi.getDataLabel("tm_bg"));
					 tmen=Double.parseDouble(multi.getDataLabel("tm_en"));
					 total=tmen-tmbg;
					 if(total<0){
                                           total=total*-1;
                                           }

					  %>
                      <tr>
                        <td align="center" class="forborder"><%=multi.getDataLabel("doctype")%></td>
                        <td align="center" class="forborder"><%=multi.getDataLabel("docdate")%></td>
                        <td align="center" class="forborder"><%=tmbg%></td>
                        <td align="center" class="forborder"> <%=tmen%></td>
                        <td align="center" class="forborder"> <%=df.format(total)%> </td>
                        
                      </tr>
                      <%multi.next(); }while(!multi.eof());}%>
                    </table></td>
                </tr>
                <tr>
                  <td class="blankspace" colspan="2"></td>
                </tr>
              </table>
              <br>
            </center>
          </div></td>
      </tr>
      <tr>
        <td class="bottom"></td>
      </tr>
    </table></center>
    </div>
</div>
</form>
<!--Start ERROR AND WARNING -->
<!--END ERROR AND WARNING -->
</body>
</html>