Pu Zhibing
2025-02-18 fcb98e91a1e521b895cb58e8ac424f51dfd4e96a
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org" xmlns:shiro="http://www.pollix.at/thymeleaf/shiro">
<head>
<th:block th:include="include :: header('动态列')" />
</head>
<body class="gray-bg">
    <div class="container-div">
        <div class="row">
            <div class="col-sm-12 search-collapse">
                <form id="table-form">
                    <div class="select-list">
                        <ul>
                            <li>
                                要增加的列:
                                <select name="field">
                                    <option value="">默认</option>
                                    <option value="userBalance">用户余额</option>
                                </select>
                            </li>
                            <li>
                                <a class="btn btn-primary btn-rounded btn-sm" onclick="tableSearch()"><i class="fa fa-search"></i>&nbsp;搜索</a>
                                <a class="btn btn-warning btn-rounded btn-sm" onclick="reset()"><i class="fa fa-refresh"></i>&nbsp;重置</a>
                            </li>
                        </ul>
                    </div>
                </form>
            </div>
            <div class="col-sm-12 select-table table-striped">
                <table id="bootstrap-table"></table>
            </div>
        </div>
    </div>
    <div th:include="include :: footer"></div>
    <script th:inline="javascript">
        var prefix = ctx + "demo/table";
        var datas = [[${@dict.getType('sys_normal_disable')}]];
 
        $(function() {
            ajaxColumns();
        });
        // 动态获取列
        function ajaxColumns() {
            var url = prefix + "/ajaxColumns";
            var dataParam = $.common.formToJSON("table-form");
            $.modal.loading("正在查询中,请稍候...");
            $.post(url, dataParam, function(result) {
                if (result.code == web_status.SUCCESS) {
                    setColumns(result.data);
                } else if (result.code == web_status.WARNING) {
                    $.modal.alertWarning(result.msg)
                } else {
                    $.modal.alertError(result.msg);
                }
                $.modal.closeLoading();
            });
        }
          // 设置列
        function setColumns(list) {
            var columns = [];
            list.forEach(function(item) {
                if($.common.equals('status',item.field)){
                    columns.push({
                        field : item.field, 
                        title : item.title,
                        align: 'center',
                        formatter: function(value, row, index) {
                            return $.table.selectDictLabel(datas, value);
                        }
                    })
                } else {
                    columns.push({
                        field : item.field, 
                        title : item.title
                    })
                }
            });
            columns.push({
                title: '操作',
                align: 'center',
                formatter: function(value, row, index) {
                    var actions = [];
                    actions.push('<a class="btn btn-success btn-xs" href="javascript:;"><i class="fa fa-edit"></i>编辑</a> ');
                    actions.push('<a class="btn btn-danger btn-xs" href="javascript:;"><i class="fa fa-remove"></i>删除</a>');
                    return actions.join('');
                }
            });
            if(!table.get(table.options.id)){
                initTable(columns);
            } else {
                refreshTable(columns);
            }
        }
          // 刷新表格
        function refreshTable(columns) {
            var options = {
                columns: columns
            };
            $("#" + table.options.id).bootstrapTable('refreshOptions',options);
        }
          // 初始化表格
        function initTable(columns){
            var options = {
                url: prefix + "/list",
                showSearch: false,
                showRefresh: false,
                showToggle: false,
                showColumns: false,
                columns: columns
            };
            $.table.init(options);
        }
          // 搜索
        function tableSearch(){
            ajaxColumns();
        }
          // 重置
        function reset(){
            $("#table-form")[0].reset();
            ajaxColumns();
        }
    </script>
</body>
</html>