package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Calendar;
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="mll")
@ViewScoped
public class MoneyLendingQuartlyReportBean implements Serializable {

    private static final long serialVersionUID = 1L;

    private String moneyLender, address, licenceNo, licenceDate, branchCode;
    private Date startDate, endDate;
    DataBaseMethods db = new DataBaseMethods();
    ArrayList<LoanInfo> lendCustList;

    
    
    public MoneyLendingQuartlyReportBean() {
        
    	HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
        UserInfo selected = (UserInfo) ss.getAttribute("selectedDataForHeaderBean");
        branchCode = selected.getBranchCode();
        
        basicDetails();
        
    }
    
    
    
    public void basicDetails(){

    	try (Connection conn = DataBaseConnection.JAVAConnection()) {

            String query = "SELECT * FROM firm_detail WHERE branch_code = ?";

            try (PreparedStatement ps = conn.prepareStatement(query)) {
                ps.setString(1, branchCode);

                ResultSet rs = ps.executeQuery();

                if (rs.next()) {
                    address = rs.getString("address3");
                    licenceNo = rs.getString("address4");
                     // if licenceDate is stored in DB, fetch it here
                    // licenceDate = rs.getString("licence_date");
                }
    
            } catch (Exception e) {
                e.printStackTrace();
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
  
    
    public void search() {
    	

    	   // Format to desired output, e.g., "dd-MM-yyyy"
	    DateTimeFormatter outputFormatter = DateTimeFormatter.ofPattern("dd-MM-yyyy");
    	
    	lendCustList = new ArrayList<>();
        Timestamp fromDte = new Timestamp(startDate.getTime());
        Timestamp endDte = new Timestamp(endDate.getTime());

        try (Connection conn = DataBaseConnection.JAVAConnection()) {

            String query = "SELECT * FROM personalloan WHERE approvalDate BETWEEN ? AND ?";

            try (PreparedStatement ps = conn.prepareStatement(query)) {

                ps.setTimestamp(1, fromDte);
                ps.setTimestamp(2, endDte);
                 
                ResultSet rs = ps.executeQuery();
                System.out.println(query);
                while (rs.next()) {
                    LoanInfo li = new LoanInfo();
                    String shareholder = rs.getString("shareholderno");
                          
                    UserInfo userDet = db.memberBasicDetail(shareholder, conn);
                    
                    li.setNameOfCust(userDet.getFirst_applicantName());
                    li.setCustAddress(userDet.getAddress());
                    li.setDateOfLoan(rs.getString("approvalDate"));
                    li.setCustLoanAmount(rs.getString("loanAmount"));
                    
                    String loanNo = rs.getString("loanNo");
                    Date firstEMiDate = rs.getDate("emi_due_date");
                    if(firstEMiDate==null ) {
                     firstEMiDate = rs.getDate("approvalDate"); 	
                     
                    }
                   
                    li.setTerms(rs.getInt("terms"));
                    int trm  = rs.getInt("terms");
                    System.out.println("date :"+firstEMiDate +"Loan No :"+loanNo);
                    Date dom =   addMonthsToDate(firstEMiDate, trm);
                   
                    SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
                    String dateofmat = sdf.format(dom);
                    li.setDateOfMaturity(dateofmat);
                    li.setIntrestRate(rs.getString("interest"));
                    li.setDocumentOfSecurtiy(rs.getString("idproof"));
                    
                         
                    lendCustList.add(li);
                }

            } catch (Exception e) {
            	
                e.printStackTrace();
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    
    
    public static Date addMonthsToDate(Date inputDate, int months) {
        if (inputDate == null) {
            return null;
        }
         
        Calendar cal = Calendar.getInstance();
        cal.setTime(inputDate);
        cal.add(Calendar.MONTH, months);
        return cal.getTime();
    }

  
 
    public String getMoneyLender() {
        return moneyLender;
    }

    public void setMoneyLender(String moneyLender) {
        this.moneyLender = moneyLender;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getLicenceNo() {
        return licenceNo;
    }

    public void setLicenceNo(String licenceNo) {
        this.licenceNo = licenceNo;
    }

    public String getLicenceDate() {
        return licenceDate;
    }

    public void setLicenceDate(String licenceDate) {
        this.licenceDate = licenceDate;
    }

    public Date getStartDate() {
        return startDate;
    }

    public void setStartDate(Date startDate) {
        this.startDate = startDate;
    }

    public Date getEndDate() {
        return endDate;
    }

    public void setEndDate(Date endDate) {
        this.endDate = endDate;
    }

    public ArrayList<LoanInfo> getLendCustList() {
        return lendCustList;
    }

    public void setLendCustList(ArrayList<LoanInfo> lendCustList) {
        this.lendCustList = lendCustList;
    }

}
