package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.UserInfo;
import other_package.ReportInfo;

@ManagedBean(name="centerWiseCollectionReport")
@ViewScoped
public class CenterWiseCollectionReportBean implements Serializable
{
	Date searchDate=new Date(), endDate=new Date();
	ArrayList<UserInfo> list;
	UserInfo listr1;
	double grandTotal, loanTotal, rdTotal;
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	DataBaseMethods dbm=new DataBaseMethods();
	DataBaseMethodsHemant dbh = new DataBaseMethodsHemant();
	List<SelectItem> branchList, centerList;
	int branchId, centerId;
	String  userType, shareholderNo;
	boolean disAll;
	private ArrayList<UserInfo> detailList=new ArrayList<>();
	private double detailLoanTotal;
	private double detailRdTotal;
	private double detailPenaltyTotal;
	private double detailGrandTotal;
	
	public CenterWiseCollectionReportBean() 
	{
		searchDate.setDate(1);
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		String branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = dbm.branchList(branchUserId,conn);
		String cc=(String) ss.getAttribute("companyName");

		userType= (String) ss.getAttribute("type");

		
	    disAll= dbh.disAllByCompanyNameUserType(userType,cc);

		
	}
		
	
	public void fetchCenterList()
	{
		centerList = new ArrayList<>();
		centerList = dbh.centerListByBranchId(branchId);
	}   
    
	public void searchData()
	{
		//Connection conn=DataBaseConnection.JAVAConnection();
		loanTotal=rdTotal=grandTotal=0;
		list=dbh.centerWiseCollectionList(branchId,searchDate,endDate, centerId);
		if(list.size()>0)
		{
			for(UserInfo uu: list)
			{   
				loanTotal+=uu.getLoanAmount();
				rdTotal+=uu.getRdAmount();
				System.out.println("rd ka total KYA TOTAL AAYEGA::"+rdTotal);
				grandTotal+=uu.getTotalAmount();
				
			}
		}
	}
	
	public void loadDetail(UserInfo info)
	{
	    detailLoanTotal=0;
	    detailRdTotal=0;
	    detailPenaltyTotal=0;
	    detailGrandTotal=0;

	    detailList=dbh.centerWiseCollectionDetail(
	            branchId,
	            searchDate,
	            endDate,
	            info.getCenterId());

	    for(UserInfo uu:detailList)
	    {
	        detailLoanTotal+=uu.getLoanAmount();
	        detailRdTotal+=uu.getRdAmount();
	        detailPenaltyTotal+=uu.getPenalty();
	        detailGrandTotal+=uu.getTotalAmount();
	    }
	    
	    System.out.println("CENTER ID = "+info.getCenterId());
	    
	    
	    
	    
	}
	
	
	
	
	
	


	public Date getSearchDate() {
		return searchDate;
	}


	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}


	public double getGrandTotal() {
		return grandTotal;
	}


	public void setGrandTotal(double grandTotal) {
		this.grandTotal = grandTotal;
	}


	public double getLoanTotal() {
		return loanTotal;
	}


	public void setLoanTotal(double loanTotal) {
		this.loanTotal = loanTotal;
	}


	public double getRdTotal() {
		return rdTotal;
	}


	public void setRdTotal(double rdTotal) {
		this.rdTotal = rdTotal;
	}


	public ArrayList<UserInfo> getList() {
		return list;
	}


	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public String getUserType() {
		return userType;
	}

	public void setUserType(String userType) {
		this.userType = userType;
	}

	public boolean isDisAll() {
		return disAll;
	}

	public void setDisAll(boolean disAll) {
		this.disAll = disAll;
	}

	public List<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(List<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public int getCenterId() {
		return centerId;
	}

	public void setCenterId(int centerId) {
		this.centerId = centerId;
	}



	public UserInfo getListr1() {
		return listr1;
	}



	public void setListr1(UserInfo listr1) {
		this.listr1 = listr1;
	}



	public DataBaseReportMethods getDbmr() {
		return dbmr;
	}



	public void setDbmr(DataBaseReportMethods dbmr) {
		this.dbmr = dbmr;
	}



	public DataBaseMethods getDbm() {
		return dbm;
	}



	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}



	public DataBaseMethodsHemant getDbh() {
		return dbh;
	}



	public void setDbh(DataBaseMethodsHemant dbh) {
		this.dbh = dbh;
	}



	public String getShareholderNo() {
		return shareholderNo;
	}



	public void setShareholderNo(String shareholderNo) {
		this.shareholderNo = shareholderNo;
	}



	public ArrayList<UserInfo> getDetailList() {
		return detailList;
	}



	public void setDetailList(ArrayList<UserInfo> detailList) {
		this.detailList = detailList;
	}



	public double getDetailLoanTotal() {
		return detailLoanTotal;
	}



	public void setDetailLoanTotal(double detailLoanTotal) {
		this.detailLoanTotal = detailLoanTotal;
	}



	public double getDetailRdTotal() {
		return detailRdTotal;
	}



	public void setDetailRdTotal(double detailRdTotal) {
		this.detailRdTotal = detailRdTotal;
	}



	public double getDetailPenaltyTotal() {
		return detailPenaltyTotal;
	}



	public void setDetailPenaltyTotal(double detailPenaltyTotal) {
		this.detailPenaltyTotal = detailPenaltyTotal;
	}



	public double getDetailGrandTotal() {
		return detailGrandTotal;
	}



	public void setDetailGrandTotal(double detailGrandTotal) {
		this.detailGrandTotal = detailGrandTotal;
	}
	
	
	
}