package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

@ManagedBean(name = "odlAgreementBean")
@ViewScoped

public class OverDueLoanAgreementBean implements Serializable
{
	private String dayofMonth, monthofYear, amountInWords;
	
	private int branchId;
	
	private Date todayDate = new Date();
	
	OverDraftInfo selected;
	
	SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
	
	
	
	public OverDueLoanAgreementBean() 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        branchId = (int) ss.getAttribute("branchId");
        selected = (OverDraftInfo) ss.getAttribute("odCustomerData");
                
        loanDetails();
        otherDetails();
	}
	
	
	
	public void loanDetails() 
	{
        try (Connection conn = DataBaseConnection.JAVAConnection()) 
        {
            String qq = "SELECT * FROM overdue_loan WHERE customer_id = ? AND branch_id = ? AND status = 'active'";
          
            try (PreparedStatement ps = conn.prepareStatement(qq)) 
            {
                ps.setString(1, selected.getCustomerId());
                ps.setInt(2, branchId);
                
                ResultSet rs = ps.executeQuery();
                if (rs.next()) 
                {
                    selected.setLoanNo(rs.getString("loan_no"));
                    selected.setSanctionLimit(rs.getDouble("sanction_limit"));
                    selected.setInterestRate(rs.getInt("interest_rate"));
                    selected.setFees(rs.getDouble("fees"));
                    selected.setPayMode(rs.getString("pay_mode"));
                    selected.setTxnNo(rs.getString("txn_no"));
                    selected.setTxnDateStr(sdf.format(rs.getDate("txn_date")));
                    selected.setUtilizedAmount(rs.getDouble("utilized_amount"));
                    selected.setTerm(rs.getInt("term"));
                    selected.setFrequency(rs.getInt("frequency"));
                    selected.setDaysOutstanding(rs.getInt("days"));
                    selected.setInterestDue(rs.getDouble("interest_due"));
                }
            }
        } 
        catch (Exception e) 
        {
            e.printStackTrace();
        }
    }
	
	
	
	public void otherDetails()
	{
		SimpleDateFormat sdf1 = new SimpleDateFormat("dd");
		dayofMonth = sdf1.format(todayDate);
		
		SimpleDateFormat sdf2 = new SimpleDateFormat("MMMM");
		monthofYear = sdf2.format(todayDate);	
		
		amountInWords = convertAmount(selected.getSanctionLimit());
	}
	
	
	
	private static final String[] units = 
    {
        "", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine",
        "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen",
        "Seventeen", "Eighteen", "Nineteen"
    };

    
    
    private static final String[] tens = 
    {
        "", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety"
    };

    
    
    public static String convertToWords(int number) 
    {
        if (number == 0) return "Zero";

        return convert(number).trim();
    }

    
    
    private static String convert(int number) 
    {
        if (number < 20) 
        {
            return units[number];
        } 
        else if (number < 100) 
        {
            return tens[number / 10] + " " + units[number % 10];
        }
        else if (number < 1000) 
        {
            return units[number / 100] + " Hundred " + convert(number % 100);
        } 
        else if (number < 100000) 
        {
            return convert(number / 1000) + " Thousand " + convert(number % 1000);
        } 
        else if (number < 10000000) 
        {
            return convert(number / 100000) + " Lakh " + convert(number % 100000);
        } 
        else 
        {
            return convert(number / 10000000) + " Crore " + convert(number % 10000000);
        }
    }

    
    
    public static String convertAmount(double amount) 
    {
        int rupees = (int) amount;
        int paise = (int) Math.round((amount - rupees) * 100);

        String words = convertToWords(rupees) + " Rupees";
        
        if (paise > 0) 
        {
            words += " and " + convertToWords(paise) + " Paise";
        }
        
        return words + " Only";
    }



	public OverDraftInfo getSelected() {
		return selected;
	}



	public void setSelected(OverDraftInfo selected) {
		this.selected = selected;
	}



	public String getDayofMonth() {
		return dayofMonth;
	}



	public void setDayofMonth(String dayofMonth) {
		this.dayofMonth = dayofMonth;
	}



	public String getMonthofYear() {
		return monthofYear;
	}



	public void setMonthofYear(String monthofYear) {
		this.monthofYear = monthofYear;
	}



	public Date getTodayDate() {
		return todayDate;
	}



	public void setTodayDate(Date todayDate) {
		this.todayDate = todayDate;
	}



	public String getAmountInWords() {
		return amountInWords;
	}



	public void setAmountInWords(String amountInWords) {
		this.amountInWords = amountInWords;
	}
	
}