package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Timestamp;
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 org.primefaces.context.RequestContext;

@ManagedBean(name="pendingTrans")
@ViewScoped
public class PendingTransactionBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	ArrayList<UserInfo> finalList,depositList,shareChequeList,shareExtraChequeList,withDrawList,rdPayList,loanPayList,incomeList,fdrIncomeList, returnInstantLoanList, instantBorrowList, promotorsCapitalList;
	ArrayList<InstallmentInfo> list;
	ArrayList<LoanInfo> loanEMIList;
	UserInfo selectedItem;
	Date chqReturnDate=new Date(), chqClearDate=new Date();
	boolean value,showPayDetail;
	String instlmnt_no="",label, reason;
	int x,a=0;
	double amount,insAmount;
	DataBaseMethods obj=new DataBaseMethods();
	public PendingTransactionBean() 
	{
	   createList();
	}
	
	public void createList()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		finalList=new ArrayList<>();
		depositList=obj.depositPaymentList(branchId);
		//withDrawList=obj.withdrawPaymentList();
		returnInstantLoanList=obj.pendingReturnInstantLoanList(branchId);
		instantBorrowList=obj.pendingInstantBorrowList(branchId);
		promotorsCapitalList=obj.pendingPromotorsCapitalList(branchId);
		
		
		incomeList=obj.pendingIncomeList(branchId);
		fdrIncomeList=obj.pendingFdrIncomeList(branchId);
		rdPayList=obj.allPayReceipt(branchId);
		loanPayList=obj.allLoanPayReceipt(branchId);
		shareChequeList= obj.pendingCheque(branchId);
		shareExtraChequeList= obj.pendingChequeFromShareInfoTable(branchId);
		
		
		finalList.addAll(shareExtraChequeList);
		finalList.addAll(shareChequeList);
		finalList.addAll(promotorsCapitalList);
		finalList.addAll(instantBorrowList);
		finalList.addAll(returnInstantLoanList);
		finalList.addAll(depositList);
		finalList.addAll(incomeList);
		finalList.addAll(fdrIncomeList);
		//finalList.addAll(withDrawList);
		finalList.addAll(rdPayList);
		finalList.addAll(loanPayList);
		   
		int i=1;
		for(UserInfo ll:finalList)
		{
			ll.setSno(i++);
		}
		
	}

	public void dateSettingMethod()
	{
		chqClearDate=selectedItem.getChq_ddDate();
	}
	
	
	public String approveRequest()
	{
		
		int i=obj.approveTransaction(selectedItem, chqClearDate);
		if(i>=1)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Transaction Approved Successfully"));
			
			if(selectedItem.getStatus().equalsIgnoreCase("Payment For RD"))
			{
				detailsForRDFDPrint();
				RequestContext.getCurrentInstance().execute("window.open('rd_fdReceipt.xhtml')");
			}
			else if(selectedItem.getStatus().equalsIgnoreCase("EMI Payment"))
			{
				detailsForLoanPrint();
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
			}
			createList();
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		}
		return "pendingTransaction";
	}
	
	public void detailsForRDFDPrint()
	{
		int id=Integer.valueOf(selectedItem.getId());
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("shareHolderNo", selectedItem.getShareHolderNo());
		ss.setAttribute("frequency", selectedItem.getFrequency());
		ss.setAttribute("office_application_no", selectedItem.getOffice_application_no());
		ss.setAttribute("scheme_type", selectedItem.getScheme_type());
		ss.setAttribute("rd_fdNo",selectedItem.getAccountNo());
		ss.setAttribute("maturityDate",selectedItem.getStrMatDate());
		ss.setAttribute("date",selectedItem.getEntryDate());
		ss.setAttribute("issue_date",selectedItem.getOffice_date());
		ss.setAttribute("maturity_value",selectedItem.getMaturity_value());
		ss.setAttribute("receipt_no", selectedItem.getReceiptNo());
		ss.setAttribute("installment_amount", selectedItem.getAmount());
		ss.setAttribute("plan_no", selectedItem.getPlan_no());
		ss.setAttribute("id", id);
		ss.setAttribute("instlmnt_no",instlmnt_no );
	}
	
	public void detailsForLoanPrint()
	{
		int id=Integer.valueOf(selectedItem.getId());
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("shareHolderNo", selectedItem.getShareHolderNo());
		ss.setAttribute("loanNo",selectedItem.getLoanNo());
		ss.setAttribute("receipt_no", selectedItem.getReceiptNo());
		ss.setAttribute("installment_amount", selectedItem.getAmount());
		ss.setAttribute("loanType", selectedItem.getScheme_type());
		ss.setAttribute("receipt_date",selectedItem.getEntryDateStr());
		ss.setAttribute("id", id);
		ss.setAttribute("instlmnt_no",instlmnt_no);
	}

	public String denyRequest()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		int i=obj.denyTransaction(selectedItem);
		if(i>=1)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Transaction Denied SuccessFully"));
			
			String voucherNo=obj.generateVoucherNo(branchId,"expense_table",conn);
			if(amount>0)
			{
				int j=new DataBaseIncomeExpense().addExpense(branchId,chqReturnDate, "Other_Dr", "Cheque", String.valueOf(amount), selectedItem.getChq_ddNo(), selectedItem.getBranch(), 
						selectedItem.getSubmittedToBank(), selectedItem.getChq_ddDate(), "Cheque Bounce Charge", "Cheque Bounce Charge", "1", voucherNo, 0,"0","","");
				
			}
			
			createList();
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		}
		return "pendingTransaction";
	}
	
	public void viewDetails()
	{
		if(selectedItem.getPayMode().equalsIgnoreCase("cheque"))
    	{
    		value=true;
      	}
    	else
    	{
    		value=false;
    	}
		
		if(selectedItem.getStatus().equals("Payment For RD"))
		{
			label="RD/FD No.";
			showPayDetail=true;
		}
		else if(selectedItem.getStatus().equals("EMI Payment"))
		{
			label="Loan No.";
			showPayDetail=true;
		}
		else if(selectedItem.getStatus().equals("Deposit"))
		{
			label="Acc.No";
			showPayDetail=false;
		}
		else if(selectedItem.getStatus().equals("Fixed_Deposit_Cr"))
		{
			label="FDR No.";
			showPayDetail=false;
		}
		else if(selectedItem.getStatus().equals("Other_Cr") || selectedItem.getStatus().equals("Fixed_Asset_Cr"))
		{
			label="Item Name";
			showPayDetail=false;
		}
	}
	
	public String viewLoan()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedLoan",selectedItem);
		return "";
	}

	public ArrayList<UserInfo> getFinalList() {
		return finalList;
	}
	public void setFinalList(ArrayList<UserInfo> finalList) {
		this.finalList = finalList;
	}
	
	public ArrayList<UserInfo> getDepositList() {
		return depositList;
	}

	public void setDepositList(ArrayList<UserInfo> depositList) {
		this.depositList = depositList;
	}

	public ArrayList<UserInfo> getWithDrawList() {
		return withDrawList;
	}

	public void setWithDrawList(ArrayList<UserInfo> withDrawList) {
		this.withDrawList = withDrawList;
	}

	public ArrayList<UserInfo> getRdPayList() {
		return rdPayList;
	}

	public void setRdPayList(ArrayList<UserInfo> rdPayList) {
		this.rdPayList = rdPayList;
	}

	public ArrayList<UserInfo> getLoanPayList() {
		return loanPayList;
	}

	public void setLoanPayList(ArrayList<UserInfo> loanPayList) {
		this.loanPayList = loanPayList;
	}

	public UserInfo getSelectedItem() {
		return selectedItem;
	}
	public void setSelectedItem(UserInfo selectedItem) {
		this.selectedItem = selectedItem;
	}
	public boolean isValue() {
		return value;
	}
	public boolean isShowPayDetail() {
		return showPayDetail;
	}
	public void setShowPayDetail(boolean showPayDetail) {
		this.showPayDetail = showPayDetail;
	}
	public void setValue(boolean value) {
		this.value = value;
	}

	public ArrayList<InstallmentInfo> getList() {
		return list;
	}

	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}

	public String getInstlmnt_no() {
		return instlmnt_no;
	}

	public void setInstlmnt_no(String instlmnt_no) {
		this.instlmnt_no = instlmnt_no;
	}

	public Date getChqReturnDate() {
		return chqReturnDate;
	}

	public void setChqReturnDate(Date chqReturnDate) {
		this.chqReturnDate = chqReturnDate;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public Date getChqClearDate() {
		return chqClearDate;
	}

	public void setChqClearDate(Date chqClearDate) {
		this.chqClearDate = chqClearDate;
	}

	public String getReason() {
		return reason;
	}

	public void setReason(String reason) {
		this.reason = reason;
	}
	
	
}
