Online PHP editor | perf for PT8iU

<?php include 'conexion.php'; // Función para calcular Días de Ingreso y Nota automáticamente function calcularDiasYNota($fechaIngreso, $fechaInventario) { $dateIngreso = new DateTime($fechaIngreso); $dateInv = new DateTime($fechaInventario); $dias = $dateIngreso->diff($dateInv)->days; if ($dias < 15) { $nota = "Menor a 15 días"; $badgeClass = "bg-success"; // Verde } elseif ($dias <= 29) { $nota = "Entre 15 y 29 días"; $badgeClass = "bg-warning text-dark"; // Amarillo } else { $nota = "Mayor a 30 días"; $badgeClass = "bg-danger"; // Rojo } return [ 'dias' => $dias, 'nota' => $nota, 'badge' => $badgeClass ]; } // Obtener registros $sql = "SELECT * FROM inventario ORDER BY fecha_ingreso ASC"; $result = $conn->query($sql); ?> <!DOCTYPE html> <html lang="es"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Control de Inventario</title>  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">  <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" rel="stylesheet"> <style> body { background-color: #f8f9fa; } .table-header { background-color: #1a252f; color: white; } .card { border-radius: 12px; box-shadow: 0 4px 6px rgba(0,0,0,0.05); } </style> </head> <body> <div class="container-fluid py-4 px-4"> <div class="d-flex justify-content-between align-items-center mb-4"> <h2><i class="fa-solid fa-boxes-stacked me-2"></i>Control de Inventario de Equipos</h2> <button class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#modalIngreso"> <i class="fa-solid fa-plus me-1"></i> Registrar Nuevo Artículo </button> </div>  <div class="card"> <div class="card-body p-0"> <div class="table-responsive"> <table class="table table-hover table-striped align-middle mb-0"> <thead class="table-header"> <tr> <th>FECHA INVENTARIO</th> <th>FECHA INGRESO</th> <th>SERIE</th> <th>ARTÍCULO</th> <th>ESTADO</th> <th>COMENTARIO</th> <th class="text-center">DÍAS INGRESO</th> <th class="text-center">NOTA</th> </tr> </thead> <tbody> <?php if ($result->num_rows > 0): ?> <?php while($row = $result->fetch_assoc()): $calculo = calcularDiasYNota($row['fecha_ingreso'], $row['fecha_inventario']); ?> <tr> <td><?= date("d/m/Y", strtotime($row['fecha_inventario'])) ?></td> <td><?= date("d/m/Y", strtotime($row['fecha_ingreso'])) ?></td> <td><code class="fw-bold text-dark"><?= htmlspecialchars($row['serie']) ?></code></td> <td><span class="badge bg-secondary"><?= htmlspecialchars($row['articulo']) ?></span></td> <td> <?php if($row['estado'] == 'LIMPIEZA'): ?> <span class="badge bg-info text-dark">LIMPIEZA</span> <?php else: ?> <span class="badge bg-primary">EN BODEGA</span> <?php endif; ?> </td> <td><?= htmlspecialchars($row['comentario']) ?></td> <td class="text-center fw-bold"><?= $calculo['dias'] ?></td> <td class="text-center"> <span class="badge <?= $calculo['badge'] ?> px-3 py-2"> <?= $calculo['nota'] ?> </span> </td> </tr> <?php endwhile; ?> <?php else: ?> <tr> <td colspan="8" class="text-center py-4 text-muted">No hay registros guardados.</td> </tr> <?php endif; ?> </tbody> </table> </div> </div> </div> </div>  <div class="modal fade" id="modalIngreso" tabindex="-1" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <form action="guardar.php" method="POST"> <div class="modal-header"> <h5 class="modal-title">Registrar Artículo</h5> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <div class="modal-body"> <div class="mb-3"> <label class="form-label">Fecha Inventario</label> <input type="date" name="fecha_inventario" class="form-control" value="<?= date('Y-m-d') ?>" required> </div> <div class="mb-3"> <label class="form-label">Fecha Ingreso</label> <input type="date" name="fecha_ingreso" class="form-control" required> </div> <div class="mb-3"> <label class="form-label">Serie</label> <input type="text" name="serie" class="form-control" placeholder="Ej: 2700050952..." required> </div> <div class="mb-3"> <label class="form-label">Artículo</label> <select name="articulo" class="form-select" required> <option value="MPOS">MPOS</option> <option value="PAX A920PRO">PAX A920PRO</option> <option value="RAPI BAC">RAPI BAC</option> </select> </div> <div class="mb-3"> <label class="form-label">Estado</label> <select name="estado" class="form-select" required> <option value="EN BODEGA">EN BODEGA</option> <option value="LIMPIEZA">LIMPIEZA</option> <option value="REPARACION">REPARACIÓN</option> </select> </div> <div class="mb-3"> <label class="form-label">Comentario</label> <textarea name="comentario" class="form-control" rows="2" placeholder="Ej: SIN CAJA / ESTANTE ABAJO"></textarea> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancelar</button> <button type="submit" class="btn btn-success">Guardar Registro</button> </div> </form> </div> </div> </div> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> </body> </html>

Version	System time (s)	User time (s)	Memory (MiB)
8.5.10	0.006	0.005	16.88
8.5.9	0.008	0.006	17.04
8.5.8	0.009	0.009	16.84
8.5.7	0.009	0.008	17.17
8.5.6	0.004	0.004	16.93
8.5.5	0.008	0.009	16.74
8.5.4	0.008	0.004	16.80
8.5.3	0.009	0.005	16.93
8.5.2	0.010	0.008	16.66
8.5.1	0.009	0.007	16.73
8.5.0	0.009	0.008	16.90
8.4.25	0.015	0.005	19.82
8.4.24	0.007	0.007	19.77
8.4.23	0.010	0.010	19.79
8.4.22	0.006	0.006	19.72
8.4.21	0.013	0.007	19.66
8.4.20	0.008	0.003	19.75
8.4.19	0.009	0.012	19.79
8.4.18	0.016	0.006	19.75
8.4.17	0.008	0.011	19.78
8.4.16	0.006	0.005	19.86
8.4.15	0.010	0.009	19.91
8.4.14	0.007	0.006	17.98
8.4.13	0.011	0.007	17.88
8.4.12	0.006	0.005	18.14
8.4.11	0.009	0.004	18.10
8.4.10	0.010	0.009	18.15
8.4.9	0.005	0.010	18.08
8.4.8	0.008	0.008	18.09
8.4.7	0.006	0.003	18.14
8.4.6	0.007	0.002	18.05
8.4.5	0.006	0.003	18.07
8.4.4	0.005	0.004	17.96
8.4.3	0.005	0.004	17.92
8.4.2	0.006	0.010	17.90
8.4.1	0.012	0.007	17.89
8.3.33	0.015	0.008	18.42
8.3.32	0.011	0.011	18.59
8.3.31	0.006	0.004	18.61
8.3.30	0.005	0.007	18.59
8.3.29	0.010	0.008	18.64
8.3.28	0.008	0.004	18.58
8.3.27	0.009	0.005	16.80
8.3.26	0.008	0.010	17.01
8.3.25	0.009	0.007	16.91
8.3.24	0.006	0.003	16.92
8.3.23	0.004	0.004	17.00
8.3.22	0.004	0.005	16.91
8.3.21	0.006	0.003	16.99
8.3.20	0.005	0.003	16.86
8.3.19	0.006	0.005	17.00
8.3.18	0.002	0.006	16.86
8.3.17	0.007	0.004	16.86
8.3.16	0.006	0.002	17.00
8.3.15	0.003	0.005	16.92
8.3.14	0.005	0.003	16.96
8.3.13	0.006	0.003	17.00
8.3.12	0.006	0.006	16.92
8.3.11	0.012	0.007	16.92
8.3.10	0.008	0.005	16.89
8.3.9	0.005	0.004	16.93
8.3.8	0.005	0.004	16.93
8.3.7	0.010	0.007	16.89
8.3.6	0.009	0.002	16.89
8.3.5	0.009	0.007	16.89
8.3.4	0.013	0.008	18.09
8.3.3	0.009	0.002	18.14
8.3.2	0.013	0.008	18.09
8.3.1	0.007	0.005	18.21
8.3.0	0.011	0.010	18.08
8.2.33	0.006	0.006	18.27
8.2.32	0.005	0.004	18.21
8.2.31	0.005	0.003	18.18