Alive2212 / LaravelQueryHelper

tests/CreatesApplication.php

Spacing +1 added lines, -1 removed lines

@@ -16,7 +16,7 @@
      */
     public function createApplication()
     {
-        $app = require __DIR__ . '/../../../../bootstrap/app.php';
+        $app = require __DIR__.'/../../../../bootstrap/app.php';
 //        $kernel = new Kernel();
 //        dd($kernel);
         $app->make(Kernel::class)->bootstrap();

src/QueryHelper.php

Spacing +12 added lines, -14 removed lines

@@ -35,7 +35,7 @@ 
         $result = $query;
         $keys = explode('.', $filters[0]['key']);
         if (collect($keys)->count() == 2) {
-            $result = $result->orWhereHas($keys[0], function ($query) use ($filters, $keys) {
+            $result = $result->orWhereHas($keys[0], function($query) use ($filters, $keys) {
                 foreach ($filters as $filter) {
                     $keys = explode('.', $filter['key']);
                     $query->where($keys[1], $filter['operator'], $filter['value']);
@@ -100,8 +100,7 @@ 
                 $result = $this->getHierarchyFilterKey($filter);
             }
             $key = $level % 2 == $this->orWhereConditionLevel ?
-                'or_' . $this->queryFilterTitle :
-                'and_' . $this->queryFilterTitle;
+                'or_'.$this->queryFilterTitle : 'and_'.$this->queryFilterTitle;
             $adaptedFilters = array_merge_recursive($adaptedFilters, [$key => $result]);
         }
         return $adaptedFilters;
@@ -156,7 +155,7 @@ 
     {
         foreach ($filters as $filterKey => $filterValues) {
             $currentFilter = [$filterKey => $filterValues];
-            $model = $model->Where(function ($query) use ($currentFilter) {
+            $model = $model->Where(function($query) use ($currentFilter) {
                 $this->addWhereCondition($query, $currentFilter, $this->orWhereConditionLevel == 0 ? 'and' : 'or');
             });
         }
@@ -219,15 +218,15 @@ 
                 return $this->addWhereCondition($model, $filters, $type, ++$index);
 
             // if and
-            case 'and_' . $this->queryFilterTitle:
+            case 'and_'.$this->queryFilterTitle:
                 // if not first record and type is or
                 if ($type == "or" && $index > 0) {
-                    $model = $model->orWhere(function (Builder $builder) use ($firstFilterValue) {
+                    $model = $model->orWhere(function(Builder $builder) use ($firstFilterValue) {
                         $builder = $this->addWhereCondition($builder, $firstFilterValue, 'and', 0);
                         return $builder;
                     });
                 } else {
-                    $model = $model->where(function (Builder $builder) use ($firstFilterValue) {
+                    $model = $model->where(function(Builder $builder) use ($firstFilterValue) {
                         $builder = $this->addWhereCondition($builder, $firstFilterValue, 'and', 0);
                         return $builder;
                     });
@@ -235,15 +234,15 @@ 
                 break;
 
             // if or
-            case 'or_' . $this->queryFilterTitle:
+            case 'or_'.$this->queryFilterTitle:
                 // if not first record and type is or
                 if ($type == "or" && $index > 0) {
-                    $model = $model->orWhere(function (Builder $builder) use ($firstFilterValue) {
+                    $model = $model->orWhere(function(Builder $builder) use ($firstFilterValue) {
                         $builder = $this->addWhereCondition($builder, $firstFilterValue, 'or', 0);
                         return $builder;
                     });
                 } else {
-                    $model = $model->where(function (Builder $builder) use ($firstFilterValue) {
+                    $model = $model->where(function(Builder $builder) use ($firstFilterValue) {
                         $builder = $this->addWhereCondition($builder, $firstFilterValue, 'or', 0);
                         return $builder;
                     });
@@ -254,12 +253,12 @@ 
             default:
                 // if not first record and type is or
                 if ($type == "or" && $index > 0) {
-                    $model = $model->orWhereHas($firstFilterKey, function (Builder $builder) use ($firstFilterValue) {
+                    $model = $model->orWhereHas($firstFilterKey, function(Builder $builder) use ($firstFilterValue) {
                         $builder = $this->addWhereCondition($builder, $firstFilterValue, 'or', 0);
                         return $builder;
                     });
                 } else {
-                    $model = $model->whereHas($firstFilterKey, function (Builder $builder) use ($firstFilterValue) {
+                    $model = $model->whereHas($firstFilterKey, function(Builder $builder) use ($firstFilterValue) {
                         $builder = $this->addWhereCondition($builder, $firstFilterValue, 'and', 0);
                         return $builder;
                     });
@@ -321,7 +320,6 @@ 
      */
     public function getFilterValue(array $filter): ?string
     {
-        return (array_key_exists('value', $filter)) ? $filter['value'] :
-            ($filter[2] == null ? "null" : $filter[2]);
+        return (array_key_exists('value', $filter)) ? $filter['value'] : ($filter[2] == null ? "null" : $filter[2]);
     }
 }