package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

@ManagedBean(name="viewLoanEmi")
@ViewScoped
public class ViewLoanEmiBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	String loanNo,loanType;
	UserInfo user_info;
	LoanInfo loan_info;
	boolean show, showMemberTable;
	public static List<String> list;
	ArrayList<LoanInfo> listt;
	ArrayList<SelectItem> loanTypeList;
	ArrayList<LoanInfo> grpLoanMemberList;
	LoanInfo selectedMember;
	DataBaseMethods dbm=new DataBaseMethods();
	
	public ViewLoanEmiBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		loanTypeList=dbm.loanTypeList(conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void searchData()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(loanType.equals("grouploan"))
		{
			loanNo=loanNo.substring(0,loanNo.indexOf("/"));
			grpLoanMemberList=dbm.loanListInGroupLoan(loanNo,conn);
			showMemberTable=true;
			show=false;
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		else
		{
			showMemberTable=false;
			showEmi();
		}
	}
	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().showLoanNoByLoanType(branchId,name,loanType);
     	return list;
	}
	
	public void clearForm()
	{
		show=false;loanNo="";
	}
	
	public void commonMethod()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		loanNo=selectedMember.getSubLoanNo();
		user_info=dbm.userInfoByLoanNoLoanType(loanNo,loanType, conn);
		loan_info=dbm.loanInfoByLoanNoLoanType(loanNo,loanType, conn);
		if(user_info!=null)
		{
			show=true;
		}
		else
		{
			show=false;
		}
		
		listt=dbm.loanInstallment(loanType,loanNo, conn);
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void showEmi()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		loanNo=loanNo.substring(0,loanNo.indexOf("/"));
		/*if(list.contains(loanNo))
		{*/
			user_info=dbm.userInfoByLoanNoLoanType(loanNo,loanType,conn);
			loan_info=dbm.loanInfoByLoanNoLoanType(loanNo,loanType,conn);
			if(user_info!=null)
			{
				show=true;
			}
			else
			{
				show=false;
			}
			
			listt=dbm.loanInstallment(loanType,loanNo, conn);
			/*double trms=Double.parseDouble(loan_info.getLoanTerm());
			listt=new ArrayList<LoanInfo>();
			int i=1;
			double x=0;
	         
			int j=0;
			String frq=loan_info.getFrequency();
			if(frq=="Daily")
			{
				j=1;
			}
			else if(frq=="1 week")
			{
				j=7;
			}
			else if(frq=="2 week")
			{
				j=14;
			}
			else if(frq=="4 week")
			{
				j=28;
			}
			
			for(x=1;x<=trms;x++)
			{
				LoanInfo ll=new LoanInfo();
				ll.setSno(i);
				if(x==trms)
				{
					/*emi=emi-discount;
					ll.setInstallAmount(emi);
					ll.setInstallAmount(loan_info.getInstallAmount()-loan_info.getDiscount());
				}
				else
				{
					ll.setInstallAmount(loan_info.getInstallAmount());
				}
				
				Date dt=loan_info.getApprovalDate();
				dt.setDate(dt.getDate()+j);
				ll.setStrInstlmntDate(new SimpleDateFormat("dd/MM/yyyy").format(dt));
				i++;
			   listt.add(ll);
			}
		/*}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("LoanNo is not Valid"));
		}*/
	}

	public ArrayList<SelectItem> getLoanTypeList() {
		return loanTypeList;
	}

	public void setLoanTypeList(ArrayList<SelectItem> loanTypeList) {
		this.loanTypeList = loanTypeList;
	}
	
	public LoanInfo getLoan_info() {
		return loan_info;
	}
	public void setLoan_info(LoanInfo loan_info) {
		this.loan_info = loan_info;
	}
	public UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public String getLoanNo() {
		return loanNo;
	}
	public String getLoanType() {
		return loanType;
	}
	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}
	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}
	public ArrayList<LoanInfo> getListt() {
		return listt;
	}
	public void setListt(ArrayList<LoanInfo> listt) {
		this.listt = listt;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}

	public boolean isShowMemberTable() {
		return showMemberTable;
	}

	public void setShowMemberTable(boolean showMemberTable) {
		this.showMemberTable = showMemberTable;
	}

	public ArrayList<LoanInfo> getGrpLoanMemberList() {
		return grpLoanMemberList;
	}

	public void setGrpLoanMemberList(ArrayList<LoanInfo> grpLoanMemberList) {
		this.grpLoanMemberList = grpLoanMemberList;
	}

	public LoanInfo getSelectedMember() {
		return selectedMember;
	}

	public void setSelectedMember(LoanInfo selectedMember) {
		this.selectedMember = selectedMember;
	}
	
}
