package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;


@ManagedBean(name="eNachExport")
@ViewScoped
public class EnachModuleDataExportBean implements Serializable {

	
public Date fromDate,toDate;	
ArrayList<EnachDataExportInfo>loanList;
ArrayList<LoanInfo>infolist;

DbYashwant dby = new DbYashwant();
DataBaseMethods dbm = new DataBaseMethods();
SimpleDateFormat sf=new SimpleDateFormat("yyyy-MM-dd");

public void  nachExport()
{
	loanList= new ArrayList<>();
	infolist =new ArrayList<>();
	Connection con =DataBaseConnection.JAVAConnection();
	loanList =dby.selectEnachLoanNo(con,fromDate,toDate);
	dby.selectUmrnNo(loanList, con);
	
	for(EnachDataExportInfo ss : loanList)
	{
		if(null !=(ss.getUmrnNo()))
		{
			
		dby.loanInstallment("personalloan", ss.getLoanNo(), con,infolist,ss.getUmrnNo());
			dby.loanInstallment("grouploan", ss.getLoanNo(), con,infolist,ss.getUmrnNo());
		}
	}
	String frmD = sf.format(fromDate);
	String toD = sf.format(toDate);
	
	loanList = new ArrayList<>();
	for (LoanInfo ll: infolist)
	{
		if(ll.getLoanNo()!= null)
		{
			if(ll.getStrInstlmntDate().compareTo(frmD) >= 0 && ll.getStrInstlmntDate().compareTo(toD) <= 0)
 {
			EnachDataExportInfo ss = new EnachDataExportInfo();
			ss.setLoanNo(ll.getLoanNo());
			String[] parts = ll.getLoanNo().split("-");

			// parts[0] = "2025"
			ss.setEmiAmount(ll.getDueAmount());
			ss.setUmrnNo(ll.getUmrnNo());
			ss.setEmiDate(ll.getStrInstlmntDate());
			ss.setEmiNO(ll.getEmiNo());
			if(parts[0].equalsIgnoreCase("GL")) {
				ss.setPreEmiAmount(dbm.preEmiChargeCalculationMethod(ll.getLoanNo(), "grouploan", con));
				System.out.println("GL");
				
			}
			else
			{
				ss.setPreEmiAmount(dbm.preEmiChargeCalculationMethod(ll.getLoanNo(), "personalloan", con));
	
			}
			loanList.add(ss);
 }
		}
	}
	
	
}






public ArrayList<EnachDataExportInfo> getLoanList() {
	return loanList;
}

public void setLoanList(ArrayList<EnachDataExportInfo> loanList) {
	this.loanList = loanList;
}




public Date getFromDate() {
	return fromDate;
}




public void setFromDate(Date fromDate) {
	this.fromDate = fromDate;
}




public Date getToDate() {
	return toDate;
}




public void setToDate(Date toDate) {
	this.toDate = toDate;
}




public ArrayList<LoanInfo> getInfolist() {
	return infolist;
}




public void setInfolist(ArrayList<LoanInfo> infolist) {
	this.infolist = infolist;
}
}
