package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
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.DataBaseMethodsRaviK;
import main_package.DataBaseConnection;
import main_package.UserInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="ddReport")
@ViewScoped

public class DDReportBean  implements Serializable
{
ArrayList<SelectItem> dsaList;
String dsaType="",nameDsa,chkDate, printDate, searchType, dsaCode;
String frequencyType = "all";
Boolean show=false,dsaName=false,namerndr, disDsa;
Date startdate;
UserInfo selected;
ArrayList<UserInfo> list;
double depositAmt, openingAmt,dueAmt;
DataBaseMethods dbm=new DataBaseMethods();
int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();

	private String username,designationName;
	private boolean renAllForBranch;


boolean renDueDate,disAll;
DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();
DataBaseMethodsRaviK dbmr = new DataBaseMethodsRaviK();

String userType;



public DDReportBean()
{
	startdate=new Date();
	Connection conn=DataBaseConnection.JAVAConnection();
	DataBaseMethods db=new DataBaseMethods();
	  selected=db.firmDetailsLogo();
	
	if(selected.getName().equalsIgnoreCase("ROYAL MICROFINANCE"))
	{
		renDueDate=true;
	}
	else {
		renDueDate=false;
	}
	
	  
	/*for(int i=0;i<dsaList.size();i++)
	{
		RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "Message", "DSA List Size: "+dsaList.size()));
		FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("DSA Label: "+dsaList.get(i).getLabel()));
	}*/

	HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
	int branchId = (int) ss.getAttribute("branchId");
	
     String uname= (String) ss.getAttribute("username");
     String cc=(String) ss.getAttribute("companyName");

		userType= (String) ss.getAttribute("type");

		
	    disAll= dbmh.disAllByCompanyNameUserType(userType,cc);

//      String getDesignationName =DataBaseMethodsHemant.getDesignationByUname(uname);
//      System.out.println("designation is get By uname is:"+getDesignationName);
//    
//    if(getDesignationName.equalsIgnoreCase("BRANCH MANAGER"))
//    {
//    	renAllForBranch=true;
//    }
//    else
//    {
//    	renAllForBranch=false;
//    }
	list=(ArrayList<UserInfo>) ss.getAttribute("listForPrint");
	nameDsa=(String) ss.getAttribute("name");
	dsaType=(String) ss.getAttribute("code");
	printDate=(String) ss.getAttribute("chkDate");
	
	if(list==null)
	{
		
	}
	else
	{
		if(nameDsa==null)
		{
			
		}
		else if(nameDsa.equals("all"))
		{
			namerndr=false;
		}
		else
		{
			namerndr=true;
		}
		depositAmt=openingAmt=0;
		for(UserInfo uu: list)
		{
			depositAmt+=uu.getDepositAmt();
			openingAmt+=uu.getOpeningAmt();
		}
	}
	
	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"))
	{
		dsaType=dbm.dsaCodeByEmpUserId(userId, conn);
		disDsa=true;
	}
	
	branchUserId = (String) ss.getAttribute("branchUserId");
	branchList = new DataBaseMethods().branchList(branchUserId,conn);
	try {
		conn.close();
	} catch (Exception e) {
		// TODO: handle exception
	}
}


public UserInfo firmDetailsLogo() 
{
	UserInfo uu=new UserInfo();
	try(Connection con=DataBaseConnection.JAVAConnection();) 
	{
		Statement st=con.createStatement();
		String qq="select logo,name from firm_detail";
		ResultSet rs=st.executeQuery(qq);
		if(rs.next())
		{
			uu.setLogo(rs.getString("logo"));
			uu.setName(rs.getString("name"));
		}
	}
	catch (Exception e)
	{
		 e.printStackTrace();
	} 
	return uu;
}

public void view()
{
	
	if(branchId != 0)
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		depositAmt=openingAmt=0;
		show=true;
		if(dsaType.equals("all"))
		{
			dsaName=true;
			namerndr=false;
			
		}
		else
		{
			dsaName=false;
			namerndr=true;
			nameDsa= dbm.dsaNameById(dsaType,conn);
		}
		chkDate = new SimpleDateFormat("yyyy-MM-dd").format(startdate);
		printDate = new SimpleDateFormat("dd-MMM-yyyy").format(startdate);
		
		if(searchType.equalsIgnoreCase("all"))
		{
			list=new ArrayList<>();
			ArrayList<UserInfo> list1,list2,list3,list4,list5;
			
//			list1=dbm.ddList(branchId,dsaType,chkDate,conn, "DD" ,frequencyType);
//			list2=dbm.ddList(branchId,dsaType,chkDate,conn, "RD" ,frequencyType);
//			list3=dbm.ddList(branchId,dsaType,chkDate,conn, "DL" ,frequencyType);
//			list4=dbm.ddList(branchId,dsaType,chkDate,conn, "PL" ,frequencyType);
//			list5=dbm.ddList(branchId,dsaType,chkDate,conn, "GL" ,frequencyType);
			 
			list1=dbmr.ddList(branchId,dsaType,chkDate,conn, "DD" ,frequencyType);
			list2=dbmr.ddList(branchId,dsaType,chkDate,conn, "RD" ,frequencyType);
//			list3=dbmr.ddList(branchId,dsaType,chkDate,conn, "DL" ,frequencyType);
			list4=dbmr.ddList(branchId,dsaType,chkDate,conn, "PL" ,frequencyType);
			list5=dbmr.ddList(branchId,dsaType,chkDate,conn, "GL" ,frequencyType);
			
			list.addAll(list1);
			list.addAll(list2);
//			list.addAll(list3);
			list.addAll(list4);
			list.addAll(list5);
			
			for(int i=0;i<list.size();i++)
			{
				list.get(i).setSno(i+1);
			}
		}
		else
		{
			list= dbmr.ddList(branchId,dsaType,chkDate,conn, searchType, frequencyType);
		}
		
		for(UserInfo uu: list)
		{
			depositAmt+=uu.getDepositAmt();
			openingAmt+=uu.getOpeningAmt();
			//dueAmt+=Double.valueOf(uu.getDueAmt());
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	else
	{
		FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
	}
	
}
public String print()
{
	// System.out.println("hello: "+dsaType+"/"+nameDsa);
	HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
	ss.setAttribute("listForPrint",list);
	ss.setAttribute("name",nameDsa);
	ss.setAttribute("code",dsaType);
	ss.setAttribute("chkDate",printDate);
	RequestContext.getCurrentInstance().execute("window.open('printDDReport.xhtml')");
	return "ddReport.xhtml";
}


public ArrayList<SelectItem> getDsaList() {
	return dsaList;
}
public void setDsaList(ArrayList<SelectItem> dsaList) {
	this.dsaList = dsaList;
}
public String getDsaType() {
	return dsaType;
}
public void setDsaType(String dsaType) {
	this.dsaType = dsaType;
}
public Boolean getShow() {
	return show;
}
public void setShow(Boolean show) {
	this.show = show;
}
public Date getStartdate() {
	return startdate;
}
public void setStartdate(Date startdate) {
	this.startdate = startdate;
}
public ArrayList<UserInfo> getList() {
	return list;
}
public void setList(ArrayList<UserInfo> list) {
	this.list = list;
}
public Boolean getDsaName() {
	return dsaName;
}
public void setDsaName(Boolean dsaName) {
	this.dsaName = dsaName;
}
public String getNameDsa() {
	return nameDsa;
}
public void setNameDsa(String nameDsa) {
	this.nameDsa = nameDsa;
}
public Boolean getNamerndr() {
	return namerndr;
}
public void setNamerndr(Boolean namerndr) {
	this.namerndr = namerndr;
}


public String getChkDate() {
	return chkDate;
}


public void setChkDate(String chkDate) {
	this.chkDate = chkDate;
}


public double getDepositAmt() {
	return depositAmt;
}


public void setDepositAmt(double depositAmt) {
	this.depositAmt = depositAmt;
}


public double getOpeningAmt() {
	return openingAmt;
}


public void setOpeningAmt(double openingAmt) {
	this.openingAmt = openingAmt;
}


public String getPrintDate() {
	return printDate;
}


public void setPrintDate(String printDate) {
	this.printDate = printDate;
}


public String getSearchType() {
	return searchType;
}


public void setSearchType(String searchType) {
	this.searchType = searchType;
}


public double getDueAmt() {
	return dueAmt;
}


public void setDueAmt(double dueAmt) {
	this.dueAmt = dueAmt;
}


public String getDsaCode() {
	return dsaCode;
}


public void setDsaCode(String dsaCode) {
	this.dsaCode = dsaCode;
}


public Boolean getDisDsa() {
	return disDsa;
}


public void setDisDsa(Boolean disDsa) {
	this.disDsa = disDsa;
}

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 String getUsername() {
	return username;
}


public void setUsername(String username) {
	this.username = username;
}


public String getDesignationName() {
	return designationName;
}


public void setDesignationName(String designationName) {
	this.designationName = designationName;
}


public boolean isRenAllForBranch() {
	return renAllForBranch;
}


public void setRenAllForBranch(boolean renAllForBranch) {
	this.renAllForBranch = renAllForBranch;
}
public boolean isRenDueDate() {
	return renDueDate;
}


public void setRenDueDate(boolean renDueDate) {
	this.renDueDate = renDueDate;


}


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 UserInfo getSelected() {
	return selected;
}


public void setSelected(UserInfo selected) {
	this.selected = selected;
}


public DataBaseMethods getDbm() {
	return dbm;
}


public void setDbm(DataBaseMethods dbm) {
	this.dbm = dbm;
}


public String getBranchUserId() {
	return branchUserId;
}


public void setBranchUserId(String branchUserId) {
	this.branchUserId = branchUserId;
}


public DataBaseMethodsHemant getDbmh() {
	return dbmh;
}


public void setDbmh(DataBaseMethodsHemant dbmh) {
	this.dbmh = dbmh;
}


public String getFrequencyType() {
	return frequencyType;
}


public void setFrequencyType(String frequencyType) {
	this.frequencyType = frequencyType;
}

}