package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
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.servlet.http.HttpSession;

@ManagedBean(name = "overDraftLoanBean")
@ViewScoped

public class overDraftLoanFormBean implements Serializable
{
	private String remarks, payMode, txnNo, currentDate, id = "0";
	
	private int branchId, interestRate, bankId, daysOutstanding, duration, frequency;
	
	private double sanctionLimit = 2000, fees, utilizedAmount, interestDue;
	
	private Date txnDate = new Date();
	
	private boolean renStatement = false;
		
	private List<Integer> dayOptions;
	
	OverDraftInfo selected;
	
	DecimalFormat df = new DecimalFormat("##.##");
	
	
	
	public overDraftLoanFormBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
	    branchId = (int) ss.getAttribute("branchId");
	    selected = (OverDraftInfo) ss.getAttribute("odCustomerData");
	    
	    dayOptions = new ArrayList<>();
	    for (int i = 1; i <= 365; i++) 
	    {
	        dayOptions.add(i);
	    }
	    currentDate = new SimpleDateFormat("dd-MM-yyyy").format(new Date());
	}
	
	
	
	public void calculateInterest() 
	{
	    if (utilizedAmount > sanctionLimit) 
	    {
	        utilizedAmount = sanctionLimit;
	        FacesContext.getCurrentInstance().addMessage(null,
	            new FacesMessage(FacesMessage.SEVERITY_WARN,
	                "Utilized Amount cannot be greater than Sanction Limit", null));
	    }

	    if (duration > 0 && frequency > 0) 
	    {
	        daysOutstanding = (duration * 365) / frequency;
	    } 
	    else 
	    {
	        daysOutstanding = 0;
	    }

	    if (utilizedAmount > 0 && daysOutstanding > 0 && interestRate > 0) 
	    {
	        interestDue = (utilizedAmount * interestRate * daysOutstanding) / 36500.0;
	        id = df.format(interestDue);
	    } 
	    else 
	    {
	        interestDue = 0;
	        id = "0";
	    }
	}

	
	
	public void generateStatement() 
	{	
	    calculateInterest();
	    renStatement = true; 
	}
	
	
	
	public void submit()
	{
		if (selected.getCustomerId() == null || selected.getCustomerId().isEmpty()) 
		{
			return;
		}
		
		String loanNo = generateNextLoanNo();
		
		try(Connection conn = DataBaseConnection.JAVAConnection()) 
		{
			String qq = "INSERT INTO overdue_loan (customer_id, loan_no, sanction_limit, interest_rate, fees, pay_mode, txn_no, "
					  + "txn_date, utilized_amount, term, frequency, days, interest_due, branch_id) "
					  + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
			
			try(PreparedStatement ps = conn.prepareStatement(qq)) 
			{
				ps.setString(1, selected.getCustomerId());
				ps.setString(2, loanNo);
				ps.setDouble(3, sanctionLimit);
				ps.setInt(4, interestRate);
				ps.setDouble(5, fees);
				ps.setString(6, payMode);
				ps.setString(7, txnNo);
				ps.setDate(8, new java.sql.Date(txnDate.getTime()));
				ps.setDouble(9, utilizedAmount);
				ps.setInt(10, duration);
				ps.setInt(11, frequency);
				ps.setInt(12, daysOutstanding);
				ps.setDouble(13, interestDue);
				ps.setInt(14, branchId);
				
				int i = ps.executeUpdate();
				if (i>0) 
				{
					reset();
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Loan Submitted"));
				}
				else 
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Loan not Submitted"));
				}
			} 
			catch (Exception e) 
			{
				e.printStackTrace();
			}
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public String generateNextLoanNo() 
	{
	    String nextCustomerId = "ODL-0000000001";
	    String sql = "SELECT loan_no FROM overdue_loan ORDER BY loan_no DESC LIMIT 1";

	    try (Connection con = DataBaseConnection.JAVAConnection();
	         PreparedStatement ps = con.prepareStatement(sql);
	         ResultSet rs = ps.executeQuery()) 
	    {
	        if (rs.next()) 
	        {
	            String lastId = rs.getString("loan_no");
	            String numericPart = lastId.substring(lastId.lastIndexOf("-") + 1);
	            long newIdNum = Long.parseLong(numericPart) + 1;
	            nextCustomerId = String.format("ODL-%010d", newIdNum);
	        }
	    } 
	    catch (Exception e) 
	    {
	        e.printStackTrace();
	    }

	    return nextCustomerId;
	}
	
	
	
	public void reset()
	{
		remarks = payMode = txnNo = currentDate = ""; 
		
		id = "0";
		
		interestRate = duration = 0;
		
		fees = utilizedAmount = interestDue = 0;
		
		txnDate = new Date();
		
		renStatement = false;
		
		selected = null;
	}



	public OverDraftInfo getSelected() {
		return selected;
	}



	public void setSelected(OverDraftInfo selected) {
		this.selected = selected;
	}



	public String getRemarks() {
		return remarks;
	}



	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}



	public int getInterestRate() {
		return interestRate;
	}



	public void setInterestRate(int interestRate) {
		this.interestRate = interestRate;
	}



	public double getSanctionLimit() {
		return sanctionLimit;
	}



	public void setSanctionLimit(double sanctionLimit) {
		this.sanctionLimit = sanctionLimit;
	}



	public double getFees() {
		return fees;
	}



	public void setFees(double fees) {
		this.fees = fees;
	}



	public String getPayMode() {
		return payMode;
	}



	public void setPayMode(String payMode) {
		this.payMode = payMode;
	}



	public int getBankId() {
		return bankId;
	}



	public void setBankId(int bankId) {
		this.bankId = bankId;
	}



	public Date getTxnDate() {
		return txnDate;
	}



	public void setTxnDate(Date txnDate) {
		this.txnDate = txnDate;
	}



	public String getTxnNo() {
		return txnNo;
	}



	public void setTxnNo(String txnNo) {
		this.txnNo = txnNo;
	}



	public int getDaysOutstanding() {
		return daysOutstanding;
	}



	public void setDaysOutstanding(int daysOutstanding) {
		this.daysOutstanding = daysOutstanding;
	}



	public double getUtilizedAmount() {
		return utilizedAmount;
	}



	public void setUtilizedAmount(double utilizedAmount) {
		this.utilizedAmount = utilizedAmount;
	}



	public double getInterestDue() {
		return interestDue;
	}



	public void setInterestDue(double interestDue) {
		this.interestDue = interestDue;
	}



	public List<Integer> getDayOptions() {
		return dayOptions;
	}



	public void setDayOptions(List<Integer> dayOptions) {
		this.dayOptions = dayOptions;
	}



	public String getCurrentDate() {
		return currentDate;
	}



	public void setCurrentDate(String currentDate) {
		this.currentDate = currentDate;
	}



	public String getId() {
		return id;
	}



	public void setId(String id) {
		this.id = id;
	}



	public boolean isRenStatement() {
		return renStatement;
	}



	public void setRenStatement(boolean renStatement) {
		this.renStatement = renStatement;
	}



	public int getDuration() {
		return duration;
	}



	public void setDuration(int duration) {
		this.duration = duration;
	}



	public int getFrequency() {
		return frequency;
	}



	public void setFrequency(int frequency) {
		this.frequency = frequency;
	}
	
}