<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>

<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.database.*,com.csc.library.utilities.*,com.csc.library.components.*,com.csc.library.session.*"%>
<jsp:useBean id="MPROBATION_01" class="com.csc.library.system.Task" scope="page" />
<%
	MPROBATION_01.setChannel(request, response);
	HelpEntry screen = (HelpEntry) MPROBATION_01.process("HelpEntry", "MPROBATION_01HELP");
	screen.setMaxLine(20);	
	screen.getInquiry().setFilter("status = 'V'");
	
	//screen.process();
	if(screen==null){
		return;
	}
	//out.println(screen.getUProfile().toString());
	String[][] scc=SystemCode.getContent("REQSTATUS");
 
	String filter = "status in('V') and 1=1 ";

	CheckNull chk2 = new CheckNull(); 

		InitialEnvironment ine = new InitialEnvironment("GLOBAL");

	String email_from = ine.getValue("mailauth-username");;
	

	String bu1 =chk2.chkNullString(request.getParameter("__bu1"));
	String bu2 =chk2.chkNullString(request.getParameter("__bu2"));
	String bu3 =chk2.chkNullString(request.getParameter("__bu3"));
	String bu4 =chk2.chkNullString(request.getParameter("__bu4"));
	String bu5 =chk2.chkNullString(request.getParameter("__bu5"));
	String emp_type =chk2.chkNullString(request.getParameter("__emp_type"));
	String position = chk2.chkNullString(request.getParameter("__position"));
	String start_date_approve = chk2.chkNullString(request.getParameter("__start_date_approve"));
	String end_date_approve = chk2.chkNullString(request.getParameter("__end_date_approve"));
	String value_conSearch = chk2.chkNullString(request.getParameter("__value_conSearch"));
	String searchBy = chk2.chkNullString(request.getParameter("__searchBy"));
	
	 if( !bu1.equals("") ){
		 filter += "and bu1= '"+bu1+"' ";
	}
	if( !bu2.equals("") ){
		 filter += "and bu2 = '"+ bu2+ "' ";
	}
	if( !bu3.equals("") ){
		 filter += "and bu3 = '"+ bu3+ "' ";
	}
	if( !bu4.equals("") ){
		 filter += "and bu4 = '"+ bu4+ "' ";
	}
	
	if( !bu5.equals("") ){
		 filter += "and bu5 = '"+ bu5+ "' ";
	}
	if( !position.equals("") ){
		 filter += "and emp_position = '"+ position+ "' ";
	}
	if( !emp_type.equals("") ){
		filter += "and emp_type = '"+ emp_type+ "' ";
	}
	if( !value_conSearch.equals("") ){
		 filter += "and "+searchBy+" like '%"+value_conSearch+"%'";
	}

	if (!start_date_approve.equals("") && !end_date_approve.equals("")) {
		CscCalendar date_start = new CscCalendar(start_date_approve);
		CscCalendar date_end = new CscCalendar(end_date_approve);
		filter += "and (approve_date between '"+date_start.getYYYYMMDD()+"' and '"+date_end.getYYYYMMDD()+"') ";	
}

	int beginRow=((Integer.parseInt(screen.goPage)-1)*screen.maxLine)+1;
    int endRow=(Integer.parseInt(screen.goPage))*screen.maxLine;
    screen.getInquiry().setBetween(beginRow, endRow);
    screen.getInquiry().clearOldCondition();
	screen.getInquiry().setFilter(filter);
	screen.process();
	
%>


<%!
		private String getAppstatus(String apsassessy,String astid,UProfile screen,String field){
					String result="";
					try{
					String sql="select  *  from tapstran where   apsassessy = '"+apsassessy+"' and astid = '"+astid+"'";
					String dbName = screen.getDbName();
					String tableName = "tapstran";
					DataSet ds = new DataSet(sql,dbName,tableName);
					ds.setFetchAll(false);
					ds.initConnection(screen);
					while(ds.next()){
						result = ds.getString(field);
					}
				}catch(Exception e){ }

				return result;
		
		}

			private String getBossEmail(String empid,String field,UProfile screen){

				String result="";
					try{
					String sql="select b1.employeeid employeeid,b2.employeeid bossid ,m.email email from mempl_box b1 left join mapprove_box box on b1.boxid = box.boxid left join mempl_box b2 on box.upper_boxid0 = b2.boxid left join memployee m on b2.employeeid = m.employeeid where b1.employeeid = '"+empid+"' ";
					String dbName = screen.getDbName();
					String tableName = "mempl_box";
					DataSet ds = new DataSet(sql,dbName,tableName);
					ds.setFetchAll(false);
					ds.initConnection(screen);
					while(ds.next()){
						result = ds.getString(field);
					}
				}catch(Exception e){ }

				return result;

		}
	
%>

<html ng-app="myHR">
<head>
<title><%=screen.getInquiry().getCurrentDbRecord().getDescription()%></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<link type="text/css" rel="stylesheet" href="../CSS/TISCO.css" >
<link href="../CSS/bootstrap.css" rel="stylesheet"  type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet"  type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script language="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 type="text/javascript" src="../JS/DATEINPUT.js"></script>
<script type="text/javascript" src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>


<script language="JavaScript" type="text/JavaScript">



<!--
//-->

function goHelp(helpName,inputName){
	var helpReturn;
	 if(inputName=="__bu1" ){
		helpReturn="__bu1:bu1id,__bu1_desc:tdesc";
	}else if(inputName=="__bu2" ){
		helpReturn="__bu2:bu2id,__bu2_desc:tdesc";
	}else if(inputName=="__bu3" ){
		helpReturn="__bu3:bu3id,__bu3_desc:tdesc";
	}else if(inputName=="__bu4" ){
		helpReturn="__bu4:bu4id,__bu4_desc:tdesc";
	}else if(inputName=="__bu5" ){
		helpReturn="__bu5:bu5id,__bu5_desc:tdesc";
	}else if(inputName=="__position" ){
		helpReturn="__position:positionid,__position_desc:tdesc";
	}

	linkHelp_Return2(helpName, helpReturn, "");
}
function setFilter(){
	with(document.cscform){

	

		if(reqstatus.value!=""){
			__fixCon.value="req_status='"+reqstatus.value+"' "
		}
		
		else
		__fixCon.value="";
		__cmd.value="search";	
	//	__fixCon.value = filter;
		submit();
	}
}

function goProcess(send_to,send_from,employee_req){
		var pam="MPROBATION_02.jsp?__mail_to="+send_to+"&__mail_from="+send_from+"&__employee_req="+employee_req+"&__astid_req=AP80";	
		window.open(pam,"","left=200,top=150,width=1000,height=550,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}


function GoSearch(){
		search();
	}
</script>


</head>
<%
		String helpReturn="";
		if(request.getParameter("__helpReturn")!=null){
			helpReturn=request.getParameter("__helpReturn");
		}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" >


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

<%=screen.InitialVariable()%>

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

<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="MPROBATION_01">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__requestid" value="">
<input type="hidden" name="__calendar"  value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<script language="javascript">getInputFormatDate();</script> 


 <br>
 <div align="center">
 <table height="" align="center" cellpadding="0" cellspacing="0" >
    <tr bgcolor="#3366CC">
      <td  height="20" class="header">MPROBATION_01, <!-- <script language="javaScript">swapLang('Employees Due To Probation')</script> -->
	  <span swlang code="SW005514">Employees Due To Probation</span>&nbsp;</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 colspan="1" class="columnlabel"><%=screen.getLabel("bu1")%>&nbsp;</td>
					<td colspan="3"><input type="text" name="__bu1" size="10" value="">
						<a href="javascript:goHelp('MBU1HELP','__bu1')"> <img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>&nbsp;<input type="text" name="__bu1_desc" size="30" readonly > </td>
                </tr>

				<tr> 
					<td colspan="1" class="columnlabel"><%=screen.getLabel("bu2")%>&nbsp;</td>
					<td colspan="3"><input type="text" name="__bu2" size="10" value="">
						<a href="javascript:goHelp('MBU2HELP','__bu2')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>&nbsp;<input type="text" name="__bu2_desc" size="30" readonly > </td>
                </tr>

				<tr> 
					<td colspan="1" class="columnlabel"><%=screen.getLabel("bu3")%>&nbsp;</td>
					<td colspan="3"><input type="text" name="__bu3" size="10" value="">
						<a href="javascript:goHelp('MBU3HELP','__bu3')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>&nbsp;<input type="text" name="__bu3_desc" size="30" readonly > </td>
                </tr>

				<tr> 
					<td colspan="1" class="columnlabel"><%=screen.getLabel("bu4")%>&nbsp;</td>
					<td colspan="3"><input type="text" name="__bu4" size="10" value="">
						<a href="javascript:goHelp('MBU4HELP','__bu4')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>&nbsp;<input type="text" name="__bu4_desc" size="30" readonly > </td>
                </tr>

				<tr> 
					<td colspan="1" class="columnlabel"><%=screen.getLabel("bu5")%>&nbsp;</td>
					<td colspan="3"><input type="text" name="__bu5" size="10" value="">
						<a href="javascript:goHelp('MBU5HELP','__bu5')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>&nbsp;<input type="text" name="__bu5_desc" size="30" readonly > </td>
                </tr>

				<tr> 
                 <td width="15%"> <div align="right">
                      <!-- <script language="javascript">swapLang('Position');</script> -->
                      <span swlang code="SW000308">Position</span>&nbsp; </div></td>
                  <td colspan="3"><input type="text" name="__position" size="10" value="">
				  <a href="javascript:goHelp('MPOSITIONHELP','__position')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>&nbsp;
				 <input type="text" name="__position_desc" size="30" readonly > </td>
                </tr>

				<tr> 
                 <td width="15%"> <div align="right">
                      <!-- <script language="javascript">swapLang('Date');</script> -->
                     <span swlang code="SW000002">Date</span> &nbsp; </div></td>
                  <td colspan="3">

					 <input type="text" name="__start_date_approve" size="10" maxlength="10" value="<%=start_date_approve%>" onFocus="this.select();" onKeyUp="formatDate(this);" onBlur="" onKeyPress="chkIntegerOfDate(this.value);" />
                      <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image111','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__start_date_approve')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image111" width="20" height="20" border="0" align="absmiddle" id="Image111"></a>-
                      
					<input type="text" name="__end_date_approve" size="10" maxlength="10" value="<%=end_date_approve%>" onFocus="this.select();" onKeyUp="formatDate(this);" onBlur="" onKeyPress="chkIntegerOfDate(this.value);" />
                      <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image111','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__end_date_approve')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image111" width="20" height="20" border="0" align="absmiddle" id="Image111"></a>


				</td>
                </tr>
				<%
				
								ListBox listbox_type = new ListBox();
										listbox_type.setUProfile(screen.getUProfile());	
										listbox_type.setName("emp_type");
										//listbox_type.setonChange("setDisableField('ta_no');clearText();");
										listbox_type.setValidCode("EMPTYPE");
				%>
				<tr> 
                 <td width="15%"> <div align="right">
                      <!-- <script language="javascript">swapLang('Employee Type');</script> -->
                      <span swlang code="SW000130">Employee Type</span>&nbsp; </div></td>
                  <td colspan="3"><%=listbox_type.process()%> </td>
                </tr>

		
                <tr> 
                  <td width="15%"> <div align="right">
                      <!-- <script language="javascript">swapLang('Order By');</script> -->
                      <span swlang code="SW000004">Order By</span>&nbsp; </div></td>
                  <td><%=screen.getTagOrder()%></td>
				   <td colspan="3">
				   </tr>
				   <tr>
                  <td width="20%"> <div align="right">
                      <!-- <script language="javascript">swapLang('Search By');</script> -->
					  <span swlang code="SW000005">Search By</span>&nbsp;</div></td>
                  <td><%=screen.getTagSearchBy()%></td>
				   <td colspan="3">
                </tr>
                <tr> 
                  <!-- <td><div align="right">
                      <script language="javascript">swapLang('Condition');</script>
                      &nbsp; </div></td>
                  <td > <%=screen.getTagConSearch()%></td> -->
            <td> <div align="right">
                      <!-- <script language="javascript">swapLang('Key Value');</script> -->
                      <span swlang code="SW000007">Key Value</span> &nbsp;</div></td>
                  <td><input name="__value_conSearch" type="text"  size="25" value="" />
				  &nbsp;
										<button type="button" class="btn btn-primary width100" swlang code="SW003537" onClick="search();">search</button></td>
                 <td colspan="3"></tr>
              <!-- <tr>
					<td><div align="right"><script language="javascript" type="text/javascript">swapLang('Word_in_Employee_Code')</script>&nbsp;</div></td>
					<td ><input name="__employeeid" type="text" size="15" value="" /></td>
					<td colspan="2"></td>
              </tr>
				
				 <tr>
                <td><div align="right"><script language="javascript" type="text/javascript">swapLang('Word_in_Name')</script>&nbsp;</div></td>
                <td><input name="__fname" type="text" size="25" value="" /></td>
                <td><div align="right"><script language="javascript" type="text/javascript">swapLang('Word_in_Surname')</script>&nbsp;</div></td>
                <td nowrap="nowrap" class="column-input"><input name="__lname" type="text" size="25" value="" />
                  <a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" alt="" width="73" height="23" border="0" align="absmiddle" /></a></td>
              </tr> 
			  <tr>
                <td><div align="right"><script language="javascript" type="text/javascript">swapLang("Order By");</script>&nbsp;</div></td>
                <td colspan="3"><%=screen.getTagOrder()%></td>
              </tr>-->
			  

               <tr>
	                  <td colspan="4"><div align="right"><%=screen.getPageTag()%></div></td>
                </tr>
              </table></td>
          </tr>
        </table></td>
		  </tr>
		  <tr>
		  <td>
		  <br>	
		  <table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe tablewithborder">
	<tr >
			  <td width="6%" nowrap  class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Employee Code')</script> -->
			  <span swlang code="SW011939">Employee Code</span></div></td>
			  <td width="15%" nowrap  class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Name_Surname')</script> -->
			  <span swlang code="SW007745">Name Surname</span></div></td>
			  <td width="12%"  nowrap class="title1"><div align="center"><%=screen.getLabel("bu1")%></div></td>
			  <td width="12%"  nowrap class="title1"><div align="center"><%=screen.getLabel("bu2")%></div></td>
			  <td width="12%"  nowrap class="title1"><div align="center"><%=screen.getLabel("bu3")%></div></td>
			  <td width="12%"  nowrap class="title1"><div align="center"><%=screen.getLabel("bu4")%></div></td>
			  <td width="12%"  nowrap class="title1"><div align="center"><%=screen.getLabel("bu5")%></div></td>
			  <td width="15%"  nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Position')</script> -->
			  <span swlang code="SW000308">Position</span></div></td>
			  <td width="20%"  nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Employee StartDate')</script> -->
			  <span swlang code="SW005472">Employee StartDate</span></div></td>
			  <td width="20%"  nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Probation Date')</script> -->
			  <span swlang code="SW005473">Probation Date</span></div></td>
			  <td width="20%"  nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Approve Date')</script> -->
			  <span swlang code="SW011065">Disapprove date</span></div></td>
			  <td width="9%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Approve Employee')</script> -->
			  <span swlang code="SW005475">Approve Employee</span> </div></td>
		  </tr>
		   <% 
					CheckNull chk = new CheckNull();
					while(screen.nextRec()){ 
						if(screen.checkLinePage()){   
							screen.referLangOn();
						
			%>
			  <tr >
			  <td width="6%" nowrap  class=""><div align="center"><%=screen.getString("employeeid")%></div></td>
			  <td width="15%" nowrap  class=""><div align="center"><%=screen.getString("fullname")%></div></td>
			  <td width="12%"  nowrap class=""><div align="center"><%=screen.getString("mbu1","tdesc")%></div></td>
			  <td width="12%" nowrap  class=""><div align="center"><%=screen.getString("mbu2","tdesc")%></div></td>
			  <td width="12%"  nowrap class=""><div align="center"><%=screen.getString("mbu3","tdesc")%></div></td>
			  <td width="12%"  nowrap class=""><div align="center"><%=screen.getString("mbu4","tdesc")%></div></td>
			  <td width="12%" nowrap class=""><div align="center"><%=screen.getString("mbu5","tdesc")%></div></td>
			  <td width="15%" nowrap class=""><div align="center"><%=screen.getString("mposition","tdesc")%></div></td>
			  <td width="20%"  nowrap class=""><div align="center"><%=screen.getString("startdate")%></div></td>
			  <td width="20%"  nowrap class=""><div align="center"><%=screen.getString("prodate")%></div></td>
			  <td width="20%"  nowrap class=""><div align="center"><%=screen.getString("approve_date")%></div></td>

			 <% 	String apsid=  this.getAppstatus(screen.getString("employeeid"),"AP80",screen.getUProfile(),"apsid"); %>

			<%if(apsid.equals("")){%>
			  <td width="9%" nowrap class=""><div align="center"><a href="javascript:goProcess('<%=this.getBossEmail(screen.getString("employeeid"),"email",screen.getUProfile())%>','<%=email_from%>','<%=screen.getString("employeeid")%>');"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/EDIT20.gif" border="0"/></a></div></td>
			<%}else{%>
				  <td width="9%" nowrap class=""><div align="center">-</div></td>

				<%}%>
		  </tr>
		  <%
						screen.referLangOff();
				}
				 if(screen.outLinePage()){ break; }
				   }%>
		  </table>
		  </td>
		  </tr>
		  <tr><td >
		  </td></tr>
		  <tr><td class="bottom">
		  </td></tr>
  
  </table>
</div>
</form>
</body>
</html>