App\Console\Commands\databaseCheck

Complexity

Total Complexity

13

Size/Duplication

Total Lines	141
Duplicated Lines	0 %

Test Coverage

Coverage

4.34%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	handle()	0	19	3
A	checkForeignKeys()	0	35	3
B	checkUsers()	0	64	6

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Storage;

use App\User;
use App\UserSettings;
use App\Domains\Maintenance\DatabaseCheck as MaintenanceDatabaseCheck;


class databaseCheck extends Command
{
    protected $signature = 'tb-dbcheck {--fix : Automatically fix any errors that arrise}';
    protected $fix = false;
    protected $description = 'Verify database and file structure has no errors';

    public function __construct()
    {
        parent::__construct();

    }

    public function handle()
    {
        //  Determine if fix option is enabled
        if($this->option('fix'))
        {
            $this->fix = true;
        }
        //  Extend the amount of time the script is allowed to run
        ini_set('max_execution_time', 600);  //  600 seconds = 10 minutes

        //  Begin check
        $fixStr = $this->fix ? 'on' : 'off';
        $this->line('');
        $this->line('Running Database Check...');
        $this->line('');
        Log::alert('The database check has been initiated.  Fix option is set to '.$fixStr);

        $this->checkUsers();
        $this->checkForeignKeys();
    }



    //  User check will count users and administrators
    protected function checkUsers()
    {
        $activeUsers   = User::all()->count();
        $inactiveUsers = User::onlyTrashed()->count();

        //  All users allowed to login
        $str = 'Current Active Users........................... '.$activeUsers;
        $this->line($str);
        Log::notice($str);

        //  All users that have been disabled
        $str = 'Current Inactive Users......................... '.$inactiveUsers;
        $this->line($str);
        Log::notice($str);

        //  All Active Installers
        $instArr    = [];
        $installers = User::where('role_id', 1)->get();
        foreach($installers as $ins)
        {
            $instArr[] = [
                'user_id'   => $ins->user_id,
                'username'  => $ins->username,
                'full_name' => $ins->full_name,
            ];
        }
        $this->line('');
        $this->line('Active Installers:');
        $this->table(['User ID', 'Username', 'Full Name'], $instArr);
        Log::notice('Current Active Installers - ', $instArr);

        //  All Active Administrators
        $adminArr    = [];
        $administrators = User::where('role_id', 2)->get();
        foreach($administrators as $adm)
        {
            $adminArr[] = [
                'user_id'   => $adm->user_id,
                'username'  => $adm->username,
                'full_name' => $adm->full_name,
            ];
        }
        $this->line('');
        $this->line('Active Administrators:');
        $this->table(['User ID', 'Username', 'Full Name'], $adminArr);
        Log::notice('Current Active Administrators - ', $adminArr);

        //  Validate that each user has a user_settings entry
        $this->line('');
        $this->line('Validating User Settings');
        $userList   = User::all();
        foreach($userList as $user)
        {
            $row = UserSettings::where('user_id', $user->user_id)->count();
            if($row != 1)
            {
                $str = 'User '.$user->full_name.' missing Settings Table';
                $this->error($str);
                Log::error($str);

                if($this->fix)
                {
                    UserSettings::create([
                        'user_id' => $user->user_id,
                    ]);
                }
            }
        }
    }

    protected function checkForeignKeys()
    {
        $tableList = [
            'users',
            'user_role_permissions',
            'user_logins',
            'tech_tips',
            'tech_tip_systems',
            'tech_tip_files',
            'tech_tip_favs',
            'tech_tip_comments',
            'system_types',
            'system_data_fields',
            'file_links',
            'file_link_files',
            'customer_systems',
            'customer_system_data',
            'customer_notes',
            'customer_files',
            'customer_favs',
            'customer_contacts',
            'customer_contact_phones',
        ];

        $dbObj = new MaintenanceDatabaseCheck($this->fix);
        $this->line('Running Foreign Key Check');

        foreach($tableList as $table)
        {
            $valid = $dbObj->execute($table);
            if(!$valid)
            {
                $str = 'Foreign Key Check for '.$table.' failed';
                $this->error($str);
                Log::error($str);
            }
        }
    }
}