package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;

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;

@ManagedBean(name="dsaLedger")
@ViewScoped

public class DsaLedgerBean implements Serializable
{
	ArrayList<SelectItem> dsaList;
	String dsaCode;
	double totalCredit,totalDebit,closingBalance;
	boolean show;
	Date startDate=new Date(), endDate=new Date();
	ArrayList<DsaListInfo> list,creditList,debitList;
	DataBaseMethods obj=new DataBaseMethods();
	public DsaLedgerBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		startDate.setDate(1);
		dsaList=obj.allDsaList(branchId,"Other",conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void showReport()
	{
		int i=0;
		totalDebit=totalCredit=closingBalance=0;
		list=new ArrayList<>();
		creditList=obj.dsaCreditListFromDsaCommissionTable(dsaCode, startDate, endDate);
		debitList=obj.dsaDebitList(dsaCode, startDate, endDate);
		
		if(creditList.size()>0)
		{
			list.addAll(creditList);
		}
		
		if(debitList.size()>0)
		{
			list.addAll(debitList);
		}
		
		if(list.size()>0)
		{
			Collections.sort(list);
			for(DsaListInfo dd : list)
			{
				dd.setSno(++i);
				totalDebit+=(dd.getDebitAmount());
				totalCredit+=(dd.getCreditAmount());
			}
			closingBalance=totalCredit-totalDebit;
			show=true;
		}
		else
		{
			show=false;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found"));
		}
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public double getTotalCredit() {
		return totalCredit;
	}

	public void setTotalCredit(double totalCredit) {
		this.totalCredit = totalCredit;
	}

	public double getTotalDebit() {
		return totalDebit;
	}

	public void setTotalDebit(double totalDebit) {
		this.totalDebit = totalDebit;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public ArrayList<DsaListInfo> getList() {
		return list;
	}

	public void setList(ArrayList<DsaListInfo> list) {
		this.list = list;
	}

	public double getClosingBalance() {
		return closingBalance;
	}

	public void setClosingBalance(double closingBalance) {
		this.closingBalance = closingBalance;
	}

	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;
	}
	
	
}
