/**
* Search filter: summary OR body.
*/
protected function search()
{
$info = $this->extract('search');
$value = $this->quote(str_replace('*', '%', "%{$info['values']}%"));
$expr = $this->expr->orX($this->expr->like('t.summary', $value), $this->expr->like('t.body', $value));
$this->builder->andWhere($expr);
$this->filters['search'] = $info;
}
/**
* 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;
}
/**
* @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);
}
}
