From fd1211cd8d25526bfc4039bfa6547c7859e399bb Mon Sep 17 00:00:00 2001 From: zmk <496160012@qq.com> Date: 星期五, 21 六月 2024 12:40:36 +0800 Subject: [PATCH] 提交代码 --- javaweb-plus/javaweb-cms/src/main/java/com/javaweb/geo/service/impl/HoleServiceImpl.java | 34 +++++++++++++++++++++++++++++----- 1 files changed, 29 insertions(+), 5 deletions(-) diff --git a/javaweb-plus/javaweb-cms/src/main/java/com/javaweb/geo/service/impl/HoleServiceImpl.java b/javaweb-plus/javaweb-cms/src/main/java/com/javaweb/geo/service/impl/HoleServiceImpl.java index b7422a6..405098b 100644 --- a/javaweb-plus/javaweb-cms/src/main/java/com/javaweb/geo/service/impl/HoleServiceImpl.java +++ b/javaweb-plus/javaweb-cms/src/main/java/com/javaweb/geo/service/impl/HoleServiceImpl.java @@ -182,13 +182,34 @@ return "瀵煎叆瀹屾瘯" ; } + /** + * 鎬昏繘搴� + * @return + */ + @Override + public Hole selectHoleTotalProcess() { + return holeMapper.selectHoleTotalProcess(); + } + + /** + * 鍦哄湴杩涘害 + * @return + */ + @Override + public List<Hole> selectHoleProjectProcess() { + return holeMapper.selectHoleProjectProcess(); + } + + private String saveExcel(MultipartFile file) { + String fileSaveDir2 = Global.getProfile() + "\\template\\" ; + String filename = file.getOriginalFilename(); - File dir = new File(fileSaveDir); + File dir = new File(fileSaveDir2); if (!dir.exists()) { dir.mkdir(); } - String addr = fileSaveDir + filename; + String addr = fileSaveDir2 + filename; try { File dest = new File(addr); file.transferTo(dest); @@ -201,11 +222,14 @@ private List<Hole> readData(String filepath) { ExcelReader reader = ExcelUtil.getReader(filepath, 0); reader.addHeaderAlias("閽诲瓟缂栧彿", "code"); - reader.addHeaderAlias("瀛斿彛楂樼▼", "elevation"); - reader.addHeaderAlias("璁捐瀛旀繁", "depth"); + reader.addHeaderAlias("閽诲瓟绫诲瀷", "type"); + reader.addHeaderAlias("瀛斿彛楂樼▼(m)", "elevation"); + reader.addHeaderAlias("璁捐瀛旀繁(m)", "depth"); + reader.addHeaderAlias("閽诲瓟鐘舵��", "status"); reader.addHeaderAlias("閽诲瓟缁忓害", "longitude"); reader.addHeaderAlias("閽诲瓟绾害", "latitude"); - reader.addHeaderAlias("杩涘害", "pic1"); + reader.addHeaderAlias("鎬昏繘灏�(m)", "footage"); + reader.addHeaderAlias("宸插畬鎴愯繘灏�(m)", "footageCpl"); List<Hole> list = reader.readAll(Hole.class); return list; -- Gitblit v1.9.1