public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
if ($context === 'list') {
$alias = current($query->getDQLPart('from'))->getAlias();
$query->andWhere($alias . '.parent IS NULL');
}
return $query;
}
public function createQuery($context = 'list')
{
/** @var ProxyQuery|QueryBuilder $query */
$query = parent::createQuery($context);
if ($context == 'list') {
$parameters = $this->getFilterParameters();
$domainValue = isset($parameters['domain']) ? $parameters['domain'] : false;
list($tableAlias) = $query->getQueryBuilder()->getRootAliases();
if ($domainValue) {
$query->where($tableAlias . '.domain = :domain')->setParameter('domain', $domainValue);
}
$emptyLocale = !empty($parameters['emptyLocale']['value']) ? $parameters['emptyLocale']['value'] : false;
if ($emptyLocale) {
$query->andWhere($tableAlias . '.translations NOT LIKE :emptyLocale')->setParameter('emptyLocale', '%s:2:"' . $emptyLocale . '"%');
}
$location = !empty($parameters['location']['value']) ? $parameters['location']['value'] : false;
if ($location) {
if ($location == self::FILTER_LOCATION_FRONTEND) {
$query->andWhere($tableAlias . '.source NOT LIKE :excludeAdmin')->setParameter('excludeAdmin', '%admin\\.%');
} elseif ($location == self::FILTER_LOCATION_BACKEND) {
$query->andWhere($tableAlias . '.source LIKE :excludeAdmin')->setParameter('excludeAdmin', '%admin\\.%');
}
}
}
return $query;
}
public function createQuery($context = 'list')
{
/** @var FcRequestQuery $query */
$query = parent::createQuery($context);
$query->filterByFcForm($this->getFcForm());
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.customer', ':my_param'));
$query->setParameter('my_param', true);
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.deleteFlag', ':not_delete'));
$query->setParameter('not_delete', 0);
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.type', ':type'));
$query->setParameter(':type', Department::BRANCH);
return $query;
}
/**
* {@inheritdoc}
*/
public function createQuery($context = 'list')
{
/** @var PublicationQuery $query */
$query = parent::createQuery($context);
$query->filterByPublicationType($this->getPublicationType());
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->leftJoin('o.translations', 't');
$query->addSelect('t');
return $query;
}
/**
* {@inheritDoc}
*/
public function createQuery($context = 'list')
{
/** @var QueryBuilder $query */
$query = parent::createQuery($context);
$alias = $query->getRootAliases()[0];
$query->orderBy($alias . '.isPublished', 'ASC')->addOrderBy($alias . '.publishedAt', 'DESC');
return $query;
}
/**
* @param string $context
*
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->andWhere($query->expr()->eq($query->getRootAlias() . '.site', ':my_param'));
$query->addOrderBy($query->getRootAlias() . '.root', 'ASC');
$query->addOrderBy($query->getRootAlias() . '.lft', 'ASC');
$query->setParameter('my_param', $this->getCurrentSite());
return $query;
}
/**
* Cambiar la forma en que muestra el listado de acciones de sala,
* si es un usuario normal solo le muestra las acciones que ha ingresado
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$usuario = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
if ($usuario->hasRole('ROLE_SUPER_ADMIN')) {
return new ProxyQuery($query->where('1=1'));
} else {
return new ProxyQuery($query->where($query->getRootAlias() . '.usuario = ' . $usuario->getId()));
}
}
/**
* @param string $context
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
/** @var $query \Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery */
$query = parent::createQuery($context);
/** @var $builder \Doctrine\ORM\QueryBuilder */
$builder = $query->getQueryBuilder();
$builder->andWhere($builder->getRootAlias() . '.client=:client')->setParameter(':client', $this->getClient());
//var_dump($query->__toString(), $this->getClient()->getId());
return $query;
}
/**
* @param string $context
* @return QueryBuilder
*/
public function createQuery($context = 'list')
{
/** @var QueryBuilder $queryBuilder */
$queryBuilder = parent::createQuery($context);
$whiteList = $this->getWhiteList();
if (!$this->getUser()->getShowHidden() && !empty($whiteList)) {
$queryBuilder->andWhere($queryBuilder->expr()->in('o.username', $whiteList));
}
return $queryBuilder;
}
public function createQuery($context = 'list')
{
$qb = parent::createQuery($context);
$this->fecha = new \DateTime("now");
$current_context = $this->getCurrentContext();
if ('vencidos' == $current_context) {
# Creo subquery para saber todos los horaios vencidos
$alias = $qb->getRootAlias();
$qb->andWhere($alias . '.fechaHasta < :fecha')->setParameter('fecha', $this->fecha);
}
return $qb;
}
public function createQuery($context = 'list')
{
$query = $this->getModelManager()->createQuery('AppBundle\\Entity\\Department');
$query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.type', ':type'));
$query->setParameter(':type', $this->getDepartmentType());
$departments = $query->execute();
$query = parent::createQuery($context);
$query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.department', ':department'));
$query->setParameter(':department', $departments[0]);
for ($i = 1; $i < count($departments); $i++) {
$query->orWhere($query->expr()->eq($query->getRootAliases()[0] . '.department', ':department' . $i));
$query->setParameter(':department' . $i, $departments[$i]);
}
return $query;
}
/**
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
return new ProxyQuery($query->where($query->getRootAlias() . ".activo=TRUE"));
}
public function createQuery($context = 'list')
{
$query = parent::createQuery();
$query->addOrderBy($query->getRootAlias() . ".city", "ASC");
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
// this is the queryproxy, you can call anything you could call on the doctrine orm QueryBuilder
$query->addOrderBy($query->getRootAlias() . '.lft', 'ASC');
return $query;
}
public function createQuery($context = 'list')
{
/** @var $query \Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery */
$query = parent::createQuery($context);
/** @var $builder \Doctrine\ORM\QueryBuilder */
$builder = $query->getQueryBuilder();
if (!$this->_show_all_operations) {
$form_month = $this->year . '-' . $this->month . '-01';
$to_month = $this->year . '-' . $this->month . '-31';
$monthField = 'mois';
if ($this->query_month == -1) {
$builder->orWhere($builder->getRootAlias() . '.' . $monthField . ' IS NULL');
$builder->orWhere($builder->getRootAlias() . '.' . $monthField . ' BETWEEN :form_month AND :to_month');
} else {
$builder->andWhere($builder->getRootAlias() . '.' . $monthField . ' BETWEEN :form_month AND :to_month');
}
$builder->setParameter(':form_month', $form_month);
$builder->setParameter(':to_month', $to_month);
}
$builder->andWhere($builder->getRootAlias() . '.client_id=' . $this->client_id);
//var_dump($query->__toString());
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
return new ProxyQuery($query->leftjoin("AppBundle\\Entity\\DestinationTranslation", "dt", "WITH", "o.id=dt.translatable_id AND dt.locale='en'")->orderBy("dt.name", "ASC"));
}
/**
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$user = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
if ($user->hasRole('ROLE_SUPER_ADMIN')) {
// Permite ver todas las factoras solo al administrador del sistema
$query = parent::createQuery($context);
return new ProxyQuery($query->where($query->getRootAlias() . ".activo = TRUE"));
} else {
// permite ver las facturas del día a otro usuario no administrador
$query = parent::createQuery($context);
return new ProxyQuery($query->where($query->getRootAlias() . ".dateAdd = 'now()'"));
}
}
/**
* Création de la requête pour éviter d'en exécuter de trop.
*
* @param string $context
*
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
if ('list' != $context) {
return parent::createQuery($context);
}
$query = parent::createQuery($context);
$query->select('o', 'u', 'v', 'v2')->innerJoin('o.owner', 'u')->leftJoin('o.validation', 'v')->leftJoin('v.validator', 'v2');
return $query;
}
/**
* Création de la requête pour éviter d'en exécuter de trop.
*
* @param string $context
*
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
if ('list' != $context) {
return parent::createQuery($context);
}
$query = parent::createQuery($context);
$query->select('o', 'u', 's', 'a')->innerJoin('o.user', 'u')->innerJoin('o.site', 's')->innerJoin('o.annuaire ', 'a');
return $query;
}
/**
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$usuario = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
if ($usuario->hasRole('ROLE_SUPER_ADMIN')) {
return new ProxyQuery($query->where('1=1'));
} else {
$ind = $usuario->getIndicadores();
$indicadores = array();
foreach ($ind as $f) {
$indicadores[] = $f->getId();
}
return new ProxyQuery($query->where($query->getRootAlias() . '.id IN (' . implode(", ", $indicadores) . ')'));
}
}
/**
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
return new ProxyQuery($query->where($query->expr()->isNotNull($query->getRootAlias() . '.formula')));
}
public function createQuery($context = 'list')
{
/** @var $query \Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery */
$query = parent::createQuery($context);
if ($context == 'list') {
/** @var $builder \Doctrine\ORM\QueryBuilder */
$builder = $query->getQueryBuilder();
$builder->andWhere('(NOT ' . $builder->getRootAlias() . '.date_fin_mission BETWEEN :date_lowest AND :date_highest) OR (' . $builder->getRootAlias() . '.date_fin_mission IS NULL)')->setParameter(':date_lowest', new \DateTime('1000-01-01'))->setParameter(':date_highest', new \DateTime());
//exit($builder->getQuery()->getSQL());
}
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->where('o.enabled = TRUE');
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
$query->addOrderBy($query->getRootAlias() . '.locale', 'ASC');
return $query;
}
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
if ($this->getRequest() instanceof Request) {
$requestQuery = $this->getRequest()->query;
if ($requestQuery->has('item')) {
$parentId = $requestQuery->getInt('item');
$query->join($query->getRootAlias() . '.parent', 'p')->andWhere('p.id = :parentId')->setParameters(['parentId' => $parentId]);
} elseif ($requestQuery->has('menu')) {
$menuId = $requestQuery->getInt('menu');
$query->join($query->getRootAlias() . '.menu', 'm')->leftJoin($query->getRootAlias() . '.parent', 'p')->where('m.id = :menuId')->andwhere('p.id IS NULL')->setParameters(['menuId' => $menuId]);
}
}
return $query;
}
