<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*" contentType="text/html;charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.database.*,java.util.*" contentType="text/html;charset=UTF-8"%>
<%@page import="com.csc.library.database.DataSet"%>
<jsp:useBean id="REC6011" scope="page" class="com.csc.library.system.Task"/>
<jsp:useBean id="REC601HELP" scope="page" class="com.csc.library.system.Task"/><%
REC601HELP.setChannel(request ,response);
REC6011.setChannel(request ,response);
HelpEntry screen=(HelpEntry) REC601HELP.process("HelpEntry","REC601HELP");
CheckNull chkNull = new CheckNull();
screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"'");
screen.process();
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("mcommittee");
DbInquiry emp = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee");
inq.setColumn("employeeid,companyid,requestid");
inq.setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"))+"'");
inq.putChild(emp);
int i =0;
String applicantid = chkNull.chkNullString(request.getParameter("__app"));
String edit = chkNull.chkNullString(request.getParameter("__edit"));
String[] key = null;
if(edit.equals("edit")){
key = applicantid.split("#");
for( i=0;i<key.length;i++){
DbRecord app = new InitialRecord(screen.getUProfile()).getDbRecord("mcandidatere");
app.setColumn("applicantid,candidatestatus,companyid");
app.set("applicantid",key[i]);
app.set("companyid",screen.getUProfile().get("companyid"));
if(app.search() == 1){
app.set("candidatestatus","9");
app.save();
}
}
}else if(edit.equals("re")){
key = applicantid.split("#");
for( i=0;i<key.length;i++){
DbRecord app = new InitialRecord(screen.getUProfile()).getDbRecord("mcandidatere");
app.setColumn("applicantid,candidatestatus,companyid");
app.set("applicantid",key[i]);
app.set("companyid",screen.getUProfile().get("companyid"));
if(app.search() == 1){
app.set("candidatestatus","");
app.save();
}
}
}else if(edit.equals("del")){
key = applicantid.split("#");
for( i=0;i<key.length;i++){
DbTable app = new InitialTable(screen.getUProfile()).getDbTable("mcandidatere");
app.setKeyOff();
app.setFilter("applicantid='"+key[i]+"'");
app.realDelete();
}
}
inq.refresh();
String mailList="";
while(inq.next()){
mailList = mailList+inq.getString("memployee","email")+",";
}
if(mailList.length()>0)mailList=mailList.substring(0,mailList.length()-1);
/*=============================== committree =============================*/
String empid ="";
String email ="";
String fname="";
String lname="";
String efname="";
String elname="";
String prefix="";
String eprefix="";
String requestid = chkNull.chkNullString(request.getParameter("__requestid"));
String sql="SELECT MP.TDESC,MP.EDESC,* from MCOMMITTEE MC inner join memployee me on(MC.EMPLOYEEID=me.EMPLOYEEID) inner join MPREFIX MP ON(ME.EMP_PREFIX=MP.PREFIXID) where MC.REQUESTID='"+requestid+"' and MC.PRIORITY='1'";
//out.print(sql);
DataSet ds = new DataSet(sql,screen.getUProfile().get("dbname"),"MCOMMITTEE");
ds.initConnection(screen.getUProfile());
if(ds.next()){
empid = ds.getString("employeeid");
email = ds.getString("email");
fname = ds.getString("fname");
lname = ds.getString("lname");
efname = ds.getString("efname");
elname = ds.getString("elname");
prefix = ds.getString("tdesc");
eprefix = ds.getString("edesc");
}
ds.closeConnection();
/*=============================== End committree =============================*/
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<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/RECSCREEN.js'></script>
<script language='javascript' src='../JS/HOTKEY.js'></script>
<script language='javascript' src='../JS/EMPLOYEE.js'></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript">
function GoSave() {
with(document.cscform){
bCon=confirm(MyCode[1]);
if (bCon==true) {
__confirm.value="s";
__cmd.value = "save";
submit();
}
}
}
function checkAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox") {
elements[i].checked=true;
}
}
}
}
function decheckAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox") {
elements[i].checked=false;
}
}
}
}
function setData(){
with(document.cscform){
__app.value="";
__edit.value="";
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox") {
if(elements[i].checked == true){
__app.value += elements[i].value + "#";
}
}
}
}
}
function Save(){
with(document.cscform){
var a = "";
var b = "";
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"&&elements[i].checked==true){
a = elements[i].name.replace("chk_re","");
b = elements[i].name.replace("num","");
if(elements[i].name == "chk_re"+a){
//alert("AA");
setData();
var ms = confirm("ยืนยันการเลือกผู้สมัคร");
if(ms==true){
__edit.value="re";
submit();
}
}else if(elements[i].name=="num"+b){
//alert("bb");
setData();
var ms = confirm("ยืนยันการเลือกผู้สมัคร");
if(ms==true){
__edit.value="edit";
submit();
}
}else{
alert("กรุณาเลือกพนักงาน");
}
}
}
}
}
function Del(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"&&elements[i].checked==true){
if(elements[i].name.indexOf("num") != -1){
//alert("AA");
setData();
var ms = confirm("ยืนยันการเลือกผู้สมัคร");
if(ms==true){
__edit.value="del";
submit();
}
}else{
alert("ไม่สามารถลบข้อมูลได้");
}
}
}
}
}
function mail(){
with(document.cscform){
var j=0;
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"&&elements[i].checked==true){
if(elements[i].name.indexOf("num") != -1){
alert("ไม่สมารถส่งเมลล์ได้เนื่องจากยังไม่นัดสัมภาษณ์");
}else{
//alert("ส่งได้");
j++;
}
}
}
if(j=="1"){
pam="REC6012_PHATRA.jsp?&__mail_to="+mailList.value+"&__mail_from="+from.value+"&__nametha="+__nametha.value+"&__nameeng="+__nameeng.value;
window.open(pam,"","left=150,top=150,width=800,height=500,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}else if(j>="2") {
alert("กรุณาเลือกผู้สมัครให้ถูกจำนวน");
}
}
}
</script>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #3366CC}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="" >
<form name="cscform" method="post" action="REC6011_PHATRA.jsp" >
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden"name="__screen" value="REC6011">
<input type="hidden" name="__help" size="50" value="">
<input name="__fixCon" type="hidden" value="">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__empid" value="<%=empid%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="gopage" value="">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__notNull" value="">
<input type="hidden" name="__requestid" value="<%=chkNull.chkNullString(request.getParameter("__requestid"))%>">
<input type="hidden" name="__app" value="" >
<input type="hidden" name="__edit" value="" >
<input type="hidden" name="__nametha" value="<%=chkNull.chkNullString(request.getParameter("__nametha"),prefix+""+fname+" "+lname)%>" >
<input type="hidden" name="__nameeng" value="<%=chkNull.chkNullString(request.getParameter("__nameeng"),eprefix+""+efname+" "+elname)%>" >
<input name="mailList" type="hidden" value="<%=chkNull.chkNullString(email)%>">
<input name="from" type="hidden" value='<%=screen.getUProfile().get("email")%>'>
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<br>
<center> <table width="100%" align="center" cellpadding="0" cellspacing="0" class="normal">
<tr class="header">
<td class="header" align="right">REC6011,
<script language="javascript">swapLang('Candidate Selection');</script></td>
</tr>
<%
if(screen.nextRec()){ %>
<tr >
<td colspan="2"><table border="0" cellpadding="0" cellspacing="0" class="maxsize" >
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("REQUESTID")%> </td>
<td colspan="5" class="columnData"><%=screen.getDataLabel("REQUESTID")%></td>
<td colspan="3" align="left"><%=screen.getLabel("MREQUEST","REQ_STATUS")%> <span class="style1"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MREQUEST","REQ_STATUS")%> </span></td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("MREQUEST","DOC_DATE") %> </td>
<td colspan="2" nowrap class="columnData"> <%=screen.getDataLabel("MREQUEST","DOC_DATE") %> </td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("MJOBCODE","TDESC") %> </td>
<td colspan="2" nowrap class="columnData"><%=screen.getDataLabel("MJOBCODE","TDESC")%>
</td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("MPOSITION","TDESC") %> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MPOSITION","TDESC")%></td>
<input name="position" type="hidden" value="<%=screen.getDataLabel("MPOSITION","TDESC")%>">
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("MREQUEST","REQ_TYPE") %> </td>
<td colspan="5" class="columnData"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MREQUEST","REQ_TYPE")%></td>
<td colspan="2" align="left" nowrap><script language="javascript">swapLang('No of Requirement')</script> <span class="style1"><%=screen.getDataLabel("MREQUEST","EMP_NUM")%> </span> <script language="JavaScript">swapLang('Position')</script></td>
</tr>
<!-- <tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Salary range')</script> </td>
<td colspan="2" class="columnData"><%=screen.getDataLabel("MREQUEST","FROMSALARY")%> - <%=screen.getDataLabel("MREQUEST","TOSALARY")%><span class="style2">
<script language="JavaScript">swapLang('Baht')</script>
</span></td>
</tr> -->
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Ages')</script> </td>
<td colspan="5" class="columnData"><%=screen.getDataLabel("MREQUEST","FROMAGE")%> - <%=screen.getDataLabel("MREQUEST","TOAGE")%>
<span class="style2"><script language="JavaScript">swapLang('Year')</script></span></td>
<td align="left" colspan="2"><script language="javascript">swapLang('Gender')</script>
<%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MREQUEST","SEX")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="javascript">swapLang('Applicantion Duration')</script> </td>
<td colspan="2" class="columnData"><%=screen.getDataLabel("MREQUEST","STARTDATE")%> <%=screen.getDataLabel("MREQUEST","LASTDATE")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("MREQUEST","REQUEST_BY")%> </td>
<td colspan="2" class="columnData"><%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%></td>
<tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("MREQUEST","APPROVEDATE")%> </td>
<td colspan="2" class="columnData"><%=screen.getDataLabel("MREQUEST","APPROVEDATE")%></td>
<tr>
<td colspan="8"></td>
</tr>
<tr>
<td colspan="8"><hr></td>
</tr>
<tr>
<td colspan="8"><script language="javascript">swapLang('Applicant List');</script></td>
</tr>
<tr>
<td colspan="8"><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2">
<tr bgcolor="#3366CC">
<td class="row3" align="center" width="30"><script language="javascript">swapLang('Select');</script></td>
<td width="50" align="center" nowrap class="row3"><script language="JavaScript">swapLang('Sequence')</script></td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Applicant ID')</script></td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Name')</script>
-
<script language="JavaScript">swapLang('Lastname')</script></td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Job')</script></td>
<!-- <td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Interview Date')</script></td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Interview Time')</script></td> -->
</tr>
<%
screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"' AND CANDIDATESTATUS='9'");
screen.process();
i=1;
while(screen.nextRec()){
if(screen.getDataLabel("CANDIDATESTATUS").equals("9")){
//out.print("i1 = "+i);
%>
<tr>
<td align="center" nowrap><input type="checkbox" name="chk_re<%=i%>" value="<%=screen.getDataLabel("APPLICANTID") %>" id="chk_re<%=i%>" ></td>
<td align="center" nowrap><%=i%></td>
<td align="center" nowrap><%=screen.getDataLabel("APPLICANTID") %></td>
<td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","FULLNAME") %></td>
<td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","JOBNAME").equals("")?screen.getDataLabel("MAPPLICANT","FREETEXTJOB") :screen.getDataLabel("MAPPLICANT","JOBNAME") %></td>
<!-- <td align="center" nowrap><%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWDATE") %></td>
<td align="center" nowrap><%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWTIME") %></td> -->
</tr>
<input name="interviewplace<%=i%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWPLACE")%>">
<input name="interviewroom<%=i%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWROOM")%>">
<input name="interviewdate<%=i%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWDATE")%>">
<input name="interviewtime<%=i++%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWTIME")%>">
<%
}
}
%>
<tr>
<td colspan="9" align="center"></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="8"><script language="javascript">swapLang('No record Applicant List');</script></td>
</tr>
<tr>
<td colspan="8"><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2">
<tr bgcolor="#3366CC">
<td class="row3" align="center" width="30"><script language="javascript">swapLang('Select');</script></td>
<td width="50" align="center" nowrap class="row3"><script language="JavaScript">swapLang('Sequence')</script> </td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Applicant ID')</script> </td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Name')</script>
-
<script language="JavaScript">swapLang('Lastname')</script> </td>
<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Job')</script> </td>
</tr>
<%
//screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"' AND CANDIDATESTATUS=''");
screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"' ");
screen.process();
i=1;
while(screen.nextRec()){
//out.print("i2 = "+i);
if(screen.getDataLabel("CANDIDATESTATUS").equals("")||screen.getDataLabel("CANDIDATESTATUS").equals("0")){
if(i==1){
%><input type="hidden" name="__applicantid" value="<%=screen.getDataLabel("APPLICANTID") %>"> <%
}
%>
<tr>
<td align="center" nowrap><input type="checkbox" name="num<%=i%>" value="<%=screen.getDataLabel("APPLICANTID") %>" id="num<%=i%>"></td>
<td align="center" nowrap><%=i%></td>
<td align="center" nowrap>
<%=screen.getDataLabel("APPLICANTID") %>
<input type="hidden" name="__applicantid_<%=i%>" id="appid<%=i%>" value="<%=screen.getDataLabel("APPLICANTID") %>">
</td>
<td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","FULLNAME") %></td>
<td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","JOBNAME").equals("")?screen.getDataLabel("MAPPLICANT","FREETEXTJOB") :screen.getDataLabel("MAPPLICANT","JOBNAME") %></td>
<%i++;%>
</tr>
<%
}
}
%>
<input type="hidden" name="__appcount" value="<%=i-1%>">
<tr>
<td colspan="9" align="center"><a href="javascript:checkAll()"><img src="../IMAGES/BUTTON/SELECTALL.gif" width="73" height="23" border="0"></a> <a href="javascript:decheckAll()"><img src="../IMAGES/BUTTON/DESELECTALL.gif" width="73" height="23" border="0"></a> <a href="javascript:Save()"><img src="../IMAGES/BUTTON/SAVE.gif" width="73" height="23" border="0"></a> <!--a href="javascript:Del()"><img src="../IMAGES/BUTTON/DELETE.gif" width="73" height="23" border="0"></a--> <a href="javascript:mail();"><img src="../IMAGES/BUTTON/MAIL.gif" width="73" height="23" border="0"></a> </td>
</tr>
</table></td>
</tr>
</table></td>
<%}
else {
%>
<tr><td> <script language="JavaScript">swapLang('No Candidate Found!!')</script></td></tr>
<%}%>
</tr>
<tr bordercolor="0069B3">
<td class="bottom"></td>
</tr>
</table>
<script language="JavaScript">
</script>
</center>
<!----------BEGIN CSC ENDING ZONE ------------------------>
<%=screen.endJSP()%>
<!----------END CSC ENDING ZONE -------------------------->
</FORM>
</body>
</html>