package HdfcEmandate;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.UUID;
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.DataBaseAutoCompAndDuplicate;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsNaman;
import natch_package.CashfreeDetails;

@ManagedBean(name = "hdfcEmandateBean")
@ViewScoped
public class HdfcEmandateBean implements Serializable {

	private static final long serialVersionUID = 1L;

	private EmandateRequest mandateRequest = new EmandateRequest();

	private String hdfcActionUrl = "https://emandateut.hdfcuat.bank.in/Emandate.aspx";

	private ArrayList<SelectItem> bankCodeList = new ArrayList<>();
	ArrayList<String> list;
	private String loanNo, shareHolderNo;
	ArrayList<SelectItem> loanNumList = new ArrayList<>();
	ArrayList<EmandateRequest> mandateList = new ArrayList<>();

	private DataBaseMethodsNaman dbn = new DataBaseMethodsNaman();

	private boolean subscriptionForm = false;

	String userId = null, branchId = null;

	private boolean sessionValid = true;

	public HdfcEmandateBean() {

	    DebugLogger.log("\n====== HDFC BEAN INIT START ======");

	    try {
	        FacesContext fc = FacesContext.getCurrentInstance();

	        if (fc == null) {
	            DebugLogger.log("FacesContext is NULL");
	            sessionValid = false;
	            return;
	        }

	        HttpSession session = (HttpSession) fc.getExternalContext().getSession(false);

	        if (session != null) {

	            userId = String.valueOf(session.getAttribute("username"));
	            branchId = String.valueOf(session.getAttribute("branchId"));

	            DebugLogger.log("Session found");
	            DebugLogger.log("UserId: " + userId);
	            DebugLogger.log("BranchId: " + branchId);

	        } else {

	            DebugLogger.log("Session is NULL");
	            sessionValid = false;
	        }

	        // Validate user
	        if (userId == null || userId.trim().isEmpty() || "null".equalsIgnoreCase(userId)) {

	            sessionValid = false;

	            DebugLogger.log("User session INVALID");

	            fc.addMessage(null,
	                new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                    "Something Wrong",
	                    "Please login again"));

	        } else {

	            DebugLogger.log("User session VALID");

	        }

	    } catch (Exception e) {

	        sessionValid = false;

	        DebugLogger.log("ERROR in Bean Constructor: " + e.getMessage());
	        e.printStackTrace();
	    }

	    DebugLogger.log("====== HDFC BEAN INIT END ======\n");
	}
	
	public void resetFlow() {

	    System.out.println("Resetting mandate flow...");

	    mandateRequest = new EmandateRequest();

	    loanNo = null;
	    shareHolderNo = null;

	    loanNumList.clear();
	    mandateList.clear();

	    subscriptionForm = false;
	    showMandateSection = false;

	    mandateFromDb = null;
	}
 

    //  MAIN FLOW
    public String prepareRequest() {

        try {
            formatDates();
            generateMsgId();
            forceClean();
            encryptFields();
            generateChecksum();

            String validation = mandateRequest.validate();
            if (!"VALID".equals(validation)) {
                System.out.println("Validation Error: " + validation);
                return null;
            }
            
            boolean saved = dbn.insertEmandateTxn(mandateRequest,branchId,userId,shareHolderNo,loanNo);
            System.out.println("inseret status"+saved);
            if (!saved) 
            {
                System.out.println("DB Insert Failed");
                return null;
            }

            System.out.println(mandateRequest.toString());

          
            String txnId = mandateRequest.getMsgId();

            return "hdfcRedirect?faces-redirect=true&txnId=" + txnId;

        } catch (Exception e) {
            e.printStackTrace();
        }

        return null;
    }
    
   

	private EmandateRequest mandateFromDb;

    public EmandateRequest getMandateData() {

        if (mandateFromDb == null) {

            String txnId = FacesContext.getCurrentInstance()
                    .getExternalContext()
                    .getRequestParameterMap()
                    .get("txnId");

            if (txnId == null || txnId.trim().isEmpty()) {
                System.out.println("Invalid txnId");
                return null;
            }

            mandateFromDb = dbn.getTxnByMsgId(txnId);
            

            if (mandateFromDb == null) {
                System.out.println("No data found for txnId: " + txnId);
            }
        }

        return mandateFromDb;
    }
	
    private boolean showMandateSection = false;

    public boolean isShowMandateSection() {
        return showMandateSection;
    }

    public void goToMandate() {
        showMandateSection = true;
    }

    public void goBack() {
        showMandateSection = false;
    }
    
    
	public List<String> completeText(String name)
	{
		
		list = new ArrayList<String>();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");        
		
		list= (ArrayList<String>) new DataBaseAutoCompAndDuplicate().loanListFromMemberList(branchId, name);
		System.out.println(list.size());
	 	return list;
	 	
	}
   
	

	public void checkTotalLoan() {

	    loanNumList = new ArrayList<>();

	    String input = shareHolderNo;
	    shareHolderNo = extractShareholderNo(input);

	    try (Connection conn = DataBaseConnection.JAVAConnection()) {

	        // PERSONAL LOAN
	        String queryPersonal = "SELECT loanNo FROM personalloan WHERE shareholderno = ? AND status = ?";
	        try (PreparedStatement ps = conn.prepareStatement(queryPersonal)) {
	            ps.setString(1, shareHolderNo);
	            ps.setString(2, "Approve");

	            ResultSet rs = ps.executeQuery();
	            while (rs.next()) {
	                loanNumList.add(new SelectItem(rs.getString("loanNo")));
	            }
	        }

	        // SECURE LOAN
	        String querySecure = "SELECT loanNo FROM secure_loan WHERE shareholderno = ? AND status = ?";
	        try (PreparedStatement ps = conn.prepareStatement(querySecure)) {
	            ps.setString(1, shareHolderNo);
	            ps.setString(2, "Approve");

	            ResultSet rs = ps.executeQuery();
	            while (rs.next()) {
	                loanNumList.add(new SelectItem(rs.getString("loanNo")));
	            }
	        }

	        //  HANDLE CASES
	        if (loanNumList.isEmpty()) {

	            FacesContext.getCurrentInstance().addMessage(null,
	                new FacesMessage(FacesMessage.SEVERITY_ERROR,
	                    "No Active Loan",
	                    "Customer does not have any active loan"));

	        } else if (loanNumList.size() == 1) {

	            //  AUTO FLOW
	            loanNo = (String) loanNumList.get(0).getValue();
	            fetchLoanData();

	        }
	        // else → multiple loans → UI will show dropdown

	    } catch (Exception e) {
	        e.printStackTrace();
	    }
	}
	
public void fetchLoanData() {

    System.out.println("Loan No: " + loanNo);

    if (loanNo == null) {
        System.out.println("Loan No is null!");
        return;
    }

    // 🔹 Decide table safely
    String table;
    if (loanNo.startsWith("PL-")) {
        table = "personalloan";
    } else if (loanNo.startsWith("SL-")) {
        table = "secure_loan";
    } else {
        System.out.println("Unknown Loan Type: " + loanNo);
        return;
    }

    bankCodeList = new DataBaseMethods().fetchBankCodeByNpci();

    // 🔹 Extract shareholder no
    String input = shareHolderNo;
    shareHolderNo = extractShareholderNo(input);
    System.out.println("ShareholderNo :" + shareHolderNo);

    try (Connection conn = DataBaseConnection.JAVAConnection()) {

    	String query;

    	if (loanNo.startsWith("PL-")) {

    	    query = "SELECT l.shareholderno, l.loanNo, " +
    	            "l.app_acc_no, l.app_bank_name, l.app_bank_ifsc, l.emi_due_date, l.frequency, l.terms, emi, " +
    	            "s.first_applicantName, s.mobile, " +
    	            "s.bank_accountNo, s.bank_name, s.bank_ifsc " +
    	            "FROM personalloan l " +
    	            "JOIN shareholder_info s ON l.shareholderno = s.shareholderno " +
    	            "WHERE l.shareholderno = ? AND l.loanNo = ? AND l.status = ?";

    	} else {

    	    query = "SELECT l.shareholderno, l.loanNo, " +
    	            "l.app_acc_no, l.app_bank_name, " +   
    	            "l.emi_due_date, l.frequency, l.terms, emi, " +
    	            "s.first_applicantName, s.mobile, " +
    	            "s.bank_accountNo, s.bank_name, s.bank_ifsc " +
    	            "FROM secure_loan l " +
    	            "JOIN shareholder_info s ON l.shareholderno = s.shareholderno " +
    	            "WHERE l.shareholderno = ? AND l.loanNo = ? AND l.status = ?";
    	}

        try (PreparedStatement ps = conn.prepareStatement(query)) {

            ps.setString(1, shareHolderNo);
            ps.setString(2, loanNo);
            ps.setString(3, "Approve");

            ResultSet rs = ps.executeQuery();

            if (rs.next()) {

                // 🔹 Loan data
                shareHolderNo = rs.getString("shareholderno");
                loanNo = rs.getString("loanNo");
            
                //  Shareholder data (from JOIN)
                mandateRequest.setCustomerName(rs.getString("first_applicantName"));
                mandateRequest.setCustomerMobile(rs.getString("mobile"));
                
                
                String accountNo = rs.getString("app_acc_no");
                if (accountNo == null || accountNo.isEmpty()) {
                    accountNo = rs.getString("bank_accountNo");
                }

                String bankName = rs.getString("app_bank_name");
                if (bankName == null || bankName.isEmpty()) {
                    bankName = rs.getString("bank_name");
                }

                String ifsc = null;

                if (loanNo.startsWith("PL-")) {
                    ifsc = rs.getString("app_bank_ifsc"); // only for PL
                }

                // fallback for both
                if (ifsc == null || ifsc.isEmpty()) {
                    ifsc = rs.getString("bank_ifsc");
                }

                mandateRequest.setCustomerAccountNo(accountNo);
                mandateRequest.setCustomerInstructedMemberId(ifsc.toUpperCase());
                String bankCode = getBankCodeFromIFSC(ifsc);
                

             // Get values directly from DB
                String startDateStr = rs.getString("emi_due_date"); // 2025-07-03

                // Parse date (no formatter needed for ISO format)
                LocalDate startDate = LocalDate.parse(startDateStr);

                // Handle terms safely (since it's 12.0)
                int terms = rs.getBigDecimal("terms").intValue();

                // Add months
                LocalDate expiryDate = startDate.plusMonths(terms);

                // Set values
                mandateRequest.setCustomerStartDate(startDateStr);
                mandateRequest.setCustomerDebitAmount(rs.getBigDecimal("emi"));
                mandateRequest.setCustomerExpiryDate(expiryDate.toString()); // yyyy-MM-dd

                bankCodeList = (ArrayList<SelectItem>) dbn.getNpcibankListFetch(false, RequestType.CREATE);

                for (SelectItem item : bankCodeList) {

                    //  MATCH BANK CODE
                    if (item.getValue() != null && 
                        item.getValue().toString().equalsIgnoreCase(bankCode)) {

                        //  Set value in filler6
                        mandateRequest.setFiller6(item.getValue().toString());

                        System.out.println("Matched Bank → " + item.getLabel());
                        break; // stop loop once found
                    }
                }

                subscriptionForm = true;

            } else {
                subscriptionForm = false;
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

    } catch (Exception e) {
        e.printStackTrace();
    }
}

public String getBankCodeFromIFSC(String ifsc) {
    if (ifsc == null || ifsc.length() < 4) {
        return null;
    }
    return ifsc.substring(0, 4).toUpperCase();
}


    // ================= HELPERS =================

	private String extractShareholderNo(String input) {
	    if (input != null && input.contains("/")) {
	       
	        return input.substring(0, input.indexOf('/')).trim();
	    }
	    return input != null ? input.trim() : null;
	}

    private void formatDates() throws Exception {
        SimpleDateFormat input = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy");
        SimpleDateFormat output = new SimpleDateFormat("yyyy-MM-dd");

        if (mandateRequest.getCustomerStartDate() != null) {
            Date start = input.parse(mandateRequest.getCustomerStartDate());
            mandateRequest.setCustomerStartDate(output.format(start));
        }

        if (mandateRequest.getCustomerExpiryDate() != null) {
            Date end = input.parse(mandateRequest.getCustomerExpiryDate());
            mandateRequest.setCustomerExpiryDate(output.format(end));
        }
        mandateRequest.setMandateReqType("");
        
    }
    
    private String clean(String val) {
        return (val == null || val.trim().equalsIgnoreCase("null")) ? "" : val.trim();
    }
    private void forceClean() {

        mandateRequest.setCustomerEmail(clean(mandateRequest.getCustomerEmail()));
        mandateRequest.setCustomerReference1(clean(mandateRequest.getCustomerReference1()));
        mandateRequest.setCustomerReference2(clean(mandateRequest.getCustomerReference2()));
        
        
        mandateRequest.setFiller1(clean(mandateRequest.getFiller1()));
        mandateRequest.setFiller2(clean(mandateRequest.getFiller2()));
        mandateRequest.setFiller3(clean(mandateRequest.getFiller3()));
        mandateRequest.setFiller4(clean(mandateRequest.getFiller4()));
        mandateRequest.setFiller7(clean(mandateRequest.getFiller7()));
        mandateRequest.setFiller8(clean(mandateRequest.getFiller8()));
        mandateRequest.setFiller9(clean(mandateRequest.getFiller9()));
        mandateRequest.setFiller10(clean(mandateRequest.getFiller10()));

        mandateRequest.setUmrn(clean(mandateRequest.getUmrn()));
    }
   
    private void generateMsgId() {
        String timestamp = new SimpleDateFormat("yyyyMMddHHmmssSSS").format(new Date());
        String random = UUID.randomUUID().toString().replace("-", "").substring(0, 8).toUpperCase();
        mandateRequest.setMsgId(timestamp + random);
    }

    private void encryptFields() {
        mandateRequest.setEncCustomerName(AESUtil.encrypt(mandateRequest.getCustomerName()));
        mandateRequest.setEncCustomerMobile(AESUtil.encrypt(mandateRequest.getCustomerMobile()));
        mandateRequest.setEncCustomerAccountNo(AESUtil.encrypt(mandateRequest.getCustomerAccountNo()));
        mandateRequest.setEncShortCode(AESUtil.encrypt(mandateRequest.getShortCode()));
        mandateRequest.setEncUtilCode(AESUtil.encrypt(mandateRequest.getUtilCode()));
    }

    private void generateChecksum() {

        String checksumData =
                mandateRequest.getCustomerAccountNo() + "|" +
                mandateRequest.getCustomerStartDate() + "|" +
                mandateRequest.getCustomerExpiryDate() + "|" +
                mandateRequest.getCustomerDebitAmount() + "|" +
                (mandateRequest.getCustomerMaxAmount() != null
                        ? mandateRequest.getCustomerMaxAmount()
                        : "");

        String checksum = ChecksumUtil.generateChecksum(checksumData);

        mandateRequest.setCheckSum(checksum);
    }

    // ================= UI LOGIC =================

    public void onSequenceTypeChange() {
        if ("OOFF".equals(mandateRequest.getCustomerSequenceType())) {
            mandateRequest.setCustomerDebitFrequency(null);
        }
    }

    // ================= GETTERS =================

    public EmandateRequest getMandateRequest() {
        return mandateRequest;
    }

    public String getHdfcActionUrl() {
        return hdfcActionUrl;
    }

    public ArrayList<SelectItem> getBankCodeList() {
        return bankCodeList;
    }
    
    public EmandateRequest getMandateFromDb() {
		return mandateFromDb;
	}

	public void setMandateFromDb(EmandateRequest mandateFromDb) {
		this.mandateFromDb = mandateFromDb;
	}
	 public ArrayList<String> getList() {
			return list;
		}

		public void setList(ArrayList<String> list) {
			this.list = list;
		}

		public String getLoanNo() {
			return loanNo;
		}

		public void setLoanNo(String loanNo) {
			this.loanNo = loanNo;
		}

		public String getShareHolderNo() {
			return shareHolderNo;
		}

		public void setShareHolderNo(String shareHolderNo) {
			this.shareHolderNo = shareHolderNo;
		}

		public ArrayList<SelectItem> getLoanNumList() {
			return loanNumList;
		}

		public void setLoanNumList(ArrayList<SelectItem> loanNumList) {
			this.loanNumList = loanNumList;
		}

		public boolean isSubscriptionForm() {
			return subscriptionForm;
		}

		public void setSubscriptionForm(boolean subscriptionForm) {
			this.subscriptionForm = subscriptionForm;
		}

		public boolean isSearchVisible() {
		    return !subscriptionForm;
		}



		public boolean isSessionValid() {
			return sessionValid;
		}



		public void setSessionValid(boolean sessionValid) {
			this.sessionValid = sessionValid;
		}



		public ArrayList<EmandateRequest> getMandateList() {
			return mandateList;
		}



		public void setMandateList(ArrayList<EmandateRequest> mandateList) {
			this.mandateList = mandateList;
		}


		
}