package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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;

import other_package.DataBaseMethodsOther;

@ManagedBean(name="misPayment")
@ViewScoped
public class MisPaymentBean implements Serializable
{
	UserInfo user_info;
	Date closeDate,newMaturityDate,chequeDate, currentDate=new Date(),maxDate,instlmntDate;
    String user_no,receipt_no, chequeNo, bankName, paymentMode,strNewMaturirtyDate,status,pageName,instlmnt_no,transfer,submittedBankName, label, searchType="12";
    ArrayList<InstallmentInfo> list, paidList,rdPayList;
    List<String> nameList;
	double interest,maturity_value,amount,penalty,newMaturirtyValue,newIntrest,insAmount, totalPaid, monthlyAmount,paybleAmount,currentbalanceOfSavingAccount;
	boolean value, value1, value2,showTransfer,showTransferSelect,disableAmount, showEmiList,transferMode;
	String savingAccountNo,voucherNo;
	ArrayList<SelectItem> bankList, bankNameList;
	int totalPay=0, myId=0;
	String ifscCode, userId;
	DataBaseMethods dbm=new DataBaseMethods();
	DataBaseIncomeExpense ff=new DataBaseIncomeExpense();
	
	
	public MisPaymentBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		receipt_no=String.valueOf(dbm.receiptNo());
		bankNameList=dbm.bankNameSelectItemList(conn);
		voucherNo=dbm.generateVoucherNo(branchId,"expense_table",conn);

		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public List<String> completeUserNo(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		nameList=new DataBaseAutoCompAndDuplicate().userAccoutnNoFrequencyWise(branchId,name, "MIS", dbm.userId());
     	return nameList;
	}
	
	
	public void checkDetail() throws ParseException 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(user_no.contains("/"))
		{
			user_no=user_no.substring(0,user_no.indexOf("/"));
		}
		user_info = dbm.userInfoDuringTransaction(user_no);
		value=true;
		paybleAmount=user_info.getMaturity_value()-user_info.getInstallment_amount();
		monthlyAmount=Double.parseDouble(new DecimalFormat("##.##").format(paybleAmount/user_info.getTerms()));
		amount=monthlyAmount;
		list=dbm.misDepositList(user_info, conn);
		showEmiList=true;
		for(int l=0;l<list.size();l++)
		{
			Date dt=new Date();
			if(list.get(l).getStatus().equals("Paid"))
			{
				list.get(l).setColorStatus("paid");
			}
			else
			{
				SimpleDateFormat f = new SimpleDateFormat("dd/MM/yyyy");
				Date tempDt=f.parse(list.get(l).getIns_date());
				if(tempDt.before(dt))
				{
					list.get(l).setColorStatus("due");
				}
				else
				{
					list.get(l).setColorStatus("upcoming");
				}
			}
		}
		
		totalPaid=0;
		for(InstallmentInfo ff: list)
		{
			totalPaid+=ff.getPaidAmount();
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
//		System.out.println("app name : "+user_info.getFirst_applicantName());
	}
	
	public void checkPaidDetail()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		rdPayList=dbm.checkRdFdPaidDetailByUserNo(user_info.getUser_no());
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void forPaymentMode()
	{Connection conn=DataBaseConnection.JAVAConnection();
		if (paymentMode.equals("")) 
		{
			value1 = value2= transferMode=false;
		}
		else if (paymentMode.equals("cash")) 
		{
			value1 = true;
			value2 = false;
			showTransfer=false;
			showTransferSelect=true;
			transferMode=false;
			transfer=bankName=chequeNo="";
			chequeDate=null;
		}
		else if (paymentMode.equalsIgnoreCase("transfer"))
		{
			savingAccountNo=dbm.savingAccountByShareHolderNo(user_info.getShareHolderNo());
			UserInfo info=null;
			info=dbm.savingAccountDetailByAccountNo(savingAccountNo);
			currentbalanceOfSavingAccount=info.getAmount();
			transferMode=true;
			value1 = false;
			value2 = false;
			showTransfer=false;
			showTransferSelect=true;
			transfer=bankName=chequeNo="";
			chequeDate=null;
		}
		else
		{
			label=paymentMode;
			transferMode=false;
			value2 = true;
			value1 = false;
			showTransferSelect=false;
			showTransfer=true;
			transfer=bankName=chequeNo="";
			chequeDate=null;
		} 
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String misTransaction()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		transfer="No";
	    Connection conn=DataBaseConnection.JAVAConnection();
	 if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No") || paymentMode.equalsIgnoreCase("transfer"))
	 {
	     submittedBankName="N/A";
	 }
	
	 boolean z=new DataBaseMethodsDuplicate().receiptDuplicacy(receipt_no);
	 if(z==true)
	 {
	     receipt_no=String.valueOf(dbm.receiptNo());
	 }
	 boolean status=dbm.rd_FdPayStatus(user_no);
	 if(status==true)
	 {
	     FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Approve Your Previous Payment To Make Further Payment"));
	 }
	 else
	 {
	     double paidAmount=dbm.returnMisInterestAmount(user_no, conn);
	    // System.out.println(paidAmount+"hello"+paybleAmount);
	    
	     if(paybleAmount>paidAmount)
	     {
	         double remainingAmount=paybleAmount-paidAmount;
	         if(remainingAmount>=amount)               
	         {
	             int    n = dbm.paymentReceipt(branchId,user_no, 0, currentDate,paymentMode, chequeNo, chequeDate, bankName,penalty,receipt_no,submittedBankName, user_info.getScheme_type(),"",user_info.getDsaCode(), amount);
	             myId=n;
	             if (n >= 1)
	             {
	                 
	                
	                 sendMessage();
	                
	                 if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
	                 {
	                     FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
	                     dbm.decreaseCapitalCompanyAmount(branchId,amount);
	                    
	                     detailsForRDFDPrint();
	                     RequestContext.getCurrentInstance().execute("window.open('rd_fdReceipt.xhtml')");
	                 }
	                 else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
	                 {
	                     FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
	                     dbm.decreaseBankBalance(submittedBankName, amount, conn);
	                    
	                     detailsForRDFDPrint();
	                     RequestContext.getCurrentInstance().execute("window.open('rd_fdReceipt.xhtml')");
	                 }
	                 else if(paymentMode.equalsIgnoreCase("transfer"))
	                 {
	                     int k =dbm.userDeposit(branchId,savingAccountNo, String.valueOf(amount), currentDate, paymentMode, chequeNo, chequeDate, bankName, "approved",
	                    		 submittedBankName,"Mis Interest Credit", "");
	                     if(k >= 1)
	                     {
	                         remainingAmount=currentbalanceOfSavingAccount+amount;
	                         dbm.increaseSavingAccountAmount(remainingAmount, savingAccountNo);
	                         FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Transfer  SuccessFully in Saving Account No. "+savingAccountNo));
	                     }
	                 }
	                 else
	                 {
	                     FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
	                 }
	                 value2= false;paymentMode=chequeNo=bankName="";
	                 showTransfer=showEmiList=false;
	                 showTransferSelect=false;
	                 transfer="";
	                 amount=monthlyAmount;
	                 penalty=0.0;
	                 chequeNo=bankName="";
	                 chequeDate=null;
	                 receipt_no=String.valueOf(dbm.receiptNo());
	                 if(receipt_no.equals(""))
	                 {
	                     receipt_no="1";
	                 }
	                 bankList=new DataBaseIncomeExpense().allBankList(conn);
	                 return "misPayment.xhtml";
	             }
	             else
	             {
	                 FacesContext fc = FacesContext.getCurrentInstance();
	                 fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
	             }
	         }
	         else
	         {
	             FacesContext fc = FacesContext.getCurrentInstance();
	             fc.addMessage(null, new FacesMessage("Only Rs. "+remainingAmount+" Is Left in Selected RD No."));
	         }
	     }
	     else
	     {
	         FacesContext fc=FacesContext.getCurrentInstance();
	         fc.addMessage(null, new FacesMessage("Either You Have Paid All Installments Or Lesser Amount Than Installment Is To Be Paid.Please check!"));
	     }
	 }
	
	try {
	conn.close();
	} catch (Exception e) {
	//TODO: handle exception
	}
	 return "";
}

	private void sendMessage() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		userId=dbm.userId();
		//System.out.println("call msg: "+user_info.getContactNo());
		String check=dbm.checkStatusInMessageSettingTable("Pay RD Emi");
		if(check.equals("active"))
		{
			String typeMessage="Dear "+user_no+" - "+user_info.getFirst_applicantName()+", Rs. "+amount+" Return Sucessfully By "+paymentMode;
			dbm.runMessageUrl(branchId,user_info.getContactNo(), typeMessage, userId,"pending", conn);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Message For This Module is not Active. Please Go to In User Block and Active Message For This Module."));
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	public void detailsForRDFDPrint()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("id",myId);
		ss.setAttribute("shareHolderNo",user_info.getShareHolderNo());
		ss.setAttribute("frequency", user_info.getFrequency());
		ss.setAttribute("office_application_no", user_info.getOffice_application_no());
		ss.setAttribute("scheme_type", user_info.getScheme_type());
		ss.setAttribute("rd_fdNo",user_no);
		ss.setAttribute("maturityDate",user_info.getStrMatDate());
		ss.setAttribute("date",currentDate);
		ss.setAttribute("issue_date",user_info.getOffice_date());
		ss.setAttribute("maturity_value",user_info.getMaturity_value());
		ss.setAttribute("receipt_no", receipt_no);
		ss.setAttribute("installment_amount",amount);
		ss.setAttribute("plan_no", user_info.getPlan_no());
	}
	
	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	public Date getCloseDate() {
		return closeDate;
	}

	public void setCloseDate(Date closeDate) {
		this.closeDate = closeDate;
	}

	public Date getNewMaturityDate() {
		return newMaturityDate;
	}

	public void setNewMaturityDate(Date newMaturityDate) {
		this.newMaturityDate = newMaturityDate;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public Date getCurrentDate() {
		return currentDate;
	}

	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}

	public Date getMaxDate() {
		return maxDate;
	}

	public void setMaxDate(Date maxDate) {
		this.maxDate = maxDate;
	}

	public Date getInstlmntDate() {
		return instlmntDate;
	}

	public void setInstlmntDate(Date instlmntDate) {
		this.instlmntDate = instlmntDate;
	}

	public String getUser_no() {
		return user_no;
	}

	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}

	public String getReceipt_no() {
		return receipt_no;
	}

	public void setReceipt_no(String receipt_no) {
		this.receipt_no = receipt_no;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getStrNewMaturirtyDate() {
		return strNewMaturirtyDate;
	}

	public void setStrNewMaturirtyDate(String strNewMaturirtyDate) {
		this.strNewMaturirtyDate = strNewMaturirtyDate;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getPageName() {
		return pageName;
	}

	public void setPageName(String pageName) {
		this.pageName = pageName;
	}

	public String getInstlmnt_no() {
		return instlmnt_no;
	}

	public void setInstlmnt_no(String instlmnt_no) {
		this.instlmnt_no = instlmnt_no;
	}

	public String getTransfer() {
		return transfer;
	}

	public void setTransfer(String transfer) {
		this.transfer = transfer;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}

	public ArrayList<InstallmentInfo> getList() {
		return list;
	}

	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}

	public ArrayList<InstallmentInfo> getPaidList() {
		return paidList;
	}

	public void setPaidList(ArrayList<InstallmentInfo> paidList) {
		this.paidList = paidList;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	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 double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public double getPenalty() {
		return penalty;
	}

	public void setPenalty(double penalty) {
		this.penalty = penalty;
	}

	public double getNewMaturirtyValue() {
		return newMaturirtyValue;
	}

	public void setNewMaturirtyValue(double newMaturirtyValue) {
		this.newMaturirtyValue = newMaturirtyValue;
	}

	public double getNewIntrest() {
		return newIntrest;
	}

	public void setNewIntrest(double newIntrest) {
		this.newIntrest = newIntrest;
	}

	public double getInsAmount() {
		return insAmount;
	}

	public void setInsAmount(double insAmount) {
		this.insAmount = insAmount;
	}

	public double getTotalPaid() {
		return totalPaid;
	}

	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}

	public boolean isValue() {
		return value;
	}

	public void setValue(boolean value) {
		this.value = value;
	}

	public boolean isValue1() {
		return value1;
	}

	public void setValue1(boolean value1) {
		this.value1 = value1;
	}

	public boolean isValue2() {
		return value2;
	}

	public void setValue2(boolean value2) {
		this.value2 = value2;
	}

	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 isDisableAmount() {
		return disableAmount;
	}

	public void setDisableAmount(boolean disableAmount) {
		this.disableAmount = disableAmount;
	}

	public boolean isShowEmiList() {
		return showEmiList;
	}

	public void setShowEmiList(boolean showEmiList) {
		this.showEmiList = showEmiList;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public ArrayList<SelectItem> getBankNameList() {
		return bankNameList;
	}

	public void setBankNameList(ArrayList<SelectItem> bankNameList) {
		this.bankNameList = bankNameList;
	}

	public int getTotalPay() {
		return totalPay;
	}

	public void setTotalPay(int totalPay) {
		this.totalPay = totalPay;
	}

	public String getIfscCode() {
		return ifscCode;
	}

	public void setIfscCode(String ifscCode) {
		this.ifscCode = ifscCode;
	}

	public String getUserId() {
		return userId;
	}

	public void setUserId(String userId) {
		this.userId = userId;
	}

	public ArrayList<InstallmentInfo> getRdPayList() {
		return rdPayList;
	}

	public void setRdPayList(ArrayList<InstallmentInfo> rdPayList) {
		this.rdPayList = rdPayList;
	}

	public double getMonthlyAmount() {
		return monthlyAmount;
	}

	public void setMonthlyAmount(double monthlyAmount) {
		this.monthlyAmount = monthlyAmount;
	}

	public double getPaybleAmount() {
		return paybleAmount;
	}

	public void setPaybleAmount(double paybleAmount) {
		this.paybleAmount = paybleAmount;
	}

	public int getMyId() {
		return myId;
	}

	public void setMyId(int myId) {
		this.myId = myId;
	}

	public boolean isTransferMode() {
		return transferMode;
	}

	public void setTransferMode(boolean transferMode) {
		this.transferMode = transferMode;
	}

	public String getSavingAccountNo() {
		return savingAccountNo;
	}

	public void setSavingAccountNo(String savingAccountNo) {
		this.savingAccountNo = savingAccountNo;
	}

	public double getCurrentbalanceOfSavingAccount() {
		return currentbalanceOfSavingAccount;
	}

	public void setCurrentbalanceOfSavingAccount(
			double currentbalanceOfSavingAccount) {
		this.currentbalanceOfSavingAccount = currentbalanceOfSavingAccount;
	}

	
	
	
}
