From fc15aa768cdb6c48ee8b21a5f43570c2f955a9ff Mon Sep 17 00:00:00 2001 From: suerwei <18810552194@163.com> Date: 星期三, 22 五月 2024 11:46:04 +0800 Subject: [PATCH] 场地状态,首页统计 --- javaweb-plus/javaweb-cms/src/main/java/com/javaweb/geo/service/impl/HoleServiceImpl.java | 26 +++++++++++++++++++++++--- 1 files changed, 23 insertions(+), 3 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..6db62e6 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,6 +182,25 @@ return "瀵煎叆瀹屾瘯" ; } + /** + * 鎬昏繘搴� + * @return + */ + @Override + public Hole selectHoleTotalProcess() { + return holeMapper.selectHoleTotalProcess(); + } + + /** + * 鍦哄湴杩涘害 + * @return + */ + @Override + public List<Hole> selectHoleProjectProcess() { + return holeMapper.selectHoleProjectProcess(); + } + + private String saveExcel(MultipartFile file) { String filename = file.getOriginalFilename(); File dir = new File(fileSaveDir); @@ -201,11 +220,12 @@ private List<Hole> readData(String filepath) { ExcelReader reader = ExcelUtil.getReader(filepath, 0); reader.addHeaderAlias("閽诲瓟缂栧彿", "code"); - reader.addHeaderAlias("瀛斿彛楂樼▼", "elevation"); - reader.addHeaderAlias("璁捐瀛旀繁", "depth"); + reader.addHeaderAlias("瀛斿彛楂樼▼(m)", "elevation"); + reader.addHeaderAlias("璁捐瀛旀繁(m)", "depth"); 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