Differential D1150 Diff 3448 src/app/Console/Commands/WalletUntil.php

Changeset View

Standalone View

src/app/Console/Commands/WalletUntil.php

This file was added.

				<?php

				namespace App\Console\Commands;

				use Illuminate\Console\Command;

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

				/**
				* The console command description.
				*
				* @var string
				*/
				protected $description = 'Show until when the balance on a wallet lasts.';

				/**
				* Create a new command instance.
				*
				* @return void
				*/
				public function __construct()
				{
				parent::__construct();
				}

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

				if (!$wallet) {
				return 1;
				}

				$balance = $wallet->balance;

				$discount = $wallet->getDiscountRate();

				$costs = 0;

				$fromDate = \Carbon\Carbon::now()->subMonthsWithoutOverflow(6);
				$toDate = \Carbon\Carbon::now()->subMonthsWithoutOverflow(6);

				$entitlements = \App\Entitlement::where('wallet_id', $wallet->id)->orderBy('updated_at');

				foreach ($entitlements as $entitlement) {
				if ($entitlement->cost == 0) {
				continue;
				}

				if ($entitlement->created_at > $fromDate) {
				$fromDate = $entitlement->created_at->copy();
				}

				if ($entitlement->updated_at > $toDate) {
				$toDate = $entitlement->updated_at->copy();
				}
				}

				machniakUnsubmitted Not Done Inline Actions This is the same query but different order as above. I guess, we could do a single select. machniak: This is the same query but different order as above. I guess, we could do a single select.
				foreach ($entitlements->get() as $entitlement) {
				if ($entitlement->cost == 0) {
				continue;
				}

				$newToDate = $entitlement->updated_at->copy()->addMonthsWithoutOverflow(1);

				$cost = $discount * $entitlement->cost;
				$costs += $cost;

				if ($balance >= $cost) {
				$balance -= $cost;
				if ($newToDate > $toDate) {
				$toDate = $newToDate;
				}
				}
				}

				$this->info("{$wallet->balance} lasts until {$toDate} (a month costs {$costs})");
				}
				}