package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
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.servlet.http.HttpSession;

import main_package.CenterInfo;
import main_package.DataBaseAutoCompAndDuplicate;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.HeaderBean;
import main_package.InstallmentInfo;
import main_package.LoanInfo;
import main_package.UserInfo;

@ManagedBean(name="centerCard")
@ViewScoped
public class CenterCardBean implements Serializable
{
	String loanNo,user_no,loanType,searchType, cardType, applicantPhoto,qrPhoto, disburseDateStr;
	List<String> nameList, rdNameList;
	ArrayList<LoanInfo> loanEMIList, blankList;
	UserInfo user_info, rdInfo;
	LoanInfo loan_info;
	DataBaseMethods obj=new DataBaseMethods();
	DecimalFormat dc=new DecimalFormat("##.##");
	boolean showTable, showTableRd, showTableLoan;
	ArrayList<InstallmentInfo> list;
	boolean showLoan, showRd, showFiled, showColumn, showGoldenRdBtn, showSecondCompany;
	CenterInfo selectedCenter;
	double preEmiCharge;
	
	public void checkCardType()
	{
		showTable=false;
		list=new ArrayList<>();loanEMIList=new ArrayList<>();
		user_info=new UserInfo();
		loan_info=new LoanInfo();
		showFiled=true;
		user_no=loanNo=""; 
		
		if(cardType.contains("loan"))
		{
			showLoan=true;
			showRd=false;
			loanType=cardType;
		}
		else if(cardType.equalsIgnoreCase("RD") || cardType.equalsIgnoreCase("DD"))
		{
			showLoan=false;
			showRd=true;
			searchType=cardType;
		}
		else if(cardType.equalsIgnoreCase("centergl"))
		{
			showLoan=true;
			showRd=true;
			loanType="grouploan";
			searchType="RD";
		}
		
		else if(cardType.equalsIgnoreCase("centerpl"))
		{
			showLoan=true;
			showRd=true;
			loanType="personalloan";
			searchType="RD";
		}
		
		if(loanType!=null && loanType.contains("loan"))
		{
			showColumn=true;
		}
		else
		{
			showColumn=false;
		}
	}
	
	public void centerCardDetail()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		blankList=new ArrayList<>();
		for(int i=1;i<=24;i++)
		{
			LoanInfo ll=new LoanInfo();
			
			ll.setSno(i);
			
			blankList.add(ll);
		}
		
		Connection conn=DataBaseConnection.JAVAConnection();
		
		qrPhoto=obj.qrCodeScanImage(branchId);
		showTable=true;
		if(loanNo.contains("/"))
		{
			loanNo=loanNo.substring(0,loanNo.indexOf("/"));
		}
		
		if(loanType!=null)
		{
			user_info=obj.userInfoByLoanNoLoanType(loanNo,loanType,conn);
			loan_info=obj.loanInfoByLoanNoLoanType(loanNo,loanType, conn);
			loanEMIList=obj.loanInstallment(loanType,loanNo, conn);
		}
		
		selectedCenter=obj.selectedCenterInfo(loan_info.getCenter());
//		if(selectedCenter.getCenterLeaderName()==null || selectedCenter.getCenterLeaderName().equalsIgnoreCase(""))
//		{
//			loan_info.setGroupLeaderName(selectedCenter.getCenterLeaderName());
//		}

		// RD Detail
		if(user_no.contains("/"))
		{
			user_no=user_no.substring(0,user_no.indexOf("/"));
		}
		
		rdInfo = obj.userInfoDuringTransaction(user_no);
		list=obj.showInstallment(user_no,conn);
		/*if(list.size()>0)
		{
			for(InstallmentInfo ii: list)
			{
				System.out.println("==========="+ii.getIns_date());
				System.out.println("amt: "+ii.getInstallment_amount());
			}
		}*/
		
		if(cardType.equalsIgnoreCase("centergl") || cardType.contains("centerpl") || cardType.contains("loan"))
		{
			showTableLoan=true;
			showTableRd=false;
			for(int i=0;i<loanEMIList.size();i++)
			{
				if(list.size()>0)
				{
					for(int j=0;j<list.size();j++)
					{
						if(loanEMIList.get(i).getStrInstlmntDate().equals(list.get(j).getIns_date()))
						{
							loanEMIList.get(i).setAmount(list.get(j).getInstallment_amount());
							loanEMIList.get(i).setTotalAmount(loanEMIList.get(i).getInstallAmount()+loanEMIList.get(i).getAmount());
						}
					}
				}
				else
				{
					loanEMIList.get(i).setTotalAmount(loanEMIList.get(i).getInstallAmount());
				}
			}
			
			
			// Work For Saving Amount
			if(loan_info==null)
			{
				
			}
			else
			{
				if(loan_info.getExtraAmt()>0)
				{
					for(int i=0;i<loanEMIList.size();i++)
					{
						loanEMIList.get(i).setInstallAmount(loanEMIList.get(i).getInstallAmount()+loan_info.getExtraAmt());
						loanEMIList.get(i).setTotalAmount(loanEMIList.get(i).getInstallAmount());
					}
				}
			}
			Date disburseDate=obj.loanDisburseDateByLoanNo(loanNo, conn);
			if(disburseDate!=null)
			{
				disburseDateStr=new SimpleDateFormat("dd/MM/yyyy").format(disburseDate);
			}
		}
		else
		{
			showTableLoan=false;
			showTableRd=true;
		}
		
		HeaderBean hh=new HeaderBean();
		showGoldenRdBtn=false;
		if(hh.getName().equalsIgnoreCase("DEVKRIPA MICROFINANCE FOUNDATION"))
		{
			showSecondCompany=true;
			if(showTableRd==true)
			{
				showGoldenRdBtn=true;
			}
		}
		else
		{
			showSecondCompany=false;
		}
		
		if(user_info!=null)
		{
			applicantPhoto=obj.applicantPhotoByShareHolderNo(user_info.getShareHolderNo(), conn);
		}
		
		preEmiCharge=obj.preEmiChargeCalculationMethod(loanNo, loanType, conn);
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
	public List<String> completeLoanNo(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		if(loanType!=null)
		{
			nameList=new DataBaseAutoCompAndDuplicate().showLoanNoByLoanTypeForApp(branchId,name,loanType, obj.userId());
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null,new FacesMessage("Please Select Loan Type First"));
		}
		return nameList;
	}
	
	public List<String> completeUserNo(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		rdNameList=new DataBaseAutoCompAndDuplicate().userAccoutnNoFrequencyWise(branchId,name,searchType, "");
     	return rdNameList;
	}
	

	public String getLoanNo() {
		return loanNo;
	}

	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}

	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	public ArrayList<LoanInfo> getLoanEMIList() {
		return loanEMIList;
	}

	public void setLoanEMIList(ArrayList<LoanInfo> loanEMIList) {
		this.loanEMIList = loanEMIList;
	}

	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	public LoanInfo getLoan_info() {
		return loan_info;
	}

	public void setLoan_info(LoanInfo loan_info) {
		this.loan_info = loan_info;
	}

	public boolean isShowTable() {
		return showTable;
	}

	public void setShowTable(boolean showTable) {
		this.showTable = showTable;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}

	public List<String> getRdNameList() {
		return rdNameList;
	}

	public void setRdNameList(List<String> rdNameList) {
		this.rdNameList = rdNameList;
	}

	public String getUser_no() {
		return user_no;
	}

	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}

	public String getCardType() {
		return cardType;
	}

	public void setCardType(String cardType) {
		this.cardType = cardType;
	}

	public boolean isShowLoan() {
		return showLoan;
	}

	public void setShowLoan(boolean showLoan) {
		this.showLoan = showLoan;
	}

	public boolean isShowRd() {
		return showRd;
	}

	public void setShowRd(boolean showRd) {
		this.showRd = showRd;
	}

	public boolean isShowFiled() {
		return showFiled;
	}

	public void setShowFiled(boolean showFiled) {
		this.showFiled = showFiled;
	}

	public ArrayList<InstallmentInfo> getList() {
		return list;
	}

	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}

	public boolean isShowTableRd() {
		return showTableRd;
	}

	public void setShowTableRd(boolean showTableRd) {
		this.showTableRd = showTableRd;
	}

	public boolean isShowTableLoan() {
		return showTableLoan;
	}

	public void setShowTableLoan(boolean showTableLoan) {
		this.showTableLoan = showTableLoan;
	}

	public UserInfo getRdInfo() {
		return rdInfo;
	}

	public void setRdInfo(UserInfo rdInfo) {
		this.rdInfo = rdInfo;
	}

	public boolean isShowColumn() {
		return showColumn;
	}

	public void setShowColumn(boolean showColumn) {
		this.showColumn = showColumn;
	}

	public String getApplicantPhoto() {
		return applicantPhoto;
	}

	public void setApplicantPhoto(String applicantPhoto) {
		this.applicantPhoto = applicantPhoto;
	}

	public String getQrPhoto() {
		return qrPhoto;
	}

	public void setQrPhoto(String qrPhoto) {
		this.qrPhoto = qrPhoto;
	}

	public ArrayList<LoanInfo> getBlankList() {
		return blankList;
	}

	public void setBlankList(ArrayList<LoanInfo> blankList) {
		this.blankList = blankList;
	}

	public boolean isShowGoldenRdBtn() {
		return showGoldenRdBtn;
	}

	public void setShowGoldenRdBtn(boolean showGoldenRdBtn) {
		this.showGoldenRdBtn = showGoldenRdBtn;
	}

	public boolean isShowSecondCompany() {
		return showSecondCompany;
	}

	public void setShowSecondCompany(boolean showSecondCompany) {
		this.showSecondCompany = showSecondCompany;
	}

	public CenterInfo getSelectedCenter() {
		return selectedCenter;
	}

	public void setSelectedCenter(CenterInfo selectedCenter) {
		this.selectedCenter = selectedCenter;
	}

	public String getDisburseDateStr() {
		return disburseDateStr;
	}

	public void setDisburseDateStr(String disburseDateStr) {
		this.disburseDateStr = disburseDateStr;
	}

	public double getPreEmiCharge() {
		return preEmiCharge;
	}

	public void setPreEmiCharge(double preEmiCharge) {
		this.preEmiCharge = preEmiCharge;
	}



}
