业务类型查询模板接口上传

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/frameworkcore/compatibility/impl/SmFunctionQueryServicePlatformImpl.java

@@ -395,12 +395,16 @@
                    throw new VciBaseException(String.valueOf(e.code),e.messages);
                }
            }
        }else if(parentId.equals("sysOptionNode")){
        }else if(parentId.equals("operateNode")){
            //加载所有操作
            try{
                //将返回的节点外层套上当前父节点
                MenuVO parentNode = JsonConfigReader.getSysModuleConf().getOperateNode();
                List<MenuVO> menuVOS = new ArrayList<>();
                //如果查询的是第一层节点就需要直接返回sysOptionNode节点
                if(Func.isNotBlank(modeType) && modeType.equals("firstNode")){
                    menuVOList.add(parentNode);
                    return menuVOList;
                }
                OperateInfo[] operateInfos = platformClientUtil.getFrameworkService().getOperateTreeList(parentId);
                for(int i = 0; i < operateInfos.length;i++ ){
                    OperateInfo operateInfo = operateInfos[i];
@@ -416,10 +420,8 @@
                    menuVO.setSort((int) operateInfo.seq);
                    menuVO.setModeType("operateObject");
                    menuVO.setHasChildren(false);
                    menuVOS.add(menuVO);
                    menuVOList.add(menuVO);
                }
                parentNode.setChildren(menuVOS);
                menuVOList.add(parentNode);
            }catch (PLException e) {
                e.printStackTrace();
                throw new VciBaseException(String.valueOf(e.code),new String[]{VciBaseUtil.getExceptionMessage(e)});

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/controller/HMSysModConfigController.java

@@ -1,7 +1,6 @@
package com.vci.web.controller;

import com.vci.constant.FrameWorkLangCodeConstant;
import com.vci.corba.framework.data.AppConfigDetailInfo;
import com.vci.corba.framework.data.FuncOperationInfo;
import com.vci.corba.framework.data.OperateInfo;
import com.vci.frameworkcore.compatibility.ISmFunctionQueryService;
@@ -9,7 +8,6 @@
import com.vci.pagemodel.AppConfigDetailInfoVO;
import com.vci.pagemodel.ExpExcelConditionVO;
import com.vci.pagemodel.MenuVO;
import com.vci.starter.web.annotation.controller.VciUnCheckRight;
import com.vci.starter.web.exception.VciBaseException;
import com.vci.starter.web.pagemodel.BaseResult;
import com.vci.starter.web.util.ControllerUtil;
@@ -19,7 +17,6 @@
import org.apache.commons.lang3.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

@@ -188,7 +185,7 @@
            return BaseResult.success(hmSysModConfigService.addOperationType(operateInfo),"添加操作类型成功");
        }catch (Exception e){
            e.printStackTrace();
            String errorMsg = "删除模块时出现错误，原因："+ VciBaseUtil.getExceptionMessage(e);
            String errorMsg = "添加操作类型时出现错误，原因："+ VciBaseUtil.getExceptionMessage(e);
            logger.error(errorMsg);
            throw new VciBaseException(errorMsg);
        }

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/controller/OsQueryTemplateController.java

@@ -147,6 +147,39 @@
    }

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿ä¸‹çš„查询条件的查询按钮查询list列表
     * @param qtInfoDTO
     * @return æŸ¥è¯¢ç»“æžœ
     */
    @PostMapping("/getCriteriaBtm")
    public BaseResult getCriteriaBtm(@RequestBody QTInfoDTO qtInfoDTO){
        try {
            return quereyTemplateServiceI.getCriteriaBtm(qtInfoDTO);
        } catch (PLException e) {
            BaseResult objectBaseResult = new BaseResult<>();
            objectBaseResult.setCode(Integer.parseInt(e.code));
            objectBaseResult.setMsg(Arrays.toString(e.messages));
            return objectBaseResult;
        }
    }

    /**
     * æŸ¥è¯¢æ¡ä»¶ä¸‹çš„选择查询模板对话框（查询全部模板和所对应的业务类型或链接类型名）
     * @return
     */
    @GetMapping("/getAllQTs")
    public BaseResult getAllQTs(){
        try {
            return quereyTemplateServiceI.getAllQTs();
        } catch (PLException e) {
            BaseResult objectBaseResult = new BaseResult<>();
            objectBaseResult.setCode(Integer.parseInt(e.code));
            objectBaseResult.setMsg(Arrays.toString(e.messages));
            return objectBaseResult;
        }
    }

    /**
     * æŸ¥è¯¢æ¨¡æ¿åˆ—表
     * @param btName ç±»åž‹åç§°
     * @return æŸ¥è¯¢ç»“æžœ
@@ -258,4 +291,78 @@
            return objectBaseResult;
        }
    }

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿ä¿å­˜
     * @param qtInfoDTO ä¿å­˜ä¼ è¾“对象
     * @return ä¿å­˜ç»“æžœ
     */
    @PostMapping("/btmSave")
    public BaseResult btmSave(@RequestBody QTInfoDTO qtInfoDTO){
        try {
            return quereyTemplateServiceI.btmSave(qtInfoDTO);
        } catch (PLException e) {
            BaseResult objectBaseResult = new BaseResult<>();
            objectBaseResult.setCode(Integer.parseInt(e.code));
            objectBaseResult.setMsg(Arrays.toString(e.messages));
            return objectBaseResult;
        }
    }

    /**
     * æ›´æ–°æ•°æ®åº“结构
     * @return æ›´æ–°ç»“æžœ
     */
    @PostMapping("/updateDBStructure")
    public BaseResult btmSave(){
        try {
            return quereyTemplateServiceI.updateDBStructure();
        } catch (PLException e) {
            BaseResult objectBaseResult = new BaseResult<>();
            objectBaseResult.setCode(Integer.parseInt(e.code));
            objectBaseResult.setMsg(Arrays.toString(e.messages));
            return objectBaseResult;
        }
    }

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿æ ‘查询，用于界面的导出功能
     * @return æŸ¥è¯¢ç»“æžœ
     */
    @GetMapping("/getBtmQtTree")
    public BaseResult getBtmQtTree(){
        try {
            return quereyTemplateServiceI.getBtmQtTree();
        } catch (PLException e) {
            BaseResult objectBaseResult = new BaseResult<>();
            objectBaseResult.setCode(Integer.parseInt(e.code));
            objectBaseResult.setMsg(Arrays.toString(e.messages));
            return objectBaseResult;
        }
    }

    /**
     * å¯¼å‡ºä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
     * names æŸ¥è¯¢æ¨¡æ¿å
     * @return
     */
    @PostMapping("/expBtmQTTemplate")
    public void expBtmQTTemplate(@RequestBody List<String> names,HttpServletResponse response) throws PLException, IOException {
        quereyTemplateServiceI.expBtmQTTemplate(names, response);
    }

    /**
     * å¯¼å…¥ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
     * @param file ä¸Šä¼ çš„文件
     * @return å¯¼å…¥ç»“æžœ
     */
    @PostMapping("/impBtmTemplate")
    public BaseResult impBtmTemplate(MultipartFile file){
        try {
            return quereyTemplateServiceI.impBtmTemplate(file);
        }catch (Throwable e) {
            throw new VciBaseException(VciBaseUtil.getExceptionMessage(e),new String[0],e);
        }
    }

}

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/controller/WebBtmTypeController.java

@@ -403,7 +403,15 @@
    @GetMapping(value = "/getAllAttributesByBtmId")
    @VciBusinessLog(operateName = "查看业务类型的属性")
    public BaseResult<List<OsBtmTypeAttributeVO>> getAllAttributesByBtmId(String btmId){
        List<OsBtmTypeAttributeVO> osBtmTypeAttributeVOS = btmService.listAttributeByBtmIdHasDefault(btmId);
        List<OsBtmTypeAttributeVO> osBtmTypeAttributeVOS = null;
        try {
            osBtmTypeAttributeVOS = btmService.listAttributeByBtmIdHasDefault(btmId);
        } catch (PLException e) {
            e.printStackTrace();
            String exceptionMessage = VciBaseUtil.getExceptionMessage(e);
            logger.error(exceptionMessage);
            throw new VciBaseException(exceptionMessage);
        }
        return BaseResult.dataList(osBtmTypeAttributeVOS);
    }

@@ -457,7 +465,15 @@
        String hasDefaultAttr = baseQueryObject.getConditionMap().getOrDefault("hasDefaultAttr","false");
        String attrId = baseQueryObject.getConditionMap().containsKey("name")?baseQueryObject.getConditionMap().get("name").replace("*",""):"";
        String attrName = baseQueryObject.getConditionMap().containsKey("label") ? baseQueryObject.getConditionMap().get("label").replace("*","") : "";
        List<OsBtmTypeAttributeVO> boAttrs = btmService.listAttributeByBtmId(btmTypeId);
        List<OsBtmTypeAttributeVO> boAttrs = null;
        try {
            boAttrs = btmService.listAttributeByBtmId(btmTypeId);
        } catch (PLException e) {
            e.printStackTrace();
            String exceptionMessage = VciBaseUtil.getExceptionMessage(e);
            logger.error(exceptionMessage);
            throw new VciBaseException(exceptionMessage);
        }
        if(boAttrs == null){
            boAttrs = new ArrayList<>();
        }
@@ -505,7 +521,15 @@
        String attrId = baseQueryObject.getConditionMap().containsKey("name")?baseQueryObject.getConditionMap().get("name").replace("*",""):"";
        String attrName = baseQueryObject.getConditionMap().containsKey("label") ? baseQueryObject.getConditionMap().get("label").replace("*","") : "";
        OsBtmTypeVO btmTypeVO = btmService.selectByOid(btmTypeOid);
        List<OsBtmTypeAttributeVO> boAttrs = btmService.listAttributeByBtmId(btmTypeVO.getId());
        List<OsBtmTypeAttributeVO> boAttrs = null;
        try {
            boAttrs = btmService.listAttributeByBtmId(btmTypeVO.getId());
        } catch (PLException e) {
            e.printStackTrace();
            String exceptionMessage = VciBaseUtil.getExceptionMessage(e);
            logger.error(exceptionMessage);
            throw new VciBaseException(exceptionMessage);
        }
        List<OsBtmTypeAttributeVO> attrList = boAttrs.stream().filter(s->{
            boolean usedFlag = true;
            if(StringUtils.isNotBlank(attrId) && !s.getId().contains(attrId)){

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/controller/WebCodeGenSchemaController.java

@@ -1,5 +1,7 @@
package com.vci.web.controller;

import com.vci.corba.common.PLException;
import com.vci.starter.web.exception.VciBaseException;
import com.vci.starter.web.pagemodel.BaseQueryObject;
import com.vci.starter.web.pagemodel.BaseResult;
import com.vci.starter.web.pagemodel.DataGrid;
@@ -7,6 +9,7 @@
import com.vci.starter.web.util.LangBaseUtil;
import com.vci.dto.OsCodeGenSchemaDTO;
import com.vci.pagemodel.OsCodeGenSchemaVO;
import com.vci.starter.web.util.VciBaseUtil;
import com.vci.web.service.OsCodeGenSchemaServiceI;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@@ -71,8 +74,14 @@
     */
    @PostMapping(value = "/productCodeFile")
    public BaseResult productCodeFile(String oid){
        codeGenSchemaService.productCodeFile(oid);
        return BaseResult.success();
        try {
            codeGenSchemaService.productCodeFile(oid);
            return BaseResult.success();
        } catch (PLException e) {
            e.printStackTrace();
            String exceptionMessage = VciBaseUtil.getExceptionMessage(e);
            throw new VciBaseException(exceptionMessage);
        }
    }

    /**

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/other/BtmQTExportData.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,65 @@
package com.vci.web.other;

import com.vci.corba.omd.btm.BizType;
import com.vci.corba.omd.ltm.LinkType;
import com.vci.corba.omd.qtm.QTD;
import com.vci.corba.omd.qtm.QTInfo;

import java.io.Serializable;
import java.util.HashMap;
import java.util.Map;

/**
 * æŸ¥è¯¢ä¸šåŠ¡ç±»åž‹æ¨¡æ¿å¯¼å‡ºæ•°æ®ç±»ï¼šå¯åºåˆ—化为模板文件,同时也兼导出数据控制类
 * @Title        :QTExportData.java
 * @Description    : 
 * @Copyright    :宏博远达科技有限公司
 * @Author        :平台与规划部/ZhongGY/E-mail:zhonggy@vci-tech.com
 * @Date        :2015-6-8
 * @Version        :1
 * @Other        :产生注释:Alt+Shift+J
 */
public class BtmQTExportData implements Serializable{

    private static final long serialVersionUID = 1L;

	
    /**
     * éœ€è¦åºåˆ—化的模板数据
     */
    //
    private Map<String/*类型名称*/, BizType/*类型对象*/> selectedBtmItems = new HashMap<String, BizType>();
    private Map<String/*类型名称*/,String[]/*类型所属属性*/> selectedBtmAttrs = new HashMap<String, String[]>();
    private Map<String/*查询模板名称*/, QTInfo/*查询模板对象*/> allSelectedQTs = new HashMap<String, QTInfo>();
    private Map<String/*类型名称*/, QTD[]/*查询模板定义*/> allQTDs = new HashMap<String, QTD[]>();


    public Map<String, BizType> getSelectedBtmItems() {
        return selectedBtmItems;
    }

    public void setSelectedBtmItems(Map<String, BizType> selectedBtmItems) {
        this.selectedBtmItems = selectedBtmItems;
    }

    public Map<String, String[]> getSelectedBtmAttrs() {
        return selectedBtmAttrs;
    }

    public void setSelectedBtmAttrs(Map<String, String[]> selectedBtmAttrs) {
        this.selectedBtmAttrs = selectedBtmAttrs;
    }

    public Map<String, QTD[]> getAllQTDs() {
        return allQTDs;
    }

    public void setAllQTDs(Map<String, QTD[]> allQTDs) {
        this.allQTDs = allQTDs;
    }

    public Map<String, QTInfo> getAllQTs() {
        return allSelectedQTs;
    }

}

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/OsBtmServiceI.java

@@ -114,14 +114,14 @@
     * @param btmId ä¸šåŠ¡ç±»åž‹çš„编号
     * @return å±žæ€§çš„内容
     */
    List<OsBtmTypeAttributeVO> listAttributeByBtmId(String btmId);
    List<OsBtmTypeAttributeVO> listAttributeByBtmId(String btmId) throws PLException;

    /**
     * æ ¹æ®ä¸šåŠ¡ç±»åž‹èŽ·å–包含的属性--包含基础属性
     * @param btmId ä¸šåŠ¡ç±»åž‹çš„编号
     * @return å±žæ€§çš„内容
     */
    List<OsBtmTypeAttributeVO> listAttributeByBtmIdHasDefault(String btmId);
    List<OsBtmTypeAttributeVO> listAttributeByBtmIdHasDefault(String btmId) throws PLException;

    /**
     * å‚照业务类型

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/OsCodeGenSchemaServiceI.java

@@ -1,4 +1,5 @@
package com.vci.web.service;
import com.vci.corba.common.PLException;
import com.vci.starter.web.exception.VciBaseException;
import com.vci.starter.web.pagemodel.DataGrid;
import com.vci.starter.web.pagemodel.PageHelper;
@@ -59,7 +60,7 @@
     * @param oid æ–¹æ¡ˆçš„主键
     * @throws VciBaseException å‚数为空，方案不存在会抛出异常
     */
    void productCodeFile(String oid) throws VciBaseException;
    void productCodeFile(String oid) throws VciBaseException, PLException;

    /**
     * é¢„览代码文件

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/OsQuereyTemplateServiceI.java

@@ -3,6 +3,7 @@
import com.vci.corba.common.PLException;
import com.vci.corba.omd.ltm.LinkType;
import com.vci.corba.omd.qtm.QTD;
import com.vci.corba.omd.qtm.QTInfo;
import com.vci.dto.QTInfoDTO;
import com.vci.pagemodel.OsBtmTypeAttributeVO;
import com.vci.pagemodel.OsLinkTypeAttributeVO;
@@ -52,7 +53,6 @@
     */
    BaseResult deleteTemplate(String name) throws PLException;
    /**
     *
     * @param qtInfoDTO ä¼ è¾“的数据对象：
     *                linkTypeName é“¾æŽ¥ç±»åž‹ã€
     *                rdPositive æ–¹å‘，true正向，false反向
@@ -106,4 +106,52 @@
     * @return æ“ä½œç»“æžœ
     */
    BaseResult deleteLinkTemplate(List<String> templateNames) throws PLException;

    /**
     * æŸ¥è¯¢æ¡ä»¶ä¸‹çš„查询按钮
     * @param qtInfoDTO
     * @return
     * @throws PLException
     */
    BaseResult getCriteriaBtm(QTInfoDTO qtInfoDTO) throws PLException;

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿ä¿å­˜
     * @param qtInfoDTO ä¿å­˜ä¼ è¾“对象
     * @return ä¿å­˜ç»“æžœ
     */
    BaseResult btmSave(QTInfoDTO qtInfoDTO) throws PLException;

    /**
     * æ›´æ–°æ•°æ®åº“结构
     * @return ä¿å­˜ç»“æžœ
     */
    BaseResult updateDBStructure() throws PLException;

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿æ ‘查询，用于界面的导出功能
     * @return æŸ¥è¯¢ç»“æžœ
     */
    BaseResult getBtmQtTree() throws PLException;

    /**
     * å¯¼å‡ºä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
     * names æŸ¥è¯¢æ¨¡æ¿å
     * @return
     */
    void expBtmQTTemplate(List<String> names, HttpServletResponse response) throws PLException,IOException ;

    /**
     * æŸ¥è¯¢æ¡ä»¶ä¸‹çš„选择查询模板对话框（查询全部模板和所对应的业务类型或链接类型名）
     * @return
     */
    BaseResult getAllQTs() throws PLException;

    /**
     * å¯¼å…¥ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
     * @param file ä¸Šä¼ çš„文件
     * @return å¯¼å…¥ç»“æžœ
     */
    BaseResult impBtmTemplate(MultipartFile file) throws IOException, ClassNotFoundException;

}

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsBtmServiceImpl.java

@@ -38,6 +38,7 @@
import com.vci.starter.poi.constant.ExcelLangCodeConstant;
import com.vci.starter.poi.util.ExcelUtil;
import com.vci.starter.web.annotation.log.VciUnLog;
import com.vci.starter.web.constant.QueryOptionConstant;
import com.vci.starter.web.enumpck.BooleanEnum;
import com.vci.starter.web.exception.VciBaseException;
import com.vci.starter.web.pagemodel.BaseResult;
@@ -358,9 +359,14 @@
     * @return å±žæ€§çš„内容
     */
    @Override
    public List<OsBtmTypeAttributeVO> listAttributeByBtmId(String btmId) {
    public List<OsBtmTypeAttributeVO> listAttributeByBtmId(String btmId) throws PLException {
        VciBaseUtil.alertNotNull(btmId,"业务类型的编号");
        OsBtmTypeVO btmTypeVO = getBtmById(btmId);
        BizType[] bizTypes = platformClientUtil.getBtmService().getBizTypes(btmId);
        if(Func.isEmpty(bizTypes)){
            return new ArrayList<>();
        }
        BizType bizType = bizTypes[0];
        OsBtmTypeVO btmTypeVO = btmDO2VO(bizType);
        List<OsBtmTypeAttributeVO> attributes = btmTypeVO.getAttributes();
        if(attributes == null){
            attributes = new ArrayList<>();
@@ -375,7 +381,7 @@
     * @return å±žæ€§çš„内容
     */
    @Override
    public List<OsBtmTypeAttributeVO> listAttributeByBtmIdHasDefault(String btmId) {
    public List<OsBtmTypeAttributeVO> listAttributeByBtmIdHasDefault(String btmId) throws PLException {
        List<OsBtmTypeAttributeVO> attrVOs = listAttributeByBtmId(btmId);
        if(attrVOs == null){
            attrVOs = new ArrayList<>();
@@ -1216,13 +1222,15 @@
    public boolean addIndex(List<IndexObject> indexObjectList) throws PLException {
        VciBaseUtil.alertNotNull(indexObjectList,"新增的索引信息");
        String btmName = indexObjectList.get(0).getTypeName();
        String indexNames = indexObjectList.stream().map(IndexObject::getIndexName).collect(Collectors.joining());
        String indexNames = indexObjectList.stream().map(IndexObject::getIndexName).collect(Collectors.joining(","));
        String[] oldindexAttr = {indexNames};
        BusinessObject bo;
        List<BusinessObject> boList = new ArrayList<>();
        //先查询当前添加索引是否已经存在，如果存在就先删除再新增实现替换操作
        Map<String, String> conditionMap = new HashMap<>();
        conditionMap.put("typename",btmName);
        //先这样处理，前端现在只做了单次保存，所以不用in
        conditionMap.put("indexname", indexNames);
        List<IndexObject> indexObjects = getIndexByCondition(conditionMap);
        if(indexObjects!=null && indexObjects.size()>0){
            //索引不存在时删除就会报错索引不存在，所以这里有索引才去删除

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsCodeGenSchemaServiceImpl.java

@@ -1,6 +1,7 @@
package com.vci.web.service.impl;

import com.alibaba.fastjson.JSONObject;
import com.vci.corba.common.PLException;
import com.vci.starter.revision.service.RevisionModelUtil;
import com.vci.starter.web.annotation.Column;
import com.vci.starter.web.constant.FrameWorkLcStatusConstant;
@@ -268,7 +269,7 @@
     * @throws VciBaseException å‚数为空，方案不存在会抛出异常
     */
    @Override
    public void productCodeFile(String oid) throws VciBaseException {
    public void productCodeFile(String oid) throws VciBaseException, PLException {
        OsCodeGenSchemaDO codeGenSchemaDO = selectByOid(oid);
        //处理临时文件夹，在临时文件夹中添加codes/{业务类型的英文名称}
        String tempFolder =LocalFileUtil.getProjectFolder();

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsQueryTemplateImpl.java

@@ -3,11 +3,15 @@
import cn.hutool.core.io.FileUtil;
import cn.hutool.core.util.ZipUtil;
import com.alibaba.fastjson.JSONObject;
import com.vci.client.ClientSession;
import com.vci.client.common.oq.OQTool;
import com.vci.client.common.providers.ClientServiceProvider;
import com.vci.common.qt.object.*;
import com.vci.constant.FrameWorkLangCodeConstant;
import com.vci.corba.common.PLException;
import com.vci.corba.omd.atm.AttributeDef;
import com.vci.corba.omd.btm.BizType;
import com.vci.corba.omd.data.BusinessObject;
import com.vci.corba.omd.data.LinkObject;
import com.vci.corba.omd.ltm.LinkType;
import com.vci.corba.omd.qtm.QTD;
@@ -22,8 +26,10 @@
import com.vci.starter.poi.util.ExcelUtil;
import com.vci.starter.web.exception.VciBaseException;
import com.vci.starter.web.pagemodel.BaseResult;
import com.vci.starter.web.pagemodel.DataGrid;
import com.vci.starter.web.pagemodel.Tree;
import com.vci.starter.web.util.*;
import com.vci.web.other.BtmQTExportData;
import com.vci.web.other.LinkQTExportData;
import com.vci.web.service.*;
import com.vci.web.util.DateUtil;
@@ -32,17 +38,22 @@
import com.vci.web.util.WebUtil;
import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.time.DateFormatUtils;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.jdesktop.swingx.JXDatePicker;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import javax.swing.*;
import java.awt.*;
import java.io.*;
import java.util.*;
import java.util.List;
import java.util.stream.Collectors;

/**
@@ -90,7 +101,7 @@
    }

    /**
     * æŸ¥è¯¢æ¨¡æ¿
     * ä¿å­˜æŸ¥è¯¢æ¨¡æ¿
     * @param qtd æŸ¥è¯¢æ¨¡æ¿å®žä½“ç±»
     * @return ä¿å­˜ç»“æžœ
     */
@@ -150,8 +161,7 @@
        }
    }
    /**
     *
     * @param dataMap ä¼ è¾“的数据对象：
     * @param qtInfoDTO ä¼ è¾“的数据对象：
     *                linkTypeName é“¾æŽ¥ç±»åž‹ã€
     *                rdPositive æ–¹å‘，true正向，false反向
     *                btmName ä¸šåŠ¡ç±»åž‹åç§°
@@ -163,7 +173,7 @@
     */
    @Override
    public BaseResult getCriteria(QTInfoDTO qtInfoDTO) throws PLException {
        QueryTemplate qt = getQT(qtInfoDTO);
        QueryTemplate qt = getQT(qtInfoDTO,true);
        String checkInfo = OQTool.checkQT(qt);
        if(!checkInfo.equals("OK")){
            throw new PLException("500", new String[]{checkInfo});
@@ -189,7 +199,7 @@
            qtInfoDTO.setBtmName(obj.btmName);
            qtInfoDTO.setQtName(obj.qtName);
            qtInfoDTO.setLevelFlag(obj.levelFlag);
//            qtInfoDTO.setQtText(obj.qtText);
            //qtInfoDTO.setQtText(obj.qtText);
            qtInfoDTO.setQtUIText(obj.qtUIText);
            if(StringUtils.isNotBlank(obj.qtUIText)){
                //将给定的String文本解析为XML文档并返回新创建的document
@@ -271,7 +281,7 @@
     */
    @Override
    public BaseResult linkSave(QTInfoDTO qtInfoDTO) throws PLException {
        QueryTemplate qt = getQT(qtInfoDTO);
        QueryTemplate qt = getQT(qtInfoDTO,true);
        String checkInfo = OQTool.checkQT(qt);
        if(!checkInfo.equals("OK")){
            throw new PLException("500", new String[]{checkInfo});
@@ -415,17 +425,22 @@
     * ç»„装查询模板
     * @return
     */
    public QueryTemplate getQT(QTInfoDTO qtInfoDTO) throws PLException {
    public QueryTemplate getQT(QTInfoDTO qtInfoDTO,boolean isLinkType) throws PLException {
        QueryTemplate qt = new QueryTemplate();
        qt.setType(QTConstants.TYPE_LINK);
        //TODO String qtId =
        qt.setLinkType(qtInfoDTO.getBtmName());
        qt.setDirection(qtInfoDTO.getQueryTemplate().getDirection());
        qt.setBtmType(qtInfoDTO.getQueryTemplate().getBtmType());

        qt.setVersion(qtInfoDTO.getQueryTemplate().getVersion());
        qt.setQueryISLeaf(qtInfoDTO.getQueryTemplate().isQueryISLeaf());
        qt.setLevel(qtInfoDTO.getQueryTemplate().getLevel());
        if(isLinkType){
            qt.setType(QTConstants.TYPE_LINK);
            qt.setLinkType(qtInfoDTO.getBtmName());
            qt.setDirection(qtInfoDTO.getQueryTemplate().getDirection());
            qt.setBtmType(qtInfoDTO.getQueryTemplate().getBtmType());
            qt.setVersion(qtInfoDTO.getQueryTemplate().getVersion());
            qt.setQueryISLeaf(qtInfoDTO.getQueryTemplate().isQueryISLeaf());
            qt.setLevel(qtInfoDTO.getQueryTemplate().getLevel());
        }else{
            qt.setType(QTConstants.TYPE_BTM);
            qt.setBtmType(qtInfoDTO.getBtmName());
        }

        List<String> clauseList = new ArrayList<String>();
        //TODO æŸ¥è¯¢åˆ— æ˜¾ç¤ºåˆ—
        clauseList.add("*");
@@ -915,7 +930,6 @@
//        return qt;
//    }


    /**
     * è¿”回查询的版本
     * @return
@@ -940,7 +954,6 @@
        return version;
    }


    /**
     * æ ¡éªŒå‚æ•°
     * @param qtd
@@ -957,7 +970,6 @@
            throw new PLException("500", new String[]{"该模板定义名已经被使用, è¯·æ›´æ¢"});
        }
    }


    /**
     * å¯¼å‡ºé“¾æŽ¥ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
@@ -1143,6 +1155,35 @@
        }
    }

    private void getPLQtBtmItem2(String string, BizType bizType, List<BizType> ltsNew) {
        // TODO Auto-generated method stub
        try {
            BizType queryBizType = platformClientUtil.getBtmService().getBizTypes(string)[0];
            BizType[] btmArray = platformClientUtil.getBtmService().getBizTypes("");
            String[] strings = queryBizType.apNameArray;
            boolean b = true;
            for (int i = 0; i < btmArray.length; i++) {
                if (btmArray[i].name.equals(string)) {
                    b = false;
                    if (Arrays.equals(bizType.apNameArray, strings)) {
                        btmArray[i].name += "【业务类型已存在】";
                        ltsNew.add(btmArray[i]);
                    } else {
                        btmArray[i].name += "【业务类型存在但属性不一致】";
                        ltsNew.add(btmArray[i]);
                    }
                }
            }
            if (b) {
                bizType.name += "【业务类型不存在】";
                ltsNew.add(bizType);
            }
        } catch (PLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    private void getPLQtWrapper(String string, QTInfo qtWrapper, List<LinkType> ltsNew, List<QTInfo> qTWrapperNew, Map<String/*类型名称*/, QTD[]/*查询模板定义*/> newNorepQTDs) {
        try {
            QTInfo[] qtws = platformClientUtil.getQTDService().getAllQTs();
@@ -1208,6 +1249,71 @@
        }
    }

    private void getPLBtmQtWrapper(String string, QTInfo qtWrapper, List<BizType> ltsNew, List<QTInfo> qTWrapperNew, Map<String/*类型名称*/, QTD[]/*查询模板定义*/> newNorepQTDs) {
        try {
            QTInfo[] qtws = platformClientUtil.getQTDService().getAllQTs();
            boolean islaet = true;
            for (int i = 0; i < qtws.length; i++) {
                if (string.equals(qtws[i].qtName)) {
                    islaet = false;
                    for (BizType lt : ltsNew) {
                        if (qtWrapper.btmName.equals(lt.name.substring(0,
                                lt.name.indexOf("【")))) {
                            if (lt.name.endsWith("【业务类型已存在】")) {
                                qtWrapper.qtName += "【查询模板已存在，不导入】";
                                qTWrapperNew.add(qtWrapper);
                            }else if(lt.name.endsWith("【业务类型存在但属性不一致】")){
                                qtWrapper.qtName += "【查询模板所属业务类型属性不一致，不导入】";
                                qTWrapperNew.add(qtWrapper);
                            }else{
                                qtWrapper.qtName += "【查询模板所属业务类型不存在，不导入】";
                                qTWrapperNew.add(qtWrapper);
                            }
                        }
                    }
                }
            }
            if (islaet) {
                for (BizType btmItem : ltsNew) {
                    if (qtWrapper.btmName.equals(btmItem.name.substring(0,
                            btmItem.name.indexOf("【")))) {
                        if (btmItem.name.endsWith("【业务类型已存在】")) {
                            //判断查询模板定义是否存在，进行保存
                            QTD[] qtds = newNorepQTDs.get(qtWrapper.btmName);
                            if(qtds != null){
                                for (QTD qtd : qtds) {
                                    QTD qtdByName = platformClientUtil.getQTDService().getQTDByName(qtd.name);
                                    if(!(qtdByName != null && StringUtils.isNotBlank(qtdByName.name))){
                                        boolean b = platformClientUtil.getQTDService().addQTD(qtd);
                                        if(!b){
                                            qtWrapper.qtName += qtWrapper.qtName+"导入查询模板定义【" + qtdByName.name + "】失败！";
                                        }
                                    }
                                }
                                newNorepQTDs.remove(qtWrapper.btmName);
                            }
                            boolean success = platformClientUtil.getQTDService().saveQT(qtWrapper);
                            if(!success){
                                qtWrapper.qtName += qtWrapper.qtName+"导入失败！";
                            }else {
                                qtWrapper.qtName += "【查询模板导入成功！】";
                            }
                            qTWrapperNew.add(qtWrapper);
                        }else if(btmItem.name.endsWith("【业务类型存在但属性不一致】")){
                            qtWrapper.qtName += "【查询模板所属业务类型属性不一致，不导入】";
                            qTWrapperNew.add(qtWrapper);
                        }else{
                            qtWrapper.qtName += "【查询模板所属业务类型不存在，不导入】";
                            qTWrapperNew.add(qtWrapper);
                        }
                    }
                }
            }
        } catch (PLException e) {
            e.printStackTrace();
        }
    }

    //根据选择的查询模板过滤模板定义
    private Map<String, QTD[]> getnewNorepQTDs(Map<String, QTD[]> norepQTDs,
                                               Map<String, QTInfo> allQTs) {
@@ -1235,6 +1341,290 @@
        if(!b){
            return BaseResult.fail("删除失败！！！");
        }
        return BaseResult.success();
        return BaseResult.success("查询模板删除成功！");
    }

    /**
     * @param qtInfoDTO ä¼ è¾“的数据对象：
     *                linkTypeName é“¾æŽ¥ç±»åž‹ã€
     *                rdPositive æ–¹å‘，true正向，false反向
     *                btmName ä¸šåŠ¡ç±»åž‹åç§°
     *                combRelaType ä¸šåŠ¡ç±»åž‹é€‰æ‹©å€¼
     *                versionValue ç‰ˆæœ¬ç­æ¬¡å€¼
     *                isQueryIsLeaf æ˜¯å¦é€‰æ‹©ä¸‹çº§
     *                level å­èŠ‚点层数
     * @return æŸ¥è¯¢ç»“æžœ
     */
    @Override
    public BaseResult getCriteriaBtm(QTInfoDTO qtInfoDTO) throws PLException {
        QueryTemplate qt = getQT(qtInfoDTO,false);
        String checkInfo = OQTool.checkQT(qt);
        if(!checkInfo.equals("OK")){
            throw new PLException("500", new String[]{checkInfo});
        }
        qt.setId("qt1");
        BusinessObject[] result = platformClientUtil.getQueryService().findBTMObjects(qt.getId(), OQTool.qtTOXMl(qt).asXML());
        return BaseResult.dataList(Arrays.asList(result));
    }

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿ä¿å­˜
     * @param qtInfoDTO ä¿å­˜ä¼ è¾“对象
     * @return ä¿å­˜ç»“æžœ
     */
    @Override
    public BaseResult btmSave(QTInfoDTO qtInfoDTO) throws PLException {
        VciBaseUtil.alertNotNull(
                qtInfoDTO,"保存的业务类型模板对象",
                qtInfoDTO.getBtmName(),"请选择业务类型和查询模板定义来创建查询模板"
        );

        //add by caill start éåŽ†æ™®é€šæŸ¥è¯¢æ¨¡æ¿è¾“入框中的值做校验
        //        ArrayList<String> list = cpm_centerPanel.getList();
        //        for(int i=0;i<list.size();i++){
        //            String text = (String) list.get(i);
        //            if(text.contains("'")){
        //                JOptionPane.showMessageDialog(cp_mainPanel, "条件值中包含了非法字符", "非法字符", JOptionPane.ERROR_MESSAGE);
        //                return;
        //            }
        //        }
        //保存之前带出已选择的qtName
        QueryTemplate qt = getQT(qtInfoDTO,false);
        //前端调用这个方法isExistsQT()
        /*if(isExists(qtName)){
            return BaseResult.success("","该查询模板名已经存在,是否覆盖？");
        }*/
        String checkInfo = OQTool.checkQT(qt);
        if(!checkInfo.equals("OK")){
            throw new PLException("500", new String[]{checkInfo});
        }
        //设置排序信息
        qt.setOrderInfoList(qtInfoDTO.getQueryTemplate().getOrderInfoList());
        QTInfo qtWrapper = new QTInfo();
        qtWrapper.qtName = qtInfoDTO.getQtName();
        qtWrapper.btmName = qt.getBtmType();
        qtWrapper.creator = WebUtil.getCurrentUserId();
        qtWrapper.createTime = System.currentTimeMillis();
        if(qtInfoDTO.getTree() == null){
            qtWrapper.qtUIText = "";
        }else{
            //当勾选了高级查询时需要处理高级查询的相关条件
            qtWrapper.qtUIText = getSeniorXML(qtInfoDTO);
        }
        qtWrapper.levelFlag = qtInfoDTO.getLevelFlag();
        qtWrapper.qtText = OQTool.qtTOXMl(qt).asXML();
        boolean saveFlag = platformClientUtil.getQTDService().saveQT(qtWrapper);
        if(saveFlag){
            return BaseResult.success("保存查询模板成功");
        }else{
            return BaseResult.fail("保存查询模板失败");
        }
    }

    /**
     * æ›´æ–°æ•°æ®åº“结构
     * @return ä¿å­˜ç»“æžœ
     */
    @Override
    public BaseResult updateDBStructure() throws PLException {
        boolean f = platformClientUtil.getQTDService().updateQT();
        if(f){
            return BaseResult.success("更新成功");
        }else{
            return BaseResult.fail("更新失败");
        }
    }

    /**
     * ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿æ ‘查询，用于界面的导出功能
     * @return æŸ¥è¯¢ç»“æžœ
     */
    @Override
    public BaseResult getBtmQtTree() throws PLException {
        BizType[] bizTypes= null;
        QTInfo[] qts = null;
        HashMap<String,Object> tree = new HashMap();
        tree.put("text","业务类型");
        if (bizTypes == null) {
            List<BizType> es = new ArrayList<>();
            bizTypes = platformClientUtil.getBtmService().getBizTypes("");
            for (BizType lt : bizTypes) {
                QTInfo[] qtWrappers = platformClientUtil.getQTDService().getObjTypeQTs(lt.name);
                if (qtWrappers.length!=0) {
                    es.add(lt);
                }
            }
            bizTypes = es.toArray(new BizType[es.size()]);
            //TODO:需修正没有关联查询模板业务类型去掉
            qts = platformClientUtil.getQTDService().getAllQTs();//获取所有查询模板
        }
        List<HashMap<String,Object>> childList = new ArrayList<>();
        //添加业务类型根节点
        for (BizType plAction : bizTypes) {
            HashMap<String,Object> childTree = new HashMap();
            childTree.put("text", plAction.label + "/" +plAction.name);
            childTree.put("oid", plAction.oid);
            //tree.put("children", childTree);
            addExportTreeNode(plAction, qts, childTree);
            childList.add(childTree);
        }
        tree.put("children", childList);
        return BaseResult.success(tree);
    }

    /**
     * å¯¼å‡ºä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
     * names æŸ¥è¯¢æ¨¡æ¿å
     * @return
     */
    @Override
    public void expBtmQTTemplate(List<String> names, HttpServletResponse response) throws PLException, IOException {
        String defaultTempFolder = LocalFileUtil.getDefaultTempFolder();
        String vciqtmfFileName = defaultTempFolder + File.separator + "BtmTemplateExp" + new Date().getTime() + ".vciqtf";
        BtmQTExportData exportData = new BtmQTExportData();
        for (String name : names) {
            QTInfo qt = platformClientUtil.getQTDService().getQT(name);
            exportData.getAllQTs().put(qt.qtName,qt);
            BizType[] bizTypes = platformClientUtil.getBtmService().getBizTypes(qt.btmName);
            for (int i = 0; i < bizTypes.length; i++) {
                BizType bizType = bizTypes[i];
                if(bizTypes != null && !bizType.oid.equals("")){
                    exportData.getSelectedBtmItems().put(bizType.name, bizType);
                    exportData.getSelectedBtmAttrs().put(bizType.name, bizType.apNameArray);
                    exportData.getAllQTDs().put(bizType.name, platformClientUtil.getQTDService().getBizTypeQTDs(bizType.name));
                }
            }
        }
        ObjectOutputStream vciamfFileStream = null;
        try {
            File vciqtmfFile = new File(vciqtmfFileName);
            vciamfFileStream = new ObjectOutputStream(new FileOutputStream(vciqtmfFile));
            vciamfFileStream.writeObject(exportData);
        }finally {
            try {
                if (vciamfFileStream != null) {
                    vciamfFileStream.flush();
                    vciamfFileStream.close();
                }
            } catch (Exception e) {
                throw new PLException("500",new String[]{"导出流关闭异常！"});
            }
        }
        ControllerUtil.writeFileToResponse(response,vciqtmfFileName);
        FileUtil.del(defaultTempFolder + File.separator);
    }

    /**
     * æŸ¥è¯¢æ¡ä»¶ä¸‹çš„选择查询模板对话框（查询全部模板和所对应的业务类型或链接类型名）
     * @return
     */
    @Override
    public BaseResult getAllQTs() throws PLException {
        QTInfo[] allQTs = platformClientUtil.getQTDService().getAllQTs();
        DataGrid<QTInfo> dataGrid = new DataGrid<>();
        dataGrid.setData(Arrays.asList(allQTs));
        dataGrid.setTotal(allQTs.length);
        return BaseResult.dataGrid(dataGrid);
    }

    /**
     * å¯¼å…¥ä¸šåŠ¡ç±»åž‹æŸ¥è¯¢æ¨¡æ¿
     * @param file ä¸Šä¼ çš„文件
     * @return å¯¼å…¥ç»“æžœ
     */
    @Override
    public BaseResult impBtmTemplate(MultipartFile file) throws IOException, ClassNotFoundException {
        if (file == null) {
            return BaseResult.fail(FrameWorkLangCodeConstant.IMPORT_FAIL, new String[]{"无导入的文件"});
        }
        if (!file.getOriginalFilename().endsWith(".vciqtf")) {
            throw new VciBaseException("仅能上传.vciqtf格式文件，请重新上传！");
        }
        ObjectInputStream obj = new ObjectInputStream(
                file.getInputStream());
        BtmQTExportData qtExportData = (BtmQTExportData) obj.readObject();
        List<BizType> ltsNew = new ArrayList<>();
        List<QTInfo> qTWrapperNew = new ArrayList<>();
        Map<String/* ç±»åž‹åç§° */, QTD[]/* æŸ¥è¯¢æ¨¡æ¿å®šä¹‰ */> norepQTDs = new HashMap<String, QTD[]>();
        addImportBtmData(qtExportData, ltsNew, qTWrapperNew, norepQTDs);
        QTInfo[] qts = qTWrapperNew
                .toArray(new QTInfo[qTWrapperNew.size()]);
        //处理树的返回
        HashMap<String,Object> tree = new HashMap();
        tree.put("text","业务类型");
        List<HashMap<String,Object>> childList = new ArrayList<>();
        //添加业务类型根节点
        for (BizType plAction : ltsNew) {
            HashMap<String,Object> childTree = new HashMap();
            childTree.put("text", plAction.label + "/" +plAction.name);
            childTree.put("oid", plAction.oid);
            addExportTreeNode(plAction, qts, childTree);
            childList.add(childTree);
        }
        tree.put("children", childList);
        return BaseResult.success(tree);
    }

    // æ•°æ®è¿‡æ»¤
    private void addImportBtmData(BtmQTExportData qtExportData, List<BizType> ltsNew, List<QTInfo> qTWrapperNew,
                               Map<String/* ç±»åž‹åç§° */, QTD[]/* æŸ¥è¯¢æ¨¡æ¿å®šä¹‰ */> norepQTDs) {
        Map<String/* ç±»åž‹åç§° */, QTD[]/* æŸ¥è¯¢æ¨¡æ¿å®šä¹‰ */> allQTDs = qtExportData
                .getAllQTDs();
        Map<String/* ç±»åž‹åç§° */, BizType/* ç±»åž‹å¯¹è±¡ */> selectedBtmItems = qtExportData
                .getSelectedBtmItems();
        Map<String/* ç±»åž‹åç§° */, String[]/* ç±»åž‹æ‰€å±žå±žæ€§ */> selectedBtmAttrs = qtExportData
                .getSelectedBtmAttrs();
        Map<String/* æŸ¥è¯¢æ¨¡æ¿åç§° */, QTInfo/* æŸ¥è¯¢æ¨¡æ¿å¯¹è±¡ */> allSelectedQTs = qtExportData
                .getAllQTs();
        if (allQTDs.size() == 0 || allQTDs == null
                || selectedBtmItems.size() == 0 || selectedBtmItems == null
                || selectedBtmAttrs.size() == 0 || selectedBtmAttrs == null
                || allSelectedQTs.size() == 0 || allSelectedQTs == null) {
            throw new VciBaseException("导入的模板数据有误!!!");
        }
        Set<Map.Entry<String, QTD[]>> pLActions = allQTDs.entrySet();
        Set<Map.Entry<String, QTInfo>> pLQts = allSelectedQTs.entrySet();
        Set<Map.Entry<String, BizType>> btmpLQts = selectedBtmItems.entrySet();
        for (Map.Entry<String, QTD[]> entry : pLActions) {
            String string = entry.getKey();
            QTD[] qtds = entry.getValue();
            getPLQtIsInDB(string, qtds, norepQTDs);
        }
        for (Map.Entry<String, BizType> entry : btmpLQts) {
            String string = entry.getKey();
            BizType bizType = entry.getValue();
            getPLQtBtmItem2(string, bizType, ltsNew);
        }
        Map<String/*类型名称*/, QTD[]/*查询模板定义*/> newNorepQTDs = getnewNorepQTDs(norepQTDs,allSelectedQTs);
        for (Map.Entry<String, QTInfo> entry : pLQts) {
            String string = entry.getKey();
            QTInfo qtWrapper = entry.getValue();
            getPLBtmQtWrapper(string, qtWrapper, ltsNew, qTWrapperNew, newNorepQTDs);
        }

    }

    /**
     * ç”Ÿæˆå¯¼å‡ºæ ‘选择以及导入树显示
     * @param bizType
     * @param qts
     * @param tree
     */
    private void addExportTreeNode(BizType bizType/*业务类型*/,QTInfo[] qts/*查询模板对象*/,HashMap<String,Object> tree) {
        List<String> childList = new ArrayList<>();
        // æ·»åŠ æŸ¥è¯¢æ¨¡æ¿å¯¹è±¡å­èŠ‚点
        for (QTInfo qtItem : qts) {
            //处理导入时无法进行类型判断
            int splitLength = bizType.name.indexOf("【");
            if(splitLength == -1){
                splitLength = bizType.name.length();
            }
            if (qtItem.btmName.equals(bizType.name.substring(0,
                    splitLength))) {
                childList.add(qtItem.qtName);
            }
        }
        tree.put("children",childList);
    }

}

 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/WebBtmIOServiceImpl.java

@@ -851,7 +851,13 @@
        if(!CollectionUtils.isEmpty(btmTypeVOList)) {
            btmTypeVOList.stream().forEach(btmTypeVO -> {
                String btmId = btmTypeVO.getId();
                List<OsBtmTypeAttributeVO> attributeVOS = btmService.listAttributeByBtmId(btmId);
                List<OsBtmTypeAttributeVO> attributeVOS = null;
                try {
                    attributeVOS = btmService.listAttributeByBtmId(btmId);
                } catch (PLException e) {
                    e.printStackTrace();
                    throw new VciBaseException(VciBaseUtil.getExceptionMessage(e));
                }
                //先是名称
                int rowIndex = index[0];
                WriteExcelData idED = new WriteExcelData(rowIndex, 0, btmId);