<?php

namespace App\Console\Commands;

use Modules\Licensing\Models\License;
use App\Models\User;
use App\Services\Accounts\PurchasedAccountProvisioner;
use Illuminate\Console\Command;

final class SonarDeskAccountsBackfill extends Command
{
    protected $signature = 'sonardesk:accounts:backfill {--dry-run : Report missing customer accounts without creating them} {--no-email : Create accounts without sending password setup links}';

    protected $description = 'Create portal accounts for existing licence holders that do not already have one.';

    public function handle(PurchasedAccountProvisioner $accounts): int
    {
        $customers = License::query()
            ->whereNotNull('customer_email')
            ->where('customer_email', '<>', '')
            ->select(['customer_email', 'customer_name'])
            ->orderBy('customer_email')
            ->get()
            ->unique(fn (License $license) => strtolower(trim((string) $license->customer_email)));

        $missing = 0;
        $created = 0;

        foreach ($customers as $license) {
            $email = strtolower(trim((string) $license->customer_email));
            if ($email === '') {
                continue;
            }

            if (User::query()->whereRaw('lower(email) = ?', [$email])->exists()) {
                continue;
            }

            $missing++;
            if ($this->option('dry-run')) {
                $this->line("MISSING  {$email}");
                continue;
            }

            if ($accounts->ensure($email, $license->customer_name, ! $this->option('no-email'))) {
                $created++;
                $this->info("CREATED  {$email}");
            }
        }

        if ($this->option('dry-run')) {
            $this->info("{$missing} account(s) would be created.");
        } else {
            $this->info("{$created} account(s) created.");
        }

        return self::SUCCESS;
    }
}