表格里某个字段排序

<el-table
    ref="unknownTable"
    :data="tableDataList"
    border
    stripe
    @sort-change="changeSort"
    tooltip-effect="dark"
    v-loading="listLoading"
    element-loading-text="数据加载中..."
    style="width: 100%;">

   <el-table-column prop="date" label="日期"  width="180" sortable="custom">

//排序
changeSort(obj) {
    if (obj.order) {
        this.orderBy = obj.prop.replace(/([A-Z])/g, '_$1').toLowerCase() + ' ' + (obj.order === 'ascending' ? 'asc' : 'desc')
    } else {
        this.orderBy = ''
    }
    this.handleSearch();
},

前端API

export function findRobotByPage(page, orderBy) {
    let jsonData = {
        page: page,
        orderBy:orderBy,
    }
    return request({
        url: '/bigdata/robot/findByPage',
        method: 'post',
        data: Qs.stringify(jsonData)
    })
}

后台

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

if (StringUtils.isNotBlank(robotVo.getOrderBy())) {
    PageHelper.orderBy(robotVo.getOrderBy());
}
PageHelper.startPage(page, size);
List<RobotDto> list = robotMapper.findByPage(params);

 

 

/**
 * 排序
 */
private String orderBy;