|
@@ 318-322 (lines=5) @@
|
| 315 |
|
protected function caseInsensitiveColumnSearch($i, $column, $keyword) |
| 316 |
|
{ |
| 317 |
|
if ($this->request->isRegex($i)) { |
| 318 |
|
if ($this->isOracleSql()) { |
| 319 |
|
$this->query->whereRaw('REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )', [$keyword]); |
| 320 |
|
} else { |
| 321 |
|
$this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]); |
| 322 |
|
} |
| 323 |
|
} else { |
| 324 |
|
$this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [Str::lower($keyword)]); |
| 325 |
|
} |
|
@@ 338-342 (lines=5) @@
|
| 335 |
|
protected function caseSensitiveColumnSearch($i, $column, $keyword) |
| 336 |
|
{ |
| 337 |
|
if ($this->request->isRegex($i)) { |
| 338 |
|
if ($this->isOracleSql()) { |
| 339 |
|
$this->query->whereRaw('REGEXP_LIKE( ' . $column . ' , ? )', [$keyword]); |
| 340 |
|
} else { |
| 341 |
|
$this->query->whereRaw($column . ' REGEXP ?', [$keyword]); |
| 342 |
|
} |
| 343 |
|
} else { |
| 344 |
|
$this->query->whereRaw($column . ' LIKE ?', [$keyword]); |
| 345 |
|
} |