bootstrap table 后台传排序字段及升序降序

时间:2022-07-11 17:24:26

 $('#mytab').bootstrapTable({
                url: "http://localhost/bootstrap/getJsonData?method=index2",//数据源
                dataField: "rows",//服务端返回数据键值 就是说记录放的键值是rows,分页时使用总记录数的键值为total
                totalField: 'total',
                height: tableHeight(),//高度调整
               sidePagination: "server",//服务端分页
               method: "get",//请求方式
               pagination: true,//是否分页
               escape: true,
               pageNumber: 1,
               totalRows: 0, // server side need to set
               queryParams: function getParams(params) {
                    var searchKey1 = $("#s1").val(); 
                    var searchKey2 = $("#s2").val(); 
                    var temp = { //这里的键的名字和控制器的变量名必须一直,这边改动,控制器也需要改成一样的
                             limit: params.limit, //页面大小
                                 searchKey1:searchKey1,
                                 searchKey2:searchKey2,
                                 sortName:this.sortName,
                                 sortOrder:this.sortOrder,

                                  pageindex:this.pageNumber//当前页码
                               };
                   return temp;
                },
                buttonsAlign: "left",//按钮对齐方式
                selectItemName: 'id',
                toolbar: "#toolbar",
                toolbarAlign: 'left',
                columns: [
                    {
                        title: "全选",//标题
                        width: 60,//宽度
                        align: "center",//水平
                        checkbox: true,
                        valign: "middle"//垂直
                     
                    },
                    {
                        field: "id",
                        title: "id",
                        sortable: true
                    },
                    {
                        field: "DeviceName",
                        title: "DeviceName",
                        sortable: true
                    }
                ],
                onRefresh: function (params) {
                    if($("#refreshWay .active").data("toggle")=== "off"){
                     autoRefresh();
                    }
                },
                locale: "zh-CN"//中文支持
            });

           在queryParams方法中添加排序字段和升序降序字段到后台