@@ -166,8 +166,8 @@ discard block |
||
166 | 166 | } |
167 | 167 | |
168 | 168 | $this->model = $this->model->leftJoin($sortTable, $keyName, '=', $sortTable.'.id') |
169 | - ->orderBy($sortColumn, $this->sortedBy) |
|
170 | - ->addSelect($table.'.*'); |
|
169 | + ->orderBy($sortColumn, $this->sortedBy) |
|
170 | + ->addSelect($table.'.*'); |
|
171 | 171 | } else { |
172 | 172 | $this->model = $this->model->orderBy($this->orderBy, $this->sortedBy); |
173 | 173 | } |
@@ -274,17 +274,17 @@ discard block |
||
274 | 274 | $query->where(function (Builder $query) use ($field, $value) { |
275 | 275 | $query->where(function (Builder $query) use ($field, $value) { |
276 | 276 | $query->where("{$field}_min", '<=', $value[0]) |
277 | - ->where("{$field}_max", '>=', $value[1]); |
|
277 | + ->where("{$field}_max", '>=', $value[1]); |
|
278 | 278 | })->orWhere(function (Builder $query) use ($field, $value) { |
279 | 279 | $query->where("{$field}_min", '<=', $value[0]) |
280 | - ->where("{$field}_max", '>=', $value[0]); |
|
280 | + ->where("{$field}_max", '>=', $value[0]); |
|
281 | 281 | })->orWhere(function (Builder $query) use ($field, $value) { |
282 | 282 | $query->where("{$field}_min", '>=', $value[0]) |
283 | - ->where("{$field}_max", '<=', $value[1]); |
|
283 | + ->where("{$field}_max", '<=', $value[1]); |
|
284 | 284 | })->orWhere(function (Builder $query) use ($field, $value) { |
285 | 285 | $query->where("{$field}_min", '>=', $value[0]) |
286 | - ->where("{$field}_max", '>=', $value[1]) |
|
287 | - ->where("{$field}_min", '<=', $value[1]); |
|
286 | + ->where("{$field}_max", '>=', $value[1]) |
|
287 | + ->where("{$field}_min", '<=', $value[1]); |
|
288 | 288 | }); |
289 | 289 | }); |
290 | 290 | break; |
@@ -304,17 +304,17 @@ discard block |
||
304 | 304 | $this->model = $this->model->where(function (Builder $query) use ($field, $value) { |
305 | 305 | $query->where(function (Builder $query) use ($field, $value) { |
306 | 306 | $query->where("{$field}_min", '<=', $value[0]) |
307 | - ->where("{$field}_max", '>=', $value[1]); |
|
307 | + ->where("{$field}_max", '>=', $value[1]); |
|
308 | 308 | })->orWhere(function (Builder $query) use ($field, $value) { |
309 | 309 | $query->where("{$field}_min", '<=', $value[0]) |
310 | - ->where("{$field}_max", '>=', $value[0]); |
|
310 | + ->where("{$field}_max", '>=', $value[0]); |
|
311 | 311 | })->orWhere(function (Builder $query) use ($field, $value) { |
312 | 312 | $query->where("{$field}_min", '>=', $value[0]) |
313 | - ->where("{$field}_max", '<=', $value[1]); |
|
313 | + ->where("{$field}_max", '<=', $value[1]); |
|
314 | 314 | })->orWhere(function (Builder $query) use ($field, $value) { |
315 | 315 | $query->where("{$field}_min", '>=', $value[0]) |
316 | - ->where("{$field}_max", '>=', $value[1]) |
|
317 | - ->where("{$field}_min", '<=', $value[1]); |
|
316 | + ->where("{$field}_max", '>=', $value[1]) |
|
317 | + ->where("{$field}_min", '<=', $value[1]); |
|
318 | 318 | }); |
319 | 319 | }); |
320 | 320 | break; |
@@ -344,17 +344,17 @@ discard block |
||
344 | 344 | $query->where(function (Builder $query) use ($field, $value) { |
345 | 345 | $query->where(function (Builder $query) use ($field, $value) { |
346 | 346 | $query->where("{$field}_min", '<=', $value[0]) |
347 | - ->where("{$field}_max", '>=', $value[1]); |
|
347 | + ->where("{$field}_max", '>=', $value[1]); |
|
348 | 348 | })->orWhere(function (Builder $query) use ($field, $value) { |
349 | 349 | $query->where("{$field}_min", '<=', $value[0]) |
350 | - ->where("{$field}_max", '>=', $value[0]); |
|
350 | + ->where("{$field}_max", '>=', $value[0]); |
|
351 | 351 | })->orWhere(function (Builder $query) use ($field, $value) { |
352 | 352 | $query->where("{$field}_min", '>=', $value[0]) |
353 | - ->where("{$field}_max", '<=', $value[1]); |
|
353 | + ->where("{$field}_max", '<=', $value[1]); |
|
354 | 354 | })->orWhere(function (Builder $query) use ($field, $value) { |
355 | 355 | $query->where("{$field}_min", '>=', $value[0]) |
356 | - ->where("{$field}_max", '>=', $value[1]) |
|
357 | - ->where("{$field}_min", '<=', $value[1]); |
|
356 | + ->where("{$field}_max", '>=', $value[1]) |
|
357 | + ->where("{$field}_min", '<=', $value[1]); |
|
358 | 358 | }); |
359 | 359 | }); |
360 | 360 | } else { |
@@ -370,17 +370,17 @@ discard block |
||
370 | 370 | $this->model = $this->model->orWhere(function (Builder $query) use ($field, $value) { |
371 | 371 | $query->where(function (Builder $query) use ($field, $value) { |
372 | 372 | $query->where("{$field}_min", '<=', $value[0]) |
373 | - ->where("{$field}_max", '>=', $value[1]); |
|
373 | + ->where("{$field}_max", '>=', $value[1]); |
|
374 | 374 | })->orWhere(function (Builder $query) use ($field, $value) { |
375 | 375 | $query->where("{$field}_min", '<=', $value[0]) |
376 | - ->where("{$field}_max", '>=', $value[0]); |
|
376 | + ->where("{$field}_max", '>=', $value[0]); |
|
377 | 377 | })->orWhere(function (Builder $query) use ($field, $value) { |
378 | 378 | $query->where("{$field}_min", '>=', $value[0]) |
379 | - ->where("{$field}_max", '<=', $value[1]); |
|
379 | + ->where("{$field}_max", '<=', $value[1]); |
|
380 | 380 | })->orWhere(function (Builder $query) use ($field, $value) { |
381 | 381 | $query->where("{$field}_min", '>=', $value[0]) |
382 | - ->where("{$field}_max", '>=', $value[1]) |
|
383 | - ->where("{$field}_min", '<=', $value[1]); |
|
382 | + ->where("{$field}_max", '>=', $value[1]) |
|
383 | + ->where("{$field}_min", '<=', $value[1]); |
|
384 | 384 | }); |
385 | 385 | }); |
386 | 386 | } else { |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | if (!is_null($value)) { |
263 | 263 | if (!is_null($relation)) { |
264 | 264 | $this->model = |
265 | - $this->model->whereHas($relation, function (Builder $query) use ($field, $condition, $value) { |
|
265 | + $this->model->whereHas($relation, function(Builder $query) use ($field, $condition, $value) { |
|
266 | 266 | switch ($condition) { |
267 | 267 | case 'in': |
268 | 268 | $query->whereIn($field, $value); |
@@ -271,17 +271,17 @@ discard block |
||
271 | 271 | $query->whereBetween($field, $value); |
272 | 272 | break; |
273 | 273 | case 'cross': |
274 | - $query->where(function (Builder $query) use ($field, $value) { |
|
275 | - $query->where(function (Builder $query) use ($field, $value) { |
|
274 | + $query->where(function(Builder $query) use ($field, $value) { |
|
275 | + $query->where(function(Builder $query) use ($field, $value) { |
|
276 | 276 | $query->where("{$field}_min", '<=', $value[0]) |
277 | 277 | ->where("{$field}_max", '>=', $value[1]); |
278 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
278 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
279 | 279 | $query->where("{$field}_min", '<=', $value[0]) |
280 | 280 | ->where("{$field}_max", '>=', $value[0]); |
281 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
281 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
282 | 282 | $query->where("{$field}_min", '>=', $value[0]) |
283 | 283 | ->where("{$field}_max", '<=', $value[1]); |
284 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
284 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
285 | 285 | $query->where("{$field}_min", '>=', $value[0]) |
286 | 286 | ->where("{$field}_max", '>=', $value[1]) |
287 | 287 | ->where("{$field}_min", '<=', $value[1]); |
@@ -301,17 +301,17 @@ discard block |
||
301 | 301 | $this->model = $this->model->whereBetween($field, $value); |
302 | 302 | break; |
303 | 303 | case 'cross': |
304 | - $this->model = $this->model->where(function (Builder $query) use ($field, $value) { |
|
305 | - $query->where(function (Builder $query) use ($field, $value) { |
|
304 | + $this->model = $this->model->where(function(Builder $query) use ($field, $value) { |
|
305 | + $query->where(function(Builder $query) use ($field, $value) { |
|
306 | 306 | $query->where("{$field}_min", '<=', $value[0]) |
307 | 307 | ->where("{$field}_max", '>=', $value[1]); |
308 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
308 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
309 | 309 | $query->where("{$field}_min", '<=', $value[0]) |
310 | 310 | ->where("{$field}_max", '>=', $value[0]); |
311 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
311 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
312 | 312 | $query->where("{$field}_min", '>=', $value[0]) |
313 | 313 | ->where("{$field}_max", '<=', $value[1]); |
314 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
314 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
315 | 315 | $query->where("{$field}_min", '>=', $value[0]) |
316 | 316 | ->where("{$field}_max", '>=', $value[1]) |
317 | 317 | ->where("{$field}_min", '<=', $value[1]); |
@@ -331,7 +331,7 @@ discard block |
||
331 | 331 | $modelTableName = $this->model->getModel()->getTable(); |
332 | 332 | if (!is_null($value)) { |
333 | 333 | if (!is_null($relation)) { |
334 | - $this->model = $this->model->orWhereHas($relation, function (Builder $query) use ( |
|
334 | + $this->model = $this->model->orWhereHas($relation, function(Builder $query) use ( |
|
335 | 335 | $field, |
336 | 336 | $condition, |
337 | 337 | $value |
@@ -341,17 +341,17 @@ discard block |
||
341 | 341 | } elseif ($condition == 'between') { |
342 | 342 | $query->whereBetween($field, $value); |
343 | 343 | } elseif ($condition == 'cross') { |
344 | - $query->where(function (Builder $query) use ($field, $value) { |
|
345 | - $query->where(function (Builder $query) use ($field, $value) { |
|
344 | + $query->where(function(Builder $query) use ($field, $value) { |
|
345 | + $query->where(function(Builder $query) use ($field, $value) { |
|
346 | 346 | $query->where("{$field}_min", '<=', $value[0]) |
347 | 347 | ->where("{$field}_max", '>=', $value[1]); |
348 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
348 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
349 | 349 | $query->where("{$field}_min", '<=', $value[0]) |
350 | 350 | ->where("{$field}_max", '>=', $value[0]); |
351 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
351 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
352 | 352 | $query->where("{$field}_min", '>=', $value[0]) |
353 | 353 | ->where("{$field}_max", '<=', $value[1]); |
354 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
354 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
355 | 355 | $query->where("{$field}_min", '>=', $value[0]) |
356 | 356 | ->where("{$field}_max", '>=', $value[1]) |
357 | 357 | ->where("{$field}_min", '<=', $value[1]); |
@@ -367,17 +367,17 @@ discard block |
||
367 | 367 | } elseif ($condition == 'between') { |
368 | 368 | $this->model = $this->model->orWhereBetween($modelTableName.'.'.$field, $value); |
369 | 369 | } elseif ($condition == 'cross') { |
370 | - $this->model = $this->model->orWhere(function (Builder $query) use ($field, $value) { |
|
371 | - $query->where(function (Builder $query) use ($field, $value) { |
|
370 | + $this->model = $this->model->orWhere(function(Builder $query) use ($field, $value) { |
|
371 | + $query->where(function(Builder $query) use ($field, $value) { |
|
372 | 372 | $query->where("{$field}_min", '<=', $value[0]) |
373 | 373 | ->where("{$field}_max", '>=', $value[1]); |
374 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
374 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
375 | 375 | $query->where("{$field}_min", '<=', $value[0]) |
376 | 376 | ->where("{$field}_max", '>=', $value[0]); |
377 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
377 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
378 | 378 | $query->where("{$field}_min", '>=', $value[0]) |
379 | 379 | ->where("{$field}_max", '<=', $value[1]); |
380 | - })->orWhere(function (Builder $query) use ($field, $value) { |
|
380 | + })->orWhere(function(Builder $query) use ($field, $value) { |
|
381 | 381 | $query->where("{$field}_min", '>=', $value[0]) |
382 | 382 | ->where("{$field}_max", '>=', $value[1]) |
383 | 383 | ->where("{$field}_min", '<=', $value[1]); |