package com.talentcard.server.business.payment;
|
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.stereotype.Service;
|
|
/**
|
* Ledger for money facts that disagree with local state.
|
*
|
* <p>A callback or a provider query may describe a payment that local business rules refuse to
|
* accept: another merchant, another amount, another order, a cancelled order or a payment whose
|
* merchant binding is missing. Those cases must never be silently dropped and never auto-fulfil the
|
* order, so every one of them is recorded as an open row an administrator can inspect.
|
*/
|
@Service
|
public class PaymentIssueRecorder {
|
|
static final String PROVIDER = "HUIFU";
|
|
private final JdbcTemplate jdbc;
|
|
public PaymentIssueRecorder(JdbcTemplate jdbc) {
|
this.jdbc = jdbc;
|
}
|
|
public void issue(String type, String businessNo, String orderNo, String expected, String actual, long amount, String message) {
|
jdbc.update("""
|
insert into payment_reconciliation_issue(issue_type, provider, business_no, order_no, expected_status, actual_status, amount, detail_message)
|
values (?, ?, ?, ?, ?, ?, ?, ?)
|
on duplicate key update detected_at = now(), expected_status = values(expected_status), actual_status = values(actual_status), amount = values(amount), detail_message = values(detail_message)
|
""", type, PROVIDER, businessNo, emptyToNull(orderNo), emptyToNull(expected), emptyToNull(actual), amount, truncate(message));
|
}
|
|
public void resolve(String type, String businessNo, String by) {
|
jdbc.update("update payment_reconciliation_issue set status = 'resolved', resolved_at = now(), resolved_by = ? where issue_type = ? and provider = ? and business_no = ? and status = 'open'", by, type, PROVIDER, businessNo);
|
}
|
|
private String emptyToNull(String value) { return value == null || value.isBlank() ? null : value; }
|
|
private String truncate(String value) { if (value == null) return ""; return value.length() > 500 ? value.substring(0, 500) : value; }
|
}
|
