org.sagacity.sqltoy.model.TreeSort Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sagacity-sqltoy Show documentation

sqltoy core code

There is a newer version: 5.6.31.jre8

package org.sagacity.sqltoy.model;

import java.io.Serializable;

/**
 * @project sagacity-sqltoy
 * @description 提供基于QueryExecutor的树排序api模型
 * @author zhongxuchen
 * @version v1.0, Date:2023年6月21日
 * @modify 2023年6月21日,修改说明
 */
public class TreeSort implements Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = -6451807102929254951L;

	/**
	 * id节点字段
	 */
	private String idColumn;

	/**
	 * pid节点字段
	 */
	private String pidColumn;

	/**
	 * 汇总列
	 */
	private String[] sumColumns;

	/**
	 * filter过滤对比列(如:字段列 status==1 的行数据参与汇总)
	 */
	private String filterColumn;

	/**
	 * 对比类型(==,!=,>,<,>=,<=,in,between)
	 */
	private String compareType;

	/**
	 * 对比数据(如:1)
	 */
	private String[] compareValues;

	/**
	 * 层级排序列
	 */
	private String levelOrderColumn;

	/**
	 * 降序
	 */
	private String orderWay = "desc";

	/**
	 * @return the orderWay
	 */
	public String getOrderWay() {
		return orderWay;
	}

	public TreeSort orderWay(String orderWay) {
		this.orderWay = orderWay;
		return this;
	}

	/**
	 * @return the levelOrderColumn
	 */
	public String getLevelOrderColumn() {
		return levelOrderColumn;
	}

	public TreeSort levelOrderColumn(String levelOrderColumn) {
		this.levelOrderColumn = levelOrderColumn;
		return this;
	}

	public String getIdColumn() {
		return idColumn;
	}

	public TreeSort idColumn(String idColumn) {
		this.idColumn = idColumn;
		return this;
	}

	public String getPidColumn() {
		return pidColumn;
	}

	public TreeSort pidColumn(String pidColumn) {
		this.pidColumn = pidColumn;
		return this;
	}

	public String[] getSumColumns() {
		return sumColumns;
	}

	public TreeSort sumColumns(String... sumColumns) {
		this.sumColumns = sumColumns;
		return this;
	}

	public String getFilterColumn() {
		return filterColumn;
	}

	public TreeSort filterColumn(String filterColumn) {
		this.filterColumn = filterColumn;
		return this;
	}

	public String getCompareType() {
		return compareType;
	}

	public TreeSort compareType(String compareType) {
		this.compareType = compareType;
		return this;
	}

	public String[] getCompareValues() {
		return compareValues;
	}

	public TreeSort compareValues(String... compareValues) {
		this.compareValues = compareValues;
		return this;
	}

}