|
@@ 292-296 (lines=5) @@
|
| 289 |
|
|
| 290 |
|
switch ($strategy) { |
| 291 |
|
case null: |
| 292 |
|
case self::STRATEGY_EXACT: |
| 293 |
|
$queryBuilder |
| 294 |
|
->andWhere(sprintf($wrapCase('%s.%s').' = '.$wrapCase(':%s'), $alias, $field, $valueParameter)) |
| 295 |
|
->setParameter($valueParameter, $value); |
| 296 |
|
break; |
| 297 |
|
case self::STRATEGY_PARTIAL: |
| 298 |
|
$queryBuilder |
| 299 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s, \'%%\')'), $alias, $field, $valueParameter)) |
|
@@ 297-301 (lines=5) @@
|
| 294 |
|
->andWhere(sprintf($wrapCase('%s.%s').' = '.$wrapCase(':%s'), $alias, $field, $valueParameter)) |
| 295 |
|
->setParameter($valueParameter, $value); |
| 296 |
|
break; |
| 297 |
|
case self::STRATEGY_PARTIAL: |
| 298 |
|
$queryBuilder |
| 299 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s, \'%%\')'), $alias, $field, $valueParameter)) |
| 300 |
|
->setParameter($valueParameter, $value); |
| 301 |
|
break; |
| 302 |
|
case self::STRATEGY_START: |
| 303 |
|
$queryBuilder |
| 304 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(:%s, \'%%\')'), $alias, $field, $valueParameter)) |
|
@@ 302-306 (lines=5) @@
|
| 299 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s, \'%%\')'), $alias, $field, $valueParameter)) |
| 300 |
|
->setParameter($valueParameter, $value); |
| 301 |
|
break; |
| 302 |
|
case self::STRATEGY_START: |
| 303 |
|
$queryBuilder |
| 304 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(:%s, \'%%\')'), $alias, $field, $valueParameter)) |
| 305 |
|
->setParameter($valueParameter, $value); |
| 306 |
|
break; |
| 307 |
|
case self::STRATEGY_END: |
| 308 |
|
$queryBuilder |
| 309 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s)'), $alias, $field, $valueParameter)) |
|
@@ 307-311 (lines=5) @@
|
| 304 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(:%s, \'%%\')'), $alias, $field, $valueParameter)) |
| 305 |
|
->setParameter($valueParameter, $value); |
| 306 |
|
break; |
| 307 |
|
case self::STRATEGY_END: |
| 308 |
|
$queryBuilder |
| 309 |
|
->andWhere(sprintf($wrapCase('%s.%s').' LIKE '.$wrapCase('CONCAT(\'%%\', :%s)'), $alias, $field, $valueParameter)) |
| 310 |
|
->setParameter($valueParameter, $value); |
| 311 |
|
break; |
| 312 |
|
case self::STRATEGY_WORD_START: |
| 313 |
|
$queryBuilder |
| 314 |
|
->andWhere(sprintf($wrapCase('%1$s.%2$s').' LIKE '.$wrapCase('CONCAT(:%3$s, \'%%\')').' OR '.$wrapCase('%1$s.%2$s').' LIKE '.$wrapCase('CONCAT(\'%% \', :%3$s, \'%%\')'), $alias, $field, $valueParameter)) |
api-platform /
core
