package group_head_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.BankInfo;
import main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodsDuplicate;
import main_package.HeaderBean;

import org.primefaces.context.RequestContext;
@ManagedBean(name="expense")
@ViewScoped

// This Class Contain the Form of Add New Fixed Assets, Fixed Deposit and Other Expenses.  
public class ExpenseBean implements Serializable
{
	private static final long serialVersionUID = 1L;
    
    ArrayList<SelectItem> expenseCategoryList,modeList;
    Date expenseDate,chequeDate;
    String amount,itemName="",description,reqMessage,paymentMode,chequeNo,bankBranch,bankName,selectedCategoy,label,itemLabel
    ,fixedDepositAmount="", noOfItem="1", fixedDepositBank="",fixedDepositAccNo="",fixedDepositRate="",fixedDepositTime="",fixedDepositAddress="",otherExpenseCategory="";
	int itemRate;
    boolean showFixedDeposit,showCheque,showFields,itemRender,renderOther,showBank,stockField,showFdrField;
    ArrayList<SelectItem> bankList,otherList,itemList;
	BankInfo bank_info;
	String newItemName, voucherNo;
	DataBaseMethods dbm=new DataBaseMethods();
	
	public ExpenseBean() 
    {
		//expenseCategoryList=new DataBaseMethodsIncome_Expense().allExpenseCategory();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selectedCategoy=(String)ss.getAttribute("expenseCategory");
		int branchId = (int) ss.getAttribute("branchId");
		expenseDate=new Date();
	/*	showFields=true;
		itemRender=false;
		showFixedDeposit=false;*/
		Connection conn=DataBaseConnection.JAVAConnection();
		
		HeaderBean hh=new HeaderBean();
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		
		
		voucherNo=dbm.generateVoucherNo(branchId,"expense_table",conn);
		
		if(selectedCategoy.equals("Fixed_Asset_Dr"))
		{
			itemList=dbm.groupHeadSelectList(conn,"Assets");
			itemLabel="Item Name";
			reqMessage="Please Enter Item Name";
			showFields=false;
			itemRender=true;
			stockField=true;
			renderOther=false;
			showFixedDeposit=false;
			showFdrField=false;
			
		}
		else if(selectedCategoy.equals("Fixed_Deposit_Dr"))
		{
			itemLabel="FDR No.";
			reqMessage="Please Enter FDR No.";
			showFixedDeposit=true;
			showFields=false;
			itemRender=false;
			stockField=false;
			showFdrField=true;
			
		}
		else if(selectedCategoy.equals("Other_Dr"))
		{
			otherList=dbm.groupHeadSelectList(conn, "Expense");
			itemLabel="Item Name";
			reqMessage="Please Enter Item Name";
			showFields=true;
			itemRender=false;
			renderOther=true;
			stockField=false;
			showFixedDeposit=false;
			showFdrField=false;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
    }
	
	public void calculateTotal()
	{
		amount="0";
		amount=String.valueOf(Integer.parseInt(noOfItem)*itemRate);
	}
	
	public void checkBank()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		bank_info=dbm.obtainBankInfoById(bankName,conn);
		bankBranch=bank_info.getBank_branch();
	/*	address=bank_info.address;
		accNo=bank_info.acc_no;*/
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void checkExpenseCategory()
	{
		
	}
	
	public void addExpense() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		voucherNo=dbm.generateVoucherNo(branchId,"expense_table",conn);
		double balance=dbm.currentBankBalance(bankName, conn);
		if(!paymentMode.equalsIgnoreCase("Cash"))
		{
			if(balance<=0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Bank Balance is Not Sufficient for This Transaction. Balance :"+balance));
			}
			
		}
		
		if(selectedCategoy.equals("Fixed_Deposit_Dr"))
		{
			boolean checkFD=new DataBaseMethodsDuplicate().checkDuplicateFDRExpense(branchId,itemName,conn);
			if(checkFD==true)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Duplicate FD No.Please Try With a New/Unique FD No."));
			}
			else
			{
				
				int i=new DataBaseIncomeExpense().addFixedDepositExpense(branchId,expenseDate,fixedDepositAmount,fixedDepositBank,fixedDepositAccNo,fixedDepositRate,fixedDepositTime,
						fixedDepositAddress,itemName,paymentMode,chequeNo,bankBranch,bankName,chequeDate,conn);
				if(i>=1)
				{
				    FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Fixed Deposit Expense Added Successfully"));
				    if(paymentMode.equalsIgnoreCase("Cash"))
				    {
				    	dbm.increaseSharedCompanyAmount(branchId,Double.valueOf(fixedDepositAmount),conn);
				    }
				    else if(paymentMode.equalsIgnoreCase("Bank Deduction"))
				    {
				    	dbm.decreaseBankBalance(bankName, Double.valueOf(fixedDepositAmount),conn);
				    }
					amount=description=paymentMode=chequeNo=bankBranch=bankName=label=fixedDepositAccNo=fixedDepositAddress
							=fixedDepositAmount=fixedDepositBank=fixedDepositRate=fixedDepositTime="";
					showCheque=showFixedDeposit=false;
					showFields=true;
					itemRender=false;
					expenseDate=new Date();
					itemName="";
					try {
						conn.close();
					} catch (Exception e) {
						// TODO: handle exception
					}
					FacesContext.getCurrentInstance().getExternalContext().redirect("addExpense.xhtml");
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
				}
			}
			
		}
		else
		{
			boolean checkItem=false;
			if(selectedCategoy.equals("Fixed_Asset_Dr"))
			{
				checkItem=false;
			}
			
			if(checkItem==true)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Duplicate Item Name.Please Try With a New/Unique Item Name."));
			}
			else
			{
				int x=new DataBaseIncomeExpense().addExpense(branchId,expenseDate,selectedCategoy,paymentMode,amount,chequeNo,bankBranch,bankName,chequeDate,
						description,itemName, noOfItem, voucherNo, itemRate,"0","",""); 
				if(x>=1)
				{
				    FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Expense Added Successfully"));
				    if(paymentMode.equalsIgnoreCase("Cash"))
				    {
				    	dbm.increaseSharedCompanyAmount(branchId,Double.valueOf(amount),conn);
				    }
				    else if(paymentMode.equalsIgnoreCase("Bank Deduction"))
				    {
				    	dbm.decreaseBankBalance(bankName, Double.valueOf(amount),conn);
				    }
				   printVoucherDetail();
				    amount=description=paymentMode=chequeNo=bankBranch=bankName=selectedCategoy=label=itemName="";
					showCheque=false;
					expenseDate=new Date();
					showFields=true;
					itemRender=false;
					showFixedDeposit=false;
					itemName="";
					try {
						conn.close();
					} catch (Exception e) {
						// TODO: handle exception
					}
					
					FacesContext.getCurrentInstance().getExternalContext().redirect("addExpense.xhtml");
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
				}
			}
			
		}
		
		
	}
	
	public void checkPaymentMode()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			showCheque=false;
			showBank=false;
		}
		else if(paymentMode.equalsIgnoreCase("Bank Deduction"))
		{
			showBank=true;
			showCheque=false;
		}
		else
		{
			label=paymentMode;
			showCheque=true;
			showBank=false;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}

	public void printVoucherDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", voucherNo);
		ss.setAttribute("expDate", expenseDate);
		ss.setAttribute("amount", amount);
		ss.setAttribute("vchtype", "Debit");
		ss.setAttribute("payTo", description);
		ss.setAttribute("being", itemName);
		ss.setAttribute("payMode", paymentMode);
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}
	
	public Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	public ArrayList<SelectItem> getExpenseCategoryList() {
		return expenseCategoryList;
	}
	public void setExpenseCategoryList(ArrayList<SelectItem> expenseCategoryList) {
		this.expenseCategoryList = expenseCategoryList;
	}
	public Date getExpenseDate() {
		return expenseDate;
	}
	public void setExpenseDate(Date expenseDate) {
		this.expenseDate = expenseDate;
	}
	public String getAmount() {
		return amount;
	}
	public void setAmount(String 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 boolean isShowBank() {
		return showBank;
	}

	public void setShowBank(boolean showBank) {
		this.showBank = showBank;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}
	public String getBankName() {
		return bankName;
	}
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}
	public boolean isShowCheque() {
		return showCheque;
	}
	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}
	public String getSelectedCategoy() {
		return selectedCategoy;
	}
	public void setSelectedCategoy(String selectedCategoy) {
		this.selectedCategoy = selectedCategoy;
	}
	public String getLabel() {
		return label;
	}
	public void setLabel(String label) {
		this.label = label;
	}

	public boolean isShowFields() {
		return showFields;
	}

	public void setShowFields(boolean showFields) {
		this.showFields = showFields;
	}

	public boolean isItemRender() {
		return itemRender;
	}

	public void setItemRender(boolean itemRender) {
		this.itemRender = itemRender;
	}

	public String getItemName() {
		return itemName;
	}

	public void setItemName(String itemName) {
		this.itemName = itemName;
	}

	public boolean isShowFixedDeposit() {
		return showFixedDeposit;
	}

	public void setShowFixedDeposit(boolean showFixedDeposit) {
		this.showFixedDeposit = showFixedDeposit;
	}

	public String getReqMessage() {
		return reqMessage;
	}

	public void setReqMessage(String reqMessage) {
		this.reqMessage = reqMessage;
	}

	public String getItemLabel() {
		return itemLabel;
	}

	public void setItemLabel(String itemLabel) {
		this.itemLabel = itemLabel;
	}

	public String getFixedDepositAmount() {
		return fixedDepositAmount;
	}

	public void setFixedDepositAmount(String fixedDepositAmount) {
		this.fixedDepositAmount = fixedDepositAmount;
	}

	public String getFixedDepositBank() {
		return fixedDepositBank;
	}

	public void setFixedDepositBank(String fixedDepositBank) {
		this.fixedDepositBank = fixedDepositBank;
	}

	public String getFixedDepositAccNo() {
		return fixedDepositAccNo;
	}

	public void setFixedDepositAccNo(String fixedDepositAccNo) {
		this.fixedDepositAccNo = fixedDepositAccNo;
	}

	public String getFixedDepositRate() {
		return fixedDepositRate;
	}

	public void setFixedDepositRate(String fixedDepositRate) {
		this.fixedDepositRate = fixedDepositRate;
	}

	public String getFixedDepositTime() {
		return fixedDepositTime;
	}

	public void setFixedDepositTime(String fixedDepositTime) {
		this.fixedDepositTime = fixedDepositTime;
	}

	public String getFixedDepositAddress() {
		return fixedDepositAddress;
	}

	public void setFixedDepositAddress(String fixedDepositAddress) {
		this.fixedDepositAddress = fixedDepositAddress;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}

	public boolean isRenderOther() {
		return renderOther;
	}

	public void setRenderOther(boolean renderOther) {
		this.renderOther = renderOther;
	}

	public ArrayList<SelectItem> getOtherList() {
		return otherList;
	}

	public void setOtherList(ArrayList<SelectItem> otherList) {
		this.otherList = otherList;
	}

	public String getOtherExpenseCategory() {
		return otherExpenseCategory;
	}

	public void setOtherExpenseCategory(String otherExpenseCategory) {
		this.otherExpenseCategory = otherExpenseCategory;
	}

	public ArrayList<SelectItem> getModeList() {
		return modeList;
	}

	public void setModeList(ArrayList<SelectItem> modeList) {
		this.modeList = modeList;
	}

	public ArrayList<SelectItem> getItemList() {
		return itemList;
	}

	public void setItemList(ArrayList<SelectItem> itemList) {
		this.itemList = itemList;
	}

	public String getNewItemName() {
		return newItemName;
	}

	public void setNewItemName(String newItemName) {
		this.newItemName = newItemName;
	}

	public boolean isStockField() {
		return stockField;
	}

	public void setStockField(boolean stockField) {
		this.stockField = stockField;
	}

	public String getNoOfItem() {
		return noOfItem;
	}

	public void setNoOfItem(String noOfItem) {
		this.noOfItem = noOfItem;
	}

	public boolean isShowFdrField() {
		return showFdrField;
	}

	public void setShowFdrField(boolean showFdrField) {
		this.showFdrField = showFdrField;
	}

	public int getItemRate() {
		return itemRate;
	}

	public void setItemRate(int itemRate) {
		this.itemRate = itemRate;
	}

	public String getVoucherNo() {
		return voucherNo;
	}

	public void setVoucherNo(String voucherNo) {
		this.voucherNo = voucherNo;
	}
	
	
}
