package main_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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.apache.poi.hssf.util.HSSFColor.TEAL;
import org.primefaces.context.RequestContext;

@ManagedBean(name="userRegistration")
@ViewScoped
public class UserRegistrationBean implements Serializable
{
	private static final long serialVersionUID = 1L;

	String office_application_no,user_no, first_applicantName,father_husband_name, guardian_name,guardian_relation,status,PAN;
	String bank_accountNo, bank_name, branch, address, mobile,nominee_name, nominee_relation, nominee_address, scheme_type, plan_no;
	String account_status,shareHolderNo,receipt_no,strMaturityDate,label, label2,dsaCode="";
	double application_rupees,applicant_fees,installment_amount,interest,maturity_value,dsaCommission, monthlyAmount;
	int terms,frequency;
	Date office_date=new Date(), maxDate=new Date(),dob,nominee_dob,maturity_date;
	public static List<String> list;
	boolean show,showFreq, showComm, showMonth, disDsa;
	UserInfo selectedUser;
	ArrayList<SelectItem> dsaList;
	ArrayList<SelectItem> planList;
	DsaListInfo dsa_info, commissionInfo;
	DataBaseMethods obj=new DataBaseMethods();
	int branchId;
	public UserRegistrationBean() 
	{
		label="Terms";
		label2="Installment Amount";
		
		HeaderBean hh=new HeaderBean();
		if(hh.getName().equalsIgnoreCase("SRLF MUTUAL BENEFIT NIDHI LIMITED") || hh.getName().equalsIgnoreCase("SHREE RAJ LAXMI FINANCE") 
				|| hh.getName().equalsIgnoreCase("GKFC NIDHI LIMITED") || hh.getName().equalsIgnoreCase("ARADHANA MUTUAL BENEFIT NIDHI LIMITED")
				 || hh.getName().equalsIgnoreCase("SHRI GANESH FINANCE"))
		{
			maxDate.setDate(maxDate.getDate()+15);
		}
		
		
	}
	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().shareHolderAllNo(branchId,name);
     	return list;
	}
	
	public void shareHolderDetails()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		
		if(shareHolderNo.contains("/"))
		{
			shareHolderNo=shareHolderNo.substring(0,shareHolderNo.indexOf("/"));
		}
		selectedUser=obj.userInfoByShareHolderNo(shareHolderNo, conn);
		if(selectedUser!=null)
		{
			show=true;
		}
		else
		{
			show=false;
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Invalid Share Holder No"));
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void calculateInterest()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		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);
	    strMaturityDate=new SimpleDateFormat("dd/MM/yyyy").format(maturity_date);
	    
	    if(scheme_type.equals("MIS"))
	    {
	    	showMonth=true;
	    	double intr=maturity_value-installment_amount;
	    	monthlyAmount=Math.round(intr/terms);
	    }
	    else
	    {
	    	showMonth=false;
	    	monthlyAmount=0;
	    }
	    
	    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 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 checkSchemeType()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		interest=0.0;
		dsaCommission=0.00;
		if(scheme_type.equalsIgnoreCase("RD"))
		{
			frequency=12;
			showFreq=true;
			label="Terms";
			label2="Installment Amount";
		}
		else if(scheme_type.equalsIgnoreCase("DD"))
		{
			frequency=365;
			showFreq=false;
			label="Terms";
			label2="Installment Amount";
		}
		else if(scheme_type.equalsIgnoreCase("FD"))
		{
			frequency=12;
			showFreq=false;
			label="FD Tenure (IN MONTHS)";
			label2="FD Amount";
			
		}
		else if(scheme_type.equalsIgnoreCase("MIS"))
		{
			frequency=12;
			showFreq=false;
			label="MIS Tenure (IN MONTHS)";
			label2="Deposit Amount";
		}
		
		Connection conn=DataBaseConnection.JAVAConnection();
		user_no=obj.calculateUserNo(branchId,scheme_type);
		office_application_no=user_no;
		
		String userId=obj.userId();
		dsaList=obj.allDsaList(branchId,"Loan",conn);
		if(obj.userType().equals("employee"))
		{
			dsaCode=obj.dsaCodeByEmpUserId(userId, conn);
			disDsa=true;
		}
		
		planList=obj.allPlans(branchId,scheme_type);
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void checkPlan()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		interest=obj.interestByPlanNo(plan_no);
		if(dsaCode==null || dsaCode.equals(""))
		{
			dsaCommission=0;
		}
		else
		{
			commissionInfo=obj.checkPlanCommissionDetail(plan_no, conn);
			if(commissionInfo==null || commissionInfo.getStatusNullCheck().equals("0"))
			{
				dsaCommission=0;
				showComm=false;
			}
			else
			{
				if(commissionInfo.getCommissionBase().equalsIgnoreCase("Approval"))
				{
					showComm=true;
					calculateCommission();
				}
				else
				{
					showComm=false;
				}
			}
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public String register()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		int flag=1;
		
		boolean chk=obj.checkLastEntrySettingInDb(branchId,"Deposit",conn);
		if(chk==true)
		{
			String lastDepositNo=obj.lastShareLoanDepositNo("Deposit");
			Date lastDate=obj.lastShareLoanDepositNoDate(lastDepositNo, "Deposit");
			
			if(lastDate!=null && !lastDepositNo.equals(""))
			{
				String lastDateStr=new SimpleDateFormat("dd-MMM-yyyy").format(lastDate);
				if(lastDate.after(office_date))
				{
					flag=99;
					FacesContext fc=FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("New Deposit can't open Before the Last Deposit No. Date. Your Last Deposit No. "+lastDepositNo +" Open Date is: "+lastDateStr));
				}
			}
		}
		
		
		if(terms<=0)
		{
			flag=98;
		}
		
		if(installment_amount<=0)
		{
			flag=97;
		}
		
		if(flag==1)
		{
			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);
			strMaturityDate=new SimpleDateFormat("dd/MM/yyyy").format(maturity_date);
			int x1=checkValue();
			if(x1!=0)
		    {
		    	FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Enter Correct Terms According To Frequency"));
		    }
			else
			{
				user_no=obj.calculateUserNo(branchId,scheme_type);
		
				int n=obj.registerUser(branchId,office_application_no,office_date,application_rupees,user_no,scheme_type,plan_no,terms,
				applicant_fees,installment_amount,interest,maturity_value,maturity_date,shareHolderNo,frequency,dsaCode,dsaCommission);
				if(n>=1)
				{
					FacesContext fc=FacesContext.getCurrentInstance();
					receipt_no=String.valueOf(obj.receiptNo());
					
					sendMessage(conn);
					
					if(dsaCommission>0)
					{
						String emiNo="all";
						String dsaName=obj.dsaNameById(dsaCode,conn);
						int i=obj.insertDataInDsaCommissionTable(branchId,scheme_type, user_no, dsaCode, dsaCommission, office_date, emiNo);
						if(i>0)
						{
							fc.addMessage(null, new FacesMessage("Commission Auto Credited to "+dsaCode+" - "+dsaName+" Rs.:- "+dsaCommission));
						}
					}
					/*int x=obj.firstInstallment(user_no,office_date,installment_amount,receipt_no);
					if(x>=1)
					{*/
						//obj.increaseCompanyCapitalAmount(installment_amount);
						obj.increaseCompanyCapitalAmount(branchId,applicant_fees,conn);
						
						fc.addMessage(null, new FacesMessage("Registered Successfully... Your "+scheme_type+" No. is:- "+user_no));
						ss.setAttribute("shareHolderNo", shareHolderNo);
						ss.setAttribute("frequency", frequency);
						ss.setAttribute("office_application_no", office_application_no);
						ss.setAttribute("scheme_type", scheme_type);
						ss.setAttribute("rd_fdNo",user_no);
						ss.setAttribute("maturityDate", strMaturityDate);
						ss.setAttribute("date", office_date);
						ss.setAttribute("issue_date", office_date);
						if(scheme_type.equalsIgnoreCase("MIS"))
						{
							ss.setAttribute("maturity_value",installment_amount);
						}
						else
						{
							ss.setAttribute("maturity_value",maturity_value);
						}
//						/ss.setAttribute("maturity_value", maturity_value);
						ss.setAttribute("receipt_no", receipt_no);
						ss.setAttribute("installment_amount", installment_amount);
						ss.setAttribute("plan_no", plan_no);
						ss.setAttribute("dsaCommission", dsaCommission);
						ss.setAttribute("dsaCode", dsaCode);
						ss.setAttribute("id",0);
						
						HeaderBean hh=new HeaderBean();
						if(hh.getName().equalsIgnoreCase("DEVKRIPA MICROFINANCE FOUNDATION"))
						{
							RequestContext.getCurrentInstance().execute("window.open('printRD_FDFormGolden.xhtml')");
						}
						else
						{
							RequestContext.getCurrentInstance().execute("window.open('printRD_FDForm.xhtml')");
						}
						
						
						shareHolderNo="";
						try {
							conn.close();
						} catch (Exception e) {
							// TODO: handle exception
						}
						return "userRegistration.xhtml";
					/*}
					else
					{
						FacesContext fc=FacesContext.getCurrentInstance();
						fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
					}*/
				}
				else
				{
					FacesContext fc=FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
				}
			}
		}
		else if(flag==98)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Please Enter Valid Deposit Terms.", ""));
		}
		else if(flag==97)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Please Enter Valid Deposit Amount.", ""));
		}
		
		
		return "";
	}
	

	private void sendMessage(Connection conn) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		HeaderBean hh=new HeaderBean();
		String check=obj.checkStatusInMessageSettingTable("Policy Registration");
		if(check.equals("active"))
		{
			String typeMessage="Thanks for Deposit in "+hh.getSentBy()+". Your "+scheme_type+" No. is "+user_no;
			String userId=obj.userId();
			obj.runMessageUrl(branchId,selectedUser.getContactNo(), typeMessage, userId,"1207161799206261693", conn);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Message For This Module is not Active. Please Go to In User Block and Active Message For This Module."));
		}
	}

	public void calculateCommission()
	{
		double val=0;
		if(commissionInfo==null)
		{
			dsaCommission=0;
		}
		else
		{
			 if(commissionInfo.getCommissionBase().equalsIgnoreCase("approval"))
			   {
				   if(scheme_type.equals("FD"))
				   {
					   val=installment_amount;
				   }
				   else
				   {
					   val=installment_amount*terms;
				   }
				   
				   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
				   {
					   dsaCommission=(val/100)*commissionInfo.getCommission_value();
				   }
				   else
				   {
					   dsaCommission=commissionInfo.getCommission_value();
				   }
			   }
			   else
			   {
				   showComm=false;
				   dsaCommission=0;
			   }
			   dsaCommission=Double.parseDouble(new DecimalFormat("##.##").format(dsaCommission));
		}
	  
	}
	
	
	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 String getUser_no() {
		return user_no;
	}
	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}
	public String getFirst_applicantName() {
		return first_applicantName;
	}
	public void setFirst_applicantName(String first_applicantName) {
		this.first_applicantName = first_applicantName;
	}
	public String getFather_husband_name() {
		return father_husband_name;
	}
	public void setFather_husband_name(String father_husband_name) {
		this.father_husband_name = father_husband_name;
	}
	public String getGuardian_name() {
		return guardian_name;
	}
	public void setGuardian_name(String guardian_name) {
		this.guardian_name = guardian_name;
	}
	public String getGuardian_relation() {
		return guardian_relation;
	}
	public void setGuardian_relation(String guardian_relation) {
		this.guardian_relation = guardian_relation;
	}
	public String getStatus() {
		return status;
	}
	public void setStatus(String status) {
		this.status = status;
	}
	public String getPAN() {
		return PAN;
	}
	public void setPAN(String pAN) {
		PAN = pAN;
	}
	public String getBank_accountNo() {
		return bank_accountNo;
	}
	public void setBank_accountNo(String bank_accountNo) {
		this.bank_accountNo = bank_accountNo;
	}
	public String getBank_name() {
		return bank_name;
	}
	public void setBank_name(String bank_name) {
		this.bank_name = bank_name;
	}
	public String getBranch() {
		return branch;
	}
	public void setBranch(String branch) {
		this.branch = branch;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getMobile() {
		return mobile;
	}
	public void setMobile(String mobile) {
		this.mobile = mobile;
	}
	public String getNominee_name() {
		return nominee_name;
	}
	public void setNominee_name(String nominee_name) {
		this.nominee_name = nominee_name;
	}
	public String getNominee_relation() {
		return nominee_relation;
	}
	public void setNominee_relation(String nominee_relation) {
		this.nominee_relation = nominee_relation;
	}
	public String getNominee_address() {
		return nominee_address;
	}
	public void setNominee_address(String nominee_address) {
		this.nominee_address = nominee_address;
	}
	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 getAccount_status() {
		return account_status;
	}
	public void setAccount_status(String account_status) {
		this.account_status = account_status;
	}
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	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 ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	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 int getTerms() {
		return terms;
	}
	public void setTerms(int terms) {
		this.terms = terms;
	}
	public Date getOffice_date() {
		return office_date;
	}
	public void setOffice_date(Date office_date) {
		this.office_date = office_date;
	}
	public Date getDob() {
		return dob;
	}
	public void setDob(Date dob) {
		this.dob = dob;
	}
	public Date getNominee_dob() {
		return nominee_dob;
	}
	public void setNominee_dob(Date nominee_dob) {
		this.nominee_dob = nominee_dob;
	}
	public Date getMaturity_date() {
		return maturity_date;
	}
	public void setMaturity_date(Date maturity_date) {
		this.maturity_date = maturity_date;
	}
	public String getReceipt_no() {
		return receipt_no;
	}
	public void setReceipt_no(String receipt_no) {
		this.receipt_no = receipt_no;
	}
	public String getStrMaturityDate() {
		return strMaturityDate;
	}
	public void setStrMaturityDate(String strMaturityDate) {
		this.strMaturityDate = strMaturityDate;
	}
	public static List<String> getList() {
		return list;
	}
	public static void setList(List<String> list) {
		UserRegistrationBean.list = list;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	public int getFrequency() {
		return frequency;
	}
	public void setFrequency(int frequency) {
		this.frequency = frequency;
	}

	

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public ArrayList<SelectItem> getPlanList() {
		return planList;
	}

	public void setPlanList(ArrayList<SelectItem> planList) {
		this.planList = planList;
	}

	public boolean isShowFreq() {
		return showFreq;
	}

	public void setShowFreq(boolean showFreq) {
		this.showFreq = showFreq;
	}

	public String getLabel2() {
		return label2;
	}

	public void setLabel2(String label2) {
		this.label2 = label2;
	}

	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 isShowComm() {
		return showComm;
	}

	public void setShowComm(boolean showComm) {
		this.showComm = showComm;
	}

	public DsaListInfo getDsa_info() {
		return dsa_info;
	}

	public void setDsa_info(DsaListInfo dsa_info) {
		this.dsa_info = dsa_info;
	}

	public DsaListInfo getCommissionInfo() {
		return commissionInfo;
	}

	public void setCommissionInfo(DsaListInfo commissionInfo) {
		this.commissionInfo = commissionInfo;
	}

	public Date getMaxDate() {
		return maxDate;
	}

	public void setMaxDate(Date maxDate) {
		this.maxDate = maxDate;
	}

	public double getMonthlyAmount() {
		return monthlyAmount;
	}

	public void setMonthlyAmount(double monthlyAmount) {
		this.monthlyAmount = monthlyAmount;
	}

	public boolean isShowMonth() {
		return showMonth;
	}

	public void setShowMonth(boolean showMonth) {
		this.showMonth = showMonth;
	}

	public boolean isDisDsa() {
		return disDsa;
	}

	public void setDisDsa(boolean disDsa) {
		this.disDsa = disDsa;
	}
	
	
}
