App\Services\MovieService::processMovieReleases()

Complexity

Conditions	23
Paths	4169

Size

Total Lines	88
Code Lines	53

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function processMovieReleases(string $groupID = '', string $guidChar = '', int $lookupIMDB = 1): void
    {
        if ($lookupIMDB === 0) {
            return;
        }

        $query = Release::query()
            ->select(['searchname', 'id'])
            ->whereBetween('categories_id', [Category::MOVIE_ROOT, Category::MOVIE_OTHER])
            ->whereNull('imdbid');

        if ($groupID !== '') {
            $query->where('groups_id', $groupID);
        }

        if ($guidChar !== '') {
            $query->where('leftguid', $guidChar);
        }

        if ((int) $lookupIMDB === 2) {
            $query->where('isrenamed', '=', 1);
        }

        $res = $query->orderByDesc('id')->limit($this->movieqty)->get();

'id' 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::orderByDesc().

        $movieCount = count($res);
        $failedIDs = [];

        if ($movieCount > 0) {
            if ($this->echooutput && $movieCount > 1) {
                $this->colorCli->header('Processing '.$movieCount.' movie releases.');
            }

            foreach ($res as $arr) {
                if (! $this->parseMovieSearchName($arr['searchname'])) {
                    $failedIDs[] = $arr['id'];

                    continue;
                }

                $this->currentRelID = $arr['id'];
                $movieName = $this->formatMovieName();

                if ($this->echooutput) {
                    $this->colorCli->info('Looking up: '.$movieName);
                }

                $foundIMDB = $this->searchLocalDatabase($arr['id']) ||
                    $this->searchIMDb($arr['id']) ||
                    $this->searchOMDbAPI($arr['id']) ||
                    $this->searchTraktTV($arr['id'], $movieName) ||
                    $this->searchTMDB($arr['id']);

                if ($foundIMDB) {
                    if ($this->echooutput) {
                        $this->colorCli->primary('Successfully updated release with IMDB ID');
                    }

                    continue;
                } else {
                    $releaseCheck = Release::query()->where('id', $arr['id'])->whereNotNull('imdbid')->exists();
                    if ($releaseCheck) {
                        if ($this->echooutput) {
                            $this->colorCli->info('Release already has IMDB ID, skipping');
                        }

                        continue;
                    }
                }

                $failedIDs[] = $arr['id'];
            }

            if (! empty($failedIDs)) {
                if ($this->echooutput) {
                    $failedReleases = Release::query()
                        ->select(['id', 'searchname'])
                        ->whereIn('id', $failedIDs)
                        ->get();

                    $this->colorCli->header('Failed to find IMDB IDs for '.count($failedIDs).' releases:');
                    foreach ($failedReleases as $release) {
                        $this->colorCli->error("ID: {$release->id} - {$release->searchname}");
                    }
                }

                foreach (array_chunk($failedIDs, 100) as $chunk) {
                    Release::query()->whereIn('id', $chunk)->update(['imdbid' => '0000000']);
                }