<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.report.ReportUDF" %>
<%@page import="java.util.*,java.io.*"%>
<%@page import="com.csc.library.util.download.*"%>
<%@page import="com.csc.library.util.ManageDocument"%>
<%@page import="com.csc.library.databean.util.FileUtil"%>
<jsp:useBean id="REC200O" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="REC201OT" class="com.csc.library.system.Task" scope="page" />
<%
CheckNull chk=new CheckNull();
CscCalendar cscC =new CscCalendar();
ThaiUtilities thaiut=new ThaiUtilities();
REC201OT.setChannel(request ,response);
UIManager screen1=(UIManager) REC201OT.process("SingleEntry","REC201OT");
REC200O.setChannel(request, response);
HelpEntry screen = (HelpEntry) REC200O.process("HelpEntry", "VW_TAPPLICANT");
screen.setMaxLine(15);
//screen.process();
screen.setOrder();
screen.setSearch();
String seby = chk.chkNullString(request.getParameter("__searchBy"));
String comsea = chk.chkNullString(request.getParameter("__conSearch"));
String data = thaiut.ASCII2Unicode(chk.chkNullString(request.getParameter("__valueSearch")));
String comsea2 = "";
if(seby.equals("vw_tapplicant.TDG1")){
screen.inq.setFilter(" TDG1 "+comsea+" '%"+data+"%' or TDG2 "+comsea+" '%"+data+"%' or TDG3 "+comsea+" '%"+data+"%' or TDG4 "+comsea+" '%"+data+"%' or TDG5 "+comsea+" '%"+data+"%' or FREEDEGREE1 "+comsea+" '%"+data+"%' or FREEDEGREE2 "+comsea+" '%"+data+"%' or FREEDEGREE3 "+comsea+" '%"+data+"%'");
}
else if(seby.equals("vw_tapplicant.TMA1")){
screen.inq.setFilter("TMA1 "+comsea+" '%"+data+"%' or TMA2 "+comsea+" '%"+data+"%' or TMA3 "+comsea+" '%"+data+"%' or TMA4 "+comsea+" '%"+data+"%' or TMA5 "+comsea+" '%"+data+"%' or FREEMAJOR1 "+comsea+" '%"+data+"%' or FREEMAJOR2 "+comsea+" '%"+data+"%' or FREEMAJOR3 "+comsea+" '%"+data+"%'");
}
else if(seby.equals("vw_tapplicant.GPA1")){
screen.inq.setFilter(" (GPA1 "+comsea+" '"+data+"' and GPA1 != '') or (GPA2 "+comsea+" '"+data+"' and GPA2 != '') or (GPA3 "+comsea+" '"+data+"' and GPA3 != '') or (GPA4 "+comsea+" '"+data+"' and GPA4 != '') or (GPA5 "+comsea+" '"+data+"' and GPA5 != '') or (FREEGPA1 "+comsea+" '"+data+"' and FREEGPA1 != '') or (FREEGPA2 "+comsea+" '"+data+"' and FREEGPA2 != '') or (FREEGPA3 "+comsea+" '"+data+"' and FREEGPA3 != '')");
}
else if(seby.equals("vw_tapplicant.BIRTHDAY")){
// if(data >= 0 && data <= 99){
if(comsea.equals("<")){
comsea2=">";
}
else if(comsea.equals(">")){
comsea2="<";
}
else if(comsea.equals("<=")){
comsea2=">=";
}
else if(comsea.equals(">=")){
comsea2="<=";
}
screen.inq.setFilter("BIRTHDAY"+ comsea2 +"'"+ cscC.decYear(Integer.parseInt(chk.chkNullString(request.getParameter("__valueSearch"),"0"))).getYear()+"-01-01'");
// }
}
screen.inq.refresh();
screen.countRec(screen.inq);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<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 language="JavaScript" src="../JS/SCREEN.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--
//-->
function search2(){
with(document.cscform){
if(chAction()){
// if(__searchBy.value=="vw_tapplicant.BIRTHDAY"){//__conSearch
/* if(__valueSearch.value>=0 &&__valueSearch.value<=99){
// alert("old"+__conSearch.value);
if(__conSearch.value=="<"){
__conSearch.value=">";
}
else if(__conSearch.value==">"){
__conSearch.value="<";
}
else if(__conSearch.value=="<="){
__conSearch.value=">=";
}
else if(__conSearch.value==">="){
__conSearch.value="<=";
}
// alert("new"+__conSearch.value);
// alert(__valueSearch.value);
start = new Date();
// alert(start);
start.setFullYear(start.getYear()-__valueSearch.value);
// alert(start.getFullYear());
__valueSearch.value=start.getFullYear()+"-01-01";
//alert(__valueSearch.value);
}
}*/
/* else if(__searchBy.value=="vw_tapplicant.TDG1"){//__conSearch
}
*/
__cmd.value="search";
submit();
}
}
}
function GoDelete(){
with(document.cscform) {
bCon=confirm(MyCode[4]);
if (bCon==true){
__cmd.value = "erase";
submit();
}
}
}
function GoTransfer(){
with(document.cscform) {
bCon=confirm(MyCode[1]);
if (bCon==true){
__cmd.value = "transfer";
submit();
}
}
}
function goPages(appid,pages){
with(document.cscform){
__help.value="__applicantid$"+appid;
action=pages+".jsp";
submit();
}
}
function goPagess(){
with(document.cscform){
action="#";
submit();
}
}
function goPage(page){
with(document.cscform){
if(chAll()==false){
alert("ต้องทำการ TRANSFER ข้อมูลก่อน");
}
else{
__goPage.value=page;
submit();
}
}
}
function chAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"){
if(elements[i].checked){
return false;
}else{
}
}
}//end for
return true;
}//end with
}//end function
</script>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
helpReturn=request.getParameter("__helpReturn");
}
String goPage="";
if(request.getParameter("__goPage")==null){
goPage="+1";
}
else{
goPage=request.getParameter("__goPage");
}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden"name="__screen" value="REC201OT">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="<%=goPage%>">
<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("__screen")%>">
<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<br>
<div align="center">
<table height="" align="center" cellpadding="0" cellspacing="0" width="100%" >
<tr bgcolor="#3366CC">
<td class="header"><div align="right">REC200O, <script language="JavaScript">swapLang('Job Application')</script>(Import) </div></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 width="15%"> <div align="right">
<script language="javascript">swapLang('Order By');</script>
</div></td>
<td><%=screen.getTagOrder()%></td>
<td width="20%"> <div align="right">
<script language="javascript">swapLang('Search By');</script> </div></td>
<td><%=screen.getTagSearchBy()%></td>
</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>
</div></td>
<td><%=screen.getTagValueSearch()%> <a href="javascript:search2();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></td>
</tr>
<tr>
<td colspan="4" class="blankspace" align="right"><a href="javascript:GoTransfer();"><img src="../IMAGES/BUTTON/TRANSFER.gif" border="0"></a>
<a href="javascript:GoDelete();"><img src="../IMAGES/BUTTON/DELETE.gif" border="0"></a></td>
</tr>
<tr>
<td colspan="4"><div align="right"> <%=screen.getPageTag()%></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<div align="right"><br>
</div>
<table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe">
<tr >
<td class="title1"><div align="center"> </div></td>
<td class="title1"><div align="center"> <%=screen.getLabel("applicantid")%></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Name")</script> - <script language="javaScript">swapLang("Lastname")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Degree")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Major")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Gpa")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Code")</script><script language="javaScript">swapLang("Source")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Source")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Ages")</script></div></td>
</tr>
<% while(screen.nextRec()){
if(screen.checkLinePage()){
screen.referLangOn();
%>
<tr>
<td align="center"><label>
<input type="checkbox" name="__ch<%=screen.getString("applicantid")%>" value="<%=screen.getString("applicantid")%>">
</label></td>
<td nowrap class="forborder2"><div align="center"> <a href="javascript:goPages('<%=screen.getString("applicantid")%>','REC201OV');"><%=screen.getString("applicantid")%></a></div></td>
<td nowrap class="forborder2"><div align="center"> <%=screen.getString("fullname")%></div></td>
<td nowrap class="forborder2"><div align="center"> <%=screen.getString("tdg1")%></div></td>
<!--<td nowrap class="forborder2"><div align="center"> <%//=screen.getString("degreeid1")%></div></td>
<td nowrap class="forborder2"><div align="center"> <%//=screen.getString("highestdegreedesc")%></div></td>-->
<td nowrap class="forborder2"><div align="center"> <%=screen.getString("tma1")%></div></td>
<!--<td nowrap class="forborder2"><div align="center"> <%//=screen.getString("highestdegreemajordesc")%></div></td>-->
<!--<td nowrap class="forborder2"><div align="center"> <%//=screen.getString("highestdegreegpa")%></div></td>-->
<td nowrap class="forborder2"><div align="center"> <%=screen.getString("GPA1")%></div></td>
<td nowrap class="forborder2"><div align="center"> <%=screen.getString("news")%></div></td>
<td nowrap class="forborder2"><div align="center"> <%=screen.getInquiry().getCurrentDbRecord().getSystemCode("news")%></div></td>
<td nowrap class="forborder2"><div align="center"> <%=screen.getString("ages")%></div></td>
</tr>
<%
screen.referLangOff();
}
if(screen.outLinePage()){ break; }
}
%>
</table>
</td>
</tr>
<tr><td ><input type="hidden" name="keyDel" value="">
</td></tr>
<tr>
<td>
<table align="center">
<tr>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Code")</script><script language="javaScript">swapLang("Source")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Source")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Code")</script><script language="javaScript">swapLang("Source")</script></div></td>
<td class="title1"><div align="center"><script language="javaScript">swapLang("Source")</script></div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">0</div></td>
<td class="forborder2"><div align="center" class="style1">สนใจสมัครด้วยตัวเอง</div></td>
<td class="forborder2"><div align="center" class="style1">7</div></td>
<td class="forborder2"><div align="center" class="style1">เว็บไซต์สมัครงาน(Nationejobs)</div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">1</div></td>
<td class="forborder2"><div align="center" class="style1">เว็บไซต์ของธนาคาร</div></td>
<td class="forborder2"><div align="center" class="style1">8</div></td>
<td class="forborder2"><div align="center" class="style1">หนังสือพิมพ์สมัครงาน</div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">2</div></td>
<td class="forborder2"><div align="center" class="style1">สาขาของธนาคาร</div></td>
<td class="forborder2"><div align="center" class="style1">9</div></td>
<td class="forborder2"><div align="center" class="style1">หนังสือพิมพ์ธุรกิจทั่วไป</div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">3</div></td>
<td class="forborder2"><div align="center" class="style1">เว็บไซต์สมัครงาน(Jobbkk)</div></td>
<td class="forborder2"><div align="center" class="style1">10</div></td>
<td class="forborder2"><div align="center" class="style1">งานนัดพบแรงงาน</div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">4</div></td>
<td class="forborder2"><div align="center" class="style1">ว็บไซต์สมัครงาน(Jobthai)</div></td>
<td class="forborder2"><div align="center" class="style1">11</div></td>
<td class="forborder2"><div align="center" class="style1">บุคคลแนะนำ</div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">5</div></td>
<td class="forborder2"><div align="center" class="style1">เว็บไซต์สมัครงาน(Jjobsdb)</div></td>
<td class="forborder2"><div align="center" class="style1">12</div></td>
<td class="forborder2"><div align="center" class="style1">Applications from TS</div></td>
</tr>
<tr>
<td class="forborder2"><div align="center" class="style1">6</div></td>
<td class="forborder2"><div align="center" class="style1">เว็บไซต์สมัครงาน(Jobtopgun)</div></td>
<td class="forborder2"><div align="center" class="style1">13</div></td>
<td class="forborder2"><div align="center" class="style1">อื่นๆ</div></td>
</tr>
</table>
</td>
</tr>
<tr><td class="bottom">
</td></tr>
</table>
</div>
</form>
</body>
</html>