BalancesCommand.php
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

BalancesCommand.php
View Options

	<?php

	namespace App\Console\Commands\Wallet;

	use Illuminate\Console\Command;

	class BalancesCommand extends Command
	{
	/**
	* The name and signature of the console command.
	*
	* @var string
	*/
	protected $signature = 'wallet:balances';

	/**
	* The console command description.
	*
	* @var string
	*/
	protected $description = 'Show the balance on wallets';

	/**
	* Execute the console command.
	*
	* @return mixed
	*/
	public function handle()
	{
	$wallets = \App\Wallet::select('wallets.*')
	->join('users', 'users.id', '=', 'wallets.user_id')
	->withEnvTenantContext('users')
	->where('balance', '!=', '0')
	->whereNull('users.deleted_at')
	->orderBy('balance');

	$wallets->each(
	function ($wallet) {
	$user = $wallet->owner;

	$this->info(
	sprintf(
	"%s: %8s (account: %s/%s (%s))",
	$wallet->id,
	$wallet->balance,
	"https://kolabnow.com/cockpit/admin/accounts/show",
	$user->id,
	$user->email
	)
	);
	}
	);
	}
	}