yajra /
laravel-datatables
| @@ 330-337 (lines=8) @@ | ||
| 327 | * @param mixed $column |
|
| 328 | * @param string $keyword |
|
| 329 | */ |
|
| 330 | protected function regexCaseInsensitiveColumnSearch($column, $keyword) |
|
| 331 | { |
|
| 332 | if ($this->isOracleSql()) { |
|
| 333 | $this->query->whereRaw('REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )', [$keyword]); |
|
| 334 | } else { |
|
| 335 | $this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]); |
|
| 336 | } |
|
| 337 | } |
|
| 338 | ||
| 339 | /** |
|
| 340 | * Perform case sensitive column search. |
|
| @@ 360-367 (lines=8) @@ | ||
| 357 | * @param mixed $column |
|
| 358 | * @param string $keyword |
|
| 359 | */ |
|
| 360 | protected function regexCaseSensitiveColumnSearch($column, $keyword) |
|
| 361 | { |
|
| 362 | if ($this->isOracleSql()) { |
|
| 363 | $this->query->whereRaw('REGEXP_LIKE( ' . $column . ' , ? )', [$keyword]); |
|
| 364 | } else { |
|
| 365 | $this->query->whereRaw($column . ' REGEXP ?', [$keyword]); |
|
| 366 | } |
|
| 367 | } |
|
| 368 | ||
| 369 | /** |
|
| 370 | * @inheritdoc |
|
