package xin.glue.ui.Z;

import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.text.SimpleDateFormat;

import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import xin.glue.ui.common.PosDBEngine;

import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.vo.PosRowSet;

public class PosReports extends PosDBEngine {
	public String runActivity(PosContext ctx) {
		HttpServletRequest request = (HttpServletRequest)ctx.findRequestAttr("HttpServletRequest");
		HttpSession session = request.getSession();
		if (session.getAttribute("username") != null) {
			ctx.put("USER_CD", session.getAttribute("username"));
			ctx.put("USER_PW", session.getAttribute("password"));
			session.removeAttribute("username");
			session.removeAttribute("password");
		}

		Initialize(false);
		setParamMap(ctx, "sqlkey", "param");
		PosRowSet rowSet = (PosRowSet)Execute(ctx, "sqlkey", "param");

		if (rowSet != null && rowSet.hasNext()) {
	        String resultkey = getProperty("resultkey");
	        if (resultkey == null) resultkey = "ListResult_0";
			Map row = new HashMap();
	        for (Iterator itr = rowSet.next().getAttributes().entrySet().iterator(); itr.hasNext();) {
	        	Map.Entry entry = (Map.Entry)itr.next();
	        	row.put(entry.getKey(), entry.getValue());
	        }
	        row.put("DEPT_CD", "00000000");
			ctx.put(resultkey, row);
			HttpServletResponse response = (HttpServletResponse)ctx.findRequestAttr("HttpServletResponse");
			Cookie cookie = new Cookie("REG_ADDERSS", request.getRemoteAddr() + '|' + ((String[])ctx.get("REMOTE_ADDRESS"))[0].replace(';', ','));
			cookie.setMaxAge(-1);
			response.addCookie(cookie);
			cookie = new Cookie("REG_DATE", (new SimpleDateFormat("yyyyMMddkkmmss")).format(new Date()));
			cookie.setMaxAge(-1);
			response.addCookie(cookie);
			cookie = new Cookie("REG_ID", (String)ctx.get("USER_CD"));
			cookie.setMaxAge(-1);
			response.addCookie(cookie);
		}
		return PosBizControlConstants.SUCCESS;
	}
}