package report_package;

import java.io.IOException;
import java.io.Serializable;
import java.text.DecimalFormat;
import java.util.ArrayList;
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;

import main_package.DataBaseMethods;
import main_package.UserInfo;

import org.primefaces.context.RequestContext;

import other_package.DataBaseMethodsOther;
import other_package.ReportInfo;

@ManagedBean(name="savingAccountStatement")
@ViewScoped
public class SavingAccountStatementBean implements Serializable
{
	Date startDate=new Date(), endDate=new Date();
	boolean show;
	ArrayList<ReportInfo> list;
	ReportInfo selectedAccount;
	UserInfo selectedUser;
	DataBaseMethodsOther dbmp=new DataBaseMethodsOther();
	int total;
	DecimalFormat df=new DecimalFormat("##.##");
	double openingAmount, creditAmount, debitAmount, balance;
	ArrayList<SelectItem> savingAccList;
	String accountNo, center;
	
	public SavingAccountStatementBean() 
	{
		startDate.setDate(1);
		savingAccList=new DataBaseReportMethods().savingActiveAccountNoList();
	}
	
	public void searchReport()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		show=true;
		openingAmount=creditAmount=debitAmount=balance=0;
		list=dbmp.savingAccStatementForAll(branchId,startDate,endDate, accountNo, center);
		total=list.size();
		for(ReportInfo rr: list)
		{
			openingAmount+=rr.getAmount();
			creditAmount+=rr.getCreditAmount();
			debitAmount+=rr.getDebitAmount();
			balance+=rr.getBalance();
		}
		
		openingAmount=Double.parseDouble(df.format(openingAmount));
		creditAmount=Double.parseDouble(df.format(creditAmount));
		debitAmount=Double.parseDouble(df.format(debitAmount));
		balance=Double.parseDouble(df.format(balance));
	}
	
	public void refreshSavingBalance()
	{
		int i=dbmp.refreshSavingAccountBalance(selectedAccount);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Balance Update Successfully !!!"));
			searchReport();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Amount Update !!!"));
		}
	}
	
	public void refreshSavingBalanceMultiple()
	{
		int i=0;
		for(ReportInfo rr: list)
		{
			i+=dbmp.refreshSavingAccountBalance(rr);
		}
		
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(i+" Saving Account Balance Update Successfully !!!"));
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Amount Update !!!"));
		}
	}

	public void printReport()
	{
		System.out.println("printtt");
	}
	
	// This Method Return on Mini-Statement Page where We Can Check Saving Account Statement.
	public void miniStatement() throws IOException
	{
		selectedUser=new DataBaseMethods().savingAccountDetailByShareHolderNo(selectedAccount.getShareHolderNo());
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedUser", selectedUser);
		ss.setAttribute("pageName","savingAccountStatement");
		ss.setAttribute("svStartDate", startDate);
		ss.setAttribute("svEndDate", endDate);
		
		RequestContext.getCurrentInstance().execute("window.open('miniStatement.xhtml')");
	}
		
	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 boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public ArrayList<ReportInfo> getList() {
		return list;
	}

	public void setList(ArrayList<ReportInfo> list) {
		this.list = list;
	}

	public DataBaseMethodsOther getDbmp() {
		return dbmp;
	}

	public void setDbmp(DataBaseMethodsOther dbmp) {
		this.dbmp = dbmp;
	}

	public ReportInfo getSelectedAccount() {
		return selectedAccount;
	}

	public void setSelectedAccount(ReportInfo selectedAccount) {
		this.selectedAccount = selectedAccount;
	}

	public int getTotal() {
		return total;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	public double getOpeningAmount() {
		return openingAmount;
	}

	public void setOpeningAmount(double openingAmount) {
		this.openingAmount = openingAmount;
	}

	public double getCreditAmount() {
		return creditAmount;
	}

	public void setCreditAmount(double creditAmount) {
		this.creditAmount = creditAmount;
	}

	public double getDebitAmount() {
		return debitAmount;
	}

	public void setDebitAmount(double debitAmount) {
		this.debitAmount = debitAmount;
	}

	public double getBalance() {
		return balance;
	}

	public void setBalance(double balance) {
		this.balance = balance;
	}

	public UserInfo getSelectedUser() {
		return selectedUser;
	}

	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}

	public ArrayList<SelectItem> getSavingAccList() {
		return savingAccList;
	}

	public void setSavingAccList(ArrayList<SelectItem> savingAccList) {
		this.savingAccList = savingAccList;
	}

	public String getAccountNo() {
		return accountNo;
	}

	public void setAccountNo(String accountNo) {
		this.accountNo = accountNo;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}
}
