@@ -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 | } |