/**
 * @author      Dennis W. Gichangi <dennis@openbaraza.org>
 * @version     2011.0329
 * @since       1.6
 * website		www.openbaraza.org
 * The contents of this file are subject to the GNU Lesser General Public License
 * Version 3.0 ; you may use this file in compliance with the License.
 */
package org.baraza.web;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Map;
import java.util.Enumeration;
import java.util.logging.Logger;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.baraza.xml.BElement;
import org.baraza.DB.BJSONQuery;

public class BJSONData extends HttpServlet {
	Logger log = Logger.getLogger(BJSONData.class.getName());

	public void doPost(HttpServletRequest request, HttpServletResponse response)  {
		doGet(request, response);
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response) {
		ServletContext context = getServletContext();
		HttpSession webSession = request.getSession(true);
		String xmlcnf = (String)webSession.getAttribute("xmlcnf");
		String ps = System.getProperty("file.separator");
		String xmlfile = context.getRealPath("WEB-INF") + ps + "configs" + ps + xmlcnf;
		String dbconfig = "java:/comp/env/jdbc/database";
		String projectDir = context.getInitParameter("projectDir");
		if(projectDir != null) xmlfile = projectDir + ps + "configs" + ps + xmlcnf;
		
		/*Enumeration e = request.getParameterNames();
        while (e.hasMoreElements()) {
			String ce = (String)e.nextElement();
			System.out.println(ce + ":" + request.getParameter(ce));
		}*/
		
		BWeb web = new BWeb(dbconfig, xmlfile);
		web.init(request);
		BElement view = web.getView();
		//System.out.println("BASE 1010 : " + view.toString());
		
		String sortSN = "S" + web.getViewKey();
		String sortby = request.getParameter("sidx");
		if(sortby != null && sortby.trim().equals("")) sortby = null;
		if(sortby != null) {
			if(sortby.equals("CL")) sortby = view.getAttribute("keyfield") + "  " + request.getParameter("sord");
			else sortby = sortby + "  " + request.getParameter("sord");
			
			webSession.setAttribute(sortSN, sortby);
		} else if(webSession.getAttribute(sortSN) != null) {
			sortby = (String)webSession.getAttribute(sortSN);
		}
//System.out.println("JSON sort : " + sortby);
		
		Map<String, String> whereParams = web.getWhere(request);
		String wheresql = whereParams.get("wheresql");
//System.out.println("JSON Where :" + wheresql);
		
		String pageNum = request.getParameter("page");
		if(pageNum == null) pageNum = "0";
		Integer pageStart = new Integer(0);
		Integer pageSize = new Integer(0);
		try {
			if(request.getParameter("rows") == null) pageSize = new Integer(30);
			else pageSize = new Integer(request.getParameter("rows"));
			pageStart = new Integer(pageNum) * pageSize;
		} catch(NumberFormatException ex) { 
			log.severe("Page size error " + ex);
		}
		
		if(view.getAttribute("superuser", "false").equals("true")) {
			if(!web.getUser().getSuperUser()) return;
		}
		
		boolean secured = true;
		String rUrl = request.getRequestURI();
		if(rUrl == null) rUrl = "";
		if(rUrl.contains("jsongeneral")) {
			if(!view.getAttribute("secured", "false").equals("true")) secured = false;
		}
		
		BJSONQuery JSONQuery = new BJSONQuery(web.getDB(), view, wheresql, sortby, pageStart, pageSize);
		String JSONStr = "";
		if(secured) JSONStr = JSONQuery.getJSONData(web.getViewKey(), false);

		try {
			PrintWriter out = response.getWriter();
			response.setContentType("application/json;charset=\"utf-8\"");
			
			out.print(JSONStr);
			
		} catch(IOException ex) {
			System.out.println("ERROR : Cannot get writer from response : " + ex);
		}
		
		web.close();
	}
}