@@ -70,12 +70,12 @@ discard block |
||
70 | 70 | $query->where('postdate', '>', now()->subDays($maxAge)); |
71 | 71 | } |
72 | 72 | |
73 | - if (! empty($excludedCats)) { |
|
73 | + if (!empty($excludedCats)) { |
|
74 | 74 | $query->whereNotIn('categories_id', $excludedCats); |
75 | 75 | } |
76 | 76 | |
77 | 77 | if ($groupName !== -1) { |
78 | - $query->whereHas('group', function ($q) use ($groupName) { |
|
78 | + $query->whereHas('group', function($q) use ($groupName) { |
|
79 | 79 | $q->where('name', $groupName); |
80 | 80 | }); |
81 | 81 | } |
@@ -241,10 +241,10 @@ discard block |
||
241 | 241 | ->where('nzbstatus', NZB::NZB_ADDED) |
242 | 242 | ->where('passwordstatus', $this->showPasswords()) |
243 | 243 | ->whereBetween('categories_id', [Category::TV_ROOT, Category::TV_OTHER]) |
244 | - ->when($maxAge > 0, function ($q) use ($maxAge) { |
|
244 | + ->when($maxAge > 0, function($q) use ($maxAge) { |
|
245 | 245 | $q->where('postdate', '>', now()->subDays($maxAge)); |
246 | 246 | }) |
247 | - ->when(! empty($excludedCats), function ($q) use ($excludedCats) { |
|
247 | + ->when(!empty($excludedCats), function($q) use ($excludedCats) { |
|
248 | 248 | $q->whereNotIn('categories_id', $excludedCats); |
249 | 249 | }) |
250 | 250 | ->whereRaw($this->uSQL($userShows, 'videos_id')) |
@@ -320,7 +320,7 @@ discard block |
||
320 | 320 | { |
321 | 321 | // Delete NZB from disk. |
322 | 322 | $nzbPath = $nzb->NZBPath($identifiers['g']); |
323 | - if (! empty($nzbPath)) { |
|
323 | + if (!empty($nzbPath)) { |
|
324 | 324 | File::delete($nzbPath); |
325 | 325 | } |
326 | 326 | |
@@ -360,7 +360,7 @@ discard block |
||
360 | 360 | */ |
361 | 361 | public function updateMulti($guids, $category, $grabs, $videoId, $episodeId, $anidbId, $imdbId) |
362 | 362 | { |
363 | - if (! \is_array($guids) || \count($guids) < 1) { |
|
363 | + if (!\is_array($guids) || \count($guids) < 1) { |
|
364 | 364 | return false; |
365 | 365 | } |
366 | 366 | |
@@ -384,7 +384,7 @@ discard block |
||
384 | 384 | $sql = '(1=2 '; |
385 | 385 | foreach ($userQuery as $query) { |
386 | 386 | $sql .= sprintf('OR (r.%s = %d', $type, $query->$type); |
387 | - if (! empty($query->categories)) { |
|
387 | + if (!empty($query->categories)) { |
|
388 | 388 | $catsArr = explode('|', $query->categories); |
389 | 389 | if (\count($catsArr) > 1) { |
390 | 390 | $sql .= sprintf(' AND r.categories_id IN (%s)', implode(',', $catsArr)); |
@@ -426,7 +426,7 @@ discard block |
||
426 | 426 | $orderBy = $this->getBrowseOrder($orderBy); |
427 | 427 | } |
428 | 428 | |
429 | - $searchFields = Arr::where($searchArr, static function ($value) { |
|
429 | + $searchFields = Arr::where($searchArr, static function($value) { |
|
430 | 430 | return $value !== -1; |
431 | 431 | }); |
432 | 432 | |
@@ -436,7 +436,7 @@ discard block |
||
436 | 436 | $searchResult = $this->elasticSearch->indexSearch($phrases, $limit); |
437 | 437 | } else { |
438 | 438 | $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', '', [], $searchFields); |
439 | - if (! empty($searchResult)) { |
|
439 | + if (!empty($searchResult)) { |
|
440 | 440 | $searchResult = Arr::wrap(Arr::get($searchResult, 'id')); |
441 | 441 | } |
442 | 442 | } |
@@ -464,12 +464,12 @@ discard block |
||
464 | 464 | $query->where('postdate', '>', now()->subDays($maxAge)); |
465 | 465 | } |
466 | 466 | |
467 | - if (! empty($excludedCats)) { |
|
467 | + if (!empty($excludedCats)) { |
|
468 | 468 | $query->whereNotIn('categories_id', $excludedCats); |
469 | 469 | } |
470 | 470 | |
471 | 471 | if ((int) $groupName !== -1) { |
472 | - $query->whereHas('group', function ($q) use ($groupName) { |
|
472 | + $query->whereHas('group', function($q) use ($groupName) { |
|
473 | 473 | $q->where('name', $groupName); |
474 | 474 | }); |
475 | 475 | } |
@@ -534,7 +534,7 @@ discard block |
||
534 | 534 | $searchResult = $this->elasticSearch->indexSearchApi($searchName, $limit); |
535 | 535 | } else { |
536 | 536 | $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $searchName, ['searchname']); |
537 | - if (! empty($searchResult)) { |
|
537 | + if (!empty($searchResult)) { |
|
538 | 538 | $searchResult = Arr::wrap(Arr::get($searchResult, 'id')); |
539 | 539 | } |
540 | 540 | } |
@@ -549,12 +549,12 @@ discard block |
||
549 | 549 | $query->where('postdate', '>', now()->subDays($maxAge)); |
550 | 550 | } |
551 | 551 | |
552 | - if (! empty($excludedCats)) { |
|
552 | + if (!empty($excludedCats)) { |
|
553 | 553 | $query->whereNotIn('categories_id', $excludedCats); |
554 | 554 | } |
555 | 555 | |
556 | 556 | if ((int) $groupName !== -1) { |
557 | - $query->whereHas('group', function ($q) use ($groupName) { |
|
557 | + $query->whereHas('group', function($q) use ($groupName) { |
|
558 | 558 | $q->where('name', $groupName); |
559 | 559 | }); |
560 | 560 | } |
@@ -626,11 +626,11 @@ discard block |
||
626 | 626 | $show = self::fromQuery($showQry); |
627 | 627 | |
628 | 628 | if ($show->isNotEmpty()) { |
629 | - if ((! empty($episode) && ! empty($series)) && $show[0]->episodes !== '') { |
|
629 | + if ((!empty($episode) && !empty($series)) && $show[0]->episodes !== '') { |
|
630 | 630 | $showSql .= ' AND r.tv_episodes_id IN ('.$show[0]->episodes.') AND tve.series = '.$series; |
631 | - } elseif (! empty($episode) && $show[0]->episodes !== '') { |
|
631 | + } elseif (!empty($episode) && $show[0]->episodes !== '') { |
|
632 | 632 | $showSql = sprintf('AND r.tv_episodes_id IN (%s)', $show[0]->episodes); |
633 | - } elseif (! empty($series) && empty($episode)) { |
|
633 | + } elseif (!empty($series) && empty($episode)) { |
|
634 | 634 | // If $series is set but episode is not, return Season Packs and Episodes |
635 | 635 | $showSql .= ' AND r.tv_episodes_id IN ('.$show[0]->episodes.') AND tve.series = '.$series; |
636 | 636 | } |
@@ -644,26 +644,26 @@ discard block |
||
644 | 644 | } |
645 | 645 | |
646 | 646 | // If $name is set it is a fallback search, add available SxxExx/airdate info to the query |
647 | - if (! empty($name) && $showSql === '') { |
|
648 | - if (! empty($series) && (int) $series < 1900) { |
|
647 | + if (!empty($name) && $showSql === '') { |
|
648 | + if (!empty($series) && (int) $series < 1900) { |
|
649 | 649 | $name .= sprintf(' S%s', str_pad($series, 2, '0', STR_PAD_LEFT)); |
650 | - if (! empty($episode) && ! str_contains($episode, '/')) { |
|
650 | + if (!empty($episode) && !str_contains($episode, '/')) { |
|
651 | 651 | $name .= sprintf('E%s', str_pad($episode, 2, '0', STR_PAD_LEFT)); |
652 | 652 | } |
653 | 653 | // If season is not empty but episode is, add a wildcard to the search |
654 | 654 | if (empty($episode)) { |
655 | 655 | $name .= '*'; |
656 | 656 | } |
657 | - } elseif (! empty($airDate)) { |
|
657 | + } elseif (!empty($airDate)) { |
|
658 | 658 | $name .= sprintf(' %s', str_replace(['/', '-', '.', '_'], ' ', $airDate)); |
659 | 659 | } |
660 | 660 | } |
661 | - if (! empty($name)) { |
|
661 | + if (!empty($name)) { |
|
662 | 662 | if (config('nntmux.elasticsearch_enabled') === true) { |
663 | 663 | $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit); |
664 | 664 | } else { |
665 | 665 | $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']); |
666 | - if (! empty($searchResult)) { |
|
666 | + if (!empty($searchResult)) { |
|
667 | 667 | $searchResult = Arr::wrap(Arr::get($searchResult, 'id')); |
668 | 668 | } |
669 | 669 | } |
@@ -679,11 +679,11 @@ discard block |
||
679 | 679 | NZB::NZB_ADDED, |
680 | 680 | $this->showPasswords(), |
681 | 681 | $showSql, |
682 | - (! empty($name) && ! empty($searchResult)) ? 'AND r.id IN ('.implode(',', $searchResult).')' : '', |
|
682 | + (!empty($name) && !empty($searchResult)) ? 'AND r.id IN ('.implode(',', $searchResult).')' : '', |
|
683 | 683 | Category::getCategorySearch($cat, 'tv'), |
684 | 684 | $maxAge > 0 ? sprintf('AND r.postdate > NOW() - INTERVAL %d DAY', $maxAge) : '', |
685 | 685 | $minSize > 0 ? sprintf('AND r.size >= %d', $minSize) : '', |
686 | - ! empty($excludedCategories) ? sprintf('AND r.categories_id NOT IN('.implode(',', $excludedCategories).')') : '' |
|
686 | + !empty($excludedCategories) ? sprintf('AND r.categories_id NOT IN('.implode(',', $excludedCategories).')') : '' |
|
687 | 687 | ); |
688 | 688 | $baseSql = sprintf( |
689 | 689 | "SELECT r.searchname, r.guid, r.postdate, r.groups_id, r.categories_id, r.size, r.totalpart, r.fromname, r.passwordstatus, r.grabs, r.comments, r.adddate, r.videos_id, r.tv_episodes_id, r.haspreview, r.jpgstatus, |
@@ -720,7 +720,7 @@ discard block |
||
720 | 720 | if ($releases !== null) { |
721 | 721 | return $releases; |
722 | 722 | } |
723 | - $releases = ((! empty($name) && ! empty($searchResult)) || empty($name)) ? self::fromQuery($sql) : []; |
|
723 | + $releases = ((!empty($name) && !empty($searchResult)) || empty($name)) ? self::fromQuery($sql) : []; |
|
724 | 724 | if (count($releases) !== 0 && $releases->isNotEmpty()) { |
725 | 725 | $releases[0]->_totalrows = $this->getPagerCount( |
726 | 726 | preg_replace('#LEFT(\s+OUTER)?\s+JOIN\s+(?!tv_episodes)\s+.*ON.*=.*\n#i', ' ', $baseSql) |
@@ -746,24 +746,24 @@ discard block |
||
746 | 746 | ->whereIn('categories_id', Category::getCategorySearch($cat, 'tv', true)); |
747 | 747 | |
748 | 748 | // Check if siteIdArr contains id key |
749 | - if (! empty($siteIdArr) && array_key_exists('id', $siteIdArr)) { |
|
749 | + if (!empty($siteIdArr) && array_key_exists('id', $siteIdArr)) { |
|
750 | 750 | $query->where('videos_id', $siteIdArr['id']); |
751 | 751 | } |
752 | - if (! empty(array_filter($siteIdArr))) { |
|
753 | - $query->whereHas('video', function ($q) use ($siteIdArr, $series, $episode, $airDate) { |
|
752 | + if (!empty(array_filter($siteIdArr))) { |
|
753 | + $query->whereHas('video', function($q) use ($siteIdArr, $series, $episode, $airDate) { |
|
754 | 754 | foreach ($siteIdArr as $column => $id) { |
755 | 755 | if ($id > 0 && $column !== 'id') { |
756 | 756 | $q->orWhere($column, $id); |
757 | 757 | } |
758 | 758 | |
759 | 759 | } |
760 | - if (! empty($series)) { |
|
761 | - $q->whereHas('episode', function ($q) use ($series, $episode, $airDate) { |
|
760 | + if (!empty($series)) { |
|
761 | + $q->whereHas('episode', function($q) use ($series, $episode, $airDate) { |
|
762 | 762 | $q->where('series', (int) preg_replace('/^s0*/i', '', $series)); |
763 | - if (! empty($episode)) { |
|
763 | + if (!empty($episode)) { |
|
764 | 764 | $q->where('episode', (int) preg_replace('/^e0*/i', '', $episode)); |
765 | 765 | } |
766 | - if (! empty($airDate)) { |
|
766 | + if (!empty($airDate)) { |
|
767 | 767 | $q->whereDate('firstaired', $airDate); |
768 | 768 | } |
769 | 769 | }); |
@@ -771,18 +771,18 @@ discard block |
||
771 | 771 | }); |
772 | 772 | } |
773 | 773 | |
774 | - if (! empty($name)) { |
|
774 | + if (!empty($name)) { |
|
775 | 775 | // If $name is set it is a fallback search, add available SxxExx/airdate info to the query |
776 | - if (! empty($series) && (int) $series < 1900) { |
|
776 | + if (!empty($series) && (int) $series < 1900) { |
|
777 | 777 | $name .= sprintf(' S%s', str_pad($series, 2, '0', STR_PAD_LEFT)); |
778 | - if (! empty($episode) && ! str_contains($episode, '/')) { |
|
778 | + if (!empty($episode) && !str_contains($episode, '/')) { |
|
779 | 779 | $name .= sprintf('E%s', str_pad($episode, 2, '0', STR_PAD_LEFT)); |
780 | 780 | } |
781 | 781 | // If season is not empty but episode is, add a wildcard to the search |
782 | 782 | if (empty($episode)) { |
783 | 783 | $name .= '*'; |
784 | 784 | } |
785 | - } elseif (! empty($airDate)) { |
|
785 | + } elseif (!empty($airDate)) { |
|
786 | 786 | $name .= sprintf(' %s', str_replace(['/', '-', '.', '_'], ' ', $airDate)); |
787 | 787 | } |
788 | 788 | |
@@ -790,7 +790,7 @@ discard block |
||
790 | 790 | $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit); |
791 | 791 | } else { |
792 | 792 | $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']); |
793 | - if (! empty($searchResult)) { |
|
793 | + if (!empty($searchResult)) { |
|
794 | 794 | $searchResult = Arr::wrap(Arr::get($searchResult, 'id')); |
795 | 795 | } |
796 | 796 | } |
@@ -806,7 +806,7 @@ discard block |
||
806 | 806 | $query->where('postdate', '>', now()->subDays($maxAge)); |
807 | 807 | } |
808 | 808 | |
809 | - if (! empty($excludedCategories)) { |
|
809 | + if (!empty($excludedCategories)) { |
|
810 | 810 | $query->whereNotIn('categories_id', $excludedCategories); |
811 | 811 | } |
812 | 812 | |
@@ -851,19 +851,19 @@ discard block |
||
851 | 851 | $cacheKey = md5(json_encode(func_get_args())); |
852 | 852 | $cacheTTL = now()->addMinutes(config('nntmux.cache_expiry_medium')); |
853 | 853 | |
854 | - return Cache::remember($cacheKey, $cacheTTL, function () use ($imDbId, $tmDbId, $traktId, $offset, $limit, $name, $cat, $maxAge, $minSize, $excludedCategories) { |
|
854 | + return Cache::remember($cacheKey, $cacheTTL, function() use ($imDbId, $tmDbId, $traktId, $offset, $limit, $name, $cat, $maxAge, $minSize, $excludedCategories) { |
|
855 | 855 | $query = self::query() |
856 | 856 | ->with(['movieinfo', 'group', 'category', 'category.parent', 'nfo']) |
857 | 857 | ->whereBetween('categories_id', [Category::MOVIE_ROOT, Category::MOVIE_OTHER]) |
858 | 858 | ->where('nzbstatus', NZB::NZB_ADDED) |
859 | 859 | ->where('passwordstatus', $this->showPasswords()); |
860 | 860 | |
861 | - if (! empty($name)) { |
|
861 | + if (!empty($name)) { |
|
862 | 862 | if (config('nntmux.elasticsearch_enabled') === true) { |
863 | 863 | $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit); |
864 | 864 | } else { |
865 | 865 | $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']); |
866 | - if (! empty($searchResult)) { |
|
866 | + if (!empty($searchResult)) { |
|
867 | 867 | $searchResult = Arr::wrap(Arr::get($searchResult, 'id')); |
868 | 868 | } |
869 | 869 | } |
@@ -876,24 +876,24 @@ discard block |
||
876 | 876 | } |
877 | 877 | |
878 | 878 | if ($imDbId !== -1 && is_numeric($imDbId)) { |
879 | - $query->whereHas('movieinfo', function ($q) use ($imDbId) { |
|
879 | + $query->whereHas('movieinfo', function($q) use ($imDbId) { |
|
880 | 880 | $q->where('imdbid', $imDbId); |
881 | 881 | }); |
882 | 882 | } |
883 | 883 | |
884 | 884 | if ($tmDbId !== -1 && is_numeric($tmDbId)) { |
885 | - $query->whereHas('movieinfo', function ($q) use ($tmDbId) { |
|
885 | + $query->whereHas('movieinfo', function($q) use ($tmDbId) { |
|
886 | 886 | $q->where('tmdbid', $tmDbId); |
887 | 887 | }); |
888 | 888 | } |
889 | 889 | |
890 | 890 | if ($traktId !== -1 && is_numeric($traktId)) { |
891 | - $query->whereHas('movieinfo', function ($q) use ($traktId) { |
|
891 | + $query->whereHas('movieinfo', function($q) use ($traktId) { |
|
892 | 892 | $q->where('traktid', $traktId); |
893 | 893 | }); |
894 | 894 | } |
895 | 895 | |
896 | - if (! empty($excludedCategories)) { |
|
896 | + if (!empty($excludedCategories)) { |
|
897 | 897 | $query->whereNotIn('categories_id', $excludedCategories); |
898 | 898 | } |
899 | 899 | |
@@ -938,7 +938,7 @@ discard block |
||
938 | 938 | } |
939 | 939 | |
940 | 940 | $results = $this->search(['searchname' => getSimilarName($name)], -1, '', '', -1, -1, 0, config('nntmux.items_per_page'), '', -1, $excludedCats, 'basic', [$parentCat]); |
941 | - if (! $results) { |
|
941 | + if (!$results) { |
|
942 | 942 | return $ret; |
943 | 943 | } |
944 | 944 |