<!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.utilities.*,com.csc.library.report.ReportUDF"%> <%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <jsp:useBean id="PSU115_STD" class="com.csc.library.system.Task" scope="page"/> <% CheckNull chk=new CheckNull(); PSU115_STD.setChannel(request,response); HelpEntry screen = (HelpEntry) PSU115_STD.process("HelpEntry","MEMPLOYEEHELP"); ReportUDF reportUDF = new ReportUDF(); String employeeid = chk.chkNullString(request.getParameter("__employeeid")); String condition = chk.chkNullString(request.getParameter("__condition"),""); String educindex = chk.chkNullString(request.getParameter("__educ_index"),""); String deval = chk.chkNullString(request.getParameter("__deletevalue")); screen.getInquiry().setFilter("employeeid = '"+employeeid+"'"); screen.process(); screen.nextRec(); if(!deval.equals("")){ String[] array = deval.split(","); for (String eduval:array){ DbRecord rec = new InitialRecord(screen.getUProfile()).getDbRecord("MEMPL_EDUCATE"); rec.set("employeeid",employeeid); rec.set("COMPANYID",screen.getUProfile().get("companyid")); rec.set("EDUC_INDEX",eduval); rec.delete(); } } %> <html ng-app="myHR"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <script type='text/javascript' src='../JS/SCREEN.js'></script> <script type="text/javascript" src="../JS/jquery-1.11.1.min.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/ICONSMENU.js'></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" > function GoSave(){confirmSave();} function GoUpdate(){update();} function GoDelete(){alert(MyCode[150]); //edelete(); } function GoSearch(){ search(); } function addMulti(){ if(document.cscform.__employeeid.value==""){ alert(MyCode[0]); document.cscform.__employeeid.focus(); }else{ with(document.cscform){ window.open(__childMulti.value+".jsp?__cmd=&__gorec=&__ack=add"+ "&__RecNo="+__maxrec.value+ "&__employeeid="+__employeeid.value+ "&__headMulti="+__screen.value+"&__companyid="+__companyid.value,"Expertise","left=150,top=20,width=700,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } } function deleteMulti(){ with(document.cscform){ //bCon=confirm("ต้องการลบข้อมูลหรือไม่ ?"); bCon=confirm(MyCode[4]); if (bCon===true){ __deletevalue.value = getCheckBox(); var swap = new swaplang(); var titlename = swap.swap2String("SW012001"); alert(titlename); submit(); } } } function getCheckBox(){ var value = ""; $(".del_list").each(function(){ if($(this).prop("checked")){ value = chkText(value); value += $(this).val(); } }); return value; } function chkText(str){ if(str.length > 0){ str += ","; } return str; } function checkAll(){ with(document.cscform){ for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox") elements[i].checked=true; }//end for }//end with }//end function function decheckAll(){ with(document.cscform){ for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox") elements[i].checked=false; }//end for }//end with }//end function function childMulti(record){ with(document.cscform){ window.open(__childMulti.value+".jsp?__cmd=&__gorec="+record+ "&__ack=edit&__employeeid="+__employeeid.value+ "&__headMulti="+__headMulti.value+ "&__companyid="+__companyid.value+ "&__educ_index="+record,"Expertise","left=150,top=20,width=700,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function goHelp(helpName,inputName){ var helpReturn; var fixCon = ""; if(inputName=="__employeeid" ) helpReturn="__employeeid:employeeid"; linkHelp_Return(helpName,helpReturn,fixCon); } function postReturn(){ with(document.cscform){ submit(); } } </script> </head> <body leftmargin="0" topmargin="0" onload="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP24.gif','../IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/HELP_SWAP24.gif','../IMAGES/BUTTON/SWAP/NEW_SWAP24.gif','../IMAGES/BUTTON/SWAP/EDIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/DEL_SWAP24.gif','../IMAGES/BUTTON/SWAP/PROCESS_SWAP24.gif')"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="?"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden"name="__screen" value="PSU115"> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__deletevalue" value=""> <input type="hidden" name="__cmd" value=""> <input name="__notdelall" type="hidden" value="true"> <input type="hidden" name="__childMulti" value="PSU115_ESTD"> <input name="__headMulti" type="hidden" value="PSU115"> <input type="hidden" name="__gorec" value=""> <input type="hidden" name="__maxrec" value=""> <input type="hidden" name="__multiTable" value="MEMPL_EDUCATE"> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <!-- <input name="__notNull" type="hidden" value="<%//=screen.getRequire()%>"> --> <input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>"> <input name="__companyid" type="hidden" value="<%=screen.getUProfile().get("companyid")%>"> <script language="JavaScript" src="../JS/HOTKEY.js"></script> <br> <div align="center"> <table cellpadding="0" cellspacing="0" class="large"> <tr > <td class="header">PSU115_STD, <span swlang code="SW000202">Educational Background</span> </td> </tr> <tr> <td> <br> <table border="1" cellpadding="0" cellspacing="0" class="largest" align="center"> <tr> <td><table cellspacing="0" cellpadding="0" class="inframe"> <tr> <td ></td> <td ></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("MPREFIX","PREFIXID")%>"> <input name="MPREFIX@TDESC" type="text" readonly size="10" value="<%=screen.getDataLabel("MPREFIX","TDESC")%>"> <input name="__fname" type="text" readonly size="20" value="<%=screen.getDataLabel("fname")%>"> <input name="__lname" type="text" readonly size="20" value="<%=screen.getDataLabel("lname")%>"> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("efname")%> </td> <td><input name="MPREFIX@EDESC" type="text" readonly size="10" value="<%=screen.getDataLabel("MPREFIX","EDESC")%>"> <input name="__efname" type="text" readonly size="20" value="<%=screen.getDataLabel("efname")%>"> <input name="__elname" type="text" readonly size="20" value="<%=screen.getDataLabel("elname")%> "> </td> </tr> <tr> <td > </td> <td > </td> </tr> </table></td> </tr> </table> <br> <table border="0" cellpadding="0" cellspacing="1"class="inframe" align="center"> <tr> <td> <table border="0" cellpadding="0" cellspacing="1" bgcolor="#333333" class="inframe" > <tr> <td class="row3" ><div align="center"> <span swlang code="SW000289">Del</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW000193">Seq</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW005741">Degree</span></div></td> <!-- ADD 20070807 --> <td class="row3" > <div align="center"> <span swlang code="SW005172">Educational</span></div></td> <!-- End_ADD 20070807 --> <td class="row3" > <div align="center"> <span swlang code="SW002141">Institute</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW002142">Faculty</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW011915">Major</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW008762">Start</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW000210">Finish</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW002145">GPA</span></div></td> <td class="row3" > <div align="center"> <span swlang code="SW009263">Reference</span></div></td> </tr> <% int line_num = 1; String sql_cur="select mde.degree_level,edu.degreeid,edu.employeeid,edu.EDUC_INDEX,edu.INSTITUE,edu.FACULTY,edu.MAJORID,edu.YEAR_START,edu.BACKGROUNDID,edu.YEAR_END,edu.GPA,edu.REFERENCE from mempl_educate as edu LEFT JOIN mdegree as mde on edu.degreeid = mde.degreeid WHERE employeeid='"+employeeid+"' ORDER BY mde.degree_level DESC"; DataSet eduall = new DataSet(sql_cur, screen.getUProfile().getDbName(), ""); eduall.setFetchAll(false); eduall.initConnection(screen.getUProfile()); while(eduall.next()){ DbInquiry mdegree = new InitialInquiry(screen.getUProfile()).getDbInquiry("MDEGREE"); mdegree.setColumn("*"); mdegree.setFilter("degreeid = '"+eduall.getString("degreeid")+"'"); mdegree.refresh(); mdegree.next(); mdegree.referLangOn(); DbInquiry medubackground = new InitialInquiry(screen.getUProfile()).getDbInquiry("MEDUBACKGROUND"); medubackground.setColumn("*"); medubackground.setFilter("backgroundid = '"+eduall.getString("backgroundid")+"'"); medubackground.refresh(); medubackground.next(); medubackground.referLangOn(); DbInquiry minstitue = new InitialInquiry(screen.getUProfile()).getDbInquiry("MINSTITUE"); minstitue.setColumn("*"); minstitue.setFilter("institueid = '"+eduall.getString("institue")+"'"); minstitue.refresh(); minstitue.next(); minstitue.referLangOn(); DbInquiry mfaculty = new InitialInquiry(screen.getUProfile()).getDbInquiry("MFACULTY"); mfaculty.setColumn("*"); mfaculty.setFilter("facultyid = '"+eduall.getString("faculty")+"'"); mfaculty.refresh(); mfaculty.next(); mfaculty.referLangOn(); DbInquiry mmajor = new InitialInquiry(screen.getUProfile()).getDbInquiry("MMAJOR"); mmajor.setColumn("*"); mmajor.setFilter("majorid = '"+eduall.getString("majorid")+"'"); mmajor.refresh(); mmajor.next(); mmajor.referLangOn(); %> <tr> <td width="30"><div align="center"><input type="checkbox" name="" class="del_list" value="<%=eduall.getString("educ_index")%>" ></div></td> <td><div align="center"><a href="javaScript:childMulti('<%=eduall.getString("educ_index")%>')"><%=line_num++%></a></div></td> <td><div align="center"><%=mdegree.getString("edesc")%></div></td> <td><div align="center"><%=medubackground.getString("edesc")%></div></td> <td><div align="center"><%=minstitue.getString("edesc")%></div></td> <td><div align="center"><%=mfaculty.getString("edesc")%></div></td> <td><div align="center"><%=mmajor.getString("edesc")%></div></td> <td><div align="center"><%if(eduall.getString("year_start")!=null){out.print(eduall.getString("year_start"));}%></div></td> <td><div align="center"><%if(eduall.getString("year_end")!=null){out.print(eduall.getString("year_end"));}%></div></td> <td><div align="center"><%if(eduall.getString("gpa")!=null){out.print(eduall.getString("gpa"));}%></div></td> <td><div align="center"><%=reportUDF.getSystemCode("yesno",screen.getUProfile().get("lang"),eduall.getString("reference"))%></div></td> </tr> <% } eduall.closeConnection();%> </table> </td> </tr> </table> </td> </tr> <tr > <td colspan="2" class="blankspace"></td> </tr> <tr> <td colspan="2" nowrap class="buttonline"><div align="center"><a href="javascript:checkAll();"><img src="../IMAGES/BUTTON/SELECTALL.gif" border="0" align="middle"></a> <a href="javascript:decheckAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" align="middle"></a> <a href="javascript:addMulti();" ><img src="../IMAGES/BUTTON/ADD.gif" border="0" align="middle"></a> <a href="javascript:deleteMulti();"><img src="../IMAGES/BUTTON/DELETE.gif" border="0" align="middle"></a></div></td> </tr> <tr > <td colspan="2" class="blankspace"> </td> </tr> <tr> <td colspan="2" align="right"><script language="javascript">printEditCheck('<%=screen.getDataLabel("edit_by")%>','<%=screen.getDataLabel("edit_date")%>','<%=screen.getDataLabel("edit_time")%>','<%=screen.getDataLabel("approve")%>');</script> </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>