package main_package;

import group_head_package.DataBaseIncomeExpense;

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;

@ManagedBean(name="instantLoan")
@ViewScoped
public class InstantLoanBean implements Serializable
{
	String name, description, selectedName, paymentMode,chequeNo,bankBranch,bankName, label;
	ArrayList<SelectItem> list, bankList, returnList;
	boolean showCheque, showExtraAmt;
	double amount, loanAmount, extraAmount;
	int no;
	Date loanDate=new Date(), chequeDate;
	BankInfo bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	int branchId;
	
	public InstantLoanBean() 
	{
		HttpSession ss0=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss0.getAttribute("branchId");
		no=obj.nextNo("lender",branchId);
		list=obj.allBorrowerOrLenderList(branchId,"lender");
		
		/// for return List having only balance, required of moneymoon 08-July-2019
		if(list.size()>0)
		{
			returnList=new ArrayList<>();
			for(SelectItem ss: list)
			{
				int cr=obj.checkInstantLoanAmount(branchId,String.valueOf(ss.getValue()), "credit");
				int dr=obj.checkInstantLoanAmount(branchId,String.valueOf(ss.getValue()), "debit");
				int bal=cr-dr;
				if(bal>0)
				{
					returnList.add(ss);
				}
			}
		}
			
	}
	
	public void checkPaymentMode()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			showCheque=false;
			showExtraAmt=true;
		}
		
		else
		{
			bankList=new ArrayList<>();
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			label=paymentMode;
			showCheque=true;
			showExtraAmt=false;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}	
	
	
	public void checkBank()
	{
		Connection con=DataBaseConnection.JAVAConnection();
		bank_info=obj.obtainBankInfoById(bankName,con);
		//bankBranch=bank_info.getBank_branch();
	/*	address=bank_info.address;
		accNo=bank_info.acc_no;*/
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	public void checkAmount()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		int cr=obj.checkInstantLoanAmount(branchId,selectedName, "credit");
		int dr=obj.checkInstantLoanAmount(branchId,selectedName, "debit");
		loanAmount=cr-dr;
	}

	
	public String addLoan()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Greater than zero. Please Check..."));
		}
		else
		{
			int i=obj.addInstantLoan(branchId,selectedName, amount, description, loanDate, "credit", chequeNo, chequeDate, bankName, bankBranch, paymentMode);
			if(i>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Instant Loan Add Sucessfully"));
				no=obj.nextNo("lender",branchId);
				if(paymentMode.equalsIgnoreCase("Cash"))
				{
				  	obj.decreaseCapitalCompanyAmount(branchId,amount);
				}
				return "instantLoan";
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
			}
		}
		
		return "";
	}
	
	public String addReturnLoan()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection con=DataBaseConnection.JAVAConnection();
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Greater than zero. Please Check..."));
		}
		else if(amount>loanAmount)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("You can return only "+loanAmount));
		}
		else
		{
			int i=obj.addInstantLoan(branchId,selectedName, amount, description, loanDate, "debit", chequeNo, chequeDate, bankName, bankBranch, paymentMode);
			if(i>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Instant Loan Return Sucessfully"));
				no=obj.nextNo("lender",branchId);
				if(paymentMode.equalsIgnoreCase("Cash"))
				{
				  	obj.increaseCompanyCapitalAmount(branchId,amount,con);
				}
				
				if(extraAmount>0 && paymentMode.equalsIgnoreCase("Cash"))
				{
					String voucherNo=new DataBaseMethods().generateVoucherNo(branchId,"income_table", con);
					int j=new DataBaseIncomeExpense().addIncome(branchId,loanDate, "Other_Cr", paymentMode, String.valueOf(extraAmount), chequeNo, bankBranch, bankName, 
							chequeDate, description, "Instant Loan Interest", 0, "N/A", "0", 0, "", "", voucherNo, "",
							0, "active","");
					if(j>0)
					{
						obj.increaseCompanyCapitalAmount(branchId,extraAmount,con);
					}
				}
				
				return "returnInstantLoan";
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
				
			}
		}
		
		return "";
	}
	
	
	public String addName()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		int i=obj.addBorrowerLenderName(no,name,"lender",branchId);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Name Add Sucessfully"));
			no=obj.nextNo("lender",branchId);
			
			return "instantLoan";
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
			return "";
		}
		
	}
	
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public ArrayList<SelectItem> getList() {
		return list;
	}

	public void setList(ArrayList<SelectItem> list) {
		this.list = list;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public int getNo() {
		return no;
	}

	public void setNo(int no) {
		this.no = no;
	}

	public String getSelectedName() {
		return selectedName;
	}

	public void setSelectedName(String selectedName) {
		this.selectedName = selectedName;
	}

	

	public double getLoanAmount() {
		return loanAmount;
	}

	public void setLoanAmount(double loanAmount) {
		this.loanAmount = loanAmount;
	}

	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 ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public boolean isShowCheque() {
		return showCheque;
	}

	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}

	public Date getLoanDate() {
		return loanDate;
	}

	public void setLoanDate(Date loanDate) {
		this.loanDate = loanDate;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public double getExtraAmount() {
		return extraAmount;
	}

	public void setExtraAmount(double extraAmount) {
		this.extraAmount = extraAmount;
	}

	public boolean isShowExtraAmt() {
		return showExtraAmt;
	}

	public void setShowExtraAmt(boolean showExtraAmt) {
		this.showExtraAmt = showExtraAmt;
	}

	public ArrayList<SelectItem> getReturnList() {
		return returnList;
	}

	public void setReturnList(ArrayList<SelectItem> returnList) {
		this.returnList = returnList;
	}
	
	
	
		
}
