<?php
namespace TheatreCore\Repository;
use TheatreCore\Entity\AnnCategories;
use TheatreCore\Traits\TheatreTrait;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
/**
* AnnCategoriesRepository
*
* This class was generated by the Doctrine ORM. Add your own custom
* repository methods below.
*/
class AnnCategoriesRepository extends ServiceEntityRepository
{
use TheatreTrait;
private $em;
public $__table;
public $__table_object;
public $__idtable;
public function __construct(ManagerRegistry $registry)
{
parent::__construct($registry, AnnCategories::class);
$this->__table = $this->getClassMetadata()->getTableName();
$this->__table_object = $this->getClassMetadata()->name;
$this->__idtable = $this->getClassMetadata()->getSingleIdentifierFieldName();
}
public function getCategoriesList($byid = true)
{
return $this->getEntityManager()->getConnection()->fetchAllKeyValue(
'SELECT ' . ($byid ? 'idcategorie' : 'url_clean') . ', name FROM ' . $this->__table . ' WHERE online=1'
);
}
}