package group_head_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseMethods;
import main_package.DataBaseConnection;

import org.primefaces.context.RequestContext;
@ManagedBean(name="viewEditDeleteIncome")
@ViewScoped
public class ViewEditDeleteIncomeBean implements Serializable
{
    private static final long serialVersionUID = 1L;
    ArrayList<IncomeList>iList;
    IncomeList selectedIncome;
    String selectedCategory,strIncomeDate,transferTo,description,paymentMode,chequeNo,bankBranch,bankName,label;
    Date startDate=new Date(),endDate=new Date();
    boolean showCheque;
    double amount;
    
    public ViewEditDeleteIncomeBean()
    {
    	HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
    	Connection conn=DataBaseConnection.JAVAConnection();
    	startDate.setDate(1);
    	iList=new  DataBaseIncomeExpense().allIncomeList(branchId,startDate,endDate,conn);
    	try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
    }
    
	public void searchIncome()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		iList=new  DataBaseIncomeExpense().allIncomeList(branchId,startDate,endDate,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}

	public void viewDetails()
	{
		selectedCategory=selectedIncome.getCategory();
		paymentMode=selectedIncome.getPaymentMode();
		amount=selectedIncome.getAmount();
		strIncomeDate=selectedIncome.getStrIncomeDate();
		transferTo=selectedIncome.getTransferToBankName();
		if(paymentMode.equals("Cash"))
		{
			showCheque=false;
			
		}
		else if(paymentMode.equals("Cheque"))
		{
			showCheque=true;
			chequeNo=selectedIncome.getChequeNo();
			bankName=selectedIncome.getBankName();
			bankBranch=selectedIncome.getBankBranch();
			description=selectedIncome.getDescription();
		}
	}
	
	public void printVoucherDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", selectedIncome.getVoucherNo());
		ss.setAttribute("expDate", selectedIncome.getIncomeDate());
		ss.setAttribute("amount", String.valueOf(selectedIncome.getAmount()));
		ss.setAttribute("vchtype", "Credit");
		ss.setAttribute("payTo", selectedIncome.getDescription());
		ss.setAttribute("being", selectedIncome.getItem_name());
		ss.setAttribute("payMode", selectedIncome.getPaymentMode());
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}
	
	public void print()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("list", iList);
		ss.setAttribute("start", new SimpleDateFormat("dd/MM/yyyy").format(startDate));
		ss.setAttribute("end", new SimpleDateFormat("dd/MM/yyyy").format(endDate));
		
		RequestContext.getCurrentInstance().execute("window.open('printExtraIncome.xhtml')");
	}
	
	public void deleteSelectedIncome()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		String pMode=selectedIncome.getPaymentMode();
		Double amt=selectedIncome.getAmount();
		double oldamt=selectedIncome.getOldAmount();
		String bankId=selectedIncome.getTransferBank();
		String item=selectedIncome.getItem_name();
		String category=selectedIncome.getCategory();
		int i=new DataBaseIncomeExpense().deleteIncome(selectedIncome);
		if(i>=1)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			iList=new DataBaseIncomeExpense().allIncomeList(branchId,startDate, endDate,conn);
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Income Deleted successfully"));
			 if(pMode.equalsIgnoreCase("Cash") && ( bankId==null || bankId.equals("N/A")))
	            {
	            	new DataBaseMethods().decreaseCapitalCompanyAmount(branchId,amt);
	            }
	            else if(pMode.equalsIgnoreCase("Cash") && (!bankId.equals("N/A") && bankId!=null))
	            {
	            	new DataBaseMethods().decreaseBankBalance(bankId, amt,conn);
	            }
	            else if(pMode.equalsIgnoreCase("Cheque"))
	            {
	            	new DataBaseMethods().decreaseBankBalance(bankId, amt,conn);
	            }
			 
			 if(category.equalsIgnoreCase("Fixed_Asset_Cr") && oldamt>0)
			 {
				 new DataBaseMethods().updateStatusForIncomeTable(branchId,item,"Fixed_Asset_Dr");
			 }
			 try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An error found, try again"));
		}
	}

	public ArrayList<IncomeList> getiList() {
		return iList;
	}

	public void setiList(ArrayList<IncomeList> iList) {
		this.iList = iList;
	}

	public IncomeList getSelectedIncome() {
		return selectedIncome;
	}
	public void setSelectedIncome(IncomeList selectedIncome) {
		this.selectedIncome = selectedIncome;
	}

	public String getSelectedCategory() {
		return selectedCategory;
	}

	public void setSelectedCategory(String selectedCategory) {
		this.selectedCategory = selectedCategory;
	}

	public String getStrIncomeDate() {
		return strIncomeDate;
	}

	public void setStrIncomeDate(String strIncomeDate) {
		this.strIncomeDate = strIncomeDate;
	}

	

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public String getBankBranch() {
		return bankBranch;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public boolean isShowCheque() {
		return showCheque;
	}

	public String getTransferTo() {
		return transferTo;
	}

	public void setTransferTo(String transferTo) {
		this.transferTo = transferTo;
	}

	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}
}
