Differential D3590 Diff 10337 src/app/Console/Commands/Wallet/TrialEndCommand.php

Changeset View

Standalone View

src/app/Console/Commands/Wallet/TrialEndCommand.php

This file was added.

				<?php

				namespace App\Console\Commands\Wallet;

				use App\Console\Command;

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

				/**
				* The console command description.
				*
				* @var string
				*/
				protected $description = 'Notify wallet (account) owners about an end of the trial period.';

				/**
				* Execute the console command.
				*
				* @return mixed
				*/
				public function handle()
				{
				// Get all wallets, excluding deleted/inactive accounts
				// created precisely a month ago
				$wallets = \App\Wallet::select('wallets.*')
				->join('users', 'users.id', '=', 'wallets.user_id')
				->leftJoin('wallet_settings', function ($join) {
				$join->on('wallet_settings.wallet_id', '=', 'wallets.id')
				->where('wallet_settings.key', 'trial_end_notice');
				})
				->withEnvTenantContext('users')
				->whereNull('users.deleted_at')
				->where('users.status', '&', \App\User::STATUS_IMAP_READY)
				->where('users.created_at', '>', \now()->subMonthsNoOverflow(2))
				->whereNull('wallet_settings.value')
				->cursor();
				mollekopfUnsubmitted Not Done Inline Actions Given you filter on trail_end_notice you could date-filter on created_at > subMonthDateNoOverflow(2) (everyone that is still in the second month). This would allow to "catch-up" should the command for some reason not execute on a specific day, and otherwise result in the same. mollekopf: Given you filter on trail_end_notice you could date-filter on created_at >…

				foreach ($wallets as $wallet) {
				// Send the email asynchronously
				\App\Jobs\TrialEndEmail::dispatch($wallet->owner);

				// Store the timestamp
				$wallet->setSetting('trial_end_notice', (string) \now());
				}
				}
				}