Blacklight\Releases::moviesSearch()

Complexity

Conditions	17
Paths	1539

Size

Total Lines	82
Code Lines	46

Duplication

Lines	0
Ratio	0 %

Importance

Changes	13
Bugs	6	Features	0

<?php
    public function moviesSearch(int $imDbId = -1, int $tmDbId = -1, int $traktId = -1, int $offset = 0, int $limit = 100, string $name = '', array $cat = [-1], int $maxAge = -1, int $minSize = 0, array $excludedCategories = []): mixed
    {
        $query = self::query()
            ->with(['movieinfo', 'group', 'category', 'category.parent', 'nfo'])
            ->whereBetween('categories_id', [Category::MOVIE_ROOT, Category::MOVIE_OTHER])
            ->where('nzbstatus', NZB::NZB_ADDED)
            ->where('passwordstatus', $this->showPasswords());

        if (! empty($name)) {
            if (config('nntmux.elasticsearch_enabled') === true) {
                $searchResult = $this->elasticSearch->indexSearchTMA($name, $limit);
            } else {
                $searchResult = $this->manticoreSearch->searchIndexes('releases_rt', $name, ['searchname']);
                if (! empty($searchResult)) {
                    $searchResult = Arr::wrap(Arr::get($searchResult, 'id'));
                }
            }

            if (count($searchResult) === 0) {
                return collect();
            }

            $query->whereIn('id', $searchResult);
        }

        if ($imDbId !== -1 && is_numeric($imDbId)) {
            $query->whereHas('movieinfo', function ($q) use ($imDbId) {
                $q->where('imdbid', $imDbId);
            });
        }

        if ($tmDbId !== -1 && is_numeric($tmDbId)) {
            $query->whereHas('movieinfo', function ($q) use ($tmDbId) {
                $q->where('tmdbid', $tmDbId);
            });
        }

        if ($traktId !== -1 && is_numeric($traktId)) {
            $query->whereHas('movieinfo', function ($q) use ($traktId) {
                $q->where('traktid', $traktId);
            });
        }

        if (! empty($excludedCategories)) {
            $query->whereNotIn('categories_id', $excludedCategories);
        }

        if ($cat !== [-1]) {
            $query->whereIn('categories_id', $cat);
        }

        if ($maxAge > 0) {
            $query->where('postdate', '>', now()->subDays($maxAge));
        }

        if ($minSize > 0) {
            $query->where('size', '>=', $minSize);
        }

        $totalRows = $query->count();

        $query->orderBy('postdate', 'desc')

'postdate' of type string is incompatible with the type Closure|Illuminate\Database\Eloquent\Builder|Illuminate\Database\Query\Builder expected by parameter $column of Illuminate\Database\Query\Builder::orderBy().

            ->offset($offset)
            ->limit($limit);

        $cacheKey = md5($query->toRawSql());

It seems like $query->toRawSql() can also be of type Illuminate\Database\Eloquent\Builder and Illuminate\Database\Query\Builder; however, parameter $string of md5() does only seem to accept string, maybe add an additional type check?

        $cacheTTL = now()->addMinutes(config('nntmux.cache_expiry_medium'));

        $releases = Cache::get($cacheKey);
        if ($releases !== null) {
            return $releases;
        }

        $releases = $query->get();

        if ($releases->isNotEmpty()) {
            $releases[0]->_totalrows = $totalRows;
        }

        Cache::put($cacheKey, $releases, $cacheTTL);

        return $releases;
    }