package report_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRaviK;
import main_package.DsaListInfo;
import main_package.HeaderBean;
import main_package.InstallmentInfo;
import main_package.LoanInfo;
import main_package.SelectBooleanView;
import main_package.UserInfo;

@ManagedBean(name="loanReportRequestByApp")
@ViewScoped

public class LoanReportRequestByAppBean implements Serializable
{
	DataBaseMethods dbm=new DataBaseMethods();
	DataBaseReportMethods obj=new DataBaseReportMethods();
	private static final long serialVersionUID = 1L;
	Date startDate=new Date(),endDate=new Date();
	boolean show, showSavingType, showBank,status;
	LoanInfo selectedRow, loan_info;
	ArrayList<SelectItem> empList,loanList,dsaList, bankList;
	ArrayList<LoanInfo> detailsList, confirmationList,loanEMIList;
	double totalAmount, finalAmount,totalSavingAmount,interestAmount, principleAmount,commission,totalPaidEmi;
	double totalDatePayment,amountToPaid,amountPaid,dsaCommission, totalPaid, totalAmountGreen, totalAmountRed, totalAmountBlue;
	DsaListInfo commissionInfo;
	int totalEntryGreen, totalEntryRed, totalEntryBlue;
	String dsaCode, searchLoan, userId,receiptNo, payMode, bank;
	String loanType="personalloan",receipt_no,empName, searchType, entryStatus;
	int emiNo,myId;
	UserInfo user_info;
	DecimalFormat dc=new DecimalFormat("##.##");
	private String paymentSource = "ALL";
	
	 Date chequeDate,  currentDate=new Date();
	
	String voucherNo,chequeNo,bankName,paymentMode,loanNo,transctionNo;
	
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();
	

	
	public LoanReportRequestByAppBean()
	 {
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		empList= obj.empList(branchId);
		loanList= obj.loanList(branchId);
		confirmationList= new ArrayList<>();
		
		payMode = "all";
	    status = false;
	    entryStatus = "active";
	 }
	
	public void view()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		show=true;
		detailsList= new ArrayList<>();
		detailsList = obj.detailsList(startDate,endDate,empName,searchType, entryStatus, branchId, payMode,paymentSource);
		totalAmount=totalAmountGreen=totalAmountRed=totalAmountBlue=0;
		totalEntryGreen=totalEntryRed=totalEntryBlue=0;
		
		
		if(detailsList.size()>0)
		{
			for(LoanInfo uu:detailsList)
			{
				totalAmount+=uu.getAmount();
				if(uu.getStatus().equalsIgnoreCase("pending"))
				{
					totalAmountBlue+=uu.getAmount();
					++totalEntryBlue;
				}
				if(uu.getStatus().equalsIgnoreCase("active"))
				{
					totalAmountGreen+=uu.getAmount();
					++totalEntryGreen;
				}
				if(uu.getStatus().equalsIgnoreCase("delete"))
				{
					totalAmountRed+=uu.getAmount();
					++totalEntryRed;
				}
			}
		}
		
		if(searchType.equalsIgnoreCase("saving"))
		{
			showSavingType=true;
		}
		else
		{
			showSavingType=false;
		}
	}
	
	public void companyBank()
	{
		if(payMode.equalsIgnoreCase("online"))
		{
			showBank=true;
			Connection conn=DataBaseConnection.JAVAConnection();
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else
		{
			showBank=false;
		}
		
		if(payMode.equalsIgnoreCase("all"))
		{
			status = false;
			entryStatus ="active";
		}
		else {
			status = true;
		}
		
	}
	
	public void delete()
	{
		int i=dbm.updateAppPayLoanEmiStatus(selectedRow.getId(), "delete");
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Request Deleted Sucessfully."));
			view();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error In Deletion."));
		}
	}
	
	public void confirmation()
	{
		finalAmount=0.00;
		for(int i=0;i<confirmationList.size();i++)
		{
			confirmationList.get(i).setSno(i+1);
			finalAmount+=confirmationList.get(i).getAmount();
		}
		
		/*for(int i=0;i<totalSelection.size();i++)
		{
			totalDatePayment=totalDatePayment+totalSelection.get(i).getPaidAmount();
			if(totalSelection.get(i).getPaidAmount()>0)
			{  
			    totalSelection.get(i).setSno(sno++);
				confirmationList.add(totalSelection.get(i));
				
			}
		}*/
	}
	
	public void pay()
	{ 
		
		 
		Connection conn =DataBaseConnection.JAVAConnection();
		int val=0;
		if(searchType.equals("DD") ||searchType.equals("RD") || searchType.equals("FD") || searchType.equals("GD"))
		 {
        	//RequestContext.getCurrentInstance().execute("window.open('paymentReceipt.xhtml')");
        	val=depositMethod(conn);
		 }
		else if(searchType.equalsIgnoreCase("penalty"))
		{
			val=penaltyMethod(conn);
		}
		
		else if(searchType.equalsIgnoreCase("bounceCharge"))
		{
			//user_info=dbm.userInfoByLoanNoLoanType(selectedRow.getLoanNo(),searchType, conn);
		  //	user_info.setShareHolderNo(selectedRow.getShareHolderNo());
			val=payBounceCharges(selectedRow.getLoanNo(),selectedRow.getAmount(), conn,selectedRow.getPaymentMode(),bank);

		}
		
		else if(searchType.equalsIgnoreCase("saving"))
		 {
			if(selectedRow.getSavingType().equalsIgnoreCase("deposit"))
			{
				val=savingDepositMethod(conn);
			}
			
			else if(selectedRow.getSavingType().equalsIgnoreCase("withdraw"))
			{
				val=savingWithdrawMethod(conn);
			}
			
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!! Please Contact to administrator... "));
			}
			
		 }
		else
		{
			//RequestContext.getCurrentInstance().execute("window.open('payLoanEMI.xhtml')");
			val=loanMethod(selectedRow, conn);
		}
    
		if(val>0)
		{
			 int i=dbm.updateAppPayLoanEmiStatus(selectedRow.getId(), "active");
			if(i>0)
			{
				view();
			}
		}
       
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	

	private int penaltyMethod(Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		
		String voucherNo=dbm.generateVoucherNo(branchId,"income_table",conn);
		if(selectedRow.getPaymentMode().equalsIgnoreCase("cash"))
		{
			bank="N/A";
		}
		int i=new DataBaseIncomeExpense().addIncome(branchId,startDate,"Other_Cr",selectedRow.getPaymentMode(),String.valueOf(selectedRow.getAmount()),"","",
				"",selectedRow.getOfficeDate(),"Receive Loan Penalty","Receive Penalty",0,bank,
				"0",0,selectedRow.getLoanNo(),"", voucherNo,"",0,"active",selectedRow.getDsacode()); 
		if(i>0)
		{	
			
			if(selectedRow.getPaymentMode().equalsIgnoreCase("cash"))
			{
				dbm.decreaseSharedCompanyAmount(branchId,selectedRow.getAmount());/// Increase amount due to Penalty Amount
			}
			else
			{
				dbm.increaseBankBalance(bank, selectedRow.getAmount(), conn);
			}
		}
		return i;
	}
	

	public void payMultiple()
	
	{
 
		 System.out.println("payMultiple button Hit");
		
		Connection conn =DataBaseConnection.JAVAConnection();
		
		if(searchType.equals("DD") ||searchType.equals("RD") || searchType.equals("FD") || searchType.equals("GD"))
		 {
			payDepositMultiple(conn);
		 }
		else if(searchType.equalsIgnoreCase("saving"))
		{
			paySavingMultiple(conn);
		}
		else if(searchType.equalsIgnoreCase("penalty"))
		{
			payPenaltyMultiple(conn);
		}
		else
		{
			payLoanMultiple(conn);
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	
	public void payPenaltyMultiple(Connection conn)
	{
		for(int i=0;i<confirmationList.size();i++)
		{
			selectedRow=confirmationList.get(i);
			int val=penaltyMethod(conn);
			if(val>0)
			{
				dbm.updateAppPayLoanEmiStatus(selectedRow.getId(), "active");
			}
		}
		confirmationList.clear();
		view();
	}
	
	private void paySavingMultiple(Connection conn) 
	{
		for(int i=0;i<confirmationList.size();i++)
		{
			selectedRow=confirmationList.get(i);
			int val=0;
			if(selectedRow.getSavingType().equalsIgnoreCase("deposit"))
			{
				val=savingDepositMethod(conn);
			}
			
			else if(selectedRow.getSavingType().equalsIgnoreCase("withdraw"))
			{
				val=savingWithdrawMethod(conn);
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!! Please Contact to administrator... "));
			}
			
			if(val>0)
			{
				dbm.updateAppPayLoanEmiStatus(selectedRow.getId(), "active");
			}
		}
		confirmationList.clear();
		view();
	}
	

	public void payDepositMultiple(Connection conn)
	{
		for(int i=0;i<confirmationList.size();i++)
		{
			selectedRow=confirmationList.get(i);
			int val=depositMethod(conn);
			if(val>0)
			{
				dbm.updateAppPayLoanEmiStatus(selectedRow.getId(), "active");
			}
		}
		confirmationList.clear();
		view();
	}
	
	private void payLoanMultiple(Connection conn) 
	{
		for(int i=0;i<confirmationList.size();i++)
		{
			selectedRow=confirmationList.get(i);
			int val=loanMethod(selectedRow,conn);
			if(val>0)
			{
				dbm.updateAppPayLoanEmiStatus(selectedRow.getId(), "active");
			}
		}
		confirmationList.clear();
		view();
	}

	private int savingDepositMethod(Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int n=0;
		boolean check=dbm.checkEntryOfSelectedDateForKalp(selectedRow, "savingDepositMethod" ,conn);
		if(check==false)
		{
			String app_status="pending",message="Payment Done SuccessFully... Please Approve Your Payment";
			app_status="approved";
			message="Payment Done SuccessFully.";
			n = dbm.userDeposit(branchId,selectedRow.getLoanNo(), String.valueOf(selectedRow.getAmount()), selectedRow.getOfficeDate(),"cash", "", null, "",app_status,"N/A","Self",selectedRow.getDsacode());
			if (n >= 1) 
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
				double preAmount=dbm.acconuntHolderAmountByAccountNo(selectedRow.getLoanNo());
				Double newAmount=preAmount+selectedRow.getAmount();
				dbm.updateSavingAmountByAccountNo(selectedRow.getLoanNo(),newAmount);
				dbm.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedRow.getAmount()),conn);
			}	
		}
		return n;
	}

	private int savingWithdrawMethod(Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int n=0;
		boolean check=dbm.checkEntryOfSelectedDateForKalp(selectedRow, "savingWithdrawMethod" ,conn);
		if(check==false)
		{
			double preAmount=dbm.acconuntHolderAmountByAccountNo(selectedRow.getLoanNo());
			if(preAmount>=selectedRow.getAmount())
			{
				String app_status="pending",message="Payment Done SuccessFully... Please Approve Your Payment";
				app_status="approved";
				message="Payment Done SuccessFully.";
				n = dbm.userWithdrwal(branchId,selectedRow.getLoanNo(), String.valueOf(selectedRow.getAmount()), selectedRow.getOfficeDate(),"cash", "", null,
						"", "",app_status, "Self",selectedRow.getDsacode());
				if (n >= 1) 
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
					Double newAmount=preAmount-selectedRow.getAmount();
					dbm.updateSavingAmountByAccountNo(selectedRow.getLoanNo(),newAmount);
					dbm.increaseSharedCompanyAmount(branchId,selectedRow.getAmount(),conn);
				}	
			}
			else
			{
				String message="Insufficient Balance in "+selectedRow.getLoanNo();
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
			}
		}
		return n;
	}
	
	private int depositMethod(Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int n=0;
		boolean check=dbm.checkEntryOfSelectedDateForKalp(selectedRow, "depositMethod" ,conn);
		if(check==false)
		{
			ArrayList<InstallmentInfo>  dlist=dbm.showInstallment(selectedRow.getLoanNo(), conn);
	    	double paybleAmount=dbm.checkForPaymentReceipt(selectedRow.getLoanNo(),selectedRow.getType());
			double paidAmount=dbm.paidAmountByUser(selectedRow.getLoanNo(),conn);
			if(paybleAmount>paidAmount)
			{
				double remainingAmount=paybleAmount-paidAmount;
				if(remainingAmount>=selectedRow.getAmount())				
				{	
					if(selectedRow.getPaymentMode()=="cash") {
						bank="N/A";
					}
					String receiptNo=String.valueOf(dbm.receiptNo());
					n = dbm.paymentReceipt(branchId,selectedRow.getLoanNo(), selectedRow.getAmount(),selectedRow.getOfficeDate(),selectedRow.getPaymentMode(), "",null,"",0.00,receiptNo,bank,searchType,"", selectedRow.getDsacode(), 0);
					if (n >= 1) 
					  {
						calculateDsaCommissionForDeposit(selectedRow,dlist,conn);
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... for user_id "+selectedRow.getLoanNo()+" "+selectedRow.getApplicantName()));
						dbm.increaseCompanyCapitalAmount(branchId,selectedRow.getAmount(),conn);
					  }
					else
					  {
						FacesContext fc = FacesContext.getCurrentInstance();
						fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again for user_id "+selectedRow.getLoanNo()));
					  }
				}
				else
				{
					FacesContext fc = FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("You Have To Pay Only "+remainingAmount+" for user_id"+selectedRow.getLoanNo()));
				}
			}
			else 
			{
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Either You Have Paid All Installments Or Lesser Amount Than Installment Is To Be Paid for user_id "+selectedRow.getLoanNo()+"Please check!"));
			}
		}
		return n;
	}

	private void calculateDsaCommissionForDeposit(LoanInfo ff, ArrayList<InstallmentInfo> list, Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		if(ff.getPlanNo()==null || ff.getPlanNo().equals(""))
		{
			
		}
		else
			{
				if(ff.getDsacode()==null || ff.getDsacode().equals(""))
				{
					dsaCommission=0;
				}
				else
				{
					dsaCommission=0;
					commissionInfo=dbm.checkPlanCommissionDetail(ff.getPlanNo(), conn);
					if(commissionInfo==null || commissionInfo.getStatusNullCheck().equals("0"))
					{
						// System.out.println("null pointer: hello RD EMI");
						dsaCommission=0;
					}
					else
					{
						double val=0, terms=0;
						  // System.out.println("pay amt: "+amount);
							if(ff.getAmount()%ff.getInstallAmount()==0)
							{
								 if(commissionInfo.getCommissionBase().equalsIgnoreCase("collection"))
								 {
									   val=ff.getInstallAmount();
											
									   		
											   terms=ff.getAmount()/ff.getInstallAmount();
											   if(terms>=commissionInfo.getMaxEmi())
											   {
												   terms=commissionInfo.getMaxEmi();
											   }
											   // System.out.println("hello terms: "+terms);
										   }
										  
									
								 int emiNo=0;
								  for(int i=0; i<list.size();i++)
								  {
									  if(list.get(i).getStatus().equalsIgnoreCase("due"))
									  {
										  emiNo=list.get(i).getSno();
										  break;
									  }
								  }
								  
									  
									  String emiiiNo="";
									  //System.out.println("emi no:: "+emiNo);
									  for(int j=1;j<=terms;j++)
									  {
										  if(ff.getLoanType().equals("DD"))
										   {
											   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
											   {
												   dsaCommission=(val/100)*commissionInfo.getCommission_value();
											   }
											   else
											   {
												   dsaCommission=commissionInfo.getCommission_value();
											   }
											   emiiiNo=String.valueOf(emiNo);
										   }
										   else  if(ff.getLoanType().equals("RD"))
										   {
											   commissionInfo=dbm.checkPlanCommissionDetailForRd(ff.getPlanNo(), emiNo);
											   if(commissionInfo==null || commissionInfo.getStatusNullCheck().equals("0"))
											   {
												   dsaCommission=0;
											   }
											   else
											   {
												   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
												   {
													   dsaCommission=(val/100)*commissionInfo.getCommission_value();
												   }
												   else
												   {
													   dsaCommission=commissionInfo.getCommission_value();
												   }
												   emiiiNo=String.valueOf(emiNo);
											   }
											}
										   else
										   {
											   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
											   {
												   dsaCommission=(val/100)*commissionInfo.getCommission_value();
											   }
											   else
											   {
												   dsaCommission=commissionInfo.getCommission_value();
											   }
											   emiiiNo="all";
										   }
										   
										   dsaCommission=Double.parseDouble(dc.format(dsaCommission));
											// System.out.println(dsaCommission+"========="+emiiiNo);
										   if(dsaCommission>0)
										   {
											  boolean checkEntry=dbm.checkDuplicacyInDsaCommissionTable(ff.getLoanNo(),emiiiNo);
											  if(checkEntry==false)
											  {
												  String dsaName=dbm.dsaNameById(ff.getDsacode(),conn);
													int i=dbm.insertDataInDsaCommissionTable(branchId,ff.getLoanType(), ff.getLoanNo(), ff.getDsacode(), dsaCommission, ff.getOfficeDate(), emiiiNo);
													if(i>0)
													{
														FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Commission Auto Credited to "+ff.getDsacode()+" - "+dsaName+" Rs.:- "+dsaCommission));
													}
											  }
											 
										   }
										 
										   emiNo++;
									  }
									}
							
								   else
								   {
									   val=0;
									   dsaCommission=0;
									   FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Commission Not Auto Credited Due To EMI Amount not valid for Commission."));
								   
								   }
					}
			}
			
		}
	}

	private int loanMethod(LoanInfo ul, Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int n=0;
		boolean check=dbm.checkEntryOfSelectedDateForKalp(selectedRow, "loanMethod" ,conn);
		if(check==false)
		{   
			
			user_info=dbm.userInfoByLoanNoLoanType(ul.getLoanNo(),searchType, conn);
			loan_info=dbm.loanInfoByLoanNoLoanType(ul.getLoanNo(),searchType, conn);
			loanEMIList=dbm.loanInstallment(searchType,ul.getLoanNo(), conn);
			receipt_no=String.valueOf(dbm.loanPayReceiptNo());
			loop:for(LoanInfo ll:loanEMIList)
			{
				if(ll.getStatus().equalsIgnoreCase("Due"))
				{
					emiNo=ll.getSno();
					break loop;
				}
			}
			
			int rAmount=dbm.checkReleaseLoanAmount(ul.getLoanNo());
			if(rAmount>=ul.getAmount())
			{
				boolean chk=allLoanPayMethod(ul,conn);
			 	if(chk==true)
			 	{
			 		n=1;
			 		// Method for Pay Extra Saving Amount By User
			 		if(ul.getExtraAmtPay()>0)
			 		{
			 			String accno=dbm.savingAccountByShareHolderNo(user_info.getShareHolderNo());
			 			String app_status="approved";
			 			String detail=ul.getLoanNo()+" EMI Deposit";
			 			n = dbm.userDeposit(branchId,accno, String.valueOf(ul.getExtraAmtPay()), ul.getOfficeDate(),"cash", "", null, "",app_status,"N/A",detail,"");
						if (n >= 1) 
						{
							double preAmount=dbm.acconuntHolderAmountByAccountNo(accno);
							Double newAmount=preAmount+ul.getExtraAmtPay();
							dbm.updateSavingAmountByAccountNo(accno,newAmount);
							dbm.increaseCompanyCapitalAmount(branchId,ul.getExtraAmtPay(),conn);
						}
			 		}
			 		
			 		FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Rs. "+ul.getAmount()+" Payment Done Successfully of Loan No. "+ul.getLoanNo()));
			 		principleAmount=commission=interestAmount=emiNo=0;
			 		receipt_no="";
			 	}
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Loan No. "+ul.getLoanNo()+" Loan Amount not Release."));
			}
		}
		
		return n;
	}
	
	
	String emis="";
	private boolean allLoanPayMethod(LoanInfo ul, Connection conn) 
	{
		double totalAmount=0;
		for(LoanInfo ll:loanEMIList)
		{
			totalAmount+=ll.getInstallAmount();
		}
		double paidAmount=dbm.loanPaidAmountByUser(searchType, ul.getLoanNo(), conn);
		double remainingAmount=Double.parseDouble(new DecimalFormat("##.##").format(totalAmount-paidAmount));
		if(remainingAmount>=ul.getAmount())
		{
			double rmemi=loanEMIList.get(emiNo-1).getDueAmount();
			if(rmemi>=ul.getAmount())
			{
				emis=String.valueOf(emiNo);
				payEmiPayment(ul.getAmount(), ul, conn);
			}
			else
			{
				double firsteiamount=rmemi;
				payEmiPayment(firsteiamount, ul, conn);
				emis=String.valueOf(emiNo);
				double secondemiamount=ul.getAmount()-rmemi;
				while(secondemiamount>0)
				{
					double rmsemi=loanEMIList.get(emiNo).getDueAmount();
					emiNo=emiNo+1; 
					
					if(rmsemi>=secondemiamount)
					{
						emis=emis+","+String.valueOf(emiNo);
						payEmiPayment(secondemiamount, ul,conn);
					   secondemiamount=0;
					}
					else
					{
						emis=emis+","+String.valueOf(emiNo);
						double ammnt =rmsemi;
						payEmiPayment(ammnt, ul, conn);
						secondemiamount=secondemiamount-rmsemi;
					}
				}
			}
			return true;
		}
		else 
		{
			FacesContext fc = FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("You Have To Pay Only "+remainingAmount+ " For Selected Loan No. "+ul.getLoanNo()));
		}
		
		return false;
	}	
	
	public boolean payEmiPayment(double amount, LoanInfo ul, Connection conn)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		String restructureStatus="No";
		calculateEmiPayAmount(amount, ul, conn);
		String attendance="";
		 String  tranNo= ul.getTransactionNo();
		if(selectedRow.getAttendance()!=null)
		{
			attendance=selectedRow.getAttendance();
		}
		if(ul.getPaymentMode().equalsIgnoreCase("cash"))  // condition add on 25 Oct 2023
		{
			bank="N/A";
		}
		String remark=ul.getRemark()+" EMI Deposit By App "+empName+" "+ul.getName();
		myId = dbm.payLoanEMI(branchId,ul.getLoanNo(),searchType,amount,ul.getOfficeDate(),ul.getPaymentMode(), tranNo,ul.getOfficeDate(),"",0,receipt_no,bank,restructureStatus,0,
				emiNo,loan_info.getDsacode(),attendance,remark);
		if(myId >= 1) 
		{
			
			//cash balance update
			//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)
			{
				interestAmount=interestAmount-loan_info.getDiscount();
			}
			principleAmount=amount-interestAmount;
			
			if(ul.getPaymentMode().equalsIgnoreCase("online"))
			{
				dbm.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(myId, interestAmount);
				dbm.increaseBankBalance(bank, amount, conn);   // add online entry via app approval 26 march 2023
			}			
			else
			{
				dbm.updateInterestAmountInLoanPayReceipt(branchId,myId, interestAmount);
				dbm.decreaseSharedCompanyAmount(branchId,principleAmount);
			}
			
			receipt_no=String.valueOf(dbm.loanPayReceiptNo());
			loanEMIList=dbm.loanInstallment(searchType,ul.getLoanNo(),conn);
			
			principleAmount=interestAmount=0;
			//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=dbm.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=dbm.checkDuplicacyInDsaCommissionTable(loan_info.getLoanNo(),  String.valueOf(emiNo));
								   if(checkEntry==false)
								   {
									   String dsaName=dbm.dsaNameById(loan_info.getDsacode(),conn);
										int j=dbm.insertDataInDsaCommissionTable(branchId,loan_info.getLoanType(), loan_info.getLoanNo(), loan_info.getDsacode(), commission, ul.getOfficeDate(), String.valueOf(emiNo));
										
										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(new DecimalFormat("##.##").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, LoanInfo ul, Connection conn) 
	{
	
		double lastPayAmt=dbm.emiPaidAmountByEmiNo(ul.getLoanNo(), emiNo, conn);
		if(lastPayAmt>0)
		{
			double paytotalint=dbm.emiPaidInterestByEmiNo(ul.getLoanNo(), emiNo, conn);
			double emiIntr=Double.parseDouble(loanEMIList.get(emiNo-1).getInterestAmount());
			emiIntr=Double.parseDouble(new DecimalFormat("##.##").format(emiIntr));
			if(paytotalint==emiIntr)
			{
				interestAmount=0;
			}
			else
			{
				double  intres=emiIntr-paytotalint;
				intres=Double.parseDouble(new DecimalFormat("##.##").format(intres));
				if(amount>=intres)
				{
					interestAmount=intres;
				}
				else
				{
					interestAmount=amount;
				}
			}
		}
		else
		{
			double emiIntr=Double.parseDouble(loanEMIList.get(emiNo-1).getInterestAmount());
			if(amount>=emiIntr)
			{
				interestAmount=emiIntr;
			}
			else 
			{
				interestAmount=amount;
			}
		}
	}
	
	
	
	private int 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");
		int i=0;
//		String paymentMode="cash";
		
		if(selectedRow.getPaymentMode().equalsIgnoreCase("CASH"))
		{
			bankName="NA";
		}
		
		System.out.println("bank name is:"+bankName);
		String lt = dbmt.loanTypeByLoanNo(loanNo);
		
		System.out.println("PAY MODE"+selectedRow.getPaymentMode());
		System.out.println("BANK NAME OS"+bank);
		if(bounceCharge>0)
		{
			System.out.println("");
			voucherNo=dbm.generateVoucherNo(branchId,"income_table",conn);
			i=new DataBaseIncomeExpense().addIncome(branchId,currentDate,"Other_Cr",selectedRow.getPaymentMode(), String.valueOf(bounceCharge),chequeNo,"",
					bankName,chequeDate,"Receive Cheque Bounce Charge","Receive Cheque Bounce Charge",0,bank,
					"0",0, loanNo, lt, voucherNo,"",0,"active",selectedRow.getDsacode()); 
			if(i>0) 
			{   
				//work here by ravi entry after customer pay bounce charge
//				i = dbrk.addManualCharges(loanNo, lt, currentDate, String.valueOf(bounceCharge), "System Generated Bounce Charge", currentDate, conn);
								
				printVoucherDetail(bounceCharge,"Receive Cheque Bounce Charge",conn);
				
				if(paymentMode.equalsIgnoreCase("Cash"))
				{
					dbm.decreaseSharedCompanyAmount(branchId
							,bounceCharge);/// Increase amount due to Bounce Charges Amount
				}
				
				bounceCharge=0;
			}
			
		}
		return i;
		
	}
	
	
	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());
		if(searchType.equalsIgnoreCase("bounceCharge"))
		{
			ss.setAttribute("being", item+" From - "+selectedRow.getLoanNo()+" - "+dbm.firstApplicantNameBySHNo(selectedRow.getShareHolderNo(), conn));

		}
		else {
			ss.setAttribute("being", item+" From - "+loanNo+" - "+dbm.firstApplicantNameBySHNo(user_info.getShareHolderNo(), conn));

		}
		ss.setAttribute("payMode", paymentMode);
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}
	
	
	public Date getStartDate() {
		return startDate;
	}
	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}
	public Date getEndDate() {
		return endDate;
	}
	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}
	
	public String getsearchType() {
		return searchType;
	}
	public void setsearchType(String searchType) {
		this.searchType = searchType;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}

	public ArrayList<SelectItem> getEmpList() {
		return empList;
	}

	public void setEmpList(ArrayList<SelectItem> empList) {
		this.empList = empList;
	}

	public String getEmpName() {
		return empName;
	}

	public void setEmpName(String empName) {
		this.empName = empName;
	}

	public ArrayList<SelectItem> getLoanList() {
		return loanList;
	}

	public void setLoanList(ArrayList<SelectItem> loanList) {
		this.loanList = loanList;
	}

	

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}
	public double getTotalAmount() {
		return totalAmount;
	}

	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}

	public double getTotalAmountGreen() {
		return totalAmountGreen;
	}

	public void setTotalAmountGreen(double totalAmountGreen) {
		this.totalAmountGreen = totalAmountGreen;
	}

	public double getTotalAmountRed() {
		return totalAmountRed;
	}

	public void setTotalAmountRed(double totalAmountRed) {
		this.totalAmountRed = totalAmountRed;
	}

	public double getTotalAmountBlue() {
		return totalAmountBlue;
	}

	public void setTotalAmountBlue(double totalAmountBlue) {
		this.totalAmountBlue = totalAmountBlue;
	}

	public int getTotalEntryGreen() {
		return totalEntryGreen;
	}

	public void setTotalEntryGreen(int totalEntryGreen) {
		this.totalEntryGreen = totalEntryGreen;
	}

	public int getTotalEntryRed() {
		return totalEntryRed;
	}

	public void setTotalEntryRed(int totalEntryRed) {
		this.totalEntryRed = totalEntryRed;
	}

	public int getTotalEntryBlue() {
		return totalEntryBlue;
	}

	public void setTotalEntryBlue(int totalEntryBlue) {
		this.totalEntryBlue = totalEntryBlue;
	}

	public DataBaseMethods getDbm() {
		return dbm;
	}

	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}

	public DataBaseReportMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseReportMethods obj) {
		this.obj = obj;
	}

	public LoanInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(LoanInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	public ArrayList<LoanInfo> getDetailsList() {
		return detailsList;
	}

	public void setDetailsList(ArrayList<LoanInfo> detailsList) {
		this.detailsList = detailsList;
	}

	public ArrayList<LoanInfo> getConfirmationList() {
		return confirmationList;
	}

	public void setConfirmationList(ArrayList<LoanInfo> confirmationList) {
		this.confirmationList = confirmationList;
	}

	public double getTotalDatePayment() {
		return totalDatePayment;
	}

	public void setTotalDatePayment(double totalDatePayment) {
		this.totalDatePayment = totalDatePayment;
	}

	public double getAmountToPaid() {
		return amountToPaid;
	}

	public void setAmountToPaid(double amountToPaid) {
		this.amountToPaid = amountToPaid;
	}

	public double getAmountPaid() {
		return amountPaid;
	}

	public void setAmountPaid(double amountPaid) {
		this.amountPaid = amountPaid;
	}

	public double getDsaCommission() {
		return dsaCommission;
	}

	public void setDsaCommission(double dsaCommission) {
		this.dsaCommission = dsaCommission;
	}

	public double getTotalPaid() {
		return totalPaid;
	}

	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}

	public DsaListInfo getCommissionInfo() {
		return commissionInfo;
	}

	public void setCommissionInfo(DsaListInfo commissionInfo) {
		this.commissionInfo = commissionInfo;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public double getFinalAmount() {
		return finalAmount;
	}

	public void setFinalAmount(double finalAmount) {
		this.finalAmount = finalAmount;
	}

	public boolean isShowSavingType() {
		return showSavingType;
	}

	public void setShowSavingType(boolean showSavingType) {
		this.showSavingType = showSavingType;
	}

	public String getEntryStatus() {
		return entryStatus;
	}

	public void setEntryStatus(String entryStatus) {
		this.entryStatus = entryStatus;
	}

	public boolean isShowBank() {
		return showBank;
	}

	public void setShowBank(boolean showBank) {
		this.showBank = showBank;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public String getPayMode() {
		return payMode;
	}

	public void setPayMode(String payMode) {
		this.payMode = payMode;
	}

	public String getBank() {
		return bank;
	}

	public void setBank(String bank) {
		this.bank = bank;
	}

	public boolean isStatus() {
		return status;
	}

	public void setStatus(boolean status) {
		this.status = status;
	}

	public String getPaymentSource() {
	    return paymentSource;
	}

	public void setPaymentSource(String paymentSource) {
	    this.paymentSource = paymentSource;
	}

	public Date getCurrentDate() {
		return currentDate;
	}

	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	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;
	}

}