RefreshBalance::handle() - Code Metrics - Inspection of "fix namespace" - bavix/laravel-wallet - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 986bed...72bf42 )

by Бабичев

created 2019-06-17 15:00 UTC

RefreshBalance::handle() A

↳ Parent: RefreshBalance

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
cc	1
eloc	13
nc	1
nop	0
dl	0
loc	19
ccs	0
cts	14
cp	0
crap	2
rs	9.8333
c	0
b	0
f	0

<?php

namespace Bavix\Wallet\Commands;

use Illuminate\Database\Query\JoinClause;
use Illuminate\Support\Facades\DB;
use Illuminate\Console\Command;
use function config;

class RefreshBalance extends Command
{

    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'wallet:refresh';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Recalculates all wallets';

    /**
     * @return void
     */
    public function handle(): void
    {
        DB::transaction(function () {
            $wallet = config('wallet.wallet.table');
            $trans = config('wallet.transaction.table');

            $availableBalance = DB::table($trans)
                ->select('wallet_id', DB::raw('sum(amount) balance'))
                ->where('confirmed', true)
                ->groupBy('wallet_id');

            $joinClause = function (JoinClause $join) use ($wallet) {
                $join->on("$wallet.id", '=', 'b.wallet_id');
            };

            DB::table($wallet)->update(['balance' => 0]);
            DB::table($wallet)
                ->joinSub($availableBalance, 'b', $joinClause, null, null, 'left')
                ->update(['balance' => DB::raw('b.balance')]);
        });
    }

}


1			<?php
2
3			namespace Bavix\Wallet\Commands;
4
5			use Illuminate\Database\Query\JoinClause;
6			use Illuminate\Support\Facades\DB;
7			use Illuminate\Console\Command;
8			use function config;
9
10			class RefreshBalance extends Command
11			{
12
13			/**
14			* The name and signature of the console command.
15			*
16			* @var string
17			*/
18			protected $signature = 'wallet:refresh';
19
20			/**
21			* The console command description.
22			*
23			* @var string
24			*/
25			protected $description = 'Recalculates all wallets';
26
27			/**
28			* @return void
29			*/
30			public function handle(): void
31			{
32			DB::transaction(function () {
33			$wallet = config('wallet.wallet.table');
34			$trans = config('wallet.transaction.table');
35
36			$availableBalance = DB::table($trans)
37			->select('wallet_id', DB::raw('sum(amount) balance'))
38			->where('confirmed', true)
39			->groupBy('wallet_id');
40
41			$joinClause = function (JoinClause $join) use ($wallet) {
42			$join->on("$wallet.id", '=', 'b.wallet_id');
43			};
44
45			DB::table($wallet)->update(['balance' => 0]);
46			DB::table($wallet)
47			->joinSub($availableBalance, 'b', $joinClause, null, null, 'left')
48			->update(['balance' => DB::raw('b.balance')]);
49			});
50			}
51
52			}
53

bavix / laravel-wallet

Push — master ( 986bed...72bf42 )

RefreshBalance::handle() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like