package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

@ManagedBean(name="dailyCashDetail")
@ViewScoped
public class DailyCashDetailBean implements Serializable
{
	int totalAmount, totalNoOfNote;
	DataBaseMethods db=new DataBaseMethods();
	boolean showSubmit, showCalculate;
	double cashBalance;
	Date submitDate;
	ArrayList<DailyCashInfo> list;
	
	public DailyCashDetailBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		
		cashBalance=db.remainingCompanyCapitalAmount(branchId,conn);
		cashBalance=Double.parseDouble(new DecimalFormat("##.##").format(cashBalance));
		submitDate=new Date();
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void searchDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		list=db.viewDailyCashDetailData(submitDate,branchId);
		if(list.size()>0)
		{
			showCalculate=false;
			showSubmit=false;
			totalNoOfNote=totalAmount=0;
			for(DailyCashInfo dd: list)
			{
				totalAmount+=dd.getAmount();
				totalNoOfNote+=dd.getNoOfNote();
			}
		}
		else
		{
			totalNoOfNote=totalAmount=0;
			showCalculate=true;
			showSubmit=false;
			
			DailyCashInfo dd1=new DailyCashInfo();
			dd1.setNoteType(2000);
			list.add(dd1);
			
			DailyCashInfo dd2=new DailyCashInfo();
			dd2.setNoteType(500);
			list.add(dd2);
			
			DailyCashInfo dd3=new DailyCashInfo();
			dd3.setNoteType(200);
			list.add(dd3);
			
			DailyCashInfo dd4=new DailyCashInfo();
			dd4.setNoteType(100);
			list.add(dd4);	
			
			DailyCashInfo dd5=new DailyCashInfo();
			dd5.setNoteType(50);
			list.add(dd5);
			
			DailyCashInfo dd6=new DailyCashInfo();
			dd6.setNoteType(20);
			list.add(dd6);
			
			DailyCashInfo dd7=new DailyCashInfo();
			dd7.setNoteType(10);
			list.add(dd7);
			
			DailyCashInfo dd8=new DailyCashInfo();
			dd8.setNoteType(5);
			list.add(dd8);
			
			DailyCashInfo dd9=new DailyCashInfo();
			dd9.setNoteType(2);
			list.add(dd9);
			
			DailyCashInfo dd10=new DailyCashInfo();
			dd10.setNoteType(1);
			list.add(dd10);
		}
	}	
	
	public void calculateTotal()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		
		cashBalance=db.remainingCompanyCapitalAmount(branchId,conn);
		cashBalance=Double.parseDouble(new DecimalFormat("##.##").format(cashBalance));
		
		totalNoOfNote=totalAmount=0;
		for(int i=0;i<list.size();i++)
		{
			list.get(i).setAmount(list.get(i).getNoteType()*list.get(i).getNoOfNote());
			totalNoOfNote+=list.get(i).getNoOfNote();
			totalAmount+=list.get(i).getAmount();
		}
		
		if(totalAmount==cashBalance)
		{
			showSubmit=true;
		}
		else
		{
			showSubmit=false;
			
			RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "Cash Counting and Balance Mismatch", "Dear User, Note "
					+ "Counting Total is Wrong As per Your Cash In Hand. Your Note Counting Total Rs. is "+totalAmount +" and Company Cash Balance is : Rs. "+cashBalance+" Thanks..."));
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void submitData()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int i=db.insertDailyCashDetailData(list,branchId,submitDate);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Data Submit Sucessfully..."));
			list=new ArrayList<>();
			showCalculate=showSubmit=false;
			totalNoOfNote=totalAmount=0;
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
		}
	}
	



	public boolean isShowSubmit() {
		return showSubmit;
	}

	public void setShowSubmit(boolean showSubmit) {
		this.showSubmit = showSubmit;
	}

	public double getCashBalance() {
		return cashBalance;
	}

	public void setCashBalance(double cashBalance) {
		this.cashBalance = cashBalance;
	}

	public int getTotalAmount() {
		return totalAmount;
	}

	public void setTotalAmount(int totalAmount) {
		this.totalAmount = totalAmount;
	}

	public int getTotalNoOfNote() {
		return totalNoOfNote;
	}

	public void setTotalNoOfNote(int totalNoOfNote) {
		this.totalNoOfNote = totalNoOfNote;
	}

	public boolean isShowCalculate() {
		return showCalculate;
	}

	public void setShowCalculate(boolean showCalculate) {
		this.showCalculate = showCalculate;
	}

	
	public ArrayList<DailyCashInfo> getList() {
		return list;
	}

	public void setList(ArrayList<DailyCashInfo> list) {
		this.list = list;
	}

	public Date getSubmitDate() {
		return submitDate;
	}

	public void setSubmitDate(Date submitDate) {
		this.submitDate = submitDate;
	}
	
	
}
