cakephp/tests/test_app/TestApp/Model/Table/PaginatorPostsTable.php

<?php
/**
 * CakePHP : Rapid Development Framework (http://cakephp.org)
 * Copyright 2005-2011, Cake Software Foundation, Inc.
 *
 * Licensed under The MIT License
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright 2005-2011, Cake Software Foundation, Inc.
 * @link          http://cakephp.org CakePHP Project
 * @since         3.0.0
 * @license       MIT License (http://www.opensource.org/licenses/mit-license.php)
 */
namespace TestApp\Model\Table;

use Cake\ORM\Query;
use Cake\ORM\Table;
use Cake\Utility\Hash;

/**
 * PaginatorPostsTable class
 *
 */
class PaginatorPostsTable extends Table {

/**
 * initialize method
 *
 * @return void
 */
	public function initialize(array $config) {
		$this->table('posts');
		$this->belongsTo('PaginatorAuthor', [
			'foreignKey' => 'author_id'
		]);
	}

/**
 * Finder method for find('popular');
 */
	public function findPopular(Query $query, array $options) {
		$field = $this->alias() . '.' . $this->primaryKey();
		$query->where([$field . ' >' => '1']);
		return $query;
	}

/**
 * Finder for published posts.
 */
	public function findPublished(Query $query, array $options) {
		$query->where(['published' => 'Y']);
		return $query;
	}

}