package group_head_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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 org.primefaces.context.RequestContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;

@ManagedBean(name="manageJournalEntry")
@ViewScoped
public class ManageJournalEntryBean implements Serializable
{
	Date bookDate=new Date(), paidDate=new Date(), chequeDate;
	String transType, ledgerName, remark, label, voucherNo;
	double amount, debitAmount, creditAmount, libAmount, assetsAmount;
	ArrayList<JournalInfo> jList;
	ArrayList<SelectItem> ledgerList, bankList;
	JournalInfo selectedRow;
	boolean value1, value2;
	String chequeNo, bankName, paymentMode,submittedBankName="N/A";
	DataBaseMethods dbm=new DataBaseMethods();
	
	public ManageJournalEntryBean() 
	{
		Connection con=DataBaseConnection.JAVAConnection();
		bankList=new DataBaseIncomeExpense().allBankList(con);
		viewData();
		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	private void viewData() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		jList=dbm.viewJournalEntry(branchId);
		debitAmount=creditAmount=0;
		if(jList.size()>0)
		{
			for(JournalInfo jj: jList)
			{
				if(jj.getTransType().equalsIgnoreCase("debit"))
				{
					debitAmount+=jj.getAmount();
				}
				else
				{
					creditAmount+=jj.getAmount();
				}
			}
		}
	}

	public void createLedgerList()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(transType.equalsIgnoreCase("Debit"))
		{
			ledgerList=dbm.groupHeadSelectList(conn, "Expense");
		}
		else if(transType.equalsIgnoreCase("Credit"))
		{
			ledgerList=dbm.groupHeadSelectList(conn, "Income");
		}
		else if(transType.equalsIgnoreCase("Liability"))
		{
			ledgerList=dbm.groupHeadSelectList(conn, "Liability");
		}
		else if(transType.equalsIgnoreCase("Assets"))
		{
			ledgerList=dbm.groupHeadSelectList(conn, "Assets");
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void insertEntry()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		int i=dbm.insertJournalEntry(branchId,bookDate, transType, ledgerName, amount, remark);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Data Insert Sucessfully..."));
			transType=ledgerName=remark="";
			amount=0;
			viewData();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error in Data Insertion !!!"));
		}
	}
	
	public void deleteEntry()
	{
		int i=dbm.deleteJournalEntry(selectedRow.getId());
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Data Delete Sucessfully..."));
			viewData();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error in Data Deletion !!!"));
		}
	}
	
	public void clearEntry()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		if(selectedRow.getTransType().equalsIgnoreCase("Debit") || selectedRow.getTransType().equalsIgnoreCase("Liability"))
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			String cat="";
			if(selectedRow.getTransType().equalsIgnoreCase("Liability"))
			{
				cat="Liability_Dr";
			}
			else
			{
				cat="Other_Dr";
			}
			
			if(paymentMode.equalsIgnoreCase("cash"))
			{
				submittedBankName="N/A";
			}
			
			voucherNo=dbm.generateVoucherNo(branchId,"expense_table",conn);
			int x=new DataBaseIncomeExpense().addExpense(branchId,paidDate,cat,paymentMode,String.valueOf(selectedRow.getAmount()),chequeNo,"",submittedBankName,chequeDate,
					selectedRow.getRemark(),selectedRow.getLedgerName(), "", voucherNo, 0,"0","",""); 
			if(x>=1)
			{
			    FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Transaction Done Successfully..."));
			    if(paymentMode.equalsIgnoreCase("Cash"))
			    {
			    	dbm.increaseSharedCompanyAmount(branchId,Double.valueOf(selectedRow.getAmount()),conn);
			    }
			    dbm.updateJournalEntryStatus(selectedRow.getId(), paidDate, conn);
			    viewData();
			   printVoucherDetail();
			}  
			
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Work in Progress!!!"));
		}
	}
	
	public void printVoucherDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", voucherNo);
		ss.setAttribute("expDate", paidDate);
		ss.setAttribute("amount", String.valueOf(selectedRow.getAmount()));
		ss.setAttribute("vchtype", "Debit");
		ss.setAttribute("payTo", selectedRow.getRemark());
		ss.setAttribute("being", selectedRow.getLedgerName());
		ss.setAttribute("payMode", paymentMode);
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}
	
	public void forPaymentMode()
	{
		//// System.out.println(paymentMode);
		if (paymentMode.equalsIgnoreCase("0")) 
		{
			value1 = value2= false;
		}
		else if(paymentMode.equalsIgnoreCase("Cash")) 
		{
			value1 = true;
			value2 = false;
			bankName=chequeNo="";
			chequeDate=null;
		}
		else
		{
			label=paymentMode;
			value2 = true;
			value1 = false;
			bankName=chequeNo="";
			chequeDate=null;
		}
	}
	
	
	
	public Date getBookDate() {
		return bookDate;
	}
	public void setBookDate(Date bookDate) {
		this.bookDate = bookDate;
	}
	public String getTransType() {
		return transType;
	}
	public void setTransType(String transType) {
		this.transType = transType;
	}
	public String getLedgerName() {
		return ledgerName;
	}
	public void setLedgerName(String ledgerName) {
		this.ledgerName = ledgerName;
	}
	public String getRemark() {
		return remark;
	}
	public void setRemark(String remark) {
		this.remark = remark;
	}
	public double getAmount() {
		return amount;
	}
	public void setAmount(double amount) {
		this.amount = amount;
	}

	public ArrayList<JournalInfo> getjList() {
		return jList;
	}

	public void setjList(ArrayList<JournalInfo> jList) {
		this.jList = jList;
	}

	public JournalInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(JournalInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	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 ArrayList<SelectItem> getLedgerList() {
		return ledgerList;
	}

	public void setLedgerList(ArrayList<SelectItem> ledgerList) {
		this.ledgerList = ledgerList;
	}

	public Date getPaidDate() {
		return paidDate;
	}

	public void setPaidDate(Date paidDate) {
		this.paidDate = paidDate;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getVoucherNo() {
		return voucherNo;
	}

	public void setVoucherNo(String voucherNo) {
		this.voucherNo = voucherNo;
	}

	public double getLibAmount() {
		return libAmount;
	}

	public void setLibAmount(double libAmount) {
		this.libAmount = libAmount;
	}

	public double getAssetsAmount() {
		return assetsAmount;
	}

	public void setAssetsAmount(double assetsAmount) {
		this.assetsAmount = assetsAmount;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public boolean isValue1() {
		return value1;
	}

	public void setValue1(boolean value1) {
		this.value1 = value1;
	}

	public boolean isValue2() {
		return value2;
	}

	public void setValue2(boolean value2) {
		this.value2 = value2;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	public DataBaseMethods getDbm() {
		return dbm;
	}

	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}
	
	
}
