60 lines
1.9 KiB
PHP
60 lines
1.9 KiB
PHP
<?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;
|
|
}
|
|
}
|