package report_package;

import java.io.Serializable;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collections;
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.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.DataBaseMethodsRaviK;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.LoanInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="releaseReport")
@ViewScoped

public class LoanPaymentReleaseReportBean implements Serializable
{
	
	String userType, companyName;
	
	String loanType = "all", dsaCode, branchUserId, remark;	
	
	
	int branchId;
	
	int rowType = 2;
	
	double totalAmount;
	
	BigDecimal bigTotalAmount;
	
	Date startdate = new Date(), enddate = new Date();
	
	
	boolean show, showDsaCode;
	
	boolean disAll;
	
	boolean showCashBankAmount, showRow;
	
	
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	
	ArrayList<SelectItem> dsaList;
	
	ArrayList<LoanInfo> list;
	
	LoanInfo selectedEntry;
	
	
	DataBaseReportMethods obj1 = new DataBaseReportMethods();
	DataBaseMethods obj = new DataBaseMethods();
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();
	DataBaseMethodTaheer dbt = new DataBaseMethodTaheer();	
	DataBaseMethodsRaviK dbmr = new DataBaseMethodsRaviK();
	
	
	
	public LoanPaymentReleaseReportBean() 
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,conn);
		userType = (String) ss.getAttribute("type");
		
		
		companyName = dbt.companyNameByBranchId(branchId);
	    System.out.println("noob : " + companyName);
		
		disAll = dbmh.disAllByCompanyNameUserType(userType, companyName);
		
		startdate.setDate(1);
		
		try 
		{
			conn.close();
		}
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		
		if ("FINAZONE MICRO SERVICES FOUNDATION".equalsIgnoreCase(companyName) || 
			"GKFC MICROSERVICES FOUNDATION".equalsIgnoreCase(companyName)) 
		{
			showRow = true;
		}
		else 
		{
			showRow = false;
		}
		
		loanWiseReport();
	}
	
	
	
	public void checkDsa()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		dsaList = obj.allDsaList(branchId,"Loan",conn);
		
		try 
		{
			conn.close();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public void checkLoanType()
	{
		if(loanType.equalsIgnoreCase("all"))
		{
			showDsaCode = false;
		}
		else
		{
			showDsaCode = true;
			Connection conn = DataBaseConnection.JAVAConnection();
			dsaList = obj.allDsaList(branchId, "Loan", conn);
			
			try 
			{
				conn.close();
			} 
			catch (SQLException e) 
			{
				e.printStackTrace();
			}
		}
	}
	
	
	public void loanWiseReport()
	{
	
		Connection conn = DataBaseConnection.JAVAConnection();
		list = new ArrayList<>();
		totalAmount = 0;
		
		if (("FINAZONE MICRO SERVICES FOUNDATION".equalsIgnoreCase(companyName) || 
				"GKFC MICROSERVICES FOUNDATION".equalsIgnoreCase(companyName)) && rowType == 1) 
		{
			showCashBankAmount = true;
			list = dbt.debitLoanList(branchId, loanType, new java.sql.Date(startdate.getTime()), 
									 new java.sql.Date(enddate.getTime()), dsaCode, conn);
		}
		else 
		{
			showCashBankAmount = false;
			list = obj1.debitLoanList(branchId,loanType, startdate, enddate, dsaCode,conn);
		}
		
		for(LoanInfo ll : list)
		{
			
			String fileCharge = obj.fileChargeByLoanNo(ll.getLoanNo(), conn);
		    ll.setFileCharge(fileCharge);
			
			totalAmount += Double.valueOf(ll.getLoanAmount());
			bigTotalAmount = new BigDecimal(totalAmount);
		}
		
		if(list.size() > 0)
		{
			show = true;
			Collections.sort(list);
		}
		else
		{
			show = false;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found."));
		}
		
		int k = 1;
		for(LoanInfo ll : list)
		{
			ll.setSno(k++);
		}
	}
	
	
	
	public void print()
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("list", list);
		ss.setAttribute("amount", totalAmount);
		ss.setAttribute("size", list.size());
		
		RequestContext.getCurrentInstance().execute("window.open('printReleasedLoanReport.xhtml')");
	}
	
	
	
	public void delete()
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn = DataBaseConnection.JAVAConnection();
		String savingAccountNo = obj.savingAccountByShareHolderNo(selectedEntry.getShareHolderNo());
		double preAmount = obj.acconuntHolderAmountByAccountNo(savingAccountNo);
		
		double amount = Double.valueOf(selectedEntry.getLoanAmount());
		String bankid = selectedEntry.getBankId();
		
		int flag = 1;
		if(selectedEntry.getMode().equalsIgnoreCase("transfer"))
		{
			if(Double.valueOf(selectedEntry.getLoanAmount()) > preAmount)
			{
				flag = 0;
				RequestContext.getCurrentInstance().showMessageInDialog(
						new FacesMessage(FacesMessage.SEVERITY_INFO, "Saving Account Balance Alert???", 
						  "Dear User, Saving Account doesn't have Enough Balance. Saving Account Balance is Only Rs. " + preAmount));
			}
		}
		
		if(flag == 1)
		{
			int i = obj1.deleteDebitLoanEntry(selectedEntry.getId(),remark);
			if(i >= 1)
			{
				if(selectedEntry.getMode().equalsIgnoreCase("cash"))
				{
					obj.decreaseSharedCompanyAmount(branchId, amount);
					fileChargeAndInsuranceFee(conn);
					processingCharge(conn);
					stampFeeAndLoanPayment(conn);
				}
				else if(selectedEntry.getMode().equalsIgnoreCase("transfer"))
				{
					int	n = obj.userWithdrwal(branchId, savingAccountNo, String.valueOf(amount), selectedEntry.getRequestDate(),
							"Transfer", "", null, "N/A", "", "approved", "Transacion Revert into Loan Account","");
					if (n >= 1) 
					{
						Double newAmount = preAmount - amount;
						obj.updateSavingAmountByAccountNo(savingAccountNo, newAmount);
					}
				}
				else
				{
					obj.increaseBankBalance(bankid, amount, conn);
				}
				
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Enrty Deleted Successfully"));
//				RequestContext.getCurrentInstance().showMessageInDialog(
//							new FacesMessage(FacesMessage.SEVERITY_INFO, "Confirmation????", 
//									"Dear User, Please Delete All Entries Related to This Loan No. "+selectedEntry.getLoanNo()));
				
				list = obj1.debitLoanList(branchId,loanType, startdate, enddate,dsaCode,conn);
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured.Please Check!"));
			}
		}

		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	private void fileChargeAndInsuranceFee(Connection conn) 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		LoanInfo loan_info = obj.loanInfoByLoanNoLoanType(selectedEntry.getLoanNo(), selectedEntry.getLoanType(), conn);
		FacesContext fc = FacesContext.getCurrentInstance();
		
		
		String fcStatus = obj.checkSettingFromMasterSettingNewTable("File Charge", conn);
		if(fcStatus.equalsIgnoreCase("loan_disburse"))
		{
			int z = obj.updateIncomeTableSelectedActiveEntryStatus("File Charge", "pending", selectedEntry.getLoanNo(), conn, null);
			if(z > 0)
			{
				if(Double.valueOf(loan_info.getFileCharge()) > 0)
				{
					obj.decreaseCapitalCompanyAmount(branchId, Double.valueOf(loan_info.getFileCharge()));
					fc.addMessage(null, new FacesMessage("File Charge " + loan_info.getFileCharge() + " Rs. Revert Sucessfully."));
				}
			}
		}	
		
		// Insurance Fee Amount Add on Loan Approval
		String insFeeStatus = obj.checkSettingFromMasterSettingNewTable("Insurance Fee", conn);
		if(insFeeStatus.equalsIgnoreCase("loan_disburse"))
		{
			int z = obj.updateIncomeTableSelectedActiveEntryStatus("Insurance Fee", "pending", selectedEntry.getLoanNo(), conn, null);
			if(z > 0)
			{
				if(Double.valueOf(loan_info.getInsuranceFee()) > 0)
				{
					obj.decreaseCapitalCompanyAmount(branchId, Double.valueOf(loan_info.getInsuranceFee()));
					fc.addMessage(null, new FacesMessage("Insurance Fee " + loan_info.getInsuranceFee()+" Rs. Revert Sucessfully."));
				}
			}
		}	
	}
	
	private void processingCharge(Connection conn) 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		LoanInfo loan_info = obj.loanInfoByLoanNoLoanType(selectedEntry.getLoanNo(), selectedEntry.getLoanType(), conn);
		FacesContext fc = FacesContext.getCurrentInstance();
		
		String pcStatus = obj.checkSettingFromMasterSettingNewTable("Processing Charge", conn);
		if(pcStatus.equalsIgnoreCase("loan_disburse"))
		{
			int z = obj.updateIncomeTableSelectedActiveEntryStatus("Processing Charge", "pending", selectedEntry.getLoanNo(), conn, null);
			if(z > 0)
			{
				if(Double.valueOf(loan_info.getProcessingCharge()) > 0)
				{
					obj.decreaseCapitalCompanyAmount(branchId, Double.valueOf(loan_info.getProcessingCharge()));
					fc.addMessage(null, new FacesMessage("Processing Charge " + loan_info.getProcessingCharge() + " Rs. Revert Sucessfully."));
				}
			}
		}	
	}
	
	private void stampFeeAndLoanPayment(Connection conn)
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		LoanInfo loan_info = obj.loanInfoByLoanNoLoanType(selectedEntry.getLoanNo(), selectedEntry.getLoanType(), conn);
		FacesContext fc = FacesContext.getCurrentInstance();
		
		String fcStatus = obj.checkSettingFromMasterSettingNewTable("Stamp Fee", conn);
		if(fcStatus.equalsIgnoreCase("loan_disburse"))
		{
			int z = obj.updateIncomeTableSelectedActiveEntryStatus("Stamp Fee", "pending", selectedEntry.getLoanNo(), conn, null);
			if(z > 0)
			{
				System.out.println(loan_info.getStamp());
				
				if(loan_info.getStamp() > 0)
				{
					obj.decreaseCapitalCompanyAmount(branchId, loan_info.getStamp());
					fc.addMessage(null, new FacesMessage("Stamp Fee " + loan_info.getStamp() + " Rs. Revert Sucessfully."));
				}
			}
		}			
	}
	
	
	
	public void updateDisbursalDate()
	{   
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn = DataBaseConnection.JAVAConnection();

		try{
			int i = dbmr.updateDisbursalDateByLoanNo(selectedEntry.getLoanNo(),selectedEntry.getRequestDate(),selectedEntry.getUmrnNo(),conn);

			if(i > 0)
			{
				FacesContext.getCurrentInstance().addMessage(null,
						new FacesMessage(FacesMessage.SEVERITY_INFO,"Success","Disbursal Date Updated Successfully"));

				//list = obj1.debitLoanList(branchId, loanType, startdate, enddate, dsaCode, conn);
				  loanWiseReport();
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null,
						new FacesMessage(FacesMessage.SEVERITY_ERROR,"Error","Loan No Not Found"));
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				conn.close();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
		}
	}

	
	
	public ArrayList<LoanInfo> getList() {
		return list;
	}
	public void setList(ArrayList<LoanInfo> list) {
		this.list = list;
	}
	public double getTotalAmount() {
		return totalAmount;
	}
	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}
	public LoanInfo getSelectedEntry() {
		return selectedEntry;
	}
	public void setSelectedEntry(LoanInfo selectedEntry) {
		this.selectedEntry = selectedEntry;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	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 isShowDsaCode() {
		return showDsaCode;
	}

	public void setShowDsaCode(boolean showDsaCode) {
		this.showDsaCode = showDsaCode;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public String getBranchUserId() {
		return branchUserId;
	}

	public void setBranchUserId(String branchUserId) {
		this.branchUserId = branchUserId;
	}

	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;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public BigDecimal getBigTotalAmount() {
		return bigTotalAmount;
	}

	public void setBigTotalAmount(BigDecimal bigTotalAmount) {
		this.bigTotalAmount = bigTotalAmount;
	}

	public boolean isDisAll() {
		return disAll;
	}

	public void setDisAll(boolean disAll) {
		this.disAll = disAll;
	}

	public String getUserType() {
		return userType;
	}

	public void setUserType(String userType) {
		this.userType = userType;
	}



	public boolean isShowCashBankAmount() {
		return showCashBankAmount;
	}



	public void setShowCashBankAmount(boolean showCashBankAmount) {
		this.showCashBankAmount = showCashBankAmount;
	}



	public int getRowType() {
		return rowType;
	}



	public void setRowType(int rowType) {
		this.rowType = rowType;
	}



	public boolean isShowRow() {
		return showRow;
	}



	public void setShowRow(boolean showRow) {
		this.showRow = showRow;
	}
		
}