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
 * Updation of new Greeting Cards
 *
 * @author	Tung
 *
 * @version 1.0.0
 */
public class UpdateGreetingCardServlet extends HttpServlet {
	
	/**
	 * String represent the class name
	 */
	private final static String CLASSNAME = "UpdateGreetingCardServlet";

	private static Ig3DB_sp ig3db_sp = null;
	
	public void init(ServletConfig config) 
	{
		try 
		{
			super.init(config);
			ig3db_sp = new Ig3DB_sp();
			ig3db_sp.Connect();
		} 
		catch(Exception e)
		{}
	}
	
    /**
     * 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 nickname = "";
	    String password = "";
	    String category = "";
	    String permission = "";
	    String imgid1 = "";
	    String imgid2 = "";
	    String imgid3 = "";
	    String polyid = "";
	    String midletName = "";
	    String uid = "";
	    String sqlUpdateString = "";
	    CommonResponse httpResponse = null;
		
		try
		{
			uid = request.getParameter("id");
		    nickname = request.getParameter("nick");
		    password = request.getParameter("pass");
		    category = request.getParameter("cat");
		    permission = request.getParameter("perm");
		    imgid1 = request.getParameter("imgid1");
		    imgid2 = request.getParameter("imgid2");
		    imgid3 = request.getParameter("imgid3");
		    polyid = request.getParameter("polyid");
		    midletName = request.getParameter("name");
		    
		    
		    doLog("[UpdateGreetingCardServlet] - Debug Param");
		    doLog("[UpdateGreetingCardServlet] - uid = " + uid);
		    doLog("[UpdateGreetingCardServlet] - nickname = " + nickname);
		    doLog("[UpdateGreetingCardServlet] - password = " + password);
		    doLog("[UpdateGreetingCardServlet] - category = " + category);
		    doLog("[UpdateGreetingCardServlet] - permission = " + permission);
		    doLog("[UpdateGreetingCardServlet] - imgid1 = " + imgid1);
		    doLog("[UpdateGreetingCardServlet] - imgid2 = " + imgid2);
		    doLog("[UpdateGreetingCardServlet] - imgid3 = " + imgid3);
		    doLog("[UpdateGreetingCardServlet] - polyid = " + polyid);
		    doLog("[UpdateGreetingCardServlet] - midletName = " + midletName);
		    
		    // setup response method
		    httpResponse = new CommonResponse(response, "xml");

		    if(category == null || category.length() == 0
		    		|| imgid1 == null || imgid1.length() == 0
		    		|| imgid2 == null || imgid2.length() == 0
		    		|| imgid3 == null || imgid3.length() == 0
		    		|| polyid == null || polyid.length() == 0
		    		|| uid == null || uid.length() == 0
		    		|| midletName == null || midletName.length() == 0)
		    {
		    	httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_PARAM));
		    	doLog("[UpdateGreetingCardServlet] - Error Param");
				return;
		    }
		    
		    doLog("[UpdateGreetingCardServlet] - Verify mandatory param");
		    if(nickname == null || password == null || !CheckUser(nickname, password)) 
		    {
		    	httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_LOGIN));
		    	doLog("[UpdateGreetingCardServlet] - Error Login");
		    	return;
		    }
		    
		    doLog("[UpdateGreetingCardServlet] - Update to greetingcard table");
		    sqlUpdateString = "update tblgreetingcard"
		    				+ " set img1_id = "+imgid1
		    				+ ", img2_id = "+imgid2
		    				+ ", img3_id = "+imgid3
		    				+ ", poly_id = "+polyid
		    				+ ", midlet_name = '"+midletName+"'"
		    				+ ", category = '"+category+"'"
		    				+ " where id = "+uid;
		    				
		    DataConnect dc = new DataConnect();
		    doLog("[UpdateGreetingCardServlet] - DataConnect Start Query");
		    boolean status = dc.updateSQL(sqlUpdateString);
		    doLog("[UpdateGreetingCardServlet] - DataConnect End Query");
		    dc.close();

		    doLog("[UpdateGreetingCardServlet] - Update to greetingcard table done, Status = "+status);
		    
		    if(!status) 
		    {
		    	httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_CONTENT));
		    	doLog("[UpdateGreetingCardServlet] - Error Content");
		    	return;
		    }

		    httpResponse.response(ErrorCode.getHttpErrorMessage(ErrorCode.ERR_NONE) + "&ID=" + uid );
		    
		}
		catch (Exception exception)
		{
			StackTraceElement[] trace = exception.getStackTrace(); 
			for (int i=0; i < trace.length; i++) 
			{
				doLog(trace[i].toString());
			}
			
			doLog("[UpdateGreetingCardServlet] - Exception : "+exception.getMessage());
	    	httpResponse.response(
	    			 ErrorCode.getHttpErrorMessage(ErrorCode.ERR_SYSTEM) + " : Exception :" +exception.getMessage());
		}
    }
	
	/**
	 * Validate user login information
	 * @param sNick
	 * @param sPass
	 * @return
	 * @throws Exception
	 */
	private boolean CheckUser(String sNick, String sPass) throws Exception 
	{
		return ig3db_sp.CheckUser(sNick, sPass);
	}
	
	
	/**
	 * 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) 
		{}
	}
}