<%@ 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"> </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> - <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> <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> <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> <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> <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> <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> - <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"> </td> <td class="column-input"> </td> <td class="column-input"> </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"> </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"> </td> <td class="column-input"> </td> <td class="column-input"> </td> </tr> </table> </div> <div id="searchinfo"> <span id="recordfound"><script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> : <%=screen.getRecCount()%></span> <span id="pagetag"><script language="JavaScript" type="text/javascript">swapLang("Page");</script> : <%=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"> <%=screen.getString("employeeid") %></td> <td class="column-text"> <%=screen.getString("fullname") %></td> <td class="column-text"> <%=screen.getString("mposition","tdesc") %></td> <td class="column-text left"> <%=screen.getString("hadjposition","old_job") %></td> <td class="column-text left"> <%=screen.getString("MBU1","tdesc") %></td> <td class="column-text left"> <%=screen.getString("MBU2","tdesc") %></td> <td class="column-text left"> <%=screen.getString("MBU3","tdesc") %></td> <td class="column-text left"> <%=screen.getString("hadjposition","adj_date") %></td> <td class="column-text left"> <%=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();%>