<%@ 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>