<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.session.DbInquiry"%> <%@page import="com.csc.library.utilities.UProfile"%> <%@page import="com.csc.library.utilities.getFieldDataTag"%> <%@page import="com.csc.library.utilities.DbXml"%> <jsp:useBean id="checkmodule" class="com.csc.library.system.Task" scope="page"/> <% /* URL : http://localhost:8082/hr/PERSONAL/MAILMERGE_DHAS_001.jsp?__cmd=login&__guest=true&__agencyname=&__agencyid=&__dbcomp=DB3-100&__lang=tha&__user=wipawine_k&__user_level=01 http://myhr.dhas.com/hr/PERSONAL/MAILMERGE_DHAS_001.jsp?__cmd=login&__guest=true&__agencyname=&__agencyid=&__dbcomp=DB3-100&__lang=tha&__user=wipawine_k&__user_level=01 */ session.invalidate(); checkmodule.setChannel(request,response); checkmodule.checkProfile(); UProfile u = checkmodule.getUProfile(); // out.print(u); if(u!=null){ String fliter = request.getParameter("__filter"); getFieldDataTag tag = new getFieldDataTag(u); // u.setDbName(new InitialEnvironment("GLOBAL").getValue("db-name")); u.set("lang", request.getParameter("__lang")); u.set("user",request.getParameter("__user")); u.set("user_level",request.getParameter("__user_level")); u.set("employeeid",request.getParameter("__employeeid")); u.set("companyid","100"); u.set("appname",""); u.set("schemaname","myhradmin"); u.set("fsecurity","1"); // out.print(u); DbInquiry inq = new DbXml(u,"PERSONAL/MAILMERGE_DHAS_001", "", "", "", new java.util.HashMap()).getInquiry(); // inq.getCurrentDbRecord().getSystemField().remove("create_by"); // inq.getCurrentDbRecord().getSystemField().remove("create_byuser"); // out.print(inq.getCurrentDbRecord().getSystemField().toString()); tag.setDbInq(inq); tag.setFilter(" ADDR_CURRENT='1' AND EMPLOYEEID IN (SELECT EMPLOYEEID FROM MEMPLOYEE WHERE STATUS='V') "); // tag.setFilter(" EMPLOYEEID in ('001003','470024') "); // tag.setChildChk("memployee",2); tag.read(); out.print("<STATUS>\"TRUE\"</STATUS>\n"); out.print(tag.getAllTag()); }else{ out.print("<STATUS>FALSE</STATUS>\n"); } %>