package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
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="closePlan")
@ViewScoped

public class CloseSchemePageBean 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;
    ArrayList<InstallmentInfo> list;
    List<String> nameList;
	double interest,maturity_value,amount,penalty,newMaturirtyValue,newIntrest,insAmount;
	boolean value, value1, value2,showTransfer,showTransferSelect,disableAmount, disCloseBtn;
	ArrayList<SelectItem> bankList;
	int totalPay;
	DataBaseMethods db=new DataBaseMethods();
	 ArrayList<InstallmentInfo> rdPayList;
	
	public CloseSchemePageBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		user_no=(String) ss.getAttribute("userNo");
		// // System.out.println("close page: "+user_no);
		
		if(user_no==null || user_no.equals(""))
		{
			
		}
		else
		{
			userInfo();
		}
		
		  
	}
	
	public void checkPaidDetail()
	{
		
		rdPayList=db.checkRdFdPaidDetailByUserNo(user_info.getUser_no());
	}
	
	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;
		if(user_no.contains("/"))
		{
			user_no=user_no.substring(0,user_no.indexOf("/"));
		}
		 
		String a=db.statusOfOdLoanByUserNo(user_no);
         if(a.equalsIgnoreCase("active"))
         {
      	   disCloseBtn=true;
         }
         else
         {
        	 disCloseBtn=false;
         }
         
		user_info = db.userInfoDuringTransaction(user_no);
		totalPay=db.calculateTotalDepositInSelectedRd(user_no, conn);
        scheme=user_info.getScheme_type();
        value = true;
        newIntrest=user_info.getInterest();
        
        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 void calculateNewMaturity()
	{
		
		//int f=0;
		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
		{
			if(newMaturirtyValue==0)  // condtion for manual new maturity amount 26-06-2019 for Kalp
			{
				/*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;
					/*if(totalPay>0)
					{
						month=totalPay/(int)user_info.getInstallment_amount();
						diff=totalPay%(int)user_info.getInstallment_amount();
					}*/
					// // System.out.println("hello diff: "+diff);
					/*if(user_info.getFrequency()==365)
					{
						month=totalPay/(int)user_info.getInstallment_amount();
						diff=totalPay%(int)user_info.getInstallment_amount();
					}
					else
					{
						month=differenceInMonths(user_info.getOffice_date(),closeDate);
					}*/
					
					if(user_info.getScheme_type().equalsIgnoreCase("FD"))
					{
						month=differenceInMonthsForBreak(user_info.getOffice_date(),closeDate);
					}
					else
					{
						month=totalPay/(int)user_info.getInstallment_amount();
						diff=totalPay%(int)user_info.getInstallment_amount();
					}
					
					
					if(month>0)
					{
						newMaturirtyValue=db.findInterestForBreak(user_info.getTerms(), user_info.getInstallment_amount(),newIntrest,user_info.getScheme_type(),month, user_info.getFrequency());
					}
					
					newMaturirtyValue+=diff;
					newMaturirtyValue=Double.parseDouble(new DecimalFormat("##.##").format(newMaturirtyValue));
					newMaturirtyValue= Math.round(newMaturirtyValue);
				
				  
				//}
			}
			newMaturityDate=db.findMaturityDate(closeDate,1,0);
		    strNewMaturirtyDate=new SimpleDateFormat("dd/MM/yyyy").format(newMaturityDate);
			  RequestContext.getCurrentInstance().execute("PF('maturityInfoDialog').hide()");
			    RequestContext.getCurrentInstance().execute("PF('confirmInfoDialog').show()");
		}
	}
	
	private static int differenceInMonthsForBreak(Date startDate, Date endDate) 
	{
		int days = (int) ((endDate.getTime() - startDate.getTime()) / (1000 * 60 * 60 * 24));
		int diffMonth =Math.round(days/30);
	    return diffMonth;
	}
	
	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 void checkMaturityValue()
	{
		if(newIntrest>0)
		{
			newMaturirtyValue=0;
		}
		else if(newMaturirtyValue<totalPay)
		{
			newMaturirtyValue=totalPay;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Maturity Value can't be lesss than Rs. "+totalPay+"/-"));
		}
	}
	
	public String updateMaturity()
	{
		int i=db.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 "maturedRD.xhtml";
	    }
	    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;
	}

	public boolean isDisCloseBtn() {
		return disCloseBtn;
	}

	public void setDisCloseBtn(boolean disCloseBtn) {
		this.disCloseBtn = disCloseBtn;
	}

	public ArrayList<InstallmentInfo> getRdPayList() {
		return rdPayList;
	}

	public void setRdPayList(ArrayList<InstallmentInfo> rdPayList) {
		this.rdPayList = rdPayList;
	}
	

}
