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.Date;

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="editUser")
@ViewScoped
public class EditUserBean implements Serializable
{DataBaseMethods obj=new DataBaseMethods();
	private static final long serialVersionUID = 1L;
	String id,scheme_type,plan_no,strMatDate,applFee,oldApplFee,label,dsaCode,office_application_no;
	double application_rupees,applicant_fees,installment_amount,interest,maturity_value,dsaCommission;
	Date office_date,maturity_date;
	UserInfo selected;
	int terms,frequency;
	ArrayList<SelectItem> planList,dsaList;
	boolean disableFreq, showUpdateBtn, disDsa;
	public boolean isDisDsa() {
		return disDsa;
	}

	public void setDisDsa(boolean disDsa) {
		this.disDsa = disDsa;
	}

	DsaListInfo dsa_info;
	
	public EditUserBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		selected=(UserInfo) ss.getAttribute("selected");
		id=selected.getId();
		office_date=selected.getOffice_date();
		application_rupees=selected.getApplication_rupees();
		scheme_type=selected.getScheme_type();
		planList=obj.allPlans(branchId,scheme_type);
		plan_no=selected.getPlan_no();
		dsaList=obj.allDsaList(branchId,scheme_type,conn);
		office_application_no=selected.getOffice_application_no();
		
		terms=selected.getTerms();
		if(selected.getDsaCode()==null || selected.getDsaCode().equalsIgnoreCase(""))
		{
			disDsa=false;
		}
		else
		{
			dsaCode=selected.getDsaCode();
			disDsa=true;
		}
	
		dsaCommission=selected.getDsaCommission();
		applicant_fees=selected.getApplicant_fees();
		if(applicant_fees==0)
		{
			applFee="";
		}
		else
		{
			applFee=String.valueOf(applicant_fees);
		}
		
		oldApplFee=applFee;

		installment_amount=selected.getInstallment_amount();
		interest=selected.getInterest();
		maturity_value=selected.getMaturity_value();
		maturity_date=selected.getMaturity_date();
		strMatDate=selected.getStrMatDate();
		frequency=selected.getFrequency();
		if(scheme_type.equals("FD"))
		{
			disableFreq=true;
			label="Time Period (IN MONTHS)";
		}
		else if(scheme_type.equals("DD"))
		{
			disableFreq=true;
			label="Terms";
		}
		else
		{
			disableFreq=false;
			label="Terms";
		}
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void calculateInterest()
	{
		showUpdateBtn=true;
		int x=0;
		maturity_value=obj.findInterest(terms,installment_amount,interest,scheme_type,frequency);
		maturity_value=Double.parseDouble(new DecimalFormat("##.##").format(maturity_value));
		maturity_date=obj.findMaturityDate(office_date,terms,frequency);
		strMatDate=new SimpleDateFormat("dd/MM/yyyy").format(maturity_date);
		x=checkValue();
		if(x!=0)
	    {
	    	FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Enter Correct Terms According To Frequency"));
	    }
	    else
	    {
	    	RequestContext.getCurrentInstance().execute("PF('maturityInfoDialog').show()");
	    	RequestContext.getCurrentInstance().update(":form2");
	    }
	}
	
//	public void updateDsaList()
//	{
//		if(scheme_type.equals("RD"))
//		{
//			if(terms==365)
//				{
//					dsaList=obj.allDsaList("DD");
//				}
//			else
//				{
//					dsaList=obj.allDsaList("RD");
//				}
//		}
//	}
	public void calculateCommission()
	{
	   System.out.println("$$"+terms);
		if(dsaCode !=null)
			{
			dsa_info=obj.dsaInfoByCode(dsaCode,scheme_type);
			
				double RdAmt=scheme_type.equals("FD")?installment_amount:installment_amount*terms;
				//System.out.println(RdAmt);
				String commType=dsa_info.getCommission_type();
				double commVal=dsa_info.getCommission_value();
				//System.out.println("##"+commVal);
				//System.out.println("@@"+commType);
				if(commType.equals("flat"))
					{
						dsaCommission=commVal;
					}
				else
					{ 
						dsaCommission=(RdAmt*commVal)/100;
						dsaCommission=Double.parseDouble(new DecimalFormat("##.##").format(dsaCommission));
					}
		  }
		
	  
	   
	}
	public int checkValue()
	{
		int x=0;
		if(frequency==4)
	    {
	    	x=terms%3;
	    }
	    else if(frequency==2)
	    {
	    	x=terms%6;
	    }
	    else if(frequency==1)
	    {
	    	x=terms%12;
	    }
		return x;
	}
	
	public void checkPlan()
	{
		if(plan_no.equals(""))
		{
			interest=selected.getInterest();
		}
		else
		{
			interest=obj.interestByPlanNo(plan_no);
		}
		
	}
	
	public String updateInfoUser()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		double capital=obj.totalCompanyCapitalAmount(branchId);
		maturity_value=obj.findInterest(terms,installment_amount,interest,scheme_type,frequency);
		maturity_value=Double.parseDouble(new DecimalFormat("##.##").format(maturity_value));
		maturity_date=obj.findMaturityDate(office_date,terms,frequency);
		int x1=checkValue();
		if(x1!=0)
	    {
	    	FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Enter Correct Terms According To Frequency"));
	    }
		else
		{
			int n=obj.updateUserInfo(id,scheme_type,plan_no,terms,applicant_fees,installment_amount,interest,maturity_value,maturity_date,frequency,dsaCode,dsaCommission, 
					office_application_no, office_date);
			if(n>=1)
			{
				
				if(applicant_fees==0)
				{
					applFee="";
				}
				else
				{
					applFee=String.valueOf(applicant_fees);
				}
				//System.out.println("capital : "+capital);
		    	//System.out.println("new : "+applFee);
		    	//System.err.println("old : "+oldApplFee);
				obj.updateCompanyCapital(branchId,applFee, oldApplFee, capital);
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Details Updated Successfully"));
				return "editViewDeleteUser";
			}
			else
			{
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			}
		}
		return "";
	}
	
	
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public int getFrequency() {
		return frequency;
	}

	public void setFrequency(int frequency) {
		this.frequency = frequency;
	}

	public String getScheme_type() {
		return scheme_type;
	}
	public void setScheme_type(String scheme_type) {
		this.scheme_type = scheme_type;
	}
	public String getPlan_no() {
		return plan_no;
	}
	public void setPlan_no(String plan_no) {
		this.plan_no = plan_no;
	}
	public String getStrMatDate() {
		return strMatDate;
	}
	public void setStrMatDate(String strMatDate) {
		this.strMatDate = strMatDate;
	}
	public double getApplication_rupees() {
		return application_rupees;
	}
	public void setApplication_rupees(double application_rupees) {
		this.application_rupees = application_rupees;
	}
	public double getApplicant_fees() {
		return applicant_fees;
	}
	public void setApplicant_fees(double applicant_fees) {
		this.applicant_fees = applicant_fees;
	}
	public double getInstallment_amount() {
		return installment_amount;
	}
	public void setInstallment_amount(double installment_amount) {
		this.installment_amount = installment_amount;
	}
	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 Date getOffice_date() {
		return office_date;
	}
	public void setOffice_date(Date office_date) {
		this.office_date = office_date;
	}
	public Date getMaturity_date() {
		return maturity_date;
	}
	public void setMaturity_date(Date maturity_date) {
		this.maturity_date = maturity_date;
	}
	public UserInfo getSelected() {
		return selected;
	}
	public void setSelected(UserInfo selected) {
		this.selected = selected;
	}
	public int getTerms() {
		return terms;
	}
	public void setTerms(int terms) {
		this.terms = terms;
	}

	public ArrayList<SelectItem> getPlanList() {
		return planList;
	}

	public void setPlanList(ArrayList<SelectItem> planList) {
		this.planList = planList;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getDsaCode() {
		return dsaCode;
	}
	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}
	public double getDsaCommission() {
		return dsaCommission;
	}
	public void setDsaCommission(double dsaCommission) {
		this.dsaCommission = dsaCommission;
	}
	public boolean isDisableFreq() {
		return disableFreq;
	}

	public void setDisableFreq(boolean disableFreq) {
		this.disableFreq = disableFreq;
	}
	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}
	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public String getOffice_application_no() {
		return office_application_no;
	}

	public void setOffice_application_no(String office_application_no) {
		this.office_application_no = office_application_no;
	}

	public boolean isShowUpdateBtn() {
		return showUpdateBtn;
	}

	public void setShowUpdateBtn(boolean showUpdateBtn) {
		this.showUpdateBtn = showUpdateBtn;
	}
	
}
