ChatController.java 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643
  1. package com.pharmacopoeia.controller;
  2. import com.pharmacopoeia.config.QwenProperties;
  3. import com.pharmacopoeia.dto.ChatRequest;
  4. import com.pharmacopoeia.dto.FeedbackRequest;
  5. import com.pharmacopoeia.dto.ImageChatRequest;
  6. import com.pharmacopoeia.dto.MultimodalChatRequest;
  7. import com.pharmacopoeia.service.*;
  8. import org.springframework.http.MediaType;
  9. import org.springframework.http.ResponseEntity;
  10. import org.springframework.http.codec.ServerSentEvent;
  11. import org.springframework.web.bind.annotation.*;
  12. import reactor.core.publisher.Flux;
  13. import reactor.core.publisher.Sinks;
  14. import org.springframework.jdbc.core.JdbcTemplate;
  15. import org.springframework.web.multipart.MultipartFile;
  16. import java.util.*;
  17. import java.util.regex.Matcher;
  18. import java.util.regex.Pattern;
  19. import java.util.stream.Collectors;
  20. @RestController
  21. @RequestMapping("/api/v1/chat")
  22. public class ChatController {
  23. // 复用 PromptService.SECTION_DISPLAY 统一权威映射,避免两处重复定义导致不一致
  24. private final RetrieverService retrieverService;
  25. private final LLMService llmService;
  26. private final PromptService promptService;
  27. private final ChatPersistenceService persistenceService;
  28. private final RerankerService rerankerService;
  29. private final JdbcTemplate jdbc;
  30. private final QwenProperties props;
  31. public ChatController(RetrieverService rs, LLMService ls, PromptService ps,
  32. ChatPersistenceService cps, RerankerService rrs,
  33. JdbcTemplate jdbc, QwenProperties props) {
  34. this.retrieverService = rs;
  35. this.llmService = ls;
  36. this.promptService = ps;
  37. this.persistenceService = cps;
  38. this.rerankerService = rrs;
  39. this.jdbc = jdbc;
  40. this.props = props;
  41. }
  42. @PostMapping("/ask")
  43. public ResponseEntity<Map<String, Object>> chatAsk(@RequestBody ChatRequest request) {
  44. String query = request.getMessage();
  45. String cid = request.getConversationId() != null && !request.getConversationId().isBlank()
  46. ? request.getConversationId()
  47. : UUID.randomUUID().toString();
  48. String intent = retrieverService.classifyIntent(query);
  49. List<Map<String, Object>> docs = retrieverService.search(query, intent, 20);
  50. docs = rerankerService.rerank(docs, query, 5);
  51. // 统一:LLM 回答 + 原文对照
  52. List<Map<String, String>> messages = promptService.buildPrompt(query, docs, intent);
  53. String llmAnswer = cleanAnswer(llmService.chat(messages));
  54. String answer = llmAnswer;
  55. List<Map<String, Object>> sources = buildSources(docs);
  56. persistenceService.saveMessage(cid, "user", query, intent, null);
  57. persistenceService.saveMessage(cid, "assistant", answer, intent, sources);
  58. return ResponseEntity.ok(Map.of(
  59. "answer", answer,
  60. "sources", sources,
  61. "intent", intent,
  62. "conversation_id", cid
  63. ));
  64. }
  65. @PostMapping(value = "/stream", produces = MediaType.TEXT_EVENT_STREAM_VALUE)
  66. public Flux<ServerSentEvent<String>> chatStream(@RequestBody ChatRequest request) {
  67. String query = request.getMessage();
  68. final String cid = request.getConversationId() != null && !request.getConversationId().isBlank()
  69. ? request.getConversationId()
  70. : UUID.randomUUID().toString();
  71. final String intent = retrieverService.classifyIntent(query);
  72. final List<Map<String, Object>> docs = rerankerService.rerank(retrieverService.search(query, intent, 20), query, 5);
  73. Sinks.Many<ServerSentEvent<String>> sink = Sinks.many().unicast().onBackpressureBuffer();
  74. try {
  75. sink.tryEmitNext(ServerSentEvent.<String>builder().event("intent").data(intent).build());
  76. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status").data("Retrieving...").build());
  77. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status").data("Matched " + docs.size() + " records, generating...").build());
  78. final List<Map<String, String>> messages = promptService.buildPrompt(query, docs, intent);
  79. StringBuilder fullAnswer = new StringBuilder();
  80. llmService.chatStream(messages)
  81. .doOnNext(token -> {
  82. fullAnswer.append(token);
  83. sink.tryEmitNext(ServerSentEvent.<String>builder().data(token).build());
  84. })
  85. .doOnComplete(() -> {
  86. final List<Map<String, Object>> sources = buildSources(docs);
  87. try {
  88. String meta = new com.fasterxml.jackson.databind.ObjectMapper().writeValueAsString(Map.of(
  89. "intent", intent,
  90. "sources", sources,
  91. "conversation_id", cid
  92. ));
  93. sink.tryEmitNext(ServerSentEvent.<String>builder().event("meta").data(meta).build());
  94. } catch (Exception ignored) {}
  95. String finalAnswer = cleanAnswer(fullAnswer.toString());
  96. persistenceService.saveMessage(cid, "user", query, intent, null);
  97. persistenceService.saveMessage(cid, "assistant", finalAnswer, intent, sources);
  98. sink.tryEmitComplete();
  99. })
  100. .doOnError(e -> sink.tryEmitError(e))
  101. .subscribe();
  102. } catch (Exception e) {
  103. sink.tryEmitError(e);
  104. }
  105. return sink.asFlux();
  106. }
  107. // ============================================================
  108. // 图片对话 API(Qwen VL 分析 + OCR → RAG 检索 → 联网搜索)
  109. // ============================================================
  110. @PostMapping("/ask-image")
  111. public ResponseEntity<Map<String, Object>> chatAskImage(@RequestBody ImageChatRequest request) {
  112. String cid = request.getConversationId() != null && !request.getConversationId().isBlank()
  113. ? request.getConversationId()
  114. : UUID.randomUUID().toString();
  115. // Step 1: Qwen VL 分析图片 + OCR 提取文字
  116. String ocrText = llmService.analyzeImage(
  117. request.getImageBase64(), request.getMimeType(),
  118. "请分析这张图片,提取其中所有文字信息(OCR),特别是药品名称、成分、用法用量等关键药学信息。简要输出即可。");
  119. // Step 2: 拼接查询 → RAG 检索
  120. String query = (!request.getMessage().isBlank())
  121. ? request.getMessage() + "\n\n(图片OCR提取内容:" + ocrText + ")"
  122. : ocrText;
  123. String intent = retrieverService.classifyIntent(query);
  124. List<Map<String, Object>> docs = retrieverService.search(query, intent, 20);
  125. docs = rerankerService.rerank(docs, query, 5);
  126. // Step 3: 构建 Prompt(含图片分析上下文)+ 联网搜索
  127. List<Map<String, String>> messages = promptService.buildPrompt(query, docs, intent);
  128. String imageContext = "\n\n【图片分析结果】\n" + ocrText + "\n";
  129. messages.get(0).put("content", messages.get(0).get("content") + imageContext);
  130. String llmAnswer = cleanAnswer(llmService.chat(messages, true));
  131. String answer = llmAnswer;
  132. List<Map<String, Object>> sources = buildSources(docs);
  133. persistenceService.saveMessage(cid, "user",
  134. request.getMessage().isBlank() ? "[图片]" : "[图片] " + request.getMessage(),
  135. intent, null);
  136. persistenceService.saveMessage(cid, "assistant", answer, intent, sources);
  137. return ResponseEntity.ok(Map.of(
  138. "answer", answer,
  139. "sources", sources,
  140. "intent", intent,
  141. "conversation_id", cid
  142. ));
  143. }
  144. @PostMapping(value = "/stream-image", produces = MediaType.TEXT_EVENT_STREAM_VALUE)
  145. public Flux<ServerSentEvent<String>> chatStreamImage(@RequestBody ImageChatRequest request) {
  146. final String cid = request.getConversationId() != null && !request.getConversationId().isBlank()
  147. ? request.getConversationId()
  148. : UUID.randomUUID().toString();
  149. Sinks.Many<ServerSentEvent<String>> sink = Sinks.many().unicast().onBackpressureBuffer();
  150. // 校验图片数据
  151. if (request.getImageBase64() == null || request.getImageBase64().isBlank()) {
  152. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status").data("图片数据为空,请重新上传").build());
  153. sink.tryEmitComplete();
  154. return sink.asFlux();
  155. }
  156. try {
  157. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status").data("正在分析图片(OCR 文字识别)...").build());
  158. // Step 1: Qwen VL 分析图片
  159. StringBuilder ocrBuilder = new StringBuilder();
  160. llmService.analyzeImageStream(request.getImageBase64(), request.getMimeType(),
  161. "请分析这张图片,提取其中所有文字信息(OCR),特别是药品名称、成分、用法用量等。简要输出。")
  162. .doOnNext(ocrBuilder::append)
  163. .doOnComplete(() -> {
  164. String ocrText = ocrBuilder.toString();
  165. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status").data("图片分析完成,正在检索药典知识库...").build());
  166. // Step 2: 拼接查询 → RAG
  167. String query = (!request.getMessage().isBlank())
  168. ? request.getMessage() + "\n\n(图片OCR提取内容:" + ocrText + ")"
  169. : ocrText;
  170. final String intent = retrieverService.classifyIntent(query);
  171. sink.tryEmitNext(ServerSentEvent.<String>builder().event("intent").data(intent).build());
  172. final List<Map<String, Object>> docs = rerankerService.rerank(retrieverService.search(query, intent, 20), query, 5);
  173. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status")
  174. .data("已匹配 " + docs.size() + " 条药典资料,生成回答中(已启用联网搜索)...").build());
  175. // Step 3: 构建 Prompt + 联网搜索流式生成
  176. final List<Map<String, String>> messages = promptService.buildPrompt(query, docs, intent);
  177. String imageContext = "\n\n【图片分析结果】\n" + ocrText + "\n";
  178. messages.get(0).put("content", messages.get(0).get("content") + imageContext);
  179. StringBuilder fullAnswer = new StringBuilder();
  180. llmService.chatStream(messages, true)
  181. .doOnNext(token -> {
  182. fullAnswer.append(token);
  183. sink.tryEmitNext(ServerSentEvent.<String>builder().data(token).build());
  184. })
  185. .doOnComplete(() -> {
  186. final List<Map<String, Object>> sources = buildSources(docs);
  187. try {
  188. String meta = new com.fasterxml.jackson.databind.ObjectMapper().writeValueAsString(Map.of(
  189. "intent", intent,
  190. "sources", sources,
  191. "conversation_id", cid,
  192. "ocr_text", ocrText
  193. ));
  194. sink.tryEmitNext(ServerSentEvent.<String>builder().event("meta").data(meta).build());
  195. } catch (Exception ignored) {}
  196. String finalAnswer = cleanAnswer(fullAnswer.toString());
  197. persistenceService.saveMessage(cid, "user",
  198. request.getMessage().isBlank() ? "[图片]" : "[图片] " + request.getMessage(),
  199. intent, null);
  200. persistenceService.saveMessage(cid, "assistant", finalAnswer, intent, sources);
  201. sink.tryEmitComplete();
  202. })
  203. .doOnError(sink::tryEmitError)
  204. .subscribe();
  205. })
  206. .doOnError(sink::tryEmitError)
  207. .subscribe();
  208. } catch (Exception e) {
  209. sink.tryEmitError(e);
  210. }
  211. return sink.asFlux();
  212. }
  213. // ============================================================
  214. // 统一多模态对话 API(文本 + 图片 + 视频)
  215. // ============================================================
  216. @PostMapping("/ask-multimodal")
  217. public ResponseEntity<Map<String, Object>> chatAskMultimodal(@RequestBody MultimodalChatRequest request) {
  218. String cid = request.getConversationId() != null && !request.getConversationId().isBlank()
  219. ? request.getConversationId()
  220. : UUID.randomUUID().toString();
  221. // Step 1: 媒体分析(如果有附件)
  222. String ocrText = "";
  223. String mediaLabel = "";
  224. if (request.getMediaBase64() != null && !request.getMediaBase64().isBlank()
  225. && request.getMediaType() != null && !request.getMediaType().isBlank()) {
  226. mediaLabel = "video".equals(request.getMediaType()) ? "视频" : "图片";
  227. ocrText = llmService.analyzeMedia(
  228. request.getMediaBase64(), request.getMediaType(),
  229. request.getMediaMime(), "");
  230. }
  231. // Step 2: 拼接查询
  232. String query = request.getMessage() != null ? request.getMessage().trim() : "";
  233. if (!query.isEmpty() && !ocrText.isEmpty()) {
  234. query = query + "\n\n(" + mediaLabel + "OCR提取内容:" + ocrText + ")";
  235. } else if (!ocrText.isEmpty()) {
  236. query = ocrText;
  237. } else if (query.isEmpty()) {
  238. query = "请介绍一下自己";
  239. }
  240. // Step 3: RAG 检索
  241. String intent = retrieverService.classifyIntent(query);
  242. List<Map<String, Object>> docs = retrieverService.search(query, intent, 20);
  243. docs = rerankerService.rerank(docs, query, 5);
  244. // Step 4: 构建 Prompt + 联网搜索
  245. List<Map<String, String>> messages = promptService.buildPrompt(query, docs, intent);
  246. if (!ocrText.isEmpty()) {
  247. messages.get(0).put("content",
  248. messages.get(0).get("content") + "\n\n【" + mediaLabel + "分析结果】\n" + ocrText + "\n");
  249. }
  250. boolean enableSearch = !ocrText.isEmpty() || props.isEnableWebSearch();
  251. String llmAnswer = cleanAnswer(llmService.chat(messages, enableSearch));
  252. String answer = llmAnswer;
  253. List<Map<String, Object>> sources = buildSources(docs);
  254. String userMsg = !request.getMessage().isBlank() ? request.getMessage()
  255. : !ocrText.isEmpty() ? "[" + mediaLabel + "]" : request.getMessage();
  256. persistenceService.saveMessage(cid, "user", userMsg, intent, null);
  257. persistenceService.saveMessage(cid, "assistant", answer, intent, sources);
  258. return ResponseEntity.ok(Map.of(
  259. "answer", answer,
  260. "sources", sources,
  261. "intent", intent,
  262. "conversation_id", cid
  263. ));
  264. }
  265. @PostMapping(value = "/stream-multimodal", produces = MediaType.TEXT_EVENT_STREAM_VALUE)
  266. public Flux<ServerSentEvent<String>> chatStreamMultimodal(@RequestBody MultimodalChatRequest request) {
  267. final String cid = request.getConversationId() != null && !request.getConversationId().isBlank()
  268. ? request.getConversationId()
  269. : UUID.randomUUID().toString();
  270. final boolean hasMedia = request.getMediaBase64() != null && !request.getMediaBase64().isBlank()
  271. && request.getMediaType() != null && !request.getMediaType().isBlank();
  272. final String mediaLabel = hasMedia && "video".equals(request.getMediaType()) ? "视频" : "图片";
  273. Sinks.Many<ServerSentEvent<String>> sink = Sinks.many().unicast().onBackpressureBuffer();
  274. try {
  275. if (hasMedia) {
  276. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status")
  277. .data("🔍 正在分析" + mediaLabel + "...").build());
  278. // 先发 OCR section header
  279. sink.tryEmitNext(ServerSentEvent.<String>builder()
  280. .data("【📷 " + mediaLabel + "分析】\n\n").build());
  281. StringBuilder ocrBuilder = new StringBuilder();
  282. llmService.analyzeMediaStream(request.getMediaBase64(), request.getMediaType(),
  283. request.getMediaMime(), "")
  284. .doOnNext(token -> {
  285. ocrBuilder.append(token);
  286. sink.tryEmitNext(ServerSentEvent.<String>builder().data(token).build());
  287. })
  288. .doOnComplete(() -> {
  289. sink.tryEmitNext(ServerSentEvent.<String>builder().data("\n\n").build());
  290. doStreamAnswer(sink, cid, request, ocrBuilder.toString(), mediaLabel);
  291. })
  292. .doOnError(sink::tryEmitError)
  293. .subscribe();
  294. } else {
  295. doStreamAnswer(sink, cid, request, "", "");
  296. }
  297. } catch (Exception e) {
  298. sink.tryEmitError(e);
  299. }
  300. return sink.asFlux();
  301. }
  302. // ============================================================
  303. // 文件上传 API(multipart → base64 → 复用已有对话管线)
  304. // ============================================================
  305. @PostMapping("/upload-image")
  306. public ResponseEntity<Map<String, Object>> uploadImage(
  307. @RequestParam("file") MultipartFile file,
  308. @RequestParam(defaultValue = "") String message,
  309. @RequestParam(defaultValue = "") String conversationId) {
  310. // 校验 MIME 类型
  311. Set<String> allowed = Set.of("image/jpeg", "image/png", "image/webp", "image/bmp");
  312. String contentType = file.getContentType();
  313. if (contentType == null || !allowed.contains(contentType)) {
  314. throw new IllegalArgumentException(
  315. "不支持的图片格式: " + contentType + ",支持 jpg/png/webp/bmp");
  316. }
  317. // 校验大小 ≤ 10MB
  318. if (file.getSize() > 10 * 1024 * 1024) {
  319. throw new IllegalArgumentException("图片大小不能超过 10MB");
  320. }
  321. // 转 base64 → 委托给 ask-image
  322. String base64;
  323. try {
  324. base64 = Base64.getEncoder().encodeToString(file.getBytes());
  325. } catch (Exception e) {
  326. throw new RuntimeException("读取上传文件失败", e);
  327. }
  328. ImageChatRequest req = new ImageChatRequest();
  329. req.setImageBase64(base64);
  330. req.setMimeType(contentType);
  331. req.setMessage(message);
  332. req.setConversationId(
  333. conversationId.isBlank() ? UUID.randomUUID().toString() : conversationId);
  334. return chatAskImage(req);
  335. }
  336. @PostMapping("/upload-media")
  337. public ResponseEntity<Map<String, Object>> uploadMedia(
  338. @RequestParam("file") MultipartFile file,
  339. @RequestParam(defaultValue = "") String message,
  340. @RequestParam(defaultValue = "") String conversationId) {
  341. String contentType = file.getContentType();
  342. if (contentType == null) {
  343. throw new IllegalArgumentException("无法识别的媒体类型");
  344. }
  345. String mediaType;
  346. long maxSize;
  347. if (contentType.startsWith("image/")) {
  348. mediaType = "image";
  349. maxSize = 10 * 1024 * 1024; // 10MB
  350. } else if (contentType.startsWith("video/")) {
  351. mediaType = "video";
  352. maxSize = 50 * 1024 * 1024; // 50MB
  353. } else {
  354. throw new IllegalArgumentException(
  355. "不支持的媒体格式: " + contentType + ",支持 jpg/png/webp/bmp/mp4/mov/avi/webm");
  356. }
  357. if (file.getSize() > maxSize) {
  358. throw new IllegalArgumentException(
  359. "文件大小不能超过 " + (maxSize / 1024 / 1024) + "MB");
  360. }
  361. String base64;
  362. try {
  363. base64 = Base64.getEncoder().encodeToString(file.getBytes());
  364. } catch (Exception e) {
  365. throw new RuntimeException("读取上传文件失败", e);
  366. }
  367. MultimodalChatRequest req = new MultimodalChatRequest();
  368. req.setMessage(message);
  369. req.setMediaType(mediaType);
  370. req.setMediaBase64(base64);
  371. req.setMediaMime(contentType);
  372. req.setConversationId(
  373. conversationId.isBlank() ? UUID.randomUUID().toString() : conversationId);
  374. return chatAskMultimodal(req);
  375. }
  376. /** 流式多模态:OCR 完成后,走 RAG + 生成 */
  377. private void doStreamAnswer(Sinks.Many<ServerSentEvent<String>> sink, String cid,
  378. MultimodalChatRequest request, String ocrText, String mediaLabel) {
  379. if (!ocrText.isEmpty()) {
  380. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status")
  381. .data("📚 检索药典知识库...").build());
  382. }
  383. String query = request.getMessage() != null ? request.getMessage().trim() : "";
  384. if (!query.isEmpty() && !ocrText.isEmpty()) {
  385. query = query + "\n\n(" + mediaLabel + "OCR提取内容:" + ocrText + ")";
  386. } else if (!ocrText.isEmpty()) {
  387. query = ocrText;
  388. } else if (query.isEmpty()) {
  389. query = "请介绍一下自己";
  390. }
  391. final String intent = retrieverService.classifyIntent(query);
  392. sink.tryEmitNext(ServerSentEvent.<String>builder().event("intent").data(intent).build());
  393. final List<Map<String, Object>> docs = rerankerService.rerank(retrieverService.search(query, intent, 20), query, 5);
  394. final boolean enableSearch = !ocrText.isEmpty() || props.isEnableWebSearch();
  395. sink.tryEmitNext(ServerSentEvent.<String>builder().event("status")
  396. .data("已匹配 " + docs.size() + " 条药典资料,生成回答中"
  397. + (enableSearch ? "(已启用联网搜索)" : "") + "...").build());
  398. final List<Map<String, String>> messages = promptService.buildPrompt(query, docs, intent);
  399. if (!ocrText.isEmpty()) {
  400. messages.get(0).put("content",
  401. messages.get(0).get("content") + "\n\n【" + mediaLabel + "分析结果】\n" + ocrText + "\n");
  402. }
  403. // 发送回答 section header
  404. sink.tryEmitNext(ServerSentEvent.<String>builder().data("\n【📚 药典参考回答】\n\n").build());
  405. StringBuilder fullAnswer = new StringBuilder();
  406. llmService.chatStream(messages, enableSearch)
  407. .doOnNext(token -> {
  408. fullAnswer.append(token);
  409. sink.tryEmitNext(ServerSentEvent.<String>builder().data(token).build());
  410. })
  411. .doOnComplete(() -> {
  412. final List<Map<String, Object>> sources = buildSources(docs);
  413. try {
  414. String meta = new com.fasterxml.jackson.databind.ObjectMapper().writeValueAsString(Map.of(
  415. "intent", intent, "sources", sources, "conversation_id", cid,
  416. "ocr_text", ocrText));
  417. sink.tryEmitNext(ServerSentEvent.<String>builder().event("meta").data(meta).build());
  418. } catch (Exception ignored) {}
  419. String finalAnswer = cleanAnswer(fullAnswer.toString());
  420. String userMsg = !request.getMessage().isBlank() ? request.getMessage()
  421. : !ocrText.isEmpty() ? "[" + mediaLabel + "]" : "";
  422. persistenceService.saveMessage(cid, "user", userMsg, intent, null);
  423. persistenceService.saveMessage(cid, "assistant", finalAnswer, intent, sources);
  424. sink.tryEmitComplete();
  425. })
  426. .doOnError(sink::tryEmitError)
  427. .subscribe();
  428. }
  429. @GetMapping("/history")
  430. public ResponseEntity<Map<String, Object>> getHistory(
  431. @RequestParam(defaultValue = "1") int page,
  432. @RequestParam(defaultValue = "20") int pageSize) {
  433. // getHistory 现在直接返回包含 items/page/page_size/total/total_pages 的 Map
  434. var result = persistenceService.getHistory(page, pageSize);
  435. return ResponseEntity.ok(result);
  436. }
  437. @GetMapping("/history/{cid}")
  438. public ResponseEntity<Map<String, Object>> getConversationDetail(@PathVariable String cid) {
  439. var msgs = persistenceService.getConversationDetail(cid);
  440. return ResponseEntity.ok(Map.of("conversation_id", cid, "messages", msgs));
  441. }
  442. @PostMapping("/feedback")
  443. public ResponseEntity<Map<String, Object>> submitFeedback(@RequestBody FeedbackRequest request) {
  444. persistenceService.updateFeedback(request.getMessageId(), request.getFeedback());
  445. return ResponseEntity.ok(Map.of("status", "ok"));
  446. }
  447. @GetMapping("/admin/conversations")
  448. public ResponseEntity<Map<String, Object>> adminListConversations(
  449. @RequestParam(defaultValue = "1") int page,
  450. @RequestParam(defaultValue = "20") int pageSize,
  451. @RequestParam(required = false) String keyword) {
  452. int offset = (page - 1) * pageSize;
  453. StringBuilder sql = new StringBuilder("""
  454. SELECT DISTINCT ON (c.conversation_id)
  455. c.conversation_id, c.title, c.created_at,
  456. m.content AS last_msg, m.role
  457. FROM conversations c
  458. JOIN messages m ON m.conversation_id = c.conversation_id
  459. """);
  460. List<Object> params = new ArrayList<>();
  461. if (keyword != null && !keyword.isBlank()) {
  462. sql.append("WHERE m.content ILIKE ? ");
  463. params.add("%" + keyword + "%");
  464. }
  465. sql.append("""
  466. ORDER BY c.conversation_id, m.created_at DESC
  467. LIMIT ? OFFSET ?
  468. """);
  469. params.add(pageSize);
  470. params.add(offset);
  471. List<Map<String, Object>> items = jdbc.queryForList(
  472. sql.toString(), params.toArray());
  473. return ResponseEntity.ok(Map.of(
  474. "items", items,
  475. "page", page,
  476. "page_size", pageSize
  477. ));
  478. }
  479. private List<Map<String, Object>> buildSources(List<Map<String, Object>> docs) {
  480. Set<String> seen = new HashSet<>();
  481. return docs.stream()
  482. .filter(d -> {
  483. String key = d.getOrDefault("name", "") + "|" + d.getOrDefault("section", "");
  484. return seen.add(key);
  485. })
  486. .limit(8) // 去重后最多 8 条,覆盖更多栏目
  487. .map(d -> {
  488. String content = (String) d.getOrDefault("content", "");
  489. String drugName = (String) d.getOrDefault("name", "");
  490. String storedSection = (String) d.getOrDefault("section", "");
  491. String sourceVersion = (String) d.getOrDefault("source_version", "");
  492. String sourceVolume = (String) d.getOrDefault("source_volume", "");
  493. String category = (String) d.getOrDefault("category", "");
  494. // 优先用 DB 元数据,回退到内容解析
  495. if (drugName == null || drugName.isEmpty()) {
  496. drugName = extractDrugName(content);
  497. }
  498. String sectionDisplay = PromptService.SECTION_DISPLAY.getOrDefault(storedSection, storedSection);
  499. if (sectionDisplay == null || sectionDisplay.isEmpty()) {
  500. sectionDisplay = realSection(content, storedSection);
  501. }
  502. // 构建完整来源引用
  503. StringBuilder sourceBuilder = new StringBuilder();
  504. if (!sourceVersion.isEmpty()) sourceBuilder.append(sourceVersion);
  505. if (!sourceVolume.isEmpty()) {
  506. if (!sourceBuilder.isEmpty()) sourceBuilder.append(" ");
  507. sourceBuilder.append(sourceVolume);
  508. }
  509. String fullSource = sourceBuilder.toString();
  510. content = content.replaceAll("\\s*来源:.*$", "");
  511. content = content.replaceAll("[\\r\\n]+", " ").trim();
  512. String excerpt = content.length() > 500 ? content.substring(0, 500) + "…" : content;
  513. return Map.<String, Object>of(
  514. "drug_id", d.getOrDefault("drug_id", ""),
  515. "name", drugName,
  516. "section", sectionDisplay,
  517. "category", category != null ? category : "",
  518. "source", fullSource,
  519. "excerpt", excerpt
  520. );
  521. })
  522. .collect(Collectors.toList());
  523. }
  524. private String extractDrugName(String content) {
  525. if (content == null) return "";
  526. int start = content.indexOf("【");
  527. int end = content.indexOf(" - ");
  528. if (start >= 0 && end > start) {
  529. return content.substring(start + 1, end);
  530. }
  531. return content.length() > 20 ? content.substring(0, 20) : content;
  532. }
  533. /** 从 content 文本中提取真实 section(兜底"正文") */
  534. private String realSection(String content, String storedSection) {
  535. if (!"正文".equals(storedSection) || content == null) return storedSection;
  536. int sep = content.indexOf(" - ");
  537. if (sep < 0) return storedSection;
  538. int end = content.indexOf("】", sep);
  539. if (end > sep) {
  540. return content.substring(sep + 3, end).trim();
  541. }
  542. return storedSection;
  543. }
  544. private String cleanAnswer(String text) {
  545. if (text == null) return "";
  546. // 去除多余空白行(保留单个换行),修复 Qwen 常见格式问题
  547. return text
  548. .replace("\r\n", "\n")
  549. .replaceAll("\\n{3,}", "\n\n")
  550. .trim();
  551. }
  552. }