package com.example.rzgb.evidence; import com.example.rzgb.common.*; import java.net.URI; import java.nio.charset.StandardCharsets; import java.security.*; import java.sql.ResultSet; import java.sql.SQLException; import java.util.*; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Service; import tools.jackson.databind.JsonNode; /** * 借鉴证据准入的思路,由服务端验证引用,不能由模型自己声称“已有来源”。 * 证据绑定真实完成的同任务工具调用;来源、摘录及原始快照共同计算哈希。 * 哈希用于发现存储变化,不证明发布网站内容真实,也不是具备外部签名的防篡改审计。 */ @Service public class EvidenceService { private final JdbcTemplate jdbc; private final Json json; public EvidenceService(JdbcTemplate jdbc, Json json) { this.jdbc = jdbc; this.json = json; } public String record(String task, String call, String url, String locator, String title, String excerpt, JsonNode snapshot) { if (jdbc.queryForObject("SELECT COUNT(*) FROM tool_call WHERE id=? AND task_id=? AND status='SUCCEEDED'", Integer.class, call, task) != 1) throw new ApiException(409, "EVIDENCE_SCOPE_MISMATCH", "证据必须来自当前任务中已完成的真实请求"); String id = UUID.randomUUID().toString(); String source = safeUrl(url), position = trim(locator,256), name = trim(title,512), quote = trim(excerpt,2000); String raw = json.write(snapshot); String digest = digest(source, position, name, quote, raw); jdbc.update("INSERT INTO evidence(id,task_id,tool_call_id,source_url,locator,excerpt,source_title,source_type,content_hash,source_snapshot) VALUES(?,?,?,?,?,?,?,'PUBLIC_RECORD',?,?)", id, task, call, source, position, quote, name, digest, raw); return id; } /** 返回展示所需的最少信息,不把完整供应商响应或私有字段泄露到来源列表中。 */ public List> list(String task) { return jdbc.query("SELECT e.*,t.status AS call_status,t.task_id AS call_task FROM evidence e JOIN tool_call t ON t.id=e.tool_call_id WHERE e.task_id=? AND (e.source_type IS NULL OR e.source_type<>'GENERATED_DRAFT') ORDER BY e.created_at,e.id", (rs,n) -> { String stored = rs.getString("content_hash"), url = rs.getString("source_url"); boolean verified = verified(rs, task); Map item = new LinkedHashMap<>(); item.put("id", rs.getString("id")); item.put("url", safeUrl(url)); item.put("locator", rs.getString("locator")); item.put("excerpt", rs.getString("excerpt")); item.put("title", rs.getString("source_title")); item.put("toolCallId", rs.getString("tool_call_id")); item.put("contentHash", stored); item.put("verified", verified); return item; }, task); } /** 批量取出通过校验的原始事实,仅供后端重建报告,避免逐条引用产生 N+1 查询。 */ public Map verifiedSnapshots(String task) { Map sources = new HashMap<>(); jdbc.query("SELECT e.*,t.status AS call_status,t.task_id AS call_task FROM evidence e JOIN tool_call t ON t.id=e.tool_call_id WHERE e.task_id=?", (org.springframework.jdbc.core.RowCallbackHandler) rs -> { if (verified(rs,task)) sources.put(rs.getString("id"), json.read(rs.getString("source_snapshot"))); }, task); return sources; } private boolean verified(ResultSet rs, String task) throws SQLException { String raw = rs.getString("source_snapshot"), stored = rs.getString("content_hash"), url = rs.getString("source_url"); return raw != null && stored != null && task.equals(rs.getString("call_task")) && "SUCCEEDED".equals(rs.getString("call_status")) && Objects.equals(url, safeUrl(url)) && stored.equals(digest(url, rs.getString("locator"), rs.getString("source_title"), rs.getString("excerpt"), raw)); } /** 报告发布前逐一检查引用;未知、跨任务或变化过的证据均不能作为已核验事实。 */ public void requireVerified(String task, Collection references) { Map verified = new HashMap<>(); for (var item : list(task)) verified.put(item.get("id").toString(), Boolean.TRUE.equals(item.get("verified"))); if (references.stream().anyMatch(id -> id == null || !Boolean.TRUE.equals(verified.get(id)))) throw new ApiException(409, "EVIDENCE_INVALID", "报告引用不存在、超出当前任务或内容已变化,请重新核验来源"); } private String digest(String url, String locator, String title, String excerpt, String raw) { Map fields = new LinkedHashMap<>(); fields.put("url", url); fields.put("locator", locator); fields.put("title", title); fields.put("excerpt", excerpt); fields.put("snapshot", raw); return hash(json.write(fields)); } public static String hash(String value) { try { return HexFormat.of().formatHex(MessageDigest.getInstance("SHA-256").digest(value.getBytes(StandardCharsets.UTF_8))); } catch (NoSuchAlgorithmException e) { throw new IllegalStateException(e); } } private static String trim(String value, int size) { return value == null ? "" : value.substring(0, Math.min(size,value.length())); } /** 这里只验证展示链接,不访问 DNS,也不修改供应商返回的签名参数。网页抓取另走安全检查。 */ public static String safeUrl(String value) { if (value == null || value.isBlank()) return null; try { URI uri = URI.create(value); if (!Set.of("http", "https").contains(Objects.toString(uri.getScheme(), "").toLowerCase(Locale.ROOT)) || uri.getHost() == null || uri.getUserInfo() != null || uri.getHost().equalsIgnoreCase("localhost") || uri.getHost().equals("127.0.0.1") || uri.getHost().equals("[::1]")) return null; return value; } catch (IllegalArgumentException e) { return null; } } }