@php $usuario = Auth::user()->usuario; use Illuminate\Support\Facades\DB; // dd(DB::table('carga_log_archivos')->select(DB::raw('sum(n_nuevos_locales) as locales'), DB::raw('sum(n_nuevos_productos) as productos'))->where('fecha' ,'=',DB::raw('CURRENT_DATE'))->toSql()); $nuevos = DB::select("SELECT origen, 'Productos' AS tipo, COUNT(*) AS conteo FROM data_productos WHERE DATE(fecha_ingreso) = CURRENT_DATE GROUP BY 1 UNION SELECT origen, 'Locales' AS tipo, COUNT(*) AS conteo FROM data_locales WHERE DATE(fecha_ingreso) = CURRENT_DATE GROUP BY 1"); $filtrosLazy = (isset($filtrosLazy)) ? json_encode($filtrosLazy) : json_encode([]); @endphp