添加xls模板

13693261870

2023-11-16 d2811d5ee9b13f301326d18b118dde40ba811b14

添加xls模板

 src/main/java/com/moon/server/controller/data/RasterAnalysisController.java

@@ -7,7 +7,7 @@
import com.moon.server.helper.StringHelper;
import com.moon.server.helper.WebHelper;
import com.moon.server.service.data.RasterAnalysisService;
import com.moon.server.service.data.SlopAnalysisService;
import com.moon.server.service.data.SlopeAnalysisService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
@@ -34,7 +34,7 @@
    RasterAnalysisService rasterService;

    @Resource
    SlopAnalysisService slopAnalysisService;
    SlopeAnalysisService slopeAnalysisService;

    private final static List<Integer> PIXELS = new ArrayList<>(Arrays.asList(1, 2, 4, 8, 16, 32, 64, 128, 256));

@@ -179,7 +179,7 @@
                return;
            }

            slopAnalysisService.downloadSlopXls(geo, res);
            slopeAnalysisService.downloadSlopXls(geo, res);
        } catch (Exception ex) {
            WebHelper.writeStr2Page(res, ex.getMessage());
            log.error(ex.getMessage(), ex);

 src/main/java/com/moon/server/helper/FileHelper.java

@@ -8,6 +8,8 @@
import org.apache.commons.logging.LogFactory;

import java.io.*;
import java.net.URL;
import java.net.URLDecoder;
import java.nio.ByteBuffer;
import java.nio.channels.FileChannel;
import java.nio.charset.StandardCharsets;
@@ -445,4 +447,35 @@
            is.close();
        }
    }

    /**
     * è¿‡æ»¤è¾“入字符串, å‰”除多行注释以及替换掉反斜杠
     */
    public static String filter(String str) {
        return str.replaceAll("/\\*[\\s\\S]*?\\*/", "");
    }

    /**
     * è§£ç 
     */
    public static String decode(String str) {
        try {
            return URLDecoder.decode(str, "UTF-8");
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);
            return null;
        }
    }

    /**
     * èŽ·å–ClassPath
     */
    public static String getClassPath() {
        URL resource = ClassLoader.getSystemResource("");
        if (null == resource) {
            return null;
        }

        return decode(filter(resource.getPath()));
    }
}

 src/main/java/com/moon/server/service/data/SlopeAnalysisService.java

ÎļþÃû´Ó src/main/java/com/moon/server/service/data/SlopAnalysisService.java ÐÞ¸Ä
@@ -2,6 +2,7 @@

import com.moon.server.entity.all.StaticData;
import com.moon.server.entity.data.PointEntity;
import com.moon.server.helper.FileHelper;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.gdal.gdal.Dataset;
@@ -12,6 +13,8 @@
import org.springframework.stereotype.Service;

import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.net.URL;
import java.util.ArrayList;
import java.util.List;

@@ -21,11 +24,24 @@
 * @date 2023-11-16
 */
@Service
public class SlopAnalysisService {
public class SlopeAnalysisService {
    @Value("${sys.path.slopFile}")
    private String filePath;

    private final static Log log = LogFactory.getLog(SlopAnalysisService.class);
    private String xlsTemplate;

    private final static Log log = LogFactory.getLog(SlopeAnalysisService.class);

    /**
     * èŽ·å–Excel模板
     */
    private String getXlsTemplate() {
        if (null == xlsTemplate) {
            xlsTemplate = FileHelper.getClassPath() + File.separator + "config" + File.separator + "slop.xlsx";
        }

        return xlsTemplate;
    }

    /**
     * ä¸‹è½½å¡åº¦åˆ†æžExcel

 src/main/resources/config/slope.xlsx

Binary files differ