package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

@ManagedBean(name="odLoanReturn")
@ViewScoped
public class OdLoanReturnBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	LoanInfo viewPrsnlLoan;
	Date OdReturnDate=new Date();
	Date chequeDate;
	UserInfo user_info,guarantorUser1,guarantorUser2;
	String guarantor1,guarantor2,user_no,transfer,strOffcDate,plan_no,submittedBankName,frequencyLabel,label,scheme_type,strMatDate,planSchemeTypeForOd,paymentMode,bankName,bankBranch,chequeNo;
	ArrayList<UserInfo>userList;
	UserInfo selectedInfo;
	boolean showReturnLoan,showCheque,showFields,checkSavingAccount,showMode,showFixedDeposit,renderReturn,renderItem,showTransfer,showTransferSelect, showButtonFdr,showButtonCommon;
	double installment_amount,odAmount,applicantFees,frequency,odReturnInterest,interest,maturity_value,totalDepositamount,odReturnAmount,odInterest;
	int terms,days;
	DataBaseMethods obj=new DataBaseMethods();
	ArrayList<SelectItem> bankList;
	
	public OdLoanReturnBean()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		viewPrsnlLoan=(LoanInfo) ss.getAttribute("selectedLoan");
	
		planSchemeTypeForOd=obj.planSchemeType(viewPrsnlLoan.odScheme);
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		
		selectedInfo=obj.selectedInfoForDepositList(viewPrsnlLoan.getShareHolderNo(), viewPrsnlLoan.getOdLoanDepositType(), conn);
		
		user_no=selectedInfo.getUser_no();
		plan_no=selectedInfo.getPlanName();
		scheme_type=selectedInfo.getScheme_type();
		terms=selectedInfo.getTerms();
		frequencyLabel=selectedInfo.getFrequencyLabel();
		applicantFees=selectedInfo.getApplicant_fees();
		installment_amount=selectedInfo.getInstallment_amount();
		interest=selectedInfo.getInterest();
		strMatDate=new SimpleDateFormat("dd/MM/yyyy").format(selectedInfo.getMaturity_date());
		maturity_value=selectedInfo.getMaturity_value();
		scheme_type=selectedInfo.getScheme_type();
		odAmount=selectedInfo.getOdAmount()*0.8;
		totalDepositamount=selectedInfo.getOdAmount();
		strOffcDate=new SimpleDateFormat("dd/MM/yyyy").format(selectedInfo.getOffice_date());
		
		user_info=new DataBaseMethods().userInfoByShareHolderNo(viewPrsnlLoan.getShareHolderNo(), conn);
		guarantorUser1=new DataBaseMethods().userInfoByShareHolderNo(guarantor1, conn);
		guarantorUser2=new DataBaseMethods().userInfoByShareHolderNo(guarantor2,conn);
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	public void calculateReturnAmount() 
	{
		if(OdReturnDate .after(viewPrsnlLoan.getOdLoanDate()) || OdReturnDate .equals(viewPrsnlLoan.getOdLoanDate()) )
		{
		  days = (int) ((OdReturnDate.getTime() - viewPrsnlLoan.getOdLoanDate().getTime() ) / (1000 * 60 * 60 * 24));
		  odReturnInterest=Double.valueOf(new DecimalFormat("##.##").format((viewPrsnlLoan.getOdAmount()*days*viewPrsnlLoan.getOdInterest())/36500));
		  odReturnAmount=Double.valueOf(new DecimalFormat("##.##").format(viewPrsnlLoan.getOdAmount()+odReturnInterest));
		  showReturnLoan=true;
		}
		else
		{
			RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "ERROR !!", "Date Slection is Wrong !! "));
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(" Date Slection is Wrong !! "));
		}
	}
	
	public String addOdLoanReturn() throws IOException 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String odReturn=obj.addOdLoanReturn(branchId,OdReturnDate, odReturnAmount,viewPrsnlLoan.getShareHolderNo(),viewPrsnlLoan.getOdLoanDepositType(), odReturnInterest, paymentMode, bankName, chequeNo, chequeDate, viewPrsnlLoan.getOdLoanNo(), viewPrsnlLoan.getOdLoanDepositType(), viewPrsnlLoan.getOdScheme(),viewPrsnlLoan.getSavingAccountNo(), viewPrsnlLoan.getBankId(), conn);
		if(odReturn.equals("i"))
		{
			if(odReturnInterest>0)
			{
				String voucherNo=new DataBaseMethods().generateVoucherNo(branchId,"income_table", conn);
				new DataBaseIncomeExpense().addIncome(branchId,OdReturnDate, "Other_Cr", paymentMode, String.valueOf(odReturnInterest), chequeNo, bankBranch, bankName, chequeDate,
						"Interest Receive From OD Loan Return", "OD Loan Interest", 0, "N/A", "", 0, viewPrsnlLoan.getOdLoanNo(), "Od Loan", voucherNo, "", 0,"active","");
			}
			obj.updateStatusInOdLoan(viewPrsnlLoan.getOdLoanNo(),viewPrsnlLoan.getOdLoanDepositType(),conn);
			if(paymentMode.equalsIgnoreCase("cash"))
			{
				obj.increaseCompanyCapitalAmount(branchId,odReturnAmount, conn);
			}
			else 
			{
				obj.increaseBankBalance(submittedBankName,odReturnAmount, conn);
			}
			
			//FacesContext.getCurrentInstance().getExternalContext().redirect("viewDeleteOfOdLoan.xhtml");
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("OD Return Amount Rs. "+odReturnAmount + " Return Successfully For The Member Of "+viewPrsnlLoan.getShareHolderNo()));
			return "mainDashBoard.xhtml";
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error In  OD Amount Return."));
		}
		return "";
	}
	
	public void checkPaymentMode()
	{
		if(paymentMode.equals("Cash"))
			{
			checkSavingAccount=false;
				showCheque=false;
				showTransfer=false;
				showTransferSelect=true;
				transfer=bankBranch=bankName=chequeNo="";
				chequeDate=null;
			}
		
		else 
			if(paymentMode.equals("Cheque") || paymentMode.equals("Demand Draft") || paymentMode.equals("rtgs"))
			{
				if(paymentMode.equals("Cheque"))
					{
						label="Cheque";
					}
				else 
					if(paymentMode.equals("rtgs"))
					{
						label="RTGS/NEFT/IMPS";
					}
				else
					{
						label="Demand Draft";
					}
				checkSavingAccount=false;
				showCheque=true;
				showTransferSelect=false;
				showTransfer=true;
				transfer=bankBranch=bankName=chequeNo="";
				chequeDate=null;
			}
	}
	public String backButton()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		String pageName=(String) ss.getAttribute("pageName");
		return pageName;
	}

	public String getGuarantor1() {
		return guarantor1;
	}

	public void setGuarantor1(String guarantor1) {
		this.guarantor1 = guarantor1;
	}

	public String getGuarantor2() {
		return guarantor2;
	}

	public void setGuarantor2(String guarantor2) {
		this.guarantor2 = guarantor2;
	}

	public UserInfo getGuarantorUser1() {
		return guarantorUser1;
	}

	public void setGuarantorUser1(UserInfo guarantorUser1) {
		this.guarantorUser1 = guarantorUser1;
	}

	public UserInfo getGuarantorUser2() {
		return guarantorUser2;
	}

	public void setGuarantorUser2(UserInfo guarantorUser2) {
		this.guarantorUser2 = guarantorUser2;
	}

	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	public LoanInfo getViewPrsnlLoan() {
		return viewPrsnlLoan;
	}

	public void setViewPrsnlLoan(LoanInfo viewPrsnlLoan) {
		this.viewPrsnlLoan = viewPrsnlLoan;
	}

	public String getUser_no() {
		return user_no;
	}

	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}

	public String getPlan_no() {
		return plan_no;
	}

	public void setPlan_no(String plan_no) {
		this.plan_no = plan_no;
	}

	public String getScheme_type() {
		return scheme_type;
	}

	public void setScheme_type(String scheme_type) {
		this.scheme_type = scheme_type;
	}

	

	public String getStrMatDate() {
		return strMatDate;
	}

	public void setStrMatDate(String strMatDate) {
		this.strMatDate = strMatDate;
	}

	public ArrayList<UserInfo> getUserList() {
		return userList;
	}

	public void setUserList(ArrayList<UserInfo> userList) {
		this.userList = userList;
	}

	public double getInstallment_amount() {
		return installment_amount;
	}

	public void setInstallment_amount(double installment_amount) {
		this.installment_amount = installment_amount;
	}

	public double getOdAmount() {
		return odAmount;
	}

	public void setOdAmount(double odAmount) {
		this.odAmount = odAmount;
	}

	public double getApplicantFees() {
		return applicantFees;
	}

	public void setApplicantFees(double applicantFees) {
		this.applicantFees = applicantFees;
	}

	public double getFrequency() {
		return frequency;
	}

	public void setFrequency(double frequency) {
		this.frequency = frequency;
	}

	public double getInterest() {
		return interest;
	}

	public void setInterest(double interest) {
		this.interest = interest;
	}

	public double getMaturity_value() {
		return maturity_value;
	}

	public void setMaturity_value(double maturity_value) {
		this.maturity_value = maturity_value;
	}

	public int getTerms() {
		return terms;
	}

	public void setTerms(int terms) {
		this.terms = terms;
	}

	public DataBaseMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}

	public String getPlanSchemeTypeForOd() {
		return planSchemeTypeForOd;
	}

	public void setPlanSchemeTypeForOd(String planSchemeTypeForOd) {
		this.planSchemeTypeForOd = planSchemeTypeForOd;
	}

	public String getFrequencyLabel() {
		return frequencyLabel;
	}

	public void setFrequencyLabel(String frequencyLabel) {
		this.frequencyLabel = frequencyLabel;
	}

	public double getTotalDepositamount() {
		return totalDepositamount;
	}

	public void setTotalDepositamount(double totalDepositamount) {
		this.totalDepositamount = totalDepositamount;
	}

	public String getStrOffcDate() {
		return strOffcDate;
	}

	public void setStrOffcDate(String strOffcDate) {
		this.strOffcDate = strOffcDate;
	}

	public UserInfo getSelectedInfo() {
		return selectedInfo;
	}

	public void setSelectedInfo(UserInfo selectedInfo) {
		this.selectedInfo = selectedInfo;
	}

	public double getOdReturnAmount() {
		return odReturnAmount;
	}

	public void setOdReturnAmount(double odReturnAmount) {
		this.odReturnAmount = odReturnAmount;
	}

	public double getOdInterest() {
		return odInterest;
	}

	public void setOdInterest(double odInterest) {
		this.odInterest = odInterest;
	}

	public Date getOdReturnDate() {
		return OdReturnDate;
	}

	public void setOdReturnDate(Date odReturnDate) {
		OdReturnDate = odReturnDate;
	}


	public Date getChequeDate() {
		return chequeDate;
	}


	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}


	public String getPaymentMode() {
		return paymentMode;
	}


	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}


	public boolean isShowCheque() {
		return showCheque;
	}


	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}


	public boolean isShowFields() {
		return showFields;
	}


	public void setShowFields(boolean showFields) {
		this.showFields = showFields;
	}


	public boolean isCheckSavingAccount() {
		return checkSavingAccount;
	}


	public void setCheckSavingAccount(boolean checkSavingAccount) {
		this.checkSavingAccount = checkSavingAccount;
	}


	public boolean isShowMode() {
		return showMode;
	}


	public void setShowMode(boolean showMode) {
		this.showMode = showMode;
	}


	public boolean isShowFixedDeposit() {
		return showFixedDeposit;
	}


	public void setShowFixedDeposit(boolean showFixedDeposit) {
		this.showFixedDeposit = showFixedDeposit;
	}


	public boolean isRenderReturn() {
		return renderReturn;
	}


	public void setRenderReturn(boolean renderReturn) {
		this.renderReturn = renderReturn;
	}


	public boolean isRenderItem() {
		return renderItem;
	}


	public void setRenderItem(boolean renderItem) {
		this.renderItem = renderItem;
	}


	public boolean isShowTransfer() {
		return showTransfer;
	}


	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}


	public boolean isShowTransferSelect() {
		return showTransferSelect;
	}


	public void setShowTransferSelect(boolean showTransferSelect) {
		this.showTransferSelect = showTransferSelect;
	}


	public boolean isShowButtonFdr() {
		return showButtonFdr;
	}


	public void setShowButtonFdr(boolean showButtonFdr) {
		this.showButtonFdr = showButtonFdr;
	}


	public boolean isShowButtonCommon() {
		return showButtonCommon;
	}


	public void setShowButtonCommon(boolean showButtonCommon) {
		this.showButtonCommon = showButtonCommon;
	}


	public int getDays() {
		return days;
	}


	public void setDays(int days) {
		this.days = days;
	}


	public String getLabel() {
		return label;
	}


	public void setLabel(String label) {
		this.label = label;
	}


	public String getTransfer() {
		return transfer;
	}


	public void setTransfer(String transfer) {
		this.transfer = transfer;
	}


	public String getBankName() {
		return bankName;
	}


	public void setBankName(String bankName) {
		this.bankName = bankName;
	}


	public String getBankBranch() {
		return bankBranch;
	}


	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}


	public String getChequeNo() {
		return chequeNo;
	}


	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}


	public String getSubmittedBankName() {
		return submittedBankName;
	}


	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}


	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}


	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}


	public double getOdReturnInterest() {
		return odReturnInterest;
	}


	public void setOdReturnInterest(double odReturnInterest) {
		this.odReturnInterest = odReturnInterest;
	}


	public boolean isShowReturnLoan() {
		return showReturnLoan;
	}


	public void setShowReturnLoan(boolean showReturnLoan) {
		this.showReturnLoan = showReturnLoan;
	}


	

	
}
