<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*"%>
<%@page import="com.csc.library.utilities.CheckNull"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,java.text.DecimalFormat"%>
<%@ page import="java.util.*,java.io.*,java.sql.*"%>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Locale" %>
<%@ page import="java.util.Date" %>
<%@ page import="com.csc.library.components.*" %>
<%@ page import="com.csc.library.report.ReportUDF" %>
<%@ page import="com.csc.api.recruit.*" %>
<%@ page import="com.csc.library.databean.Simmcandidatewithgson" %>
<%@ page import="com.csc.library.databean.Simmapplicantwithgson" %>
<%@ page import="com.csc.library.databean.Simmappointmentwithgson" %>
<%@ page import="com.csc.library.databean.Simmapplicanthisotherwithgson" %>
<%@ page import="com.csc.library.utilities.gsonmapping.*" %>
<%
CheckNull chk = new CheckNull();
String fixCon= "";
String filter = "1=1";
String loop2 = chk.chkNullString(request.getParameter("__loop2"));
String helpReturn="";

if( request.getParameter("__helpReturn") != null ){
	helpReturn = request.getParameter("__helpReturn");
}
if(!loop2.equals("") || !loop2.equals("null")){
		filter += "and personal like '%"+ loop2 +"%'";
}
%>

<jsp:useBean id="MCANDIDATEHELP" class="com.csc.library.system.Task" scope="page"/>

<%
MCANDIDATEHELP.setChannel(request, response);
HelpEntry screen = (HelpEntry) MCANDIDATEHELP.process("HelpEntry",request.getParameter("__helpName"));
screen.process();
CheckNull chkNull = new CheckNull();

if( !chkNull.chkNullString(request.getParameter("__langOn")).equals("") && request.getParameter("__langOn").equalsIgnoreCase("true") ){
	screen.referLangOn();
}else{
	screen.referLangOff();
}
%>

<HTML>
	<HEAD>
		<TITLE>myNOTE : Business Process Management Service</TITLE>
		<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
		<LINK HREF="../CSS/MYNOTE.css" REL="stylesheet" TYPE="text/css">
		<SCRIPT TYPE='text/JavaScript' SRC='../JS/MYNOTE_SCREEN.js'></SCRIPT>
		<SCRIPT TYPE='text/JavaScript' SRC='../JS/SCREEN.js'></SCRIPT>
		<SCRIPT LANGUAGE="JavaScript">setLang('<%=screen.getUProfile().get("lang")%>');</SCRIPT>
	</HEAD>
	<BODY>
		<FORM NAME="cscform" METHOD="post" ACTION="MCANDIDATE_PERSONALNAME.jsp">		
			<INPUT TYPE="hidden" NAME="__screen" VALUE="RRC027HELP">
			<INPUT TYPE="hidden" NAME="__cmd" VALUE="">
			<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="<%=helpReturn%>">
			<INPUT TYPE="hidden" NAME="__helpName" VALUE="<%=request.getParameter("__helpName")%>">
			<INPUT TYPE="hidden" NAME="__pageCall" VALUE="<%=request.getParameter("__pageCall")%>">
			<INPUT TYPE="hidden" NAME="__fixCon" VALUE="<%=request.getParameter("__fixCon")%>">
			<INPUT TYPE="hidden" NAME="__langOn" VALUE="<%=chkNull.chkNullString(request.getParameter("__langOff"))%>">
			<INPUT TYPE="hidden" NAME="__rsc_skip" VALUE="<%=chkNull.chkNullString(request.getParameter("__rsc_skip"))%>">
			<INPUT TYPE="hidden" NAME="rsc_skip" VALUE="<%=chkNull.chkNullString(request.getParameter("rsc_skip"))%>">
			<BR>
			<TABLE WIDTH="500" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="0">
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/T.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/L2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
    				<TD VALIGN="middle"><FONT FACE="MS Sans Serif" SIZE="1" COLOR="#FFFFFF">
      					
      					
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
							<TR BGCOLOR="#FFFFFF">
          						<TD HEIGHT="15" COLSPAN="2" BGCOLOR="#0099CC"><SPAN CLASS="style1">&nbsp;
								  <SPAN><%=screen.getUProfile().get("lang").equals("tha")?"ตารางค้นหาชื่อ-สกุลพนักงาน":"Employee Name-Surname Search Table"%> </SPAN>
								  
								 </TD>
        					</TR>
							<TR BGCOLOR="#FFFFFF">
								<TD HEIGHT="15"  >
									<SPAN><%=screen.getUProfile().get("lang").equals("tha")?"กรุณากรอกชื่อหรือนามสกุล":"Please enter your first name or last name."%> </SPAN>
								</TD>
								<TD HEIGHT="15"  >
									<INPUT TYPE="text"  NAME="__loop2" SIZE='20' MAXLENGTH='30' VALUE="<%=loop2%>" >
								</TD>
							</TR>
      					</TABLE>
    				</FONT></TD>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/R2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/B.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
			</TABLE>			
			<BR>
			<TABLE WIDTH="500" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="0">
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/T.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/L2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
    				<TD VALIGN="middle"><FONT FACE="MS Sans Serif" SIZE="1" COLOR="#FFFFFF">
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF"> </TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF"> </TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF">
          						<TD HEIGHT="15" COLSPAN="2" BGCOLOR="#0099CC"><SPAN CLASS="style1">&nbsp;
								  <SPAN>MCANDIDATE_PERSONALNAME<SPAN>
								  
								 </TD>
        					</TR>
      					</TABLE>

				<%
					DbInquiry inqcan = new InitialInquiry(screen.getUProfile()).getDbInquiry("Simmcandidatewithgson");
					inqcan.setFilter(filter);
					inqcan.refresh();
					int num = inqcan.recCount();
					String fname = "";
					String lname = "";
				%>
				<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
						<TR BGCOLOR="#FFFFFF">
							<TD  class='center'HEIGHT="15" BGCOLOR="#0099CC">CANDIDATEID</TD>
							<TD  class='center'HEIGHT="15" BGCOLOR="#0099CC">E-MAIL</TD>
							<TD  class='center'HEIGHT="15" BGCOLOR="#0099CC">NAME - SURNAME</TD>
						</TR>
					<%
					while(inqcan.next()){
						Simmcandidatewithgson simmcandidatewithgson = (Simmcandidatewithgson) inqcan.getCurrentDbRecord();
						fname = screen.getUProfile().get("lang").equals("tha")?simmcandidatewithgson.mcandidatePersonal.fname.tha:simmcandidatewithgson.mcandidatePersonal.fname.eng;
						lname = screen.getUProfile().get("lang").equals("tha")?simmcandidatewithgson.mcandidatePersonal.lname.tha:simmcandidatewithgson.mcandidatePersonal.lname.eng;
					%>
					<tr BGCOLOR="#EFEFEF">
						<td class='center'><a href="javascript:backPage_Return('__email#<%=inqcan.getString("email")%>;__fname#<%=fname%>;__lname#<%=lname%>');"><%=inqcan.getString("candidateid")%></a><br></td>
						<td class='center'><%=inqcan.getString("email")%><br></td>
						<td class='center'><%=fname+" "+lname%></td>
					</tr>
					<%
						}
					%>
					<%	if(num < 1){	%>
					<tr BGCOLOR="#EFEFEF">
							<td class='center' COLSPAN="3"> No Data</td>		
					</tr>
					<%	}	%>			
					</TABLE>
						
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/R2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/B.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
			</TABLE>
		</FORM>
	</BODY>
</HTML>