/**
* {@inheritdoc}
*/
protected function doWalkComparison($fieldName, $operator, $placeholder)
{
switch ($operator) {
case Comparison::IN:
return $this->expr->in($fieldName, $placeholder);
case Comparison::NIN:
return $this->expr->notIn($fieldName, $placeholder);
case Comparison::EQ:
case Comparison::IS:
if ($placeholder === null) {
return $this->expr->isNull($fieldName);
}
return $this->expr->eq($fieldName, $placeholder);
case Comparison::NEQ:
if ($placeholder === null) {
return $this->expr->isNotNull($fieldName);
}
return $this->expr->neq($fieldName, $placeholder);
case Comparison::CONTAINS:
return $this->expr->like($fieldName, $placeholder);
default:
$operator = self::convertComparisonOperator($operator);
if ($operator) {
return $this->expr->comparison($fieldName, $operator, $placeholder);
}
throw new \RuntimeException("Unknown comparison operator: " . $operator);
}
}
/**
* Creates an IS NULL expression with the given arguments.
*
* @param string $x The field in string format to be restricted by IS NULL.
*
* @return string
*/
public function isNull($x)
{
$x = $this->helper->quoteColumnName($x);
return $this->expressionBuilder->isNull($x);
}
/**
* Get list of entities for autopopulate fields.
*
* @param $type
* @param $filter
* @param $limit
* @param $start
*
* @return array
*/
public function getLookupResults($type, $filter = '', $limit = 10, $start = 0)
{
$results = [];
switch ($type) {
case 'companyfield':
case 'lead.company':
$expr = null;
if ('lead.company' === $type) {
$column = 'companyname';
$filterVal = $filter;
} else {
if (is_array($filter)) {
$column = $filter[0];
$filterVal = $filter[1];
} else {
$column = $filter;
}
}
$expr = new ExpressionBuilder($this->em->getConnection());
$composite = $expr->andX();
$composite->add($expr->like("comp.{$column}", ':filterVar'));
// Validate owner permissions
if (!$this->security->isGranted('lead:leads:viewother')) {
$composite->add($expr->orX($expr->andX($expr->isNull('comp.owner_id'), $expr->eq('comp.created_by', (int) $this->userHelper->getUser()->getId())), $expr->eq('comp.owner_id', (int) $this->userHelper->getUser()->getId())));
}
$results = $this->em->getRepository('MauticLeadBundle:Company')->getSimpleList($composite, ['filterVar' => $filterVal . '%'], $column);
break;
}
return $results;
}
public function testIsNull()
{
$this->assertEquals($this->doctrineExpressionBuilder->isNull('`test`'), $this->expressionBuilder->isNull('test'));
}
/**
* @param $queryBuilder
* @param $expressionBuilder
*/
protected function addFilteredProperties(QueryBuilder &$queryBuilder, ExpressionBuilder $expressionBuilder)
{
if (!count($this->filteredProperties)) {
return;
}
foreach ($this->filteredProperties as $index => $filteredProperty) {
$property = 'm.' . $filteredProperty['membersPropertyFilter_property'];
$comparator = $filteredProperty['membersPropertyFilter_comparator'];
$value = $filteredProperty['membersPropertyFilter_value'];
switch ($comparator) {
case 'empty':
$queryBuilder->andWhere($expressionBuilder->orX($expressionBuilder->eq($property, ':property' . $index), $expressionBuilder->isNull($property)));
$value = '';
break;
case 'not empty':
$queryBuilder->andWhere($expressionBuilder->gt($property, ':property' . $index));
$value = '';
break;
default:
if (!method_exists($expressionBuilder, $comparator)) {
continue;
}
$queryBuilder->andWhere($expressionBuilder->{$comparator}($property, ':property' . $index));
break;
}
$queryBuilder->setParameter(':property' . $index, $value);
}
}
