package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

@ManagedBean(name="printSanctionLoan")
@ViewScoped

public class PrintFormatOfSanctionNoteBean implements Serializable
{   
	UserInfo info=new UserInfo();
	UserInfo guarantorInfo=new UserInfo(),user_info;
	ArrayList<LoanInfo>goldDeataillist;

	LoanInfo selectedLoan;

	String applicantName,fatherName,loanAmount,loanInterest,guarantarName,guarantarFatherName,guarantarAddress,terms,nomName,nomFaName,nomAddress,address,freq,interestRate,loanApprovedDate;
	String emiDate,appChqNo,appChqNo1,appChqNo2,appChqNo3,appChqNo4,appChqNo5,appAccNo,appBankName,appBankBranch,loanAmountWord,secGuaName,secGuaFaName,secGuaAddress,secGuaChqNo,secGuaChqNo1,secGuaChqNo2,secGuaChqNo3,secGuaChqNo4,secGuaChqNo5,secGuaBankName,secGuaBankBranch,secGuaAccNo,loanNo;
	double emiAmount, preEmiCharge, netDisburseAmt,totalRepayableAmount;
	ArrayList<DebitInfo> transactionHistory;
	String nomIfsc,guarantar1Ifsc,guarantar2Ifsc,applicantIfsc,nomRel, printDisburseDateStr,printDisburseAmt,amountInWords, strCloseDate;
	String principalDueDate;
//	Date emiDate;
	int emiDay; 
	
	boolean checKGuarantar, showDailyLoan, showOtherLoan, showMogar, renG1, renNom;
	String vType, vCompany, vEngineNo, vModel, vMarketValue, vRegOwner, vRegNo, vChesisNo, secSubType, gItemName, gGrossWeight, gNetWeight,gPurityWeight, gQty, 
	gMarketValue, gRemark, goldImagePath;
	boolean property ,gold;
	String intrest;
	String fileCharge,insuranceFee,frequency,loanAmountInword,intrestAmountInWord,fileChargeInWord,insuranceFeeInWord;
	String aadhaarNo,voterId,mobileNo, guaAadhaarNo,guaVoterId,guaMobileNo,guaPan,appIfscBank;
    
	String disbursalDate,totalRepaymentInWord,address2,address3,address1,dealer;
	ArrayList<LoanInfo> loanEMIList;
	ArrayList<Date> dtList;
	Date closeDate;
	double downPayment,billAmount,otherCharge;
	String emiEndDate,requestDate,approvalDate,emiDateDay,dealerAddress,dealerMobile,dealerEmail;
	String typeLoan;
	String onlineFileViewPath;
	boolean goldPhoto1,goldPhoto2;

	private String companyName,guarantorName;
	private String gurantorNameByMemberId;
	


	String product,imeiNo,productModel;
	
	

	DataBaseMethods dbm=new DataBaseMethods();
	DbYashwant dby =new DbYashwant();
	SimpleDateFormat sf=new SimpleDateFormat("dd/MM/yyyy");
	 NumberToWord nm = new NumberToWord();
	
	String strEmiDate,reason,shareHolderNo,chequeNo,accountNum,bankName,contactNo,bankBranch,panNo,guarantorAdress,guarantorHno,guaChequeNo,guaBankName,guaBankBranch,guaAcc;
	String strTodayDate = new SimpleDateFormat("dd/MM/yyyy").format(new Date());
	String policyNo, lastEMIDate;
	
	
	
	public PrintFormatOfSanctionNoteBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selectedLoan = (LoanInfo) ss.getAttribute("selectedLoan");
		companyName = (String) ss.getAttribute("companyName");
		
		UserInfo selected = (UserInfo) ss.getAttribute("selectedDataForHeaderBean");
		
		if (!selected.firm_name.equalsIgnoreCase("null") && 
			 selected.firm_name.equalsIgnoreCase("FINAZONE MICRO SERVICES FOUNDATION")) 
		{
			address1="Head Office: Mustatil No.- 99, Kila No.- 4/1 (2-2),4/2(1-2),5 Min (4/16)";
			address2= "Third Floor, Ghitorni Mehrauli Village, Delhi – 110030";
			address3= "";
		}
		
		else
		{
			address1= selected.getAddress1();
			address2= selected.getAddress2();
			address3= selected.getAddress3();
		}
		
		filePathDetail(conn);
	    
		applicantName=selectedLoan.getApplicantName();
		System.out.println(applicantName);
		applicantIfsc=selectedLoan.getAppBankIfsc();
		guarantar1Ifsc=selectedLoan.getG1BankIfsc();
		guarantar2Ifsc=selectedLoan.getG2BankIfsc();
		//guarantorName= selectedLoan.getFGuarantor();
		guarantorName= selectedLoan.getfGuarantor();
		 gurantorNameByMemberId=   dbm.applicantNameByShareHolderNo( guarantorName, conn); 
		System.out.println("ggn name is:"+guarantorName);
	
		address= selectedLoan.getAddress();
		System.out.println("address is:"+address);
		
		if(selectedLoan.getEmiDate()!=null)
		{
			emiDay=selectedLoan.getEmiDate().getDate();
		}
		// System.out.println("sjdshdjshdjshjdhsdhsd"+selectedLoan.getG2ChqNo());
		
		if(selectedLoan.getG2ChqNo()==null || selectedLoan.getG2ChqNo().equals(""))
		{
			checKGuarantar=false;		
		}
		else
		{
			checKGuarantar=true;
		}
	    
		// Detail of Member	'
		nomIfsc=selectedLoan.getNomIfsc(); 
		address=selectedLoan.getAddress(); 
		System.out.println(address);
		loanAmount=selectedLoan.getLoanAmount();
		fatherName=selectedLoan.getFatherHusbandName();
		emiAmount=selectedLoan.getInstallAmount();
		terms=selectedLoan.getLoanTerm();
		freq=selectedLoan.getFreqLable();
		loanInterest=selectedLoan.getLoanInterest();
		guarantarFatherName=selectedLoan.getGuarantarFatherName();
//		guarantarName=selectedLoan.getGuarantarName();
//		System.out.println("gurantar name is:"+guarantarName);
//		guarantarAddress=selectedLoan.getGuarantarAddress();
		guarantorHno=selectedLoan.getGuarantorShareHno();
		reason=selectedLoan.getReason();
		nomName=selectedLoan.getNomName();
		nomFaName=selectedLoan.getNomFaName();
		nomAddress=selectedLoan.getNomAddress();
		shareHolderNo=selectedLoan.getShareHolderNo();
		contactNo=selectedLoan.getContactNo();
		bankName=selectedLoan.getAppBankName();
		chequeNo=selectedLoan.getAppChqNo();
		accountNum=selectedLoan.getNomBankAccountNo();
		bankBranch=selectedLoan.getAppBankBranch();
		appIfscBank=selectedLoan.getAppBankIfsc();
	
		user_info = dbm.userInfoByShareHolderNo(selectedLoan.getShareHolderNo(), conn);
		panNo=user_info.getPAN();
		aadhaarNo=user_info.getUniqueId();
		voterId=user_info.getVoterId();
		mobileNo= user_info.getContactNo();
		
		
		guaChequeNo=selectedLoan.getG1ChqNo();
		guaBankBranch=selectedLoan.getG1BankBranch();
		guaBankName= selectedLoan.getG1BankName();
		guaAcc=selectedLoan.getG1AccNo();
		emiDate=selectedLoan.getStrEmiDueDate();
		
		if(emiDate == null)
		{
			emiDate="10/10/2025";
		}
		emiDateDay=dby.dateConvertintoDay(null,emiDate);
		appAccNo=selectedLoan.getAppAccNo();
		appChqNo=selectedLoan.getAppChqNo();
		appBankBranch=selectedLoan.getAppBankBranch();
		appBankName=selectedLoan.getAppBankName();
		appIfscBank=selectedLoan.getAppBankIfsc();
		guarantar1Ifsc=selectedLoan.getG1BankIfsc();
		
		
//		dealer= selectedLoan.getDealer();
		dealer= dby.idconvertIntoDealer(conn, selectedLoan.getDealer());
		dealerAddress=dby.selectDealerAddress(conn,selectedLoan.getDealer() );
		dealerEmail=dby.selectDealerEmail(conn, selectedLoan.getDealer());
		dealerMobile =dby.selectDealerMobile(conn, selectedLoan.getDealer());
		product =dby.selectProduct(conn, selectedLoan.getProduct());
		productModel = dby.selectProductModel(conn, selectedLoan.getProduct());
		
		
		otherCharge=selectedLoan.getDptCharge()+selectedLoan.getCardCharge();
		
		imeiNo= selectedLoan.getImeiNoI();
		System.out.println( selectedLoan.getProduct()+"ss"+product);
		
		
		   downPayment= selectedLoan.getDownPayment();
		
		fileCharge = selectedLoan.getFileCharge();
		insuranceFee = selectedLoan.getInsuranceFee();
		frequency=dbm.frequencyLabel(selectedLoan.getFrequency());
		billAmount=selectedLoan.getBillAmount();
		
		
		double inrt= new DataBaseMethods().totalInterestForDiscount(Double.parseDouble(loanAmount),Double.parseDouble(terms),Double.parseDouble(selectedLoan.getLoanInterest()),Integer.valueOf(selectedLoan.getFrequency()),emiAmount);
		intrest =String.valueOf(emiAmount*Double.parseDouble(terms)-Double.parseDouble(loanAmount)) ;
		
		loanAmountInword=nm.convertNumberToWords(Integer.valueOf(loanAmount.replaceAll("\\.[0-9]+$", "")));
		intrestAmountInWord = nm.convertNumberToWords(Integer.valueOf(intrest.replaceAll("\\.[0-9]+$", "")));
		fileChargeInWord=nm.convertNumberToWords(Integer.valueOf(fileCharge.replaceAll("\\.[0-9]+$", "")));
		
		
		String[] amount = loanAmount.split("\\.");
		String amt = null;
		for(int k=0;k<amount.length;k++)
		{
			amt=amount[0];
		}
		int number = Integer.valueOf(amt);
		loanAmountWord=nm.convertNumberToWords(number);
		
		
		secGuaAccNo=selectedLoan.getG2AccNo();
		secGuaChqNo=selectedLoan.getG2ChqNo();
		secGuaBankName=selectedLoan.getG2BankName();
		secGuaBankBranch=selectedLoan.getG2BankBranch();
		secGuaName=selectedLoan.getSecGuarantarName();
		secGuaFaName=selectedLoan.getSecGuarantarFatherName();
		secGuaAddress=selectedLoan.getSecGuarantarAddress();
		interestRate=selectedLoan.getLoanInterest();
		loanNo=selectedLoan.getLoanNo();
		
		policyNo = loanNo.replaceFirst("^(PL|GL|SL)", "SMSA");
		
//		preEmiCharge= selectedLoan.getPreEmiCharge();
	
		if (loanNo.contains("PL")) 
		{
			preEmiCharge = dbm.preEmiChargeCalculationMethod(selectedLoan.getLoanNo(), "personalloan",conn);
			System.out.println("noob:"+preEmiCharge);
		}
		else if (loanNo.contains("GL")) 
		{
			preEmiCharge = dbm.preEmiChargeCalculationMethod(selectedLoan.getSubLoanNo(), "grouploan",conn);
		}
		
		System.out.println(loanNo + " " + selectedLoan.getSubLoanNo());
		
		if(selectedLoan.getLoanType().equalsIgnoreCase("grouploan"))
			{
			typeLoan="GROUP LOAN";
				}
		else {
			typeLoan="PERSONAL LOAN";
		}
		
		requestDate=new SimpleDateFormat("dd/MM/yyyy").format( selectedLoan.getRequestDate());
//		  System.out.println(selectedLoan.getStrApprovalDate()+"aa");
		approvalDate=selectedLoan.getStrApprovalDate();
		
		
		goldDeataillist = dby.fetchGoldDeatail(conn,loanNo);
		
		for(LoanInfo name: goldDeataillist)
		{
			goldImagePath =name.getGoldImagePath();
			
			if (name.getgGrossWeight() != null)

			{
				gold =true;
			}
			
			if(name.getpArea() !=null)
			{
				property = true;
			}
			
			
			if(name.getSno()==1)
			{
				goldPhoto1=true;
				goldPhoto2=false;
			}else {
				goldPhoto1=false;
				goldPhoto2=true;
			}
		}
		
		loanApprovedDate=selectedLoan.getStrApprovalDate();
		disbursalDate=dby.fetchDisbursalDate(loanNo);
		
		totalRepayableAmount= emiAmount*Double.parseDouble(terms)+Double.parseDouble(fileCharge)+Double.parseDouble(insuranceFee);
		totalRepaymentInWord=nm.convertNumberToWords(Integer.valueOf(String.valueOf(totalRepayableAmount).replaceAll("\\.[0-9]+$", "")));
		Date date = null;
		try 
		{
			SimpleDateFormat inputFormat = new SimpleDateFormat("yyyy-MM-dd");
			
			if (disbursalDate != null && !disbursalDate.trim().isEmpty()) 
			{
			    date = inputFormat.parse(disbursalDate);
			    
			    Calendar cal = Calendar.getInstance();
		        cal.setTime(date);
		        double d = Double.parseDouble(terms);
		        int intValue = (int) d;
		        cal.add(Calendar.MONTH,intValue ); // Add 2 months
		        Date newDate = cal.getTime();
		         principalDueDate= sf.format(newDate);
			}
		}
		catch (ParseException e) 
		{
			e.printStackTrace();
		}
  
		String apCheqNo = selectedLoan.getAppChqNo();
		String secgaCheqNo = selectedLoan.getAppChqNo();
		String[] apCh = null;
		String[] secCh = null;
		
		if (apCheqNo != null) 
		{
			apCh = apCheqNo.split(",");
			
			for(int i=0;i<apCh.length;i++)
			{
				if(i==0)
				{
					appChqNo1=apCh[0];
				}
				else if(i==1)
				{
					appChqNo2=apCh[1];
				}
				else if(i==2)
				{
					appChqNo3=apCh[2];
				}
				else if(i==3)
				{
					appChqNo4=apCh[3];
				}
				else if(i==4)
				{
					appChqNo5=apCh[4];
				}
			}
		}
		
		if (secgaCheqNo != null) 
		{
			secCh = secgaCheqNo.split(",");
		
			for(int i=0;i<secCh.length;i++)
			{
				if(i==0)
				{
					secGuaChqNo1=secCh[0];
				}
				else if(i==1)
				{
					secGuaChqNo2=secCh[1];
				}
				else if(i==2)
				{
					secGuaChqNo3=secCh[2];
				}
				else if(i==3)
				{
					secGuaChqNo4=secCh[3];
				}
				else if(i==4)
				{
					secGuaChqNo5=secCh[4];
				}		
			}
		}
		
		
		
		netDisburseAmt=Double.parseDouble(loanAmount)-(Double.parseDouble(selectedLoan.getFileCharge())+Double.parseDouble(selectedLoan.getInsuranceFee()));
		
		if ("TRP MICRO FINANCE FOUNDATION".equalsIgnoreCase(companyName)) 
		{
			netDisburseAmt = Double.parseDouble(loanAmount) - (Double.parseDouble(selectedLoan.getFileCharge()) + 
							 Double.parseDouble(selectedLoan.getInsuranceFee()) + selectedLoan.getStamp() + 
							 selectedLoan.getAdvanceEMIAmount());
		}
		
		if(selectedLoan.getEmiPaidDate()!=null)
		{
			strEmiDate=new SimpleDateFormat("dd/MM/yyyy").format(selectedLoan.getEmiPaidDate());
			
			 Calendar cal = Calendar.getInstance();
		        cal.setTime(selectedLoan.getEmiPaidDate());

		        // Add 3 months
		        cal.add(Calendar.MONTH, Integer.valueOf(terms.replaceAll("\\.[0-9]+$", "")));

		        // Get updated date
		        Date Date1 = cal.getTime();
		        emiEndDate = new SimpleDateFormat("dd/MM/yyyy").format(Date1);
		}
		guarantarAddress=selectedLoan.getGuarantarAddress();
		
		
		if(selectedLoan.getFrequency().equals("365") || selectedLoan.getFrequency().equals("365.0"))
		{
			showOtherLoan=false;
		}
		else
			
			
		{
			showOtherLoan=true;
		}
		
		String loanType=dbm.loanValueByLoanLabel(selectedLoan.getLoanType());
		String loanNo="";
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			loanNo=selectedLoan.getSubLoanNo();
			renG1=false;
			renNom=true;
			
			nomName=dbm.shareHolderDetailByColumnName(shareHolderNo, "nominee_name", conn);
			nomAddress=dbm.shareHolderDetailByColumnName(shareHolderNo, "nominee_address", conn);
			nomRel=dbm.shareHolderDetailByColumnName(shareHolderNo, "nominee_relation", conn);
			nomFaName=dbm.shareHolderDetailByColumnName(shareHolderNo, "first_applicantName", conn);
		}
		else
		{
			loanNo=selectedLoan.getLoanNo();
			renG1=true;
			renNom=false;
		}
		loanEMIList=dbm.loanInstallment(loanType,loanNo, conn);
		HeaderBean hh=new HeaderBean();
		//System.out.println(hh.getName());
		if(hh.getName().equalsIgnoreCase("MOGAR FINANCE") || hh.getName().equals("DEV GROUP") || 
		   hh.getName().equalsIgnoreCase("SURNATH MICRO SERVICE ASSOCIATION"))
		{
			showMogar=true;
			DebitInfo dd=dbm.viewDebitLoanHistoryForSanctionLetter(loanType, loanNo, shareHolderNo, conn);
			bankName=dd.getBankName();
			chequeNo=dd.getChequeNo();
			printDisburseAmt=dd.getAmount();
			printDisburseDateStr=dd.getStrPayDate();
		}
		else
		{
			showMogar=false;
		}
		transactionHistory=dbm.viewDebitLoanHistory(loanType,loanNo,selectedLoan.getShareHolderNo(),conn);
		
		if(selectedLoan.getStatus()!=null && selectedLoan.getStatus().equalsIgnoreCase("Approve"))
		{
			dtList=dbm.loanEmiDateList(selectedLoan.getFrequencyVal(), selectedLoan.getTerms(), selectedLoan.getEmiPaidDate(), selectedLoan.getApprovalDate());
			if(dtList.size()>1)
			{
				closeDate=dtList.get(dtList.size()-1);
				strCloseDate=sf.format(closeDate);
			}
		}
		
		info=dbm.allShareHoldersForView(selectedLoan.getShareHolderNo(),info);
		guarantorInfo=dbm.memberBasicDetail(guarantorHno, conn);
		guaAadhaarNo=guarantorInfo.getUniqueId();
		guaVoterId=guarantorInfo.getVoterId();
		guaMobileNo= guarantorInfo.getContactNo();
		guaPan= guarantorInfo.getPAN();
		
		if (companyName != null && !companyName.equalsIgnoreCase("SUDERSHANA FINANCE")) {
		    preEmiCharge = dbm.preEmiChargeCalculationMethod(loanNo, loanType, conn);
		    netDisburseAmt -= preEmiCharge;
		}
		
		try 
		{
			getLastEmiDate();
		} 
		catch (ParseException e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public void getLastEmiDate() throws ParseException 
	{
		Date firstEmi = sf.parse(emiDate);
		int tenure = selectedLoan.getTerms();
		String freq = selectedLoan.getFrequency();
		
	    Calendar cal = Calendar.getInstance();
	    cal.setTime(firstEmi);

	    int interval = tenure - 1;

	    if (freq.equals("365") || freq.equals("365.0")) 
	    {
	        cal.add(Calendar.DATE, interval);
	    }
	    else if (freq.equals("52") || freq.equals("52.0")) 
	    {
	        cal.add(Calendar.DATE, interval * 7);
	    }
	    else if (freq.equals("26") || freq.equals("26.0")) 
	    {
	        cal.add(Calendar.DATE, interval * 14);
	    }
	    else if (freq.equals("24") || freq.equals("24.0")) 
	    {
	        cal.add(Calendar.DATE, interval * 15);
	    }
	    else if (freq.equals("36") || freq.equals("36.0")) 
	    {
	        cal.add(Calendar.DATE, interval * 10);
	    }
	    else if (freq.equals("13") || freq.equals("13.0")) 
	    {
	        cal.add(Calendar.DATE, interval * 28);
	    }
	    else if (freq.equals("12") || freq.equals("12.0")) 
	    {
	        cal.add(Calendar.MONTH, interval);
	    }
	    else if (freq.equals("4") || freq.equals("4.0")) 
	    {
	        cal.add(Calendar.MONTH, interval * 3);
	    }
	    else if (freq.equals("2") || freq.equals("2.0")) 
	    {
	        cal.add(Calendar.MONTH, interval * 6);
	    }
	    else if (freq.equals("1") || freq.equals("1.0")) 
	    {
	        cal.add(Calendar.YEAR, interval);
	    }

	    Date lastEMI = cal.getTime();
	    lastEMIDate = sf.format(lastEMI);
	}
	
	
	
	public void filePathDetail(Connection conn)  
	{
		try
		{
			Statement st = conn.createStatement();
			String qq = "select * from firm_detail limit 1";
			ResultSet rs = st.executeQuery(qq);
			if(rs.next())
			{
				onlineFileViewPath = rs.getString("file_view_path");
			}
		}
		catch (Exception e)
		{
			 e.printStackTrace();
		} 
	}
	
	
	
	public LoanInfo getSelectedLoan() {
		return selectedLoan;
	}
	public void setSelectedLoan(LoanInfo selectedLoan) {
		this.selectedLoan = selectedLoan;
	}
	public String getApplicantName() {
		return applicantName;
	}
	public void setApplicantName(String applicantName) {
		this.applicantName = applicantName;
	}
	public String getFatherName() {
		return fatherName;
	}
	public void setFatherName(String fatherName) {
		this.fatherName = fatherName;
	}
	public String getLoanAmount() {
		return loanAmount;
	}
	public void setLoanAmount(String loanAmount) {
		this.loanAmount = loanAmount;
	}
	public double getEmiAmount() {
		return emiAmount;
	}
	public void setEmiAmount(double emiAmount) {
		this.emiAmount = emiAmount;
	}
	public String getLoanInterest() {
		return loanInterest;
	}
	public void setLoanInterest(String loanInterest) {
		this.loanInterest = loanInterest;
	}
	public String getGuarantarName() {
		return guarantarName;
	}
	public void setGuarantarName(String guarantarName) {
		this.guarantarName = guarantarName;
	}
	public String getGuarantarFatherName() {
		return guarantarFatherName;
	}
	public void setGuarantarFatherName(String guarantarFatherName) {
		this.guarantarFatherName = guarantarFatherName;
	}
	public String getGuarantarAddress() {
		return guarantarAddress;
	}
	public void setGuarantarAddress(String guarantarAddress) {
		this.guarantarAddress = guarantarAddress;
	}
	public String getTerms() {
		return terms;
	}
	public void setTerms(String terms) {
		this.terms = terms;
	}
	public String getStrEmiDate() {
		return strEmiDate;
	}
	public void setStrEmiDate(String strEmiDate) {
		this.strEmiDate = strEmiDate;
	}
	public String getNomName() {
		return nomName;
	}
	public void setNomName(String nomName) {
		this.nomName = nomName;
	}
	public String getNomFaName() {
		return nomFaName;
	}
	public void setNomFaName(String nomFaName) {
		this.nomFaName = nomFaName;
	}
	public String getNomAddress() {
		return nomAddress;
	}
	public void setNomAddress(String nomAddress) {
		this.nomAddress = nomAddress;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getFreq() {
		return freq;
	}
	public void setFreq(String freq) {
		this.freq = freq;
	}
	public String getReason() {
		return reason;
	}
	public void setReason(String reason) {
		this.reason = reason;
	}
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	public String getChequeNo() {
		return chequeNo;
	}
	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}
	public String getAccountNum() {
		return accountNum;
	}
	public void setAccountNum(String accountNum) {
		this.accountNum = accountNum;
	}
	public String getBankName() {
		return bankName;
	}
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}
	public String getContactNo() {
		return contactNo;
	}
	
	public String getPanNo() {
		return panNo;
	}
	public void setPanNo(String panNo) {
		this.panNo = panNo;
	}
	public void setContactNo(String contactNo) {
		this.contactNo = contactNo;
	}
	public String getBankBranch() {
		return bankBranch;
	}
	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}
	public String getGuarantorAdress() {
		return guarantorAdress;
	}
	public void setGuarantorAdress(String guarantorAdress) {
		this.guarantorAdress = guarantorAdress;
	}
	public String getGuarantorHno() {
		return guarantorHno;
	}
	public void setGuarantorHno(String guarantorHno) {
		this.guarantorHno = guarantorHno;
	}
	public String getGuaChequeNo() {
		return guaChequeNo;
	}
	public void setGuaChequeNo(String guaChequeNo) {
		this.guaChequeNo = guaChequeNo;
	}
	public String getGuaBankName() {
		return guaBankName;
	}
	public void setGuaBankName(String guaBankName) {
		this.guaBankName = guaBankName;
	}
	public String getGuaBankBranch() {
		return guaBankBranch;
	}
	public void setGuaBankBranch(String guaBankBranch) {
		this.guaBankBranch = guaBankBranch;
	}
	public String getGuaAcc() {
		return guaAcc;
	}
	public void setGuaAcc(String guaAcc) {
		this.guaAcc = guaAcc;
	}
	public String getEmiDate() {
		return emiDate;
	}
	public void setEmiDate(String emiDate) {
		this.emiDate = emiDate;
	}
	public String getAppChqNo() {
		return appChqNo;
	}
	public void setAppChqNo(String appChqNo) {
		this.appChqNo = appChqNo;
	}
	public String getAppAccNo() {
		return appAccNo;
	}
	public void setAppAccNo(String appAccNo) {
		this.appAccNo = appAccNo;
	}
	public String getAppBankName() {
		return appBankName;
	}
	public void setAppBankName(String appBankName) {
		this.appBankName = appBankName;
	}
	public String getAppBankBranch() {
		return appBankBranch;
	}
	public void setAppBankBranch(String appBankBranch) {
		this.appBankBranch = appBankBranch;
	}
	public String getLoanAmountWord() {
		return loanAmountWord;
	}
	public void setLoanAmountWord(String loanAmountWord) {
		this.loanAmountWord = loanAmountWord;
	}
	public String getSecGuaName() {
		return secGuaName;
	}
	public void setSecGuaName(String secGuaName) {
		this.secGuaName = secGuaName;
	}
	public String getSecGuaFaName() {
		return secGuaFaName;
	}
	public void setSecGuaFaName(String secGuaFaName) {
		this.secGuaFaName = secGuaFaName;
	}
	public String getSecGuaAddress() {
		return secGuaAddress;
	}
	public void setSecGuaAddress(String secGuaAddress) {
		this.secGuaAddress = secGuaAddress;
	}
	public String getSecGuaChqNo() {
		return secGuaChqNo;
	}
	public void setSecGuaChqNo(String secGuaChqNo) {
		this.secGuaChqNo = secGuaChqNo;
	}
	public String getSecGuaBankName() {
		return secGuaBankName;
	}
	public void setSecGuaBankName(String secGuaBankName) {
		this.secGuaBankName = secGuaBankName;
	}
	public String getSecGuaBankBranch() {
		return secGuaBankBranch;
	}
	public void setSecGuaBankBranch(String secGuaBankBranch) {
		this.secGuaBankBranch = secGuaBankBranch;
	}
	public String getSecGuaAccNo() {
		return secGuaAccNo;
	}
	public void setSecGuaAccNo(String secGuaAccNo) {
		this.secGuaAccNo = secGuaAccNo;
	}
	public String getNomIfsc() {
		return nomIfsc;
	}
	public void setNomIfsc(String nomIfsc) {
		this.nomIfsc = nomIfsc;
	}
	public String getGuarantar1Ifsc() {
		return guarantar1Ifsc;
	}
	public void setGuarantar1Ifsc(String guarantar1Ifsc) {
		this.guarantar1Ifsc = guarantar1Ifsc;
	}
	public String getGuarantar2Ifsc() {
		return guarantar2Ifsc;
	}
	public void setGuarantar2Ifsc(String guarantar2Ifsc) {
		this.guarantar2Ifsc = guarantar2Ifsc;
	}
	public String getApplicantIfsc() {
		return applicantIfsc;
	}
	public void setApplicantIfsc(String applicantIfsc) {
		this.applicantIfsc = applicantIfsc;
	}
	public String getNomRel() {
		return nomRel;
	}
	public void setNomRel(String nomRel) {
		this.nomRel = nomRel;
	}
	public int getEmiDay() {
		return emiDay;
	}
	public void setEmiDay(int emiDay) {
		this.emiDay = emiDay;
	}
	public boolean isChecKGuarantar() {
		return checKGuarantar;
	}
	public void setChecKGuarantar(boolean checKGuarantar) {
		this.checKGuarantar = checKGuarantar;
	}
	
	public boolean isShowDailyLoan() {
		return showDailyLoan;
	}
	public void setShowDailyLoan(boolean showDailyLoan) {
		this.showDailyLoan = showDailyLoan;
	}
	public boolean isShowOtherLoan() {
		return showOtherLoan;
	}
	public void setShowOtherLoan(boolean showOtherLoan) {
		this.showOtherLoan = showOtherLoan;
	}
	public boolean isShowMogar() {
		return showMogar;
	}
	public void setShowMogar(boolean showMogar) {
		this.showMogar = showMogar;
	}
	
	
	public String getPrintDisburseDateStr() {
		return printDisburseDateStr;
	}
	public void setPrintDisburseDateStr(String printDisburseDateStr) {
		this.printDisburseDateStr = printDisburseDateStr;
	}
	public String getPrintDisburseAmt() {
		return printDisburseAmt;
	}
	public void setPrintDisburseAmt(String printDisburseAmt) {
		this.printDisburseAmt = printDisburseAmt;
	}
	public ArrayList<LoanInfo> getLoanEMIList() {
		return loanEMIList;
	}
	public void setLoanEMIList(ArrayList<LoanInfo> loanEMIList) {
		this.loanEMIList = loanEMIList;
	}
	public double getNetDisburseAmt() {
		return netDisburseAmt;
	}
	public void setNetDisburseAmt(double netDisburseAmt) {
		this.netDisburseAmt = netDisburseAmt;
	}
	public ArrayList<DebitInfo> getTransactionHistory() {
		return transactionHistory;
	}
	public void setTransactionHistory(ArrayList<DebitInfo> transactionHistory) {
		this.transactionHistory = transactionHistory;
	}
	public String getAmountInWords() {
		return amountInWords;
	}
	public void setAmountInWords(String amountInWords) {
		this.amountInWords = amountInWords;
	}
	public UserInfo getInfo() {
		return info;
	}
	public void setInfo(UserInfo info) {
		this.info = info;
	}
	public UserInfo getGuarantorInfo() {
		return guarantorInfo;
	}
	public void setGuarantorInfo(UserInfo guarantorInfo) {
		this.guarantorInfo = guarantorInfo;
	}
	public String getStrCloseDate() {
		return strCloseDate;
	}
	public void setStrCloseDate(String strCloseDate) {
		this.strCloseDate = strCloseDate;
	}
	public boolean isRenG1() {
		return renG1;
	}
	public void setRenG1(boolean renG1) {
		this.renG1 = renG1;
	}
	public boolean isRenNom() {
		return renNom;
	}
	public void setRenNom(boolean renNom) {
		this.renNom = renNom;
	}
	public double getPreEmiCharge() {
		return preEmiCharge;
	}
	public void setPreEmiCharge(double preEmiCharge) {
		this.preEmiCharge = preEmiCharge;
	}
	public String getInterestRate() {
		return interestRate;
	}
	public void setInterestRate(String interestRate) {
		this.interestRate = interestRate;
	}
	public String getLoanNo() {
		return loanNo;
	}
	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}
	public String getAppChqNo1() {
		return appChqNo1;
	}
	public void setAppChqNo1(String appChqNo1) {
		this.appChqNo1 = appChqNo1;
	}
	public String getAppChqNo2() {
		return appChqNo2;
	}
	public void setAppChqNo2(String appChqNo2) {
		this.appChqNo2 = appChqNo2;
	}
	public String getAppChqNo3() {
		return appChqNo3;
	}
	public void setAppChqNo3(String appChqNo3) {
		this.appChqNo3 = appChqNo3;
	}
	public String getAppChqNo4() {
		return appChqNo4;
	}
	public void setAppChqNo4(String appChqNo4) {
		this.appChqNo4 = appChqNo4;
	}
	public String getAppChqNo5() {
		return appChqNo5;
	}
	public void setAppChqNo5(String appChqNo5) {
		this.appChqNo5 = appChqNo5;
	}
	public String getSecGuaChqNo1() {
		return secGuaChqNo1;
	}
	public void setSecGuaChqNo1(String secGuaChqNo1) {
		this.secGuaChqNo1 = secGuaChqNo1;
	}
	public String getSecGuaChqNo2() {
		return secGuaChqNo2;
	}
	public void setSecGuaChqNo2(String secGuaChqNo2) {
		this.secGuaChqNo2 = secGuaChqNo2;
	}
	public String getSecGuaChqNo3() {
		return secGuaChqNo3;
	}
	public void setSecGuaChqNo3(String secGuaChqNo3) {
		this.secGuaChqNo3 = secGuaChqNo3;
	}
	public String getSecGuaChqNo4() {
		return secGuaChqNo4;
	}
	public void setSecGuaChqNo4(String secGuaChqNo4) {
		this.secGuaChqNo4 = secGuaChqNo4;
	}
	public String getSecGuaChqNo5() {
		return secGuaChqNo5;
	}
	public void setSecGuaChqNo5(String secGuaChqNo5) {
		this.secGuaChqNo5 = secGuaChqNo5;
	}
	public String getLoanApprovedDate() {
		return loanApprovedDate;
	}
	public void setLoanApprovedDate(String loanApprovedDate) {
		this.loanApprovedDate = loanApprovedDate;
	}
	public String getDisbursalDate() {
		return disbursalDate;
	}
	public void setDisbursalDate(String disbursalDate) {
		this.disbursalDate = disbursalDate;
	}
	public String getvType() {
		return vType;
	}
	public void setvType(String vType) {
		this.vType = vType;
	}
	public String getvCompany() {
		return vCompany;
	}
	public void setvCompany(String vCompany) {
		this.vCompany = vCompany;
	}
	public String getvEngineNo() {
		return vEngineNo;
	}
	public void setvEngineNo(String vEngineNo) {
		this.vEngineNo = vEngineNo;
	}
	public String getvModel() {
		return vModel;
	}
	public void setvModel(String vModel) {
		this.vModel = vModel;
	}
	public String getvMarketValue() {
		return vMarketValue;
	}
	public void setvMarketValue(String vMarketValue) {
		this.vMarketValue = vMarketValue;
	}
	public String getvRegOwner() {
		return vRegOwner;
	}
	public void setvRegOwner(String vRegOwner) {
		this.vRegOwner = vRegOwner;
	}
	public String getvRegNo() {
		return vRegNo;
	}
	public void setvRegNo(String vRegNo) {
		this.vRegNo = vRegNo;
	}
	public String getvChesisNo() {
		return vChesisNo;
	}
	public void setvChesisNo(String vChesisNo) {
		this.vChesisNo = vChesisNo;
	}
	public String getSecSubType() {
		return secSubType;
	}
	public void setSecSubType(String secSubType) {
		this.secSubType = secSubType;
	}
	public String getgItemName() {
		return gItemName;
	}
	public void setgItemName(String gItemName) {
		this.gItemName = gItemName;
	}
	public String getgGrossWeight() {
		return gGrossWeight;
	}
	public void setgGrossWeight(String gGrossWeight) {
		this.gGrossWeight = gGrossWeight;
	}
	public String getgNetWeight() {
		return gNetWeight;
	}
	public void setgNetWeight(String gNetWeight) {
		this.gNetWeight = gNetWeight;
	}
	public String getgPurityWeight() {
		return gPurityWeight;
	}
	public void setgPurityWeight(String gPurityWeight) {
		this.gPurityWeight = gPurityWeight;
	}
	public String getgQty() {
		return gQty;
	}
	public void setgQty(String gQty) {
		this.gQty = gQty;
	}
	public String getgMarketValue() {
		return gMarketValue;
	}
	public void setgMarketValue(String gMarketValue) {
		this.gMarketValue = gMarketValue;
	}
	public String getgRemark() {
		return gRemark;
	}
	public void setgRemark(String gRemark) {
		this.gRemark = gRemark;
	}
	public String getGoldImagePath() {
		return goldImagePath;
	}
	public void setGoldImagePath(String goldImagePath) {
		this.goldImagePath = goldImagePath;
	}
	public ArrayList<Date> getDtList() {
		return dtList;
	}
	public void setDtList(ArrayList<Date> dtList) {
		this.dtList = dtList;
	}
	public Date getCloseDate() {
		return closeDate;
	}
	public void setCloseDate(Date closeDate) {
		this.closeDate = closeDate;
	}
	public DataBaseMethods getDbm() {
		return dbm;
	}
	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}
	public DbYashwant getDby() {
		return dby;
	}
	public void setDby(DbYashwant dby) {
		this.dby = dby;
	}
	public SimpleDateFormat getSf() {
		return sf;
	}
	public void setSf(SimpleDateFormat sf) {
		this.sf = sf;
	}
	public NumberToWord getNm() {
		return nm;
	}
	public void setNm(NumberToWord nm) {
		this.nm = nm;
	}
	public ArrayList<LoanInfo> getGoldDeataillist() {
		return goldDeataillist;
	}
	public void setGoldDeataillist(ArrayList<LoanInfo> goldDeataillist) {
		this.goldDeataillist = goldDeataillist;
	}
	public String getPrincipalDueDate() {
		return principalDueDate;
	}
	public void setPrincipalDueDate(String principalDueDate) {
		this.principalDueDate = principalDueDate;
	}
	public boolean isProperty() {
		return property;
	}
	public void setProperty(boolean property) {
		this.property = property;
	}
	public boolean isGold() {
		return gold;
	}
	public void setGold(boolean gold) {
		this.gold = gold;
	}
	public String getIntrest() {
		return intrest;
	}
	public void setIntrest(String intrest) {
		this.intrest = intrest;
	}
	public String getFileCharge() {
		return fileCharge;
	}
	public void setFileCharge(String fileCharge) {
		this.fileCharge = fileCharge;
	}
	public String getInsuranceFee() {
		return insuranceFee;
	}
	public void setInsuranceFee(String insuranceFee) {
		this.insuranceFee = insuranceFee;
	}
	public String getFrequency() {
		return frequency;
	}
	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}
	public String getLoanAmountInword() {
		return loanAmountInword;
	}
	public void setLoanAmountInword(String loanAmountInword) {
		this.loanAmountInword = loanAmountInword;
	}
	public String getIntrestAmountInWord() {
		return intrestAmountInWord;
	}
	public void setIntrestAmountInWord(String intrestAmountInWord) {
		this.intrestAmountInWord = intrestAmountInWord;
	}
	public String getFileChargeInWord() {
		return fileChargeInWord;
	}
	public void setFileChargeInWord(String fileChargeInWord) {
		this.fileChargeInWord = fileChargeInWord;
	}
	public String getInsuranceFeeInWord() {
		return insuranceFeeInWord;
	}
	public void setInsuranceFeeInWord(String insuranceFeeInWord) {
		this.insuranceFeeInWord = insuranceFeeInWord;
	}
	public String getEmiEndDate() {
		return emiEndDate;
	}
	public void setEmiEndDate(String emiEndDate) {
		this.emiEndDate = emiEndDate;
	}
	public UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public String getAadhaarNo() {
		return aadhaarNo;
	}
	public void setAadhaarNo(String aadhaarNo) {
		this.aadhaarNo = aadhaarNo;
	}
	public String getVoterId() {
		return voterId;
	}
	public void setVoterId(String voterId) {
		this.voterId = voterId;
	}
	public String getMobileNo() {
		return mobileNo;
	}
	public void setMobileNo(String mobileNo) {
		this.mobileNo = mobileNo;
	}
	public String getGuaAadhaarNo() {
		return guaAadhaarNo;
	}
	public void setGuaAadhaarNo(String guaAadhaarNo) {
		this.guaAadhaarNo = guaAadhaarNo;
	}
	public String getGuaVoterId() {
		return guaVoterId;
	}
	public void setGuaVoterId(String guaVoterId) {
		this.guaVoterId = guaVoterId;
	}
	public String getGuaMobileNo() {
		return guaMobileNo;
	}
	public void setGuaMobileNo(String guaMobileNo) {
		this.guaMobileNo = guaMobileNo;
	}
	public String getGuaPan() {
		return guaPan;
	}
	public void setGuaPan(String guaPan) {
		this.guaPan = guaPan;
	}
	public String getAppIfscBank() {
		return appIfscBank;
	}
	public void setAppIfscBank(String appIfscBank) {
		this.appIfscBank = appIfscBank;
	}
	public String getRequestDate() {
		return requestDate;
	}
	public void setRequestDate(String requestDate) {
		this.requestDate = requestDate;
	}
	public String getApprovalDate() {
		return approvalDate;
	}
	public void setApprovalDate(String approvalDate) {
		this.approvalDate = approvalDate;
	}
	public double getTotalRepayableAmount() {
		return totalRepayableAmount;
	}
	public void setTotalRepayableAmount(double totalRepayableAmount) {
		this.totalRepayableAmount = totalRepayableAmount;
	}
	public String getTotalRepaymentInWord() {
		return totalRepaymentInWord;
	}
	public void setTotalRepaymentInWord(String totalRepaymentInWord) {
		this.totalRepaymentInWord = totalRepaymentInWord;
	}
	public String getAddress2() {
		return address2;
	}
	public void setAddress2(String address2) {
		this.address2 = address2;
	}
	public String getAddress3() {
		return address3;
	}
	public void setAddress3(String address3) {
		this.address3 = address3;
	}
	public String getAddress1() {
		return address1;
	}
	public void setAddress1(String address1) {
		this.address1 = address1;
	}
	public double getDownPayment() {
		return downPayment;
	}
	public void setDownPayment(double downPayment) {
		this.downPayment = downPayment;
	}
	public String getDealer() {
		return dealer;
	}
	public void setDealer(String dealer) {
		this.dealer = dealer;
	}
	public String getEmiDateDay() {
		return emiDateDay;
	}
	public void setEmiDateDay(String emiDateDay) {
		this.emiDateDay = emiDateDay;
	}
	public String getDealerAddress() {
		return dealerAddress;
	}
	public void setDealerAddress(String dealerAddress) {
		this.dealerAddress = dealerAddress;
	}
	public boolean isGoldPhoto1() {
		return goldPhoto1;
	}
	public void setGoldPhoto1(boolean goldPhoto1) {
		this.goldPhoto1 = goldPhoto1;
	}
	public boolean isGoldPhoto2() {
		return goldPhoto2;
	}
	public void setGoldPhoto2(boolean goldPhoto2) {
		this.goldPhoto2 = goldPhoto2;
	}

	public String getCompanyName() {
		return companyName;
	}
	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public String getProduct() {
		return product;
	}
	public void setProduct(String product) {
		this.product = product;

	}
	
	public String getTypeLoan() {
		return typeLoan;
	}
	public void setTypeLoan(String typeLoan) {
		this.typeLoan = typeLoan;
	}
	public String getImeiNo() {
		return imeiNo;
	}
	public void setImeiNo(String imeiNo) {
		this.imeiNo = imeiNo;
	}
	public double getBillAmount() {
		return billAmount;
	}
	public void setBillAmount(double billAmount) {
		this.billAmount = billAmount;
	}
	public String getDealerMobile() {
		return dealerMobile;
	}
	public void setDealerMobile(String dealerMobile) {
		this.dealerMobile = dealerMobile;
	}
	public String getDealerEmail() {
		return dealerEmail;
	}
	public void setDealerEmail(String dealerEmail) {
		this.dealerEmail = dealerEmail;
	}
	public String getProductModel() {
		return productModel;
	}
	public void setProductModel(String productModel) {
		this.productModel = productModel;
	}
	public double getOtherCharge() {
		return otherCharge;
	}
	public void setOtherCharge(double otherCharge) {
		this.otherCharge = otherCharge;
	}



	public String getGuarantorName() {
		return guarantorName;
	}



	public void setGuarantorName(String guarantorName) {
		this.guarantorName = guarantorName;
	}



	public String getGurantorNameByMemberId() {
		return gurantorNameByMemberId;
	}



	public void setGurantorNameByMemberId(String gurantorNameByMemberId) {
		this.gurantorNameByMemberId = gurantorNameByMemberId;
	}



	public String getOnlineFileViewPath() {
		return onlineFileViewPath;
	}



	public void setOnlineFileViewPath(String onlineFileViewPath) {
		this.onlineFileViewPath = onlineFileViewPath;
	}



	public String getStrTodayDate() {
		return strTodayDate;
	}



	public void setStrTodayDate(String strTodayDate) {
		this.strTodayDate = strTodayDate;
	}



	public String getPolicyNo() {
		return policyNo;
	}



	public void setPolicyNo(String policyNo) {
		this.policyNo = policyNo;
	}



	public String getLastEMIDate() {
		return lastEMIDate;
	}



	public void setLastEMIDate(String lastEMIDate) {
		this.lastEMIDate = lastEMIDate;
	}
	
}
