| @@ 343-348 (lines=6) @@ | ||
| 340 | $query = DB::collection('project'); |
|
| 341 | ||
| 342 | $s = $request->input('s'); |
|
| 343 | if (isset($s) && $s) { |
|
| 344 | $query->where( |
|
| 345 | function ($query) use ($s) { |
|
| 346 | $query->where('key', 'like', '%' . $s . '%')->orWhere('name', 'like', '%' . $s . '%'); |
|
| 347 | } |
|
| 348 | ); |
|
| 349 | } |
|
| 350 | ||
| 351 | $projects = $query->take(10)->get([ 'name', 'key' ]); |
|
| @@ 376-381 (lines=6) @@ | ||
| 373 | } |
|
| 374 | ||
| 375 | $name = $request->input('name'); |
|
| 376 | if (isset($name) && $name) { |
|
| 377 | $query->where( |
|
| 378 | function ($query) use ($name) { |
|
| 379 | $query->where('key', 'like', '%' . $name . '%')->orWhere('name', 'like', '%' . $name . '%'); |
|
| 380 | } |
|
| 381 | ); |
|
| 382 | } |
|
| 383 | ||
| 384 | // get total |
|