@@ -27,17 +27,17 @@ |
||
| 27 | 27 | $this->model = $this->model->where(function (Builder $query) use ($field, $value) { |
| 28 | 28 | $query->where(function (Builder $query) use ($field, $value) { |
| 29 | 29 | $query->where("{$field}_min", '<=', $value[0]) |
| 30 | - ->where("{$field}_max", '>=', $value[1]); |
|
| 30 | + ->where("{$field}_max", '>=', $value[1]); |
|
| 31 | 31 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 32 | 32 | $query->where("{$field}_min", '<=', $value[0]) |
| 33 | - ->where("{$field}_max", '>=', $value[0]); |
|
| 33 | + ->where("{$field}_max", '>=', $value[0]); |
|
| 34 | 34 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 35 | 35 | $query->where("{$field}_min", '>=', $value[0]) |
| 36 | - ->where("{$field}_max", '<=', $value[1]); |
|
| 36 | + ->where("{$field}_max", '<=', $value[1]); |
|
| 37 | 37 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 38 | 38 | $query->where("{$field}_min", '>=', $value[0]) |
| 39 | - ->where("{$field}_max", '>=', $value[1]) |
|
| 40 | - ->where("{$field}_min", '<=', $value[1]); |
|
| 39 | + ->where("{$field}_max", '>=', $value[1]) |
|
| 40 | + ->where("{$field}_min", '<=', $value[1]); |
|
| 41 | 41 | }); |
| 42 | 42 | }); |
| 43 | 43 | break; |
@@ -24,17 +24,17 @@ |
||
| 24 | 24 | $this->model = $this->model->whereBetween($field, $value); |
| 25 | 25 | break; |
| 26 | 26 | case 'cross': |
| 27 | - $this->model = $this->model->where(function (Builder $query) use ($field, $value) { |
|
| 28 | - $query->where(function (Builder $query) use ($field, $value) { |
|
| 27 | + $this->model = $this->model->where(function(Builder $query) use ($field, $value) { |
|
| 28 | + $query->where(function(Builder $query) use ($field, $value) { |
|
| 29 | 29 | $query->where("{$field}_min", '<=', $value[0]) |
| 30 | 30 | ->where("{$field}_max", '>=', $value[1]); |
| 31 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 31 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 32 | 32 | $query->where("{$field}_min", '<=', $value[0]) |
| 33 | 33 | ->where("{$field}_max", '>=', $value[0]); |
| 34 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 34 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 35 | 35 | $query->where("{$field}_min", '>=', $value[0]) |
| 36 | 36 | ->where("{$field}_max", '<=', $value[1]); |
| 37 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 37 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 38 | 38 | $query->where("{$field}_min", '>=', $value[0]) |
| 39 | 39 | ->where("{$field}_max", '>=', $value[1]) |
| 40 | 40 | ->where("{$field}_min", '<=', $value[1]); |
@@ -28,17 +28,17 @@ |
||
| 28 | 28 | $this->model = $this->model->orWhere(function (Builder $query) use ($field, $value) { |
| 29 | 29 | $query->where(function (Builder $query) use ($field, $value) { |
| 30 | 30 | $query->where("{$field}_min", '<=', $value[0]) |
| 31 | - ->where("{$field}_max", '>=', $value[1]); |
|
| 31 | + ->where("{$field}_max", '>=', $value[1]); |
|
| 32 | 32 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 33 | 33 | $query->where("{$field}_min", '<=', $value[0]) |
| 34 | - ->where("{$field}_max", '>=', $value[0]); |
|
| 34 | + ->where("{$field}_max", '>=', $value[0]); |
|
| 35 | 35 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 36 | 36 | $query->where("{$field}_min", '>=', $value[0]) |
| 37 | - ->where("{$field}_max", '<=', $value[1]); |
|
| 37 | + ->where("{$field}_max", '<=', $value[1]); |
|
| 38 | 38 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 39 | 39 | $query->where("{$field}_min", '>=', $value[0]) |
| 40 | - ->where("{$field}_max", '>=', $value[1]) |
|
| 41 | - ->where("{$field}_min", '<=', $value[1]); |
|
| 40 | + ->where("{$field}_max", '>=', $value[1]) |
|
| 41 | + ->where("{$field}_min", '<=', $value[1]); |
|
| 42 | 42 | }); |
| 43 | 43 | }); |
| 44 | 44 | break; |
@@ -25,17 +25,17 @@ |
||
| 25 | 25 | $this->model = $this->model->orWhereBetween($modelTableName.'.'.$field, $value); |
| 26 | 26 | break; |
| 27 | 27 | case 'cross': |
| 28 | - $this->model = $this->model->orWhere(function (Builder $query) use ($field, $value) { |
|
| 29 | - $query->where(function (Builder $query) use ($field, $value) { |
|
| 28 | + $this->model = $this->model->orWhere(function(Builder $query) use ($field, $value) { |
|
| 29 | + $query->where(function(Builder $query) use ($field, $value) { |
|
| 30 | 30 | $query->where("{$field}_min", '<=', $value[0]) |
| 31 | 31 | ->where("{$field}_max", '>=', $value[1]); |
| 32 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 32 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 33 | 33 | $query->where("{$field}_min", '<=', $value[0]) |
| 34 | 34 | ->where("{$field}_max", '>=', $value[0]); |
| 35 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 35 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 36 | 36 | $query->where("{$field}_min", '>=', $value[0]) |
| 37 | 37 | ->where("{$field}_max", '<=', $value[1]); |
| 38 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 38 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 39 | 39 | $query->where("{$field}_min", '>=', $value[0]) |
| 40 | 40 | ->where("{$field}_max", '>=', $value[1]) |
| 41 | 41 | ->where("{$field}_min", '<=', $value[1]); |
@@ -69,7 +69,7 @@ |
||
| 69 | 69 | } |
| 70 | 70 | |
| 71 | 71 | $this->model = $this->model->leftJoin($sortTable, $keyName, '=', $sortTable.'.id') |
| 72 | - ->orderBy($sortColumn, $this->sortedBy) |
|
| 73 | - ->addSelect($table.'.*'); |
|
| 72 | + ->orderBy($sortColumn, $this->sortedBy) |
|
| 73 | + ->addSelect($table.'.*'); |
|
| 74 | 74 | } |
| 75 | 75 | } |
| 76 | 76 | \ No newline at end of file |
@@ -29,17 +29,17 @@ |
||
| 29 | 29 | $query->where(function (Builder $query) use ($field, $value) { |
| 30 | 30 | $query->where(function (Builder $query) use ($field, $value) { |
| 31 | 31 | $query->where("{$field}_min", '<=', $value[0]) |
| 32 | - ->where("{$field}_max", '>=', $value[1]); |
|
| 32 | + ->where("{$field}_max", '>=', $value[1]); |
|
| 33 | 33 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 34 | 34 | $query->where("{$field}_min", '<=', $value[0]) |
| 35 | - ->where("{$field}_max", '>=', $value[0]); |
|
| 35 | + ->where("{$field}_max", '>=', $value[0]); |
|
| 36 | 36 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 37 | 37 | $query->where("{$field}_min", '>=', $value[0]) |
| 38 | - ->where("{$field}_max", '<=', $value[1]); |
|
| 38 | + ->where("{$field}_max", '<=', $value[1]); |
|
| 39 | 39 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 40 | 40 | $query->where("{$field}_min", '>=', $value[0]) |
| 41 | - ->where("{$field}_max", '>=', $value[1]) |
|
| 42 | - ->where("{$field}_min", '<=', $value[1]); |
|
| 41 | + ->where("{$field}_max", '>=', $value[1]) |
|
| 42 | + ->where("{$field}_min", '<=', $value[1]); |
|
| 43 | 43 | }); |
| 44 | 44 | }); |
| 45 | 45 | break; |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | protected function parseSearchAndRelationClosure($value, $relation, $field, $condition) |
| 33 | 33 | { |
| 34 | 34 | $this->model = |
| 35 | - $this->model->whereHas($relation, function (Builder $query) use ($field, $condition, $value) { |
|
| 35 | + $this->model->whereHas($relation, function(Builder $query) use ($field, $condition, $value) { |
|
| 36 | 36 | switch ($condition) { |
| 37 | 37 | case 'in': |
| 38 | 38 | $query->whereIn($field, $value); |
@@ -41,17 +41,17 @@ discard block |
||
| 41 | 41 | $query->whereBetween($field, $value); |
| 42 | 42 | break; |
| 43 | 43 | case 'cross': |
| 44 | - $query->where(function (Builder $query) use ($field, $value) { |
|
| 45 | - $query->where(function (Builder $query) use ($field, $value) { |
|
| 44 | + $query->where(function(Builder $query) use ($field, $value) { |
|
| 45 | + $query->where(function(Builder $query) use ($field, $value) { |
|
| 46 | 46 | $query->where("{$field}_min", '<=', $value[0]) |
| 47 | 47 | ->where("{$field}_max", '>=', $value[1]); |
| 48 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 48 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 49 | 49 | $query->where("{$field}_min", '<=', $value[0]) |
| 50 | 50 | ->where("{$field}_max", '>=', $value[0]); |
| 51 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 51 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 52 | 52 | $query->where("{$field}_min", '>=', $value[0]) |
| 53 | 53 | ->where("{$field}_max", '<=', $value[1]); |
| 54 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 54 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 55 | 55 | $query->where("{$field}_min", '>=', $value[0]) |
| 56 | 56 | ->where("{$field}_max", '>=', $value[1]) |
| 57 | 57 | ->where("{$field}_min", '<=', $value[1]); |
@@ -28,17 +28,17 @@ |
||
| 28 | 28 | $query->where(function (Builder $query) use ($field, $value) { |
| 29 | 29 | $query->where(function (Builder $query) use ($field, $value) { |
| 30 | 30 | $query->where("{$field}_min", '<=', $value[0]) |
| 31 | - ->where("{$field}_max", '>=', $value[1]); |
|
| 31 | + ->where("{$field}_max", '>=', $value[1]); |
|
| 32 | 32 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 33 | 33 | $query->where("{$field}_min", '<=', $value[0]) |
| 34 | - ->where("{$field}_max", '>=', $value[0]); |
|
| 34 | + ->where("{$field}_max", '>=', $value[0]); |
|
| 35 | 35 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 36 | 36 | $query->where("{$field}_min", '>=', $value[0]) |
| 37 | - ->where("{$field}_max", '<=', $value[1]); |
|
| 37 | + ->where("{$field}_max", '<=', $value[1]); |
|
| 38 | 38 | })->orWhere(function (Builder $query) use ($field, $value) { |
| 39 | 39 | $query->where("{$field}_min", '>=', $value[0]) |
| 40 | - ->where("{$field}_max", '>=', $value[1]) |
|
| 41 | - ->where("{$field}_min", '<=', $value[1]); |
|
| 40 | + ->where("{$field}_max", '>=', $value[1]) |
|
| 41 | + ->where("{$field}_min", '<=', $value[1]); |
|
| 42 | 42 | }); |
| 43 | 43 | }); |
| 44 | 44 | break; |
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | |
| 32 | 32 | protected function parseSearchOrRelationClosure($value, $relation, $field, $condition) |
| 33 | 33 | { |
| 34 | - $this->model = $this->model->orWhereHas($relation, function (Builder $query) use ($field, $condition, $value) { |
|
| 34 | + $this->model = $this->model->orWhereHas($relation, function(Builder $query) use ($field, $condition, $value) { |
|
| 35 | 35 | switch ($condition) { |
| 36 | 36 | case 'in': |
| 37 | 37 | $query->whereIn($field, $value); |
@@ -40,17 +40,17 @@ discard block |
||
| 40 | 40 | $query->whereBetween($field, $value); |
| 41 | 41 | break; |
| 42 | 42 | case 'cross': |
| 43 | - $query->where(function (Builder $query) use ($field, $value) { |
|
| 44 | - $query->where(function (Builder $query) use ($field, $value) { |
|
| 43 | + $query->where(function(Builder $query) use ($field, $value) { |
|
| 44 | + $query->where(function(Builder $query) use ($field, $value) { |
|
| 45 | 45 | $query->where("{$field}_min", '<=', $value[0]) |
| 46 | 46 | ->where("{$field}_max", '>=', $value[1]); |
| 47 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 47 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 48 | 48 | $query->where("{$field}_min", '<=', $value[0]) |
| 49 | 49 | ->where("{$field}_max", '>=', $value[0]); |
| 50 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 50 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 51 | 51 | $query->where("{$field}_min", '>=', $value[0]) |
| 52 | 52 | ->where("{$field}_max", '<=', $value[1]); |
| 53 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
| 53 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
| 54 | 54 | $query->where("{$field}_min", '>=', $value[0]) |
| 55 | 55 | ->where("{$field}_max", '>=', $value[1]) |
| 56 | 56 | ->where("{$field}_min", '<=', $value[1]); |