<!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.*"%> <%@ page import="org.apache.commons.lang.StringUtils" %> <%@ page import="com.csc.library.utilities.MovementUtils" %> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.utilities.*"%> <jsp:useBean id="task" scope="page" class="com.csc.library.system.Task"/> <% task.setChannel(request, response); UIManager screen=(UIManager) task.process("MultiEntry","PSU130"); MultiLine multi1 = screen.getMultiLine("MEMPL_RESIGN"); CheckNull chkNull = new CheckNull(); String chkclickadd = chkNull.chkNullString(request.getParameter("chkclickadd")); DbInquiry resign = new InitialInquiry(screen.getUProfile()).getDbInquiry("mempl_resign"); resign.setColumn("line_no"); resign.setFilter("employeeid = '"+screen.getRecord().getString("employeeid")+"'"); resign.refresh(); int line_no = resign.recCount(); if(!chkclickadd.equalsIgnoreCase("save")){ multi1.getTable().setFilter("endworkdate >= '"+screen.getRecord().getString("startdate")+"'"); multi1.getTable().refresh(); } multi1.goFirst(); if(multi1.getTable().recCount()>0 && !chkclickadd.equalsIgnoreCase("save")){ chkclickadd = "add"; } //------------------------------------------------------------------------------------------------------------------------------ if(StringUtils.trimToEmpty(request.getParameter("__cmd")).equalsIgnoreCase("save")) { if(screen.getRecord().getConfirmStatus() == 2) { // search after save because record has been clear by system screen.getRecord().set( "employeeid", screen.getDataLabel( "employeeid" ) ); screen.getRecord().set( "companyid", screen.getUProfile().get( "companyid" ) ); screen.getRecord().search(); } else if(screen.getRecord().getConfirmStatus() == -99) { // search child if confirm save multi1.getTable().refreshChild(); } } if(screen.getRecord().getString( "employeeid").length() >0 && multi1.getTable().recCount()==0 && StringUtils.trimToEmpty(request.getParameter("__generate")).equalsIgnoreCase("1") ) { DbRecord rec = screen.getTable("MEMPL_RESIGN").getNewRecord(); rec.set("employeeid", screen.getDataLabel("employeeid")); rec.set("companyid", screen.getDataLabel("companyid")); rec.set("line_no", String.valueOf(line_no+1)); rec.set("resigndate", "1900-01-01"); // for set inputbox value to empty sting rec.set("endworkdate", "1900-01-01"); // for set inputbox value to empty sting // put Transaction Record to table screen.getTable("MEMPL_RESIGN").putNewRecord(rec); //line_no = screen.getTable("MEMPL_RESIGN").getInt(screen.getTable("MEMPL_RESIGN").getMinorKey()); } screen.referLangOn(); DbRecord status = new InitialRecord(screen.getUProfile()).getDbRecord("mempl_status"); status.setColumn("statuscode,statustype"); status.set("statuscode", screen.getDataLabel("status")); status.search(); String statustype = status.getString("statustype"); line_no = screen.getTable("MEMPL_RESIGN").getInt(screen.getTable("MEMPL_RESIGN").getMinorKey()); java.text.DecimalFormat dmfm = new java.text.DecimalFormat("#,###,###,##0.00"); Double total = 0.0; String cal_yyyymmdd = new CscCalendar().getYYYYMMDD(); DbInquiry inq_htr = (DbInquiry) new InitialInquiry(screen.getUProfile()).getDbInquiry("Htraining"); inq_htr.setColumn("*"); inq_htr.referLangOn(); DbInquiry inq_crs = (DbInquiry) new InitialInquiry(screen.getUProfile()).getDbInquiry("Mcourse"); inq_crs.setColumn("*"); inq_crs.referLangOn(); inq_htr.putChild(inq_crs); inq_htr.setFilter("TRAININGID IN (SELECT TRAININGID FROM HTRAINTRNEE WHERE TRAINEEID='"+screen.getDataLabel("employeeid")+"') and crsid in (select crsid from mcourse where '"+cal_yyyymmdd+"' BETWEEN EXPENSES_STARTDATE AND EXPENSES_ENDDATE)"); inq_htr.refresh(); %> <html ng-app="myHR"> <head> <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 type="text/javascript" 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 src="../JS/jquery-2.1.3.min.js" type="text/javascript"></script> <script type="text/javascript" language="javascript" src="../JS/EMPLOYEE.js"></script> <script type="text/javascript" language="javascript" src="../JS/VIEWCALENDAR.js"></script> <script type="text/javascript" language="javascript" src="../JS/ICONSMENU.js"></script> <script type="text/javascript" language="javascript" src="../JS/HOTKEY.js"></script> <script language="javascript">setLang("<%=screen.getUProfile().get("lang")%>");</script> <script language="javascript">getTitleName();</script> <script language="JavaScript" type="text/JavaScript"> function GoSave(){ if(chkResigndate()) { document.cscform.chkclickadd.value = "save"; confirmSave(); } } function GoUpdate(){ if(chkResigndate()) { update(); } } function GoDelete(){ with(document.cscform) { __notdelall.value="true"; edelete(); } } function GoSearch(){ with(document.cscform){ __help.value="__employeeid$"+__employeeid.value; search(); } } function GoResign() { with(document.cscform) { if(__employeeid.value!="") { __generate.value="1"; chkclickadd.value = "add"; search(); } else { alert(MyCode[0]); __employeeid.focus(); __employeeid.select(); } } } function chkResigndate() { with(document.cscform){ var msg = (getLang()=="tha")? "กรุณาระบุวันที่พ้นสภาพให้ถูกต้อง.": "Please input correct resign date." if($('resigndate input').val() === "" || $('resigndate input').val() === "31-12-2100" ) { alert(msg); $('resigndate input').focus().select(); return false; } else if($('endworkdate input').val() === "" || $('endworkdate input').val() === "31-12-2100") { alert(msg); $('endworkdate input').focus().select(); return false; } } return true; } function goHelp(helpName,inputName){ with(document.cscform){ var helpReturn; var fixCon = ""; if(inputName == "__mempl_resign$resignreason$<%=line_no%>" ) { helpReturn = "__mempl_resign$resignreason$<%=line_no%>:resignreasonid,__mempl_resign$status$<%=line_no%>:status,MRESIGNREASON@TDESC"; }else if(inputName == "__mempl_resign$sup_resignreason$<%=line_no%>" ) { helpReturn = "__mempl_resign$sup_resignreason$<%=line_no%>:resignreasonid,MRESIGNREASON@TDESC$1"; }else if(inputName == "__mempl_resign$hr_resignreason$<%=line_no%>" ) { helpReturn = "__mempl_resign$hr_resignreason$<%=line_no%>:resignreasonid,MRESIGNREASON@TDESC$2"; } linkHelp_Return(helpName, helpReturn); } } //------------------------------ null check ---------------------------------------------- function nullCheck(){ for (var i=0;i<document.cscform.length;i++){ if(nullField(i)){ if(((document.cscform.elements[i].value == null) || (document.cscform.elements[i].value == "")) && (document.cscform.elements[i].type != "hidden")){ alert(MyCode[0]); document.cscform.elements[i].focus(); //alert(cscform.elements[i].name); return false; } } } return true; } // write by james function nullField(idx){ with(document.cscform){ var fieldName = new Array(); var returnV=false; if((__notNull.value != "") && (__notNull.value != null)){ fieldName= __notNull.value.split(","); } } for(i=0;i<fieldName.length;i++){ tempValue1="__"+fieldName[i]; tempValue2 = "$" +fieldName[i] +"$"; if( (tempValue1 == document.cscform.elements[idx].name) || // for normal (document.cscform.elements[idx].name.indexOf( tempValue2) >= 0 ) ) // for multi { //alert( document.cscform.elements[idx].name); returnV = true; } } return returnV; } </script> <style type="text/css"><!-- .lable-noRequire label span { visibility:hidden; display: none; } --></style> </head> <body leftmargin="0" topmargin="0"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <form name="cscform" method="post" action="?"> <!-- BEGIN CSC INITIAL ZONE --> <%=screen.InitialVariable()%> <!--- END CSC INITIAL ZONE --> <input type="hidden" name="__cmd" value=""/> <input type="hidden" name="__screen" value="PSU130"/> <input type="hidden" name="__calendar" value=""/> <input type="hidden" name="__notNull" value="<%=screen.getRequire()%><%=screen.getTable("MEMPL_RESIGN").getCurrentRecordManager().listField("require")%>"/> <input type="hidden" name="__help" value=""/> <input type="hidden" name="__gorec" value=""/> <input type="hidden" name="__headMulti" value="PSU130"/> <input type="hidden" name="__childMulti" value="PSU131"/> <input type="hidden" name="__multiTable" value="MEMPL_RESIGN"/> <input type="hidden" name="__notdelall" value=""/> <input type="hidden" name="__ack" value=""/> <input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>"/> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"/> <input type="hidden" name="__maxrec" value=""/> <input type="hidden" name="__referPage" value=""/> <input type="hidden" name="__fixCon" value=""/> <input type="hidden" name="__mempl_resign$line_no$<%=line_no%>" value="<%=line_no%>"/> <input type="hidden" name="__generate" value="0"/> <input type="hidden" name="__emp_position" value="<%=screen.getDataLabel("emp_position") %>"/> <input type="hidden" name="__bu1" value="<%=screen.getDataLabel("bu1") %>"/> <input type="hidden" name="__bu2" value="<%=screen.getDataLabel("bu2") %>"/> <input type="hidden" name="__bu3" value="<%=screen.getDataLabel("bu3") %>"/> <input type="hidden" name="__bu4" value="<%=screen.getDataLabel("bu4") %>"/> <input type="hidden" name="__bu5" value="<%=screen.getDataLabel("bu5") %>"/> <input type="hidden" name="__startdate" value="<%=screen.getDataLabel("startdate") %>"/> <input type="hidden" name="__mempl_resign$status$<%=line_no%>" value="<%=chkNull.chkNullString(request.getParameter("__mempl_resign$status$"+String.valueOf(line_no)),multi1.getDataLabel("mempl_resign", "status"))%>"/> <input type="hidden" name="chkclickadd" value="<%=chkclickadd%>"/> <script language="javascript">initToolTips();</script> <script language="javascript">getInputFormatDate();</script> <script language="javascript"> var swap = new swaplang(); var titlename = swap.swap2String("SW000774"); document.write(Icons("PSU130," +titlename )); </script> <br/> <div align="center"> <table width="640" border="0" align="center" cellpadding="4" cellspacing="0"> <tr> <td class="header">PSU130, <!-- <script language="JavaScript">document.write(titlename);</script> --> <span swlang code="SW000774">Detail of Resign</span> </td> </tr> <tr> <td> <table border="1" align="center" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td> <% screen.referLangOff();%> <table cellspacing="0" cellpadding="0" class="inframe"> <tr> <td colspan="2" class="blankspace"> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("employeeid")%> </td> <td><%=screen.getInput("employeeid")%> <%=screen.getLabel("status")%> <%=screen.getInput("status")%> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("fname")%> </td> <td> <input type="hidden" name="__emp_prefix" value="<%=screen.getDataLabel("emp_prefix")%>"/> <input name="MPREFIX@TDESC" type="text" readonly size="4" value="<%=screen.getDataLabel("mprefix","tdesc")%>"/> <input name="__fname" type="text" readonly size="22" value="<%=screen.getDataLabel("fname")%>"/> <input name="__lname" type="text" readonly size="24" value="<%=screen.getDataLabel("lname")%>"/> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("efname")%> </td> <td> <input name="MPREFIX@EDESC" type="text" readonly size="4" value="<%=screen.getDataLabel("mprefix","edesc")%>"/> <input name="__efname" type="text" readonly size="22" value="<%=screen.getDataLabel("efname")%>"/> <input name="__elname" type="text" readonly size="24" value="<%=screen.getDataLabel("elname")%>"/> </td> </tr> <tr> <td><% screen.referLangOn();%></td> <td> </td> </tr> </table> </td> </tr> </table> </td> </tr> <% if(multi1.getTable().recCount()>0 && (statustype.equalsIgnoreCase("C") || chkclickadd.equalsIgnoreCase("add") || chkclickadd.equalsIgnoreCase("save"))) { %> <tr> <td> <table border="1" align="center" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td> <table cellspacing="0" cellpadding="0" class="inframe"> <tr> <td class="blankspace" colspan="2"> </td> </tr> <% if(inq_htr.recCount()>0){ %> <tr> <td class="" colspan="2" align="right"><font color="red"><%=screen.getUProfile().get("lang").equals("tha")?"*หมายเหตุ : ติดข้อผูกมัด":"*Remark : has bond"%></font></td> </tr> <% } %> <tr> <td class="columnlabel"><%=screen.getLabel("emp_position")%> </td> <td class="columndata"><%=screen.getDataLabel("mposition","tdesc")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("bu1")%> </td> <td class="columndata"><%=screen.getDataLabel("mbu1","tdesc")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("bu2")%> </td> <td class="columndata"><%=screen.getDataLabel("mbu2","tdesc")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("bu3")%> </td> <td class="columndata"><%=screen.getDataLabel("mbu3","tdesc")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("bu4")%> </td> <td class="columndata"><%=screen.getDataLabel("mbu4","tdesc")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("bu5")%> </td> <td class="columndata"><%=screen.getDataLabel("mbu5","tdesc")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("startdate")%> </td> <td class="columndata"><%=("".equalsIgnoreCase(screen.getDataLabel("employeeid"))?"":screen.getDataLabel("startdate")) %></td> </tr> <tr> <td colspan="2" class="blankspace"> </td> </tr> <!--tr> <td class="columnlabel"><%=multi1.getLabel("status")%> </td> <td><%=multi1.getInput("mempl_resign", "status")%></td> </tr--> <tr> <td class="columnlabel"><%=multi1.getLabel("resigndate")%> </td> <td class="columndata resigndate"><%=multi1.getInput("mempl_resign", "resigndate")%> </td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("endworkdate")%> </td> <td class="columndata endworkdate"><%=multi1.getInput("mempl_resign", "endworkdate")%> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("empworkages")%> </td> <td class="columndata"><%=screen.getDataLabel("empworkagesv2u") %></td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("attitude")%> </td> <td><%=multi1.getInput("mempl_resign", "attitude")%></td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("willingly_resign")%> </td> <td><%=multi1.getInput("mempl_resign", "willingly_resign")%></td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("resignreason")%> </td> <td class="columndata"> <%-- <%=multi1.getInput("mempl_resign", "resignreason")%> --%> <input name="__mempl_resign$resignreason$<%=line_no%>" onmouseout="toolTip()" onkeyup="sysIsEdit();" onkeypress="chkSpecialStr(event);" onfocus="this.select();" onblur="trimValue(this);" type="text" size="5" maxLength="5" alt="เหตุผลการลาออก" onmousemver="toolTip('เหตุผลการลาออก')" value="<%=chkNull.chkNullString(screen.getDataLabel("mresignreason", "resignreasonid"))%>"/><%//=screen.getDataLabel("mresignreason", "resignreasonid")%> <a onmouseover="MM_swapImage('__mempl_resign$resignreason$<%=line_no%>_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MRESIGNREASONHELP','__mempl_resign$resignreason$<%=line_no%>');"><img name="__mempl_resign$resignreason$<%=line_no%>_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a> <input type="text" name="MRESIGNREASON@TDESC" readonly size="25" value="<%=screen.getDataLabel("mresignreason", "tdesc")%>"/> </td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("sup_resignreason")%> </td> <td class="columndata"> <%=multi1.getInput("mempl_resign", "sup_resignreason")%> <input type="text" name="MRESIGNREASON@TDESC$1" readonly size="25" value="<%=screen.getDataLabel("v1mresignreason", "tdesc")%>"/> </td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("hr_resignreason")%> </td> <td class="columndata"> <%=multi1.getInput("mempl_resign", "hr_resignreason")%> <input type="text" name="MRESIGNREASON@TDESC$2" readonly size="25" value="<%=screen.getDataLabel("v2mresignreason", "tdesc")%>"/> </td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("other_resignreason")%> </td> <td class="columndata"><%=multi1.getInput("mempl_resign", "other_resignreason")%></td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("strong_point")%> </td> <td class="columndata"><%=multi1.getInput("mempl_resign", "strong_point")%></td> </tr> <tr> <td class="columnlabel"><%=multi1.getLabel("weak_point")%> </td> <td class="columndata"><%=multi1.getInput("mempl_resign", "weak_point")%></td> </tr> <% if(inq_htr.recCount()>0){ %> <tr> <td colspan="2"> <table cellspacing="1" cellpadding="0" class="inframe" border="1"> <tr> <td colspan="5" class="header" swlang code="SW013161">Bond List</td> </tr> <tr> <td class="row3" align="center"><span swlang code="SW000638">Course Name</span></td> <td class="row3" align="center"><span swlang code="SW011878">Amount</span> (<span swlang code="SW000590">Baht</span>)</td> <td class="row3" align="center"><span swlang code="SW012123">Period</span></td> <td class="row3" align="center"><span swlang code="SW002343">Start Date</span></td> <td class="row3" align="center"><span swlang code="SW000023">End Date</span></td> </tr> <% while(inq_htr.next()){ Double expense = chkNull.chkNullStringToDouble(inq_htr.getString("Mcourse","expense")); total += expense; %> <tr> <td class=""><div><%=inq_crs.getString("crsdesc")%></div></td> <td class="" align="center"><div><%=dmfm.format(expense)%></div></td> <td class="" align="center"><div><%=inq_htr.getString("Mcourse","expenses_duration")%> <%=inq_htr.getString("Mcourse","expenses_every")%></div></td> <td class="" align="center"><div><%=new CscCalendar(inq_htr.getString("Mcourse","expenses_startdate")).getDDMMYYYY()%></div></td> <td class="" align="center"><div><%=new CscCalendar(inq_htr.getString("Mcourse","expenses_enddate")).getDDMMYYYY()%></div></td> </tr> <% } %> <tr> <td class="row3" colspan="3" align="right"><span swlang code="SW008898">Total Cost</span></td> <td class="row3" align="center"><%=dmfm.format(total)%></td> <td class="row3" align="center"><span swlang code="SW000590">Baht</span></td> </tr> </table> </td> </tr> <% } %> <tr> <td colspan="2" class="blankspace"> </td> </tr> <tr> <td colspan="2"> <div align="right"> <script language="javascript">printEditCheck('<%=screen.getDataLabel("edit_by")%>','<%=screen.getDataLabel("edit_date")%>','<%=screen.getDataLabel("edit_time")%>','<%=screen.getDataLabel("approve")%>'); </script> </div> </td> </tr> <tr> <td colspan="2" class="blankspace"></td> </tr> </table> </td> </tr> </table> </td> </tr> <% } else if (MovementUtils.checkNewMovement( screen.getUProfile() , screen.getDataLabel( "employeeid" ) ) && (statustype.equalsIgnoreCase("A"))) { %> <tr> <td> <table border="1" align="center" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td> <table cellpadding="0" cellspacing="0" class="inframe" > <tr> <td class="blankspace"> </td> </tr> <tr> <td align="center"> <strong> <span swlang code="SW011952">Press Add Button to continue.</span> </strong> </td> </tr> <tr> <td class="blankspace"></td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013162" onClick="GoResign();">ADD</button> </div> </td> </tr> <tr> <td class="blankspace"></td> </tr> </table> </td> </tr> </table> </td> </tr> <% } else if ( StringUtils.trimToNull(screen.getDataLabel( "employeeid" )) != null ){ %> <tr> <td> <table border="1" align="center" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td> <table cellpadding="0" cellspacing="0" class="inframe" > <tr> <td class="blankspace"></td> </tr> <tr> <td align="center"> <strong> <span swlang code="SW011950">Could not found history.</span> </strong> </td> </tr> <tr> <td class="blankspace"></td> </tr> </table> </td> </tr> </table> </td> </tr> <% } %> <tr> <td class="bottom"></td> </tr> </table> </div> <script language="javascript">setEmpIdformenu(document.cscform.__employeeid.value);</script> <!-- BEGIN CSC ENDING ZONE --> <%=screen.endJSP()%> <!-- END CSC ENDING ZONE --> </form> <% screen.referLangOff();%> </body> </html>