package com.landtool.lanbase.modules.res.controller;

import java.io.File;
import java.io.IOException;
import java.net.URLDecoder;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.UUID;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.servlet.http.HttpServletRequest;

import org.apache.shiro.SecurityUtils;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.serializer.SerializerFeature;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.landtool.lanbase.common.annotation.LogAction;
import com.landtool.lanbase.common.annotation.SysLog;
import com.landtool.lanbase.common.map.EsbToken;
import com.landtool.lanbase.common.utils.AttachmentUtils;
import com.landtool.lanbase.common.utils.FileUtils;
import com.landtool.lanbase.common.utils.HttpOperateUtils;
import com.landtool.lanbase.common.utils.HttpUtils;
import com.landtool.lanbase.common.utils.JpinyinUtils;
import com.landtool.lanbase.common.utils.Result;
import com.landtool.lanbase.config.SysTemPropertyConfig;
import com.landtool.lanbase.modules.api.utils.PageBean;
import com.landtool.lanbase.modules.org.entity.OrgUser;
import com.landtool.lanbase.modules.res.entity.GraphicStyle;
import com.landtool.lanbase.modules.res.entity.Res_Catalog;
import com.landtool.lanbase.modules.res.entity.Res_EchartsConfing;
import com.landtool.lanbase.modules.res.entity.Res_ExtBusinessLayer;
import com.landtool.lanbase.modules.res.entity.Res_ExtMapUrl;
import com.landtool.lanbase.modules.res.entity.Res_ExtThemeMap;
import com.landtool.lanbase.modules.res.entity.Res_MainInfo;
import com.landtool.lanbase.modules.res.entity.Res_SymbolLibrary;
import com.landtool.lanbase.modules.res.entity.Res_Theme_Module;
import com.landtool.lanbase.modules.res.entity.JSONModels.ServiceConfig;
import com.landtool.lanbase.modules.res.service.ResBusinessRefService;
import com.landtool.lanbase.modules.res.service.ResEchartsCofingService;
import com.landtool.lanbase.modules.res.service.ResExtBusinessLayerService;
import com.landtool.lanbase.modules.res.service.ResExtMapUrlService;
import com.landtool.lanbase.modules.res.service.ResExtThemeMapService;
import com.landtool.lanbase.modules.res.service.ResMainInfoService;
import com.landtool.lanbase.modules.res.service.ResQueryAroundService;
import com.landtool.lanbase.modules.res.service.ResSymbolLibraryService;
import com.landtool.lanbase.modules.res.service.ResThemeModuleService;
import com.landtool.lanbase.modules.sys.controller.AbstractController;
import com.landtool.lanbase.modules.sys.service.SysFieldvalueService;

import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;

@Controller
@RequestMapping("res/common")
public class CommonController extends AbstractController {
    @Autowired
    private SysTemPropertyConfig sysConfig;
    @Autowired
    private SysFieldvalueService FieldUtils;
    @Autowired
    private ResMainInfoService resMainInfoService;
    @Autowired
    private ResQueryAroundService resQueryAroundService;
    @Autowired
    private ResBusinessRefService resBusinessRefService;
    @Autowired
    private ResSymbolLibraryService resSymbolLibraryService;
    @Autowired
    private ResExtMapUrlService resExtMapUrlService;
    @Autowired
    private ResExtThemeMapService resExtThemeMapService;
    @Autowired
    private ResExtBusinessLayerService resExtBusinessLayerService;
    @Autowired
    private ResEchartsCofingService resEchartsCofingService;
    @Autowired
    private ResThemeModuleService resThemeModuleService;

    @RequestMapping("/resource_set_zbcx")
    public String resource_set_zbcx(Integer resourceid, Model model) {
        model.addAttribute("resourceid", resourceid);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        return "common/resource_set_zbcx";
    }

    @RequestMapping("/resource_set_gltc")
    public String resource_set_gltc(Integer resourceid, Model model) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        return "common/resource_set_gltc";
    }

    //图形设置
    @RequestMapping("/resource_set_TuXin")
    public String resource_set_TuXin(Integer resourceid, Model model) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        Res_MainInfo res_mainInfo = resMainInfoService.selectByPrimaryKey(resourceid);
        model.addAttribute("resMainInfo", res_mainInfo);
        return "common/resource_set_TuXin";
    }

    //添加图形设置面板
    //id表示 要编辑的行，如果有id的话，那么表示编辑
    @RequestMapping("/resource_add_TuXin")
    public String resource_add_TuXin(Integer resourceid, Model model, Integer id) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        List<Res_ExtMapUrl> resExtMapUrlList = resExtMapUrlService.selectByCondition(resourceid);
        String url = "";
        List<String> List = new ArrayList<String>();
        for (int i = 0; i < resExtMapUrlList.size(); i++) {
            url = resExtMapUrlList.get(0).getServerurl();
        }
        try {
            String TokenResponse = HttpOperateUtils.httpGet(url + "?f=pjson");
            JSONObject jsStr = JSONObject.parseObject(TokenResponse);
            JSONArray obj = JSONArray.parseArray(jsStr.get("fields").toString());
            for (int i = 0; i < obj.size(); i++) {
                List.add(obj.getJSONObject(i).getString("name"));
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        model.addAttribute("list", List);
        GraphicStyle graphicStyle = new GraphicStyle();
        if (id != null) {
            Res_MainInfo res_mainInfo = resMainInfoService.selectByPrimaryKey(resourceid);
            String[] Graphic = res_mainInfo.getGraphicStyle().split("\\|");
            JSONObject jsStr = JSONObject.parseObject(Graphic[id - 1]);
            graphicStyle.setType(jsStr.getString("type"));
            graphicStyle.setDisplayMode(jsStr.getString("displayMode"));
            graphicStyle.setClassfield(jsStr.getString("classfield"));
            graphicStyle.setValueField(jsStr.getString("ValueField"));
            graphicStyle.setStatisticalMethod(jsStr.getString("StatisticalMethod"));
        }
        model.addAttribute("graphicStyle", graphicStyle);
        model.addAttribute("hangshu", id);
        model.addAttribute("resourceid", resourceid);
        return "common/resource_add_TuXin";
    }

    //图形保存设置
    @ResponseBody
    @RequestMapping("/TuXingConfigAdd")
    public String TuXingConfigAdd(Integer resourceid, Model model, GraphicStyle graphicStyle, Integer hangshu) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        Res_MainInfo res_mainInfo = resMainInfoService.selectByPrimaryKey(resourceid);
        //新增
        int count = 0;
        if (hangshu == null) {
            String graphic = "";
            if (res_mainInfo.getGraphicStyle() == null || !res_mainInfo.getGraphicStyle().equals("")) {
                graphic += "|";
            }
            graphic += "{'type':" + "'" + graphicStyle.getType() + "'" + ",";
            graphic += "'displayMode':" + "'" + graphicStyle.getDisplayMode() + "'" + ",";
            graphic += "'classfield':" + "'" + graphicStyle.getClassfield() + "'" + ",";
            graphic += "'ValueField':" + "'" + graphicStyle.getValueField() + "'" + ",";
            graphic += "'StatisticalMethod':" + "'" + graphicStyle.getStatisticalMethod() + "'}";
            Res_MainInfo res_mainInfo1 = new Res_MainInfo();
            res_mainInfo1.setResourceid(resourceid);
            if (res_mainInfo.getGraphicStyle() == null) {
                res_mainInfo1.setGraphicStyle(graphic);
            } else {
                res_mainInfo1.setGraphicStyle(res_mainInfo.getGraphicStyle() + graphic);
            }
            count = resMainInfoService.updateByPrimaryKeySelective(res_mainInfo1);
        } else {
            String[] Graphic = res_mainInfo.getGraphicStyle().split("\\|");
            String graphic = "";
            graphic += "{'type':" + "'" + graphicStyle.getType() + "'" + ",";
            graphic += "'displayMode':" + "'" + graphicStyle.getDisplayMode() + "'" + ",";
            graphic += "'classfield':" + "'" + graphicStyle.getClassfield() + "'" + ",";
            graphic += "'ValueField':" + "'" + graphicStyle.getValueField() + "'" + ",";
            graphic += "'StatisticalMethod':" + "'" + graphicStyle.getStatisticalMethod() + "'}";
            //对应行数里面的值替换
            Graphic[hangshu - 1] = graphic;
            StringBuilder rsb = new StringBuilder();
            //然后对数组进行循环，拼接成字符串
            for (int i = 0; i < Graphic.length; i++) {
                JSONObject jsStr = JSONObject.parseObject(Graphic[i]);
                if (i != 0) {
                    rsb.append("|");
                }
                int id = i + 1;
                rsb.append("{");
                rsb.append("'type':'" + jsStr.getString("type") + "'");
                rsb.append(",'id':'" + id + "'");
                rsb.append(",'displayMode':'" + jsStr.getString("displayMode") + "'");
                rsb.append(",'classfield':'" + jsStr.getString("classfield") + "'");
                rsb.append(",'ValueField':'" + jsStr.getString("ValueField") + "'");
                rsb.append(",'StatisticalMethod':'" + jsStr.getString("StatisticalMethod") + "'");//资源类型
                rsb.append("}");
            }
            Res_MainInfo res_mainInfo1 = new Res_MainInfo();
            res_mainInfo1.setResourceid(resourceid);
            res_mainInfo1.setGraphicStyle(rsb.toString());
            count = resMainInfoService.updateByPrimaryKeySelective(res_mainInfo1);

        }
        model.addAttribute("resMainInfo", res_mainInfo);
        return "{'count':'" + count + "'}";
    }

    //图形删除设置
    @ResponseBody
    @RequestMapping("/TuXinCongiDelect")
    public String TuXinCongiDelect(Integer resourceid, Model model, Integer hangshu) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        Res_MainInfo res_mainInfo = resMainInfoService.selectByPrimaryKey(resourceid);
        int count = 0;
        String[] Graphic = res_mainInfo.getGraphicStyle().split("\\|");
        Graphic = deleteMethod(hangshu - 1, Graphic);
        StringBuilder rsb = new StringBuilder();
        //然后对数组进行循环，拼接成字符串
        for (int i = 0; i < Graphic.length; i++) {
            JSONObject jsStr = JSONObject.parseObject(Graphic[i]);
            if (i != 0) {
                rsb.append("|");
            }
            int id = i + 1;
            rsb.append("{");
            rsb.append("'type':'" + jsStr.getString("type") + "'");
            rsb.append(",'id':'" + id + "'");
            rsb.append(",'displayMode':'" + jsStr.getString("displayMode") + "'");
            rsb.append(",'classfield':'" + jsStr.getString("classfield") + "'");
            rsb.append(",'ValueField':'" + jsStr.getString("ValueField") + "'");
            rsb.append(",'StatisticalMethod':'" + jsStr.getString("StatisticalMethod") + "'");//资源类型
            rsb.append("}");
        }
        Res_MainInfo res_mainInfo1 = new Res_MainInfo();
        res_mainInfo1.setResourceid(resourceid);
        res_mainInfo1.setGraphicStyle(rsb.toString());
        count = resMainInfoService.updateByPrimaryKeySelective(res_mainInfo1);
        model.addAttribute("resMainInfo", res_mainInfo);
        return "{'count':'" + count + "'}";
    }

    public String[] deleteMethod(int index, String array[]) {
        //数组的删除其实就是覆盖前一位
        String[] arrNew = new String[array.length - 1];
        for (int i = index; i < array.length - 1; i++) {
            array[i] = array[i + 1];
        }
        System.arraycopy(array, 0, arrNew, 0, arrNew.length);
        return arrNew;
    }

    //读取图形设置
    @ResponseBody
    @RequestMapping("/TuXingConfigSelectAll")
    public String TuXingConfigSelectAll(Integer resourceid) {
        Res_MainInfo res_mainInfo = resMainInfoService.selectByPrimaryKey(resourceid);
        String[] Graphic = {};
        if (res_mainInfo != null && res_mainInfo.getGraphicStyle() != null) {
            Graphic = res_mainInfo.getGraphicStyle().split("\\|");
        }
        //查询arg url.
        List<Res_ExtMapUrl> resExtMapUrlList = resExtMapUrlService.selectByCondition(resourceid);
        String url = "";
        List<String> List = new ArrayList<String>();
        for (int i = 0; i < resExtMapUrlList.size(); i++) {
            url = resExtMapUrlList.get(0).getServerurl();
        }
        // http://192.168.0.140:6080/arcgis/rest/services/onemapjm/MapServer/26/query 加上query才能查询地图字段
        url = url + "/query";
        StringBuilder rsb = new StringBuilder();
        rsb.append("{'totalCount':'" + Graphic.length + "','url':'" + url + "");
        rsb.append("','topics':[");
        for (int i = 0; i < Graphic.length; i++) {
            JSONObject jsStr = JSONObject.parseObject(Graphic[i]);
            if (i != 0) {
                rsb.append(",");
            }
            int id = i + 1;
            rsb.append("{");
            rsb.append("'type':'" + jsStr.getString("type") + "'");
            rsb.append(",'id':'" + id + "'");
            rsb.append(",'displayMode':'" + jsStr.getString("displayMode") + "'");
            rsb.append(",'classfield':'" + jsStr.getString("classfield") + "'");
            rsb.append(",'ValueField':'" + jsStr.getString("ValueField") + "'");
            rsb.append(",'StatisticalMethod':'" + jsStr.getString("StatisticalMethod") + "'");//资源类型
            rsb.append("}");
        }
        rsb.append("]}");
        return rsb.toString();
    }

    //读取图形配置
    //http://127.0.0.1:8082/res/common/TuXingConfig
    @RequestMapping("/TuXingConfig")
    public String TuXingConfig(Integer resourceid, Model model) {
        List<Res_ExtMapUrl> resExtMapUrlList = resExtMapUrlService.selectByCondition(resourceid);
        String url = "";
        List<String> List = new ArrayList<String>();
        for (int i = 0; i < resExtMapUrlList.size(); i++) {
            url = resExtMapUrlList.get(0).getServerurl();
        }
        // http://192.168.0.140:6080/arcgis/rest/services/onemapjm/MapServer/26/query 加上query才能查询地图字段
        url = url + "/query";
        model.addAttribute("url", url);
        model.addAttribute("resourceid", resourceid);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        return "common/TuXingConfig";
    }

    //添加资源 - 多选
    @RequestMapping("/resource_select")
    public String resource_select(Model model, String flag, Integer resourceid) {
        model.addAttribute("flag", flag);
        model.addAttribute("resourceid", resourceid);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("lanbaseurl", sysConfig.getApiServer());
        // 获取数据来源表
        HashMap<String, String> DataSourceList = FieldUtils.getDataSourceList();// 获取数据来源列表
        model.addAttribute("DataSourceList", DataSourceList);
        return "common/resource_select";
    }

    /**
     * 添加关联图层列表（弃用，改用树）
     *
     * @param flag
     * @param resMainInfo
     * @param pageBean
     * @return
     */
    @ResponseBody
    @RequestMapping("/getResourceSelect")
    public String getResourceSelect(String flag, Res_MainInfo resMainInfo, PageBean pageBean) {
        Page<Res_MainInfo> page = PageHelper.startPage(pageBean.getPage(), pageBean.getLimit());
        List<Res_MainInfo> res_mainInfos = null;
        if (flag.equals("zbcx")) {
            res_mainInfos = resQueryAroundService.getResourceSelectZBCX(resMainInfo);
        } else if (flag.equals("gltc")) {
            res_mainInfos = resBusinessRefService.getResourceSelectGLTC(resMainInfo);
        }
        int countNums = (int) ((Page) res_mainInfos).getTotal();
        PageBean<Res_MainInfo> pageData = new PageBean<>(pageBean.getPage(), pageBean.getLimit(), countNums);
        pageData.setItems(res_mainInfos);
        LinkedHashMap<String, String> resourceTypeList = FieldUtils.getFieldListByKey("ResourceType");//获取资源类型列表
        StringBuilder rsb = new StringBuilder();
        rsb.append("{'totalCount':'" + countNums);
        rsb.append("','topics':[");
        for (int i = 0; i < res_mainInfos.size(); i++) {
            if (i != 0) {
                rsb.append(",");
            }
            rsb.append("{");
            rsb.append("'TITLE':'" + res_mainInfos.get(i).getTitle() + "'");
            rsb.append(",'DATASOURCES':'" + res_mainInfos.get(i).getDatasources() + "'");
            rsb.append(",'RESOURCEID':'" + res_mainInfos.get(i).getResourceid() + "'");
            rsb.append(",'RESOURCECLASS':'" + resourceTypeList.get(res_mainInfos.get(i).getResourceclass()) + "'");//资源类型
            rsb.append("}");
        }
        rsb.append("]}");
        return rsb.toString();
    }

    /**
     * 获取资源设置树
     */
    @ResponseBody
    @RequestMapping("/getResourceSelectTree")
    public String getResourceSelectTree(String flag, Res_MainInfo resMainInfo, String parentid) {
        StringBuilder resCatalogJson = new StringBuilder();
        Map<String, Object> map = new HashMap<>();
        map.put("resourceid", resMainInfo.getResourceid());
        map.put("title", resMainInfo.getTitle());
        map.put("resourceclass", resMainInfo.getResourceclass());
        map.put("datasources", resMainInfo.getDatasources());
        map.put("parentid", parentid);
        List<Res_MainInfo> res_mainInfos = null;
        List<Res_Catalog> resCatalogList = null;
        if (flag.equals("zbcx")) {
            resCatalogList = resQueryAroundService.getResourceZBCXCatalog(map);
            res_mainInfos = resQueryAroundService.getResourceZBCXCatalogList(map);
        } else if (flag.equals("gltc")) {
            resCatalogList = resBusinessRefService.getResourceGLTCCatalog(map);
            res_mainInfos = resBusinessRefService.getResourceGLTCCatalogList(map);
        }
        // 循环构造子目录节点
        List<Map<String, Object>> maps = new LinkedList<>();
        for (Res_Catalog resCatalog : resCatalogList) {
            if (!"".equals(resCatalogJson.toString())) {
                resCatalogJson.append(',');
            }
            Map<String, Object> catlogmap = new HashMap<>();
            catlogmap.put("id", resCatalog.getCatlogid());
            catlogmap.put("name", resCatalog.getTitle());
            catlogmap.put("title", resCatalog.getTitle());
            catlogmap.put("isParent", true);
            catlogmap.put("iconOpen", "/image/classicons/folderOpen.png");
            catlogmap.put("iconClose", "/image/classicons/folder.png");
            maps.add(catlogmap);
//            resCatalogJson.append("{id: " + resCatalog.getCatlogid() + ",name:'" + resCatalog.getTitle() + "',title:'" + resCatalog.getTitle() + "',isParent: true,iconOpen:'/image/classicons/folderOpen.png',iconClose:'/image/classicons/folder.png'}");
        }
        // 循环构造资源节点
        for (Res_MainInfo resMainInfo1 : res_mainInfos) {
            if (!"".equals(resCatalogJson.toString())) {
                resCatalogJson.append(',');
            }
            Map<String, Object> ctalogmap = new HashMap<>();
            ctalogmap.put("id", "ZiYuan_" + resMainInfo1.getResourceid());
            ctalogmap.put("name", resMainInfo1.getTitle());
            ctalogmap.put("title", resMainInfo1.getTitle());
            ctalogmap.put("isParent", false);
            ctalogmap.put("icon", "/image/classicons/"+ resMainInfo1.getResourceclass() +".png");
            maps.add(ctalogmap);
//            resCatalogJson.append("{id: 'ZiYuan_" + resMainInfo1.getResourceid() + "',name:'" + resMainInfo1.getTitle() + "', title: '" + resMainInfo1.getDatasources() + "',isParent:false,icon:'/image/classicons/"+ resMainInfo1.getResourceclass() +".png'}");
        }
        return JSON.toJSONString(maps, SerializerFeature.WriteMapNullValue);
    }

    /**
     * 自动补全输入首字母查询
     *
     * @param keyWord
     * @return
     */
    @ResponseBody
    @GetMapping("/findPinyinByKeyWord")
    public String[] findpinyinByKeyWord(@RequestParam(name = "keyWord") String keyWord, String flag, Integer resourceid) {
        keyWord = URLDecoder.decode(keyWord);
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("resourceid", resourceid);
        map.put("keyWord", keyWord);
        List<Res_MainInfo> list = null;
        if (flag.equals("zbcx")) {
            list = resQueryAroundService.getResourceZBCXCatalogList(map);
        } else if (flag.equals("gltc")) {
            list = resBusinessRefService.getResourceGLTCCatalogList(map);
        }
        String[] arr = new String[list.size()];
        for (int i = 0; i < list.size(); i++) {
            String title = list.get(i).getTitle();
            arr[i] = title;
        }
        return arr;
    }

    /**
     * 地图范围框选
     *
     * @param drawType    地图绘制类型（point: 点 extent: 范围）
     * @param callbackFun 绘制回调类型（处理同一页面多个调用类型区分）
     * @param model
     * @return
     */
    @RequestMapping("/obtainExtentMapViewer")
    public String obtainExtentMapViewer(String drawType, String callbackFun, Model model) {
        model.addAttribute("drawType", drawType);//绘制类型
        model.addAttribute("callbackFun", callbackFun);//回调类型
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("obtainExtentMapUrl", sysConfig.getObtainExtentMapUrl());//框选地图底图URL
        return "common/obtainExtentMapViewer";
    }

    /**
     * 符号库风格更新
     *
     * @return
     */
    @ResponseBody
    @RequestMapping("/updateSymbolLibrary")
    public String updateSymbolLibrary() {
        String pointSymbolUrl = "http://ocean-data.nmdis.com/arcgis/rest/services/JCDL/fuhao2/MapServer/0";    //点符号服务地址
        String polylineSymbolUrl = "http://ocean-data.nmdis.com/arcgis/rest/services/JCDL/fuhao2/MapServer/1"; //线符号服务地址
        String polygonSymbolUrl = "http://ocean-data.nmdis.com/arcgis/rest/services/JCDL/fuhao2/MapServer/2";  //面符号服务地址
        String[][] arr = new String[][]{{pointSymbolUrl, "点"}, {polylineSymbolUrl, "线"}, {polygonSymbolUrl, "面"}};
        String resultMsg = "更新成功！";
        String errorMsg = "";

        for (int i = 0; i < arr.length; i++) {
            try {
                String ResultJsonStr = HttpOperateUtils.httpGet(arr[i][0].trim() + "?f=json");
                JSONObject drawingInfo = JSONObject.parseObject(ResultJsonStr).getJSONObject("drawingInfo");
                if (drawingInfo != null) {
                    JSONObject renderer = drawingInfo.getJSONObject("renderer");
                    if (renderer != null) {
                        JSONArray uniqueValueInfos = renderer.getJSONArray("uniqueValueInfos");
                        if (uniqueValueInfos != null) {
                            for (int j = 0; j < uniqueValueInfos.size(); j++) {
                                String FHID = uniqueValueInfos.getJSONObject(j).getString("label");
                                String SYMBOL = uniqueValueInfos.getJSONObject(j).getString("symbol");
                                Res_SymbolLibrary resSymbolLibrary = new Res_SymbolLibrary();
                                resSymbolLibrary.setFhid(FHID);
                                resSymbolLibrary.setGeotype(arr[i][1]);
                                Res_SymbolLibrary res_symbolLibrary = resSymbolLibraryService.getByIdAndGeoType(resSymbolLibrary);//获取符号库对应记录
                                if (res_symbolLibrary != null) {
                                    res_symbolLibrary.setSymbol(SYMBOL);
                                    resSymbolLibraryService.updateByPrimaryKey(res_symbolLibrary);//更新符号库对应记录符号风格
                                }
                            }
                        }
                    }
                }
            } catch (IOException e) {
                errorMsg += arr[i][1] + ":" + e.getMessage() + "\r\n";
                continue;
            }
        }

        if (errorMsg.isEmpty()) {
            return resultMsg;
        } else {
            return errorMsg;
        }
    }

    /**
     * 符号库管理
     *
     * @return
     */
    @RequestMapping("symbolLibrary/index")
    public String symbolLibraryIndex(Model model) {
        List<String> mc = resSymbolLibraryService.getMC();
        model.addAttribute("mclist", mc);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("systemName", sysConfig.getAppFullName());
        return "manage/symbolLibrary/index";
    }

    /**
     * 获取符号库列表
     *
     * @param resSymbolLibrary
     * @param pageBean
     * @return
     */
    @ResponseBody
    @RequestMapping("symbolLibrary/getlist")
    @RequiresPermissions("res:symbolLibrary:edit")
    @LogAction("资源管理,符号库管理,符号库列表查询,查询")
    public Result getList(Res_SymbolLibrary resSymbolLibrary, PageBean pageBean) {
        PageHelper.startPage(pageBean.getPage(), pageBean.getLimit());
        List<Res_SymbolLibrary> resSymbolLibraryList = resSymbolLibraryService.getList(resSymbolLibrary);
        int countNums = (int) ((Page) resSymbolLibraryList).getTotal();
        PageBean<Res_SymbolLibrary> pageData = new PageBean<>(pageBean.getPage(), pageBean.getLimit(), countNums);
        pageData.setItems(resSymbolLibraryList);
        StringBuilder rsb = new StringBuilder();
        rsb.append("{'totalCount':'" + countNums + "','topics':[");
        List<Map<String, Object>> maps = new LinkedList<>();
        for (int i = 0; i < resSymbolLibraryList.size(); i++) {
            Map<String, Object> map = new HashMap<>();
            map.put("objectid", resSymbolLibraryList.get(i).getObjectid());
            map.put("fhid", resSymbolLibraryList.get(i).getFhid());
            map.put("mc", resSymbolLibraryList.get(i).getMc());
            map.put("geotype", resSymbolLibraryList.get(i).getGeotype());
            maps.add(map);

//            if (i != 0) rsb.append(",");
//            rsb.append("{'objectid':'" + resSymbolLibraryList.get(i).getObjectid() + "','fhid':'" + resSymbolLibraryList.get(i).getFhid() + "','mc':'" + resSymbolLibraryList.get(i).getMc() + "','geotype':'" + resSymbolLibraryList.get(i).getGeotype() + "'}");
        }
//        rsb.append("]}");
        return Result.ok().put("totalCount", countNums).put("topics", maps);
    }

    /**
     * 符号编辑页面
     *
     * @param OBJECTID
     * @return
     */
    @RequestMapping("symbolLibrary/edit")
    public String edit(Model model, int OBJECTID) {
        Res_SymbolLibrary resSymbolLibrary = resSymbolLibraryService.getById(OBJECTID);//获取符号信息
        if (resSymbolLibrary == null) {
            resSymbolLibrary = new Res_SymbolLibrary();
        }
        model.addAttribute("resSymbolLibrary", resSymbolLibrary);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());

        return "manage/symbolLibrary/edit";
    }

    /**
     * 符号编辑保存
     *
     * @param entity
     * @return
     */
    @ResponseBody
    @RequestMapping("symbolLibrary/save")
    @LogAction("资源管理,符号库管理,符号库列表修改,修改")
    public String edit(Model model, Res_SymbolLibrary entity) {
        try {
            Res_SymbolLibrary resSymbolLibrary = resSymbolLibraryService.getById(entity.getObjectid());//获取符号信息
            resSymbolLibrary.setSymbol(entity.getSymbol());
            resSymbolLibraryService.updateByPrimaryKey(resSymbolLibrary);

            return "{success: true, msg: '保存成功！'}";
        } catch (Exception e) {
            return "{success: false, msg: '" + e.getMessage() + "'}";
        }
    }

    /**
     * 符号库符号展示地图页面
     *
     * @param model
     * @param symbol
     * @param geotype
     * @return
     */
    @RequestMapping("symbolLibrary/symbolmap")
    public String symbolmap(Model model, String symbol, String geotype) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("obtainExtentMapUrl", sysConfig.getObtainExtentMapUrl());//框选地图底图URL
        model.addAttribute("symbol", symbol);
        model.addAttribute("geotype", geotype);

        return "manage/symbolLibrary/symbolmap";
    }

    //编辑器上传图片
    @RequestMapping("/uploadueditorfile")
    public ResponseEntity<Map<String, Object>> uploadueditorfile(@RequestParam(value = "upfile", required = false) MultipartFile file, HttpServletRequest request) {//value的名字一定要叫upfile，这是ueditor写好的参数名称
        String fileName = file.getOriginalFilename();
        String[] types = fileName.split("\\.");
        String type = types[types.length - 1];
        String root = sysConfig.getUploadPath().replace("/", "\\");
        String LinShiUrl = root + "\\ueditor";
        String suffix = FileUtils.getSuffix(file.getOriginalFilename());
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
        String timePath = sdf.format(new Date().getTime());
        timePath = timePath.replace("-", "");
        String newFileName = AttachmentUtils.newFileName(suffix, LinShiUrl, timePath);
        File newFile = new File(newFileName);
        //临时文件处理
        try {
            file.transferTo(newFile);
        } catch (Exception e) {
            e.printStackTrace();
        }
        Map<String, Object> result = new HashMap<String, Object>();
        result.put("state", "SUCCESS");// UEDITOR的规则:不为SUCCESS则显示state的内容
        result.put("url", sysConfig.getUploadRootPath() + FileUtils.removePrefix(newFile.getAbsolutePath(), root).replace("\\", "/"));
        result.put("title", file.getOriginalFilename());
        result.put("original", file.getOriginalFilename());
        result.put("size", file.getSize());
        result.put("type", type);
        HttpHeaders headers = new HttpHeaders();
        headers.setContentType(MediaType.TEXT_PLAIN);
        return new ResponseEntity<Map<String, Object>>(result, headers, HttpStatus.OK);
    }

    /**
     * 客户端获取Token
     *
     * @param resourceId 资源ID
     * @param request
     * @return
     */
    @ResponseBody
    @RequestMapping("/getToken")
    public String getToken(int resourceId, HttpServletRequest request) {
        String result = "";
        String callbackFunName = request.getParameter("callback");
        if (callbackFunName == null || callbackFunName.isEmpty()) {
            callbackFunName = "callback";
        }
        try {
            Long userid = ((OrgUser) SecurityUtils.getSubject().getPrincipal()).getUserid();
            Res_MainInfo resMainInfo = resMainInfoService.selectByPrimaryKey(resourceId);//获取资源主表信息
            if (resMainInfo != null) {
                boolean isPubzy = false;
                if (resMainInfo != null && resMainInfo.getSharprotocol().equals("完全公开")) {
                    isPubzy = true;
                }
                String subzyids = "";
                String serverUrl = "null";
                //查询是否是专题地图，是专题地图则获取相关子图层ID
                if (resMainInfo.getResourceclass().equals("KJ_ZTDT")) {
                    Res_ExtThemeMap resExtThemeMap = resExtThemeMapService.selectByPrimaryKey(resourceId);
                    if (resExtThemeMap != null) {
                        subzyids = resExtThemeMap.getSublayerset();
                    }
                }
                Res_ExtMapUrl resExtMapUrl = resExtMapUrlService.queryFirstOrderByResId(resourceId);
                if (resExtMapUrl != null) {
                    serverUrl = resExtMapUrl.getServerurl() == null || resExtMapUrl.getServerurl().isEmpty() ? "null" : "\"" + resExtMapUrl.getServerurl() + "\"";
                }
                String token = EsbToken.getEsbUrl(serverUrl, userid.intValue(), request.getRemoteAddr(), resourceId, resMainInfo.getEspproxy(), sysConfig, subzyids, isPubzy, resMainInfo.getToken(), true);
                result = "{ \"success\": true, \"serverUrl\": " + serverUrl + ", \"token\": " + (token.isEmpty() ? "null" : "\"" + token + "\"") + "}";
            } else {
                result = "{ \"success\": false, \"msg\": \"资源不存在！\" }";
            }
        } catch (Exception e) {
            result = "{ \"success\": false, \"msg\": \"" + e.getMessage() + "\" }";
        }
        return callbackFunName + "(" + result + ")";
    }


    /**
     * 业务图层 - 图表设置页面
     *
     * @param resourceid 资源ID
     * @param model
     * @param name       变量 如：var1，table1
     * @param type       所属类别 如：vars，tables
     * @return
     */
    @RequestMapping("/serviceconfig")
    public String setServiceConfig(Integer resourceid, Model model, String name, String type) {
        List<Res_ExtMapUrl> resExtMapUrlList = resExtMapUrlService.selectByCondition(resourceid);
        model.addAttribute("resourceid", resourceid);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("jspwebroot", sysConfig.getPubzyWebRoot().replace("javapubzy/", ""));// 临时处理

        //获取list
        JSONArray chartsList = new JSONArray();
        JSONArray tablesList = new JSONArray();
        JSONArray varsList = new JSONArray();
        Res_ExtBusinessLayer resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        if (resExtBusinessLayer != null && resExtBusinessLayer.getServiceConfig() != null && !resExtBusinessLayer.getServiceConfig().equals("")) {
            JSONObject obj = JSONObject.parseObject(resExtBusinessLayer.getServiceConfig());
            for (int i = 0; i < obj.size(); i++) {
                JSONArray object = null;
                //每次只取一个类
                if (i == 0) {
                    if (obj.getJSONArray("vars") != null) { //常量
                        object = obj.getJSONArray("vars");
                        if (object != null) {
                            for (int j = 0; j < object.size(); j++) {
                                String key = object.getJSONObject(j).getString("name");
                                String explain = object.getJSONObject(j).getJSONObject(key).getString("explain");
                                if(explain == null) {
                                    explain = "";
                                }
                                String listKey = "{\"key\":\"" + key + "\",\"explain\":\"" + explain + "\"}";
                                varsList.add(JSONObject.parseObject(listKey));
                            }
                        }
                    }
                }
                if (i == 1) {
                    if (obj.getJSONArray("tables") != null) { //表格
                        object = obj.getJSONArray("tables");
                        if (object != null) {
                            for (int j = 0; j < object.size(); j++) {
                                String key = object.getJSONObject(j).getString("name");
                                String explain = object.getJSONObject(j).getJSONObject(key).getString("explain");
                                if(explain == null) {
                                    explain = "";
                                }
                                String listKey = "{\"key\":\"" + key + "\",\"explain\":\"" + explain + "\"}";
                                tablesList.add(JSONObject.parseObject(listKey));
                            }
                        }
                    }
                }
                if (i == 2) {
                    if (obj.getJSONArray("charts") != null) { //图表
                        object = obj.getJSONArray("charts");
                        if (object != null) {
                            for (int j = 0; j < object.size(); j++) {
                                String key = object.getJSONObject(j).getString("name");
                                String explain = object.getJSONObject(j).getJSONObject(key).getString("explain");
                                if(explain == null) {
                                    explain = "";
                                }
                                String listKey = "{\"key\":\"" + key + "\",\"explain\":\"" + explain + "\"}";
                                chartsList.add(JSONObject.parseObject(listKey));
                            }
                        }
                    }
                }
            }
        }
        model.addAttribute("chartsList", chartsList);
        model.addAttribute("tablesList", tablesList);
        model.addAttribute("varsList", varsList);

        String serviceHTML = "";
        if(resExtBusinessLayer != null && resExtBusinessLayer.getServiceHTML() != null && !resExtBusinessLayer.getServiceHTML().equals("")) {
            serviceHTML = replaceServiceHTML(resExtBusinessLayer.getServiceHTML(), resourceid, "htmlToChar");
        }
        model.addAttribute("serviceHTML", serviceHTML);
        model.addAttribute("systemName", sysConfig.getAppFullName());
        return "common/ServiceConfig";
    }

    // settype0是表示业务图层的 1是表示一张图的
    @RequestMapping("/addserviceconfig")
    public String addSetServiceConfig(Integer resourceid, Model model, String name, String type,Integer moduleid,Integer settype,String associationlayer) {
        String url = "";
        List<String> List = new ArrayList<String>();
        Res_ExtBusinessLayer resExtBusinessLayer = null;
        Res_Theme_Module resThemeModule = null;
        Integer thismoduleid = moduleid != null?moduleid:0;

        String token = "";
        if(settype != null && settype == 0) { //业务图层
            resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
            List<Res_ExtMapUrl> resExtMapUrlList = resExtMapUrlService.selectByCondition(resourceid);
            if (resExtMapUrlList.size() > 0) {
                url = resExtMapUrlList.get(0).getServerurl();
                Res_MainInfo resMainInfo = resMainInfoService.selectByPrimaryKey(resourceid);
                boolean isPubzy = false;
                if (resMainInfo != null && !resMainInfo.getSharprotocol().equals("完全公开")) {
                    token = EsbToken.getEsbUrl(url, getUserId().intValue(), sysConfig.getIpHost(), resourceid, resMainInfo.getEspproxy(), sysConfig, null, isPubzy, resMainInfo.getToken(), true);
                }
            }
        }else { //一张图
            resThemeModule = resThemeModuleService.selectByid(moduleid);
            if(resThemeModule != null && resThemeModule.getServiceconfig() !=null && !resThemeModule.getServiceconfig().trim().equals("")){
                if(type.equals("tables")){
                    name = "table1";
                }else{
                    name = "chart1";
                }
            }
            url = java.net.URLDecoder.decode(associationlayer);
        }
        if (url != null && !"".equals(url)) {
            try {
                if(url.indexOf("?")!=-1){
                    if(!"".equals(token)) {
                        url += "&f=pjson&token=" + token;
                    }
                    else {
                        url += "&f=pjson";
                    }
                }else{
                    if(!"".equals(token)) {
                        url +="?f=pjson&token=" + token;
                    }
                    else {
                        url += "?f=pjson";
                    }
                }
                String TokenResponse = "";
                //ESB代理的地址需要解密
                if(HttpOperateUtils.isgzip(url)) {
                    TokenResponse = HttpUtils.getGZip(url);
                }
                else {
                    TokenResponse = HttpOperateUtils.httpGet(url);
                }
                JSONObject jsStr = JSONObject.parseObject(TokenResponse);
                if(jsStr.containsKey("fields")) {
                    JSONArray obj = JSONArray.parseArray(jsStr.get("fields").toString());
                    for (int i = 0; i < obj.size(); i++) {
                        List.add(obj.getJSONObject(i).getString("name"));
                    }
                }
            } catch (IOException e) {
                e.printStackTrace();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        model.addAttribute("list", List);
        model.addAttribute("resourceid", resourceid);
        model.addAttribute("moduleid", thismoduleid);
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("jspwebroot", sysConfig.getPubzyWebRoot().replace("javapubzy/", ""));// 临时处理
        model.addAttribute("settype", settype);
        ServiceConfig serviceConfig = new ServiceConfig();
        String key = "";
        List fieldsList = new ArrayList();
        StringBuilder str = new StringBuilder();
        String fileds = "[]";
        //编辑配置相关信息
        if (name != null && !name.equals("")) {
            //判断是属于哪一项，获取对应的json
            if (name.substring(0, 1).equals("v")) {
                key = "vars";
            }
            if (name.substring(0, 1).equals("t")) {
                key = "tables";
            }
            if (name.substring(0, 1).equals("c")) {
                key = "charts";
            }
            if ((settype == 0 && resExtBusinessLayer != null && resExtBusinessLayer.getServiceConfig() != null) || (settype == 1 && resThemeModule != null && resThemeModule.getServiceconfig() != null && !resThemeModule.getServiceconfig().trim().equals(""))) {
                JSONObject obj = JSONObject.parseObject(settype == 0 ?resExtBusinessLayer.getServiceConfig():resThemeModule.getServiceconfig());
                JSONObject newobj = null;
                boolean flag = false;
                if (obj.getJSONArray(key) != null) {
                    //获取所要编辑的项所在的json数组
                    JSONArray jsonArray = obj.getJSONArray(key);
                    if (jsonArray != null) {
                        //遍历数组，如果key一致则取出相关配置信息，退出循环
                        for (int j = 0; j < jsonArray.size(); j++) {
                            org.json.JSONObject jsonObject = new org.json.JSONObject(jsonArray.getJSONObject(j));
                            Iterator iterator = jsonObject.keys();
                            while (iterator.hasNext()) {
                                String skey = (String) iterator.next();
                                if (skey.equals(name)) {
                                    newobj = JSONObject.parseObject(jsonArray.getString(j));
                                    newobj = JSONObject.parseObject(newobj.getString(name));
                                    if (key.equals("vars")) {
                                        serviceConfig.setField(newobj.getString("field"));
                                        serviceConfig.setFunc(newobj.getString("StatisticalMethod"));
                                        serviceConfig.setWhere(newobj.getString("where"));
                                        serviceConfig.setExplain(newobj.getString("explain"));
                                        serviceConfig.setDecimalDigits(newobj.getString("DecimalDigits"));
                                        serviceConfig.setUnitConversion(newobj.getString("UnitConversion"));
                                    }
                                    if (key.equals("tables")) {
                                        serviceConfig.setGroupby(newobj.getString("groupby"));
                                        serviceConfig.setGroupbyalias(newobj.getString("groupbyalias"));
                                        serviceConfig.setWhere(newobj.getString("where"));
                                        serviceConfig.setExplain(newobj.getString("explain"));
                                        serviceConfig.setDecimalDigits(newobj.getString("DecimalDigits"));
                                        serviceConfig.setUnitConversion(newobj.getString("UnitConversion"));
                                        JSONArray tableArray = newobj.getJSONArray("list");
                                        fileds  =newobj.getString("list");
                                    }
                                    if (key.equals("charts")) {
                                        serviceConfig.setId(newobj.getString("id"));
                                        serviceConfig.setClassfield(newobj.getString("classField"));
                                        serviceConfig.setStatisticalmethod(newobj.getString("StatisticalMethod"));
                                        serviceConfig.setTitle(newobj.getString("title"));
                                        serviceConfig.setType(newobj.getString("type"));
                                        serviceConfig.setDisplaymode(newobj.getString("displayMode"));
                                        serviceConfig.setOption(newobj.getString("option"));
                                        serviceConfig.setValuefield(newobj.getString("ValueField"));
                                        serviceConfig.setWhere(newobj.getString("where"));
                                        serviceConfig.setExplain(newobj.getString("explain"));
                                        serviceConfig.setDecimalDigits(newobj.getString("DecimalDigits"));
                                        serviceConfig.setUnitConversion(newobj.getString("UnitConversion"));
                                    }
                                    flag = true;
                                    break;
                                }
                            }
                            if (flag) break;
                        }
                    }
                }
            }
        }
        model.addAttribute("jsonconfig", serviceConfig);
        if (key.equals("") && type != null) {
            key = type;
        }
        model.addAttribute("jsontype", key);
        model.addAttribute("jsonname", name);
        model.addAttribute("fieldsList", fileds);

        List<Res_EchartsConfing> resEchartsConfingList = resEchartsCofingService.selectAllChart(settype);
        JSONArray echarts = new JSONArray();
        for (int i=0;i<resEchartsConfingList.size();i++) {
            String echart = "{\"id\":\"" + resEchartsConfingList.get(i).getEchartsid() +
                    "\",\"type\":\"" + resEchartsConfingList.get(i).getEchartstype() + "\",\"key\":\"" + resEchartsConfingList.get(i).getEchartstitle() + "\"}";
            echarts.add(JSONObject.parseObject(echart));
        }
        model.addAttribute("echarts",echarts);
        return "common/add_ServiceConfig";
    }

    /**
     * 保存相关配置
     *
     * @param resourceid    资源 ID
     * @param contype       保存所属类别 如：vars，tables
     * @param serviceConfig 相关配置字段信息
     * @param serviceHTML   编辑器HTML内容
     * @return
     */
    @ResponseBody
    @RequestMapping("saveconfig")
    public String saveconfig(Integer resourceid, String contype, ServiceConfig serviceConfig, String serviceHTML, Integer moduleid,Integer settype) {
        Res_ExtBusinessLayer resExtBusinessLayer = null;
        Res_Theme_Module resThemeModule = new Res_Theme_Module();
        if (settype == 0) {
            resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        }
        String id = "";
        if (contype != null && !contype.equals("")) {
            //数据库存在对应的配置
            if ((settype == 0 && resExtBusinessLayer != null && resExtBusinessLayer.getServiceConfig() != null)) {
                JSONObject obj = JSONObject.parseObject(resExtBusinessLayer.getServiceConfig());
                StringBuilder sb = new StringBuilder();
                //新增常量配置，直接往已有的数据插入数据
                if (contype.equals("vars")) {
//                    Integer i = obj.getJSONArray("vars").size() + 1;
                    JSONArray varsObj = JSONArray.parseArray(obj.getString("vars"));
                    String i = getConfigNum("vars", varsObj); //获取list最大一个名称的数值，避免因删除出现重名
                    sb.append("{");
                    sb.append("\"field\":\"" + serviceConfig.getField() + "\"");
                    sb.append(",\"StatisticalMethod\":\"" + serviceConfig.getFunc() + "\"");
                    sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                    sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                    sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                    sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                    sb.append("}");
                    String vars = "{'name':'var" + i + "'," + "'var" + i + "':" + sb.toString() + "}";
                    //往vars插入新增数据
                    String ff = jsonString(vars);
                    varsObj.add(JSONObject.parseObject(ff));
//                    替换
                    obj.replace("vars", varsObj);
                    id = "var" + i;
                } else if (contype.equals("tables")) {
//                    Integer i = obj.getJSONArray("tables").size() + 1;
                    JSONArray tablesObj = JSONArray.parseArray(obj.getString("tables"));
                    String i = getConfigNum("tables", tablesObj);
                    sb.append("{");
                    sb.append("\"groupby\":\"" + serviceConfig.getGroupby() + "\"");
                    sb.append(",\"groupbyalias\":\"" + serviceConfig.getGroupbyalias() + "\"");
                    sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                    sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                    sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                    sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                    sb.append(",\"list\":[");
                    sb.append(serviceConfig.getFields());
                    sb.append("]");
                    sb.append("}");
                    String tables = "{'name':'table" + i + "'," + "'table" + i + "':" + sb.toString() + "}";
                    //往vars插入新增数据
                    String ff = jsonString(tables);
                    tablesObj.add(JSONObject.parseObject(ff));
                    //替换
                    obj.replace("tables", tablesObj);
                    id = "table" + i;
                } else if (contype.equals("charts")) {
//                    Integer i = obj.getJSONArray("charts").size() + 1;
                    JSONArray chartsObj = JSONArray.parseArray(obj.getString("charts"));
                    String i = getConfigNum("tables", chartsObj);
                    sb.append("{");
                    sb.append("\"id\":\"" + serviceConfig.getId() + "\"");
                    sb.append(",\"title\":\"" + serviceConfig.getTitle() + "\"");
                    sb.append(",\"type\":\"" + serviceConfig.getType() + "\"");
                    sb.append(",\"displayMode\":\"" + serviceConfig.getDisplaymode() + "\"");
                    sb.append(",\"classField\":\"" + serviceConfig.getClassfield() + "\"");
                    sb.append(",\"ValueField\":\"" + serviceConfig.getValuefield() + "\"");
                    sb.append(",\"StatisticalMethod\":\"" + serviceConfig.getStatisticalmethod() + "\"");
                    sb.append(",\"option\":\"" + serviceConfig.getOption() + "\"");
                    sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                    sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                    sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                    sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                    sb.append("}");
                    String charts = "{'name':'chart" + i + "'," + "'chart" + i + "':" + sb.toString() + "}";
                    //往vars插入新增数据
                    String ff = jsonString(charts);
                    chartsObj.add(JSONObject.parseObject(ff));
                    //替换
                    obj.replace("charts", chartsObj);
                    id = "chart" + i;
                }
                resExtBusinessLayer.setServiceConfig(obj.toString());
            } else {
                StringBuilder sb = new StringBuilder();
                sb.append("{");

                if (contype.equals("vars")) {
                    sb.append("\"vars\":[{");
                    sb.append("\"name\":\"var1\",");
                    sb.append("\"var1\":{");
                    sb.append("\"field\":\"" + serviceConfig.getField() + "\"");
                    sb.append(",\"StatisticalMethod\":\"" + serviceConfig.getFunc() + "\"");
                    sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                    sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                    sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                    sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                    sb.append("}");
                    sb.append("}],");
                    sb.append("\"tables\":[],");
                    sb.append("\"charts\":[]");
                    id = "var1";
                } else if (contype.equals("tables")) {
                    sb.append("\"vars\":[],");
                    sb.append("\"tables\":[{");
                    sb.append("\"name\":\"table1\",");
                    sb.append("\"table1\":{");
                    sb.append("\"groupby\":\"" + serviceConfig.getGroupby() + "\"");
                    sb.append(",\"groupbyalias\":\"" + serviceConfig.getGroupbyalias() + "\"");
                    sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                    sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                    sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                    sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                    sb.append(",\"list\":[");
                    sb.append(serviceConfig.getFields());
                    sb.append("]");
                    sb.append("}");
                    sb.append("}],");
                    sb.append("\"charts\":[]");
                    id = "table1";
                } else if (contype.equals("charts")) {
                    sb.append("\"vars\":[],");
                    sb.append("\"tables\":[],");
                    sb.append("\"charts\":[{");
                    sb.append("\"name\":\"chart1\",");
                    sb.append("\"chart1\":{");
                    sb.append("\"id\":\"" + serviceConfig.getId() + "\"");
                    sb.append(",\"title\":\"" + serviceConfig.getTitle() + "\"");
                    sb.append(",\"type\":\"" + serviceConfig.getType() + "\"");
                    sb.append(",\"displayMode\":\"" + serviceConfig.getDisplaymode() + "\"");
                    sb.append(",\"classField\":\"" + serviceConfig.getClassfield() + "\"");
                    sb.append(",\"ValueField\":\"" + serviceConfig.getValuefield() + "\"");
                    sb.append(",\"StatisticalMethod\":\"" + serviceConfig.getStatisticalmethod() + "\"");
                    sb.append(",\"option\":\"" + serviceConfig.getOption() + "\"");
                    sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                    sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                    sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                    sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                    sb.append("}");
                    sb.append("}]");
                    id = "chart1";
                }

                sb.append("}");
                String ff = jsonString(sb.toString());
                if (settype == 0) {
                    resExtBusinessLayer.setServiceConfig(ff);
                } else {
                    resThemeModule.setServiceconfig(ff);
                }
            }
        }
        if (settype == 0) {
            int count = resExtBusinessLayerService.updateByPrimaryKeySelective(resExtBusinessLayer);
            if (count > 0) {
                return "{'success':'success','id':'" + id + "'}";
            } else {
                return "{'success':'erro'}";
            }
        } else {
            return "{'success':'success','charttitle':'" + (contype.equals("tables") ? serviceConfig.getGroupbyalias() : serviceConfig.getTitle()) + "','serviceconfig':" + (resThemeModule.getServiceconfig() != null ? resThemeModule.getServiceconfig() : "") + "}";
        }
    }

    /**
     * 编辑配置信息
     *
     * @param name          需要修改的变量 如：var1，table1
     * @param resourceid    资源ID
     * @param serviceConfig 相关配置字段信息
     * @param serviceHTML   编辑器HTML内容
     * @return
     */
    @RequestMapping("editserviceconfig")
    @ResponseBody
    public String editServiceConfig(String name, Integer resourceid, ServiceConfig serviceConfig, String serviceHTML,Integer moduleid,Integer settype) {
        Res_ExtBusinessLayer resExtBusinessLayer = null;
        Res_Theme_Module resThemeModule = null;
        if (moduleid == 0) {
            resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        } else {
            resThemeModule = resThemeModuleService.selectByid(moduleid);
        }
        String key = "";
        if (name != null && !name.equals("")) {
            if (name.substring(0, 1).equals("v")) {
                key = "vars";
            }
            if (name.substring(0, 1).equals("t")) {
                key = "tables";
            }
            if (name.substring(0, 1).equals("c")) {
                key = "charts";
            }
            StringBuilder sb = new StringBuilder();

            if ((settype == 0 && resExtBusinessLayer != null && resExtBusinessLayer.getServiceConfig() != null) || (settype == 1 &&resThemeModule != null && resThemeModule.getServiceconfig() != null && !resThemeModule.getServiceconfig().trim().equals(""))) {
                JSONObject obj = JSONObject.parseObject(settype == 0 ? resExtBusinessLayer.getServiceConfig() : resThemeModule.getServiceconfig());
                boolean flag = false;
                if (obj.getJSONArray(key) != null) {
                    JSONArray jsonArray = obj.getJSONArray(key);
                    if (jsonArray != null) {
                        for (int j = 0; j < jsonArray.size(); j++) {
                            org.json.JSONObject jsonObject = new org.json.JSONObject(jsonArray.getJSONObject(j));
                            Iterator iterator = jsonObject.keys();
                            while (iterator.hasNext()) {
                                String skey = (String) iterator.next();
                                if (skey.equals(name)) {
                                    //找到编辑的项则替换掉旧的
                                    if (key.equals("vars")) {
                                        sb.append("{");
                                        sb.append("\"field\":\"" + serviceConfig.getField() + "\"");
                                        sb.append(",\"StatisticalMethod\":\"" + serviceConfig.getFunc() + "\"");
                                        sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                                        sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                                        sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                                        sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                                        sb.append("}");
                                    } else if (key.equals("tables")) {
                                        sb.append("{");
                                        sb.append("\"groupby\":\"" + serviceConfig.getGroupby() + "\"");
                                        sb.append(",\"groupbyalias\":\"" + serviceConfig.getGroupbyalias() + "\"");
                                        sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                                        sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                                        sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                                        sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                                        sb.append(",\"list\":[");
                                        sb.append(serviceConfig.getFields());
                                        sb.append("]");
                                        sb.append("}");
                                    } else if (key.equals("charts")) {
                                        sb.append("{");
                                        sb.append("\"id\":\"" + serviceConfig.getId() + "\"");
                                        sb.append(",\"title\":\"" + serviceConfig.getTitle() + "\"");
                                        sb.append(",\"type\":\"" + serviceConfig.getType() + "\"");
                                        sb.append(",\"displayMode\":\"" + serviceConfig.getDisplaymode() + "\"");
                                        sb.append(",\"classField\":\"" + serviceConfig.getClassfield() + "\"");
                                        sb.append(",\"ValueField\":\"" + serviceConfig.getValuefield() + "\"");
                                        sb.append(",\"StatisticalMethod\":\"" + serviceConfig.getStatisticalmethod() + "\"");
                                        sb.append(",\"option\":\"" + serviceConfig.getOption() + "\"");
                                        sb.append(",\"where\":\"" + serviceConfig.getWhere() + "\"");
                                        sb.append(",\"explain\":\"" + serviceConfig.getExplain() + "\"");
                                        sb.append(",\"DecimalDigits\":\"" + serviceConfig.getDecimalDigits() + "\"");
                                        sb.append(",\"UnitConversion\":\"" + serviceConfig.getUnitConversion() + "\"");
                                        sb.append("}");
                                    }
                                    String ff = jsonString(sb.toString());
                                    jsonArray.getJSONObject(j).replace(name, JSONObject.parseObject(ff));
                                    flag = true;
                                    break;
                                }
                            }
                            if (flag) break;
                        }
                    }
                }
                if (settype == 0) {
                    resExtBusinessLayer.setServiceConfig(obj.toString());
                } else {
                    resThemeModule.setServiceconfig(obj.toString());
                }
            }
        }
//        String replaceHTML = replaceServiceHTML(serviceHTML, resourceid, "charToHTML");
//        resExtBusinessLayer.setServiceHTML(replaceHTML);
        if (settype == 0) {
            int count = resExtBusinessLayerService.updateByPrimaryKeySelective(resExtBusinessLayer);
            if (count > 0) {
                return "{'success':'success'}";
            }
            return "{'success':'erro'}";
        } else {
            return "{'success':'success','charttitle':'" + (key.equals("tables") ? serviceConfig.getGroupbyalias() : serviceConfig.getTitle()) + "','serviceconfig':" + (resThemeModule.getServiceconfig() != null ? resThemeModule.getServiceconfig() :"") + "}";
        }
    }

    @RequestMapping("saveHtmlConfig")
    @ResponseBody
    public String saveHtmlConfig(String serviceHTML,Integer resourceid) {
        Res_ExtBusinessLayer resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        if(resExtBusinessLayer != null) {
            String replaceHTML = replaceServiceHTML(serviceHTML, resourceid, "charToHTML");
            resExtBusinessLayer.setServiceHTML(replaceHTML);
            resExtBusinessLayer.setCache("");
            int count = resExtBusinessLayerService.updateByPrimaryKeySelective(resExtBusinessLayer);
            if (count > 0) {
                return "success";
            }
            else {
                return "error";
            }
        }
        else {
            return "error";
        }
    }

    @ResponseBody
    @RequestMapping("matchKeyNotInHTML")
    public String matchKeyNotInHTML(String serviceHTML,Integer resourceid) {
        Res_ExtBusinessLayer resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        String notkey = "";
        if (resExtBusinessLayer.getServiceConfig() != null && !resExtBusinessLayer.getServiceConfig().equals("")) {
            JSONObject obj = JSONObject.parseObject(resExtBusinessLayer.getServiceConfig());
            for (int i = 0; i < obj.size(); i++) {
                JSONArray object = null;
                //每次只取一个类
                if (i == 0) {
                    if (obj.getJSONArray("vars") != null) {
                        object = obj.getJSONArray("vars");
                    }
                }
                if (i == 1) {
                    if (obj.getJSONArray("tables") != null) {
                        object = obj.getJSONArray("tables");
                    }
                }
                if (i == 2) {
                    if (obj.getJSONArray("charts") != null) {
                        object = obj.getJSONArray("charts");
                    }
                }
                if (object != null) {
                    for (int j = 0; j < object.size(); j++) {
                        String key = object.getJSONObject(j).getString("name");
                        Pattern p = Pattern.compile(key);
                        Matcher m = p.matcher(serviceHTML);
                        boolean flag = false;
                        if(m.find()) {
                            flag = true;
                            if(flag) continue;
                        }
                        if (!flag) {
                            if(notkey != "") notkey += ",";
                            String keyString = "{" + key + "}";
                            notkey += keyString;
                        }
                    }
                }
            }
        }
        return notkey;
    }


    /**
     * 删除配置信息
     */
    @RequestMapping("delserviceconfig")
    @ResponseBody
    public String delServiceConfig(String name, Integer resourceid) {
        String key = "";
        String type = "";
        //判断是属于哪一项，获取对应的json
        if (name.substring(0, 1).equals("v")) {
            key = "vars";
            type = "var";
        }
        if (name.substring(0, 1).equals("t")) {
            key = "tables";
            type = "table";
        }
        if (name.substring(0, 1).equals("c")) {
            key = "charts";
            type = "chart";
        }
        Res_ExtBusinessLayer resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        if (resExtBusinessLayer.getServiceConfig() != null) {
            JSONObject obj = JSONObject.parseObject(resExtBusinessLayer.getServiceConfig());
            boolean flag = false;
            if (obj.getJSONArray(key) != null) {
                //获取所要删除的项所在的json数组
                JSONArray jsonArray = obj.getJSONArray(key);
                if (jsonArray != null) {
                    //遍历数组，如果name一致则直接删除，退出循环
                    for (int j = 0; j < jsonArray.size(); j++) {
                        org.json.JSONObject jsonObject = new org.json.JSONObject(jsonArray.getJSONObject(j));
                        Iterator iterator = jsonObject.keys();
                        while (iterator.hasNext()) {
                            String skey = (String) iterator.next();
                            if (skey.equals(name)) {
                                //找到删除该项
                                jsonArray.remove(j);
                                flag = true;
                                break;
                            }
                        }
                        if (flag) break;
                    }
                }
//                jsonArray = newSortJson(jsonArray, type);
            }
            resExtBusinessLayer.setServiceConfig(obj.toString());
            int count = resExtBusinessLayerService.updateByPrimaryKeySelective(resExtBusinessLayer);
            if (count > 0) {
                return "success";
            }
        }
        return "error";
    }

    /**
     * 获取配置的变量键，用来命名变量值 如：var + 返回值
     *
     * @param type      类别
     * @param jsonArray json数组
     * @return
     */
    public String getConfigNum(String type, JSONArray jsonArray) {
        String i = "";
        if (jsonArray != null && jsonArray.size() > 0) {
            int max = 1;
            for (int j = 0; j < jsonArray.size(); j++) {
                String key = jsonArray.getJSONObject(j).getString("name");
                if (type.equals("vars")) {
                    int t = Integer.parseInt(key.substring(3, key.length())) + 1;
                    if (max < t) {
                        max = t;
                    }
                } else if (type.equals("tables") || type.equals("charts")) {
                    int t = Integer.parseInt(key.substring(5, key.length())) + 1;
                    if (max < t) {
                        max = t;
                    }
                }
            }
            i = String.valueOf(max);
        } else {
            i = "1";
        }
        return i;
    }

    //替换占位符
    public String replaceServiceHTML(String serviceHTML, Integer resourceid, String type) {
        //获取list
        Res_ExtBusinessLayer resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
        if (resExtBusinessLayer.getServiceConfig() != null && !resExtBusinessLayer.getServiceConfig().equals("")) {
            JSONObject obj = JSONObject.parseObject(resExtBusinessLayer.getServiceConfig());
            for (int i = 0; i < obj.size(); i++) {
                JSONArray object = null;
                String replaceString = "";
                String contype = "";
                //每次只取一个类
                if (i == 0) {
                    if (obj.getJSONArray("vars") != null) {
                        object = obj.getJSONArray("vars");
                        contype = "vars";
                    }
                }
                if (i == 1) {
                    if (obj.getJSONArray("tables") != null) {
                        object = obj.getJSONArray("tables");
                        contype = "tables";
                    }
                }
                if (i == 2) {
                    if (obj.getJSONArray("charts") != null) {
                        object = obj.getJSONArray("charts");
                        contype = "charts";
                    }
                }
                if (object != null) {
                    for (int j = 0; j < object.size(); j++) {
                        org.json.JSONObject jsonObject = new org.json.JSONObject(object.getJSONObject(j));
                        Iterator iterator = jsonObject.keys();
                        while (iterator.hasNext()) {
                            if (contype.equals("vars")) {
                                replaceString = "<span id='var'></span>";
                            } else if (contype.equals("tables")) {
                                replaceString = "<div id='var' class='radius'></div>";
                            } else if (contype.equals("charts")) {
                                replaceString = "<div id='var' class='radius top-border chart'></div>";
                            }
                            String key = (String) iterator.next();
                            replaceString = replaceString.replace("var", key);
                            String keyString = '{' + key + '}';
                            if (type.equals("charToHTML")) {
                                serviceHTML = serviceHTML.replace(keyString, replaceString);
                            }
                            if (type.equals("htmlToChar")) {
                                serviceHTML = serviceHTML.replace(replaceString, keyString);
                            }
                        }

                    }
                }
            }
        }
        return serviceHTML;
    }

    //删除 后重新组合排序（暂不使用重新排序）
    public JSONArray newSortJson(JSONArray jsonArray, String type) {
        JSONArray array = new JSONArray();
        for (int i = 0; i < jsonArray.size(); i++) {
            //循环获取第i个值，重新拼接
            JSONObject jsonObject = JSONObject.parseObject(jsonArray.getString(i));
            StringBuilder sb = new StringBuilder();
            org.json.JSONObject obj = new org.json.JSONObject(jsonArray.getJSONObject(i));
            Iterator iterator = obj.keys();
            while (iterator.hasNext()) {
                String skey = (String) iterator.next();
                JSONObject object = JSONObject.parseObject(jsonObject.getString(skey));
                sb.append("{");
                Integer nameNum = i + 1;
                sb.append("'name':'" + type + nameNum + "',");
                sb.append("'" + type + nameNum + "':");
                sb.append(jsonObject.getString(skey));
            }
            sb.append("}");
            System.out.println(sb.toString());
            array.add(JSONObject.parseObject(sb.toString()));
        }
        return array;
    }

    //切换图表样式时获取对应样式的echarts默认模板代码
    @ResponseBody
    @RequestMapping("getEchartsCode")
    public String getEchartsCode(Integer echartsid, String jsonname, Integer resourceid,Integer settype,Integer moduleid) {
        //编辑配置相关信息
        String key = "";
        String code = "";
        if (jsonname != null && !jsonname.equals("") && resourceid != null) {
            Res_ExtBusinessLayer resExtBusinessLayer = null;
            Res_Theme_Module resThemeModule = null;
            if(settype == 0 ){
                resExtBusinessLayer = resExtBusinessLayerService.selectByPrimaryKey(resourceid);
            }else{
                resThemeModule = resThemeModuleService.selectByid(moduleid);
            }
            //判断是属于哪一项，获取对应的json
            if (jsonname.substring(0, 1).equals("v")) {
                key = "vars";
            }
            if (jsonname.substring(0, 1).equals("t")) {
                key = "tables";
            }
            if (jsonname.substring(0, 1).equals("c")) {
                key = "charts";
            }
            if ((settype == 0&&resExtBusinessLayer.getServiceConfig() != null && key.equals("charts"))||
                    (settype != 0 &&resThemeModule.getServiceconfig() != null && key.equals("charts"))) {
                JSONObject obj = JSONObject.parseObject(settype==0?resExtBusinessLayer.getServiceConfig():resThemeModule.getServiceconfig());
                JSONObject newobj = null;
                boolean flag = false;
                if (obj.getJSONArray(key) != null) {
                    //获取所要获取的项所在的json数组
                    JSONArray jsonArray = obj.getJSONArray(key);
                    if (jsonArray != null) {
                        //遍历数组，如果key一致则取出相关配置信息，退出循环
                        for (int j = 0; j < jsonArray.size(); j++) {
                            org.json.JSONObject jsonObject = new org.json.JSONObject(jsonArray.getJSONObject(j));
                            Iterator iterator = jsonObject.keys();
                            while (iterator.hasNext()) {
                                String skey = (String) iterator.next();
                                if (skey.equals(jsonname)) {
                                    //如果切换的类型与数据库存的类型一致则取配置过的echarta代码
                                    if (echartsid.equals(jsonArray.getJSONObject(j).getJSONObject(jsonname).getString("id"))) {
                                        code = jsonArray.getJSONObject(j).getJSONObject(jsonname).getString("option");
                                    } else {
                                        Res_EchartsConfing resEchartsCofing = resEchartsCofingService.selectByPrimaryKey(echartsid);
                                        if (resEchartsCofing != null) {
                                            code = resEchartsCofing.getEchartsoption();
                                        }
                                    }
                                    flag = true;
                                    break;
                                }
                                else continue;
                            }
                            if (flag) break;
                        }
                    }
                }
            }
        } else {
            Res_EchartsConfing resEchartsCofing = resEchartsCofingService.selectByPrimaryKey(echartsid);
            if (resEchartsCofing != null) {
                code = resEchartsCofing.getEchartsoption();
            }
        }
        return code;
    }

    //把json化的字符串的键值中的英文双引号转化为单引号，避免因用户输入的英文双引号导致无法json化字符串
    private static String jsonString(String s){
        char[] temp = s.toCharArray();
        int n = temp.length;
        for(int i =0;i<n;i++){
            if(temp[i]==':'&&temp[i+1]=='"'){
                for(int j =i+2;j<n;j++){
                    if(temp[j]=='"'){
                        if(temp[j+1]!=',' &&  temp[j+1]!='}'){
                            temp[j]='\'';
                        }else if(temp[j+1]==',' ||  temp[j+1]=='}'){
                            break ;
                        }
                    }
                }
            }
        }
        return new String(temp);
    }

    //选择图形
    @RequestMapping("/SelectOfChart")
    public String SelectOfChart( Model model,Integer settype){
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("settype",settype);
        return "common/SelectOfChart";
    }
    /**
     * 文件上传
     */
    @ResponseBody
    @RequestMapping("/uploadfile")
    public String uploadfile(@RequestParam("my" +
            "File") MultipartFile file) {
        File desFile = null;
        if (file.isEmpty()) {
            return "No File";
        }
        String uuid = UUID.randomUUID().toString().replaceAll("-", "");
        String name = file.getOriginalFilename();
        String fileType = name.substring(name.lastIndexOf("."));
        String Filename = uuid + fileType;
        String size = org.apache.commons.io.FileUtils.byteCountToDisplaySize(file.getSize());

        String webpath="";
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
        String timePath = sdf.format(new Date().getTime());
        timePath = timePath.replace("-", "");
        Filename = uuid + fileType;
        String path = null;
        path = sysConfig.getUploadPath() + "ECharts\\"+timePath + "\\";
        File filePath = new File(path); // 创建对应的年月文件夹
        if (!filePath.exists()) {
            filePath.mkdirs();
        }
        //文件网络地址
        webpath ="ECharts/"+ timePath + "/" + Filename; // 类型为文件指向文件
        desFile = new File(path + Filename);
        String info = desFile.getAbsolutePath();
        System.out.println("info:" + info);
        System.out.println("info:" + webpath);
        try {
            org.apache.commons.io.FileUtils.copyInputStreamToFile(file.getInputStream(), desFile);
            return "{'result':'1','Path':'"+webpath+"','Filename':'"+name.substring(name.lastIndexOf("\\")+1,name.lastIndexOf("."))+"','size':'"+size.substring(0,size.lastIndexOf(" "))+"','unit':'"+size.substring(size.lastIndexOf(" ")+1,size.length())+"','FileType':'"+fileType+"'}";
        } catch (IOException e) {
            e.printStackTrace();
            return "{'result':'0'}";
        }
    }

    /**
     * @Author: lizhao
     * @Date: 2018-09-29 9:44
     * @param null
     * @Description:根据type查询，对应的类型
     *
     */
    @ResponseBody
    @RequestMapping("/SelectEchartsType")
    public String SelectEchartsType(Res_EchartsConfing echartsConfing){
        Res_EchartsConfing res_echartsConfing=resEchartsCofingService.selectEchartsType(echartsConfing);
        return res_echartsConfing.getEchartstype();
    }


    /**
     * 门户用户信息栏页面
     * @param model
     * @return
     */
    @RequestMapping("liferay/userinfo")
    public String userinfo(Model model) {
        model.addAttribute("pubzyWebRoot", sysConfig.getPubzyWebRoot());
        model.addAttribute("loginname", getUser().getChinesename());
        model.addAttribute("lanbaseRoot", sysConfig.getApiServer());
        return "liferay_userinfo";
    }


    /**
     * 根据单位名称获取首字母值
     */
    @SysLog("根据名称获取首字母值")
    @GetMapping("/changeToPinYin")
    @ResponseBody
    @ApiOperation(
            value = "根据单位获取首字母值",
            notes = ""
    )
    public Result changeToPinYin(@ApiParam(name="pinyin",value="字段pinyin",required=true)@RequestParam String name){
        name = name.replaceAll("%(?![0-9a-fA-F]{2})", "%25");
        String namepinyin = JpinyinUtils.changeToGetShortPinYin(URLDecoder.decode(name));
        //首字母小写转化大写
        String pinyin = namepinyin.toUpperCase();
        String patt="[^a-z|A-Z]";
        pinyin = pinyin.replaceAll(patt,"");
        return Result.ok().put("pinyin", URLEncoder.encode(pinyin));
    }

}