package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.ParseException;
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.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRaviK;
import main_package.LoanInfo;
import main_package.UserInfo;

@ManagedBean(name="loanReceipt")
@ViewScoped
public class LoanPaymentReceipt implements Serializable
{
	private static final long serialVersionUID = 1L;

	String loanType,oldLoanType,loanNo,issue_date,receipt_no,term,next_due_date,receipt_date,payMode;
	String shareHolderNo,amountInwords, amountInwordsWithPenalty,installment_no,members=", ";
	double installment_amount, penalty,bounceCharge,finalAmount;
	UserInfo selectedUser;
	LoanInfo info;
	ArrayList<LoanInfo> list;
	int id;
	boolean showMembers, showLoanField, showLoanClosureField;
	LoanInfo selectedLoan;
	DataBaseMethods dbm=new DataBaseMethods();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	
	DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();
	
	public LoanPaymentReceipt()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		
		if (ss != null) {
			shareHolderNo = (String) ss.getAttribute("shareHolderNo");
			oldLoanType = (String) ss.getAttribute("loanType");
			loanNo = (String) ss.getAttribute("loanNo");
			
			// Safe unboxing for primitive int
			Object idObj = ss.getAttribute("id");
			if (idObj != null) {
				id = (Integer) idObj;
			}
			
			// Safe unboxing for primitive double
			Object instAmtObj = ss.getAttribute("installment_amount");
			if (instAmtObj != null) {
				installment_amount = (Double) instAmtObj;
			}

			receipt_no = (String) ss.getAttribute("receipt_no");
			receipt_date = (String) ss.getAttribute("receipt_date");
			installment_no = (String) ss.getAttribute("instlmnt_no");
			payMode = (String) ss.getAttribute("payMode");

			//penalty=(double) ss.getAttribute("penalty");
			Double penaltyObj = (Double) ss.getAttribute("penalty");

			if (penaltyObj != null) {
			    penalty = penaltyObj;
			} else {
			    penalty = 0.0;   // default value
			}
		       
			//bounceCharge=(double) ss.getAttribute("bounceCharge");
//			Double bounceObj = (Double) ss.getAttribute("bounceCharge");
	//
//			if (bounceObj != null) {
//			    bounceCharge = bounceObj;
//			} else {
//			    bounceCharge = 0.0;   // default value
//			}
		}

		finalAmount = installment_amount + penalty + bounceCharge;
		Connection conn = DataBaseConnection.JAVAConnection();
		
		try {
		    SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
		    if (receipt_date != null) {
		        Date receiptDateObj = sdf.parse(receipt_date);
		        bounceCharge = dbrk.getPaidBounce(loanNo, receiptDateObj, conn);
		    }
		} catch (ParseException e) {
		    e.printStackTrace();
		    bounceCharge = 0.0;
		}
		
		if(installment_no != null && !installment_no.equalsIgnoreCase("Restructure"))
		{
			list = dbm.findInstallmentNoForLoan(oldLoanType, loanNo, id, installment_amount);
			
			int prevPaid = 0, afterTransaction = 0;
			if (list != null) {
				for(LoanInfo ll: list)
				{
					if(ll.getTemp1() > 0)
					{
						prevPaid = ll.getTemp1();
					}
					else if(ll.getTemp2() > 0)
					{
						afterTransaction = ll.getTemp2();
					}
				}
			}
			//installment_no=installmentNo(prevPaid,afterTransaction);
		}
				
		info = dbm.loanInfoByLoanNoLoanType(loanNo, oldLoanType, conn);
		if (info != null) {
			loanType = info.getLoanType();
			issue_date = info.getStrApprovalDate();
			term = calculateTerm(String.valueOf(info.getFrequencyVal()), info.getLoanTerm());
		}
		
		selectedUser = dbm.userInfoByShareHolderNo(shareHolderNo, conn);
		if(oldLoanType != null && oldLoanType.equals("grouploan"))
		{
			if (info != null) {
				members += info.getMembers();
			}
			showMembers = true;
		}
		else
		{
			members = "";
			showMembers = false;
		}

		if (selectedUser != null) {
			selectedUser.setStrdob(ageCalculate(selectedUser.getDob()));
			if (selectedUser.getFirst_applicantName() != null) {
				selectedUser.setFirst_applicantName(selectedUser.getFirst_applicantName().toUpperCase());
			}
			if (selectedUser.getFather_husband_name() != null) {
				selectedUser.setFather_husband_name(selectedUser.getFather_husband_name().toUpperCase());
			}
			if (selectedUser.getAddress() != null) {
				selectedUser.setAddress(selectedUser.getAddress().toUpperCase());
			}
		}
		
		if(installment_no != null && !installment_no.trim().equals("") && installment_no.equalsIgnoreCase("Loan Closure"))
		{
			showLoanField = false;
			showLoanClosureField = true;
			selectedLoan = new LoanInfo();
			//selectedLoan=new DataBaseReportMethods().loanCloserList(loanNo, selectedLoan);
			selectedLoan = dbmt.loanCloserList(loanNo, selectedLoan);

			if (selectedLoan != null) {
				installment_amount = selectedLoan.getPaidAmount();
			}
		}
		else
		{
			showLoanField = true;
			showLoanClosureField = false;
			calculateOfDueDate_InstallDate();
		}
		
		SimpleDateFormat f = new SimpleDateFormat("dd/MM/yyyy");
		try {
			if (receipt_date != null) {
				Date penDate = f.parse(receipt_date);
				String penDateStr = new SimpleDateFormat("yyyy-MM-dd").format(penDate);
				penalty = dbm.penaltyAmountReceiveByLoanNoAndDate(loanNo, penDateStr, conn);
			}
		} catch (ParseException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		double printAmt = installment_amount + penalty;
		// This line to add penalty amount with emi if both are same date, Develop on 02-Nov.2023
		
		amountInwords = new DataBaseReportMethods().numberToWords(Integer.parseInt(new DecimalFormat("##").format(installment_amount))).toUpperCase();
		amountInwordsWithPenalty = new DataBaseReportMethods().numberToWords(Integer.parseInt(new DecimalFormat("##").format(printAmt))).toUpperCase();
			
		try {
			if (conn != null) {
				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()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		ArrayList<LoanInfo> loanEMIList=dbm.loanInstallment(oldLoanType,loanNo, conn );
		for(LoanInfo ii : loanEMIList)
        {
        	if(ii.getStatus().equalsIgnoreCase("Due"))
        	{
        		next_due_date=ii.getStrInstlmntDate();
        		break;
        	}
        }
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		//next_due_date=new DataBase().loanNextDueDate(id,loanNo,oldLoanType);
	}
	
	public String ageCalculate(Date dob)
	{
		String age="0 YR - 0 M";
		
		Calendar startCalendar = new GregorianCalendar();
		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;
	}
	
	public String calculateTerm(String frequency,String loanTerm)
	{
		String diff="0 YR - 0 M";
		double frq=0;
		double loan=Double.parseDouble(loanTerm);
		if(frequency.equals("1 week") || frequency.equals("52.0") || frequency.equals("52"))
		{
			frq=0.25;
		}
		else if(frequency.equals("2 week") || frequency.equals("26.0") || frequency.equals("26"))
		{
			frq=.50;
		}
		else if(frequency.equals("4 week") || frequency.equals("13.0") || frequency.equals("13"))
		{
			frq=1;
		}
		else if(frequency.equals("Monthly") || frequency.equals("12.0") || frequency.equals("12"))
		{
			frq=1;
		}
		else if(frequency.equals("Daily") || frequency.equals("365.0") || frequency.equals("365"))
		{
			frq=1/30;
		}
		int x=(int) (loan*frq);
		int yr=x/12;
		int mnth=x%12;
		diff=yr+" YR - "+mnth+" M";
		System.out.println("hello : "+diff);
		return diff;
	}
	
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	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 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 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 getLoanType() {
		return loanType;
	}
	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}
	public String getLoanNo() {
		return loanNo;
	}
	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}
	public String getIssue_date() {
		return issue_date;
	}
	public void setIssue_date(String issue_date) {
		this.issue_date = issue_date;
	}
	public String getReceipt_date() {
		return receipt_date;
	}
	public void setReceipt_date(String receipt_date) {
		this.receipt_date = receipt_date;
	}
	public String getInstallment_no() {
		return installment_no;
	}
	public void setInstallment_no(String installment_no) {
		this.installment_no = installment_no;
	}
	public String getMembers() {
		return members;
	}
	public void setMembers(String members) {
		this.members = members;
	}
	public boolean isShowMembers() {
		return showMembers;
	}
	public void setShowMembers(boolean showMembers) {
		this.showMembers = showMembers;
	}

	public boolean isShowLoanField() {
		return showLoanField;
	}

	public void setShowLoanField(boolean showLoanField) {
		this.showLoanField = showLoanField;
	}

	public boolean isShowLoanClosureField() {
		return showLoanClosureField;
	}

	public void setShowLoanClosureField(boolean showLoanClosureField) {
		this.showLoanClosureField = showLoanClosureField;
	}

	public LoanInfo getSelectedLoan() {
		return selectedLoan;
	}

	public void setSelectedLoan(LoanInfo selectedLoan) {
		this.selectedLoan = selectedLoan;
	}

	public String getPayMode() {
		return payMode;
	}

	public void setPayMode(String payMode) {
		this.payMode = payMode;
	}

	public double getPenalty() {
		return penalty;
	}

	public void setPenalty(double penalty) {
		this.penalty = penalty;
	}

	public String getAmountInwordsWithPenalty() {
		return amountInwordsWithPenalty;
	}

	public void setAmountInwordsWithPenalty(String amountInwordsWithPenalty) {
		this.amountInwordsWithPenalty = amountInwordsWithPenalty;
	}

	public double getBounceCharge() {
		return bounceCharge;
	}

	public void setBounceCharge(double bounceCharge) {
		this.bounceCharge = bounceCharge;
	}

	public double getFinalAmount() {
		return finalAmount;
	}

	public void setFinalAmount(double finalAmount) {
		this.finalAmount = finalAmount;
	}
}
