package HdfcEmandate;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.temporal.ChronoUnit;
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.text.DecimalFormat;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodsNaman;

@ManagedBean(name = "HdfcEmandateDataBean")
@ViewScoped
public class HdfcEmandateDataBean implements Serializable {

    private static final long serialVersionUID = 1L;

    private List<EmandateRequest> mandateList = new ArrayList<>();

    private EmandateRequest selectedMandate;

    private DataBaseMethodsNaman dbn =
            new DataBaseMethodsNaman();
    
    

    public HdfcEmandateDataBean() {

        mandateList = gethdfcmandateList();

    }
    
    
    public boolean validateSelectedMandate() {

        try {

            // Load from Flash scope if null
            if (selectedMandate == null) {

                selectedMandate = (EmandateRequest)
                        FacesContext.getCurrentInstance()
                        .getExternalContext()
                        .getFlash()
                        .get("selectedMandate");
            }

            // Still null → redirect
            if (selectedMandate == null) {

                FacesContext.getCurrentInstance()
                        .getExternalContext()
                        .redirect("hdfcMandateList.xhtml");

                return false;
            }

            return true;

        } catch (Exception e) {

            e.printStackTrace();
        }

        return false;
    }
    // =========================================================
    // VIEW DETAILS
    // =========================================================

    public String viewMandate(
            EmandateRequest m) {

        FacesContext.getCurrentInstance()
                .getExternalContext()
                .getFlash()
                .put("selectedMandate", m);

        return "hdfcMandateDetails?faces-redirect=true";
    }

    public EmandateRequest getSelectedMandate() {

        if (selectedMandate == null) {

            Object obj =
                    FacesContext.getCurrentInstance()
                            .getExternalContext()
                            .getFlash()
                            .get("selectedMandate");

            if (obj != null) {

                selectedMandate =
                        (EmandateRequest) obj;
            }
        }

        return selectedMandate;
    }

    public void setSelectedMandate(
            EmandateRequest selectedMandate) {

        this.selectedMandate =
                selectedMandate;
    }

    // =========================================================
    // EDIT / AMEND
    // =========================================================

    public String editMandate(
            EmandateRequest mandate) {

        return processMandate(
                mandate,
                "Amend",
                false);
    }

    // =========================================================
    // REACTIVATE / REVOKE
    // =========================================================

    public String reactivateMandate(
            EmandateRequest mandate) {

        return processMandate(
                mandate,
                "Revoke",
                true);
    }

    // =========================================================
    // CANCEL
    // =========================================================

    public String cancelMandate(
            EmandateRequest mandate) {

        return processMandate(
                mandate,
                "Cancel",
                true);
    }

    // =========================================================
    // PAUSE / SUSPEND
    // =========================================================

    public String pauseMandate(
            EmandateRequest mandate) {

        return processMandate(
                mandate,
                "Suspend",
                true);
    }

    // =========================================================
    // COMMON PROCESSOR
    // =========================================================

    private String processMandate(
            EmandateRequest mandate,
            String operation,
            boolean clearFields) {

        if (clearFields) {
        	
            clearMandateFields(mandate);
        }

        return processMandateOperation(
                mandate,
                operation);
    }

    // =========================================================
    // CLEAR MANAGE FIELDS
    // =========================================================

    private void clearMandateFields(
            EmandateRequest mandate) {

        mandate.setCustomerStartDate("");
        mandate.setCustomerExpiryDate("");

        mandate.setCustomerDebitAmount(null);
        mandate.setCustomerMaxAmount(null);

        mandate.setCustomerDebitFrequency("");
        mandate.setCustomerSequenceType("");
    }

    // =========================================================
    // GET MANDATE REQUEST
    // =========================================================

    public EmandateRequest getMandateRequest() {

        try {

            Object obj =
                    FacesContext.getCurrentInstance()
                            .getExternalContext()
                            .getSessionMap()
                            .get("MANDATE_REQUEST");

            if (obj != null) {

                return (EmandateRequest) obj;
            }

        } catch (Exception e) {

            e.printStackTrace();
        }

        return new EmandateRequest();
    }

    // =========================================================
    // PROCESS OPERATION
    // =========================================================

    private String processMandateOperation(
            EmandateRequest mandate,
            String operation) {

        try {

            if (mandate == null) {

                System.out.println(
                        "Mandate object is NULL");

                return null;
            }

            /*
             * Generate new MsgId
             */
            generateMsgId(mandate);

            /*
             * Set mandate request type
             */
            mandate.setMandateReqType(
                    operation);

          
            /*
             * HDFC reserved fillers
             */
            mandate.setFiller9("");
            mandate.setFiller10("");

            /*
             * Generate checksum
             */
            generateChecksum(mandate);

            /*
             * DEBUG
             */
            System.out.println(
                    "FINAL MsgId : "
                    + mandate.getMsgId());

            System.out.println(
                    "FINAL Operation : "
                    + mandate.getMandateReqType());

            System.out.println(
                    "FINAL UMRN : "
                    + mandate.getUmrn());

            System.out.println(
                    "FINAL ShortCode : "
                    + mandate.getEncShortCode());

            System.out.println(
                    "FINAL UtilCode : "
                    + mandate.getEncUtilCode());

            System.out.println(
                    "FINAL IFSC : "
                    + mandate.getCustomerInstructedMemberId());

            System.out.println(
                    "FINAL CHECKSUM : "
                    + mandate.getCheckSum());

            /*
             * Store in session
             */
            FacesContext.getCurrentInstance()
                    .getExternalContext()
                    .getSessionMap()
                    .put("MANDATE_REQUEST",
                            mandate);

            /*
             * Redirect
             */
            return "hdfcManageRedirect?faces-redirect=true";

        } catch (Exception e) {

            e.printStackTrace();
        }

        return null;
    }

    // =========================================================
    // GENERATE MSG ID
    // =========================================================

    private void generateMsgId(
            EmandateRequest mandate) {

        String timestamp =
                new SimpleDateFormat(
                        "yyyyMMddHHmmssSSS")
                        .format(new Date());

        String random =
                UUID.randomUUID()
                        .toString()
                        .replace("-", "")
                        .substring(0, 8)
                        .toUpperCase();

        mandate.setMsgId(
                timestamp + random);

        System.out.println(
                "NEW MSG ID : "
                + mandate.getMsgId());
    }

    // =========================================================
    // GENERATE CHECKSUM
    // =========================================================
 
 private void generateChecksum(
         EmandateRequest mandate) {

     try {

         String checksumData =

                 safe(mandate.getCustomerAccountNo()) + "|" +

                 safe(mandate.getCustomerStartDate()) + "|" +

                 safe(mandate.getCustomerExpiryDate()) + "|" +

                 (
                         mandate.getCustomerDebitAmount() != null
                                 ? mandate.getCustomerDebitAmount().toPlainString()
                                 : ""
                 ) + "|" +

                 (
                         mandate.getCustomerMaxAmount() != null
                                 ? mandate.getCustomerMaxAmount().toPlainString()
                                 : ""
                 );

         System.out.println(
                 "CHECKSUM DATA : "
                 + checksumData);

         String checksum =
                 ChecksumUtil.generateChecksum(
                         checksumData);

         mandate.setCheckSum(checksum);

         System.out.println(
                 "GENERATED CHECKSUM : "
                 + checksum);

     } catch (Exception e) {

         e.printStackTrace();
     }
 }
 
    // =========================================================
    // SAFE STRING
    // =========================================================

    private String safe(String value) {

        return value != null
                ? value.trim()
                : "";
    }

    // =========================================================
    // FETCH MANDATE LIST
    // =========================================================

    public List<EmandateRequest> gethdfcmandateList() {

        List<EmandateRequest> list =
                new ArrayList<>();

        String query =
                "SELECT * FROM hdfc_emandates ORDER BY id DESC";

        try (
                Connection conn =
                        DataBaseConnection.JAVAConnection();

                PreparedStatement psmt =
                        conn.prepareStatement(query);

                ResultSet rs =
                        psmt.executeQuery()
        ) {

            while (rs.next()) {

                EmandateRequest obj =
                        new EmandateRequest();

                obj.setLoanNo(
                        rs.getString("loan_no"));

                obj.setId(
                        rs.getLong("id"));
                obj.setBranchId(rs.getString("branch_id"));
                obj.setUserId(rs.getString("user_id"));

                obj.setMsgId(
                        rs.getString("msg_id"));

                obj.setUmrn(
                        rs.getString("umrn"));

                obj.setRefId(
                        rs.getString("ref_id"));

                obj.setCustomerName(
                        rs.getString("customer_name"));

                obj.setCustomerMobile(
                        rs.getString("customer_mobile"));

                obj.setCustomerEmail(
                        rs.getString("customer_email"));

                obj.setCustomerAccountNo(
                        rs.getString("customer_account_no"));

                obj.setEncCustomerName(
                        rs.getString("enc_customer_name"));

                obj.setEncCustomerMobile(
                        rs.getString("enc_customer_mobile"));

                obj.setEncCustomerEmail(
                        rs.getString("enc_customer_email"));
               
                obj.setChannel(rs.getString("channel"));
                obj.setCustomerDebitFrequency(rs.getString("frequency"));
                obj.setCustomerSequenceType(rs.getString("sequence_type"));

                obj.setEncCustomerAccountNo(
                        rs.getString("enc_customer_account_no"));

                obj.setEncShortCode(
                        rs.getString("enc_short_code"));

                obj.setEncUtilCode(
                        rs.getString("enc_util_code"));

                obj.setCustomerInstructedMemberId(
                        rs.getString("ifsc_code"));

                if (rs.getDate("start_date") != null) {

                    obj.setCustomerStartDate(
                            rs.getDate("start_date")
                                    .toString());
                }

                if (rs.getDate("expiry_date") != null) {

                    obj.setCustomerExpiryDate(
                            rs.getDate("expiry_date")
                                    .toString());
                }
                
                obj.setCheckSum(rs.getString("checksum"));
                obj.setBankCode(rs.getString("bank_code"));

                obj.setCustomerDebitAmount(
                        rs.getBigDecimal("debit_amount"));

                obj.setCustomerMaxAmount(
                        rs.getBigDecimal("max_amount"));

                obj.setStatus(
                        "Success".equalsIgnoreCase(
                                rs.getString("status"))
                                ? "ACTIVE"
                                : rs.getString("status"));

                obj.setErrorCode(
                        rs.getString("error_code"));

                obj.setErrorMessage(
                        rs.getString("error_message"));
                obj.setCreatedAt(rs.getString("created_at"));
                obj.setUpdatedAt(rs.getString("updated_at"));
                obj.setTerms(
                	    calculateTerms(
                	        obj.getCustomerStartDate(),
                	        obj.getCustomerExpiryDate(),
                	        obj.getCustomerDebitFrequency(),
                	        obj.getCustomerSequenceType()
                	    )
                	);

                	obj.setRepaymentSchedule(
                	    getRepaymentSchedule(
                	        obj.getCustomerDebitAmount(),
                	        obj.getCustomerDebitFrequency(),
                	        obj.getTerms(),
                	        obj.getCustomerSequenceType()
                	    )
                	);


                list.add(obj);
            }

        } catch (Exception e) {

            e.printStackTrace();
        }

        return list;
    }
    
    public String getRepaymentSchedule(BigDecimal amount,
            String frequency,
            String terms,
            String sequenceType) {

if ("OOFF".equals(sequenceType)) {
return "One-time payment";
}

String freqText = "";
String termText = "";

switch (frequency) {

case "DAIL":
freqText = "day";
termText = "days";
break;

case "WEEK":
freqText = "week";
termText = "weeks";
break;

case "MNTH":
freqText = "month";
termText = "months";
break;

case "BIMN":
freqText = "2 months";
termText = "cycles";
break;

case "QURT":
freqText = "quarter";
termText = "quarters";
break;

case "MIAN":
freqText = "6 months";
termText = "cycles";
break;

case "YEAR":
freqText = "year";
termText = "years";
break;

default:
freqText = "period";
termText = "times";
}

DecimalFormat df = new DecimalFormat("#,##0");

return "₹"
+ df.format(amount)
+ " every "
+ freqText
+ " for "
+ terms
+ " "
+ termText;
}
    
    public String calculateTerms(String startDate,
            String expiryDate,
            String frequency,
				            String sequenceType) {
				
				try {
				
				if ("OOFF".equals(sequenceType)) {
				return "1";
				}
				
				LocalDate start = LocalDate.parse(startDate);
				LocalDate end = LocalDate.parse(expiryDate);
				
				long terms = 0;
				
				switch (frequency) {
				
				case "DAIL":
				terms = ChronoUnit.DAYS.between(start, end);
				break;
				
				case "WEEK":
				terms = ChronoUnit.WEEKS.between(start, end);
				break;
				
				case "MNTH":
				terms = ChronoUnit.MONTHS.between(start, end);
				break;
				
				case "BIMN":
				terms = ChronoUnit.MONTHS.between(start, end) / 2;
				break;
				
				case "QURT":
				terms = ChronoUnit.MONTHS.between(start, end) / 3;
				break;
				
				case "MIAN":
				terms = ChronoUnit.MONTHS.between(start, end) / 6;
				break;
				
				case "YEAR":
				terms = ChronoUnit.YEARS.between(start, end);
				break;
				
				default:
				return "-";
				}
				
				return String.valueOf(terms);
				
				} catch (Exception e) {
				return "-";
				}
				}
    // =========================================================
    // GETTERS / SETTERS
    // =========================================================

    public List<EmandateRequest> getMandateList() {

        return mandateList;
    }

    public void setMandateList(
            List<EmandateRequest> mandateList) {

        this.mandateList = mandateList;
    }
}