/**
* @param $alias
* @param array $criteria
* @param array $orderBy
* @param $limit
* @param $offset
* @param mixed $locale
* @return QueryBuilder
* @throws ConditionException
*/
private function createFindTranslatableQueryBuilder($alias, array $criteria, array $orderBy = null, $limit = null, $offset = null, $locale = null)
{
$qb = new QueryBuilder($this->_em);
$qb->from($this->_entityName, $alias);
$qb->select($alias);
foreach ($criteria as $criteriaField => $criteriaValue) {
$qb->addTranslatableWhere($alias, $criteriaField, $criteriaValue, $locale);
}
if (isset($orderBy)) {
foreach ($orderBy as $orderField => $orderDirection) {
$qb->addTranslatableOrderBy($alias, $orderField, $orderDirection, $locale);
}
}
if (isset($limit)) {
$qb->setMaxResults($limit);
}
if (isset($offset)) {
$qb->setFirstResult($offset);
return $qb;
}
return $qb;
}
