场地状态，首页统计

suerwei

2024-05-22 fc15aa768cdb6c48ee8b21a5f43570c2f955a9ff

 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;