protected function getSnippetQueryBuilder($show, $templateEnabled = true)
{
if (!in_array($show, array('enabled', 'disabled', 'all'))) {
$show = 'enabled';
}
$queryBuilder = $this->createQueryBuilder('snippet');
if ($templateEnabled) {
// by default a Template should always be enabled
$queryBuilder->join('snippet.template', 'template')->andWhere('template.enabled = 1');
}
if ($show == 'enabled') {
$queryBuilder->andWhere('snippet.enabled = 1');
}
if ($show == 'disabled') {
$queryBuilder->andWhere('snippet.enabled = 0');
}
return $queryBuilder;
}