package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collections;
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.servlet.http.HttpSession;

import main_package.DataBaseAutoCompAndDuplicate;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import other_package.DataBaseMethodsOther;
import other_package.ReportInfo;

@ViewScoped
@ManagedBean(name="memberLedgerReport")
public class MemberLedgerReportBean implements Serializable
{
	ArrayList<ReportInfo> finalList, incomeList;
	String shareHolderNo;
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	DataBaseMethods dbm=new DataBaseMethods();
	Date startDate=new Date(), endDate=new Date();
	public static List<String> list;
	double debitAmount, creditAmount, balance;
	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().shareHolderAllNo(branchId,name);
     	return list;
	}
	
	
	
	public void searchReport()
	{
		balance=debitAmount=creditAmount=0;
		Connection conn=DataBaseConnection.JAVAConnection();
		finalList=new ArrayList<>();
		if(shareHolderNo.contains("/"))
		{
			shareHolderNo=shareHolderNo.substring(0,shareHolderNo.indexOf("/"));
		}
		
		finalList.addAll(dbmr.loanEmiLedgerByShareHolderNo(shareHolderNo, conn));
		finalList.addAll(dbmr.debitloanLedgerList(shareHolderNo, conn));
		
		finalList.addAll(dbmr.depositLedgerByShareHolderNo(shareHolderNo, conn));
		
		startDate.setYear(115);
		finalList.addAll(new DataBaseMethodsOther().savingAccountLedgerForMember(dbm.savingAccountByShareHolderNo(shareHolderNo),startDate,endDate));
		finalList.addAll(dbmr.incomeLedgerReportForMember(shareHolderNo, conn));
		
		Collections.sort(finalList);
		
		for(ReportInfo rr: finalList)
		{
			debitAmount+=rr.getDebitAmount();
			creditAmount+=rr.getCreditAmount();
		}
		balance=creditAmount-debitAmount;
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}



	public ArrayList<ReportInfo> getFinalList() {
		return finalList;
	}



	public void setFinalList(ArrayList<ReportInfo> finalList) {
		this.finalList = finalList;
	}



	public ArrayList<ReportInfo> getIncomeList() {
		return incomeList;
	}



	public void setIncomeList(ArrayList<ReportInfo> incomeList) {
		this.incomeList = incomeList;
	}



	public String getShareHolderNo() {
		return shareHolderNo;
	}



	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}



	public static List<String> getList() {
		return list;
	}



	public static void setList(List<String> list) {
		MemberLedgerReportBean.list = list;
	}



	public double getDebitAmount() {
		return debitAmount;
	}



	public void setDebitAmount(double debitAmount) {
		this.debitAmount = debitAmount;
	}



	public double getCreditAmount() {
		return creditAmount;
	}



	public void setCreditAmount(double creditAmount) {
		this.creditAmount = creditAmount;
	}



	public double getBalance() {
		return balance;
	}



	public void setBalance(double balance) {
		this.balance = balance;
	}
}
