jqgrid 树表格

直接上代码

<table id="treeGrid"></table>

引入(这里采用的是bootstrap的样式):

bootstrap.min.css
ui.jqgrid-bootstrap4.css
jquery.min.js
grid.locale-cn.js
jquery.jqGrid.min.js
				$("#deptTable").jqGrid({
                    url: '/sys/dept/demo',
                    datatype: 'json',
                    colNames: ['id', '节点名称', '结束日期', '节点层级', '备注'],
                    colModel: [
                        {name: 'id', index: 'id', hidden: false, key: true},
                        {name: 'name', index: 'name', width: 200, sortable: false},
                        {name: 'endDate', index: 'endDate', width: 70, sortable: false},
                        {name: 'nodeLevel', index: 'nodeLevel', width: 100, sortable: false},
                        {name: 'remark', index: 'remark', width: 80, sortable: false}
                    ],
                    treeGrid: true,
                    treeGridModel: 'adjacency',
                    ExpandColumn: 'name',
                    jsonReader: {
                        root: "page",
                    },
                    treeReader: {
                        level_field: "level",
                        parent_id_field: "parent",
                        leaf_field: "leaf",
                        expanded_field: "expanded"
                    },
                });

关键配置有:treeGridtreeGridModelExpandColumntreeReader

返回的json示例:

{
"code": 0,
"page": [
{
"id": 0,
"parent": null,
"name": "张三",
"level": 0,
"endDate": "2019-04-13 11:17:18",
"nodeLevel": 20,
"expanded": false,
"remark": "123",
"leaf": false
},
{
"id": 1,
"parent": 0,
"name": "李四",
"level": 1,
"endDate": "2019-04-13 11:17:18",
"nodeLevel": 21,
"expanded": false,
"remark": "456",
"leaf": false
},
{
"id": 2,
"parent": 1,
"name": "王五",
"level": 2,
"endDate": "2019-04-13 11:17:18",
"nodeLevel": 22,
"expanded": false,
"remark": "789",
"leaf": true
}
],
"message": "success"
}

最后效果如下:
在这里插入图片描述

treegrid插件 当前选中的行: var config = { id: "tg1", width: "800", renderTo: "div1", headerAlign: "left", headerHeight: "30", dataAlign: "left", indentation: "20", folderOpenIcon: "images/folderOpen.gif", folderCloseIcon: "images/folderClose.gif", defaultLeafIcon: "images/defaultLeaf.gif", hoverRowBackground: "false", folderColumnIndex: "1", itemClick: "itemClickEvent", columns:[ {headerText: "", headerAlign: "center", dataAlign: "center", width: "20", handler: "customCheckBox"}, {headerText: "名称", dataField: "name", headerAlign: "center", handler: "customOrgName"}, {headerText: "拼音码", dataField: "code", headerAlign: "center", dataAlign: "center", width: "100"}, {headerText: "负责人", dataField: "assignee", headerAlign: "center", dataAlign: "center", width: "100"}, {headerText: "查看", headerAlign: "center", dataAlign: "center", width: "50", handler: "customLook"} ], data:[ {name: "城区分公司", code: "CQ", assignee: "", children:[ {name: "城区卡品分销中心"}, {name: "先锋服务厅", children:[ {name: "chlid1"}, {name: "chlid2"}, {name: "chlid3", children: [ {name: "chlid3-1"}, {name: "chlid3-2"}, {name: "chlid3-3"}, {name: "chlid3-4"} ]} ]}, {name: "半环服务厅"} ]}, {name: "清新分公司", code: "QX", assignee: "", children:[]}, {name: "英德分公司", code: "YD", assignee: "", children:[]}, {name: "佛冈分公司", code: "FG", assignee: "", children:[]} ] }; /* 单击数据行后触发该事件 id:行的id index:行的索引。 data:json格式的行数据对象。 */ function itemClickEvent(id, index, data){ window.location.href="ads"; } /* 通过指定的方法来自定义栏数据 */ function customCheckBox(row, col){ return ""; } function customOrgName(row, col){ var name = row[col.dataField] || ""; return name; } function customLook(row, col){ return "查看"; } //创建一个组件对象 var treeGrid = new TreeGrid(config); treeGrid.show(); /* 展开、关闭所有节点。 isOpen=Y示展开,isOpen=N示关闭 */ function expandAll(isOpen){ treeGrid.expandAll(isOpen); } /* 取得当前选中的行,方法返回TreeGridItem对象 */ function selectedItem(){ var treeGridItem = treeGrid.getSelectedItem(); if(treeGridItem!=null){ //获取数据行属性值 //alert(treeGridItem.id + ", " + treeGridItem.index + ", " + treeGridItem.data.name); //获取父数据行 var parent = treeGridItem.getParent(); if(parent!=null){ //jQuery("#currentRow").val(parent.data.name); } //获取子数据行集 var children = treeGridItem.getChildren(); if(children!=null && children.length>0){ jQuery("#currentRow").val(children[0].data.name); } } }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值