package com.reallinkbilling.render;

import java.io.IOException;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;
import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.db.GetDBConnection;

public class RenderExpenseImage extends ActionSupport implements SessionAware{

	
	/**
	 * 
	 */
	private static final long serialVersionUID = -8917987362136710722L;
	private HttpSession session;
	private SessionMap<String,Object> sessionMap;  

	
	public void rederExpenseImage(){
		// TODO Auto-generated method stub
		HttpServletResponse response = ServletActionContext.getResponse();
		HttpServletRequest request = ServletActionContext.getRequest();
		
		String id = request.getParameter("id");
		
		session=ServletActionContext.getRequest().getSession(false); 
		Connection connection = null;
  		PreparedStatement preparedStatement= null;	
  		ResultSet resultSet = null;
  		
  		String sql = "";
  		String db = (String) this.getSessionMap().get("db");
  		
  		String shopId = (String) this.getSessionMap().get("shopId");
		String shopCode = (String) this.getSessionMap().get("shopCode");
		
  		try
  		{
  		
  		if(db!=null)
  		{
  			
			connection = GetDBConnection.getDBConnection(db);
  			
  			sql = "SELECT "
  					+ "expense_image "
  					+ "FROM "
  					+ "shop_daily_expense_details_master "
  					+ "WHERE "
  					+ "shop_id = ? "
  					+ "AND "
  					+ "shop_code = ? "
  					+ "AND "
  					+ "entry_id = ? ";
  			
  			preparedStatement = connection.prepareStatement(sql);
  			preparedStatement.setString(1, shopId);
  			preparedStatement.setString(2, shopCode);
  			preparedStatement.setString(3,id);
  			resultSet = preparedStatement.executeQuery();
  			if(resultSet.next())
  			{
	   			Blob ph = resultSet.getBlob("expense_image");
				byte data[] = ph.getBytes(1, (int) ph.length());
				OutputStream out = response.getOutputStream();
				out.write(data);
				out.flush();
				out.close();
  			}
  		}
  		}catch (SQLException e) {
			addActionError(e.getErrorCode()+ "| Connection Error !!!");
			
		}catch (IOException e) {
			addActionError(e.getMessage()+ "| Connection Error !!!");
		}
		finally
		{
			if(resultSet != null)
			{
				try {
					resultSet.close();
				} catch (SQLException e) {
					
				}
			}
			if(preparedStatement != null)
			{
				try {
					
					preparedStatement.close();
				} catch (SQLException e) {
					
				}
			}
			if(connection != null)
			{
				try {
					
					connection.close();
				} catch (SQLException e) {
					
					e.printStackTrace();
				}
			}
			
		}
		
		
	}
	
	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}

 
	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}

	

}