Blacklight\Movie::getMovieRange()

Complexity

Conditions	4
Paths	4

Size

Total Lines	80
Code Lines	44

Duplication

Lines	0
Ratio	0 %

Importance

Changes	10
Bugs	5	Features	0

<?php
    public function getMovieRange($page, $cat, $start, $num, $orderBy, int $maxAge = -1, array $excludedCats = [])
    {
        $categorySearch = $this->buildCategorySearch($cat);
        $order = $this->getMovieOrder($orderBy);
        $cacheKey = md5(json_encode([$cat, $start, $num, $orderBy, $maxAge, $excludedCats, $page]));
        $expiresAt = now()->addMinutes(config('nntmux.cache_expiry_medium'));

        // Try to get from cache
        $cachedMovies = Cache::get($cacheKey);
        if ($cachedMovies) {
            return $cachedMovies;
        }

        $moviesQuery = MovieInfo::query()
            ->selectRaw('m.imdbid, GROUP_CONCAT(r.id ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_id')
            ->join('releases as r', 'm.imdbid', '=', 'r.imdbid')
            ->where('r.nzbstatus', 1)
            ->where('m.title', '!=', '')
            ->where('m.imdbid', '!=', '0000000')
            ->when($maxAge > 0, fn ($query) => $query->whereRaw('r.postdate > NOW() - INTERVAL ? DAY', [$maxAge]))
            ->when(! empty($excludedCats), fn ($query) => $query->whereNotIn('r.categories_id', $excludedCats))
            ->when(! empty($categorySearch), fn ($query) => $query->whereRaw($categorySearch))
            ->groupBy('m.imdbid')
            ->orderBy($order[0], $order[1])
            ->offset($start)
            ->limit($num);

        $movies = $moviesQuery->get();
        $total = DB::select('SELECT FOUND_ROWS() AS total');

        $movieIDs = $movies->pluck('imdbid')->toArray();
        $releaseIDs = $movies->pluck('grp_release_id')->toArray();

        if (! empty($movieIDs)) {
            $moviesDetailQuery = Release::query()
                ->selectRaw('
                GROUP_CONCAT(r.id ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_id,
                GROUP_CONCAT(r.rarinnerfilecount ORDER BY r.postdate DESC SEPARATOR ",") AS grp_rarinnerfilecount,
                GROUP_CONCAT(r.haspreview ORDER BY r.postdate DESC SEPARATOR ",") AS grp_haspreview,
                GROUP_CONCAT(r.passwordstatus ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_password,
                GROUP_CONCAT(r.guid ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_guid,
                GROUP_CONCAT(rn.releases_id ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_nfoid,
                GROUP_CONCAT(g.name ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_grpname,
                GROUP_CONCAT(r.searchname ORDER BY r.postdate DESC SEPARATOR "#") AS grp_release_name,
                GROUP_CONCAT(r.postdate ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_postdate,
                GROUP_CONCAT(r.size ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_size,
                GROUP_CONCAT(r.totalpart ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_totalparts,
                GROUP_CONCAT(r.comments ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_comments,
                GROUP_CONCAT(r.grabs ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_grabs,
                GROUP_CONCAT(df.failed ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_failed,
                GROUP_CONCAT(CONCAT(cp.title, " > ", c.title) ORDER BY r.postdate DESC SEPARATOR ",") AS grp_release_catname,
                m.*,
                g.name AS group_name,
                rn.releases_id AS nfoid
            ')
                ->leftJoin('usenet_groups as g', 'g.id', '=', 'r.groups_id')
                ->leftJoin('release_nfos as rn', 'rn.releases_id', '=', 'r.id')
                ->leftJoin('dnzb_failures as df', 'df.release_id', '=', 'r.id')
                ->leftJoin('categories as c', 'c.id', '=', 'r.categories_id')
                ->leftJoin('root_categories as cp', 'cp.id', '=', 'c.root_categories_id')
                ->join('movieinfo as m', 'm.imdbid', '=', 'r.imdbid')
                ->whereIn('m.imdbid', $movieIDs)
                ->whereIn('r.id', $releaseIDs)
                ->when(! empty($categorySearch), fn ($query) => $query->whereRaw($categorySearch))
                ->groupBy('m.imdbid')
                ->orderBy($order[0], $order[1])
                ->get();

            // Add total count to the first record if available
            if ($moviesDetailQuery->count() > 0) {
                $moviesDetailQuery[0]->_totalcount = $total[0]->total ?? 0;
            }

            // Cache the result
            Cache::put($cacheKey, $moviesDetailQuery, $expiresAt);

            return $moviesDetailQuery;
        }

        return collect();
    }