From 8f5cb469b825cce61734c84fd633f0dfc3000ee6 Mon Sep 17 00:00:00 2001 From: guyue <1721849008@qq.com> Date: 星期二, 08 七月 2025 18:50:01 +0800 Subject: [PATCH] 第三方接口请求数据完成 --- src/main/java/com/linghu/controller/KeywordController.java | 84 +++++++++++++++++++++++++++++++++++------- 1 files changed, 70 insertions(+), 14 deletions(-) diff --git a/src/main/java/com/linghu/controller/KeywordController.java b/src/main/java/com/linghu/controller/KeywordController.java index eabba3a..9b6e913 100644 --- a/src/main/java/com/linghu/controller/KeywordController.java +++ b/src/main/java/com/linghu/controller/KeywordController.java @@ -21,6 +21,7 @@ import javax.servlet.http.HttpServletResponse; import java.io.ByteArrayOutputStream; +import java.util.ArrayList; import java.util.List; @RestController @@ -41,15 +42,17 @@ */ @GetMapping("/statics") @ApiOperation(value = "EChart图") - public ResponseResult<KeywordStaticsListVO> statics(@RequestParam("id") Integer keywordId, @RequestParam(value = "questionId",required = false) Integer questionId) { - return keywordService.statics(keywordId,questionId); + public ResponseResult<KeywordStaticsListVO> statics(@RequestParam("id") Integer keywordId, + @RequestParam(value = "questionId", required = false) Integer questionId) { + return keywordService.statics(keywordId, questionId); } @PostMapping(value = "/exportStatics") @ApiOperation(value = "EChart图导出") - public ResponseEntity<byte[]> exportStatics(@RequestParam("id") Integer keywordId, @RequestParam(value = "questionId",required = false) Integer questionId, HttpServletResponse response) { + public ResponseEntity<byte[]> exportStatics(@RequestParam("id") Integer keywordId, + @RequestParam(value = "questionId", required = false) Integer questionId, HttpServletResponse response) { Keyword keyword = keywordMapper.selectById(keywordId); - List<KeywordStaticsVO> voList = keywordMapper.statics(keywordId,questionId,keyword.getNum()); + List<KeywordStaticsVO> voList = keywordMapper.statics(keywordId, questionId, keyword.getNum()); // 3. 导出Excel ByteArrayOutputStream out = new ByteArrayOutputStream(); @@ -63,24 +66,30 @@ .contentType(MediaType.APPLICATION_OCTET_STREAM) .body(out.toByteArray()); } + /** * 根据类别查看 */ @GetMapping("/getResultByTypeId") @ApiOperation(value = "根据类别查看") - public ResponseResult<List<PlatformProportionVO>> getResultByTypeId(@RequestParam("id") Integer keywordId, @RequestParam(value = "questionId",required = false) Integer questionId, @RequestParam(value = "typeId",required = false) Integer typeId) { - return keywordService.getResultByTypeId(keywordId,questionId,typeId); + public ResponseResult<List<PlatformProportionVO>> getResultByTypeId(@RequestParam("id") Integer keywordId, + @RequestParam(value = "questionId", required = false) Integer questionId, + @RequestParam(value = "typeId", required = false) Integer typeId) { + return keywordService.getResultByTypeId(keywordId, questionId, typeId); } - /** * 导出:根据类别查看 */ @PostMapping(value = "/exportGetResultByTypeId") @ApiOperation(value = "导出:根据类别查看") - public ResponseEntity<byte[]> exportGetResultByTypeId(@RequestParam("id") Integer keywordId, @RequestParam(value = "questionId",required = false) Integer questionId, @RequestParam(value = "typeId",required = false) Integer typeId,@RequestParam(value = "isNow") Integer isNow ) { + public ResponseEntity<byte[]> exportGetResultByTypeId(@RequestParam("id") Integer keywordId, + @RequestParam(value = "questionId", required = false) Integer questionId, + @RequestParam(value = "typeId", required = false) Integer typeId, + @RequestParam(value = "isNow") Integer isNow) { Keyword keyword = keywordService.getById(keywordId); - List<PlatformProportionVO> result = keywordMapper.getResultByTypeId(keywordId, questionId, keyword.getNum() - isNow, typeId); + List<PlatformProportionVO> result = keywordMapper.getResultByTypeId(keywordId, questionId, + keyword.getNum() - isNow, typeId); // 3. 导出Excel ByteArrayOutputStream out = new ByteArrayOutputStream(); EasyExcel.write(out, PlatformProportionVO.class) @@ -99,8 +108,10 @@ */ @GetMapping("/getResultByPlatformId") @ApiOperation(value = "根据平台查看") - public ResponseResult<List<ResultListVO>> getResultByPlatformId(@RequestParam("id") Integer keywordId, @RequestParam(value = "questionId",required = false) Integer questionId, @RequestParam(value = "platformId",required = false) Integer platformId) { - return keywordService.getResultByPlatformId(keywordId,questionId,platformId); + public ResponseResult<List<ResultListVO>> getResultByPlatformId(@RequestParam("id") Integer keywordId, + @RequestParam(value = "questionId", required = false) Integer questionId, + @RequestParam(value = "platformId", required = false) Integer platformId) { + return keywordService.getResultByPlatformId(keywordId, questionId, platformId); } /** @@ -108,9 +119,13 @@ */ @GetMapping("/exportGetResultByPlatformId") @ApiOperation(value = "根据平台查看") - public ResponseEntity<byte[]> exportGetResultByPlatformId(@RequestParam("id") Integer keywordId, @RequestParam(value = "questionId",required = false) Integer questionId, @RequestParam(value = "platformId",required = false) Integer platformId,@RequestParam(value = "isNow") Integer isNow) { + public ResponseEntity<byte[]> exportGetResultByPlatformId(@RequestParam("id") Integer keywordId, + @RequestParam(value = "questionId", required = false) Integer questionId, + @RequestParam(value = "platformId", required = false) Integer platformId, + @RequestParam(value = "isNow") Integer isNow) { Keyword keyword = keywordService.getById(keywordId); - List<ResultListVO> result = keywordMapper.getResultByPlatformId(keywordId, questionId, keyword.getNum() - isNow, platformId); + List<ResultListVO> result = keywordMapper.getResultByPlatformId(keywordId, questionId, keyword.getNum() - isNow, + platformId); // 3. 导出Excel ByteArrayOutputStream out = new ByteArrayOutputStream(); EasyExcel.write(out, ResultListVO.class) @@ -137,13 +152,54 @@ return ResponseResult.success(reference); } - /** * 投喂 */ + /** + * 批量新增关键词 + */ + @PostMapping("/batchAdd") + @ApiOperation(value = "批量新增关键词") + public ResponseResult<String> batchAdd(String keywords, String order_id) { + Boolean saveKeywords = keywordService.saveKeywords(keywords, order_id); + if (saveKeywords) { + return ResponseResult.success("新增成功"); + } else { + return ResponseResult.error("新增失败"); + } + } + /** + * 根据订单ID查询关键词 + */ + @GetMapping("/getKeywordsByOrderId") + @ApiOperation(value = "根据订单ID查询关键词") + public ResponseResult<List<Keyword>> getKeywordsByOrderId(@RequestParam("orderId") String orderId) { + List<Keyword> keywords = keywordService.getKeywordsByOrderId(orderId); + return ResponseResult.success(keywords); + } + + /** + * 修改关键词 + */ + @PostMapping("/updateKeyword") + @ApiOperation(value = "修改关键词") + public ResponseResult<String> updateKeyword(@RequestBody Keyword keyword) { + keywordService.updateById(keyword); + return ResponseResult.success("修改成功"); + } + + /** + * 删除关键词 + */ + @DeleteMapping("/deleteKeyword") + @ApiOperation(value = "删除关键词") + public ResponseResult<String> deleteKeyword(@RequestParam("keywordId") Integer keywordId) { + keywordService.removeById(keywordId); + return ResponseResult.success("删除成功"); + } } -- Gitblit v1.7.1