前言

• ruoyi 4.6

Bootstrap-Table表格排序

    <script th:inline="javascript">
        ...
        $(function() {
            var options = {
                url: prefix + "/list",
                ...
                sortName: "sort",
                sortOrder: "desc",
                ...
            };
            $.table.init(options);
        });
    </script>

当表格中包含sortName和sortOrder属性时，sql语句会自动生成order by子句：

SELECT * FROM xxx order by sort desc LIMIT ?

多个字段排序

    <script th:inline="javascript">
        ...
        $(function() {
            var options = {
                url: prefix + "/list",
                ...
                sortName: "sort desc,id asc",
                sortOrder: "",
                ...
            };
            $.table.init(options);
        });
    </script>

当表格中包含sortName和sortOrder属性时，sql语句会自动生成order by子句：

SELECT * FROM xxx order by sort desc,id asc LIMIT ?

生成order by子句说明

• (table 的 options) sortName -> (http request) orderByColumn -> 驼峰命名转下划线（orderNum -> order_num）
• (table 的 options) sortOrder-> (http request) isAsc
• isAsc 默认值为 asc
• order by子句 = orderByColumn + " " + isAsc

示例1

sortName: "sort",
sortOrder: "desc",

• order by：sort desc

示例2

sortName: "sort desc,id asc",
sortOrder: "",

示例3

sortName: "sort desc,id",
sortOrder: "asc",

示例4

sortName: "order_num",
sortOrder: "desc",

• order by：order_num desc

示例5

sortName: "orderNum",
sortOrder: "desc",

• order by：order_num desc

参考

https://www.bootstrap-table
https://bootstrap-table