package org.dromara.eims.controller;
|
|
import java.io.IOException;
|
import java.io.InputStream;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URLEncoder;
|
import java.util.List;
|
|
import jakarta.servlet.ServletOutputStream;
|
import lombok.RequiredArgsConstructor;
|
import jakarta.servlet.http.HttpServletResponse;
|
import jakarta.validation.constraints.*;
|
import cn.dev33.satoken.annotation.SaCheckPermission;
|
import org.springframework.core.io.ClassPathResource;
|
import org.springframework.http.MediaType;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.validation.annotation.Validated;
|
import org.dromara.common.idempotent.annotation.RepeatSubmit;
|
import org.dromara.common.log.annotation.Log;
|
import org.dromara.common.web.core.BaseController;
|
import org.dromara.common.mybatis.core.page.PageQuery;
|
import org.dromara.common.core.domain.R;
|
import org.dromara.common.core.validate.AddGroup;
|
import org.dromara.common.core.validate.EditGroup;
|
import org.dromara.common.log.enums.BusinessType;
|
import org.dromara.common.excel.utils.ExcelUtil;
|
import org.dromara.eims.domain.vo.EimsInspectPlanVo;
|
import org.dromara.eims.domain.bo.EimsInspectPlanBo;
|
import org.dromara.eims.service.IEimsInspectPlanService;
|
import org.dromara.common.mybatis.core.page.TableDataInfo;
|
import org.springframework.web.multipart.MultipartFile;
|
|
/**
|
* 点检计划
|
*
|
* @author zhuguifei
|
* @date 2025-03-12
|
*/
|
@Validated
|
@RequiredArgsConstructor
|
@RestController
|
@RequestMapping("/eims/inspectPlan")
|
public class EimsInspectPlanController extends BaseController {
|
|
private final IEimsInspectPlanService eimsInspectPlanService;
|
|
/**
|
* 查询点检计划列表
|
*/
|
@SaCheckPermission("eims:inspectPlan:list")
|
@GetMapping("/list")
|
public TableDataInfo<EimsInspectPlanVo> list(EimsInspectPlanBo bo, PageQuery pageQuery) {
|
// return eimsInspectPlanService.queryPageList(bo, pageQuery);
|
return eimsInspectPlanService.queryPageListCustom(bo, pageQuery);
|
}
|
|
/**
|
* 导出点检计划列表
|
*/
|
@SaCheckPermission("eims:inspectPlan:export")
|
@Log(title = "点检计划", businessType = BusinessType.EXPORT)
|
@PostMapping("/export")
|
public void export(EimsInspectPlanBo bo, HttpServletResponse response) {
|
List<EimsInspectPlanVo> list = eimsInspectPlanService.queryList(bo);
|
ExcelUtil.exportExcel(list, "点检计划", EimsInspectPlanVo.class, response);
|
}
|
|
/**
|
* 获取点检计划详细信息
|
*
|
* @param id 主键
|
*/
|
@SaCheckPermission("eims:inspectPlan:query")
|
@GetMapping("/{id}")
|
public R<EimsInspectPlanVo> getInfo(@NotNull(message = "主键不能为空")
|
@PathVariable Long id) {
|
return R.ok(eimsInspectPlanService.queryById(id));
|
}
|
|
/**
|
* 新增点检计划
|
*/
|
@SaCheckPermission("eims:inspectPlan:add")
|
@Log(title = "点检计划", businessType = BusinessType.INSERT)
|
@RepeatSubmit()
|
@PostMapping()
|
public R<Void> add(@Validated(AddGroup.class) @RequestBody EimsInspectPlanBo bo) {
|
return toAjax(eimsInspectPlanService.insertByBo(bo));
|
}
|
|
/**
|
* 修改点检计划
|
*/
|
@SaCheckPermission("eims:inspectPlan:edit")
|
@Log(title = "点检计划", businessType = BusinessType.UPDATE)
|
@RepeatSubmit()
|
@PutMapping()
|
public R<Void> edit(@Validated(EditGroup.class) @RequestBody EimsInspectPlanBo bo) {
|
return toAjax(eimsInspectPlanService.updateByBo(bo));
|
}
|
|
/**
|
* 删除点检计划
|
*
|
* @param ids 主键串
|
*/
|
@SaCheckPermission("eims:inspectPlan:remove")
|
@Log(title = "点检计划", businessType = BusinessType.DELETE)
|
@DeleteMapping("/{ids}")
|
public R<Void> remove(@NotEmpty(message = "主键不能为空")
|
@PathVariable Long[] ids) {
|
return toAjax(eimsInspectPlanService.deleteWithValidByIds(List.of(ids), true));
|
}
|
|
/**
|
* 导入数据
|
*
|
* @param file 导入文件
|
* @param updateSupport 是否更新已存在数据
|
*/
|
@Log(title = "点检计划", businessType = BusinessType.IMPORT)
|
@SaCheckPermission("eims:inspectPlan:import")
|
@PostMapping(value = "/importData", consumes = MediaType.MULTIPART_FORM_DATA_VALUE)
|
public R<Void> importData(@RequestPart("files") List<MultipartFile> files, boolean updateSupport) throws Exception {
|
StringBuilder successMsg = new StringBuilder();
|
for (MultipartFile file : files) {
|
String res = eimsInspectPlanService.importData(file, updateSupport);
|
successMsg.append(res).append(";");
|
}
|
return R.ok(successMsg.toString());
|
}
|
|
/**
|
* 获取导入模板
|
*/
|
@PostMapping("/importTemplate")
|
public void importTemplate(HttpServletResponse response) throws UnsupportedEncodingException {
|
// 设置响应类型
|
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
|
response.setCharacterEncoding("utf-8");
|
|
// 设置文件名
|
String fileName = URLEncoder.encode("点检计划导入模板", "UTF-8");
|
response.setHeader("Content-Disposition",
|
"attachment;filename=" + fileName + ".xlsx");
|
|
// 读取模板文件
|
ClassPathResource templateResource = new ClassPathResource("template/dj.xlsx");
|
try (InputStream inputStream = templateResource.getInputStream();
|
ServletOutputStream outputStream = response.getOutputStream()) {
|
|
// 流拷贝
|
byte[] buffer = new byte[1024];
|
int bytesRead;
|
while ((bytesRead = inputStream.read(buffer)) != -1) {
|
outputStream.write(buffer, 0, bytesRead);
|
}
|
} catch (IOException e) {
|
throw new RuntimeException("模板文件读取失败", e);
|
}
|
}
|
}
|