package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
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 org.primefaces.context.RequestContext;

@ManagedBean(name="calculateParticularDateMaturityValue")
@ViewScoped

public class CalculateParticularMaturityValueBean implements Serializable
{
	UserInfo user_info;
    Date closeDate=new Date(),newMaturityDate,chequeDate, currentDate=new Date(),instlmntDate;
    String user_no,receipt_no, chequeNo, bankName, paymentMode,strNewMaturirtyDate,status,pageName,instlmnt_no,transfer,submittedBankName, scheme,totalValGD;
    ArrayList<InstallmentInfo> list;
    List<String> nameList;
	double interest,maturity_value,amount,penalty,newMaturirtyValue,newIntrest,insAmount;
	boolean value, value1, value2,showTransfer,showTransferSelect,disableAmount;
	ArrayList<SelectItem> bankList;
	int totalPay;
	DataBaseMethods obj1=new DataBaseMethods();
	
	
	public List<String> completeUserNo(String name)
	{   
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		nameList=new DataBaseAutoCompAndDuplicate().userAccoutnNo(branchId,name,conn);

		try {
		conn.close();
		} catch (Exception e) {
		// TODO: handle exception
		}
     	return nameList;
	}

	public void userInfo() 
	{
		
		Connection conn=DataBaseConnection.JAVAConnection();
		totalPay=0;
		totalValGD="";
		if(user_no.contains("/"))
		{
			user_no=user_no.substring(0,user_no.indexOf("/"));
		}
		user_info = obj1.userInfoDuringTransaction(user_no);
		// System.out.println(user_info.getScheme_type());
		if(user_info.getScheme_type().equals("GD"))
		{
			totalValGD=obj1.calculateTotalDepositInSelectedRd1(user_no,user_info.getInterest(),user_info.getFrequency());
			String[] temp=totalValGD.split("-");
			// System.out.println(temp[1]);
			
			totalPay=Integer.valueOf(temp[0]);
			user_info.setMaturity_value(Double.valueOf(temp[1])+Double.valueOf(temp[0]));
		}
		else
		{
			totalPay=obj1.calculateTotalDepositInSelectedRd(user_no, conn);	
		}
	
        if(user_info.getFrequency()==365)
        {
        	scheme="DDS";
        }
        value = true;
        newIntrest=user_info.getInterest();
        newMaturirtyValue=0;
        strNewMaturirtyDate="";

		try {
		conn.close();
		} catch (Exception e) {
		// TODO: handle exception
		}
	}
	
/*	public String test(int x, int y,int k)
	{
		String ins_no="";
		int p=0,r=0;
		
		int q=y-x;
		if(k>0)
		{
			q=q+1;
		}
		x=x+1;
		for(p=1;p<=q;p++)
		{
			r=x++;
			if(p!=q)
			{
				ins_no=ins_no+r+",";
			}
			else
			{
				ins_no=ins_no+r;
			}
			
		}
		return ins_no;
	}
*/	
	public String calculateNewMaturity()
	{

		if(closeDate.before(user_info.getOffice_date()))
    	{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Close Date Can't Be Earlier Than First Installment Date...Please Check!"));
    	}
		else
		{
			/*for(InstallmentInfo ii : list)
	        {
	        	instlmntDate=ii.getInstlmntDate();
	        	SimpleDateFormat ins=new SimpleDateFormat("dd/MM/yyyy");
	        	String insdt=ins.format(instlmntDate);
	        	SimpleDateFormat cls=new SimpleDateFormat("dd/MM/yyyy");
	        	String clsdt=cls.format(closeDate);
	
	    		if( insdt.equals(clsdt) || instlmntDate.before(closeDate))
	            {
	            	status=ii.getStatus();
	            	if(status.equals("Due"))
	            	{
	            		f=1;
	            	}
	            }
	        }
			if(f==1)
			{
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("User Still Have Pending Installments Before Close Date... Please Check!"));
				
			}
			else
			{*/
				int month=0, diff=0;
				month=totalPay/(int)user_info.getInstallment_amount();
				diff=totalPay%(int)user_info.getInstallment_amount();
				newMaturirtyValue=obj1.findInterestForBreak(user_info.getTerms(), user_info.getInstallment_amount(),newIntrest,user_info.getScheme_type(),month, user_info.getFrequency());
	
			
				newMaturityDate=obj1.findMaturityDate(closeDate,1,0);
			    strNewMaturirtyDate=new SimpleDateFormat("dd/MM/yyyy").format(newMaturityDate);
			//}
		}
		return "";
		
	}
	
	private static int differenceInMonths(Date startDate, Date endDate) 
	{
		Calendar startCalendar = new GregorianCalendar();
		startCalendar.setTime(startDate);
		Calendar endCalendar = new GregorianCalendar();
		endCalendar.setTime(endDate);

		int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR);
		int diffMonth = diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH);
	    return diffMonth;
	}
	
	public String updateMaturity()
	{
		int i=obj1.updateMaturity(user_no, newMaturirtyValue, newIntrest,newMaturityDate);
	    if(i>=1)
	    {
	    	FacesContext fc = FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Your Scheme Is Closed Successfully. Please Go To 'Return Amount' To Pay."));	
			newIntrest=0;
	        closeDate=null;    
	        value=false;user_no="";
	        return "cashInOutFlow";
	    }
	    else
	    {
	    	FacesContext fc = FacesContext.getCurrentInstance();
	    	fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			return "";
	    }
	}
	
	public void updateNotMaturity()
	{
		RequestContext.getCurrentInstance().execute("PF('confirmInfoDialog').hide()");
		newIntrest=0;
		closeDate=null;
	}
	
	public UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public Date getCloseDate() {
		return closeDate;
	}
	public void setCloseDate(Date closeDate) {
		this.closeDate = closeDate;
	}
	public Date getNewMaturityDate() {
		return newMaturityDate;
	}
	public void setNewMaturityDate(Date newMaturityDate) {
		this.newMaturityDate = newMaturityDate;
	}
	public Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	public Date getCurrentDate() {
		return currentDate;
	}
	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}
	public String getUser_no() {
		return user_no;
	}
	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}
	public String getReceipt_no() {
		return receipt_no;
	}
	public void setReceipt_no(String receipt_no) {
		this.receipt_no = receipt_no;
	}
	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 getStrNewMaturirtyDate() {
		return strNewMaturirtyDate;
	}
	public void setStrNewMaturirtyDate(String strNewMaturirtyDate) {
		this.strNewMaturirtyDate = strNewMaturirtyDate;
	}
	public ArrayList<InstallmentInfo> getList() {
		return list;
	}
	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}
	public double getInterest() {
		return interest;
	}
	public void setInterest(double interest) {
		this.interest = interest;
	}
	public double getMaturity_value() {
		return maturity_value;
	}
	public void setMaturity_value(double maturity_value) {
		this.maturity_value = maturity_value;
	}
	public double getAmount() {
		return amount;
	}
	public void setAmount(double amount) {
		this.amount = amount;
	}
	public double getPenalty() {
		return penalty;
	}
	public void setPenalty(double penalty) {
		this.penalty = penalty;
	}
	public double getNewMaturirtyValue() {
		return newMaturirtyValue;
	}
	public void setNewMaturirtyValue(double newMaturirtyValue) {
		this.newMaturirtyValue = newMaturirtyValue;
	}
	public double getNewIntrest() {
		return newIntrest;
	}
	public void setNewIntrest(double newIntrest) {
		this.newIntrest = newIntrest;
	}
	public boolean isValue() {
		return value;
	}
	public void setValue(boolean value) {
		this.value = value;
	}
	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 Date getInstlmntDate() {
		return instlmntDate;
	}

	public void setInstlmntDate(Date instlmntDate) {
		this.instlmntDate = instlmntDate;
	}
    public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public double getInsAmount() {
		return insAmount;
	}

	public void setInsAmount(double insAmount) {
		this.insAmount = insAmount;
	}

	public String getInstlmnt_no() {
		return instlmnt_no;
	}

	public void setInstlmnt_no(String instlmnt_no) {
		this.instlmnt_no = instlmnt_no;
	}

	public String getTransfer() {
		return transfer;
	}

	public void setTransfer(String transfer) {
		this.transfer = transfer;
	}

	public boolean isDisableAmount() {
		return disableAmount;
	}

	public void setDisableAmount(boolean disableAmount) {
		this.disableAmount = disableAmount;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	public boolean isShowTransfer() {
		return showTransfer;
	}

	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}

	public boolean isShowTransferSelect() {
		return showTransferSelect;
	}

	public void setShowTransferSelect(boolean showTransferSelect) {
		this.showTransferSelect = showTransferSelect;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public String getPageName() {
		return pageName;
	}

	public void setPageName(String pageName) {
		this.pageName = pageName;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	public int getTotalPay() {
		return totalPay;
	}

	public void setTotalPay(int totalPay) {
		this.totalPay = totalPay;
	}

	public String getScheme() {
		return scheme;
	}

	public void setScheme(String scheme) {
		this.scheme = scheme;
	}
	

}
