<!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>&nbsp;</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")%>&nbsp;</td>
                            <td ><%=screen.getInput("employeeid")%> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=screen.getLabel("status")%>&nbsp; <%=screen.getInput("status")%> </td>
                          </tr>
                          <tr>
                            <td class="columnlabel"><%=screen.getLabel("fname")%>&nbsp;</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")%>">
                              &nbsp;
                              <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")%>&nbsp; </td>
                            <td><input name="MPREFIX@EDESC" type="text" readonly size="10" value="<%=screen.getDataLabel("MPREFIX","EDESC")%>">
                              &nbsp;
                              <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  >&nbsp;</td>
                            <td >&nbsp;</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>&nbsp;&nbsp;<a href="javascript:decheckAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" align="middle"></a>&nbsp;&nbsp;<a href="javascript:addMulti();" ><img src="../IMAGES/BUTTON/ADD.gif" border="0" align="middle"></a>&nbsp;&nbsp;<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>&nbsp;</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>