package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.TimeUnit;

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;
import other_package.ReportInfo;
import report_package.DataBaseReportMethods;

@ManagedBean(name="payLoan")
@ViewScoped

public class PayLoanEMIBean implements Serializable
{   
	private static final long serialVersionUID = 1L;
	String appType="",loanNo,loanType,pageName="",receipt_no, chequeNo,newLoanNo, bankName, paymentMode,status,instlmnt_no="",transfer,submittedBankName,loanResNo,label;
	boolean showLoanNo,show,renderBut,renderAmt,showMemberTable,renderTable1,renderTable2,renderLoanRes,value,checkRes, value1, value2,showTransfer,showTransferSelect
	,showMsg,showRestructure,disableRes,disablePreRes,disableSub,renderTableField, showMemberTableSingle, showMemberTableMultiple, showSaving=false;
	LoanInfo loan_info,mm;
	ArrayList<LoanInfo> loanEMIList, emiPaidDetailList,grpLoanMemberList, multiSelectedList, confirmMultiSelectedList,penaltyList;
	ArrayList<SelectItem> bankList,loanResNoList;
	UserInfo user_info, savingDetail;
	LoanInfo selectedMember;
    Date chequeDate, currentDate=new Date(),instlmntDate;
    List<String> nameList;
    int remainingTerms,newDiscountOnLastEmi,paidEMI, emiNo, currentDueEmi;
	double amount,penalty,emiAmount,dueAmount,interestAmount,increaseAmount,principleAmount,bulkAmount,paidPrincipal,remainingPrincipal,newEmi, penaltyDiscount;
	double preResAmt,newIntrAmount,newRate, penaltyPaidDlg, penaltyDiscountDlg;
	double totalPenaltyDue, totalPenaltyPaid, totalIntrest, totalEmi, totalPrincipal, totalDue, totalPaid,bounceCharge;
	double totalChqCharge, paidChqcharge, loanBalance, currentPenaltyDue, currentEmiAmountDue, commission, msgPenaltyAmt, totalEmiPayAmount, savingAmount;
	String userId, voucherNo,oldLoanNo, emiPayment="single", attendance, remark, savingAccountNo;
	String companyName;
	DsaListInfo commissionInfo;
	ArrayList<ReportInfo> dailyPayList;
	ArrayList<DebitInfo> transactionHistory;
	ArrayList<UserInfo>loanList;
	DataBaseMethods obj=new DataBaseMethods();
	DecimalFormat dc=new DecimalFormat("##.##");
	String strNoticeDate;
	double principalOd, interestOd, totalAmountPaid, totalAmountDue, amountPaid, penaltyOd;
	Date noticeDate=new Date();
	SimpleDateFormat sf=new SimpleDateFormat("dd/MM/yyyy");
	boolean printOne, printTwo, printThree, printFour;
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	boolean daterange = true;
	Date minPayDate, maxPayDate;
	DataBaseMethodsRaviK dbr = new DataBaseMethodsRaviK();
	DataBaseMethodsRavi dbrj = new DataBaseMethodsRavi();
    double balanceChqCharge;
    
  //dynamic cheque bounce date 
    double chequeBounceAmt;
  	double chargeB;
  	int chequeBounceEmiCount;
  	ArrayList<LoanInfo> chequeBounceDetailList,manualChargeList;
	
	
	public void newStatement() {
		
		loanList=new ArrayList<>();
		
		
		DataBaseMethodRahul dbr = new DataBaseMethodRahul();
		System.out.println("selectedMember :"+loan_info.getLoanNo());
		
		dbr.loanStatement(loan_info ,loanList);
		
		
		
	}
	
	public void printPage() throws IOException {
		
	
		dailyPayList= new ArrayList<>();
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getLoanNo());
		}
		loan_info.setInterestAmount(String.valueOf(totalIntrest));
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("viewselecteduser", user_info);
		ss.setAttribute("selectedLoan", loan_info);
		ss.setAttribute("penaltyAmount", penalty);
		ss.setAttribute("penaltyPaid", totalPenaltyPaid);
		ss.setAttribute("penaltyDue", totalPenaltyDue);
		ss.setAttribute("totalChqCharge", totalChqCharge);
		ss.setAttribute("paidChqCharge", paidChqcharge);
		ss.setAttribute("dailyPayList", dailyPayList);
		ss.setAttribute("selectedVal",loan_info);
		ss.setAttribute("operationVal", "loan");
		ss.setAttribute("reportClosingBalance", totalDue);
		ss.setAttribute("disOnLoanClose",0.0);
		ss.setAttribute("printOverallEmi",loanEMIList );                  //RR 04/7 
		ss.setAttribute("totalEmi", totalEmi);                            //RR 04/7 
		ss.setAttribute("totalIntrest",totalIntrest);                     //RR 04/7 
//		System.out.println("value intrest in cl :"+totalIntrest);

		ss.setAttribute("totalPrincipal", totalPrincipal);                //RR 04/7 
		ss.setAttribute("totalPaid", totalPaid);                          //RR 04/7 

		
		   RequestContext.getCurrentInstance().execute("window.open('printCollectEmi.xhtml')");			
	}	
	
	
	
	public PayLoanEMIBean() throws ParseException, SQLException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		companyName = dbmt.companyNameByBranchId(branchId);
		
		Connection conn=DataBaseConnection.JAVAConnection();
		transfer="No";
		userId=obj.userId();
		
		String usertype = obj.userTypeByUserId(userId,conn);
	 		    
		    Calendar cal = Calendar.getInstance();
			if ("masterAdmin".equalsIgnoreCase(usertype)) {
				  cal.set(2000, Calendar.JANUARY, 1);
				    minPayDate = cal.getTime();

				    cal.set(2100, Calendar.DECEMBER, 31);
				    maxPayDate = cal.getTime();			
			}
			else 
			{
				    int backDays = dbr.entryBackDaysByUserId(userId, conn);
		
				    maxPayDate = new Date();
				    
				    cal.setTime(new Date());
				    cal.add(Calendar.DAY_OF_MONTH, -backDays);
		
				    minPayDate = cal.getTime();
			}
		
		    currentDate = new Date(); 
		
		renderTable2=false;
		renderLoanRes=false;
		disableRes=true;
		renderAmt=true;
		disablePreRes=disableSub=false;
		showMsg=false;
		pageName=(String) ss.getAttribute("pageName");
		if(pageName!=null && pageName.equals("particularLoan"))
		{
			loanNo=((LoanInfo) ss.getAttribute("selectedLoan")).getLoanNo();
			loanType=((LoanInfo) ss.getAttribute("selectedLoan")).getLoanType();
			
			if(loanType.equals("Personal Loan"))
			{
				loanType="personalloan";
			}
			else if(loanType.equals("Vehicle Loan"))
			{
				loanType="vechicleloan";
			}
			else if(loanType.equals("Property Loan"))
			{
				loanType="propertyloan";
			}
			else if(loanType.equals("Group Loan"))
			{
				loanType="grouploan";
			}
			else if(loanType.equals("Secure Loan"))
			{
				loanType="secure_loan";
			}
			else if(loanType.equals("Business Loan"))
			{
				loanType="business_loan";
			}
			userInfo();
			ss.removeAttribute("selectedLoan");
			ss.removeAttribute("pageName");
		}
		else if(pageName!=null && pageName.equals("self"))
		{
			loanNo=(String) ss.getAttribute("restructureLoan");
			loanType=(String) ss.getAttribute("resLoanType");
			userInfo();
			ss.removeAttribute("self");
			ss.removeAttribute("restructureLoan");
			ss.removeAttribute("resLoanType");
		}
		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();
				loanNo=appPay.getLoanNo();
				loanType=appPay.getType();
				amount=appPay.getAmount();
				paymentMode=appPay.getPayMode();
				userInfo();
				
				showTransferSelect=true;
				transfer="No";
			}
			
			
			ss.removeAttribute("selectedRow2p");
			ss.removeAttribute("pageName");
		}
		/*else
		{
			pageName="cashInOutFlow";
		}*/
		receipt_no=String.valueOf(obj.loanPayReceiptNo());
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void checkPaidDetail()
	{
		emiPaidDetailList=obj.checkEmiPaidDetailByloanNoWithoutDateGrouping(loanNo);
		if(emiPaidDetailList.size()>0)
		{
			for(LoanInfo li : emiPaidDetailList)
			{
				if(li.getEmiNo().equalsIgnoreCase("EMI -2"))
				{
					li.setEmiNo("Loan Restructured");
				}
				
				
				else if(li.getEmiNo().equalsIgnoreCase("EMI -1"))
				{
					li.setEmiNo("Loan Closed");
				}
			}
		}
	}
	
	public void noticeDetailMethod()
	{
		principalOd=totalPrincipal;
		interestOd=totalIntrest;
		totalAmountPaid=totalEmi;
		totalAmountDue=loanBalance;
		amountPaid=totalPaid;
		penaltyOd = totalPenaltyDue;
	}
	
	public void printNotice()
	{
		if(noticeDate==null)
		{
			noticeDate=new Date();
		}
		strNoticeDate=sf.format(noticeDate);
		String noticeLoanNo="";
		
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			noticeLoanNo=loan_info.getSubLoanNo();
		}
		else
		{
			noticeLoanNo=loan_info.getLoanNo();
		}
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		
		ss.setAttribute("noticeName", user_info.getFirst_applicantName());
		ss.setAttribute("noticeFHname", user_info.getFather_husband_name());
		ss.setAttribute("noticeAddress", user_info.getAddress());
		ss.setAttribute("noticeMobile", user_info.getContactNo());
		ss.setAttribute("noticeLoanNo", noticeLoanNo);
		ss.setAttribute("strNoticeDate", strNoticeDate);
		ss.setAttribute("principalOd", principalOd);
		ss.setAttribute("interestOd", interestOd);
		ss.setAttribute("totalAmountPaid", totalAmountPaid);
		ss.setAttribute("totalAmountDue", totalAmountDue);
		ss.setAttribute("amountPaid", amountPaid);
		ss.setAttribute("penaltyOd", penaltyOd);
		
		
		
		if(printOne==true)
        {
			RequestContext.getCurrentInstance().execute("window.open('printDueNotice.xhtml')");
        }
        
        if(printTwo==true)
        {
        	RequestContext.getCurrentInstance().execute("window.open('printDueNoticeInHindi.xhtml')");
        }
        
        if(printThree==true)
        {
        	RequestContext.getCurrentInstance().execute("window.open('printDueNoticeInHindiFormatTwo.xhtml')");
        }
        
        if(printFour==true)
        {
        	RequestContext.getCurrentInstance().execute("window.open('printDueNoticeInHindiFormatThree.xhtml')");
        }
        
       
		Connection conn=DataBaseConnection.JAVAConnection();
		String gurantor1=new DataBaseReportMethods().gurantor1ByLoanNo(loanNo, loanType, conn);
		if(gurantor1!=null && !gurantor1.equalsIgnoreCase(""))
		{
			UserInfo mm=obj.memberBasicDetail(gurantor1, conn);
			ss.setAttribute("noticeG1Name", mm.getFirst_applicantName());
			ss.setAttribute("noticeG1FHname", mm.getFather_husband_name());
			ss.setAttribute("noticeG1Address", mm.getAddress());
			RequestContext.getCurrentInstance().execute("window.open('printDueNoticeGuarantor.xhtml')");
		}
		
	}
	
	
	public void printLoanLedger()
	{
		dailyPayList = new ArrayList<>();
		
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getLoanNo());
		}
		
		loan_info.setInterestAmount(String.valueOf(totalIntrest));
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("penaltyAmount", penalty);
		ss.setAttribute("penaltyPaid", totalPenaltyPaid);
		ss.setAttribute("penaltyDue", totalPenaltyDue);
		ss.setAttribute("totalChqCharge", totalChqCharge);
		ss.setAttribute("paidChqCharge", totalChqCharge);
		ss.setAttribute("dailyPayList", dailyPayList);
		ss.setAttribute("selectedVal",loan_info);
		ss.setAttribute("operationVal", "loan");
		ss.setAttribute("reportClosingBalance", totalDue);
		ss.setAttribute("disOnLoanClose",0.0);
		ss.setAttribute("printOverallEmi",loanEMIList );                  //RR 04/7 
		ss.setAttribute("totalEmi", totalEmi);                            //RR 04/7 
		ss.setAttribute("totalIntrest",totalIntrest);                     //RR 04/7 
		ss.setAttribute("totalPrincipal", totalPrincipal);                //RR 04/7 
		ss.setAttribute("totalPaid", totalPaid);                          //RR 04/7 
		     
		RequestContext.getCurrentInstance().execute("window.open('loanLedger.xhtml')");	
	}
	
	public void loanCloseMethod() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedLoan", loan_info);
		ss.setAttribute("pageName","payLoanEMI.xhtml");
		
		FacesContext.getCurrentInstance().getExternalContext().redirect("loanCloser.xhtml");
	}
	
	public void mapRedirect()
	{
		RequestContext.getCurrentInstance().execute("window.open('https://www.google.com/maps')");
		//FacesContext.getCurrentInstance().getExternalContext().redirect("https://www.google.com/maps");
	}
	
	public void copyEmiAmount()
	{
		for(int i=0;i<grpLoanMemberList.size();i++)
		{
			grpLoanMemberList.get(i).setPaidAmount(grpLoanMemberList.get(i).getInstallAmount());
		}
	}
		
	public List<String> completeLoanNo(String name)
	{
		if ("GKFC MICROSERVICES FOUNDATION".equalsIgnoreCase(companyName)) 
		{
			if (name != null)
			{
			    name = name.replaceFirst("^(PL|GL|SL)(?!-)", "$1-");
			}
		}
		
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		if(loanType != null)
		{
			nameList = new DataBaseAutoCompAndDuplicate().showLoanNoByLoanType(branchId,name,loanType);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null,new FacesMessage("Please Select Loan Type First"));
		}
		return nameList;
	}

	public void proceedWithNew() throws IOException
	{  
		   loanNo=newLoanNo;
		   HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		   ss.setAttribute("restructureLoan",loanNo);
		   ss.setAttribute("pageName","self");
		   ss.setAttribute("resLoanType", loanType);
		
		   FacesContext.getCurrentInstance().getExternalContext().redirect("payLoanEMI.xhtml");
		   /*// System.out.println(loanNo);
		   init();
		   userInfo();*/
		
	}
	
	public void userInfo() throws ParseException, SQLException 
	{
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			renderBut=false;
		}
		else
		{
			renderBut=true;
		}
		
		HttpSession ss1=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		pageName=(String) ss1.getAttribute("pageName");
		Connection conn=DataBaseConnection.JAVAConnection();
		if(pageName!=null && pageName.equals("particularLoan"))
		{
			loanNo=((LoanInfo) ss1.getAttribute("selectedLoan")).getLoanNo();
		}
		else
		{
			if(loanNo.contains("/"))
			{
				loanNo=loanNo.substring(0,loanNo.indexOf("/"));
			}
		}
		
		
		if(loanType.equals("grouploan"))
		{
			appType=obj.checkAppTypeForGroupLoan(loanNo);
			if(appType.equalsIgnoreCase("common"))
			{
				commonMethod();
				showMemberTable=false;
			}
			else
			{
				grpLoanMemberList=obj.loanListInGroupLoan(loanNo,conn);
				showMemberTable=true;
				showMemberTableSingle=true;
				showMemberTableMultiple=false;
			}
		}
		else
		{
			commonMethod();
			showMemberTable=false;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void emiPaymentOption()
	{
		if(emiPayment.equalsIgnoreCase("single"))
		{
			showMemberTableSingle=true;
			showMemberTableMultiple=false;
		}
		else
		{
			showMemberTableSingle=false;
			showMemberTableMultiple=true;
			renderTable1=false;
			show=false;
		}
	}
	
	
	public void multiPayConfirmMethod()
	{
		totalEmiPayAmount=0;
		confirmMultiSelectedList=new ArrayList<>();
		int count=1;
		if(multiSelectedList.size()>0)
		{
			for(int i=0; i<multiSelectedList.size(); i++)
			{
				/*System.out.println(multiSelectedList.get(i).getPaidAmount());
				System.out.println(multiSelectedList.get(i).getInstallAmount());
				System.out.println("Devide Value: "+multiSelectedList.get(i).getPaidAmount()/multiSelectedList.get(i).getInstallAmount());*/
				if(multiSelectedList.get(i).getPaidAmount()>0 && multiSelectedList.get(i).getPaidAmount()==multiSelectedList.get(i).getInstallAmount())
				{
					totalEmiPayAmount+=multiSelectedList.get(i).getPaidAmount();
					multiSelectedList.get(i).setSno(count++);
					confirmMultiSelectedList.add(multiSelectedList.get(i));
				}
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select Atleast One Loan To Pay EMI"));
		}
	}
	
	public void multiSubmitPayment() throws IOException
	{
		
		Connection conn=DataBaseConnection.JAVAConnection();
		boolean flag=true;
		int count=1;
		for(LoanInfo ll: confirmMultiSelectedList)
		{
			double interestAmount=0, principleAmount=0;
			loanEMIList=obj.loanInstallment("grouploan",ll.getSubLoanNo(), conn);
			user_info=obj.userInfoByLoanNoLoanType(ll.getSubLoanNo(),"grouploan", conn);
			loan_info=obj.loanInfoByLoanNoLoanType(ll.getSubLoanNo(),"grouploan", conn);
			loop:for(LoanInfo kk:loanEMIList)
			{
				if(kk.getStatus().equalsIgnoreCase("Due"))
				{
					emiNo=kk.getSno();
					if(kk.getInstallAmount()==ll.getPaidAmount())
					{
						flag=true;
						interestAmount=Double.parseDouble(kk.getInterestAmount());
					}
					else
					{
						flag=false;
					}
					break loop;
				}
				else
				{
					flag=false;
				}
			}
			if(flag==true)
			{
				
				HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
				int branchId = (int) ss.getAttribute("branchId");
				receipt_no=String.valueOf(obj.loanPayReceiptNo());
				myId = obj.payLoanEMI(branchId,ll.getSubLoanNo(),"grouploan",ll.getPaidAmount(),currentDate,"cash","",null,"",0,receipt_no,"N/A","No",0, emiNo, loan_info.getDsacode(), ll.getAttendance(),"");
				if (myId >= 1) 
				{
					count++;
					principleAmount=ll.getPaidAmount()-interestAmount;
					
					obj.updateInterestAmountInLoanPayReceipt(branchId,myId, interestAmount);
					obj.decreaseSharedCompanyAmount(branchId,principleAmount);
					sendMessage(ll, user_info, conn);
				}	
			}
		}
		
		if(count>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(count+" EMI Amount Paid Sucessfully."));
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			FacesContext.getCurrentInstance().getExternalContext().redirect("mainDashBoard.xhtml");
		}
		
		
	}
	
	public void printDailyPay()
	{
		dailyPayList= new ArrayList<>();
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getLoanNo());
		}
		loan_info.setInterestAmount(String.valueOf(totalIntrest));
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("penaltyAmount", penalty);
		ss.setAttribute("penaltyPaid", totalPenaltyPaid);
		ss.setAttribute("penaltyDue", totalPenaltyDue);
		ss.setAttribute("totalChqCharge", totalChqCharge);
		ss.setAttribute("paidChqCharge", paidChqcharge);
		ss.setAttribute("dailyPayList", dailyPayList);
		ss.setAttribute("selectedVal",loan_info);
		ss.setAttribute("operationVal", "loan");
		ss.setAttribute("reportClosingBalance", totalDue);
		ss.setAttribute("disOnLoanClose",0.0);
		ss.setAttribute("printOverallEmi",loanEMIList );                  //RR 04/7 
		ss.setAttribute("totalEmi", totalEmi);                            //RR 04/7 
		ss.setAttribute("totalIntrest",totalIntrest);                     //RR 04/7 
		ss.setAttribute("totalPrincipal", totalPrincipal);                //RR 04/7 
		ss.setAttribute("totalPaid", totalPaid);                          //RR 04/7 
		     
		  
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDatePayment.xhtml')");
		
	}
	
	
	public void printDailyPayOld()
	{
		dailyPayList= new ArrayList<>();
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getLoanNo());
		}
		loan_info.setInterestAmount(String.valueOf(totalIntrest));
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("penaltyAmount", penalty);
		ss.setAttribute("penaltyPaid", totalPenaltyPaid);
		ss.setAttribute("penaltyDue", totalPenaltyDue);
		ss.setAttribute("totalChqCharge", totalChqCharge);
		ss.setAttribute("paidChqCharge", paidChqcharge);
		ss.setAttribute("dailyPayList", dailyPayList);
		ss.setAttribute("selectedVal",loan_info);
		ss.setAttribute("operationVal", "loan");
		ss.setAttribute("reportClosingBalance", totalDue);
		ss.setAttribute("disOnLoanClose",0.0);
		ss.setAttribute("printOverallEmi",loanEMIList );               //RR 14/5 
		ss.setAttribute("totalEmi", totalEmi);                         //RR 14/5
		ss.setAttribute("totalIntrest",totalIntrest);                  // RR 14/5
		ss.setAttribute("totalPrincipal", totalPrincipal);             // RR 14/5
		ss.setAttribute("totalPaid", totalPaid);                       // RR 14/5
		     
		  
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDatePaymentOld.xhtml')");
		
	}
	
	public void viewMemberDetails() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("viewselecteduser", user_info);
		
		RequestContext.getCurrentInstance().execute("window.open('viewShareHolder.xhtml')");
	}
	
	public void viewG1Details() 
	{
		if(loan_info.getFirstGuarantor()!=null && !loan_info.getFirstGuarantor().equals(""))
		{
			UserInfo g1info=new UserInfo();
			g1info.setShareHolderNo(loan_info.getFirstGuarantor());
		
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			ss.setAttribute("viewselecteduser", g1info);
			
			RequestContext.getCurrentInstance().execute("window.open('viewShareHolder.xhtml')");
		}
	}
	
	private void sendMessage(LoanInfo ul, UserInfo uu, Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		String check=obj.checkStatusInMessageSettingTable("Multiple Loan Emi");
		if(check.equals("active"))
		{
			boolean isDLT = dbmt.isDLTMessageApi(conn);
			if (isDLT) 
			{
				Map<String, String> variables = new HashMap<>();
				variables.put("name", user_info.getFirst_applicantName());
				variables.put("amount", String.valueOf(ul.getPaidAmount()));
				
				dbmt.sendDLTMessage(user_info.getContactNo(), null, variables, conn, "loan EMI payment");
				
			}
			else 
			{
				String typeMessage="Dear "+uu.getFirst_applicantName()+", Rs. "+ul.getPaidAmount()+savingAmount+" Submit Sucessfully By "+paymentMode;
				obj.runMessageUrl(branchId,uu.getContactNo(), typeMessage, userId,"1207161822711123650", 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."));
		}
		
	}	
	public void commonMethod() throws ParseException, SQLException
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(loanType.equalsIgnoreCase("grouploan") && !appType.equalsIgnoreCase("common"))
		{
			loanNo=selectedMember.getSubLoanNo();
		}
		oldLoanNo=loanNo;
		user_info=obj.userInfoByLoanNoLoanType(loanNo,loanType,conn);
		loan_info=obj.loanInfoByLoanNoLoanType(loanNo,loanType, conn);
		loan_info.setDisbursementDate(
				dbrj.loanDisburseDateByLoanNo(loanNo, conn)
			);
		
		//amount=loan_info.getInstallAmount();
		value1=value2=false;
		chequeDate=null;chequeNo=bankName="";paymentMode="cash";
		paidEMI=0;
		
		if(loan_info.getEmiMode().equals("both"))
		{
			renderTableField=true;
		}
		
		if(user_info!=null)
		{
			show=true;
			renderTable1=true;
		}
		else
		{
			show=false;
			renderTable1=false;
		}
		
		loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
		
		loop:for(LoanInfo ll:loanEMIList)
		{
			if(ll.getStatus().equalsIgnoreCase("Due"))
			{
				emiNo=ll.getSno();
				amount=ll.getInstallAmount();
				break loop;
			}
		}
		savingAmount=loan_info.getExtraAmt();
		
		
		currentEmiAmountDue=currentDueEmi=0;
		for(int l=0;l<loanEMIList.size();l++)
		{
			Date dt=new Date();
			if(loanEMIList.get(l).getStatus().equals("Paid"))
			{
				loanEMIList.get(l).setColorStatus("paid");
			}
			else
			{
				if(loanEMIList.get(l).getInstallDate().before(dt))
				{
					loanEMIList.get(l).setColorStatus("due");
					currentDueEmi+=1;
					currentEmiAmountDue+=loanEMIList.get(l).getDueAmount();
				}
				else
				{
					loanEMIList.get(l).setColorStatus("upcoming");
				}
			}
		}
		
		loanEMIList=obj.penaltyCalculationMethod(loanType, loanNo, loanEMIList, conn);
		
		double totPaid=obj.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);
		if(totPaid>0)
		{
			for(int i=0; i<loanEMIList.size(); i++)
			{
				if(totPaid>loanEMIList.get(i).getPenaltyDue())
				{
					loanEMIList.get(i).setPenaltyPaid(loanEMIList.get(i).getPenaltyDue());
				}
				else
				{
					loanEMIList.get(i).setPenaltyPaid(totPaid);
					break;
				}
				totPaid=totPaid-loanEMIList.get(i).getPenaltyDue();
			}
			
		}
	
		
		totalPenaltyDue=totalPenaltyPaid=totalIntrest=totalEmi=totalPrincipal=totalDue=totalPaid=0;
		for(LoanInfo ll: loanEMIList)
		{
			totalEmi+=ll.getInstallAmount();
			totalIntrest+=Double.parseDouble(ll.getInterestAmount());
			totalPrincipal+=Double.parseDouble(ll.getPrincipalAmount());
			totalPaid+=ll.getPaidAmount();
			totalDue+=ll.getDueAmount();
			totalPenaltyDue+=ll.getPenaltyDue();
			totalPenaltyPaid+=ll.getPenaltyPaid();
		}
		penaltyDiscount=new DataBaseMethods().discountOnPenaltyByLoanNo(loanNo);
		currentPenaltyDue=totalPenaltyDue-(totalPenaltyPaid+penaltyDiscount);
		totalEmi=Math.round(totalEmi);
		totalIntrest=Math.round(totalIntrest);
		totalPrincipal=Math.round(totalPrincipal);
		totalPaid=Math.round(totalPaid);
		totalDue=Math.round(totalDue);
		totalPenaltyDue=Math.round(totalPenaltyDue);
		penaltyDiscount=Math.round(penaltyDiscount);
		totalPenaltyPaid=Math.round(totalPenaltyPaid);
		
		
		totalChqCharge=obj.calculatePenaltyAndChequeBounceCharges(loanNo, "Cheque Bounce",loanType, conn);
		paidChqcharge=obj.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Cheque Bounce", conn);
		
		balanceChqCharge = totalChqCharge - paidChqcharge;
		if (balanceChqCharge<0) {
			balanceChqCharge=0;
		}
		balanceChqCharge=Double.parseDouble(dc.format(balanceChqCharge));
		
		loanBalance=(totalEmi+totalPenaltyDue+totalChqCharge)-(totalPaid+totalPenaltyPaid+paidChqcharge+penaltyDiscount);
		loanBalance=Double.parseDouble(dc.format(loanBalance));
		
		for(LoanInfo ll:loanEMIList)
		{
			if(ll.getStatus().equalsIgnoreCase("Paid"))
			{
				paidEMI=paidEMI+1;
			}
		}
		
		//for dynamic cheque bounce 
		int i = 0;
		chargeB = dbr.getbounce(conn);
				
		for(LoanInfo ll:loanEMIList) {
			
			if (ll.getStatus().equalsIgnoreCase("Paid") 
					&& ll.getEmiPaidDate() != null
			        && ll.getInstallDate() != null
			        && ll.getEmiPaidDate().after(ll.getInstallDate())) {	
				
			
				String remark = dbr.getRemark(loanNo,ll.getSno(), conn);
				System.out.println("chek remark"+ll.getRemark());
				
		        // eNACH payment ko cheque bounce count me include nahi karna
		        if (remark != null && remark.toLowerCase().contains("payment successfully debited from the customer".toLowerCase())) {

		            //System.out.println("Skipping eNACH EMI : " + ll.getSno()
		            //                             + " | Remark : " + remark);
		            continue;
		            
		        }
		        i++;
			}
		       
			else if (ll.getStatus().equalsIgnoreCase("Due")
					  && ll.getInstallDate() != null
					  && ll.getInstallDate().before(new Date())) {
				i++;
			}
			
			
		}
		
		chequeBounceDetail();
		double manualCharge = dbr.TotalManualCharges(loanNo,conn); //papa bolo
		int j = chequeBounceEmiCount;
		System.out.println("system generated list size"+j);
		double ChekAmt = chargeB * j ;
		chequeBounceAmt = ChekAmt + manualCharge;
		//System.out.println("total bounce charge amount"+chequeBounceAmt);
		
		
		/*double sum=0,sump=0;
		for(LoanInfo ll: loanEMIList)
		{
			sum+=Double.valueOf(ll.getInterestAmount());
			sump+=Double.valueOf(ll.getPrincipalAmount());
		}
		// System.out.println("intr: "+sum);
		// System.out.println("pr: "+sump);
*/
		
		loanResNo="";
		disableRes=true;
		showRestructure=showTransferSelect=false;
		paidPrincipal=bulkAmount=remainingPrincipal=newEmi=newIntrAmount=0;
		remainingTerms=0;
		if(!loanType.equals("grouploan"))
		{
			checkRes=obj.checkRestructureOrNot(loanNo,loanType);
			if(checkRes==true)
			{
				disablePreRes=disableSub=true;
				showMsg=true;
				renderTable1=false;
				loanResNoList=obj.loanResNoList(loanNo,loanType);
				checkPaidDetail();
				renderTable2=true;
				renderLoanRes=true;
			}
			else
			{
				disablePreRes=disableSub=false;
				showMsg=false;
				renderTable2=false;
				renderTable1=true;
				renderLoanRes=false;
				preResAmt=0;
			}
		}
		

		transactionHistory=obj.viewDebitLoanHistory(loanType,loanNo,user_info.getShareHolderNo(),conn);
	}
	
	//dynamic bounce charge
//	public void chequeBounceDetail()
//	{
//	    chequeBounceDetailList = new ArrayList<LoanInfo>();
//
//	    try
//	    {
//	        Connection conn = DataBaseConnection.JAVAConnection();
//	        int j = 0;
//	        double chargeB = dbr.getbounce(conn);
//
//	        for(LoanInfo ll : loanEMIList)
//	        {
//	            if(ll.getStatus().equalsIgnoreCase("Paid")
//	                    && ll.getEmiPaidDate() != null
//	                    && ll.getEmiPaidDate().after(ll.getInstallDate()))
//	            {	
//	            	String remark = dbr.getRemark(loanNo, ll.getSno(), conn);
//	            	 if (remark != null && remark.toLowerCase().contains("payment successfully debited from the customer".toLowerCase())) {
//
//	 		            System.out.println("Skipping eNACH EMI : " + ll.getSno()
//	 		                                         + " | Remark : " + remark);
//	 		            continue;
//	            	 }
//	            	ll.setLoanNo(loanNo);
//	            	ll.setEmiNo(""+ll.getSno());
//	                chequeBounceDetailList.add(ll);
//	                j++;
//	            }
//	            else if(ll.getStatus().equalsIgnoreCase("Due")
//	            		&& ll.getInstallDate() != null
//	                    && ll.getInstallDate().before(new Date()))
//	            {	
//	            	ll.setLoanNo(loanNo);
//	            	ll.setEmiNo(""+ll.getSno());
//	                chequeBounceDetailList.add(ll);
//	                j++;
//	            }
//	            //double bounceEmi = chargeB * j ;
//	            
//	        }
//	        double bounceEmi = chargeB * j;
//	        System.out.println("boounce charge for due emi RAVI=="+bounceEmi);
//	        conn.close();
//	    }
//	    catch(Exception e)
//	    {
//	        e.printStackTrace();
//	    }
//	}
	
	// Dynamic bounce charge
	public void chequeBounceDetail()
	{
	    chequeBounceDetailList = new ArrayList<LoanInfo>();
	    manualChargeList = new ArrayList<LoanInfo>();

	    Connection conn = null;

	    try
	    {
	        conn = DataBaseConnection.JAVAConnection();

	        int j = 0;
	        chargeB = dbr.getbounce(conn);

	        // Fetch system generated EMI details
	        for(LoanInfo ll : loanEMIList)
	        {
	            if(ll.getStatus().equalsIgnoreCase("Paid")
	                    && ll.getEmiPaidDate() != null
	                    && ll.getInstallDate() != null
	                    && ll.getEmiPaidDate().after(ll.getInstallDate()))
	            {
	                String remark = dbr.getRemark(loanNo, ll.getSno(), conn);

	                // Skip successful eNACH payments
	                if(remark != null &&
	                   remark.toLowerCase().contains(
	                       "payment successfully debited from the customer"))
	                {
	                    continue;
	                }

	                ll.setLoanNo(loanNo);
	                ll.setEmiNo(String.valueOf(ll.getSno()));

	                chequeBounceDetailList.add(ll);
	            }
	            else if(ll.getStatus().equalsIgnoreCase("Due")
	                    && ll.getInstallDate() != null
	                    && ll.getInstallDate().before(new Date()))
	            {
	                ll.setLoanNo(loanNo);
	                ll.setEmiNo(String.valueOf(ll.getSno()));

	                chequeBounceDetailList.add(ll);
	            }
	        }

	        manualChargeList = dbr.showManualCharges(loanNo, conn);

	        //  Compare EMI Paid Date with Manual Charge Date
//	        java.util.Iterator<LoanInfo> iterator = chequeBounceDetailList.iterator();
//	        
//
//	        while(iterator.hasNext())
//	        {
//	            LoanInfo emi = iterator.next();
//
//	            if(emi.getEmiPaidDate() == null)
//	            {
//	                continue;
//	            }
//
//	            for(LoanInfo manual : manualChargeList)
//	            {
//	                if(manual.getPaidDate() != null)
//	                {
//	                    SimpleDateFormat sdf =
//	                            new SimpleDateFormat("dd-MM-yyyy");
//
//	                    String emiPaidDate =
//	                            sdf.format(emi.getEmiPaidDate());
//
//	                    String manualPaidDate =
//	                            sdf.format(manual.getPaidDate());
//
//	                    if(emiPaidDate.equals(manualPaidDate))
//	                    {
//	                        // Remove duplicate system generated EMI
//	                        iterator.remove();
//	                        break;
//	                    }
//	                }
//	            }
//	        }
	        
	        
	     // Compare EMI Due Date, Manual Charge Date and EMI Paid Date

	        java.util.Iterator<LoanInfo> iterator =
	                chequeBounceDetailList.iterator();

	        Calendar cal = Calendar.getInstance();

	        while(iterator.hasNext())
	        {
	            LoanInfo emi = iterator.next();

	            // Only Paid EMI can be compared with manual charge date
	            if(emi.getEmiPaidDate() == null || emi.getInstallDate() == null)
	            {
	                continue;
	            }

	            for(LoanInfo manual : manualChargeList)
	            {
	                if(manual.getPaidDate() != null)
	                {
	                    cal.setTime(manual.getPaidDate());
	                    cal.set(Calendar.HOUR_OF_DAY, 0);
	                    cal.set(Calendar.MINUTE, 0);
	                    cal.set(Calendar.SECOND, 0);
	                    cal.set(Calendar.MILLISECOND, 0);
	                    Date manualDate = cal.getTime();

	                    cal.setTime(emi.getInstallDate());
	                    cal.set(Calendar.HOUR_OF_DAY, 0);
	                    cal.set(Calendar.MINUTE, 0);
	                    cal.set(Calendar.SECOND, 0);
	                    cal.set(Calendar.MILLISECOND, 0);
	                    Date installmentDate = cal.getTime();

	                    cal.setTime(emi.getEmiPaidDate());
	                    cal.set(Calendar.HOUR_OF_DAY, 0);
	                    cal.set(Calendar.MINUTE, 0);
	                    cal.set(Calendar.SECOND, 0);
	                    cal.set(Calendar.MILLISECOND, 0);
	                    Date emiPaidDate = cal.getTime();

	                    // Manual Charge Date must be between EMI Due Date and EMI Paid Date
	                    if(!manualDate.before(installmentDate)
	                            && !manualDate.after(emiPaidDate))
	                    {
	                        iterator.remove();
	                        break;
	                    }
	                }
	            }
	        }
	        

	        // Calculate remaining bounce EMI count
	        
	         chequeBounceEmiCount = chequeBounceDetailList.size();
	      

	        System.out.println("Manual Charge List Size : "
	                + manualChargeList.size());

	        System.out.println("System Generated Bounce EMI Size : "
	                + chequeBounceDetailList.size());

	        System.out.println("Final Bounce EMI Count : " + j);

	        System.out.println("Total Bounce Charge : " + chequeBounceAmt);

	    }
	    catch(Exception e)
	    {
	        e.printStackTrace();
	    }
	    finally
	    {
	        try
	        {
	            if(conn != null)
	            {
	                conn.close();
	            }
	        }
	        catch(Exception e)
	        {
	            e.printStackTrace();
	        }
	    }
	}
	
	public void paidBounceChargeDetails() {

	    Connection conn = null;
	    chequeBounceDetailList = new ArrayList<LoanInfo>();
	   
	    try {

	        conn = DataBaseConnection.JAVAConnection();

	        System.out.println("Bean Loan No : " + loanNo);

	        chequeBounceDetailList = dbr.paidChequeBounceCharges(loanNo, "Cheque Bounce", conn);

	        System.out.println("Paid Bounce List Size : "
	                + chequeBounceDetailList.size());

	    } catch (Exception e) {
	        e.printStackTrace();
	    } finally {

	        try {
	            if (conn != null)
	                conn.close();

	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	    }
	}
	
	
	
	public void checkTransferMode()
	{
		if(transfer.equals("Yes"))
		{
			showTransfer=true;
		}
		else
		{
			showTransfer=false;
		}
	}
	
	public void forPaymentMode()
	{
		if (paymentMode.equals("0")) 
		{
			value1 = value2= false;
		}
		else if(paymentMode.equalsIgnoreCase("Transfer"))      // Option Develop on 07-May-2023
		{
			savingDetail=obj.savingAccountDetailByShareHolderNo(user_info.getShareHolderNo());
			savingAccountNo=savingDetail.getAccountNo();
			if(savingAccountNo!=null && !savingAccountNo.equals(""))
			{
				showSaving=true;
				value1 = true;
				value2 = false;
				showTransfer=false;
				showTransferSelect=true;
				bankName=chequeNo="";
				chequeDate=null;
			}
			else
			{
				paymentMode="";
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(user_info.getShareHolderNo()+" Doesn't any Saving Account. Please open a Saving Account Than Transfer Amount. "));
			}
		}
		else if (paymentMode.equalsIgnoreCase("cash")) 
		{
			showSaving=false;
			value1 = true;
			value2 = false;
			showTransfer=false;
			showTransferSelect=true;
			bankName=chequeNo=transfer="";
			chequeDate=null;
		}
		else
		{
			showSaving=false;
			label=paymentMode;
			value2 = true;
			value1 = false;
			showTransferSelect=false;
			showTransfer=true;
			transfer=bankName=chequeNo="";
			chequeDate=null;
			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 backButton()
	{
		if(pageName==null || pageName.equals(""))
		{
			pageName="mainDashBoard.xhtml";
		}
		else if(pageName.equals("self"))
		{
			pageName="cashInOutFlow";
		}
		return pageName;
	}
	
	public String submitPayment() throws ParseException 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		//For Trial Period Static Method
		int flag=1;
		Date dd= new Date();
		String string = "31/12/2026";
		DateFormat format = new SimpleDateFormat("dd/MM/yyyy");
		Date date = format.parse(string);
		if(dd.after(date))
		{	
			flag = 0;
		}
		
		if(!paymentMode.equalsIgnoreCase("Cash"))
		{
			chequeDate=currentDate;
		}
		//valodation
//		if (loan_info.getApprovalDate() != null && currentDate.before(loan_info.getApprovalDate()))
//		{
//		    FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR,
//		                                     "EMI payment date cannot be before Loan Disbursement Date.", null));
//		    return "";
//		}
		
		if(flag==1)
		{
			msgPenaltyAmt=penalty;  ///Use only in for send Msg 
			if(loan_info.getReason()!=null && loan_info.getReason().equalsIgnoreCase("restructure") && loan_info.getIncreaseAmount()==0)
			{
				if(paymentMode.equalsIgnoreCase("Cash") || paymentMode.equalsIgnoreCase("Transfer"))
				{
					submittedBankName="N/A";
				}
				
				if(amount<=0)
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount must be greater than zero!"));
					return "";
				}
				
				boolean z=new DataBaseMethodsDuplicate().loanReceiptDuplicacy(receipt_no);
				if(z==true)
				{
					receipt_no=String.valueOf(obj.loanPayReceiptNo());
				}
				
				boolean status=obj.loanPayemntStatus(loanType,loanNo);
				if(status==true)
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Approve Your Previous Payment To Make Further Payment"));
				}
				else
				{
					
					boolean chk=allLoanPayMethod();
				 	if(chk==true)
				 	{
				 		sendMessage();
						ss.setAttribute("restructureLoan","");
						ss.setAttribute("pageName","");
						ss.setAttribute("resLoanType", "");
						
						value2= false;paymentMode=chequeNo=bankName="";
						penalty=amount=0;chequeNo=bankName="";chequeDate=null;show=false;
						receipt_no=String.valueOf(obj.loanPayReceiptNo());
						Connection conn=DataBaseConnection.JAVAConnection();
						
						loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
						dueAmount=0;
						for(LoanInfo ll:loanEMIList)
						{
							dueAmount+=ll.getDueAmount();
							if(ll.getStatus().equals("Paid"))
							{
								interestAmount=Double.parseDouble(ll.getInterestAmount());
							}
						}
						
						/*if(dueAmount==0)
						{
							obj.updateStatusOfLoan(loanType,loanNo);
						}*/
						
						try {
							conn.close();
						} catch (SQLException e) {
							// TODO Auto-generated catch block
							e.printStackTrace();
						}
				 		return "payLoanEMI.xhtml";
				 	}
					/*double totalAmount=0;
					for(LoanInfo ll:loanEMIList)
					{
						totalAmount+=ll.getInstallAmount();
					}
					double paidAmount=obj.loanPaidAmountByUser(loanType, loanNo);
					double remainingAmount=Double.parseDouble(dc.format(totalAmount-paidAmount));
					if(remainingAmount>=amount)
					{
						int	n = obj.payLoanEMI(loanNo,loanType,amount,currentDate,paymentMode,chequeNo,chequeDate,bankName,penalty,receipt_no,submittedBankName,restructureStatus,0);
						if (n >= 1) 
						{
							myId=n;
							loanEMIList=obj.loanInstallment(loanType,loanNo);
							for(LoanInfo ll:loanEMIList)
							{
								if(ll.getStatus().equals("Paid"))
								{
									interestAmount=Double.parseDouble(ll.getInterestAmount());
									principleAmount=Double.parseDouble(ll.getPrincipalAmount());
								}
							}
							
							if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
								
								obj.updateInterestAmountInLoanPayReceipt(myId, interestAmount);
								obj.decreaseSharedCompanyAmount(principleAmount);
								detailsForLoanPrint();
								RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
							}
							else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
							{
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
								
								obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
								obj.increaseBankBalance(submittedBankName, amount);
								detailsForLoanPrint();
								RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
							}
							else
							{
								obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
								FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
							}
							value2= false;paymentMode=chequeNo=bankName="";
							penalty=amount=0;chequeNo=bankName="";chequeDate=null;show=false;
							receipt_no=String.valueOf(obj.loanPayReceiptNo());
							loanEMIList=obj.loanInstallment(loanType,loanNo);
							dueAmount=0;
							for(LoanInfo ll:loanEMIList)
							{
								dueAmount+=ll.getDueAmount();
								if(ll.getStatus().equals("Paid"))
								{
									interestAmount=Double.parseDouble(ll.getInterestAmount());
								}
							}
							
							if(dueAmount==0)
							{
								obj.updateStatusOfLoan(loanType,loanNo);
							}
							loanNo="";
							return "cashInOutFlow";
						}
						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
			{
				int rAmount=obj.checkReleaseLoanAmount(loanNo);
				//// System.out.println("Release Amount: "+rAmount);
				if(rAmount>=amount || rAmount==Double.parseDouble(loan_info.getLoanAmount()))
				{
					if(paymentMode.equalsIgnoreCase("Cash") || paymentMode.equalsIgnoreCase("transfer"))
					{
						submittedBankName="N/A";
					}
					
					if(amount<=0)
					{
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount must be greater than zero!"));
						return "";
					}
					
					boolean z=new DataBaseMethodsDuplicate().loanReceiptDuplicacy(receipt_no);
					if(z==true)
					{
						receipt_no=String.valueOf(obj.loanPayReceiptNo());
					}
					
					boolean status=obj.loanPayemntStatus(loanType,loanNo);
					if(status==true)
					{
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Approve Your Previous Payment To Make Further Payment"));
					}
					else
					{
						
						boolean chk=allLoanPayMethod();
					 	if(chk==true)
					 	{
					 		Connection conn=DataBaseConnection.JAVAConnection();
							sendMessage();
							addSavingAmount(conn);
							ss.setAttribute("restructureLoan","");
							ss.setAttribute("pageName","");
							ss.setAttribute("resLoanType", "");
							
							value2= false;paymentMode=chequeNo=bankName="";
							penalty=amount=savingAmount=0;chequeNo=bankName="";chequeDate=null;show=false;
							receipt_no=String.valueOf(obj.loanPayReceiptNo());
							loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
							dueAmount=0;
							for(LoanInfo ll:loanEMIList)
							{
								dueAmount+=ll.getDueAmount();
								if(ll.getStatus().equals("Paid"))
								{
									interestAmount=Double.parseDouble(ll.getInterestAmount());
								}
							}
							
							/*if(dueAmount==0)
							{
								obj.updateStatusOfLoan(loanType,loanNo);
							}*/
							
							try {
								conn.close();
							} catch (SQLException e) {
								// TODO Auto-generated catch block
								e.printStackTrace();
							}
							
							return "payLoanEMI.xhtml";
					 	}
						/*double totalAmount=0;
						for(LoanInfo ll:loanEMIList)
						{
							totalAmount+=ll.getInstallAmount();
						}
						double paidAmount=obj.loanPaidAmountByUser(loanType, loanNo);
						double remainingAmount=Double.parseDouble(dc.format(totalAmount-paidAmount));
						if(remainingAmount>=amount)
						{
							int	n = obj.payLoanEMI(loanNo,loanType,amount,currentDate,paymentMode,chequeNo,chequeDate,bankName,penalty,receipt_no,submittedBankName,restructureStatus,0);
							if (n >= 1) 
							{
								myId=n;
								loanEMIList=obj.loanInstallment(loanType,loanNo);
								for(LoanInfo ll:loanEMIList)
								{
									if(ll.getStatus().equals("Paid"))
									{
										interestAmount=Double.parseDouble(ll.getInterestAmount());
										principleAmount=Double.parseDouble(ll.getPrincipalAmount());
									}
								}
								
								if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
								{
									FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
									
									obj.updateInterestAmountInLoanPayReceipt(myId, interestAmount);
									obj.decreaseSharedCompanyAmount(principleAmount);
									detailsForLoanPrint();
									RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
								}
								else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
								{
									FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
									
									obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
									obj.increaseBankBalance(submittedBankName, amount);
									detailsForLoanPrint();
									RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
								}
								else
								{
									obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
									FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
								}
								value2= false;paymentMode=chequeNo=bankName="";
								penalty=amount=0;chequeNo=bankName="";chequeDate=null;show=false;
								receipt_no=String.valueOf(obj.loanPayReceiptNo());
								loanEMIList=obj.loanInstallment(loanType,loanNo);
								dueAmount=0;
								for(LoanInfo ll:loanEMIList)
								{
									dueAmount+=ll.getDueAmount();
									if(ll.getStatus().equals("Paid"))
									{
										interestAmount=Double.parseDouble(ll.getInterestAmount());
									}
								}
								
								if(dueAmount==0)
								{
									obj.updateStatusOfLoan(loanType,loanNo);
								}
								loanNo="";
								return "cashInOutFlow";
							}
							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("Dear User, Before Pay EMI, Loan Amount Must be Release!!!"));
				}
			}
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Some Error Occured!!!"));
		}
		return "";
	}
	
	private void sendMessage() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String check=obj.checkStatusInMessageSettingTable("Pay Loan Emi");
		if(check.equals("active"))
		{
			double msgAmt=amount+msgPenaltyAmt+savingAmount+bounceCharge;
			
			boolean isDLT = dbmt.isDLTMessageApi(conn);
			if (isDLT) 
			{
				Map<String, String> variables = new HashMap<>();
				variables.put("name", user_info.getFirst_applicantName());
				variables.put("amount", String.valueOf(msgAmt));
				
				dbmt.sendDLTMessage(user_info.getContactNo(), null, variables, conn, "loan EMI payment");
				
			}
			else 
			{
				String typeMessage="Dear "+user_info.getFirst_applicantName()+", Rs. "+msgAmt+" Submit Sucessfully By "+paymentMode;
				obj.runMessageUrl(branchId,user_info.getContactNo(), typeMessage, userId,"1207166054372658827", 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 (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	String emis="";
	
	private boolean allLoanPayMethod() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		double totalAmount=0;
		for(LoanInfo ll:loanEMIList)
		{
			totalAmount+=ll.getInstallAmount();
		}
		double paidAmount=obj.loanPaidAmountByUser(loanType, loanNo, conn);
		double remainingAmount=Double.parseDouble(dc.format(totalAmount-paidAmount));
		if(remainingAmount>=amount)
		{
			
			double rmemi=loanEMIList.get(emiNo-1).getDueAmount();
			
			if(rmemi>=amount)
			{
				emis=String.valueOf(emiNo);
				payEmiPayment(amount);
			}
			else
			{
				double firsteiamount=rmemi;
				payEmiPayment(firsteiamount);
				emis=String.valueOf(emiNo);
				double secondemiamount=amount-rmemi;
				while(secondemiamount>0)
				{
					double rmsemi=loanEMIList.get(emiNo).getDueAmount();
					emiNo=emiNo+1; 
					
					if(rmsemi>=secondemiamount)
					{
						emis=emis+","+String.valueOf(emiNo);
						payEmiPayment(secondemiamount);
					   secondemiamount=0;
					}
					else
					{
						emis=emis+","+String.valueOf(emiNo);
						double ammnt =rmsemi;
						payEmiPayment(ammnt);
						secondemiamount=secondemiamount-rmsemi;
					}
				}
			}
			
			detailsForLoanPrint(emis);
			RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
			RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt1.xhtml')");
			RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt2.xhtml')");
			if(penalty>0)
			{
				voucherNo=obj.generateVoucherNo(branchId,"income_table",conn);
				int i=new DataBaseIncomeExpense().addIncome(branchId,currentDate,"Other_Cr",paymentMode,String.valueOf(penalty),chequeNo,"",
						bankName,chequeDate,"Receive Loan Penalty","Receive Penalty",0,submittedBankName,
						"0",0,loanNo,loanType, voucherNo,"",0,"active",loan_info.getDsacode()); 
				if(i>0)
				{
					printVoucherDetail(penalty,"Receive Loan Penalty",conn);
					if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
					{
						obj.decreaseSharedCompanyAmount(branchId,penalty);/// Increase amount due to Penalty Amount
					}
					else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
					{
						obj.increaseBankBalance(submittedBankName, penalty,conn); /// Increase amount due to Penalty Amount
					}
					penalty=0;
				}
			}
			payBounceCharges(loanNo, bounceCharge, conn,paymentMode,submittedBankName); // develop on 3-7-25 RR
			
			if(paymentMode.equalsIgnoreCase("cash") || paymentMode.equalsIgnoreCase("transfer"))
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
			}
			
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
			return true;
		}
		else 
		{
			FacesContext fc = FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("You Have To Pay Only "+remainingAmount));
		}
		
		return false;
	}
	
	
	
	private void payBounceCharges(String loanNo, double bounceCharge, Connection conn, String paymentMode, String submittedBankName) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
//		String paymentMode="cash";
		if(bounceCharge>0)
		{
			voucherNo=obj.generateVoucherNo(branchId,"income_table",conn);
			int i=new DataBaseIncomeExpense().addIncome(branchId,currentDate,"Other_Cr",paymentMode,String.valueOf(bounceCharge),chequeNo,"",
					bankName,chequeDate,"Receive Cheque Bounce Charge","Receive Cheque Bounce Charge",0,submittedBankName,
					"0",0,loanNo,loanType, voucherNo,"",0,"active",loan_info.getDsacode()); 
			if(i>0)
			{
				printVoucherDetail(bounceCharge,"Receive Cheque Bounce Charge",conn);
				if(paymentMode.equalsIgnoreCase("Cash"))
				{
					obj.decreaseSharedCompanyAmount(branchId
							,bounceCharge);/// Increase amount due to Bounce Charges Amount
				}
				
				bounceCharge=0;
			}
		}
	}
	
	
	
	
	public void printVoucherDetail(double amt , String item,Connection conn)
	{
		HeaderBean hh=new HeaderBean();
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", voucherNo);
		ss.setAttribute("expDate", currentDate);
		ss.setAttribute("amount", String.valueOf(amt));
		ss.setAttribute("vchtype", "Credit");
		ss.setAttribute("payTo", hh.getName());
		ss.setAttribute("being", item+" From - "+loanNo+" - "+obj.firstApplicantNameBySHNo(user_info.getShareHolderNo(), conn));
		ss.setAttribute("payMode", paymentMode);
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}
	
	
	public boolean payEmiPayment(double amount)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String restructureStatus="No";
		calculateEmiPayAmount(amount, conn);
		myId = obj.payLoanEMI(branchId,loanNo,loanType,amount,currentDate,paymentMode,chequeNo,chequeDate,bankName,penalty,receipt_no,submittedBankName,restructureStatus,0, emiNo, loan_info.getDsacode(), attendance,"");
		if (myId >= 1) 
		{
			//this function to update status for ptp
			int ptpResult = dbr.updatePtpAfterEmiPay(loanNo, emiNo, amount, currentDate, branchId, conn);
		   // System.out.println("PTP UPDATE RESULT = " + ptpResult);
			
			if(!paymentMode.equalsIgnoreCase("Cash"))
			{
				obj.increaseBankBalance(submittedBankName, amount,conn);
			}
			
			if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
			{
				//FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
				//obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
				//obj.decreaseSharedCompanyAmount(amount);
				
				//code replace due to discount in minus and principal is more than Loan amount then we need to adjust in Interest Amount 
				if(Double.parseDouble(loan_info.getLoanTerm())==emiNo)
				{
					//System.out.println("Term: "+loan_info.getLoanTerm()+"emi no: "+emiNo);
					//System.out.println("before: "+interestAmount+" Dis: "+loan_info.getDiscount());
					interestAmount=interestAmount-loan_info.getDiscount();
					//System.out.println("after: "+interestAmount);
				}
				
				principleAmount=amount-interestAmount;
				
				obj.updateInterestAmountInLoanPayReceipt(branchId,myId, interestAmount);
				obj.decreaseSharedCompanyAmount(branchId,principleAmount);
				/*detailsForLoanPrint();
				
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");*/
			}
			else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
			{
				//FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
				
				obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
				obj.increaseBankBalance(submittedBankName, amount,conn);
			/*
				detailsForLoanPrint();
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");*/
			}
			
			else if(paymentMode.equalsIgnoreCase("Transfer"))
			{
				String svRemark="Loan "+loanNo+" EMI Deposit";
				int	n = obj.userWithdrwal(branchId,savingAccountNo, String.valueOf(amount), currentDate,paymentMode, chequeNo, chequeDate, bankName, "","approved",svRemark,"");
				if (n >= 1) 
				{
					double preAmount=obj.acconuntHolderAmountByAccountNo(savingAccountNo);
					Double newAmount=preAmount-amount;
					obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
				}
				
				if(Double.parseDouble(loan_info.getLoanTerm())==emiNo)
				{
					interestAmount=interestAmount-loan_info.getDiscount();
				}
				obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
			}
			
			else
			{
				obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
				//FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
				/*detailsForLoanPrint();
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");*/
			}
			//value2= false;paymentMode=chequeNo=bankName="";
			//penalty=amount=0;chequeNo=bankName="";chequeDate=null;show=false;showIntrest=showPrincipal=showPaytype=false;
			receipt_no=String.valueOf(obj.loanPayReceiptNo());
			loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
			dueAmount=0;
			for(LoanInfo ll:loanEMIList)
			{
				dueAmount+=ll.getDueAmount();
				if(ll.getStatus().equals("Paid"))
				{
					interestAmount=Double.parseDouble(ll.getInterestAmount());
				}
			}
			
			//DSA Commission Auto Credit When EMI Complete Paid
			
			// check old loan plan
			
			if(loan_info.getPlanNo()==null || loan_info.equals(""))
			{
				commission=0;
			}
			else
			{
				// System.out.println("emiiiiiiiii: "+emiNo);
				if(loanEMIList.get(emiNo-1).getStatus().equalsIgnoreCase("paid"))
				{
					if(loan_info.getDsacode()==null || loan_info.getDsacode().equals(""))
					{
						commission=0;
					}
					else
					{
						commissionInfo=obj.checkPlanCommissionDetail(loan_info.getPlanNo(), conn);
						if(commissionInfo==null || commissionInfo.getStatusNullCheck().equalsIgnoreCase("0"))
						{
							// System.out.println("null pointer: hello Loan EMI");
							commission=0;
						}
						else
						{
							double val=loanEMIList.get(emiNo-1).getInstallAmount();
							// System.out.println("method called: "+val);
							if(commissionInfo.getCommissionBase().equalsIgnoreCase("collection"))
						   {
							   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
							   {
								   commission=(val/100)*commissionInfo.getCommission_value();
							   }
							   else
							   {
								   commission=commissionInfo.getCommission_value();
							   }
							   if(commission>0)
								{
								   boolean checkEntry=obj.checkDuplicacyInDsaCommissionTable(loan_info.getLoanNo(),  String.valueOf(emiNo));
								   if(checkEntry==false)
								   {
									   String dsaName=obj.dsaNameById(loan_info.getDsacode(),conn);
										int j=obj.insertDataInDsaCommissionTable(branchId,loan_info.getLoanType(), loan_info.getLoanNo(), loan_info.getDsacode(), commission, currentDate, String.valueOf(emiNo));
										try {
											conn.close();
										} catch (Exception e) {
											// TODO: handle exception
										}
										if(j>0)
										{
											FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Commission Auto Credited to "+loan_info.getDsacode()+" - "+dsaName+" Rs.:- "+commission));
										}
								   }
								}
						   }
						   else
						   {
							   commission=0;
						   }
						   commission=Double.parseDouble(dc.format(commission));
						}
						
					}
				}
			}
			return true;
		}
		else
		{
			FacesContext fc = FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			return false;
		}
	}
	
	

	private void calculateEmiPayAmount(double amount, Connection conn) 
	{
		//loanEMIList=obj.loanInstallment(loanType,loanNo);
		double lastPayAmt=obj.emiPaidAmountByEmiNo(loanNo, emiNo, conn);
		//// System.out.println(lastPayAmt);
		if(lastPayAmt>0)
		{
			double paytotalint=obj.emiPaidInterestByEmiNo(loanNo, emiNo, conn);
			double emiIntr=Double.parseDouble(loanEMIList.get(emiNo-1).getInterestAmount());
			emiIntr=Double.parseDouble(dc.format(emiIntr));
			//// System.out.println(paytotalint);
			if(paytotalint==emiIntr)
			{
				interestAmount=0;
				//// System.out.println("hiiii");
			}
			else
			{
				//// System.out.println("hello");
				double  intres=emiIntr-paytotalint;
				intres=Double.parseDouble(dc.format(intres));
				if(amount>=intres)
				{
					interestAmount=intres;
				}
				else
				{
					interestAmount=amount;
				}
			    
			}
			/*double emiAmt=loanEMIList.get(emiNo).getInstallAmount();
			
			if(lastPayAmt>=emiIntr)
			{
				double emiinterrr=0;
				double amounmnnn=lastPayAmt-emiIntr;
				
			}
			else
			{
				
			}*/
		}
		else
		{
			double emiIntr=Double.parseDouble(loanEMIList.get(emiNo-1).getInterestAmount());
			
			
			if(amount>=emiIntr)
			{
				interestAmount=emiIntr;
			}
			else 
			{
				/*// System.out.println("else out");
				if(amount>=emiIntr)
				{
					interestAmount=emiIntr;
				}
				else
				{
					interestAmount=amount;
				}*/
				
				interestAmount=amount;
				
				//// System.out.println("intrest amount: "+interestAmount);
			}
			
		}
	}
	
	
	
	public void openRestructure()
	{
		if(paidEMI > 0)
		{
			Date lastPaidDate = new Date();
			
			findLoanResNo();
			bulkAmount=0;
			increaseAmount=0;
			renderAmt=false;
			showRestructure=true;
			paidPrincipal=0;
			remainingTerms=0;
			newRate=Double.valueOf(loan_info.getLoanInterest());
			double mainLoanAmount=Double.valueOf(loan_info.getLoanAmount());
			double remLoanAmount=0;
			for(LoanInfo ll: loanEMIList)
			{
				if(ll.getStatus().equalsIgnoreCase("Paid"))
				{
					paidPrincipal+=Double.valueOf(ll.getPrincipalAmount());
					paidPrincipal=Double.parseDouble(dc.format(paidPrincipal));
				}
				
				if(ll.getStatus().equalsIgnoreCase("Due"))
				{
					remainingTerms=remainingTerms+1;
				}
			}
			
			remLoanAmount=mainLoanAmount-paidPrincipal;
			int i=0;
			//loanEMIList=obj.loanInstallment(loanType,loanNo);
			if(paidEMI==0)
			{
				loopxx:for(LoanInfo ll: loanEMIList)
				{
					if((paidEMI+1)==ll.getSno())
					{
						i=i+1;
						// System.out.println(i);
						lastPaidDate=ll.getInstallDate();
						// System.out.println(ll.getInstallDate());
						break loopxx;
					}
				}
			}
			else
			{
				loopx:for(LoanInfo ll: loanEMIList)
				{
					if(paidEMI==ll.getSno())
					{
						i=i+1;
						// System.out.println(i);
						lastPaidDate=ll.getInstallDate();
						// System.out.println(ll.getInstallDate());
						break loopx;
					}				
				}
			}
			
			calculateInterestOnBulkAmount(lastPaidDate,currentDate,remLoanAmount);
			remainingPrincipal=Double.valueOf(loan_info.getLoanAmount())-(paidPrincipal);
			calculateEMI();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please pay atleast ONE EMI before restructure. "));	
		}	
	}
	
	
	
	public void checkForPrincipal()
	{
		//Date lastPaidDate=new Date();
		
		double prevRemAmt=Double.valueOf(loan_info.getLoanAmount())-(paidPrincipal);
		if(prevRemAmt>=bulkAmount)
		{
			remainingPrincipal=Double.valueOf(loan_info.getLoanAmount())-(paidPrincipal+bulkAmount);
			remainingPrincipal=remainingPrincipal+increaseAmount;
			remainingPrincipal=Double.parseDouble(dc.format(remainingPrincipal));
			disableRes=false;
			
			calculateEMI();
			/*calculateEMI();
			int i=0;
			//loanEMIList=obj.loanInstallment(loanType,loanNo);
			loopx:for(LoanInfo ll: loanEMIList)
			{
				if(paidEMI==ll.getSno())
				{
					i=i+1;
					// System.out.println(i);
					lastPaidDate=ll.getInstallDate();
					// System.out.println(ll.getInstallDate());
					break loopx;
				}
				
			}
			calculateInterestOnBulkAmount(lastPaidDate,currentDate);*/
		}
		else
		{
			newDiscountOnLastEmi=0;
			newEmi=remainingPrincipal=newIntrAmount=0;
			disableRes=true;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Only Rs."+prevRemAmt+" Principal is Pending. Please Check!"));
		}
	}
	
	public String payment() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String restructureStatus=loanResNo;
		if(paymentMode.equalsIgnoreCase("Cash") || paymentMode.equalsIgnoreCase("transfer"))
		{
			submittedBankName="N/A";
		}
		
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount must be greater than zero!"));
			return "";
		}
		
		boolean z=new DataBaseMethodsDuplicate().loanReceiptDuplicacy(receipt_no);
		if(z==true)
		{
			receipt_no=String.valueOf(obj.loanPayReceiptNo());
		}
		
		int	n = obj.payLoanEMI(branchId,loanNo,loanType,bulkAmount,currentDate,paymentMode,chequeNo,chequeDate,bankName,penalty,receipt_no,submittedBankName,restructureStatus,0, -2, loan_info.getDsacode(), attendance,"");
		if (n >= 1) 
		{
			myId=n;
			loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
			for(LoanInfo ll:loanEMIList)
			{
				if(ll.getStatus().equals("Paid"))
				{
					interestAmount=Double.parseDouble(ll.getInterestAmount());
					principleAmount=Double.parseDouble(ll.getPrincipalAmount());
				}
			}
			
			if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
				
				obj.updateInterestAmountInLoanPayReceipt(branchId,myId, newIntrAmount);
				obj.decreaseSharedCompanyAmount(branchId,bulkAmount);
				detailsForLoanPrint1();
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt1.xhtml')");
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt2.xhtml')");
			}
			else if(paymentMode.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
				
				obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, newIntrAmount);
				obj.increaseBankBalance(submittedBankName, bulkAmount,conn);
				detailsForLoanPrint1();
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
				RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt1.xhtml')");
			}
			else
			{
				obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, newIntrAmount);
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
			}
			value2= false;paymentMode=chequeNo=bankName="";
			penalty=amount=0;chequeNo=bankName="";chequeDate=null;show=false;
			receipt_no=String.valueOf(obj.loanPayReceiptNo());
			loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
			dueAmount=0;
			for(LoanInfo ll:loanEMIList)
			{
				dueAmount+=ll.getDueAmount();
				if(ll.getStatus().equals("Paid"))
				{
					interestAmount=Double.parseDouble(ll.getInterestAmount());
				}
			}
			
			if(dueAmount==0)
			{
				obj.updateStatusOfLoan(loanType,loanNo);
			}
			loanNo="";
			ss.setAttribute("restructureLoan","");
			ss.setAttribute("pageName","");
			ss.setAttribute("resLoanType", "");
			
			FacesContext.getCurrentInstance().getExternalContext().redirect("cashInOutFlow.xhtml");
		}
		else
		{
			FacesContext fc = FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		}
		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		
		return "";
		
	}
	
	public void doRestructure() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int flag=0;
		if(loanType.equalsIgnoreCase("personalloan"))
		{
			int x=obj.personalLoanRestructure(branchId,loanType,user_info.getShareHolderNo(),loanResNo,loan_info,0,remainingPrincipal,remainingTerms,newEmi,currentDate,
														newDiscountOnLastEmi,newRate,increaseAmount);
			if(x>=1)
			{
				flag=1;
				payment();
			}
			
		}
		else if(loanType.equalsIgnoreCase("propertyloan"))
		{
			int x=obj.propertyLoanRestructure(branchId,loanType,user_info.getShareHolderNo(),loanResNo,loan_info,0,remainingPrincipal,remainingTerms,newEmi,currentDate,
														newDiscountOnLastEmi,newRate,increaseAmount);
			if(x>=1)
			{
				flag=1;
				payment();
			}
		}
		else if(loanType.equalsIgnoreCase("vechicleloan"))
		{
			int x=obj.vechicleLoanRestructure(branchId,loanType,user_info.getShareHolderNo(),loanResNo,loan_info,0,remainingPrincipal,remainingTerms,newEmi,currentDate,
														newDiscountOnLastEmi,newRate,increaseAmount);
			if(x>=1)
			{
				flag=1;
				payment();
			}
		}
		else if(loanType.equalsIgnoreCase("grouploan"))
		{
			int x=obj.groupLoanRestructure(branchId,loanType,user_info.getShareHolderNo(),loanResNo,loan_info,0,remainingPrincipal,remainingTerms,newEmi,currentDate,
													newDiscountOnLastEmi,newRate,increaseAmount);
			if(x>=1)
			{
				flag=1;
				payment();
			}
		}
		
		if(flag==1)
		{
			obj.updateOldLoanRestructureStatus(oldLoanNo, loanType);
		}
	}
	
	public void cancelRestructure()
	{
		loanResNo="";
		paidPrincipal=0;
		remainingPrincipal=0;
		remainingTerms=0;
		bulkAmount=0;
		increaseAmount=0;
		newIntrAmount=0;
		newRate=0;
		newEmi=0;
		showRestructure=false;
		renderAmt=true;
	}
	
	public void calculateInterestOnBulkAmount(Date lastPaidDate, Date todayDate, double remLoanAmount) 
	{
		Timestamp lstDate=null,tdyDate=null;
		lstDate=new Timestamp(lastPaidDate.getTime());
		tdyDate=new Timestamp(todayDate.getTime());
		tdyDate.setHours(0);tdyDate.setMinutes(0);tdyDate.setSeconds(0);tdyDate.setNanos(0);
		long days=getDifferenceDays(lstDate, tdyDate);
		double interestRateMonthly =Double.parseDouble(new DecimalFormat("##.#######").format(Double.valueOf(loan_info.getLoanInterest()) / (100.00 * 365)));
		newIntrAmount=remLoanAmount*interestRateMonthly*days;
		newIntrAmount=Double.parseDouble(dc.format(newIntrAmount));
	}

	public void findLoanResNo()
	{   
 
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		String num=obj.findResLoanNo(branchId,loanNo,loanType);
		if(num.equalsIgnoreCase("NA"))
		{   
			loanResNo=loanNo+"R"+1;
		}
		else
		{   
			
			String tmp[]=num.split("R");
			int x=Integer.valueOf(tmp[1]);
			x=x+1;
			loanResNo=tmp[0]+"R"+x;
		    
		}
	}
	
	int myId=0;
	public void detailsForLoanPrint(String emis2)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("shareHolderNo", user_info.getShareHolderNo());
		ss.setAttribute("loanNo",loanNo);
		ss.setAttribute("receipt_no",receipt_no);
		ss.setAttribute("installment_amount",amount+savingAmount);
		ss.setAttribute("loanType", loanType);
		ss.setAttribute("id",myId);
		ss.setAttribute("receipt_date",new SimpleDateFormat("dd/MM/yyyy").format(currentDate));
		ss.setAttribute("instlmnt_no",emis2 );
		ss.setAttribute("payMode",paymentMode+" "+chequeNo);
		ss.setAttribute("penalty", penalty);
		ss.setAttribute("bounceCharge", bounceCharge);
	}
	
	public void detailsForLoanPrint1()
	{
		String tmp="Restructure";
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("shareHolderNo", user_info.getShareHolderNo());
		ss.setAttribute("loanNo",loanNo);
		ss.setAttribute("receipt_no",receipt_no);
		ss.setAttribute("installment_amount",bulkAmount+newIntrAmount);
		ss.setAttribute("loanType", loanType);
		ss.setAttribute("id",myId);
		ss.setAttribute("receipt_date",new SimpleDateFormat("dd/MM/yyyy").format(currentDate));
		ss.setAttribute("instlmnt_no",tmp);
		ss.setAttribute("payMode",paymentMode+" "+chequeNo);
	}

	public void calculateEMI()
	{
		if(loan_info.getEmiType().equalsIgnoreCase("reducing"))
		{
			newEmi=obj.calculateLoanEmi(remainingPrincipal,Double.valueOf(remainingTerms),newRate, loan_info.getFrequencyVal());  	
			if(remainingPrincipal==0)
			{
				newEmi=0;newDiscountOnLastEmi=0;
			}
			
			if(newEmi>0)
			{
				// System.out.println("dd : "+newEmi);
					double totalPayment=newEmi*remainingTerms;
					double falseInterest=totalPayment-remainingPrincipal;
					double trueInterest=obj.totalInterestForDiscount(remainingPrincipal,remainingTerms,newRate,loan_info.getFrequencyVal(),newEmi);
					trueInterest=Math.round(trueInterest);
					newDiscountOnLastEmi=(int) (falseInterest-trueInterest);
					newDiscountOnLastEmi=Math.round(newDiscountOnLastEmi);
			}
		}
		else
		{
			newEmi=obj.calculateLoanEmiForCalculator(remainingPrincipal,Double.valueOf(remainingTerms),newRate, loan_info.getFrequencyVal(), "both");  	
			if(remainingPrincipal==0)
			{
				newEmi=0;newDiscountOnLastEmi=0;
			}
			
			if(newEmi>0)
			{
				double totalPayment=newEmi*remainingTerms;
				double falseInterest=totalPayment-remainingPrincipal;
				double trueInterest=(remainingPrincipal*newRate*remainingTerms)/(100*loan_info.getFrequencyVal());
				trueInterest=Math.round(trueInterest);
				newDiscountOnLastEmi=(int) (falseInterest-trueInterest);
				newDiscountOnLastEmi=Math.round(newDiscountOnLastEmi);	
				
				
			}
		}
		
	}
	
	
	public void addSavingAmount(Connection conn)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		if(savingAmount>0)
 		{
 			String accno=obj.savingAccountByShareHolderNo(user_info.getShareHolderNo());
 			String app_status="approved";
 			String detail=loanNo+" EMI Deposit";
 			int	n = obj.userDeposit(branchId,accno, String.valueOf(savingAmount), currentDate,"cash", "", null, "",app_status,"N/A",detail, "");
			if (n >= 1) 
			{
				double preAmount=obj.acconuntHolderAmountByAccountNo(accno);
				Double newAmount=preAmount+savingAmount;
				obj.updateSavingAmountByAccountNo(accno,newAmount);
				obj.increaseCompanyCapitalAmount(branchId,savingAmount,conn);
			}
 		}
	}
	
	public void checkPaidPenaltyDetail()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		penaltyPaidDlg=new DataBaseMethods().totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);
		penaltyDiscountDlg=0.0;
		penaltyList=new DataBaseReportMethods().paidPenaltyListByLoanNo(loanNo);
		for(LoanInfo ll: penaltyList)
		{
			penaltyDiscountDlg+=ll.getDiscount();
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static long getDifferenceDays(Date d1, Date d2) 
	{
		long diff = d2.getTime() - d1.getTime();
		/*// System.out.println("diff : "+diff);
		// System.out.println("diff : "+TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
		*/
		return (TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
	}
	
	
	public double getNewIntrAmount() {
		return newIntrAmount;
	}

	public void setNewIntrAmount(double newIntrAmount) {
		this.newIntrAmount = newIntrAmount;
	}

	public int getRemainingTerms() {
		return remainingTerms;
	}

	public void setRemainingTerms(int remainingTerms) {
		this.remainingTerms = remainingTerms;
	}

	public UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	
	public String getLoanResNo() {
		return loanResNo;
	}

	public void setLoanResNo(String loanResNo) {
		this.loanResNo = loanResNo;
	}

	public boolean isDisableRes() {
		return disableRes;
	}

	public void setDisableRes(boolean disableRes) {
		this.disableRes = disableRes;
	}

	public double getPaidPrincipal() {
		return paidPrincipal;
	}

	public void setPaidPrincipal(double paidPrincipal) {
		this.paidPrincipal = paidPrincipal;
	}

	public double getRemainingPrincipal() {
		return remainingPrincipal;
	}

	public void setRemainingPrincipal(double remainingPrincipal) {
		this.remainingPrincipal = remainingPrincipal;
	}
	
	public double getNewEmi() {
		return newEmi;
	}

	public void setNewEmi(double newEmi) {
		this.newEmi = newEmi;
	}

	public Date getCurrentDate() {
		return currentDate;
	}
	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}
	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 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 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 String getLoanNo() {
		return loanNo;
	}
	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}
	public String getLoanType() {
		return loanType;
	}
	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}
	public boolean isShowLoanNo() {
		return showLoanNo;
	}
	public void setShowLoanNo(boolean showLoanNo) {
		this.showLoanNo = showLoanNo;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}
	public LoanInfo getLoan_info() {
		return loan_info;
	}
	public void setLoan_info(LoanInfo loan_info) {
		this.loan_info = loan_info;
	}
	public ArrayList<LoanInfo> getLoanEMIList() {
		return loanEMIList;
	}
	public void setLoanEMIList(ArrayList<LoanInfo> loanEMIList) {
		this.loanEMIList = loanEMIList;
	}

	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 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 getBulkAmount() {
		return bulkAmount;
	}

	public void setBulkAmount(double bulkAmount) {
		this.bulkAmount = bulkAmount;
	}

	public boolean isShowRestructure() {
		return showRestructure;
	}

	public double getPreResAmt() {
		return preResAmt;
	}

	public void setPreResAmt(double preResAmt) {
		this.preResAmt = preResAmt;
	}

	public void setShowRestructure(boolean showRestructure) {
		this.showRestructure = showRestructure;
	}

	public boolean isShowMsg() {
		return showMsg;
	}

	public void setShowMsg(boolean showMsg) {
		this.showMsg = showMsg;
	}

	public boolean isDisablePreRes() {
		return disablePreRes;
	}

	public void setDisablePreRes(boolean disablePreRes) {
		this.disablePreRes = disablePreRes;
	}

	public boolean isDisableSub() {
		return disableSub;
	}

	public void setDisableSub(boolean disableSub) {
		this.disableSub = disableSub;
	}

	public int getPaidEMI() {
		return paidEMI;
	}

	public void setPaidEMI(int paidEMI) {
		this.paidEMI = paidEMI;
	}

	public double getEmiAmount() {
		return emiAmount;
	}

	public void setEmiAmount(double emiAmount) {
		this.emiAmount = emiAmount;
	}

	public double getDueAmount() {
		return dueAmount;
	}

	public void setDueAmount(double dueAmount) {
		this.dueAmount = dueAmount;
	}

	public double getInterestAmount() {
		return interestAmount;
	}

	public void setInterestAmount(double interestAmount) {
		this.interestAmount = interestAmount;
	}

	public double getTotalPenaltyDue() {
		return totalPenaltyDue;
	}

	public void setTotalPenaltyDue(double totalPenaltyDue) {
		this.totalPenaltyDue = totalPenaltyDue;
	}

	public double getTotalPenaltyPaid() {
		return totalPenaltyPaid;
	}

	public void setTotalPenaltyPaid(double totalPenaltyPaid) {
		this.totalPenaltyPaid = totalPenaltyPaid;
	}

	public double getTotalIntrest() {
		return totalIntrest;
	}

	public void setTotalIntrest(double totalIntrest) {
		this.totalIntrest = totalIntrest;
	}

	public double getTotalEmi() {
		return totalEmi;
	}

	public void setTotalEmi(double totalEmi) {
		this.totalEmi = totalEmi;
	}

	public double getTotalPrincipal() {
		return totalPrincipal;
	}

	public void setTotalPrincipal(double totalPrincipal) {
		this.totalPrincipal = totalPrincipal;
	}

	public double getTotalDue() {
		return totalDue;
	}

	public void setTotalDue(double totalDue) {
		this.totalDue = totalDue;
	}

	public double getTotalPaid() {
		return totalPaid;
	}

	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}

	public double getTotalChqCharge() {
		return totalChqCharge;
	}

	public void setTotalChqCharge(double totalChqCharge) {
		this.totalChqCharge = totalChqCharge;
	}

	public double getPaidChqcharge() {
		return paidChqcharge;
	}

	public void setPaidChqcharge(double paidChqcharge) {
		this.paidChqcharge = paidChqcharge;
	}

	public double getLoanBalance() {
		return loanBalance;
	}

	public void setLoanBalance(double loanBalance) {
		this.loanBalance = loanBalance;
	}

	public ArrayList<LoanInfo> getEmiPaidDetailList() {
		return emiPaidDetailList;
	}

	public void setEmiPaidDetailList(ArrayList<LoanInfo> emiPaidDetailList) {
		this.emiPaidDetailList = emiPaidDetailList;
	}
	public double getIncreaseAmount() {
		return increaseAmount;
	}

	public void setIncreaseAmount(double increaseAmount) {
		this.increaseAmount = increaseAmount;
	}

	public double getNewRate() {
		return newRate;
	}

	public void setNewRate(double newRate) {
		this.newRate = newRate;
	}

	public boolean isRenderAmt() {
		return renderAmt;
	}

	public void setRenderAmt(boolean renderAmt) {
		this.renderAmt = renderAmt;
	}

	public boolean isRenderTable1() {
		return renderTable1;
	}

	public void setRenderTable1(boolean renderTable1) {
		this.renderTable1 = renderTable1;
	}

	public boolean isRenderTable2() {
		return renderTable2;
	}

	public void setRenderTable2(boolean renderTable2) {
		this.renderTable2 = renderTable2;
	}

	public boolean isRenderLoanRes() {
		return renderLoanRes;
	}

	public void setRenderLoanRes(boolean renderLoanRes) {
		this.renderLoanRes = renderLoanRes;
	}

	public ArrayList<SelectItem> getLoanResNoList() {
		return loanResNoList;
	}

	public void setLoanResNoList(ArrayList<SelectItem> loanResNoList) {
		this.loanResNoList = loanResNoList;
	}

	public String getNewLoanNo() {
		return newLoanNo;
	}

	public void setNewLoanNo(String newLoanNo) {
		this.newLoanNo = newLoanNo;
	}

	public boolean isShowMemberTable() {
		return showMemberTable;
	}

	public void setShowMemberTable(boolean showMemberTable) {
		this.showMemberTable = showMemberTable;
	}

	public boolean isRenderBut() {
		return renderBut;
	}

	public void setRenderBut(boolean renderBut) {
		this.renderBut = renderBut;
	}

	public ArrayList<LoanInfo> getGrpLoanMemberList() {
		return grpLoanMemberList;
	}

	public void setGrpLoanMemberList(ArrayList<LoanInfo> grpLoanMemberList) {
		this.grpLoanMemberList = grpLoanMemberList;
	}

	public LoanInfo getSelectedMember() {
		return selectedMember;
	}

	public void setSelectedMember(LoanInfo selectedMember) {
		this.selectedMember = selectedMember;
	}

	public String getVoucherNo() {
		return voucherNo;
	}

	public void setVoucherNo(String voucherNo) {
		this.voucherNo = voucherNo;
	}

	public double getCurrentPenaltyDue() {
		return currentPenaltyDue;
	}

	public void setCurrentPenaltyDue(double currentPenaltyDue) {
		this.currentPenaltyDue = currentPenaltyDue;
	}

	public double getCurrentEmiAmountDue() {
		return currentEmiAmountDue;
	}

	public void setCurrentEmiAmountDue(double currentEmiAmountDue) {
		this.currentEmiAmountDue = currentEmiAmountDue;
	}

	public double getPenaltyDiscount() {
		return penaltyDiscount;
	}

	public void setPenaltyDiscount(double penaltyDiscount) {
		this.penaltyDiscount = penaltyDiscount;
	}

	public boolean isRenderTableField() {
		return renderTableField;
	}

	public void setRenderTableField(boolean renderTableField) {
		this.renderTableField = renderTableField;
	}

	public String getEmiPayment() {
		return emiPayment;
	}

	public void setEmiPayment(String emiPayment) {
		this.emiPayment = emiPayment;
	}

	public boolean isShowMemberTableSingle() {
		return showMemberTableSingle;
	}

	public void setShowMemberTableSingle(boolean showMemberTableSingle) {
		this.showMemberTableSingle = showMemberTableSingle;
	}

	public boolean isShowMemberTableMultiple() {
		return showMemberTableMultiple;
	}

	public void setShowMemberTableMultiple(boolean showMemberTableMultiple) {
		this.showMemberTableMultiple = showMemberTableMultiple;
	}

	public ArrayList<LoanInfo> getMultiSelectedList() {
		return multiSelectedList;
	}

	public void setMultiSelectedList(ArrayList<LoanInfo> multiSelectedList) {
		this.multiSelectedList = multiSelectedList;
	}

	public ArrayList<LoanInfo> getConfirmMultiSelectedList() {
		return confirmMultiSelectedList;
	}

	public void setConfirmMultiSelectedList(
			ArrayList<LoanInfo> confirmMultiSelectedList) {
		this.confirmMultiSelectedList = confirmMultiSelectedList;
	}

	public double getTotalEmiPayAmount() {
		return totalEmiPayAmount;
	}

	public void setTotalEmiPayAmount(double totalEmiPayAmount) {
		this.totalEmiPayAmount = totalEmiPayAmount;
	}

	public int getCurrentDueEmi() {
		return currentDueEmi;
	}

	public void setCurrentDueEmi(int currentDueEmi) {
		this.currentDueEmi = currentDueEmi;
	}

	public double getSavingAmount() {
		return savingAmount;
	}

	public void setSavingAmount(double savingAmount) {
		this.savingAmount = savingAmount;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getAttendance() {
		return attendance;
	}

	public void setAttendance(String attendance) {
		this.attendance = attendance;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public ArrayList<DebitInfo> getTransactionHistory() {
		return transactionHistory;
	}

	public void setTransactionHistory(ArrayList<DebitInfo> transactionHistory) {
		this.transactionHistory = transactionHistory;
	}

	public ArrayList<LoanInfo> getPenaltyList() {
		return penaltyList;
	}

	public double getPenaltyPaidDlg() {
		return penaltyPaidDlg;
	}

	public double getPenaltyDiscountDlg() {
		return penaltyDiscountDlg;
	}

	public void setPenaltyList(ArrayList<LoanInfo> penaltyList) {
		this.penaltyList = penaltyList;
	}

	public void setPenaltyPaidDlg(double penaltyPaidDlg) {
		this.penaltyPaidDlg = penaltyPaidDlg;
	}

	public void setPenaltyDiscountDlg(double penaltyDiscountDlg) {
		this.penaltyDiscountDlg = penaltyDiscountDlg;
	}

	public double getPrincipleAmount() {
		return principleAmount;
	}

	public void setPrincipleAmount(double principleAmount) {
		this.principleAmount = principleAmount;
	}

	public String getStrNoticeDate() {
		return strNoticeDate;
	}

	public void setStrNoticeDate(String strNoticeDate) {
		this.strNoticeDate = strNoticeDate;
	}

	public double getPrincipalOd() {
		return principalOd;
	}

	public void setPrincipalOd(double principalOd) {
		this.principalOd = principalOd;
	}

	public double getInterestOd() {
		return interestOd;
	}

	public void setInterestOd(double interestOd) {
		this.interestOd = interestOd;
	}

	public double getTotalAmountPaid() {
		return totalAmountPaid;
	}

	public void setTotalAmountPaid(double totalAmountPaid) {
		this.totalAmountPaid = totalAmountPaid;
	}

	public double getTotalAmountDue() {
		return totalAmountDue;
	}

	public void setTotalAmountDue(double totalAmountDue) {
		this.totalAmountDue = totalAmountDue;
	}

	public double getAmountPaid() {
		return amountPaid;
	}

	public void setAmountPaid(double amountPaid) {
		this.amountPaid = amountPaid;
	}

	public Date getNoticeDate() {
		return noticeDate;
	}

	public void setNoticeDate(Date noticeDate) {
		this.noticeDate = noticeDate;
	}

	public boolean isShowSaving() {
		return showSaving;
	}

	public void setShowSaving(boolean showSaving) {
		this.showSaving = showSaving;
	}

	public UserInfo getSavingDetail() {
		return savingDetail;
	}

	public void setSavingDetail(UserInfo savingDetail) {
		this.savingDetail = savingDetail;
	}

	public String getSavingAccountNo() {
		return savingAccountNo;
	}

	public void setSavingAccountNo(String savingAccountNo) {
		this.savingAccountNo = savingAccountNo;
	}

	public boolean isPrintOne() {
		return printOne;
	}

	public void setPrintOne(boolean printOne) {
		this.printOne = printOne;
	}

	public boolean isPrintTwo() {
		return printTwo;
	}

	public void setPrintTwo(boolean printTwo) {
		this.printTwo = printTwo;
	}

	public boolean isPrintThree() {
		return printThree;
	}

	public void setPrintThree(boolean printThree) {
		this.printThree = printThree;
	}

	public boolean isPrintFour() {
		return printFour;
	}

	public void setPrintFour(boolean printFour) {
		this.printFour = printFour;
	}

	public double getBounceCharge() {
		return bounceCharge;
	}

	public void setBounceCharge(double bounceCharge) {
		this.bounceCharge = bounceCharge;
	}

	public double getPenaltyOd() {
		return penaltyOd;
	}

	public void setPenaltyOd(double penaltyOd) {
		this.penaltyOd = penaltyOd;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public String getAppType() {
		return appType;
	}

	public void setAppType(String appType) {
		this.appType = appType;
	}

	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 boolean isCheckRes() {
		return checkRes;
	}

	public void setCheckRes(boolean checkRes) {
		this.checkRes = checkRes;
	}

	public LoanInfo getMm() {
		return mm;
	}

	public void setMm(LoanInfo mm) {
		this.mm = mm;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	public int getNewDiscountOnLastEmi() {
		return newDiscountOnLastEmi;
	}

	public void setNewDiscountOnLastEmi(int newDiscountOnLastEmi) {
		this.newDiscountOnLastEmi = newDiscountOnLastEmi;
	}

	public int getEmiNo() {
		return emiNo;
	}

	public void setEmiNo(int emiNo) {
		this.emiNo = emiNo;
	}

	public double getCommission() {
		return commission;
	}

	public void setCommission(double commission) {
		this.commission = commission;
	}

	public double getMsgPenaltyAmt() {
		return msgPenaltyAmt;
	}

	public void setMsgPenaltyAmt(double msgPenaltyAmt) {
		this.msgPenaltyAmt = msgPenaltyAmt;
	}

	public String getUserId() {
		return userId;
	}

	public void setUserId(String userId) {
		this.userId = userId;
	}

	public String getOldLoanNo() {
		return oldLoanNo;
	}

	public void setOldLoanNo(String oldLoanNo) {
		this.oldLoanNo = oldLoanNo;
	}

	public DsaListInfo getCommissionInfo() {
		return commissionInfo;
	}

	public void setCommissionInfo(DsaListInfo commissionInfo) {
		this.commissionInfo = commissionInfo;
	}

	public ArrayList<ReportInfo> getDailyPayList() {
		return dailyPayList;
	}

	public void setDailyPayList(ArrayList<ReportInfo> dailyPayList) {
		this.dailyPayList = dailyPayList;
	}

	public ArrayList<UserInfo> getLoanList() {
		return loanList;
	}

	public void setLoanList(ArrayList<UserInfo> loanList) {
		this.loanList = loanList;
	}

	public DataBaseMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}

	public DecimalFormat getDc() {
		return dc;
	}

	public void setDc(DecimalFormat dc) {
		this.dc = dc;
	}

	public SimpleDateFormat getSf() {
		return sf;
	}

	public void setSf(SimpleDateFormat sf) {
		this.sf = sf;
	}

	public DataBaseMethodTaheer getDbmt() {
		return dbmt;
	}

	public void setDbmt(DataBaseMethodTaheer dbmt) {
		this.dbmt = dbmt;
	}

	public boolean isDaterange() {
		return daterange;
	}

	public void setDaterange(boolean daterange) {
		this.daterange = daterange;
	}

	public String getEmis() {
		return emis;
	}

	public void setEmis(String emis) {
		this.emis = emis;
	}

	public int getMyId() {
		return myId;
	}

	public void setMyId(int myId) {
		this.myId = myId;
	}

	public Date getMinPayDate() {
		return minPayDate;
	}

	public void setMinPayDate(Date minPayDate) {
		this.minPayDate = minPayDate;
	}

	public Date getMaxPayDate() {
		return maxPayDate;
	}

	public void setMaxPayDate(Date maxPayDate) {
		this.maxPayDate = maxPayDate;
	}

	public DataBaseMethodsRaviK getDbr() {
		return dbr;
	}

	public void setDbr(DataBaseMethodsRaviK dbr) {
		this.dbr = dbr;
	}

	public double getBalanceChqCharge() {
		return balanceChqCharge;
	}

	public void setBalanceChqCharge(double balanceChqCharge) {
		this.balanceChqCharge = balanceChqCharge;
	}

	public double getChequeBounceAmt() {
		return chequeBounceAmt;
	}

	public void setChequeBounceAmt(double chequeBounceAmt) {
		this.chequeBounceAmt = chequeBounceAmt;
	}

	public double getChargeB() {
		return chargeB;
	}

	public void setChargeB(double chargeB) {
		this.chargeB = chargeB;
	}

	public ArrayList<LoanInfo> getChequeBounceDetailList() {
		return chequeBounceDetailList;
	}

	public void setChequeBounceDetailList(ArrayList<LoanInfo> chequeBounceDetailList) {
		this.chequeBounceDetailList = chequeBounceDetailList;
	}

	public int getChequeBounceEmiCount() {
		return chequeBounceEmiCount;
	}

	public void setChequeBounceEmiCount(int chequeBounceEmiCount) {
		this.chequeBounceEmiCount = chequeBounceEmiCount;
	}

	public ArrayList<LoanInfo> getManualChargeList() {
		return manualChargeList;
	}

	public void setManualChargeList(ArrayList<LoanInfo> manualChargeList) {
		this.manualChargeList = manualChargeList;
	}
	
	
	
}
