PhabricatorOffsetPagedQuery.php
No OneTemporary
Actions

Size

1 KB

Subscribers

None

PhabricatorOffsetPagedQuery.php
View Options

	<?php

	/**
	* A query class which uses offset/limit paging. Provides logic and accessors
	* for offsets and limits.
	*/
	abstract class PhabricatorOffsetPagedQuery extends PhabricatorQuery {

	private $offset;
	private $limit;

	final public function setOffset($offset) {
	$this->offset = $offset;
	return $this;
	}

	final public function setLimit($limit) {
	$this->limit = $limit;
	return $this;
	}

	final public function getOffset() {
	return $this->offset;
	}

	final public function getLimit() {
	return $this->limit;
	}

	protected function buildLimitClause(AphrontDatabaseConnection $conn_r) {
	if ($this->limit && $this->offset) {
	return qsprintf($conn_r, 'LIMIT %d, %d', $this->offset, $this->limit);
	} else if ($this->limit) {
	return qsprintf($conn_r, 'LIMIT %d', $this->limit);
	} else if ($this->offset) {
	return qsprintf($conn_r, 'LIMIT %d, %d', $this->offset, PHP_INT_MAX);
	} else {
	return '';
	}
	}

	final public function executeWithOffsetPager(AphrontPagerView $pager) {
	$this->setLimit($pager->getPageSize() + 1);
	$this->setOffset($pager->getOffset());

	$results = $this->execute();

	return $pager->sliceResults($results);
	}

	}