Tul xxx Tul

Viewing: contar_registros.php

<?php
require __DIR__.'/vendor/autoload.php';
$app = require_once __DIR__.'/bootstrap/app.php';
$app->make('Illuminate\Contracts\Console\Kernel')->bootstrap();

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

$tablas = [
    'empresas',
    'productos', 
    'clientes',
    'ventas',
    'detalle_ventas',
    'proveedores',
    'categorias',
    'marcas',
    'movimientos_contables',
    'comprobantes',
    'plan_cuentas',
    'configuracion_contable'
];

echo "Conteo de registros por tabla:\n";
echo "==============================\n\n";

$total = 0;
$detalles = [];

foreach ($tablas as $tabla) {
    if (Schema::hasTable($tabla)) {
        $count = DB::table($tabla)->count();
        $detalles[$tabla] = $count;
        $total += $count;
        echo sprintf("%-30s %5d\n", $tabla . ':', $count);
    }
}

echo "\n==============================\n";
echo sprintf("%-30s %5d\n", "TOTAL:", $total);
echo "==============================\n";

User / IP	: 216.73.216.217
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64