Iniciar Sesión - RetroCloud

📊

Presupuesto Operativo Q4 2026 - Auditoría Interna

E14

=SUM(B14:D14) * (1 - $H$2)

	A (Concepto de Gasto)	B (Octubre 2026)	C (Noviembre 2026)	D (Diciembre 2026)	E (Total Trimestre)	F (Desviación vs Target)	G (Estado)
1	INGRESOS CONSOLIDADOS	€148,250.00	€162,100.00	€195,400.00	€505,750.00	+4.2%	Aprobado
2	Servicios Cloud e Infraestructura	€12,450.00	€13,100.00	€12,900.00	€38,450.00	-1.5%	Verificado
3	Nóminas y Seguridad Social (Personal Dev)	€48,000.00	€48,000.00	€54,200.00	€150,200.00	0.0%	En proceso
4	Licencias de Software y Seguridad	€3,850.00	€3,850.00	€4,100.00	€11,800.00	+2.1%	Revisión requerida
5	Marketing Digital & SEM	€14,200.00	€16,500.00	€21,000.00	€51,700.00	-0.8%	Planificado
6	Gastos de Oficina y Suministros	€2,100.00	€2,300.00	€2,250.00	€6,650.00	-3.1%	Aprobado
7	TOTAL GASTOS OPERATIVOS	€80,600.00	€83,750.00	€94,450.00	€258,800.00	-0.5%	Consolidado

UserController.php - api-backend - Visual Studio Code

📁

🔍

🌿

▶️

🧩

🐘 UserController.php ✕

🐘 AuthController.php

api-backend › app › Http › Controllers › UserController.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

<?php namespace App\Http\Controllers; use App\Models\User; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Hash; class UserController extends Controller { /** * Obtener listado consolidado de usuarios y métricas de sesión */ public function index(Request $request): JsonResponse { $validated = $request->validate([ 'page' => 'integer|min:1', 'per_page' => 'integer|max:100', 'status' => 'string|in:active,suspended', ]); $users = User::query() ->where('status', $validated['status'] ?? 'active') ->withCount(['sessions', 'transactions']) ->orderByDesc('created_at') ->paginate($validated['per_page'] ?? 25); return response()->json([ 'success' => true, 'data' => $users, ]); } }

🌿 main* ⊗ 0 ⚠ 0

Ln 24, Col 18 Spaces: 4 UTF-8 PHP 8.4

[phpMyAdmin] Servidor: 127.0.0.1:3306 › Base de datos: production_db › Tabla: users

Versión 5.2.1 | MariaDB 11.8

📋 Examinar

🛠️ Estructura

📝 SQL

🔍 Buscar

➕ Insertar

📤 Exportar

📥 Importar

⚙️ Operaciones

✓ Mostrando filas 0 - 5 (6 en total, La consulta tardó 0.0008 segundos.)

SELECT id, username, email, role, status, last_login, created_at
FROM users
WHERE status = 'active'
ORDER BY id DESC;

Acción	id	username	email	role	status	last_login	created_at
Editar Copiar Borrar	1	admin_sys	admin@production.internal	admin	active	2026-11-03 10:45:12	2026-08-15 09:20:00
Editar Copiar Borrar	2	operaciones_batch	cron@production.internal	service	active	2026-11-03 11:00:00	2026-08-16 11:10:00
Editar Copiar Borrar	3	jgarcia_dev	jgarcia@company.es	developer	active	2026-11-03 09:14:30	2026-09-01 14:00:22
Editar Copiar Borrar	4	mlopez_analytics	mlopez@company.es	analyst	active	2026-11-02 18:32:10	2026-09-10 16:45:00