<!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> </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")%> </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> <input type="text" name="__bu1_desc" size="30" readonly > </td> </tr> <tr> <td colspan="1" class="columnlabel"><%=screen.getLabel("bu2")%> </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> <input type="text" name="__bu2_desc" size="30" readonly > </td> </tr> <tr> <td colspan="1" class="columnlabel"><%=screen.getLabel("bu3")%> </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> <input type="text" name="__bu3_desc" size="30" readonly > </td> </tr> <tr> <td colspan="1" class="columnlabel"><%=screen.getLabel("bu4")%> </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> <input type="text" name="__bu4_desc" size="30" readonly > </td> </tr> <tr> <td colspan="1" class="columnlabel"><%=screen.getLabel("bu5")%> </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> <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> </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> <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> </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> </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> </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> </div></td> <td><%=screen.getTagSearchBy()%></td> <td colspan="3"> </tr> <tr> <!-- <td><div align="right"> <script language="javascript">swapLang('Condition');</script> </div></td> <td > <%=screen.getTagConSearch()%></td> --> <td> <div align="right"> <!-- <script language="javascript">swapLang('Key Value');</script> --> <span swlang code="SW000007">Key Value</span> </div></td> <td><input name="__value_conSearch" type="text" size="25" value="" /> <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> </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> </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> </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> </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>