@@ -20,8 +20,8 @@ discard block |
||
20 | 20 | if ($request->has('searchTerm')) { |
21 | 21 | $columnsToSearch = ['group', 'type', 'stat', 'date', 'plac', 'temp', 'slac_famc']; |
22 | 22 | $search_term = json_decode($request->searchTerm)->searchTerm; |
23 | - if (! empty($search_term)) { |
|
24 | - $searchQuery = '%'.$search_term.'%'; |
|
23 | + if (!empty($search_term)) { |
|
24 | + $searchQuery = '%' . $search_term . '%'; |
|
25 | 25 | foreach ($columnsToSearch as $column) { |
26 | 26 | $query->orWhere($column, 'LIKE', $searchQuery); |
27 | 27 | } |
@@ -32,8 +32,8 @@ discard block |
||
32 | 32 | $filters = get_object_vars(json_decode($request->columnFilters)); |
33 | 33 | |
34 | 34 | foreach ($filters as $key => $value) { |
35 | - if (! empty($value)) { |
|
36 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
35 | + if (!empty($value)) { |
|
36 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
37 | 37 | } |
38 | 38 | } |
39 | 39 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['repo', 'name', 'addr_id', 'rin', 'email', 'phon', 'fax', 'www', 'description', 'type_id', '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,9 +31,9 @@ discard block |
||
31 | 31 | $filters = get_object_vars(json_decode($request->columnFilters)); |
32 | 32 | $relationship_column = ['addr.adr1', 'type.name']; |
33 | 33 | foreach ($filters as $key => $value) { |
34 | - if (! in_array($key, $relationship_column)) { |
|
35 | - if (! empty($value)) { |
|
36 | - $query->orWhere($key, 'like', '%'.$value.'%'); |
|
34 | + if (!in_array($key, $relationship_column)) { |
|
35 | + if (!empty($value)) { |
|
36 | + $query->orWhere($key, 'like', '%' . $value . '%'); |
|
37 | 37 | } |
38 | 38 | } |
39 | 39 | } |
@@ -19,8 +19,8 @@ discard block |
||
19 | 19 | if ($request->has('searchTerm')) { |
20 | 20 | $columnsToSearch = ['name']; |
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 | } |
@@ -45,7 +45,7 @@ discard block |
||
45 | 45 | if ($request->has('perPage')) { |
46 | 46 | $rows = $query->paginate($request->perPage); |
47 | 47 | } |
48 | - if (! count($request->all())) { |
|
48 | + if (!count($request->all())) { |
|
49 | 49 | $rows = $query->get()->toArray(); |
50 | 50 | } |
51 | 51 |
@@ -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 = ['adr1', 'adr2', 'city', 'stae', 'post', 'ctry']; |
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 = ['name']; |
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', 'date', 'plac']; |
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', 'indi', 'rela', 'import_confirm']; |
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 | } |