package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
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.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.SavingAccountInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="deleteReports")
@ViewScoped
public class deleteReportsBean implements Serializable 
{ 
	String particular,payMode,strAmount,bankName,chequeNo,name,shareHolderNo,accountNo,type,selectedReport,show;
	Date chequeDate,date,startDate,endDate;
	String showCheq,status,title;
	double amount;
	DataBaseReportMethods obj=new DataBaseReportMethods();
	ArrayList<DeleteReportInfo> list=new ArrayList<>();
	private double totalAmount;
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	public deleteReportsBean()
	{
		startDate=new Date();
		startDate.setDate(1);
		endDate=new Date();
		show="";
		
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		
		
	}
	
	public void searchReport()
	{
		
		if(branchId != 0)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			
			totalAmount=0;
			show="show";
			if(selectedReport.equals("loanpayment") || selectedReport.equals("payment_receipt"))
			{
				status="receipt_status";
			}
			else
			{
				status="status";
			}
			
			if(selectedReport.equals("income_table"))
			{
				title="Income";
			}
			else if(selectedReport.equals("expense_table"))
			{
				title="Expense";
			}
			else if(selectedReport.equals("debit_loan"))
			{
				title="Loan Disburse";
			}
			else if(selectedReport.equals("Loan EMI"))
			{
				title="loanpayment";
			}
			else if(selectedReport.equals("payment_receipt"))
			{
				title="Deposit EMI";
			}
			else if(selectedReport.equals("customer_withdrwal"))
			{
				title="Customer Withdrawl";
			}
			else if(selectedReport.equals("customer_deposit"))
			{
				title="Customer Deposit";
			}
				
			list= obj.deleteReports(branchId,conn,selectedReport,startDate,endDate,status);
			
			if(list.size()>0)
			{
				for(int i=0;i<=list.size()-1;i++)
				{
					totalAmount+=list.get(i).getAmount();
				}
				
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}

	public void print()
	{
				HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
				ss.setAttribute("deleteList", list);
				ss.setAttribute("selectedReport",selectedReport);
				ss.setAttribute("totalAmount", totalAmount);
				ss.setAttribute("title", title);
				RequestContext.getCurrentInstance().execute("window.open('printDeleteReport.xhtml')");
	}
	
	public String getParticular() {
		return particular;
	}
	
	public void setParticular(String particular) {
		this.particular = particular;
	}
	public String getPayMode() {
		return payMode;
	}
	
	public void setPayMode(String payMode) {
		this.payMode = payMode;
	}
	public String getStrAmount() {
		return strAmount;
	}
	public void setStrAmount(String strAmount) {
		this.strAmount = strAmount;
	}
	public String getBankName() {
		return bankName;
	}
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}
	public String getChequeNo() {
		return chequeNo;
	}
	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	public String getAccountNo() {
		return accountNo;
	}
	public void setAccountNo(String accountNo) {
		this.accountNo = accountNo;
	}
	public String getType() {
		return type;
	}
	public void setType(String type) {
		this.type = type;
	}
	public String getSelectedReport() {
		return selectedReport;
	}
	public void setSelectedReport(String selectedReport) {
		this.selectedReport = selectedReport;
	}
	public Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	public Date getDate() {
		return date;
	}
	public void setDate(Date date) {
		this.date = date;
	}


	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 String getShow() {
		return show;
	}


	public void setShow(String show) {
		this.show = show;
	}

	public String getShowCheq() {
		return showCheq;
	}

	public void setShowCheq(String showCheq) {
		this.showCheq = showCheq;
	}

	public ArrayList<DeleteReportInfo> getList() {
		return list;
	}

	public void setList(ArrayList<DeleteReportInfo> list) {
		this.list = list;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public double getTotalAmount() {
		return totalAmount;
	}

	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}

	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;
	}
	

	
}
