package com.example.rzgb.conversation; import com.example.rzgb.auth.CurrentUser; import com.example.rzgb.common.*; import com.example.rzgb.config.AppProperties; import com.example.rzgb.evidence.EvidenceService; import com.example.rzgb.research.ResearchQuestion; import com.example.rzgb.task.*; import jakarta.validation.Valid; import jakarta.validation.constraints.*; import java.math.BigDecimal; import java.time.*; import java.util.*; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.security.core.Authentication; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.*; /** * 历史会话是消息与独立任务的目录。消息、自动标题和任务引用在同一事务写入,提交后才启动模型。 * 删除会话仅清除本账号消息与目录;已有报告、关注、原文件和收费审计按各自生命周期保留。 */ @RestController @RequestMapping("/api/conversations") public class ConversationController { private final JdbcTemplate jdbc; private final Json json; private final CurrentUser user; private final TaskService tasks; private final AppProperties properties; public ConversationController(JdbcTemplate jdbc,Json json,CurrentUser user,TaskService tasks,AppProperties properties) { this.jdbc=jdbc; this.json=json; this.user=user; this.tasks=tasks; this.properties=properties; } public record NewConversation(@NotNull @Size(max=128) String title) {} public record Rename(@NotBlank @Size(max=128) String title,@Min(1) long version) {} public record Attach(@NotBlank String taskId) {} public record Question(@NotBlank @Size(max=2000) String question,@NotNull SnapshotQa.Scope scope) {} public record ResearchTurn(@NotBlank @Size(max=2000) String question,ResearchQuestion.Entry entry) {} /** 查询覆盖标题及用户问题;转义 LIKE 通配符,百分号和下划线按用户原文搜索。 */ @GetMapping public List> list(Authentication auth,@RequestParam(defaultValue="") String q, @RequestParam(defaultValue="0") int offset) { if(q.length()>128||offset<0) throw new ApiException(400,"INVALID_QUERY","搜索词最多 128 字符,偏移量不能为负数"); String escaped=q.trim().replace("!","!!").replace("%","!%").replace("_","!_"); String pattern="%"+escaped+"%"; return jdbc.queryForList("SELECT c.id,c.title,c.version,c.created_at,c.updated_at FROM conversation c WHERE c.user_id=? AND (c.title LIKE ? ESCAPE '!' OR EXISTS (SELECT 1 FROM conversation_message m WHERE m.conversation_id=c.id AND m.content LIKE ? ESCAPE '!')) ORDER BY c.updated_at DESC,c.id LIMIT 50 OFFSET ?",user.id(auth),pattern,pattern,offset); } @PostMapping @Transactional public Map create(Authentication auth,@Valid @RequestBody NewConversation request) { String owner=user.id(auth),id=UUID.randomUUID().toString(); jdbc.update("INSERT INTO conversation(id,user_id,title,auto_title) VALUES(?,?,?,?)",id,owner,request.title().isBlank()?"新对话":request.title().trim(),request.title().isBlank()); return owned(owner,id,false); } @GetMapping("/{id}") public Map get(Authentication auth,@PathVariable String id) { return owned(user.id(auth),id,false); } @PatchMapping("/{id}") @Transactional public Map rename(Authentication auth,@PathVariable String id,@Valid @RequestBody Rename request) { String owner=user.id(auth); owned(owner,id,true); if(jdbc.update("UPDATE conversation SET title=?,auto_title=FALSE,version=version+1,updated_at=CURRENT_TIMESTAMP WHERE id=? AND version=?",request.title().trim(),id,request.version())!=1) throw new ApiException(409,"VERSION_CONFLICT","会话已更新,请刷新后重命名"); return owned(owner,id,false); } @DeleteMapping("/{id}") @Transactional public Object delete(Authentication auth,@PathVariable String id) { owned(user.id(auth),id,true); jdbc.update("DELETE FROM conversation WHERE id=?",id); return Map.of("deleted",true,"notice","会话及消息已删除;独立任务报告、费用记录、关注和投标原件继续按各自规则保留。"); } @GetMapping("/{id}/messages") public List> messages(Authentication auth,@PathVariable String id) { owned(user.id(auth),id,false); return jdbc.queryForList("SELECT id,role,content,task_id,created_at FROM conversation_message WHERE conversation_id=? ORDER BY created_at,id",id); } /** 显式关联既有调研任务只写目录,不发出外部请求;刷新重试不重复添加消息。 */ @PostMapping("/{id}/tasks") @Transactional public Object attach(Authentication auth,@PathVariable String id,@Valid @RequestBody Attach request) { String owner=user.id(auth); lockOwner(owner); owned(owner,id,true); var task=tasks.get(owner,request.taskId()); var r=json.read(json.write(task.get("request"))); String title=r.path("input").asText(""); if(title.isBlank()&&!r.path("research").path("companies").isEmpty()) { List names=new ArrayList<>(); for(var name:r.path("research").path("companies")) names.add(name.asText()); title=String.join(" / ",names); } if(title.isBlank()) title="区域市场 / 获客检索"; link(id,request.taskId(),title); return owned(owner,id,false); } /** 调研提交时一起写入问题和任务引用。工作线程在事务提交后启动,避免收费后留下空会话。 */ @PostMapping("/{id}/research") @Transactional public Object research(Authentication auth,@PathVariable String id, @RequestHeader("Idempotency-Key") String key,@Valid @RequestBody ResearchTurn turn) { String owner=user.id(auth),question=turn.question().strip(); lockOwner(owner); owned(owner,id,true); // 指纹覆盖用户提交本身。重试时优先回读,避免新消息或北京时间跨日改变已经接受的检索计划。 String fingerprint=EvidenceService.hash("research-turn:"+id+":"+json.write(new ResearchTurn(question,turn.entry()))); var existing=jdbc.queryForList("SELECT id,request_hash FROM agent_task WHERE user_id=? AND idempotency_key=?",owner,key); if(!existing.isEmpty()) { var row=existing.getFirst(); if(!fingerprint.equals(row.get("request_hash"))) throw new ApiException(409,"IDEMPOTENCY_CONFLICT","此提交键已用于其他问题、入口或会话"); return tasks.get(owner,row.get("id").toString()); } var history=jdbc.queryForList("SELECT t.id,t.request_json FROM conversation_message m JOIN agent_task t ON t.id=m.task_id WHERE m.conversation_id=? AND t.user_id=? ORDER BY m.created_at DESC,m.id DESC LIMIT 1",id,owner); String previousId=history.isEmpty()?null:history.getFirst().get("id").toString(); var previous=history.isEmpty()?null:json.convert(history.getFirst().get("request_json").toString(),TaskRequest.class); // 连续追问沿用最近一份原报告,使第三轮仍能使用原主体,或在原市场条件上缩小时间和地区。 if(previous!=null && previous.qa()!=null && previous.qa().reportTaskId()!=null) { previousId=previous.qa().reportTaskId(); String stored=jdbc.queryForObject("SELECT request_json FROM agent_task WHERE id=? AND user_id=?",String.class,previousId,owner); previous=json.convert(stored,TaskRequest.class); } var request=ResearchQuestion.plan(question,turn.entry(),previous,previousId,LocalDate.now(ZoneId.of("Asia/Shanghai")), Math.min(18,properties.maxCalls()),new BigDecimal("10").min(properties.maxCostUnits())); var task=tasks.create(owner,key,request,fingerprint); link(id,task.get("id").toString(),question); return task; } /** 同一幂等键在重试时读回原任务;更换问题、范围或会话均返回冲突,不二次收费。 */ @PostMapping("/{id}/messages") @Transactional public Object ask(Authentication auth,@PathVariable String id, @RequestHeader("Idempotency-Key") String key,@Valid @RequestBody Question question) { String owner=user.id(auth); lockOwner(owner); owned(owner,id,true); var request=new TaskRequest(TaskRequest.Operation.SNAPSHOT_QA,TaskRequest.Workflow.TENDER_SEARCH,question.question().trim(),false,1,new BigDecimal("0.01"),null,null,question.scope()); // 先检查键所属会话,避免同一问题在其他会话误复用同一个任务。 var previous=jdbc.queryForList("SELECT m.conversation_id FROM conversation_message m JOIN agent_task t ON t.id=m.task_id WHERE t.user_id=? AND t.idempotency_key=?",String.class,owner,key); if(!previous.isEmpty()&&!id.equals(previous.getFirst())) throw new ApiException(409,"IDEMPOTENCY_CONFLICT","此提交键已用于其他会话"); var task=tasks.create(owner,key,request); link(id,task.get("id").toString(),question.question().trim()); return task; } private void lockOwner(String owner) { jdbc.queryForObject("SELECT id FROM app_user WHERE id=? FOR UPDATE",String.class,owner); } private void link(String conversation,String task,String content) { var previous=jdbc.queryForList("SELECT conversation_id FROM conversation_message WHERE task_id=?",String.class,task); if(!previous.isEmpty()) { if(!conversation.equals(previous.getFirst())) throw new ApiException(409,"TASK_ALREADY_LINKED","任务已属于另一个会话,请从原会话回查"); return; } jdbc.update("INSERT INTO conversation_message(id,conversation_id,role,content,task_id) VALUES(?,?,'user',?,?)",UUID.randomUUID().toString(),conversation,content,task); // 首个问题自动生成纯文本标题;人工命名后不再被后续消息覆盖。 String title=content.replaceAll("[\\p{Cntrl}]"," ").strip(); title=title.substring(0,title.offsetByCodePoints(0,Math.min(60,title.codePointCount(0,title.length())))); jdbc.update("UPDATE conversation SET title=CASE WHEN auto_title=TRUE THEN ? ELSE title END,auto_title=FALSE,version=version+1,updated_at=CURRENT_TIMESTAMP WHERE id=?",title,conversation); } private Map owned(String owner,String id,boolean lock) { var rows=jdbc.queryForList("SELECT id,title,version,created_at,updated_at FROM conversation WHERE id=? AND user_id=?"+(lock?" FOR UPDATE":""),id,owner); if(rows.isEmpty()) throw new ApiException(404,"NOT_FOUND","会话不存在"); return rows.getFirst(); } }