<?php

namespace App\Actions\Demo;

use App\Models\Episode;
use App\Models\Title;
use App\Models\User;
use Common\Files\Traits\HandlesEntryPaths;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\Sequence;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Symfony\Component\Console\Helper\ProgressBar;
use Symfony\Component\Console\Output\ConsoleOutput;

class GenerateDemoComments
{
    use HandlesEntryPaths;

    private Collection $users;

    private int $currentId = 1;

    public function execute(string $variant = null): void
    {
        DB::table('comment_reports')->truncate();
        DB::table('comment_votes')->truncate();
        $this->currentId = DB::table('comments')->max('id') + 1;

        $demoEmails = collect(
            json_decode(
                file_get_contents(app_path('Actions/Demo/demo-users.json')),
                true,
            ),
        )->pluck('email');
        $this->users = User::whereIn('email', $demoEmails)->get();

        // movies
        $this->generateFor(
            Title::where('release_date', '<', now()->subDays(6))
                ->where('is_series', false)
                ->where('popularity', '>=', 10),
            $variant === 'anime'
                ? app_path('Actions/Demo/demo-anime-comments.json')
                : app_path('Actions/Demo/demo-movie-comments.json'),
        );

        // series
        $this->generateFor(
            Title::where('release_date', '<', now()->subDays(6))
                ->withCount('episodes')
                ->where('is_series', true)
                ->where('popularity', '>=', 10)
                ->has('episodes', '<', 400),
            $variant === 'anime'
                ? app_path('Actions/Demo/demo-anime-comments.json')
                : app_path('Actions/Demo/demo-series-comments.json'),
        );

        // episodes
        $this->generateFor(
            Episode::where('release_date', '<', now()->subDays(6))->whereHas(
                'title',
                function ($query) {
                    $query->where('popularity', '>=', 1);
                },
            ),
            $variant === 'anime'
                ? app_path('Actions/Demo/demo-anime-comments.json')
                : app_path('Actions/Demo/demo-episode-comments.json'),
        );
    }

    protected function generateFor(Builder $builder, string $path): void
    {
        $query = $builder->has('comments', '<', 40)->select('id');
        $count = $query->count();

        if (!$count) {
            return;
        }

        $output = new ConsoleOutput();
        $progressBar = new ProgressBar($output, $count);
        $progressBar->start();

        $output->write(
            "Generating comments for {$builder->getModel()->getTable()}",
            true,
        );

        $userSequence = new Sequence(...$this->users->pluck('id')->toArray());
        $data = json_decode(file_get_contents($path), true);

        $itemComments = collect($data)
            ->slice(0, rand(40, 118))
            ->map(function ($comment) use ($userSequence) {
                $date = now()
                    ->subMonth(rand(0, 2))
                    ->subDays(rand(1, 12));
                return [
                    'user_id' => $userSequence(),
                    'content' => $comment['comment'],
                    'upvotes' => rand(5, 200),
                    'downvotes' => rand(0, 20),
                    'reports_count' => rand(0, 3),
                    'created_at' => $date,
                    'updated_at' => $date,
                ];
            });

        $query
            ->lazyById(100)
            ->each(function ($item) use ($progressBar, $itemComments) {
                $payload = $itemComments->map(function ($comment) use ($item) {
                    $data = array_merge($comment, [
                        'id' => $this->currentId,
                        'path' => $this->encodePath($this->currentId),
                        'commentable_id' => $item->id,
                        'commentable_type' => $item->getMorphClass(),
                    ]);
                    $this->currentId++;
                    return $data;
                });
                DB::table('comments')->insert($payload->toArray());
                $progressBar->advance();
            });

        $progressBar->finish();
    }
}