package main_package;

import java.io.Serializable;
import java.sql.Connection;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

@ManagedBean(name = "sanctionLetter")
@ViewScoped
public class PrintFormateRKFinanceVehicleLoanBean implements Serializable {

	private static final long serialVersionUID = 1L;

	String approvalDate, onRoadPrice, vehicleModel, companyAddress, fatherName, dealerAccountNo, emiDueDate,
			monthlyIncome, mobile, uniqueId, vehicleMake, vehicleRegNo, loanNo, branchName, loanAmount, roi, tenor, emi,
			companyName, downPayment, disbursementAmount, dealerName, emiInWords, vehicleChesisNo, vehicleEngineNo,
			address1;
	UserInfo applicantInfo = new UserInfo();
	private String dob, signPhoto;
	double preEmi;

	
	
	public PrintFormateRKFinanceVehicleLoanBean() 
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		try 
		{
			DataBaseMethodsRavi db = new DataBaseMethodsRavi();

//			loanNo = db.latestPersonalLoanNo(conn);

			HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			LoanInfo selectedLoan = (LoanInfo) ss.getAttribute("selectedLoan");
			if (selectedLoan != null) 
			{
				loanNo = selectedLoan.getLoanNo();
			} 
			else
			{
				loanNo = " ";
			}

			approvalDate = db.approvalDateByLoanNo(loanNo, conn);
			branchName = db.branchNameByLoanNo(loanNo, conn);
			applicantInfo = db.applicantDetailsByLoanNo(loanNo, conn);
			companyName = db.companyName(conn);

			String vehicleData[] = db.vehicleDetailsByLoanNo(loanNo, conn);
			vehicleMake = vehicleData[0];
			vehicleModel = vehicleData[1];
			onRoadPrice = vehicleData[2];
			vehicleRegNo = vehicleData[3];
			vehicleEngineNo = vehicleData[4];
			vehicleChesisNo = vehicleData[5];

			String loanData[] = db.secureLoanMainDataByLoanNo(loanNo, conn);
			loanAmount = loanData[0];
			roi = loanData[1];
			tenor = loanData[2];
			emi = loanData[3];
			emiInWords = loanData[4];
			emiDueDate = loanData[5];

			preEmi = db.preEmiByLoanNo(loanNo, conn);
			downPayment = db.downPaymentByLoanNo(loanNo, conn);
			disbursementAmount = db.disbursementAmountByLoanNo(loanNo, conn);

			dealerName = db.dealerNameByLoanNo(loanNo, conn);
			dealerAccountNo = db.dealerAccountNoByLoanNo(loanNo, conn);
			companyAddress = db.companyAddress(conn);
			address1 = db.companyAddress1(conn);

			System.out.println("Applicant_Info = " + applicantInfo);
			System.out.println("approvalDate = " + approvalDate);
			System.out.println("branchName = " + branchName);
			System.out.println("Dealer Name = " + dealerName);
			System.out.println("Vehicle ChesisNo = " + vehicleChesisNo);

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	public String charAt(String text, int index) {
		if (text != null && text.length() > index) {
			return String.valueOf(text.charAt(index));
		}
		return "";
	}

	private Integer[] boxIndexList = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22,
			23, 24, 25, 26, 27, 28, 29 };

	public Integer[] getBoxIndexList() {
		return boxIndexList;
	}

	private Integer[] dateIndexList = { 0, 1, 2, 3, 4, 5, 6, 7 };

	public Integer[] getDateIndexList() {
		return dateIndexList;
	}

	public String getDobText() {
		if (applicantInfo != null && applicantInfo.getDob() != null) {
			return new java.text.SimpleDateFormat("ddMMyyyy").format(applicantInfo.getDob());
		}
		return "";
	}

	public String getApprovalDate() {
		return approvalDate;
	}

	public void setApprovalDate(String approvalDate) {
		this.approvalDate = approvalDate;
	}

	public String getBranchName() {
		return branchName;
	}

	public void setBranchName(String branchName) {
		this.branchName = branchName;
	}

	public String getLoanNo() {
		return loanNo;
	}

	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}

	public UserInfo getApplicantInfo() {
		return applicantInfo;
	}

	public void setApplicantInfo(UserInfo applicantInfo) {
		this.applicantInfo = applicantInfo;
	}

	public String getVehicleMake() {
		return vehicleMake;
	}

	public void setVehicleMake(String vehicleMake) {
		this.vehicleMake = vehicleMake;
	}

	public String getVehicleModel() {
		return vehicleModel;
	}

	public void setVehicleModel(String vehicleModel) {
		this.vehicleModel = vehicleModel;
	}

	public String getOnRoadPrice() {
		return onRoadPrice;
	}

	public void setOnRoadPrice(String onRoadPrice) {
		this.onRoadPrice = onRoadPrice;
	}

	public String getLoanAmount() {
		return loanAmount;
	}

	public void setLoanAmount(String loanAmount) {
		this.loanAmount = loanAmount;
	}

	public String getRoi() {
		return roi;
	}

	public void setRoi(String roi) {
		this.roi = roi;
	}

	public String getTenor() {
		return tenor;
	}

	public void setTenor(String tenor) {
		this.tenor = tenor;
	}

	public String getEmi() {
		return emi;
	}

	public void setEmi(String emi) {
		this.emi = emi;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public double getPreEmi() {
		return preEmi;
	}

	public void setPreEmi(double preEmi) {
		this.preEmi = preEmi;
	}

	public String getDownPayment() {
		return downPayment;
	}

	public void setDownPayment(String downPayment) {
		this.downPayment = downPayment;
	}

	public String getDisbursementAmount() {
		return disbursementAmount;
	}

	public void setDisbursementAmount(String disbursementAmount) {
		this.disbursementAmount = disbursementAmount;
	}

	public String getDealerName() {
		return dealerName;
	}

	public void setDealerName(String dealerName) {
		this.dealerName = dealerName;
	}

	public String getEmiInWords() {
		return emiInWords;
	}

	public void setEmiInWords(String emiInWords) {
		this.emiInWords = emiInWords;
	}

	public String getDob() {
		return dob;
	}

	public void setDob(String dob) {
		this.dob = dob;
	}

	public String getSignPhoto() {
		return signPhoto;
	}

	public void setSignPhoto(String signPhoto) {
		this.signPhoto = signPhoto;
	}

	public String getFatherName() {
		return fatherName;
	}

	public void setFatherName(String fatherName) {
		this.fatherName = fatherName;
	}

	public String getMobile() {
		return mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}

	public String getUniqueId() {
		return uniqueId;
	}

	public void setUniqueId(String uniqueId) {
		this.uniqueId = uniqueId;
	}

	public String getMonthlyIncome() {
		return monthlyIncome;
	}

	public void setMonthlyIncome(String monthlyIncome) {
		this.monthlyIncome = monthlyIncome;
	}

	public String getEmiDueDate() {
		return emiDueDate;
	}

	public void setEmiDueDate(String emiDueDate) {
		this.emiDueDate = emiDueDate;
	}

	public String getDealerAccountNo() {
		return dealerAccountNo;
	}

	public void setDealerAccountNo(String dealerAccountNo) {
		this.dealerAccountNo = dealerAccountNo;
	}

	public String getVehicleRegNo() {
		return vehicleRegNo;
	}

	public void setVehicleRegNo(String vehicleRegNo) {
		this.vehicleRegNo = vehicleRegNo;
	}

	public String getVehicleChesisNo() {
		return vehicleChesisNo;
	}

	public void setVehicleChesisNo(String vehicleChesisNo) {
		this.vehicleChesisNo = vehicleChesisNo;
	}

	public String getVehicleEngineNo() {
		return vehicleEngineNo;
	}

	public void setVehicleEngineNo(String vehicleEngineNo) {
		this.vehicleEngineNo = vehicleEngineNo;
	}

	public String getCompanyAddress() {
		return companyAddress;
	}

	public void setCompanyAddress(String companyAddress) {
		this.companyAddress = companyAddress;
	}

	public String getAddress1() {
		return address1;
	}

	public void setAddress1(String address1) {
		this.address1 = address1;
	}

}