NNTmux / newznab-tmux

app/Services/Releases/ReleaseSearchService.php

Spacing +50 added lines, -50 removed lines

@@ -70,7 +70,7 @@ 
             $maxAge, $excludedCats, $type, $cat, $minSize
         );
 
-        $whereSql = 'WHERE ' . implode(' AND ', $conditions);
+        $whereSql = 'WHERE '.implode(' AND ', $conditions);
         $orderBy = $this->getBrowseOrder($orderBy === '' ? 'posted_desc' : $orderBy);
 
         // Optimized query: direct query without subquery wrapper, filter on releases first using indexed columns
@@ -102,7 +102,7 @@ 
         );
 
         // Check cache
-        $cacheKey = md5($this->getCacheVersion() . $sql);
+        $cacheKey = md5($this->getCacheVersion().$sql);
         $releases = Cache::get($cacheKey);
         if ($releases !== null) {
             return $releases;
@@ -156,10 +156,10 @@ 
 
         // Size range conditions - uses indexed size column
         if (isset($sizeRange[$sizeFrom])) {
-            $conditions[] = sprintf('r.size > %d', (int)($sizeBase * $sizeRange[$sizeFrom]));
+            $conditions[] = sprintf('r.size > %d', (int) ($sizeBase * $sizeRange[$sizeFrom]));
         }
         if (isset($sizeRange[$sizeTo])) {
-            $conditions[] = sprintf('r.size < %d', (int)($sizeBase * $sizeRange[$sizeTo]));
+            $conditions[] = sprintf('r.size < %d', (int) ($sizeBase * $sizeRange[$sizeTo]));
         }
         if ($minSize > 0) {
             $conditions[] = sprintf('r.size >= %d', $minSize);
@@ -198,8 +198,8 @@ 
     private function getOptimizedCount(array $conditions): int
     {
         $maxResults = (int) config('nntmux.max_pager_results');
-        $whereSql = 'WHERE ' . implode(' AND ', $conditions);
-        $cacheKey = 'count_' . md5($whereSql);
+        $whereSql = 'WHERE '.implode(' AND ', $conditions);
+        $cacheKey = 'count_'.md5($whereSql);
 
         $count = Cache::get($cacheKey);
         if ($count !== null) {
@@ -257,7 +257,7 @@ 
                         'result' => $searchResult,
                     ]);
                 }
-                if (! empty($searchResult)) {
+                if (!empty($searchResult)) {
                     $searchResult = Arr::wrap(Arr::get($searchResult, 'id'));
                 }
             }
@@ -295,15 +295,15 @@ 
 
         $catQuery = Category::getCategorySearch($cat);
         $catQuery = preg_replace('/^(WHERE|AND)\s+/i', '', trim($catQuery));
-        if (! empty($catQuery) && $catQuery !== '1=1') {
+        if (!empty($catQuery) && $catQuery !== '1=1') {
             $conditions[] = $catQuery;
         }
 
-        if (! empty($excludedCats)) {
+        if (!empty($excludedCats)) {
             $conditions[] = sprintf('r.categories_id NOT IN (%s)', implode(',', array_map('intval', $excludedCats)));
         }
 
-        if (! empty($searchResult)) {
+        if (!empty($searchResult)) {
             $conditions[] = sprintf('r.id IN (%s)', implode(',', array_map('intval', $searchResult)));
         }
 
@@ -364,7 +364,7 @@ 
      */
     public function tvSearch(array $siteIdArr = [], string $series = '', string $episode = '', string $airDate = '', int $offset = 0, int $limit = 100, string $name = '', array $cat = [-1], int $maxAge = -1, int $minSize = 0, array $excludedCategories = []): mixed
     {
-        $shouldCache = ! (isset($siteIdArr['id']) && (int) $siteIdArr['id'] > 0);
+        $shouldCache = !(isset($siteIdArr['id']) && (int) $siteIdArr['id'] > 0);
         $rawCacheKey = md5(serialize(func_get_args()).'tvSearch');
         $cacheKey = null;
         if ($shouldCache) {
@@ -383,7 +383,7 @@ 
         $episodeJoinCondition = '';
         $needsEpisodeJoin = false;
 
-        if (! empty($siteIdArr)) {
+        if (!empty($siteIdArr)) {
             $siteConditions = [];
             foreach ($siteIdArr as $column => $id) {
                 if ($id > 0) {
@@ -391,7 +391,7 @@ 
                 }
             }
 
-            if (! empty($siteConditions)) {
+            if (!empty($siteConditions)) {
                 $siteUsesVideoIdOnly = count($siteConditions) === 1 && isset($siteIdArr['id']) && (int) $siteIdArr['id'] > 0;
 
                 $seriesFilter = ($series !== '') ? sprintf('AND tve.series = %d', (int) preg_replace('/^s0*/i', '', $series)) : '';
@@ -415,12 +415,12 @@ 
                 $videoIds = $results->pluck('video_id')->filter()->unique()->toArray();
                 $episodeIds = $results->pluck('episode_id')->filter()->unique()->toArray();
 
-                if (! empty($videoIds)) {
+                if (!empty($videoIds)) {
                     $conditions[] = sprintf('r.videos_id IN (%s)', implode(',', array_map('intval', $videoIds)));
                     $videoJoinCondition = sprintf('AND v.id IN (%s)', implode(',', array_map('intval', $videoIds)));
                 }
 
-                if (! empty($episodeIds) && ! $siteUsesVideoIdOnly) {
+                if (!empty($episodeIds) && !$siteUsesVideoIdOnly) {
                     $conditions[] = sprintf('r.tv_episodes_id IN (%s)', implode(',', array_map('intval', $episodeIds)));
                     $episodeJoinCondition = sprintf('AND tve.id IN (%s)', implode(',', array_map('intval', $episodeIds)));
                     $needsEpisodeJoin = true;
@@ -433,7 +433,7 @@ 
         }
 
         $searchResult = [];
-        if (! empty($name)) {
+        if (!empty($name)) {
             $searchName = $name;
             $hasValidSiteIds = false;
             foreach ($siteIdArr as $column => $id) {
@@ -443,18 +443,18 @@ 
                 }
             }
 
-            if (! $hasValidSiteIds) {
-                if (! empty($series) && (int) $series < 1900) {
+            if (!$hasValidSiteIds) {
+                if (!empty($series) && (int) $series < 1900) {
                     $searchName .= sprintf(' S%s', str_pad($series, 2, '0', STR_PAD_LEFT));
                     $seriesNum = (int) preg_replace('/^s0*/i', '', $series);
                     $conditions[] = sprintf('tve.series = %d', $seriesNum);
                     $needsEpisodeJoin = true;
-                    if (! empty($episode) && ! str_contains($episode, '/')) {
+                    if (!empty($episode) && !str_contains($episode, '/')) {
                         $searchName .= sprintf('E%s', str_pad($episode, 2, '0', STR_PAD_LEFT));
                         $episodeNum = (int) preg_replace('/^e0*/i', '', $episode);
                         $conditions[] = sprintf('tve.episode = %d', $episodeNum);
                     }
-                } elseif (! empty($airDate)) {
+                } elseif (!empty($airDate)) {
                     $searchName .= ' '.str_replace(['/', '-', '.', '_'], ' ', $airDate);
                     $conditions[] = sprintf('DATE(tve.firstaired) = %s', escapeString($airDate));
                     $needsEpisodeJoin = true;
@@ -469,7 +469,7 @@ 
             // Fall back to Manticore if Elasticsearch didn't return results
             if (empty($searchResult)) {
                 $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $searchName, ['searchname']);
-                if (! empty($searchResult)) {
+                if (!empty($searchResult)) {
                     $searchResult = Arr::wrap(Arr::get($searchResult, 'id'));
                 }
             }
@@ -488,7 +488,7 @@ 
 
         $catQuery = Category::getCategorySearch($cat, 'tv');
         $catQuery = preg_replace('/^(WHERE|AND)\s+/i', '', trim($catQuery));
-        if (! empty($catQuery) && $catQuery !== '1=1') {
+        if (!empty($catQuery) && $catQuery !== '1=1') {
             $conditions[] = $catQuery;
         }
 
@@ -498,7 +498,7 @@ 
         if ($minSize > 0) {
             $conditions[] = sprintf('r.size >= %d', $minSize);
         }
-        if (! empty($excludedCategories)) {
+        if (!empty($excludedCategories)) {
             $conditions[] = sprintf('r.categories_id NOT IN (%s)', implode(',', array_map('intval', $excludedCategories)));
         }
 
@@ -540,7 +540,7 @@ 
         if ($releases->isNotEmpty()) {
             $countSql = sprintf(
                 'SELECT COUNT(*) as count FROM releases r %s %s %s',
-                (! empty($videoJoinCondition) ? 'LEFT JOIN videos v ON r.videos_id = v.id AND v.type = 0' : ''),
+                (!empty($videoJoinCondition) ? 'LEFT JOIN videos v ON r.videos_id = v.id AND v.type = 0' : ''),
                 ($needsEpisodeJoin ? sprintf('%s JOIN tv_episodes tve ON r.tv_episodes_id = tve.id %s', $joinType, $episodeJoinCondition) : ''),
                 $whereSql
             );
@@ -581,11 +581,11 @@ 
             );
             $show = Release::fromQuery($showQry);
             if ($show->isNotEmpty()) {
-                if ((! empty($episode) && ! empty($series)) && $show[0]->episodes !== '') {
+                if ((!empty($episode) && !empty($series)) && $show[0]->episodes !== '') {
                     $showSql .= ' AND r.tv_episodes_id IN ('.$show[0]->episodes.') AND tve.series = '.$series;
-                } elseif (! empty($episode) && $show[0]->episodes !== '') {
+                } elseif (!empty($episode) && $show[0]->episodes !== '') {
                     $showSql = sprintf('AND r.tv_episodes_id IN (%s)', $show[0]->episodes);
-                } elseif (! empty($series) && empty($episode)) {
+                } elseif (!empty($series) && empty($episode)) {
                     $showSql .= ' AND r.tv_episodes_id IN ('.$show[0]->episodes.') AND tve.series = '.$series;
                 }
                 if ($show[0]->video > 0) {
@@ -595,21 +595,21 @@ 
                 return [];
             }
         }
-        if (! empty($name) && $showSql === '') {
-            if (! empty($series) && (int) $series < 1900) {
+        if (!empty($name) && $showSql === '') {
+            if (!empty($series) && (int) $series < 1900) {
                 $name .= sprintf(' S%s', str_pad($series, 2, '0', STR_PAD_LEFT));
-                if (! empty($episode) && ! str_contains($episode, '/')) {
+                if (!empty($episode) && !str_contains($episode, '/')) {
                     $name .= sprintf('E%s', str_pad($episode, 2, '0', STR_PAD_LEFT));
                 }
                 if (empty($episode)) {
                     $name .= '*';
                 }
-            } elseif (! empty($airDate)) {
+            } elseif (!empty($airDate)) {
                 $name .= sprintf(' %s', str_replace(['/', '-', '.', '_'], ' ', $airDate));
             }
         }
         $searchResult = [];
-        if (! empty($name)) {
+        if (!empty($name)) {
             // Try Elasticsearch first if enabled
             if (config('nntmux.elasticsearch_enabled') === true) {
                 $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit);
@@ -618,7 +618,7 @@ 
             // Fall back to Manticore if Elasticsearch didn't return results
             if (empty($searchResult)) {
                 $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']);
-                if (! empty($searchResult)) {
+                if (!empty($searchResult)) {
                     $searchResult = Arr::wrap(Arr::get($searchResult, 'id'));
                 }
             }
@@ -636,11 +636,11 @@ 
             'WHERE r.passwordstatus %s %s %s %s %s %s %s',
             $this->showPasswords(),
             $showSql,
-            (! empty($searchResult) ? 'AND r.id IN ('.implode(',', $searchResult).')' : ''),
+            (!empty($searchResult) ? 'AND r.id IN ('.implode(',', $searchResult).')' : ''),
             Category::getCategorySearch($cat, 'tv'),
             ($maxAge > 0 ? sprintf('AND r.postdate > NOW() - INTERVAL %d DAY', $maxAge) : ''),
             ($minSize > 0 ? sprintf('AND r.size >= %d', $minSize) : ''),
-            ! empty($excludedCategories) ? sprintf('AND r.categories_id NOT IN('.implode(',', $excludedCategories).')') : ''
+            !empty($excludedCategories) ? sprintf('AND r.categories_id NOT IN('.implode(',', $excludedCategories).')') : ''
         );
         $baseSql = sprintf(
             "SELECT r.searchname, r.guid, r.postdate, r.categories_id, r.size, r.totalpart, r.fromname, r.passwordstatus, r.grabs, r.comments, r.adddate,
@@ -681,7 +681,7 @@ 
     public function animeSearch($aniDbID, int $offset = 0, int $limit = 100, string $name = '', array $cat = [-1], int $maxAge = -1, array $excludedCategories = []): mixed
     {
         $searchResult = [];
-        if (! empty($name)) {
+        if (!empty($name)) {
             // Try Elasticsearch first if enabled
             if (config('nntmux.elasticsearch_enabled') === true) {
                 $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit);
@@ -690,7 +690,7 @@ 
             // Fall back to Manticore if Elasticsearch didn't return results
             if (empty($searchResult)) {
                 $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']);
-                if (! empty($searchResult)) {
+                if (!empty($searchResult)) {
                     $searchResult = Arr::wrap(Arr::get($searchResult, 'id'));
                 }
             }
@@ -710,8 +710,8 @@ 
 			%s %s %s %s %s',
             $this->showPasswords(),
             ($aniDbID > -1 ? sprintf(' AND r.anidbid = %d ', $aniDbID) : ''),
-            (! empty($searchResult) ? 'AND r.id IN ('.implode(',', $searchResult).')' : ''),
-            ! empty($excludedCategories) ? sprintf('AND r.categories_id NOT IN('.implode(',', $excludedCategories).')') : '',
+            (!empty($searchResult) ? 'AND r.id IN ('.implode(',', $searchResult).')' : ''),
+            !empty($excludedCategories) ? sprintf('AND r.categories_id NOT IN('.implode(',', $excludedCategories).')') : '',
             Category::getCategorySearch($cat),
             ($maxAge > 0 ? sprintf(' AND r.postdate > NOW() - INTERVAL %d DAY ', $maxAge) : '')
         );
@@ -759,7 +759,7 @@ 
     {
         // Early return if searching by name yields no results
         $searchResult = [];
-        if (! empty($name)) {
+        if (!empty($name)) {
             // Try Elasticsearch first if enabled
             if (config('nntmux.elasticsearch_enabled') === true) {
                 $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit);
@@ -768,7 +768,7 @@ 
             // Fall back to Manticore if Elasticsearch didn't return results
             if (empty($searchResult)) {
                 $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']);
-                if (! empty($searchResult)) {
+                if (!empty($searchResult)) {
                     $searchResult = Arr::wrap(Arr::get($searchResult, 'id'));
                 }
             }
@@ -788,7 +788,7 @@ 
             sprintf('r.passwordstatus %s', $this->showPasswords()),
         ];
 
-        if (! empty($searchResult)) {
+        if (!empty($searchResult)) {
             $conditions[] = sprintf('r.id IN (%s)', implode(',', array_map('intval', $searchResult)));
         }
 
@@ -810,13 +810,13 @@ 
             $conditions[] = sprintf('m.traktid = %d', $traktId);
         }
 
-        if (! empty($excludedCategories)) {
+        if (!empty($excludedCategories)) {
             $conditions[] = sprintf('r.categories_id NOT IN (%s)', implode(',', array_map('intval', $excludedCategories)));
         }
 
         $catQuery = Category::getCategorySearch($cat, 'movies');
         $catQuery = preg_replace('/^(WHERE|AND)\s+/i', '', trim($catQuery));
-        if (! empty($catQuery) && $catQuery !== '1=1') {
+        if (!empty($catQuery) && $catQuery !== '1=1') {
             $conditions[] = $catQuery;
         }
         if ($maxAge > 0) {
@@ -892,7 +892,7 @@ 
             }
 
             $results = $this->search(['searchname' => getSimilarName($name)], -1, '', '', -1, -1, 0, config('nntmux.items_per_page'), '', -1, $excludedCats, 'basic', [$parentCat]);
-            if (! $results) {
+            if (!$results) {
                 return $ret;
             }
 
@@ -913,7 +913,7 @@ 
     private function performIndexSearch(array $searchArr, int $limit): array
     {
         // Filter out -1 values and empty strings
-        $searchFields = Arr::where($searchArr, static function ($value) {
+        $searchFields = Arr::where($searchArr, static function($value) {
             return $value !== -1 && $value !== '' && $value !== null;
         });
 
@@ -991,7 +991,7 @@ 
                     foreach ($terms as $term) {
                         $term = trim($term);
                         if (strlen($term) >= 2) {
-                            $query->where($field, 'LIKE', '%' . $term . '%');
+                            $query->where($field, 'LIKE', '%'.$term.'%');
                         }
                     }
                 }
@@ -1047,7 +1047,7 @@ 
 
         // Size conditions
         $sizeConditions = $this->buildSizeConditions($sizeFrom, $sizeTo);
-        if (! empty($sizeConditions)) {
+        if (!empty($sizeConditions)) {
             $conditions = array_merge($conditions, $sizeConditions);
         }
 
@@ -1057,7 +1057,7 @@ 
 
         // Category conditions - only add if not empty
         $catQuery = $this->buildCategoryCondition($type, $cat);
-        if (! empty($catQuery) && $catQuery !== '1=1') {
+        if (!empty($catQuery) && $catQuery !== '1=1') {
             $conditions[] = $catQuery;
         }
 
@@ -1071,7 +1071,7 @@ 
         }
 
         // Excluded categories
-        if (! empty($excludedCats)) {
+        if (!empty($excludedCats)) {
             $excludedCatsClean = array_map('intval', $excludedCats);
             $conditions[] = sprintf('r.categories_id NOT IN (%s)', implode(',', $excludedCatsClean));
         }

app/Services/Releases/ReleaseBrowseService.php

Spacing +2 added lines, -2 removed lines

@@ -197,7 +197,7 @@ 
                 %s
             ORDER BY r.%s %s %s",
             $this->uSQL($userShows, 'videos_id'),
-            (! empty($excludedCats) ? ' AND r.categories_id NOT IN ('.implode(',', $excludedCats).')' : ''),
+            (!empty($excludedCats) ? ' AND r.categories_id NOT IN ('.implode(',', $excludedCats).')' : ''),
             Category::TV_ROOT,
             Category::TV_OTHER,
             $this->showPasswords(),
@@ -246,7 +246,7 @@ 
         $sql = '(1=2 ';
         foreach ($userQuery as $query) {
             $sql .= sprintf('OR (r.%s = %d', $type, $query->$type);
-            if (! empty($query->categories)) {
+            if (!empty($query->categories)) {
                 $catsArr = explode('|', $query->categories);
                 if (\count($catsArr) > 1) {
                     $sql .= sprintf(' AND r.categories_id IN (%s)', implode(',', $catsArr));