QueryObject class template for PhpStorm

QueryObject.php

<?php

namespace ${NAMESPACE};

use Nette;
use Kdyby;
use Kdyby\Doctrine\QueryBuilder;
use Kdyby\Persistence\Queryable;



class ${NAME} extends Kdyby\Doctrine\QueryObject
{

	/**
	 * @var array|\Closure[]
	 */
	private \$filter = [];

	/**
	 * @var array|\Closure[]
	 */
	private \$select = [];



	protected function doCreateQuery(Kdyby\Persistence\Queryable \$repository)
	{
		\$qb = \$this->doCreateFilterQuery(\$repository);

		foreach (\$this->select as \$modifier) {
			\$modifier(\$qb);
		}

		return \$qb;
	}



	protected function doCreateCountQuery(Queryable \$repository)
	{
		return \$this->doCreateFilterQuery(\$repository)->select('COUNT(e.id)');
	}



	private function doCreateFilterQuery(Queryable \$repository)
	{
		\$qb = \$repository->createQueryBuilder()
			->select('e')->from(${NAME}::class, 'e');

		foreach (\$this->filter as \$modifier) {
			\$modifier(\$qb);
		}

		return \$qb;
	}

}