本文整理汇总了PHP中Sonata\AdminBundle\Datagrid\ProxyQueryInterface::getRootEntities方法的典型用法代码示例。如果您正苦于以下问题:PHP ProxyQueryInterface::getRootEntities方法的具体用法?PHP ProxyQueryInterface::getRootEntities怎么用?PHP ProxyQueryInterface::getRootEntities使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Sonata\AdminBundle\Datagrid\ProxyQueryInterface
的用法示例。
在下文中一共展示了ProxyQueryInterface::getRootEntities方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: filter
/**
* {@inheritdoc}
*/
public function filter(ProxyQueryInterface $queryBuilder, $alias, $field, $data)
{
if (!$data || !is_array($data) || !array_key_exists('value', $data)) {
return;
}
$data['value'] = trim($data['value']);
if (strlen($data['value']) == 0) {
return;
}
$data['type'] = !isset($data['type']) ? ChoiceType::TYPE_CONTAINS : $data['type'];
$operator = $this->getOperator((int) $data['type']);
if (!$operator) {
$operator = 'LIKE';
}
$entities = $queryBuilder->getRootEntities();
$classMetadata = $this->listener->getTranslatableMetadata(current($entities));
$transMetadata = $this->listener->getTranslatableMetadata($classMetadata->targetEntity);
// Add inner join
if (!$this->hasJoin($queryBuilder, $alias)) {
$parameterName = $this->getNewParameterName($queryBuilder);
$queryBuilder->innerJoin(sprintf('%s.%s', $alias, $classMetadata->translations->name), 'trans', Expr\Join::WITH, sprintf('trans.%s = :%s', $transMetadata->locale->name, $parameterName));
$queryBuilder->setParameter($parameterName, $this->listener->getCurrentLocale());
}
// c.name > '1' => c.name OPERATOR :FIELDNAME
$parameterName = $this->getNewParameterName($queryBuilder);
$this->applyWhere($queryBuilder, sprintf('%s.%s %s :%s', 'trans', $field, $operator, $parameterName));
if ($data['type'] == ChoiceType::TYPE_EQUAL) {
$queryBuilder->setParameter($parameterName, $data['value']);
} else {
$queryBuilder->setParameter($parameterName, sprintf($this->getOption('format'), $data['value']));
}
}