Viewing File: /home/markqprx/iniasli.pro/Commands/UpdateSimplePaginateTables.php

<?php

namespace Common\Core\Commands;

use Common\Settings\Settings;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class UpdateSimplePaginateTables extends Command
{
    protected $signature = 'simplePaginateTables:update';

    public function handle(): int
    {
        $max = 100000;

        $tables = [];

        collect(DB::select('SHOW TABLES'))
            ->map(function ($val) {
                foreach ($val as $key => $tbl) {
                    return $tbl;
                }
            })
            ->each(function ($table) use ($max, &$tables) {
                if (DB::table($table)->count() > $max) {
                    $tables[] = $table;
                }
            });

        app(Settings::class)->save([
            'simple_pagination_tables' => implode(',', $tables),
        ]);

        return Command::SUCCESS;
    }
}