package com.ruoyi.web.controller.api;
|
|
|
import cn.afterturn.easypoi.excel.ExcelExportUtil;
|
import cn.afterturn.easypoi.excel.entity.ExportParams;
|
import com.google.common.collect.Lists;
|
import com.ruoyi.common.core.domain.R;
|
import com.ruoyi.system.dto.asset.AssetAdMaterialSporadicSettlementDTO;
|
import com.ruoyi.system.export.AssetAdMaterialSporadicSettlementImport;
|
import com.ruoyi.system.service.AssetAdMaterialSporadicSettlementService;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import lombok.RequiredArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.springframework.context.annotation.Lazy;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestPart;
|
import org.springframework.web.bind.annotation.RestController;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletResponse;
|
import javax.validation.Valid;
|
import java.io.IOException;
|
import java.net.URLEncoder;
|
|
/**
|
* <p>
|
* 广告物料零星结算表 前端控制器
|
* </p>
|
*
|
* @author mitao
|
* @since 2025-10-17
|
*/
|
@Slf4j
|
@Validated
|
@Api(tags = {"广告物料零星结算相关接口"})
|
@RestController
|
@RequestMapping("/asset-ad-material-sporadic-settlement")
|
@RequiredArgsConstructor(onConstructor_ = {@Lazy})
|
public class AssetAdMaterialSporadicSettlementController {
|
|
private final AssetAdMaterialSporadicSettlementService assetAdMaterialSporadicSettlementService;
|
|
@ApiOperation("下载导入模板")
|
@GetMapping("/template")
|
public void downloadTemplate(HttpServletResponse response) {
|
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), AssetAdMaterialSporadicSettlementImport.class,
|
Lists.newArrayList(new AssetAdMaterialSporadicSettlementImport()));
|
ServletOutputStream outputStream = null;
|
try {
|
String fileName = URLEncoder.encode("广告物料零星结算导入模板.xls", "utf-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
|
response.setHeader("content-Type", "application/vnd.ms-excel");
|
response.setHeader("Pragma", "no-cache");
|
response.setHeader("Cache-Control", "no-cache");
|
outputStream = response.getOutputStream();
|
workbook.write(outputStream);
|
} catch (IOException e) {
|
log.error("房屋巡检导入模板下载失败!", e);
|
} finally {
|
try {
|
outputStream.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
|
@ApiOperation("导入零星资产结算数据")
|
@PostMapping("/import")
|
public R<?> importData(@RequestPart("file") MultipartFile file, @Valid AssetAdMaterialSporadicSettlementDTO dto) {
|
assetAdMaterialSporadicSettlementService.importData(file, dto);
|
return R.ok();
|
}
|
|
}
|
