package report_package;

import java.io.Serializable;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
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.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.DataBaseMethodsRavi;
import main_package.DataBaseMethodsRaviK;
import main_package.LoanInfo;

@ViewScoped
@ManagedBean(name="loanBalanceReport")
public class LoanBalanceReportBean implements Serializable
{
	ArrayList<LoanInfo> list;
	String center, loanType, dsaCode, branchUserId;;
	long loanAmount, paidAmount, balanceAmount, totalAmount;
	BigDecimal bigLoanAmount;
	
	ArrayList<SelectItem> centerList;
	int branchId;
	DataBaseMethods obj=new DataBaseMethods();
	boolean show, showCenter;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	ArrayList<SelectItem>  dsaList;
	
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();
	DataBaseMethodTaheer dbt = new DataBaseMethodTaheer();
	DataBaseMethodsRavi dbmr = new DataBaseMethodsRavi();

	boolean disAll;
	String userType;
	
	public LoanBalanceReportBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,conn);
	    
		dsaList=obj.allDsaList(branchId,"Loan",conn);
		centerList=obj.allcenter(branchId,"all",conn);
		
		String cc=(String) ss.getAttribute("companyName");
        
		userType= (String) ss.getAttribute("type");
        		
	    disAll= dbmh.disAllByCompanyNameUserType(userType,cc);
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void checkDsa()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		dsaList=obj.allDsaList(branchId,"Loan",conn);
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void checkCenter()
	{
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			showCenter=true;
		}
		else
		{
			showCenter=false;
		}
	}
    
	public void search() 
	{
		loanAmount=paidAmount=balanceAmount=totalAmount=0;
		
		if(loanType.equalsIgnoreCase("grouploan"))
		{
			list=new DataBaseMethodTaheer().loanWiseBalanceReport(branchId,center, dsaCode);
		}
				
		else
		{
			list=new DataBaseMethodTaheer().loanWiseBalanceReportAllOtherLoan(branchId,loanType, dsaCode);
		}
		
		if(list.size()>0)
		{			
			show=true;
			
			for(LoanInfo ll: list)
			{				
				loanAmount+=Double.parseDouble(ll.getLoanAmount());
				bigLoanAmount =new BigDecimal(loanAmount);
				paidAmount+=ll.getPaidAmount();
				balanceAmount+=ll.getBalance();
				totalAmount+=ll.getTotalAmount();
			}
		}
		else
		{
			show=false;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found!!!"));
		}
	}
    
	
	
	public ArrayList<LoanInfo> getList() {
		return list;
	}

	public void setList(ArrayList<LoanInfo> list) {
		this.list = list;
	}

	

	public double getLoanAmount() {
		return loanAmount;
	}

	
	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public boolean isShowCenter() {
		return showCenter;
	}

	public void setShowCenter(boolean showCenter) {
		this.showCenter = showCenter;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	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 long getPaidAmount() {
		return paidAmount;
	}

	public void setPaidAmount(long paidAmount) {
		this.paidAmount = paidAmount;
	}

	public long getBalanceAmount() {
		return balanceAmount;
	}

	public void setBalanceAmount(long balanceAmount) {
		this.balanceAmount = balanceAmount;
	}

	public long getTotalAmount() {
		return totalAmount;
	}

	public void setTotalAmount(long totalAmount) {
		this.totalAmount = totalAmount;
	}

	public void setLoanAmount(long loanAmount) {
		this.loanAmount = loanAmount;
	}

	public BigDecimal getBigLoanAmount() {
		return bigLoanAmount;
	}

	public void setBigLoanAmount(BigDecimal bigLoanAmount) {
		this.bigLoanAmount = bigLoanAmount;
	}

	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;
	}
	
	
}