Differential D1714 Diff 4996 src/app/Console/Commands/Sku/ListUsers.php

Changeset View

Standalone View

				<?php

				namespace App\Console\Commands\Sku;

				use Illuminate\Console\Command;

				class ListUsers extends Command
				{
				/**
				* The name and signature of the console command.
				*
				* @var string
				*/
				protected $signature = 'sku:list-users {sku}';

				/**
				* The console command description.
				*
				* @var string
				*/
				protected $description = 'List users with the SKU entitlement.';

				/**
				* Execute the console command.
				*
				* @return mixed
				*/
				public function handle()
				{
				$sku = \App\Sku::find($this->argument('sku'));

				if (!$sku) {
				$sku = \App\Sku::where('title', $this->argument('sku'))->first();
				}

				if (!$sku) {
				$this->error("Unable to find the SKU.");
				return 1;
				}

				$fn = function ($entitlement) {
				$user_id = $entitlement->user_id;
				if ($entitlement->entitleable_type == \App\User::class) {
				$user_id = $entitlement->entitleable_id;
				}

				return $user_id;
				};

				$users = \App\Entitlement::select('user_id', 'entitleable_id', 'entitleable_type')
				->join('wallets', 'wallets.id', '=', 'wallet_id')
				->where('sku_id', $sku->id)
				->get()
				->map($fn)
				->unique();

				// TODO: This wereIn() might not scale
				\App\User::whereIn('id', $users)->orderBy('email')->get()
				->pluck('email')
				->each(function ($email, $key) {
				$this->info($email);
				});
				}
				}