package report_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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 main_package.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.DataBaseConnection;
import main_package.LoanInfo;

@ManagedBean(name="loanReport")
@ViewScoped
public class LoanReport implements Serializable
{
	private static final long serialVersionUID = 1L;
	Date startdate=new Date(),enddate=new Date();
	ArrayList<LoanInfo> list;
	String status="Approve" ,loanType="all", frequency="all";
	int totalHolders,sno;
	double totalamount,filecharge,maturityValue;
	ArrayList<LoanInfo> glist,blist,pelist,slist;
	ArrayList<SelectItem> loanTypeList;
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	int branchId;
	String branchUserId;
	DataBaseMethods obj=new DataBaseMethods();

	boolean showBtn=false;
	LoanInfo selectedRow;
	ArrayList<SelectItem>  dsaList;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();

	boolean disAll;
	String userType,dsaCode;
	
	public LoanReport()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		startdate.setDate(1);
		Connection conn=DataBaseConnection.JAVAConnection();
		loanTypeList=new DataBaseMethods().loanTypeList(conn);
		
		String cc=(String) ss.getAttribute("companyName");

		userType= (String) ss.getAttribute("type");
        		
	    disAll= dbmh.disAllByCompanyNameUserType(userType,cc);
	    dsaList=obj.allDsaList(branchId,"Loan",conn);
		
		
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,conn);
		
		list = new ArrayList<>();
		double d=0.0;
		totalamount=0;
		totalHolders=0;
		
		/*glist = new DataBaseMethods().groupLoanList(status);
		prlist = new DataBaseMethods().propertyLoanList(status);
		pelist = new DataBaseMethods().personalLoanList(status);
		vlist = new DataBaseMethods().vehicleLoanList(status);*/
		
		glist = obj1.groupLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
		blist = obj1.businessLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
		pelist = obj1.personalLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
		slist = obj1.secureLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
		
		list.addAll(glist);
		list.addAll(blist);
		list.addAll(pelist);
		list.addAll(slist);
		
		sno=1;
		totalHolders = list.size();
		
		for(LoanInfo info:list)
		{
			if(info.getFileCharge().isEmpty())
			{
				d = 0.0;
			}
			else
			{
				d= Double.valueOf(info.getFileCharge());
			}
			filecharge = filecharge + d;
			info.setSno(sno++);
			totalamount = totalamount + Double.valueOf(info.getLoanAmount());
		}

try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void reverseForApproval() throws IOException
	{
		if(branchId==-1)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select any Branch from the Branch List for the Again Reverse Loan Approval. Thank You!!!"));
		}
		else
		{
			String loanType=new DataBaseMethods().loanValueByLoanLabel(selectedRow.getLoanType());
			String loanNo="";
			if(loanType.equalsIgnoreCase("grouploan"))
			{
				loanNo=selectedRow.getSubLoanNo();
			}
			else
			{
				loanNo=selectedRow.getLoanNo();
			}
			int i=new DataBaseMethods().againReverseForApproval(loanNo,loanType,branchId);
			if(i>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Again Reverse For Loan Approval is Done!!! Please Check Loan in Loan Approval. Thank You!!!"));
				view();
				FacesContext.getCurrentInstance().getExternalContext().redirect("loanReport.xhtml");
			}
		}
	}
	
	public void view()
	{		
		System.out.println("view hit");
		if(branchId != 0)
		{   
			
			Connection conn=DataBaseConnection.JAVAConnection();
			if(status.equalsIgnoreCase("notApprove"))
			{
				showBtn=true;
			}
			else
			{
				showBtn=false;
			}
			
			glist=blist=pelist=slist=new ArrayList<>();
			list = new ArrayList<>();
			totalamount=0;
			if(loanType.equals("all"))
			{
				glist = obj1.groupLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				blist = obj1.businessLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				pelist = obj1.personalLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				slist = obj1.secureLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				
				list.addAll(glist);
				list.addAll(blist);
				list.addAll(pelist);
				list.addAll(slist);
			}
			else if(loanType.equals("personalloan"))
			{
				pelist = obj1.personalLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				list.addAll(pelist);
			}
			else if(loanType.equals("business_loan"))
			{
				blist = obj1.businessLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				list.addAll(blist);
			}
			else if(loanType.equals("grouploan"))
			{
				glist = obj1.groupLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode,conn);
				list.addAll(glist);
			}
			else if(loanType.equals("secure_loan"))
			{
				slist = obj1.secureLoanListbtwDate(branchId,startdate,enddate,status, frequency,dsaCode ,conn);
				list.addAll(slist);
			}
			
			
			totalHolders = list.size();
			double d=0.0;
			sno=1;
			for(LoanInfo info:list)
			{
				if(info.getFileCharge().isEmpty())
				{
					d = 0.0;
				}
				else
				{
					d= Double.valueOf(info.getFileCharge());
				}
				filecharge = filecharge + d;
				info.setSno(sno++);
				totalamount = totalamount + Double.valueOf(info.getLoanAmount());
			}  
	try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
    	else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}
	
	public String print()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("report", "loan");
		ss.setAttribute("list", list);
		return "printLoanReport";
	}
	
	
	public double getFilecharge() {
		return filecharge;
	}

	public void setFilecharge(double filecharge) {
		this.filecharge = filecharge;
	}

	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	public double getMaturityValue() {
		return maturityValue;
	}

	public void setMaturityValue(double maturityValue) {
		this.maturityValue = maturityValue;
	}

	public int getTotalHolders() {
		return totalHolders;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public void setTotalHolders(int totalHolders) {
		this.totalHolders = totalHolders;
	}

	public double getTotalamount() {
		return totalamount;
	}

	public void setTotalamount(double totalamount) {
		this.totalamount = totalamount;
	}

	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 ArrayList<LoanInfo> getList() {
		return list;
	}

	public void setList(ArrayList<LoanInfo> list) {
		this.list = list;
	}
	
	public int getSno() {
		return sno;
	}

	public void setSno(int sno) {
		this.sno = sno;
	}

	public ArrayList<LoanInfo> getGlist() {
		return glist;
	}

	public void setGlist(ArrayList<LoanInfo> glist) {
		this.glist = glist;
	}

	

	public ArrayList<LoanInfo> getPelist() {
		return pelist;
	}

	public void setPelist(ArrayList<LoanInfo> pelist) {
		this.pelist = pelist;
	}

	

	public ArrayList<SelectItem> getLoanTypeList() {
		return loanTypeList;
	}

	public void setLoanTypeList(ArrayList<SelectItem> loanTypeList) {
		this.loanTypeList = loanTypeList;
	}

	public String getFrequency() {
		return frequency;
	}

	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}

	public ArrayList<LoanInfo> getBlist() {
		return blist;
	}

	public void setBlist(ArrayList<LoanInfo> blist) {
		this.blist = blist;
	}

	public ArrayList<LoanInfo> getSlist() {
		return slist;
	}

	public void setSlist(ArrayList<LoanInfo> slist) {
		this.slist = slist;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public boolean isShowBtn() {
		return showBtn;
	}

	public void setShowBtn(boolean showBtn) {
		this.showBtn = showBtn;
	}

	public LoanInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(LoanInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	public boolean isDisAll() {
		return disAll;
	}

	public void setDisAll(boolean disAll) {
		this.disAll = disAll;
	}

	public String getUserType() {
		return userType;
	}

	public void setUserType(String userType) {
		this.userType = userType;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}
}
