package com.igm.ig3.greetingcard.servlet;

import java.io.File;
import java.io.RandomAccessFile;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.apic.ig3.common.CommonResponse;
import com.apic.ig3.common.DataConnect;
import com.apic.ig3.common.ErrorCode;
import com.apic.ig3.common.InitialCheck;
import com.apic.ig3.common.OutboundSMS;
import com.apic.ig3.common.SessionID;
import com.apic.ig3.db.Ig3DB_sp;
import com.apic.ig3.util.ApicUtil;
import com.igm.ig3.greetingcard.common.IGCConfig;

/**
 * A Main HTTP servlet that handle
 * Listing of new Greeting Cards
 *
 * @author	Tung
 *
 * @version 1.0.0
 */
public class ListGreetingCardServlet extends HttpServlet {
	
	/**
	 * String represent the class name
	 */
	private final static String CLASSNAME = "ListGreetingCardServlet";
	
	
    /**
     * Handles the HTTP GET requests from the content portal. 
     *
     * @param  request             Provides request information for HTTP 
     *                             servlets.
     * @param  response            Provides HTTP-specific functionality in 
     *                             sending a response.
     *
     * @throws ServletException    Defines a general exception a servlet can 
     *                             throw when it encounters difficulty.
     */	
	public void doGet(HttpServletRequest request, HttpServletResponse response) 
	throws ServletException 
	{
			doPost(request, response);
	}

	
    /**
     * Handles the HTTP POST requests from the content portal. 
     *
     * @param  request             Provides request information for HTTP 
     *                             servlets.
     * @param  response            Provides HTTP-specific functionality in 
     *                             sending a response.
     *
     * @throws ServletException    Defines a general exception a servlet can 
     *                             throw when it encounters difficulty.
     */	
	public void doPost(HttpServletRequest request,
                   HttpServletResponse response) throws ServletException 
    {

	    String listingType = "";
	    String listingCount = "";
	    String listingStart = "";
	    String listingSearchValue = "";
	    String listingSearchField = "";
	    String sqlQueryString = "";
	    
	    String imgID1 = "";
	    String imgID2 = "";
	    String imgID3 = "";
	    String polyID = "";
	    String midletName = "";
	    String nickname = "";
	    String category = "";
	    String responseString = "";
	    
	    CommonResponse httpResponse = null;
		
		try
		{
		    httpResponse = new CommonResponse(response, "xml");
		
			listingType = request.getParameter("listtype");
			listingSearchField = request.getParameter("listfield");
			listingSearchValue = request.getParameter("listvalue");			
		    
		    
		    doLog("[ListGreetingCardServlet] - Debug Param");
		    doLog("[ListGreetingCardServlet] - listtype = " + listingType);
		    doLog("[ListGreetingCardServlet] - listfield = " + listingSearchField);
		    doLog("[ListGreetingCardServlet] - listvalue = " + listingSearchValue);

		    if("contentid".equalsIgnoreCase(listingSearchField))
		    {
		    	sqlQueryString = "select * from tblgreetingcard where id =" + listingSearchValue;
		    }
		    else if("all".equalsIgnoreCase(listingSearchField))
		    {
		    	listingCount = request.getParameter("listcount");
		    	//Futher development
		    	doLog("[ListGreetingCardServlet] - Error Param");
		    	httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_PARAM));
		    }
		    else
		    {
		    	//Return Error
		    	doLog("[ListGreetingCardServlet] - Error Param");
		    	httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_PARAM));
		    }
		    	
		    DataConnect dc = new DataConnect();
		    String[] fields = {"img1_id","img2_id","img3_id","poly_id","midlet_name","nickname","category"};
		    doLog("[ListGreetingCardServlet] - DataConnect Start Query");
		    String[] result = dc.querySQL(sqlQueryString, fields);
		    doLog("[ListGreetingCardServlet] - DataConnect End Query");
		    dc.close();
		    
		    if(result != null && result.length == 7)
		    {
			    imgID1 = result[0];
			    imgID2 = result[1];
			    imgID3 = result[2];
			    polyID = result[3];
			    midletName = result[4];
			    nickname = result[5];
			    category = result[6];
			    doLog("[ListGreetingCardServlet] - Result imgID1 = "+imgID1
			    		+ ", imgID2 = "+imgID2
			    		+ ", imgID3 = "+imgID3
			    		+ ", polyID = "+polyID
			    		+ ", midletName = "+midletName
			    		+ ", nickname = "+nickname
			    		+ ", category = "+category);
		    }
		    else
		    {
	    		httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_SYSTEM));
	    		doLog("[ListGreetingCardServlet] - No result");
			    return;
		    }
		    
		    
		    // setup response method
		    responseString = "cat="+category
		    					+ "&imgid1=" +imgID1
		    					+ "&imgid2=" +imgID2
		    					+ "&imgid3=" +imgID3
		    					+ "&polyid=" +polyID
		    					+ "&name=" +midletName
		    					+ "&nickname=" +nickname
		    					+ "&ID=" +listingSearchValue;
		    					

		    httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_NONE) + "&" + responseString );
		    
		}
		catch (Exception exception)
		{
			StackTraceElement[] trace = exception.getStackTrace(); 
			for (int i=0; i < trace.length; i++) 
			{
				doLog(trace[i].toString());
			}
			
			doLog("[ListGreetingCardServlet] - Exception : "+exception.getMessage());
	    	httpResponse.response(
	    			 ErrorCode.getHttpErrorMessage(ErrorCode.ERR_SYSTEM) + " : Exception :" +exception.getMessage());
		}
    }
	

	/**
	 * Log msg into log file
	 * @param msg
	 */
	private void doLog(String msg) 
	{
		try 
		{
			RandomAccessFile f = new RandomAccessFile(IGCConfig.logFile+CLASSNAME+"_"+
		    ApicUtil.TimeStr("yyyyMMdd")+".log", "rw");
		    f.seek(f.length());
		    f.writeBytes(ApicUtil.TimeStr("[HH:mm:ss]") + msg + "\r\n\r\n");
		    f.close();
		} catch(Exception e) 
		{}
	}
}