<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,com.csc.library.components.*;"%>
<jsp:useBean id="TAMC01" scope="page" class="com.csc.library.system.Task"/>
<%
		TAMC01.setChannel(request ,response);
		HelpEntry screen=(HelpEntry)TAMC01.process("HelpEntry","MEMPL_BOXHELP");
		CheckNull chk = new CheckNull();
		int maxRec = 100;
		
		screen.setMaxLine(maxRec);
		String orderBy = chk.chkNullString(request.getParameter("__orderBy"));
		//out.println("<br>");
		//out.println("orderBy : " + orderBy);
		//String goPage = chk.chkNullString(request.getParameter("__goPage"),"0").replace("+", "");
		String filter = "EMPLOYEEID IN(select EMPLOYEEID from MEMPL_BOX where BOX_TYPE='0' group by EMPLOYEEID having COUNT(1)>1 union all select EMPLOYEEID from MEMPL_BOX where BOX_TYPE='0' group by EMPLOYEEID having COUNT(1)=0)";
		
		String filter2 = "EMPLOYEEID IN(select EMPLOYEEID from MEMPL_BOX where BOX_TYPE='0' group by EMPLOYEEID having COUNT(1)>1 )";
		screen.inq.setFilter(filter);
		//screen.getInquiry().setOrderBy("EMPLOYEEID,BOX_TYPE");
		//out.println("order by ="+screen.getInquiry().getOrderBy());
		screen.process();
		screen.getInquiry().setOrderBy("EMPLOYEEID,BOX_TYPE");
		//screen.getInquiry().refresh();
		

%>
<html ng-app="myHR">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script language="javascript" type="text/javascript" src="../JS/SCREEN.js"></script>
<script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>	
<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">setLang("<%=screen.getUProfile().get("lang")%>");</script>
<script language="javascript" type="text/javascript">getTitleName();</script>
<script language="javascript" type="text/javascript" src="../JS/EMPLOYEE.js"></script>
<script language="javascript" type="text/javascript" src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript" type="text/javascript" src="../JS/ICONSMENU.js"></script>
<script language="javascript" type="text/javascript" src="../JS/HOTKEY.js"></script>
<script language="javascript" type="text/javascript">

function foundData(m){
	document.getElementById("sizeData").innerHTML = m;
}


function goPageEdit(page,boxid,empid){
	var conSearch = "__boxid$"+boxid+";__employeeid$"+empid+";";
	var win = window.open(page+"?__help="+conSearch,"Child","left=150,top=20,width=700,height=200,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
	win.focus();
}

function goReturn(){
	with (document.cscform){
		submit();
	}
}
</script>


</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
	helpReturn=request.getParameter("__helpReturn");
}
String fieldSearch="";
if(request.getParameter("__fieldSearch")!=null){
	fieldSearch=request.getParameter("__fieldSearch");
}
%>
<body  leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="TAMC01.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__orderBy" value="">
<input type="hidden" name="__helpReturn" value="<%=helpReturn%>">
<input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>"> 
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__maxRec" value="<%=screen.getRecCount()%>">
<input type="hidden" name="__recCount" value="<%=maxRec%>">
<input type="hidden" name="__screen" value="MAPPROVE_BOX">
<input type="hidden" name="__action" value="">
<input type="hidden" name="__listEmp" value="">
<input type="hidden" name="__confirm" value="s">
	<input type="hidden" name="__headMulti" value="TAMC01">
	<input type="hidden" name="__childMulti" value="TAMC011">

<br>
  <table height="" align="center" cellpadding="0" cellspacing="0" class="large">
    <tr bgcolor="#3366CC">
      <td class="header"><strong>TAMC01,
	  <span swlang code="SW001769">Tamc01</span>&nbsp;</strong></td>
  </tr>
   <tr bgcolor="#3366CC">
      <td> <table class="maxsize" border="1" cellspacing="1" cellpadding="1">
          <tr>
            <td><table class="maxsize" align="center" cellpadding="0" cellspacing="0">
                <tr> 
                  <td colspan="4"  class="blankspace" ></td>
                </tr>
                <tr> 
                <td width="20%"> <div align="right">
                     <td class="columnlabel"><span swlang code="SW000005">Search By</span>

                      &nbsp;</div></td>
                <td><div align="left"><%=screen.getTagSearchBy()%></div></td>
				</tr>
				<tr>
				<td><div align="right">
                      <td class="columnlabel"><span swlang code="SW000006">Condition</span>
                      &nbsp; </div></td>
                  <td><%=screen.getTagConSearch()%></td>
				
				</tr>
				<tr>
					<td> <div align="right">
                      <td class="columnlabel"><span swlang code="SW000007">Key Value</span>

                      &nbsp;</div></td>
                 <td><div align="left"><%=screen.getTagValueSearch()%> <a href="javascript:searchH();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></div></td>
				</tr>

				<tr> 
                  <td colspan="4"  class="blankspace" ></td>
                </tr>
				<tr>			
				<td colspan="4">&nbsp;&nbsp;&nbsp;<span swlang code="SW000927">Found Data</span>&nbsp;&nbsp;<span id="sizeData"></span></td>
                  
                </tr>
				
                
              </table></td>
          </tr>
        </table></td>
  </tr>
<tr>
	<td>
	<br>
  <table width="" cellpadding="0" cellspacing="1" cols="6" bgcolor="#333333" class="inframe" id="rsTable" name="rsTable">
    <tr bgcolor="#3366CC">
		
						
						<td width="2%" class="row3"><div align="center"><span swlang code="SW000193">Seq</span></td>

						<td width="3%" class="row3"><div align="center"><span swlang code="SW000011">Code</span></div></td>

						<td width="10%" class="row3"><div align="center"><span swlang code="SW007745">Name Surname</span></div></td>

						<td width="15%" class="row3"><div align="center"><span swlang code="SW001766">Work model</span></div></td>

						<td width="12%" class="row3"><div align="center"><span swlang code="SW000057">Position</span></div></td>
						
						
    </tr>
	<% 
		/*int c = Integer.parseInt(goPage);
		int i=0;
		int j;
		if(c== 0 || c==1){
			j = 1;
		}else{
			j = ((c*maxRec)-maxRec)+1;
		} */
		int j=1;

		String empId = "";
		String tmp="";
	while(screen.nextRec()){
		screen.referLangOn();
			tmp = screen.getString("MEMPLOYEE","EMPLOYEEID");
			if(!(empId.equals(tmp))){	%>
		<tr>
			<td><div align="center"><%=j%></div></td>
			<td><div align="center"><%=screen.getString("MEMPLOYEE","EMPLOYEEID")%></div></td>
			<td><div align="left"><%=screen.getString("MEMPLOYEE","FULLNAME")%></div></td>
			<td><div align="center"><%=screen.getString("MJOBCODE","TDESC")%></div></td>
			<td><div align="center"><%=screen.getString("mposition","tdesc")%></div>
	
	</tr>
			<% 		
		j++;
	}
	%>
	 
		<tr>
			<td colspan="2"><div align="center"></div></td>
			<td colspan ="4"><div align="left"><a href="javaScript:goPageEdit('TAMC011.jsp','<%=screen.getString("BOXID")%>','<%=screen.getString("MEMPLOYEE","EMPLOYEEID")%>')"><%=screen.getString("BOXID") + " " + screen.getInquiry().getCurrentDbRecord().getSystemCode("BOX_TYPE")%></a></div></td>
			
		</tr>

	<% 

		
	
		
	empId = screen.getString("MEMPLOYEE","EMPLOYEEID");
	}
	screen.referLangOff();
	%>
	<script language="javascript">foundData('<%=j-1%>');</script>


	  
  </table>
 </td>
 </tr>
 <tr>
	 <td colspan="6" class="blankspace"></td>
 </tr>

	<tr>
	 <td colspan="6" class="blankspace"></td>
 </tr>
	<tr>
        <td   colspan="6" class="bottom"></td>
     </tr>
 </table>
  <!--script language="javascript">passValue();</script-->

</form>
</body>
</html>