<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ 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.*"  %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page"/>
<jsp:setProperty name="EMV" property="appname" value="empview" />
<%
	EMV.setChannel(request, response);
	HelpEntry screen = (HelpEntry) EMV.process("HelpEntry","PRU170");
	CheckNull chk = new CheckNull(); 

	CscCalendar cscdate = new CscCalendar();
	//cscdate.decMonth(1);
	String filter = chk.chkNullString(request.getParameter("__fixCon"));
	if(chk.chkNullString(request.getParameter("__cmd2")).equals("searchChiled")&&!chk.chkNullString(request.getParameter("__fixCon2")).equals("")){
		 filter = chk.chkNullString(request.getParameter("__fixCon2"));
		 filter = "employeeid in (select employeeid from hadjposition where "+filter+")";
	}else{
		filter += filter.equals("")?"":" AND ";
		filter += " employeeid in (select employeeid from hadjposition where adj_date like '"+cscdate.getYear()+"-"+cscdate.getMM()+"%') AND adj_date like '"+cscdate.getYear()+"-"+cscdate.getMM()+"%'";
	}
	screen.getInquiry().setFilter(filter);
	//out.print("filter :::> "+filter);
	screen.process();
	screen.referLangOff();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/template-emv-main.dwt.jsp" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Employee View</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- InstanceBeginEditable name="head" -->
<!-- Begin CSS Links -->
<link rel="stylesheet" type="text/css" href="../CSS/DDMENU.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_DEFAULT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT_TWO.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css" />
<!-- End CSS Links -->
<!-- Begin Scripts -->
<script language="JavaScript"  type="text/javascript" src="../JS/EVENTS.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/UTILITIES.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/ACTIVE_OBJECT.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/DDMENU.js"></script>
<!--[if lt IE 7]><script language="JavaScript" type="text/javascript" src="../JS/IEHOVER-FIX.js"></script><![endif]-->
<script language="JavaScript"  type="text/javascript" src="../JS/SCREEN.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/DATEINPUT.js"></script>
<script language="JavaScript" type="text/javascript">
	setLang("<%=screen.getUProfile().get("lang")%>");
	//setPageTitle(swap2String("Policy/Regulation/Rule"));
	function goHelp(helpName,inputName){
		var helpReturn;
		var fcon = "";
		if(inputName=="__employeeid1" ){
			helpReturn="__employeeid1:employeeid";
        }else if(inputName=="__employeeid2" ){
			helpReturn="__employeeid2:employeeid";
		}else if(inputName=="__position" ){
			helpReturn="__position:positionid,__positiondesc:tdesc";
		}else if(inputName=="__workarea" ){
			helpReturn="__workarea:workareaid,__workareadesc:tdesc";
		}else if(inputName=="__groupemp" ){
			helpReturn="__groupemp:groupid,__groupempdesc:tdesc";
		}else if(inputName=="__bu1" ){
			helpReturn="__bu1:bu1id,__bu1desc:tdesc";
		}else if(inputName=="__bu2" ){
			helpReturn="__bu2:bu2id,__bu2desc:tdesc";
		}
		linkHelp_Return(helpName,helpReturn);
	}

	function linkHelp_Return(help,input, fixCon){
		with(document.cscform){
			var nInput = input;
			var tmp = __fixCon.value;
			__fixCon.value = "";
			var filter = fixCon || __fixCon.value;
			if(input.indexOf(":")>0){
				nInput=input.substring(0,input.indexOf(":"));
			}
			obj = eval("document.cscform."+nInput);
			if((obj=="")||(obj.value=="")){
				var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off";
			}else{
				var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"+"&__valueSearch="+obj.value;
			}
			//var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off";
			win = window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
			if(window.focus){win.focus();}
			__fixCon.value = tmp;
		}
	} 

	ThaiCode[202] = "กรูณาเลือกเงื่อนไขในการค้นหา";
	EngCode[202] = "Please select condition for search.";

	setCode();

	function GoSearch(){
		with(document.cscform){
		if(setCondition()){
			search();
		}else{
				alert(MyCode[202]);
			__chkemployee.focus();
		}
		}
	}
	function setCondition(){
		var tmp = "";
		with(document.cscform){
			if(__chkname.checked==true || __chksurname.checked==true || __chkemployee.checked==true || __chkposition.checked==true || __chkworkarea.checked==true || __chkgroup.checked==true || __chkbu1.checked==true || __chkbu2.checked==true || __chkemp_type.checked==true || __chkadj_date.checked==true){

				if(__chkname.checked && __name.value!=""){
					tmp += "( fname like '%"+__name.value+"%') or ( efname like '%"+__name.value+"%')";
				}

				if(__chksurname.checked && __surname.value!=""){
					tmp += "( lname like '%"+__surname.value+"%') or ( elname like '%"+__surname.value+"%')";
				}

				if(__chkemployee.checked && __employeeid1.value!=""&&__employeeid2.value!=""){
					tmp += "(EMPLOYEEID between  '"+__employeeid1.value+"'  and  '"+__employeeid2.value+"')";
				}

				if(__chkposition.checked && __position.value!=""&&__positiondesc.value!=""){
					tmp += "( emp_position = '"+__position.value+"')";
				}
			
				if(__chkworkarea.checked && __workarea.value!=""&&__workareadesc.value!=""){
					tmp += "( WORKAREA = '"+__workarea.value+"')";
				}
				if(__chkgroup.checked && __groupemp.value!=""){
					tmp += (tmp!="")?" and ":"";
					tmp += "( groupid = '"+__groupemp.value+"')";
				}
				if(__chkbu1.checked && __bu1.value!=""){
					tmp += (tmp!="")?" and ":"";
					tmp += "( bu1 = '"+__bu1.value+"')";
				}
				if(__chkbu2.checked && __bu2.value!=""){
					tmp += (tmp!="")?" and ":"";
					tmp += "( bu2 = '"+__bu2.value+"')";
				}
				if(__chkemp_type.checked && __emp_type.value!=""){
					tmp += (tmp!="")?" and ":"";
					tmp += "( emp_type = '"+__emp_type.value+"')";
				}
				__fixCon.value = tmp;
				__cmd2.value = "";

				if(__chkadj_date.checked && __dateadj1.value!=""&&__dateadj2.value!=""){
					var tmp2 = (tmp!="")?tmp+" and ":"";
					tmp2 += " adj_date BETWEEN '"+replaceMyDate(__dateadj1.value)+"' AND '"+replaceMyDate(__dateadj2.value)+"' ";
					__cmd2.value = "searchChiled";
					__fixCon.value = "";
					__fixCon2.value = tmp2;
				}
				
					return true;
			}else{
				return false;
			}
			//alert(tmp);
		
		}
	}
	function replaceMyDate(date){
		var tmp_date = date;
		var tmp = tmp_date.split("-");
		if(tmp.length==3){
			return tmp[2]+"-"+tmp[1]+"-"+tmp[0];
		}
	}
</script>
<style type="text/css">
#header {
 	background: #FFFFFF ;
}
</style>
<!-- End Scripts -->
<!-- Begin Head -->
<!-- End Head -->
<!-- InstanceEndEditable -->
</head>
<body>
<div id="wrapper">
  <div id="header"><!-- InstanceBeginEditable name="header" -->
    <jsp:include page="EMV_HEADER.jsp" flush="true" />
    <!-- InstanceEndEditable -->  </div>
  <div id="topnav"><!-- InstanceBeginEditable name="top_navigation" -->
    <jsp:include page="EMV_TOPMENU.jsp" flush="true" />
    <!-- InstanceEndEditable -->  </div>
  <div id="container">
    
    <div id="content"><!-- InstanceBeginEditable name="main_content" -->
      <!-- Begin Main Content -->
      <jsp:include page="EMV_HELPBAR.jsp" flush="true" />
      <div class="content">
        <form name="cscform" method="post" action="?">
          <%=screen.InitialVariable()%>
          <input type="hidden" name="__screen" value="REV014">
          <input type="hidden" name="__cmd" value="">
          <input type="hidden" name="__calendar">
          <input type="hidden" name="__currentDate" value="<%=new CscCalendar().getEngYYYY()%>">
          <input type="hidden" name="__cmd2" value="<%=chk.chkNullString( request.getParameter("__cmd2")) %>">
          <input type="hidden" name="__help" value="">
          <input type="hidden" name="__goPage" value="">
          <input type="hidden" name="__helpName" value="">
          <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
          <input type="hidden" name="__fixCon" value="<%=chk.chkNullString( request.getParameter("__fixCon")) %>">
          <input type="hidden" name="__fixCon2" value="<%=chk.chkNullString( request.getParameter("__fixCon2")) %>">
          <input type="hidden" name="__orderBy" value="">
          <input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
          <input type="hidden" name="__announce_start" value="">
          <input type="hidden" name="__announce_end" value="">
          <script language="javascript">getInputFormatDate();</script>
          
          <div class="box-search-condition">
            <div class="content-title">
              <script type="text/javascript" language="JavaScript">swapLang("Search Condition")</script>
            </div>
            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-search-condition">
            <col width="155"/>
            <col />
              <tr>
                <td colspan="3" class="column-label">&nbsp;</td>
              </tr>
			    <tr>
			  <td class="column-label"><input type="checkbox" name="__chkemployee"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("EmployeeID")</script></td>
                <td class="column-input"><input name="__employeeid1" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('EMPLOYEEHELP','__employeeid1');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>&nbsp;-&nbsp;&nbsp;<input name="__employeeid2" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('EMPLOYEEHELP','__employeeid2');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>
                 </td>
				</tr>
				<tr>
			  <td class="column-label"><input type="checkbox" name="__chkname"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Name")</script></td>
                <td class="column-input"><input name="__name" type="text" size="15" maxlength="15" value=""></td>
				</tr>
              <tr>
			  <td class="column-label"><input type="checkbox" name="__chksurname"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Surname")</script></td>
                <td class="column-input"><input name="__surname" type="text" size="15" maxlength="15" value=""></td>
				</tr>
              <tr>
			  <td class="column-label"><input type="checkbox" name="__chkposition"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Code positions")</script></td>
                <td class="column-input"><input name="__position" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('MPOSITIONHELP','__position');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>&nbsp;&nbsp;&nbsp;
                  <input name="__positiondesc" type="text" size="50" maxlength="50" value="">
				</td>
              
              </tr>
              <tr>
			  <td class="column-label"><input type="checkbox" name="__chkworkarea"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Workarea ID")</script></td>
                <td class="column-input"><input name="__workarea" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('MWORKAREAHELP','__workarea');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>&nbsp;&nbsp;&nbsp;
                  <input name="__workareadesc" type="text" size="50" maxlength="50" value="">
				</td>
				
              </tr>
			  <tr>
			  <td class="column-label"><input type="checkbox" name="__chkgroup"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Subordinate Group")</script></td>
                <td class="column-input"><input name="__groupemp" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('MGROUPHELP','__groupemp');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>&nbsp;&nbsp;&nbsp;
                  <input name="__groupempdesc" type="text" size="50" maxlength="50" value="">
				</td>
				
              </tr>
			  <tr>
			  <td class="column-label"><input type="checkbox" name="__chkbu1"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Business Unit 1")</script></td>
                <td class="column-input"><input name="__bu1" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('MBU1HELP','__bu1');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>&nbsp;&nbsp;&nbsp;
                  <input name="__bu1desc" type="text" size="50" maxlength="50" value="">
				</td>
				
              </tr>
			  <tr>
			  <td class="column-label"><input type="checkbox" name="__chkbu2"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Business Unit 2")</script></td>
                <td class="column-input"><input name="__bu2" type="text" size="10" maxlength="10" value="">
                  <a href="javascript: goHelp('MBU2HELP','__bu2');" ><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="search" width="20" height="20" border="0" align="top"></a>&nbsp;&nbsp;&nbsp;
                  <input name="__bu2desc" type="text" size="50" maxlength="50" value="">
				</td>
				
              </tr>
			  <tr>
			  <td class="column-label"><input type="checkbox" name="__chkemp_type"></td>
			  <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Emp Type")</script></td>
			  <td class="column-input"><%=screen.getInput("emp_type") %></td>
			  
			  </tr>
			  <tr>
			  <td class="column-label"><input type="checkbox" name="__chkadj_date"></td>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Between Date")</script></td>
                <td class="column-input">
					<input type='text' Name='__dateadj1' size='10' maxlength='10' value='' onkeypress="chkIntegerOfDate(this.value);" onKeyUp="formatDate(this);" onBlur="chkInputDate2(this,__dateadj2);" onFocus="this.select();"> 
					<a href="javascript:viewCal('__dateadj1');"><img src="../IMAGES/EMPVIEW/ICON_CALENDAR.gif" alt="Calendar" width="20" height="20" border="0" align="top"  ></a>
					&nbsp;-&nbsp;
					<input type='text' Name='__dateadj2' size='10' maxlength='10' value='' onkeypress="chkIntegerOfDate(this.value);" onKeyUp="sysIsEdit();formatDate(this);" onBlur="chkInputDate2(__dateadj1,this);" onFocus="this.select();"> 
					<a href="javascript:viewCal('__dateadj2');"><img src="../IMAGES/EMPVIEW/ICON_CALENDAR.gif" alt="Calendar" width="20" height="20" border="0" align="top"  ></a>
				</td>
				
              </tr>
			  <!--tr>
                <td class="column-label">&nbsp;</td>
                <td class="column-input">&nbsp;</td>
				 <td class="column-input">&nbsp; </td>
              </tr>
                <tr>
                <td class="column-label"><script language="javascript">swapLang('Search_By');</script></td>
                <td class="column-input" colspan="2"><%=screen.getTagSearchBy()%></td>
              </tr>
               <tr>
                <td class="column-label">&nbsp;</td>
                <td class="column-input" colspan="2"><%=screen.getTagValueSearch()%> <a href="javascript:searchH();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a><BR><BR></td>
              </tr-->
              <tr>
                <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Order By");</script></td>
                <td class="column-input" colspan="2"><%=screen.getTagOrder()%><a href="javascript:GoSearch();"><img src="../IMAGES/EMPVIEW/BUTTON/SEARCH.gif" alt="Search" width="60" height="23" border="0" align="top" /></a></td>
              </tr>
              <tr>
                <td class="column-label">&nbsp;</td>
                <td class="column-input">&nbsp;</td>
				 <td class="column-input">&nbsp;</td>
              </tr>
            </table>
          </div>
          <div id="searchinfo">
				<span id="recordfound"><script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> :&nbsp;&nbsp;<%=screen.getRecCount()%></span>
				<span id="pagetag"><script language="JavaScript" type="text/javascript">swapLang("Page");</script> :&nbsp;&nbsp;<%=screen.getPageTag()%></span>
				<div class="clear"></div>
		  </div>
          <div class="content-box">
            <div class="content-header">
              <h2><script type="text/javascript">swapLang("POSITION CHANGE");</script></h2>
            </div>
            <div class="content-body">
			<table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-list">
					<tr>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("employeeid") %></td>
						<td nowrap width="15%"  class="column-header left"><%=screen.getLabel("fullname") %></td>
						<td nowrap width="15%"  class="column-header left"><%=screen.getLabel("mposition","tdesc") %></td>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("hadjposition","old_job") %></td>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("MBU1","tdesc") %></td>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("MBU2","tdesc") %></td>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("MBU3","tdesc") %></td>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("hadjposition","adj_date") %></td>
						<td nowrap width="10%"  class="column-header"><%=screen.getLabel("hadjposition","eff_date") %></td>
					  </tr>
				 <%	
						
						screen.referLangOn();
						while(screen.nextRec()){
							if(screen.checkLinePage()){   
				%>   
						<tr>
							<td class="column-text left">&nbsp;<%=screen.getString("employeeid") %></td>
							<td class="column-text">&nbsp;<%=screen.getString("fullname") %></td>
							<td class="column-text">&nbsp;<%=screen.getString("mposition","tdesc") %></td>
							<td class="column-text left">&nbsp;<%=screen.getString("hadjposition","old_job") %></td>
							<td class="column-text left">&nbsp;<%=screen.getString("MBU1","tdesc") %></td>
							<td class="column-text left">&nbsp;<%=screen.getString("MBU2","tdesc") %></td>
							<td class="column-text left">&nbsp;<%=screen.getString("MBU3","tdesc") %></td>
							<td class="column-text left">&nbsp;<%=screen.getString("hadjposition","adj_date") %></td>
							<td class="column-text left">&nbsp;<%=screen.getString("hadjposition","eff_date") %></td>
						</tr>
				 <%	
							}
							if(screen.outLinePage()){ 
								break;
							}
						 }
						 screen.referLangOff();
				%>      
			</table>
			<!-- end content-body -->
			</div>
            <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>
          </div>
          
          
        </form>
      </div>
      <!-- End Main Content -->
      <!-- InstanceEndEditable -->    </div>
  </div>
  <div id="footer"><!-- InstanceBeginEditable name="footer" -->
    <jsp:include page="EMV_FOOTER.jsp" flush="true" />
    <!-- InstanceEndEditable -->  </div>
</div>
</body>
<!-- InstanceEnd --></html>
<% screen.referLangOff();%>