ChartController::bar() - Code Metrics - laravel-liberu/genealogy - Measure and Improve Code Quality continuously with Scrutinizer

ChartController::bar() A
last analyzed 2023-10-09 08:54 UTC

↳ Parent: ChartController
Complexity

Conditions	1
Paths	1
Size

Total Lines	10
Code Lines	8
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	8
nc	1
nop	0
dl	0
loc	10
rs	10
c	0
b	0
f	0
<?php

namespace App\Http\Controllers\Dashboard;

use App\Traits\ConnectionTrait;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Routing\Controller;
use Illuminate\Support\Facades\Auth;
use LaravelEnso\Charts\Factories\Bar;
use LaravelEnso\Charts\Factories\Bubble;
use LaravelEnso\Charts\Factories\Doughnut;
use LaravelEnso\Charts\Factories\Line;
use LaravelEnso\Charts\Factories\Pie;
use LaravelEnso\Charts\Factories\Polar;
use LaravelEnso\Charts\Factories\Radar;

//use LaravelEnso\Multitenancy\Enums\Connections;

class ChartController extends Controller
{
    use ConnectionTrait;
    // use SystemConnection;

    public function line()
    {
        return (new Line())
            ->title('Income')
            ->labels(['January', 'February', 'March', 'April', 'May', 'June', 'July'])
            ->datasets([
                'Sales' => [65, 59, 80, 81, 26, 25, 10],
                'Revenue' => [15, 29, 60, 31, 56, 65, 44],
            ])->fill()
            ->get();
    }

    public function bar()
    {
        return (new Bar())
            ->title('Sales')
            ->labels(['Ian', 'Feb', 'Mar'])
            ->datasets([
                'Sales' => [1233, 1231, 3123],
                'Spendings' => [1250, 1730, 5300],
                'Profit' => [1250 - 1233, 1730 - 1231, 5300 - 3123],
            ])->get();
    }

    public function pie()
    {
        // \DB::table('some')->get();
        $male = \DB::table('people')->where('sex', 'M')->get()->count();
        $female = \DB::table('people')->where('sex', 'F')->get()->count();
        $unknown = \DB::table('people')->whereNull('sex')->get()->count();
        \Session::get('db', env('DB_DATABASE'));
        $user = Auth::user();
        $user->person->company();

        \Session::get('companyId');

        // return $current_db;
        // return $sv;
        return (new Pie())
            ->title('Genders')
            ->labels(['Male', 'Female', 'Unknown'])
            ->datasets([$male, $female, $unknown])
            ->get();
    }

    public function doughnut()
    {
        return (new Doughnut())
            ->title('Colors Two')
            ->labels(['Green', 'Red', 'Azzure'])
            ->datasets([400, 50, 100])
            ->get();
    }

    public function radar()
    {
        return (new Radar())
            ->title('Habits')
            ->labels([
                'Eating', 'Drinking', 'Sleeping', 'Designing', 'Coding', 'Cycling', 'Running',
            ])
            ->datasets([
                '2005' => [65, 59, 90, 81, 56, 55, 40],
                '2006' => [28, 48, 40, 19, 96, 27, 100],
            ])->get();
    }

    public function polar()
    {
        return (new Polar())
            ->title('Again Colors')
            ->labels(['Green', 'Red', 'Azzure', 'Portocaliu', 'Purple'])
            ->datasets([11, 16, 7, 14, 14])
            ->get();
    }

    public function bubble()
    {
        return (new Bubble())
            ->title('City Population by Age')
            ->labels(['Geneva', 'Besel', 'Bucharest'])
            ->datasets([
                0 => [[1010, 59, 4800], [2011, 55, 1800], [1012, 45, 2000], [413, 58, 4400]],
                1 => [[2010, 48, 1700], [1211, 67, 1200], [2012, 96, 1233], [813, 35, 3000]],
                2 => [[1510, 44, 2000], [811, 62, 1500], [212, 55, 1299], [1213, 39, 4000]],
            ])->get();
    }

    // change database to use
    public function changedb(Request $request)
    {
        $prevConn = $this->getConnection();
        $company_id = $request->get('company_id');
//        $tree_id = $request->get('tree_id');
        if (! empty($company_id)) {
            $tenants = \App\Models\Tenant::find($company_id);
            if ($tenants) {
                $db = $tenants->tenancy_db_name;

                $key = 'database.connections.tenant.database';
                config([$key => $db]);
                \DB::reconnect('tenantdb');
//                \Session::put('conn', $conn);php
                \Session::put('db', $db);
//            $db = Connections::Tenant.$company_id.'_'.$tree_id;
//                $this->setConnection($key, $db);
            }
        }
        //            $db = 'enso';
//            $key = 'database.default';
//            $this->setConnection('mysql');

        $changeConn = $this->getConnection();

        $peoplesattached = \DB::connection($changeConn)->table('people')->get()->count();
        $familiesjoined = \DB::connection($changeConn)->table('families')->get()->count();

        return json_encode([
            'db' => config('database.connections.tenant.database'),
            'connection' => $changeConn,
            'changedb' => $prevConn === $changeConn,
            'familiesjoined' => $familiesjoined,
            'peoplesattached' => $peoplesattached,
        ], JSON_THROW_ON_ERROR);
    }

    // get companies of user.
    public function getDB()
    {
        $user = Auth::user();
        $companies = $user->person->companies()->get();

        $ret = [];
        $ret['company'] = $companies;

        return $ret;
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    public function destroy(/** @scrutinizer ignore-unused */ $id)
    {
    }

    public function trial()
    {
        $user = auth()->user();
        if ($user->subscribed('default')) {
            $days = Carbon::now()->diffInDays(Carbon::parse($user->subscription('default')->asStripeSubscription()->current_period_end));
        } else {
            $days = Carbon::now()->diffInDays($user->trial_ends_at);
        }

        return ['days' => $days];
    }

    public function changeCompany(Request $request)
    {
        $prevConn = $this->getConnection();
        $company_id = $request->get('company_id');
        $tree_id = $request->get('tree_id');
        if (! empty($company_id)) {
            $db = Connections::Tenant.$company_id.'_'.$tree_id;
filter:
    dependency_paths: ["lib/*"]
            $this->setConnection(Connections::Tenant, $db);
        } else {
            $this->setConnection('mysql');
        }
        $changeConn = $this->getConnection();

        $peoplesattached = \DB::connection($changeConn)->table('people')->get()->count();
        $familiesjoined = \DB::connection($changeConn)->table('families')->get()->count();

        return json_encode([
            'db' => config('database.connections.tenant.database'),
            'connection' => $changeConn,
            'changedb' => $prevConn === $changeConn,
            'familiesjoined' => $familiesjoined,
            'peoplesattached' => $peoplesattached,
        ], JSON_THROW_ON_ERROR);
    }
}

laravel-liberu / genealogy

ChartController::bar() A last analyzed 2023-10-09 08:54 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ChartController::bar() A
last analyzed 2023-10-09 08:54 UTC
