package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
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.ReportInfo;

@ManagedBean(name="paymentReceipt")
@ViewScoped
public class PaymentReceiptBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	
	UserInfo user_info;
    Date closeDate,newMaturityDate,chequeDate, currentDate=new Date(),instlmntDate;
    String user_no,receipt_no, chequeNo, bankName, paymentMode,strNewMaturirtyDate,status,pageName,instlmnt_no,transfer="No",submittedBankName, label;
    ArrayList<InstallmentInfo> list, rdPayList;
    ArrayList<ReportInfo> printDepositList;
    double currentEmiAmountDue,currentDueEmi, totalDue;
    List<String> nameList;
	double interest,maturity_value,amount,penalty,newMaturirtyValue,newIntrest,insAmount, totalPaid,dsaCommission, accountBalance;
	boolean value, value1, value2,showTransfer,showTransferSelect,disableAmount, showEmiList, showSavingAcc;
	ArrayList<SelectItem> bankList;
	String searchType="12", savingAccountNo, userId;
	DsaListInfo commissionInfo=new DsaListInfo();
	UserInfo savingDetail;
	DataBaseMethods obj=new DataBaseMethods();
	DecimalFormat dc=new DecimalFormat("##.##");
	
	public PaymentReceiptBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		userId=obj.userId();
		transfer="No";
		pageName=(String) ss.getAttribute("pageName");
		Connection conn=DataBaseConnection.JAVAConnection();
		if(pageName!=null && pageName.equals("particularRD_FD"))
		{
			user_no=((UserInfo) ss.getAttribute("selectedUser")).getUser_no();
			searchType=((UserInfo) ss.getAttribute("selectedUser")).getScheme_type();
			userInfo();
			ss.removeAttribute("selectedUser");
			ss.removeAttribute("pageName");
		}
		else if(pageName!=null && pageName.equals("loanReportRequestByApp.xhtml"))
		{
			UserInfo appPay=new UserInfo();
			appPay=(UserInfo) ss.getAttribute("selectedRow2p");
			
			if(appPay.getOffice_date()!=null)
			{
				currentDate=appPay.getOffice_date();
				user_no=appPay.getLoanNo();
				searchType=appPay.getType();
				amount=appPay.getAmount();
				paymentMode=appPay.getPayMode();
				// System.out.println("mode"+appPay.getPayMode());
				userInfo();
				showTransferSelect=true;
				transfer="No";
			}
			
			ss.removeAttribute("pageName");
			ss.removeAttribute("selectedRow2p");
		}
		/*else
		{
			pageName="cashInOutFlow.xhtml";
		}*/
		
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		receipt_no=String.valueOf(obj.receiptNo());
	}
	
	public void selectMessage()
	{
		if(searchType.equals("1"))
		{
	    	searchType=null;
	    	user_no=null;
		}
		
	}
	
	public void checkPaidDetailForPrint()
	{
		printDepositList=obj.checkRdFdPaidDetailByUserNoForPrint(user_info.getUser_no());
	}
	
	public void printDailyPay()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		
		ArrayList<ReportInfo> dailyPayList= new ArrayList<>();
		// System.out.println(selectedUser.getUser_no());
		// System.out.println(selectedUser.getScheme_type());
		dailyPayList= obj.dailyRDFDReport(user_info.getUser_no(),user_info.getScheme_type(),con);
		try 
		{
			con.close();
		} 
		catch (Exception e) 
		{
			// TODO: handle exception
		}
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("RDFDailyPayList", dailyPayList);
		ss.setAttribute("selectedUserInfo", user_info);
		ss.setAttribute("totalSchDue", totalDue);
		ss.setAttribute("totalSchPaid", totalPaid);
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDateSchemePayment.xhtml')");
		
	}
	
	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,searchType, obj.userId());
     	return nameList;
	}
	
	public String backButton()
	{
		if(pageName==null || pageName.equals(""))
		{
			pageName="cashInOutFlow.xhtml";
		}
		return pageName;
	}
	public void userInfo() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss1=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		pageName=(String) ss1.getAttribute("pageName");
		if(pageName!=null && pageName.equals("particularRD_FD"))
		{
			user_no=((UserInfo) ss1.getAttribute("selectedUser")).getUser_no();
		}
		else
		{
			if(user_no.contains("/"))
			{
				user_no=user_no.substring(0,user_no.indexOf("/"));
			}
		}
		
		value1=value2=false;
		paymentMode="cash";
		chequeDate=null;chequeNo=bankName="";
		user_info = obj.userInfoDuringTransaction(user_no);

		
		savingDetail=obj.savingAccountDetailByShareHolderNo(user_info.getShareHolderNo());
		savingAccountNo=savingDetail.getAccountNo();
		accountBalance=Double.parseDouble(dc.format(savingDetail.getAmount()));
		
		if(user_info.getScheme_type().equalsIgnoreCase("FD") || user_info.getScheme_type().equalsIgnoreCase("MIS"))
		{
			showEmiList=false;
		}
		else
		{
			showEmiList=true;
		}
		
		
		
		
        list=obj.showInstallment(user_no,conn);
        
        
        /*for(int i=0;i<list.size();i++)
        {
        	list.get(i).setCalc_interest(Double.parseDouble(dc.format(list.get(i).getCalc_interest())));
        	list.get(i).setTot_sum(Double.parseDouble(dc.format(list.get(i).getTot_sum())));
        }*/
        
        //For Color
    	for(int l=0;l<list.size();l++)
		{
			Date dt=new Date();
			if(list.get(l).getStatus().equalsIgnoreCase("Paid"))
			{
				list.get(l).setColorStatus("paid");
			}
			else
			{
				if(list.get(l).getInstlmntDate().before(dt))
				{
					list.get(l).setColorStatus("due");
				}
				else
				{
					list.get(l).setColorStatus("upcoming");
				}
			}
		}
        
        totalPaid=0;
        currentDueEmi = 0;
        currentEmiAmountDue = 0;
        Date dtt=new Date();
        for(InstallmentInfo ii : list)
        {
        	interest=ii.getInterest();
        	maturity_value=(ii.getTot_sum());
        	totalPaid+=ii.getPaidAmount();
        	
        	 if(!ii.getStatus().equalsIgnoreCase("Paid") && ii.getInstlmntDate().before(dtt))
     	    {
     		 currentDueEmi++;
     		 currentEmiAmountDue += ii.getDueAmount();
     	    }
        }
        
        totalPaid=Double.parseDouble(dc.format(totalPaid));
        maturity_value=Math.round(maturity_value);
        
		value = true;
		amount=user_info.getInstallment_amount();
		
		if(user_info.getScheme_type().equalsIgnoreCase("FD"))
		{
			disableAmount=true;
		}
		else
		{
			disableAmount=false;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	public void checkPaidDetail()
	{
		rdPayList=obj.checkRdFdPaidDetailByUserNo(user_info.getUser_no());
	}
	
	
	public void checkTransferMode()
	{
		if(transfer.equals("Yes"))
		{
			showTransfer=true;
		}
		else
		{
			showTransfer=false;
		}
	}
	
	public void forPaymentMode()
	{
		if (paymentMode.equalsIgnoreCase("")) 
		{
			value1 = value2= false;
			showSavingAcc=false;
		}
		else if (paymentMode.equalsIgnoreCase("cash")) 
		{
			value1 = true;
			value2 = false;
			showTransfer=false;
			showTransferSelect=true;
			bankName=chequeNo="";
			chequeDate=null;
			showSavingAcc=false;
		}
		else if(paymentMode.equalsIgnoreCase("transfer"))
		{
			if(savingAccountNo==null || savingAccountNo.equals(""))
			{
				showSavingAcc=false;
				paymentMode="";
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(user_info.getShareHolderNo()+" Don't Have Any Saving Account."));
			}
			else
			{
				showSavingAcc=true;
				value1 = false;
				value2 = false;
				showTransfer=false;
				showTransferSelect=false;
				transfer=bankName=chequeNo="";
				chequeDate=null;
			}
		}
		else
		{
			label=paymentMode;
			value2 = true;
			value1 = false;
			showTransferSelect=false;
			showTransfer=true;
			transfer=bankName=chequeNo="";
			chequeDate=null;
			showSavingAcc=false;
			if(paymentMode.equalsIgnoreCase("NACH"))
			{
				Connection conn=DataBaseConnection.JAVAConnection();
				chequeNo=obj.nachDetailByColumnNameAndShareHolderNo("umrn_no", user_info.getShareHolderNo(), conn);
				bankName=obj.nachDetailByColumnNameAndShareHolderNo("bank_name", user_info.getShareHolderNo(), conn);
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		} 
	}
	
	
	
	
	public String Transaction() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		int flag=0;
		if(paymentMode.equalsIgnoreCase("transfer"))
		{
			if(accountBalance>=amount)
			{
				flag=1;
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Sorry!!! You Don't Have Enough Saving Account Balance to Perform This Transaction. Please Check!!!"));
				flag=0;
			}
		}
		else
		{
			flag=1;
		}
		
		if(flag==1)
		{
			if(paymentMode.equalsIgnoreCase("Cash") || paymentMode.equalsIgnoreCase("transfer"))
			{
				submittedBankName="N/A";
			}
			
			boolean z=new DataBaseMethodsDuplicate().receiptDuplicacy(receipt_no);
			if(z==true)
			{
				receipt_no=String.valueOf(obj.receiptNo());
			}
			boolean status=obj.rd_FdPayStatus(user_no);
			if(status==true)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Approve Your Previous Payment To Make Further Payment"));
			}
			else
			{
				double paybleAmount=obj.checkForPaymentReceipt(user_no,user_info.getScheme_type());
				double paidAmount=obj.paidAmountByUser(user_no,conn);
				if(paybleAmount>paidAmount)
				{
					double remainingAmount=paybleAmount-paidAmount;
					if(remainingAmount>=amount)				
					{
						int	n = obj.paymentReceipt(branchId,user_no, amount, currentDate,paymentMode, chequeNo, chequeDate, bankName,penalty,receipt_no,submittedBankName, user_info.getScheme_type(), savingAccountNo,user_info.getDsaCode(), 0);
						if (n >= 1) 
						{
							myId=n;
						//	if(user_info.getScheme_type().equalsIgnoreCase("RD"))
							{
								//// System.out.println("n: "+n);
								sendMessage(conn);
								// Msg sent on Pay RD EMI Only.
							}
							calculateDsaCommission();
							if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
								obj.increaseCompanyCapitalAmount(branchId,amount,conn);
								
								detailsForRDFDPrint();
								
							}
							else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
								obj.increaseBankBalance(submittedBankName, amount,conn);
								
								detailsForRDFDPrint();
							}
							else if(paymentMode.equalsIgnoreCase("transfer"))
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Transfer SuccessFully From Saving Account"));
								obj.userWithdrwal(branchId,savingAccountNo, String.valueOf(amount), currentDate, "transfer", chequeNo, chequeDate, submittedBankName, "",
										"approved", "Transfer For "+user_no, "");
								Double newAmount=accountBalance-amount;
								obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
							
								detailsForRDFDPrint();
							}
							else
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
							}
							value2= false;paymentMode=chequeNo=searchType=user_no=bankName="";
							showTransfer=false;
							showTransferSelect=false;
							transfer="";
							amount=user_info.getInstallment_amount();
							penalty=0.0;
							chequeNo=bankName="";
							chequeDate=null;
							receipt_no=String.valueOf(obj.receiptNo());
							if(receipt_no.equals(""))
							{
								receipt_no="1";
							}
							list=obj.showInstallment(user_no,conn);
							  totalPaid=0;
						        for(InstallmentInfo ii : list)
						        {
						        	interest=ii.getInterest();
						        	maturity_value=(ii.getTot_sum());
						        	totalPaid+=ii.getPaidAmount();
						        }
							bankList=new DataBaseIncomeExpense().allBankList(conn);
							try {
								conn.close();
							} catch (Exception e) {
								// TODO: handle exception
							}
							return "paymentReceipt.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("You Have To Pay Only "+remainingAmount));
					}
				}
				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 calculateDsaCommission() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		if(user_info.getPlan_no()==null || user_info.getPlan_no().equals(""))
		{
			
		}
		else
			{
				if(user_info.getDsaCode()==null || user_info.getDsaCode().equals(""))
				{
					dsaCommission=0;
				}
				else
				{
					dsaCommission=0;
					commissionInfo=obj.checkPlanCommissionDetail(user_info.getPlan_no(), conn);
					if(commissionInfo==null || commissionInfo.getStatusNullCheck().equals("0"))
					{
						// System.out.println("null pointer: hello RD EMI");
						dsaCommission=0;
					}
					else
					{
						double val=0, terms=0;
						  // System.out.println("pay amt: "+amount);
							if(amount%user_info.getInstallment_amount()==0)
							{
								 if(commissionInfo.getCommissionBase().equalsIgnoreCase("collection"))
								 {
									   val=user_info.getInstallment_amount();
											
									   		
											   terms=amount/user_info.getInstallment_amount();
											   if(terms>=commissionInfo.getMaxEmi())
											   {
												   terms=commissionInfo.getMaxEmi();
											   }
											   // System.out.println("hello terms: "+terms);
										   }
										  
									
								 		int emiNo=0;
									  for(int i=0; i<list.size();i++)
									  {
										  if(list.get(i).getStatus().equalsIgnoreCase("due"))
										  {
											  emiNo=list.get(i).getSno();
											  break;
										  }
									  }
									  
									  System.out.println("emi no. "+emiNo);
									  
									  String emiiiNo="";
									  // System.out.println("temr:: "+terms);
									  for(int j=1;j<=terms;j++)
									  {
										  if(user_info.getScheme_type().equals("DD"))
										   {
											   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
											   {
												   dsaCommission=(val/100)*commissionInfo.getCommission_value();
											   }
											   else
											   {
												   dsaCommission=commissionInfo.getCommission_value();
											   }
											   emiiiNo=String.valueOf(emiNo);
										   }
										   else  if(user_info.getScheme_type().equals("RD"))
										   {
											   commissionInfo=obj.checkPlanCommissionDetailForRd(user_info.getPlan_no(), emiNo);
											   if(commissionInfo==null || commissionInfo.getStatusNullCheck().equals("0"))
											   {
												   dsaCommission=0;
											   }
											   else
											   {
												   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
												   {
													   dsaCommission=(val/100)*commissionInfo.getCommission_value();
												   }
												   else
												   {
													   dsaCommission=commissionInfo.getCommission_value();
												   }
												   emiiiNo=String.valueOf(emiNo);
											   }
											}
										   else
										   {
											   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
											   {
												   dsaCommission=(val/100)*commissionInfo.getCommission_value();
											   }
											   else
											   {
												   dsaCommission=commissionInfo.getCommission_value();
											   }
											   emiiiNo="all";
										   }
										   
										   dsaCommission=Double.parseDouble(dc.format(dsaCommission));
											// System.out.println(dsaCommission+"========="+emiiiNo);
										   if(dsaCommission>0)
										   {
											  boolean checkEntry=obj.checkDuplicacyInDsaCommissionTable(user_no,emiiiNo);
											  if(checkEntry==false)
											  {
												  String dsaName=obj.dsaNameById(user_info.getDsaCode(),conn);
													int i=obj.insertDataInDsaCommissionTable(branchId,user_info.getScheme_type(), user_no, user_info.getDsaCode(), dsaCommission, currentDate, emiiiNo);
													if(i>0)
													{
														FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Commission Auto Credited to "+user_info.getDsaCode()+" - "+dsaName+" Rs.:- "+dsaCommission));
													}
											  }
											 
										   }
										   try {
											conn.close();
										} catch (Exception e) {
											// TODO: handle exception
										}
										   emiNo++;
									  }
									}
							
								   else
								   {
									   val=0;
									   dsaCommission=0;
									   FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Commission Not Auto Credited Due To EMI Amount not valid for Commission."));
								   
								   }
					}
			}
			
		}
	}
	
	private void sendMessage(Connection conn) 
	{
		if(paymentMode.equalsIgnoreCase("cash")) // Due to DLT not approve same format
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId = (int) ss.getAttribute("branchId");
			String check="",payMode="cash";
			if(searchType.equalsIgnoreCase("DD"))
			{
				check=obj.checkStatusInMessageSettingTable("Pay DD Emi");
			}
			else if(searchType.equalsIgnoreCase("FD"))
			{
				check=obj.checkStatusInMessageSettingTable("Pay FD Emi");
			}
			else
			{
				check=obj.checkStatusInMessageSettingTable("Pay RD Emi");
			}
			
			if(check.equals("active"))
			{
				double paidAmount=obj.paidAmountByUser(user_no,conn);
				String typeMessage="Dear "+user_info.getFirst_applicantName()+", Rs. "+amount+" Submit Sucessfully By "+payMode+". Total Deposit Amount Balance is Rs. "+paidAmount;
				obj.runMessageUrl(branchId,user_info.getContactNo(), typeMessage, "admin","1207166054354220451",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."));
			}
		}
	}
	
	
	int myId=0;
	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());
		
		if(paymentMode.equalsIgnoreCase("cash") || paymentMode.equalsIgnoreCase("transfer"))
		{
			RequestContext.getCurrentInstance().execute("window.open('rd_fdReceipt.xhtml')");
		}
		
		HeaderBean hh=new HeaderBean();
		if(hh.getName().equalsIgnoreCase("DEVKRIPA MICROFINANCE FOUNDATION"))
		{
			RequestContext.getCurrentInstance().execute("window.open('rd_fdReceiptGolden.xhtml')");
		}
	}
	
	
/*	public String test(int x, int y,int k)
	{
		String ins_no="";
		int p=0,r=0;
		
		int q=y-x;
		if(k>0)
		{
			q=q+1;
		}
		x=x+1;
		for(p=1;p<=q;p++)
		{
			r=x++;
			if(p!=q)
			{
				ins_no=ins_no+r+",";
			}
			else
			{
				ins_no=ins_no+r;
			}
			
		}
		return ins_no;
	}
*/	
	public void calculateNewMaturity()
	{
		//int f=0;
		if(closeDate.before(user_info.getOffice_date()))
    	{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Close Date Can't Be Earlier Than First Installment Date...Please Check!"));
    	}
		else
		{
			/*for(InstallmentInfo ii : list)
	        {
	        	instlmntDate=ii.getInstlmntDate();
	        	SimpleDateFormat ins=new SimpleDateFormat("dd/MM/yyyy");
	        	String insdt=ins.format(instlmntDate);
	        	SimpleDateFormat cls=new SimpleDateFormat("dd/MM/yyyy");
	        	String clsdt=cls.format(closeDate);
	
	    		if( insdt.equals(clsdt) || instlmntDate.before(closeDate))
	            {
	            	status=ii.getStatus();
	            	if(status.equals("Due"))
	            	{
	            		f=1;
	            	}
	            }
	        }
			if(f==1)
			{
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("User Still Have Pending Installments Before Close Date... Please Check!"));
				
			}
			else
			{*/
				int month=differenceInMonths(user_info.getOffice_date(),closeDate);
			    newMaturirtyValue=obj.findInterestForBreak(user_info.getTerms(), user_info.getInstallment_amount(),newIntrest,user_info.getScheme_type(),month, user_info.getFrequency());
			    newMaturityDate=obj.findMaturityDate(closeDate,1,0);
			    strNewMaturirtyDate=new SimpleDateFormat("dd/MM/yyyy").format(newMaturityDate);
			    RequestContext.getCurrentInstance().execute("PF('maturityInfoDialog').hide()");
			    RequestContext.getCurrentInstance().execute("PF('confirmInfoDialog').show()");
			//}
		}
		
	}
	
	private static int differenceInMonths(Date startDate, Date endDate) 
	{
		Calendar startCalendar = new GregorianCalendar();
		startCalendar.setTime(startDate);
		Calendar endCalendar = new GregorianCalendar();
		endCalendar.setTime(endDate);

		int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR);
		int diffMonth = diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH);
	    return diffMonth;
	}
	
	public String updateMaturity()
	{
		int i=obj.updateMaturity(user_no, newMaturirtyValue, newIntrest,newMaturityDate);
	    if(i>=1)
	    {
	    	FacesContext fc = FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Your Scheme Is Closed Successfully"));	
			newIntrest=0;
	        closeDate=null;    
	        value=false;user_no="";
	        return "paymentReceipt";
	    }
	    else
	    {
	    	FacesContext fc = FacesContext.getCurrentInstance();
	    	fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			return "";
	    }
	}
	
	public void updateNotMaturity()
	{
		RequestContext.getCurrentInstance().execute("PF('confirmInfoDialog').hide()");
		newIntrest=0;
		closeDate=null;
	}
	
	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 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 ArrayList<InstallmentInfo> getList() {
		return list;
	}
	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}
	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 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 Date getInstlmntDate() {
		return instlmntDate;
	}

	public void setInstlmntDate(Date instlmntDate) {
		this.instlmntDate = instlmntDate;
	}
    public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public double getInsAmount() {
		return insAmount;
	}

	public void setInsAmount(double insAmount) {
		this.insAmount = insAmount;
	}

	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 boolean isDisableAmount() {
		return disableAmount;
	}

	public void setDisableAmount(boolean disableAmount) {
		this.disableAmount = disableAmount;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	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 ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public double getTotalPaid() {
		return totalPaid;
	}

	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}

	public boolean isShowEmiList() {
		return showEmiList;
	}

	public void setShowEmiList(boolean showEmiList) {
		this.showEmiList = showEmiList;
	}

	public ArrayList<InstallmentInfo> getRdPayList() {
		return rdPayList;
	}

	public void setRdPayList(ArrayList<InstallmentInfo> rdPayList) {
		this.rdPayList = rdPayList;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getPageName() {
		return pageName;
	}

	public void setPageName(String pageName) {
		this.pageName = pageName;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}

	public int getMyId() {
		return myId;
	}

	public void setMyId(int myId) {
		this.myId = myId;
	}

	public boolean isShowSavingAcc() {
		return showSavingAcc;
	}

	public void setShowSavingAcc(boolean showSavingAcc) {
		this.showSavingAcc = showSavingAcc;
	}

	public UserInfo getSavingDetail() {
		return savingDetail;
	}

	public void setSavingDetail(UserInfo savingDetail) {
		this.savingDetail = savingDetail;
	}

	public double getDsaCommission() {
		return dsaCommission;
	}

	public void setDsaCommission(double dsaCommission) {
		this.dsaCommission = dsaCommission;
	}

	public double getAccountBalance() {
		return accountBalance;
	}

	public void setAccountBalance(double accountBalance) {
		this.accountBalance = accountBalance;
	}

	public String getSavingAccountNo() {
		return savingAccountNo;
	}

	public void setSavingAccountNo(String savingAccountNo) {
		this.savingAccountNo = savingAccountNo;
	}

	public DsaListInfo getCommissionInfo() {
		return commissionInfo;
	}

	public void setCommissionInfo(DsaListInfo commissionInfo) {
		this.commissionInfo = commissionInfo;
	}

	public ArrayList<ReportInfo> getPrintDepositList() {
		return printDepositList;
	}

	public void setPrintDepositList(ArrayList<ReportInfo> printDepositList) {
		this.printDepositList = printDepositList;
	}

	public double getCurrentEmiAmountDue() {
		return currentEmiAmountDue;
	}

	public void setCurrentEmiAmountDue(double currentEmiAmountDue) {
		this.currentEmiAmountDue = currentEmiAmountDue;
	}

	public double getCurrentDueEmi() {
		return currentDueEmi;
	}

	public void setCurrentDueEmi(double currentDueEmi) {
		this.currentDueEmi = currentDueEmi;
	}

	public double getTotalDue() {
		return totalDue;
	}

	public void setTotalDue(double totalDue) {
		this.totalDue = totalDue;
	}
	
	
	
}
