PublicImportController.java 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. package com.kcim.web;
  2. import com.kcim.common.util.Result;
  3. import com.kcim.service.KpiComputeImportService;
  4. import com.kcim.vo.SheetImportResultVO;
  5. import io.swagger.annotations.Api;
  6. import io.swagger.annotations.ApiOperation;
  7. import lombok.AllArgsConstructor;
  8. import lombok.extern.slf4j.Slf4j;
  9. import org.springframework.web.bind.annotation.*;
  10. import org.springframework.web.multipart.MultipartFile;
  11. import java.util.List;
  12. /**
  13. * @program: CostAccount
  14. * @description:
  15. * @author: Wang.YS
  16. * @create: 2024-06-03 13:57
  17. **/
  18. @Slf4j
  19. @Api(tags = "成本公用导入controller")
  20. @RestController
  21. @RequestMapping("import")
  22. @AllArgsConstructor
  23. public class PublicImportController {
  24. KpiComputeImportService service;
  25. @ApiOperation("查询导入列表")
  26. @GetMapping("list")
  27. public Result getList(@RequestParam(name = "current",defaultValue = "1",required = false) Integer current,
  28. @RequestParam(name = "pageSize",defaultValue = "10",required = false) Integer pageSize,
  29. @RequestParam(required = false) String computeDate,
  30. @RequestParam(required = false) String tableName){
  31. return Result.ok(service.getList(current,pageSize,computeDate,tableName));
  32. }
  33. @ApiOperation("获取导入表名")
  34. @GetMapping("getTableList")
  35. public Result getTableList(){
  36. return Result.ok(service.getTableList());
  37. }
  38. @ApiOperation("导入数据")
  39. @PostMapping()
  40. public Result importData(@RequestPart("computeDate")String computeDate,
  41. @RequestPart String tableName,
  42. @RequestPart("file") MultipartFile file){
  43. service.importData(computeDate,tableName,file);
  44. return Result.ok();
  45. }
  46. @ApiOperation("撤销导入")
  47. @PostMapping("removeImport")
  48. public Result removeImport(@RequestParam Integer id){
  49. service.removeImport(id);
  50. return Result.ok();
  51. }
  52. @ApiOperation("复原导入")
  53. @PostMapping("recoverImport")
  54. public Result recoverImport(@RequestParam Integer id){
  55. service.recoverImport(id);
  56. return Result.ok();
  57. }
  58. @ApiOperation("批量导入数据")
  59. @PostMapping("importMultipleSheets")
  60. public Result importMultipleSheets(@RequestPart("computeDate")String computeDate,
  61. @RequestPart("file") MultipartFile file){
  62. List<SheetImportResultVO> sheetImportResultVOS = service.importMultipleSheets(computeDate, file);
  63. return Result.ok(sheetImportResultVOS);
  64. }
  65. }