ztree二级菜单有查询条件，ztree一级菜单没有查询条件

今天碰到一个需求，ztree二级菜单有查询条件，ztree一级菜单没有查询条件，一般情况下查询条件都是先取一级菜单，再取二级菜单，但是一级菜单没有查询条件，会多取了一些不应该有的记录，所以这种情况下，只能实行倒推查询，先查二级菜单，得到的结果作为条件去查一级菜单，代码如下：

/***
 * 获取模型树
 * @param id
 * @return
 */
public List<ZTreeNode> getModelTree(String id, String userId) {

    StringBuffer sql1 = new StringBuffer();

    sql1.append(" select ")
            .append("  a.tplakey,")
            .append("  a.tplaname,")
            .append("  a.tplacatecd,")
            .append("  a.DISPSEQ as seq")
            .append(" from PISS_tp_bas_inf as a")
            .append(" where a.tplastat = '1' and modeltype = 1");
    sql1.append(" order by seq");

    List<ZTreeNode> zTreeNodes1 = jdbcTemplate.query(sql1.toString(),  new RowMapper<ZTreeNode>(){
        public ZTreeNode mapRow(ResultSet rs, int rowNum)throws SQLException{
            String tplacatecd = rs.getString("tplacatecd");
            Integer seq=rs.getInt("seq");
            ZTreeNode zTreeNode1 = new ZTreeNode();
            zTreeNode1.setId(rs.getString("tplakey"));
            zTreeNode1.setName(rs.getString("tplaname"));
            zTreeNode1.setIsParent(false);
            zTreeNode1.setParentId("F_"+(StringUtil.isNull(tplacatecd) ? "1":tplacatecd));
            zTreeNode1.setIndex(seq);
            zTreeNode1.settId(tplacatecd);
            return zTreeNode1;
        }
    });

    String ids = "";
    if(!zTreeNodes1.isEmpty()){
        for(int i=0; i<zTreeNodes1.size();  i++){
            String tplacatecd = zTreeNodes1.get(i).gettId();
            ids += "'"+tplacatecd+"'"+",";
        }
        ids = ids.substring(0, ids.length()-1);
    }else{
        ids = "''";
    }

    StringBuffer sql = new StringBuffer();
    sql.append(" select ")
            .append("  b.id as flodid,")
            .append("  b.name as flodname,")
            .append("  b.p_folder_id as pid,")
            .append("  b.seq as seq")
            .append(" from PISS_tp_folder as b " +
                    " where ISENABLE='1' and id in (" +ids+")"+
                    " order by seq");

    List<ZTreeNode> zTreeNodes = jdbcTemplate.query(sql.toString(),  new RowMapper<ZTreeNode>(){
        public ZTreeNode mapRow(ResultSet rs, int rowNum)
                throws SQLException {
            String flodid = rs.getString("flodid");
            String flodname = rs.getString("flodname");
            Integer seq=rs.getInt("seq");
            ZTreeNode zTreeNode=new ZTreeNode();
            zTreeNode.setId("F_"+flodid);
            zTreeNode.setName(flodname);
            zTreeNode.setIsParent(true);
            zTreeNode.setParentId("F_"+rs.getString("pid"));
            zTreeNode.setIndex(seq);
            return zTreeNode;
        }
    });

    List<ZTreeNode> nodes = new ArrayList<ZTreeNode>();
    nodes.addAll(zTreeNodes);
    nodes.addAll(zTreeNodes1);
    return nodes;
}

页面的代码如下:

var rule_tree = new FAPUI.Tree({
    border:false,
    tbar:false,
    ttbar:false,
    filterAble:false,
    setting : {
        async : {
            enable: true,//设置 zTree 是否开启异步加载模式
            url: path+'/emphasisCompanyController/getModelTree',
            autoParam : ['id']//异步加载时需要自动提交父节点属性的参数。[setting.async.enable = true 时生效]
        },
        data:{
            key: {
                name: "name"   //设置树节点的name，节点参数name必须和它匹配
            },
            simpleData: {
                enable: true,  //开启树的层级结构
                idKey: "id",   //设置树节点id，节点参数id必须与之匹配  节点数据中保存唯一标识的属性名称。[setting.data.simpleData.enable = true 时生效]
                pIdKey: "parentId" //设置pid，节电参数pid必须与之匹配  节点数据中保存其父节点唯一标识的属性名称。[setting.data.simpleData.enable = true 时生效]
            }
        },
        check : {
            enable : true,//设置 zTree 的节点上是否显示 checkbox / radio
            chkStyle : "checkbox",//勾选框类型(checkbox 或 radio）[setting.check.enable = true 时生效]
            chkboxType: { "Y": "ps", "N": "ps" }//勾选 checkbox 对于父子节点的关联关系。
        },
        callback: {
            beforeCheck: function(treeId, treeNode) {
                return !isTreeCheckDisable;
            }
        }
    }
});

这样就可以了