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.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.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.UserInfo;
import other_package.ReportInfo;

@ManagedBean(name="rdFdReport")
@ViewScoped

public class RdFdReport implements Serializable
{
	private static final long serialVersionUID = 1L;
	Date startdate=new Date(),enddate=new Date();
	ArrayList<UserInfo> list;
	int totalHolders,sno;
	double totalamount,maturityValue;
	String searchType, status,selectLoanNo;
	boolean show;
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	ArrayList<ReportInfo> clientStatementList ;
	
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	DataBaseMethods obb = new DataBaseMethods();
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();
	boolean disAll;
	String userType;

	
	public RdFdReport()
	{
		startdate.setMonth(startdate.getMonth()-1);
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		
		String cc=(String) ss.getAttribute("companyName");

		userType= (String) ss.getAttribute("type");

		
	    disAll= dbmh.disAllByCompanyNameUserType(userType,cc);

		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	
	public void checkPaidDetail() {
		
		clientStatementList = new ArrayList<>();
		Connection conn = DataBaseConnection.JAVAConnection();
		
		System.out.println("value of the selectLoanNo :"+selectLoanNo);
		
	clientStatementList = obb.dailyRDFDReport(selectLoanNo,searchType,conn );
		
	}
	
	
	
	public void view()
	{
		if(branchId != 0)
		{
			totalamount=maturityValue=0;
			show=true;
			list = obj1.usersBtwDate(branchId,startdate,enddate, searchType, status);
			totalHolders = list.size();
			for(UserInfo info:list)
			{
				totalamount = totalamount + info.getInstallment_amount();
				maturityValue = maturityValue + info.getMaturity_value();
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}
	
	public String print()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("report", "rdfd");
		ss.setAttribute("rdFdList", list);
		
		return "printRdFdReport";
		
	}
	
	
	public int getSno() {
		return sno;
	}

	public void setSno(int sno) {
		this.sno = sno;
	}

	public double getMaturityValue() {
		return maturityValue;
	}

	public void setMaturityValue(double maturityValue) {
		this.maturityValue = maturityValue;
	}

	public int getTotalHolders() {
		return totalHolders;
	}

	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<UserInfo> getList() {
		return list;
	}

	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}
	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 String getSelectLoanNo() {
		return selectLoanNo;
	}

	public void setSelectLoanNo(String selectLoanNo) {
		this.selectLoanNo = selectLoanNo;
	}



	public ArrayList<ReportInfo> getClientStatementList() {
		return clientStatementList;
	}



	public void setClientStatementList(ArrayList<ReportInfo> clientStatementList) {
		this.clientStatementList = clientStatementList;
	}



	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;
	}



	
	
}
