package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
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;

@ManagedBean(name="fixedAssetSale")
@ViewScoped
public class FixedAssetSaleBean implements Serializable
{
	ArrayList<FixedAssetsInfo> list;
	boolean show, showCheque;;
	FixedAssetsInfo selectedRow;
	String label,paymentMode,chequeNo,bankBranch,bankName,submittedBankName="N/A", description, returnNoOfItem,voucherNo;
	int amount, itemRate;
	Date incomeDate=new Date(),chequeDate;
	ArrayList<SelectItem> bankList;
	BankInfo bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	public FixedAssetSaleBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		list=obj.allFixedAssetsList(branchId);
		if(list.size()>0)
		{
			show=true;
		}
		else
		{
			show=false;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found!!!"));
			RequestContext.getCurrentInstance().update("form");
		}
		try {
			
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void checkPaymentMode()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(paymentMode.equals("Cash"))
		{
			showCheque=false;
		}
		
		else if(paymentMode.equals("Cheque") || paymentMode.equals("Demand Draft")|| paymentMode.equals("neft"))
		{
			bankList=new ArrayList<>();
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			if(paymentMode.equals("Cheque"))
			{
				label="Cheque";
			}
			else if(paymentMode.equals("neft"))
			{
				label="NEFT/RTGS/IMPS";
			}
			else
			{
				label="Demand Draft";
			}
			showCheque=true;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}	
	
	
	public void checkBank()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		bank_info=obj.obtainBankInfoById(bankName,conn);
		bankBranch=bank_info.getBank_branch();
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	/*	address=bank_info.address;
		accNo=bank_info.acc_no;*/
	}

	
	public void saleDetail() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		voucherNo=obj.generateVoucherNo(branchId,"income_table",conn);
		if(selectedRow.getStockBalance()>=Integer.parseInt(returnNoOfItem))
		{
			int i=new DataBaseIncomeExpense().addIncome(branchId,incomeDate,"Fixed_Asset_Cr",paymentMode,String.valueOf(amount),chequeNo,bankBranch,bankName,chequeDate,description,
					selectedRow.getName(),0,submittedBankName, returnNoOfItem,0,"","", voucherNo, selectedRow.getFaPurchaseId(), itemRate,"active",""); 
			if(i>=1)
			{
				//int j=new DataBaseMethodsIncome_Expense().updateExpenseTableStatus(selectedReturn,itemName);
				int j=1;
				if(j>=1)
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Fixed Assets Sale Successfully"));
					if(paymentMode.equals("Cash"))
					{
						obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(amount),conn);
					}
					
					printVoucherDetail();
					amount=0;description=paymentMode=chequeNo=bankBranch=bankName=label="";
					incomeDate=new Date();
					list=obj.allFixedAssetsList(branchId);
					FacesContext.getCurrentInstance().getExternalContext().redirect("fixedAssetSale.xhtml");
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured...Please Try Again!"));
				}
			    
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("You can't more than Item stock. Please Check!!!"));
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	public void calculateTotal()
	{
		amount=0;
		// System.out.println("caleed "+returnNoOfItem);
		amount=Integer.parseInt(returnNoOfItem)*itemRate;
		// System.out.println(amount);
	}
	
	public void printVoucherDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", voucherNo);
		ss.setAttribute("expDate", incomeDate);
		ss.setAttribute("amount", String.valueOf(amount));
		ss.setAttribute("type", "Credit");
		ss.setAttribute("payTo", description);
		ss.setAttribute("being", selectedRow.getName());
		ss.setAttribute("payMode", paymentMode);
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");

	}

	public ArrayList<FixedAssetsInfo> getList() {
		return list;
	}


	public void setList(ArrayList<FixedAssetsInfo> list) {
		this.list = list;
	}


	public boolean isShow() {
		return show;
	}


	public void setShow(boolean show) {
		this.show = show;
	}


	public FixedAssetsInfo getSelectedRow() {
		return selectedRow;
	}


	public void setSelectedRow(FixedAssetsInfo selectedRow) {
		this.selectedRow = selectedRow;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public String getBankBranch() {
		return bankBranch;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getReturnNoOfItem() {
		return returnNoOfItem;
	}

	public void setReturnNoOfItem(String returnNoOfItem) {
		this.returnNoOfItem = returnNoOfItem;
	}

	

	public int getItemRate() {
		return itemRate;
	}

	public void setItemRate(int itemRate) {
		this.itemRate = itemRate;
	}

	public int getAmount() {
		return amount;
	}

	public void setAmount(int amount) {
		this.amount = amount;
	}

	public Date getIncomeDate() {
		return incomeDate;
	}

	public void setIncomeDate(Date incomeDate) {
		this.incomeDate = incomeDate;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public boolean isShowCheque() {
		return showCheque;
	}

	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}

	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 BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}
	
	
}
