room_position_java/src/main/java/com/zhiyun/common/model/BaseBody.java

package com.zhiyun.common.model;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zhiyun.common.utils.StringUtils;
import com.zhiyun.common.utils.sql.SqlUtil;
import lombok.Data;


/**
 * 分页数据
 *
 * @author ruoyi
 */
@Data
public class BaseBody {

    /**
     * 登录用户ID
     */
    private Long userId;

    /**
     * 当前记录起始索引
     */
    private Integer pageNum = 1;

    /**
     * 每页显示记录数
     */
    private Integer pageSize = 10;

    /**
     * 排序列
     */
    private String orderByColumn;

    /**
     * 排序的方向desc或者asc
     */
    private String sort = "asc";

    public String getOrderBy() {
        if (StringUtils.isEmpty(orderByColumn)) return "";
        return SqlUtil.escapeOrderBySql(StringUtils.toUnderScoreCase(orderByColumn) + " " + sort);
    }

    public void setSort(String sort) {
        if (StringUtils.isNotEmpty(sort)) {
            // 兼容前端排序类型
            if ("ascending".equals(sort)) {
                sort = "asc";
            } else if ("descending".equals(sort)) {
                sort = "desc";
            }
            this.sort = sort;
        }
    }


    public <T> Page<T> getPage() {
        return new Page<>(pageNum, pageSize);
    }

    public <T> Page<T> getPageNoOptimize() {
        Page<T> result = new Page<T>(pageNum, pageSize);
        result.setOptimizeCountSql(false);
        return result;
    }

    public <T> Page<T> getNotPage() {
        return new Page<>(0, -1);
    }
}