<%@ page contentType="text/html; charset=UTF-8" language="java" pageEncoding="UTF-8" %>
<%@ page import="com.csc.library.entry.EmvHelpEntry, com.csc.library.system.*,com.csc.library.session.*, com.csc.library.utilities.CheckNull" %>
<%@ page import="com.csc.library.report.ReportUDF, java.util.*"%>
<%@page import="com.csc.library.database.DataSet"%>
<%@ include file="../CHECKPROFILE.jsp" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" />
<jsp:setProperty name="EMV" property="appname" value="EMPVIEW" />

<%
    CheckNull chkNull = new CheckNull();
	CheckNull chk = new CheckNull();
	EMV.setChannel( request, response );
	EmvHelpEntry screen = (EmvHelpEntry)EMV.process("EmvHelpEntry", "REC601HELP");
	EmvHelpEntry screen2 = (EmvHelpEntry)EMV.process("EmvHelpEntry", "REC601HELP");
    String reqid = chk.chkNullString(request.getParameter("__requestid"));

	//screen.getInquiry().setFilter("requestid='"+reqid+"' ");	
	screen.setMaxLine(15);
	//screen.getInquiry().getParam().put("rec_skip","true");
	//screen.process();
	//screen.nextRec();
	//out.print(screen.getString("requestid"));
     int i=0;
	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);
	String applicantid  = chkNull.chkNullString(request.getParameter("__app"));
	String edit            = chkNull.chkNullString(request.getParameter("__edit"));
	String[] key = null;

	 

	//บนลงล่าง
	 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","9");
					app.save();
				}		   
			  }
	  }
	  //ล่างขึ้นบน
	 else 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","10");
					app.save();
				}		   
			  }
	  }
	
	inq.refresh();

	// String sql =" select  memployee.employeeid,memployee.fname,memployee.lname from mrequest inner join mcommittee  on mrequest.requestid=mcommittee.requestid inner join memployee on mcommittee.employeeid=memployee.employeeid   where mrequest.requestid='"+reqid+"' ";
	  String sql = "SELECT EMPLOYEEID FROM MCOMMITTEE WHERE REQUESTID = '"+reqid+"' AND EMPLOYEEID = '"+screen.getUProfile().get("employeeid")+"' AND PRIORITY='1' ";
	 // out.print(sql);
	  DataSet  ds = new DataSet(sql,screen.getUProfile().get("dbname"),"MCOMMITTEE");
	  ds.initConnection(screen.getUProfile());
	   ds.closeConnection();
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="myHR">
	<head>

		<title>Employee View</title>

		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
		
	</head>
	<body>
		<div class="bg-com"></div>	
		<jsp:include page="EMV_HEADMENU.jsp" flush="true" />

		<script type="text/javascript">
			setLang("<%=screen.getUProfile().get("lang")%>");
			var swap = new swaplang();
            var titlename = swap.swap2String("SW006674");
			setPageTitle(titlename);
			
			function goHelp(helpName,inputName) {
				var helpReturn;
				var fixCon = "";
				if(inputName=="__bu1" ) {
					helpReturn="__bu1:bu1id,MBU1@TDESC";	
				} else if(inputName=="__bu2" ) {
					helpReturn="__bu2:bu2id,MBU2@TDESC";	
				} else if(inputName=="__bu3" ) {
					helpReturn="__bu3:bu3id,MBU3@TDESC";	
				} else if(inputName=="__emp_position" ) {
					helpReturn="__emp_position:positionid,MPOSITION@TDESC";	
				} else if(inputName=="__subgroupid" ) {
					fixCon = "employeeid='<%=screen.getUProfile().getEmvEmpId()%>'";
					helpReturn="__subgroupid:groupid,MSUBORDINATE_GRP@TDESC";	
				}
						
				linkHelp_Return(helpName,helpReturn, fixCon);	
			}
			
			
			function GoSearch(){
				search();
			}
			
			function linkSubordinate(subordinate){
				with(document.cscform){
					__subordinateid.value = subordinate;
					action = "EMV_REC612_PHATRA.jsp";
					submit();
				}
				
			}
			function toolTip(){
			}


			function checkBeforeSave(vname){
				
				with(document.cscform){
					for(i=0;i<elements.length;i++){
						if(elements[i].type=="checkbox") {
							
							if(elements[i].checked == true){
									return true;
							}			
						}
						
					}
					return 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 = "";

				   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 NoDataFound(errcode){
				window.location.href="CONTROLERR.jsp?errcode="+errcode;			
			}
		</script>
		
		<section>
			<div class="container csc-content">
				<form name="cscform" class="form-horizontal" method="post" action="?">
					<%=screen.InitialVariable()%>
					<input type="hidden" name="__screen" value="MG_SUBORDINATE">
					<input type="hidden" name="__cmd" value="" />
					<input type="hidden" name="__help" value="" />
					<input type="hidden" name="__goPage" value="" />
					<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>" />
					<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>" />
					<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="__subordinateid" value="" />
					<input type="hidden" name="__requestid" value="<%=request.getParameter("__requestid")%>" />
					<input type="hidden" name="__app" value="" >
					<input type="hidden" name="__edit" value="" >
				
					<%
					   if(ds.next()){
					%>
					<div class="csc-block-white">
						<div class="container csc-content">
							<div class="table-responsive">	
								<table class="table table-head table-hover table-bordered table-title-left">
									<thead>
										<tr>	
											<th class="table-title" colspan=4 swlang code='SW012175'>Recorded Applicant List</th>
										</tr>
										<tr>
											<th swlang code='SW000015'>Select</th>
											<th swlang code='SW012176'>Candidate ID</th>
											<th swlang code='SW002160'>Name Lastname</th>
											<th swlang code='SW000780'>Job Title</th>
										</tr>
									</thead>
									<tbody>
										<% 
											screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"' AND CANDIDATESTATUS IN ('10') " );
												screen.process();
											if(screen.getInquiry().recCount()>0) {
												
											   
												while(screen.nextRec()){
													//out.print(i);
										%>
										<tr>
											<td><center><input type="checkbox" name="chk_re<%=i%>"  id="chk_re<%=i%>"   value="<%=screen.getString("applicantid")%>"></center></td>
											<td><center><%=screen.getDataLabel("APPLICANTID") %></center></td>
											<td><%=screen.getString("MAPPLICANT","FULLNAME")%></td>
											<td><%=screen.getDataLabel("MAPPLICANT","JOBNAME").equals("")?screen.getDataLabel("MAPPLICANT","FREETEXTJOB") :screen.getDataLabel("MAPPLICANT","JOBNAME")  %></td>
										</tr>
										<%	       
														screen.referLangOff();
												 } 
											
											}
										%>
									</tbody>
								</table>
							</div>
							
							<div class="table-responsive">	
								<table class="table table-head table-hover table-bordered table-title-left">
									<thead>
										<tr>
											<th class="table-title" colspan=4 swlang code='SW012178'>Non recorded Applicant List</th>
										</tr>
										<tr>
											<th swlang code='SW000015'>Select</th>
											<th swlang code='SW012176'>Candidate ID</th>
											<th swlang code='SW002160'>Name Lastname</th>
											<th swlang code='SW000780'>Job Title</th>
										</tr>
									</thead>			
									<tbody>
										<% 
									
												screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"' AND CANDIDATESTATUS IN ('9') ");
												//out.println("filter :: " + screen.getInquiry().getFilter());
												screen.process();
											if(screen.getInquiry().recCount()>0) {
														
												while(screen.nextRec()){		
													//out.print(i);
										%>
										<tr>
											<td><center><input type="checkbox" name="num<%=i%>"  id="num<%=i%>"   value="<%=screen.getString("applicantid")%>"></center></td>
											<td><center><%=screen.getDataLabel("APPLICANTID") %>  <input type="hidden" name="__applicantid<%=i%>"  id="appid<%=i%>" value="<%=screen.getDataLabel("APPLICANTID") %>"></center></td>
											<td><%=screen.getString("MAPPLICANT","FULLNAME")%></td>
											<td><%=screen.getDataLabel("MAPPLICANT","JOBNAME").equals("")?screen2.getDataLabel("MAPPLICANT","FREETEXTJOB") :screen.getDataLabel("MAPPLICANT","JOBNAME")  %></td>
										</tr>
										<%	
												screen.referLangOff();
												}
											}
										%>
									</tbody>
								</table>
							</div>

							<div class="center"> 
								<a class="btn btn-primary" href="javascript:checkAll();" swlang code='SW012180'>Check All</a>
								<a class="btn btn-primary" href="javascript:decheckAll();" swlang code='SW012181'>Uncheck All</a>
								<a class="btn btn-primary" href="javascript:Save();" swlang code='SW000117'>Save</a>
								<!--<a class="btn btn-primary" href="javascript:delChild();" swlang code='SW000123'>Delete</a>-->
							</div>
						</div>
					</div>
					<%=screen.endJSP()%>   
					
					<%
						 }else{
					%>
						<script>
							NoDataFound('nodata');
						</script>
					<%
						 }
					%>
					
				</form>
			</div>
		</section>
		<jsp:include page="FOOTER.jsp" flush="true" />
	</body>
</html>