package com.platform.controller; import com.alibaba.excel.EasyExcel; import com.platform.model.dto.ExcelTemplateDTO; import com.platform.model.dto.WhiteDTO; import com.platform.model.entity.WhiteEntity; import com.platform.model.resp.Result; import com.platform.model.vo.ExcelTemplateVO; import com.platform.model.vo.WhiteVO; import com.platform.page.TableDataInfo; import com.platform.service.WhiteService; import com.platform.utils.DozerUtils; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.net.URLEncoder; import java.util.List; /** * @author : wujipeng * @date : 2025/7/30 17:37 * @Version: 1.0 * @Desc : 描述信息 */ @Api(tags = "白名单") @RestController @RequestMapping("/white") public class WhiteController extends BaseController { @Resource private WhiteService whiteService; @ApiOperation(value = "分页") @PostMapping("/page") public TableDataInfo page(@RequestBody WhiteDTO whiteDTO) { startPage(whiteDTO.getPageNum(), whiteDTO.getPageSize()); return getDataTable(whiteService.pageWhite(whiteDTO)); } @ApiOperation(value = "详情") @GetMapping("/{id}") public Result detail(@PathVariable Integer id) { return Result.data(DozerUtils.convertBean(whiteService.getById(id), WhiteVO.class)); } @ApiOperation(value = "新增") @PostMapping("/save") public Result save(@RequestBody WhiteDTO whiteDTO) { return Result.data(whiteService.saveWhite(whiteDTO)); } @ApiOperation(value = "批量删除") @DeleteMapping("/delete") public Result delete(@RequestParam(name = "ids") List ids) { return Result.data(whiteService.removeBatchByIds(ids)); } @ApiOperation(value = "导出") @PostMapping("/export") public void exportExcel(HttpServletResponse response, @RequestBody WhiteDTO whiteDTO) throws IOException { // 设置响应头 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); String fileName = URLEncoder.encode("白名单", "UTF-8").replaceAll("\\+", "%20"); response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); // 查询数据 startPage(whiteDTO.getPageNum(), whiteDTO.getPageSize()); List list = whiteService.exportExcel(whiteDTO); // 写入Excel EasyExcel.write(response.getOutputStream(), WhiteVO.class) .sheet("白名单") .doWrite(list); } @ApiOperation("导入") @PostMapping("/import") public Result importExcel(@RequestParam("file") MultipartFile file) throws IOException { // 读取Excel List list = EasyExcel.read(file.getInputStream()) .head(WhiteEntity.class) .sheet() .doReadSync(); // 保存数据 whiteService.importExcel(list); return Result.data("导入成功,共导入 " + list.size() + " 条数据"); } }