/**
* @param Kdyby\Persistence\Queryable|Kdyby\Doctrine\EntityDao $repository
* @return Kdyby\Doctrine\NativeQueryBuilder
*/
private function createBasicDql(Kdyby\Persistence\Queryable $repository)
{
$qb = (new QueryBuilder($repository->getEntityManager()))->select('partial l.{id, description, year, month}')->from(Listing::class, 'l')->leftJoin(ListingItem::class, 'li WITH li.listing = l')->leftJoin('li.workedHours', 'wh');
foreach ($this->filter as $modifier) {
$modifier($qb);
}
return $qb;
}
/**
* @param Kdyby\Persistence\Queryable|Kdyby\Doctrine\EntityDao $repository
* @return Kdyby\Doctrine\NativeQueryBuilder
*/
private function createBasicDql(Kdyby\Persistence\Queryable $repository)
{
$this->queryBuilder = (new QueryBuilder($repository->getEntityManager()))->select('i')->from(Invitation::class, 'i');
foreach ($this->filter as $modifier) {
$modifier($this->queryBuilder);
}
return $this->queryBuilder;
}
protected function doCreateQuery(Kdyby\Persistence\Queryable $repository)
{
$qb = $this->createBasicQuery($repository->getEntityManager());
$qb->select('c')->orderBy('c.id');
foreach ($this->select as $modifier) {
$modifier($qb);
}
return $qb;
}
protected function doCreateQuery(Kdyby\Persistence\Queryable $repository)
{
$qb = $this->createBasicQuery($repository->getEntityManager());
$qb->innerJoin('a.resource', 'r')->innerJoin('a.privilege', 'p')->select('a, r, p')->orderBy('a.resource');
foreach ($this->select as $modifier) {
$modifier($qb);
}
return $qb;
}
/**
* @param \Kdyby\Persistence\Queryable $repository
* @return \Doctrine\ORM\Query|\Doctrine\ORM\QueryBuilder
*/
protected function doCreateQuery(Kdyby\Persistence\Queryable $repository)
{
$qb = $this->getBasicDQL($repository->getEntityManager());
$qb->select('i');
$qb->addOrderBy('i.uploadedAt', 'DESC');
foreach ($this->select as $modifier) {
$modifier($qb);
}
return $qb;
}
/**
* @param Kdyby\Persistence\Queryable|Kdyby\Doctrine\EntityDao $repository
* @return Kdyby\Doctrine\NativeQueryBuilder
*/
private function createBasicDql(Kdyby\Persistence\Queryable $repository)
{
$this->queryBuilder = (new QueryBuilder($repository->getEntityManager()))->select('sm')->from(SentMessage::class, 'sm')->orderBy('sm.id', 'DESC');
foreach ($this->filter as $modifier) {
$modifier($this->queryBuilder);
}
return $this->queryBuilder;
}
