<%@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");
		}	
%>