@@ -21,8 +21,8 @@ discard block |
||
21 | 21 | if ($request->has('searchTerm')) { |
22 | 22 | $columnsToSearch = ['description', 'is_active', 'husband_id', 'wife_id', 'type_id', 'chan', 'nchi', 'rin']; |
23 | 23 | $search_term = json_decode($request->searchTerm)->searchTerm; |
24 | - if (! empty($search_term)) { |
|
25 | - $searchQuery = '%'.$search_term.'%'; |
|
24 | + if (!empty($search_term)) { |
|
25 | + $searchQuery = '%' . $search_term . '%'; |
|
26 | 26 | foreach ($columnsToSearch as $column) { |
27 | 27 | $query->orWhere($column, 'LIKE', $searchQuery); |
28 | 28 | } |
@@ -33,8 +33,8 @@ discard block |
||
33 | 33 | $filters = get_object_vars(json_decode($request->columnFilters)); |
34 | 34 | |
35 | 35 | foreach ($filters as $key => $value) { |
36 | - if (! empty($value)) { |
|
37 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
36 | + if (!empty($value)) { |
|
37 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
38 | 38 | } |
39 | 39 | } |
40 | 40 | } |
@@ -47,7 +47,7 @@ discard block |
||
47 | 47 | if ($request->has('perPage')) { |
48 | 48 | $rows = $query->paginate($request->perPage); |
49 | 49 | } |
50 | - if (! count($request->all())) { |
|
50 | + if (!count($request->all())) { |
|
51 | 51 | $rows = $query->get(); |
52 | 52 | } |
53 | 53 |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['group', 'date', 'text', 'agnc']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['group', 'even', 'role']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['name', 'email', 'phone']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['group', 'refn', 'type']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['group', 'subm']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |
@@ -21,8 +21,8 @@ discard block |
||
21 | 21 | if ($request->has('searchTerm')) { |
22 | 22 | $columnsToSearch = ['titl', 'sour', 'auth', 'data', 'text', 'publ', 'abbr', 'name', 'description', 'repository_id', 'author_id', 'publication_id', 'type_id', 'is_active', 'group', 'quay', 'page']; |
23 | 23 | $search_term = json_decode($request->searchTerm)->searchTerm; |
24 | - if (! empty($search_term)) { |
|
25 | - $searchQuery = '%'.$search_term.'%'; |
|
24 | + if (!empty($search_term)) { |
|
25 | + $searchQuery = '%' . $search_term . '%'; |
|
26 | 26 | foreach ($columnsToSearch as $column) { |
27 | 27 | $query->orWhere($column, 'LIKE', $searchQuery); |
28 | 28 | } |
@@ -33,9 +33,9 @@ discard block |
||
33 | 33 | $filters = get_object_vars(json_decode($request->columnFilters)); |
34 | 34 | $relationship_column = ['repositories.name', 'author.name', 'publication.name', 'type.name']; |
35 | 35 | foreach ($filters as $key => $value) { |
36 | - if (! in_array($key, $relationship_column)) { |
|
37 | - if (! empty($value)) { |
|
38 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
36 | + if (!in_array($key, $relationship_column)) { |
|
37 | + if (!empty($value)) { |
|
38 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
39 | 39 | } |
40 | 40 | } |
41 | 41 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['subm', 'famf', 'temp', 'ance', 'desc', 'rin']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['name', 'description', 'is_active']; |
21 | 21 | $search_term = json_decode($request->searchTerm)->searchTerm; |
22 | - if (! empty($search_term)) { |
|
23 | - $searchQuery = '%'.$search_term.'%'; |
|
22 | + if (!empty($search_term)) { |
|
23 | + $searchQuery = '%' . $search_term . '%'; |
|
24 | 24 | foreach ($columnsToSearch as $column) { |
25 | 25 | $query->orWhere($column, 'LIKE', $searchQuery); |
26 | 26 | } |
@@ -31,8 +31,8 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! empty($value)) { |
|
35 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!empty($value)) { |
|
35 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
36 | 36 | } |
37 | 37 | } |
38 | 38 | } |