ChatController.java 30 KB

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