package cn.gistack.sm.sjztdw.controller;
|
|
import cn.gistack.sm.sjztdw.excel.DbExcel;
|
import cn.gistack.sm.sjztdw.excel.DbExcelImport;
|
import cn.gistack.sm.sjztdw.service.IDbPersonReportService;
|
import lombok.AllArgsConstructor;
|
import org.springblade.core.boot.ctrl.BladeController;
|
import org.springblade.core.excel.util.ExcelUtil;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.core.tool.utils.StringUtil;
|
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.RestController;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
* 大坝人工上报相关接口
|
*/
|
@RestController
|
@RequestMapping("/sjztdw/dbReport")
|
@AllArgsConstructor
|
public class DbPersonReportController extends BladeController {
|
|
private IDbPersonReportService dbPersonReportService;
|
|
/**
|
* 导入模板
|
*/
|
@GetMapping("export-template")
|
public void exportTemplate(HttpServletResponse response) {
|
List<DbExcel> list = new ArrayList<>();
|
|
for (int i = 0; i < 10; i++) {
|
DbExcel dbExcel = new DbExcel();
|
dbExcel.setMonitorDate(StringUtil.format("2024-03-{}",10+i));
|
list.add(dbExcel);
|
}
|
ExcelUtil.export(response, "人工上报模板", "人工上报数据表", list, DbExcel.class);
|
}
|
|
|
/**
|
* 导入数据
|
* @param file 导入excel
|
* @param resGuid 水库id
|
* @param ch 断面
|
* @return
|
*/
|
@PostMapping("import-data")
|
public R importData(MultipartFile file,String resGuid,String ch) {
|
DbExcelImport dbExcelImport = new DbExcelImport(dbPersonReportService,resGuid,ch);
|
ExcelUtil.save(file, dbExcelImport, DbExcel.class);
|
return R.success("操作成功");
|
}
|
|
|
|
|
}
|
