/** * @param string $alias * @return Expr\Andx|Expr\Comparison|Expr\Composite|null */ public function getWhere($alias) { $expr = new Expr\Andx(); foreach ($this->criteria as $key => $value) { $expr->add(new Expr\Comparison(sprintf("%s.%s", $alias, $key), Expr\Comparison::EQ, $value)); } return $expr->count() != 0 ? $expr : null; }
/** * @param string $alias * @return Expr\Andx|Expr\Comparison|Expr\Composite|null */ public function getWhere($alias) { $expr = new Expr\Andx(); foreach ($this->fits as $fit) { if ($fit instanceof WhereFitInterface) { $expr->add($fit->getWhere($alias)); } } return $expr->count() != 0 ? $expr : null; }
public function createGridQueryBuilder($entityClass, $params) { $qb = $this->em->createQueryBuilder(); $qb->from($entityClass, 'o'); $this->_addJoinEntity($qb, $params); $searches = array(); if (isset($params['search']['value'])) { $searches = explode(" ", trim($params['search']['value'])); for ($index = 0; $index < count($searches); $index++) { $qb->setParameter('main_search_' . $index, '%' . $searches[$index] . '%'); } } $fieldsSearch = new Expr\Andx(); $globalSearch = new Expr\Orx(); if (isset($params['columns'])) { foreach ($params['columns'] as $columns) { if ($columns['name'] && substr($columns['name'], 0, 1) != '_') { $field = $this->_getFieldName($columns['name']); $fieldAlias = str_replace(".", "_", $columns['name']); for ($index = 0; $index < count($searches); $index++) { $globalSearch->add($qb->expr()->like($field, ':main_search_' . $index)); } if ($columns['search']['value']) { $fieldsSearch->add($qb->expr()->like($field, ':' . $fieldAlias . '_search')); $qb->setParameter($fieldAlias . '_search', '%' . $columns['search']['value'] . '%'); } } } } $searchWhere = new Expr\Andx(); if (isset($fieldsSearch)) { $searchWhere->add($fieldsSearch); } if (isset($globalSearch)) { $searchWhere->add($globalSearch); } if ($searchWhere->count()) { $qb->andWhere($searchWhere); } return $qb; }
/** * {@inheritdoc} */ public function addAndExpression(Andx $andExpr, QueryBuilder $pivot, $searchField, $searchValue, &$i) { list($_dateStart, $_dateEnd) = explode(' - ', $searchValue); $dateStart = new \DateTime($_dateStart); $dateEnd = new \DateTime($_dateEnd); $dateEnd->setTime(23, 59, 59); $k = $i + 1; $andExpr->add($pivot->expr()->between($searchField, '?' . $i, '?' . $k)); $pivot->setParameter($i, $dateStart->format('Y-m-d H:i:s')); $pivot->setParameter($k, $dateEnd->format('Y-m-d H:i:s')); $i += 2; return $andExpr; }
/** * @param Andx $andExpr * @param QueryBuilder $pivot * @param string $searchField * @param mixed $from * @param mixed $to * @param integer $i * * @return Andx */ protected function getBetweenAndExpression(Andx $andExpr, QueryBuilder $pivot, $searchField, $from, $to, $i) { $k = $i + 1; $andExpr->add($pivot->expr()->between($searchField, '?' . $i, '?' . $k)); $pivot->setParameter($i, $from); $pivot->setParameter($k, $to); return $andExpr; }
/** * Add a condition. * * @param Andx $andExpr * @param QueryBuilder $pivot * @param string $searchType * @param string $searchField * @param string $searchValue * @param integer $i * * @return Andx */ private function addCondition(Andx $andExpr, QueryBuilder $pivot, $searchType, $searchField, $searchValue, $i) { switch ($searchType) { case 'like': $andExpr->add($pivot->expr()->like($searchField, '?' . $i)); $pivot->setParameter($i, '%' . $searchValue . '%'); break; case 'notLike': $andExpr->add($pivot->expr()->notLike($searchField, '?' . $i)); $pivot->setParameter($i, '%' . $searchValue . '%'); break; case 'eq': $andExpr->add($pivot->expr()->eq($searchField, '?' . $i)); $pivot->setParameter($i, $searchValue); break; case 'neq': $andExpr->add($pivot->expr()->neq($searchField, '?' . $i)); $pivot->setParameter($i, $searchValue); break; case 'lt': $andExpr->add($pivot->expr()->lt($searchField, '?' . $i)); $pivot->setParameter($i, $searchValue); break; case 'lte': $andExpr->add($pivot->expr()->lte($searchField, '?' . $i)); $pivot->setParameter($i, $searchValue); break; case 'gt': $andExpr->add($pivot->expr()->gt($searchField, '?' . $i)); $pivot->setParameter($i, $searchValue); break; case 'gte': $andExpr->add($pivot->expr()->gte($searchField, '?' . $i)); $pivot->setParameter($i, $searchValue); break; case 'in': $andExpr->add($pivot->expr()->in($searchField, '?' . $i)); $pivot->setParameter($i, explode(',', $searchValue)); break; case 'notIn': $andExpr->add($pivot->expr()->notIn($searchField, '?' . $i)); $pivot->setParameter($i, explode(",", $searchValue)); break; case 'isNull': $andExpr->add($pivot->expr()->isNull($searchField)); break; case 'isNotNull': $andExpr->add($pivot->expr()->isNull($searchField)); break; } return $andExpr; }
/** * @param \Doctrine\ORM\QueryBuilder $query * @return \Doctrine\ORM\QueryBuilder */ public function generateWhere(QueryBuilder $query) { $orxSearch = new Expr\Orx(); $andxIndv = new Expr\Andx(); $parameters = new ArrayCollection(); foreach ($this->getClauses() as $key => $value) { if (isset($value['indv'])) { $andxIndv->add($value['indv']['clause']); $this->createParameters($value['indv']['params'], $parameters); } if (isset($value['search'])) { $orxSearch->add($value['search']['clause']); $this->createParameters($value['search']['params'], $parameters); } } $andxIndv->add($orxSearch); $query->where($andxIndv); $p = $parameters->toArray(); foreach ($p as $param) { $query->setParameter($param->getName(), $param->getValue(), $param->getType()); } return $query; }
/** * {@inheritdoc} */ public function addAndExpression(Andx $andExpr, QueryBuilder $pivot, $searchField, $searchValue, &$i) { if (true === $this->range) { $array = explode(',', $searchValue); list($searchMin, $searchMax) = $array; } else { $searchMin = $this->min; $searchMax = $searchValue; } $k = $i + 1; $andExpr->add($pivot->expr()->between($searchField, '?' . $i, '?' . $k)); $pivot->setParameter($i, $searchMin); $pivot->setParameter($k, $searchMax); $i += 2; return $andExpr; }
public function testIsApplicableVisitTwice() { $config = $this->getMockBuilder('Oro\\Bundle\\DataGridBundle\\Datagrid\\Common\\DatagridConfiguration')->disableOriginalConstructor()->getMock(); $config->expects($this->any())->method('offsetGetByPath')->will($this->returnValueMap([['[name]', null, ConfigurationProvider::GRID_PREFIX . '1'], [Builder::DATASOURCE_TYPE_PATH, null, OrmDatasource::TYPE]])); $this->marketingListHelper->expects($this->any())->method('getMarketingListIdByGridName')->with(ConfigurationProvider::GRID_PREFIX . '1')->will($this->returnValue(1)); $this->marketingListHelper->expects($this->any())->method('getMarketingList')->with(1)->will($this->returnValue(new MarketingList())); $this->assertTrue($this->extension->isApplicable($config)); $qb = $this->getQbMock(); $dataSource = $this->getMockBuilder('Oro\\Bundle\\DataGridBundle\\Datasource\\Orm\\OrmDatasource')->disableOriginalConstructor()->getMock(); $condition = new Andx(); $condition->add('argument'); $qb->expects($this->once())->method('getDQLParts')->will($this->returnValue(['where' => $condition])); $dataSource->expects($this->once())->method('getQueryBuilder')->will($this->returnValue($qb)); $this->extension->visitDatasource($config, $dataSource); $this->assertFalse($this->extension->isApplicable($config)); }