package report_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.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.InstallmentInfo;
import main_package.UserInfo;

@ManagedBean(name="pRF_Form")
@ViewScoped
public class PrintRD_FDFormBean implements Serializable
{
	private static final long serialVersionUID = 1L;

	String scheme_type,office_application_no,rd_fd_no,maturityDate,receipt_date,receipt_no,plan_no,term,dateOfEveryInstall,next_due_date;
	String frequency,shareHolderNo,amountInwords,installment_no,issueDate,ins_no;
	double maturity_value,installment_amount,installment;
	UserInfo selectedUser;
	ArrayList<InstallmentInfo> list;
	int id;
	DataBaseMethods db=new DataBaseMethods();
	
	public PrintRD_FDFormBean()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		id=(int) ss.getAttribute("id");
		shareHolderNo=(String) ss.getAttribute("shareHolderNo");
		office_application_no=(String) ss.getAttribute("office_application_no");
		scheme_type=(String) ss.getAttribute("scheme_type");
		rd_fd_no=(String) ss.getAttribute("rd_fdNo");
		maturityDate=(String) ss.getAttribute("maturityDate");
		maturity_value=(double) ss.getAttribute("maturity_value");
		installment_amount=(double) ss.getAttribute("installment_amount");
		receipt_no=(String) ss.getAttribute("receipt_no");
		plan_no=(String) ss.getAttribute("plan_no");
		
		plan_no=db.planNameByPlanId(plan_no, conn);
		
		list=db.findInstallmentNoForRdFd(rd_fd_no,id,installment_amount);
		int prevPaid=0,afterTransaction=0;
		for(InstallmentInfo ll: list)
		{
			if(ll.getTemp1()>0)
			{
				prevPaid=ll.getTemp1();
			}
			else if(ll.getTemp2()>0)
			{
				afterTransaction=ll.getTemp2();
			}
		}
		System.out.println(prevPaid);
		System.out.println(afterTransaction);
		installment_no=installmentNo(prevPaid,afterTransaction);
		
		Date dt=(Date) ss.getAttribute("date");
		receipt_date=new SimpleDateFormat("dd/MM/yyyy").format(dt);
		
		Date cDate=(Date) ss.getAttribute("issue_date");
		issueDate=new SimpleDateFormat("dd/MM/yyyy").format(cDate);
		
		term=db.calculateTerm(dt, maturityDate);
		int frequency=(int) ss.getAttribute("frequency");
		checkValue(frequency);
		selectedUser=db.userInfoByShareHolderNo(shareHolderNo, conn);
		
		selectedUser.setStrdob(ageCalculate(selectedUser.getDob()));
		//selectedUser.setStrNomDate(ageCalculate(selectedUser.getNominee_dob()));
		if(selectedUser.getNominee_name()!=null)
		{
			selectedUser.setNominee_name(selectedUser.getNominee_name().toUpperCase());

		}
	
		selectedUser.setNominee_relation(selectedUser.getNominee_relation().toUpperCase());
		selectedUser.setFirst_applicantName(selectedUser.getFirst_applicantName().toUpperCase());
		selectedUser.setFather_husband_name(selectedUser.getFather_husband_name().toUpperCase());
		selectedUser.setAddress(selectedUser.getAddress().toUpperCase());
		
		amountInwords=new DataBaseReportMethods().numberToWords(Integer.parseInt(new DecimalFormat("##").format(installment_amount))).toUpperCase();
		calculateOfDueDate_InstallDate(dt);
		
		
		if(scheme_type.equalsIgnoreCase("fd"))
		{
			this.frequency="";
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public String installmentNo(int prevPaid, int afterTransaction)
	{
		int r=0,differenceOfInstlmntNos=0;
		String ins_no="";
		
		
		differenceOfInstlmntNos=afterTransaction-prevPaid;
		prevPaid=prevPaid+1;
		for(int p=1;p<=differenceOfInstlmntNos;p++)
		{
			r=prevPaid++;
			if(p!=differenceOfInstlmntNos)
			{
				ins_no=ins_no+r+",";
			}
			else if(prevPaid==1)
			{
				ins_no="1";
			}
			else
			{
				ins_no=ins_no+r;
			}
			
		}
		installment_no=ins_no;
		
		return installment_no;
	}
	
	public void calculateOfDueDate_InstallDate(Date ofcDate)
	{
		if(scheme_type.equals("FD") || scheme_type.equals("MIS"))
		{
			next_due_date=dateOfEveryInstall="-------";
		}
		else
		{
			/*list=new DataBase().showInstallment(rd_fd_no);
	        for(InstallmentInfo ii : list)
	        {
	        	if(ii.getStatus().equalsIgnoreCase("Due"))
	        	{
	        		next_due_date=ii.getIns_date();
	        		installment_no=String.valueOf(ii.getSno()-1);
	        		break;
	        	}
	        }*/
			
			next_due_date=db.nextDueDate(id,rd_fd_no);
			
	        if(frequency.equalsIgnoreCase("Monthly"))
	        {
	        	dateOfEveryInstall="AFTER EVERY MONTH";
	        }
	        else if(frequency.equalsIgnoreCase("Quarterly"))
	        {
	        	dateOfEveryInstall="AFTER EVERY FOUR MONTH";
	        }
	        else if(frequency.equalsIgnoreCase("Half Yearly"))
	        {
	        	dateOfEveryInstall="AFTER EVERY SIX MONTH";
	        }
	        else  if(frequency.equalsIgnoreCase("Yearly"))
	        {
	        	String dt=createDate(ofcDate);
	        	dateOfEveryInstall=dt+" OF EVERY YEAR";
	        }
	        else if(frequency.equalsIgnoreCase("Daily"))
	        {
	        	dateOfEveryInstall="EVERYDAY";
	        }
	        else if(frequency.equalsIgnoreCase("10 Days"))
	        {
	        	dateOfEveryInstall="AFTER EVERY TEN DAYS";
	        }
	        else if(frequency.equalsIgnoreCase("15 Days"))
	        {
	        	dateOfEveryInstall="AFTER EVERY FIFTEEN DAYS";
	        }
	        else if(frequency.equalsIgnoreCase("1 Week"))
	        {
	        	dateOfEveryInstall="AFTER EVERY 1 Week";
	        }
	        else if(frequency.equalsIgnoreCase("2 Week"))
	        {
	        	dateOfEveryInstall="AFTER EVERY 2 Week";
	        }
	        else if(frequency.equalsIgnoreCase("4 Week"))
	        {
	        	dateOfEveryInstall="AFTER EVERY 4 Week";
	        }
		}
	}
	
	public String createDate(Date ofcDate)
	{
		String date="";
		int d=ofcDate.getDate();
		int m=ofcDate.getMonth();
		String month=new DataBaseReportMethods().monthNameByNumber(m);
		if(d==1)
		{
			date="1 ST ";
		}
		else if(d==2)
		{
			date="1 ND ";
		}
		else if(d==3)
		{
			date="3 RD ";
		}
		else
		{
			date=d+" TH ";
		}
		date+=month;
		return date;
	}
	
	public String ageCalculate(Date dob)
	{
		String age="0 YR - 0 M";
		
		Calendar startCalendar = new GregorianCalendar();
		if(dob!=null)
		{
			startCalendar.setTime(dob);

		}
		Calendar endCalendar = new GregorianCalendar();
		endCalendar.setTime(new Date());
		
		int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR);
		int diffMonth = (diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH))%12;
		
		age=diffYear+" YR - "+diffMonth+" M";
		return age;
	}
	
	// Wrong Method
	/*public String calculateTerm(Date startDate,String eDate)
	{
		String diff="0 YR - 0 M";
		try
		{
			Date endDate=new SimpleDateFormat("dd/MM/yyyy").parse(eDate);
			
			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))%12;
			
			diff=diffYear+" YR - "+diffMonth+" M";
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return diff;
	}*/
	
	
	public String checkValue(int fr)
	{
		if(fr==12)
	    {
	    	frequency="MONTHLY";
	    }
		else if(fr==4)
	    {
	    	frequency="QUARTERLY";
	    }
	    else if(fr==2)
	    {
	    	frequency="HALF YAERLY";
	    }
	    else if(fr==1)
	    {
	    	frequency="YEARLY";
	    }
	    else if(fr==365)
	    {
	    	frequency="DAILY";
	    }
	    else if(fr==36)
	    {
	    	frequency="10 Days";
	    }
	    else if(fr==24)
	    {
	    	frequency="15 DAYS";
	    }
	    else if(fr==26)
	    {
	    	frequency="2 Week";
	    }
	    else if(fr==13)
	    {
	    	frequency="4 Week";
	    }
	    else if(fr==52)
	    {
	    	frequency="1 Week";
	    }
		return frequency;
	}
	public String getScheme_type() {
		return scheme_type;
	}
	public void setScheme_type(String scheme_type) {
		this.scheme_type = scheme_type;
	}
	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 getFrequency() {
		return frequency;
	}
	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	public double getMaturity_value() {
		return maturity_value;
	}
	public void setMaturity_value(double maturity_value) {
		this.maturity_value = maturity_value;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	public String getRd_fd_no() {
		return rd_fd_no;
	}
	public void setRd_fd_no(String rd_fd_no) {
		this.rd_fd_no = rd_fd_no;
	}
	public String getMaturityDate() {
		return maturityDate;
	}
	public void setMaturityDate(String maturityDate) {
		this.maturityDate = maturityDate;
	}
	public String getReceipt_date() {
		return receipt_date;
	}
	public void setReceipt_date(String receipt_date) {
		this.receipt_date = receipt_date;
	}
	public String getIssueDate() {
		return issueDate;
	}
	public void setIssueDate(String issueDate) {
		this.issueDate = issueDate;
	}
	public String getReceipt_no() {
		return receipt_no;
	}
	public void setReceipt_no(String receipt_no) {
		this.receipt_no = receipt_no;
	}
	public double getInstallment_amount() {
		return installment_amount;
	}
	public void setInstallment_amount(double installment_amount) {
		this.installment_amount = installment_amount;
	}
	public String getPlan_no() {
		return plan_no;
	}
	public void setPlan_no(String plan_no) {
		this.plan_no = plan_no;
	}
	public String getTerm() {
		return term;
	}
	public void setTerm(String term) {
		this.term = term;
	}
	public String getAmountInwords() {
		return amountInwords;
	}
	public void setAmountInwords(String amountInwords) {
		this.amountInwords = amountInwords;
	}
	public String getDateOfEveryInstall() {
		return dateOfEveryInstall;
	}
	public void setDateOfEveryInstall(String dateOfEveryInstall) {
		this.dateOfEveryInstall = dateOfEveryInstall;
	}
	public String getNext_due_date() {
		return next_due_date;
	}
	public void setNext_due_date(String next_due_date) {
		this.next_due_date = next_due_date;
	}
	public String getInstallment_no() {
		return installment_no;
	}
	public void setInstallment_no(String installment_no) {
		this.installment_no = installment_no;
	}
}
