package com.reallinkbilling.report;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

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.DAO.DailyExpenseDAO;
import com.reallinkbilling.db.GetDBConnection;

public class DailyExpenseReport extends ActionSupport implements SessionAware{

	/**
	 * 
	 */
	private static final long serialVersionUID = -8591113875387565921L;
	
	private HttpSession session;
	private String fromDate;
	private String toDate;
	private List<DailyExpenseDAO> dailyExpenseList = new ArrayList<DailyExpenseDAO>();
	private SessionMap<String,Object> sessionMap; 
	
	private float totalExpenseAmount = 0.0f;
	
	public String execute(){
		String result = "login";
		this.setSession(ServletActionContext.getRequest().getSession(false)); 
		 
	        if(this.getSession()==null || this.getSession().getAttribute("login")==null){ 
	        	addActionMessage("Please Login First !!!");
	        	result = "login";
	        }  
	        else{
	        	
	        	String shopId = (String) this.getSessionMap().get("shopId");
	    		String shopCode = (String) this.getSessionMap().get("shopCode");
	        	
	        	Connection connection = null;
	    		PreparedStatement preparedStatement= null;
	    		ResultSet resultSet = null;
	    	 
	    		String sql = "";
	    		String db = (String) this.getSessionMap().get("db");
	    		
	    		try
	    		{
	    			
					connection = GetDBConnection.getDBConnection(db);
	    			
	    			sql = "SELECT "
	    					+ "entry_id,"
	    					+ "DATE_FORMAT(expense_date,'%d-%m-%Y'),"
	    					+ "expense_details,"
	    					+ "exepnse_amount,"
	    					+ "type_of_payment,"
	    					+ "expense_image "
	    					+ "FROM "
	    					+ "shop_daily_expense_details_master "
	    					+ "WHERE "
	    					+ "shop_id = ? "
	    					+ "AND "
	    					+ "shop_code = ? "
	    					+ "AND "
	    					+ "(expense_date BETWEEN "
	    					+ "STR_TO_DATE(?,'%d-%m-%Y') AND STR_TO_DATE(?,'%d-%m-%Y'))";
	    			
	    			preparedStatement = connection.prepareStatement(sql);
	    			
	    			preparedStatement.setString(1, shopId);
	    			preparedStatement.setString(2, shopCode);
	    			preparedStatement.setString(3, this.getFromDate());
	    			preparedStatement.setString(4, this.getToDate());
	    			
	    			resultSet = preparedStatement.executeQuery();
	    			resultSet.last();
	    			int resultCount = resultSet.getRow();
	    			resultSet.beforeFirst();
	    			
	    		float	totalExpAmount = 0.0f;
	    			
	    			if(resultCount > 0)
	    			{
	    				while(resultSet.next())
	    				{
	    					DailyExpenseDAO dailyExpenseDAO = new DailyExpenseDAO();
	    					dailyExpenseDAO.setId(resultSet.getString(1));
	    					dailyExpenseDAO.setExpenseDate(resultSet.getString(2));
	    					dailyExpenseDAO.setExpenseReason(resultSet.getString(3));
	    					dailyExpenseDAO.setAmount(resultSet.getString(4));
	    					
	    					totalExpAmount += Float.parseFloat(resultSet.getString(4));
	    					
	    					dailyExpenseDAO.setTypeOfPayment(resultSet.getString(5));	    				
	    					dailyExpenseDAO.setExpenseImage(resultSet.getBlob(6));
	    					
	    					this.getDailyExpenseList().add(dailyExpenseDAO);
	    					
	    				}
	    				
	    				this.setTotalExpenseAmount(totalExpAmount);
	    				result = "success";
	    			}
	    			else
	    			{
	    				result = "success";
	    				addActionError("Records not found for given dates!");
	    			}
	    			
	    		}
	    		 catch (SQLException e) {
		    			
		    			result = "error";
		    			
		    			addActionError(e.getErrorCode()+" || "+e.getMessage() +" || Something Went Wrong!");
		    		} catch (IOException e) {
		    			result = "error";
		    			
		    			addActionError(e.getMessage()+" || "+e.getCause()+" || Something Went Wrong!");
		    		} 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) {}
		    			}
		    			
		    		}
	        	
	        }
	        
	        return result;
	}

	@Override
	public void validate() {
		
		if(this.getFromDate().equals("") && this.getToDate().equals(""))
		{
			addActionError("Please select dates!");
		}
	}
	public HttpSession getSession() {
		return session;
	}

	public void setSession(HttpSession session) {
		this.session = session;
	}

	public String getFromDate() {
		return fromDate;
	}

	public void setFromDate(String fromDate) {
		this.fromDate = fromDate;
	}

	public String getToDate() {
		return toDate;
	}

	public void setToDate(String toDate) {
		this.toDate = toDate;
	}

	public List<DailyExpenseDAO> getDailyExpenseList() {
		return dailyExpenseList;
	}

	public void setDailyExpenseList(List<DailyExpenseDAO> dailyExpenseList) {
		this.dailyExpenseList = dailyExpenseList;
	}
	
	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;  
	}

	public float getTotalExpenseAmount() {
		return totalExpenseAmount;
	}

	public void setTotalExpenseAmount(float totalExpenseAmount) {
		this.totalExpenseAmount = totalExpenseAmount;
	}
	
	
	
}
