package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;

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;

@ViewScoped
@ManagedBean(name="dailyDemandReport")
public class DailyDemandReportBean implements Serializable
{
	ArrayList<DailyInfo> list;
	String dsaCode;
	Date searchDate;
	boolean disDsa, checkDl;
	ArrayList<SelectItem> dsaList;
	int totalPl, totalGl, totalSl, totalDd, totalRd, grandTotal, branchId;
	DataBaseMethods dbm=new DataBaseMethods();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	
	
	
	public DailyDemandReportBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId =(int) ss.getAttribute("branchId");
		
		Connection conn=DataBaseConnection.JAVAConnection();
		
		searchDate=new Date();
		String userId=dbm.userId();
		dsaList=dbm.allDsaList(branchId,"Loan",conn);
		String empDataStatus=dbm.checkSMessageApiDetailFromTable("employee_wise_data", "",conn);
		if(dbm.userType().equals("employee") && empDataStatus.equalsIgnoreCase("active"))
		{
			dsaCode=dbm.dsaCodeByEmpUserId(userId, conn);
			disDsa=true;
		}
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void  searchReport()
	{
		list=new DataBaseReportMethods().dailyDemandMethod(branchId,searchDate, dsaCode, checkDl);
		
		System.out.println("DEMAND : -> "+branchId +" |"+searchDate+" |"+dsaCode+" |"+checkDl);
		
		if(list.size()>0)
		{
			totalPl=totalGl=totalSl=totalDd=totalRd=grandTotal=0;
			for(DailyInfo dd: list)
			{
				totalPl+=dd.getTotalPl();
				totalGl+=dd.getTotalGl();
				totalSl+=dd.getTotalSl();
				totalDd+=dd.getTotalDd();
				totalRd+=dd.getTotalRd();
				grandTotal+=dd.getTotal();
			}
		}
		System.out.println("list size "+list.size());
	}

	public ArrayList<DailyInfo> getList() {
		return list;
	}

	public void setList(ArrayList<DailyInfo> list) {
		this.list = list;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public Date getSearchDate() {
		return searchDate;
	}

	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}

	public boolean isDisDsa() {
		return disDsa;
	}

	public void setDisDsa(boolean disDsa) {
		this.disDsa = disDsa;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public int getTotalPl() {
		return totalPl;
	}

	public void setTotalPl(int totalPl) {
		this.totalPl = totalPl;
	}

	public int getTotalGl() {
		return totalGl;
	}

	public void setTotalGl(int totalGl) {
		this.totalGl = totalGl;
	}

	public int getTotalSl() {
		return totalSl;
	}

	public void setTotalSl(int totalSl) {
		this.totalSl = totalSl;
	}

	public int getTotalDd() {
		return totalDd;
	}

	public void setTotalDd(int totalDd) {
		this.totalDd = totalDd;
	}

	public int getTotalRd() {
		return totalRd;
	}

	public void setTotalRd(int totalRd) {
		this.totalRd = totalRd;
	}

	public int getGrandTotal() {
		return grandTotal;
	}

	public void setGrandTotal(int grandTotal) {
		this.grandTotal = grandTotal;
	}

	public boolean isCheckDl() {
		return checkDl;
	}

	public void setCheckDl(boolean checkDl) {
		this.checkDl = checkDl;
	}
}