<?php
set_time_limit(0);
session_start();
header("Cache-control: private"); // Arregla IE 6
//*******Datos de Conexion Base de Datos************
include("../../bd/conexion.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css" integrity="sha512-1ycn6IcaQQ40/MKBW2W4Rhis/DbILU74C1vSrLJxCq57o941Ym01SwNsOMqvEBFlcgUa6xLiPY/NS5R+E6ztJQ==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css" integrity="sha512-KfkfwYDsLkIlwQp6LFnl8zNdLGxu9YAA1QvwINks4PhcElQSvqcyVLLD9aMhXd13uQjoXtEKNosOWaZqXgel0g==" crossorigin="anonymous" referrerpolicy="no-referrer">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.1/css/jquery.dataTables.css">
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.13.1/js/jquery.dataTables.js"></script>
<link rel="stylesheet" type="text/css" href="../../../css/menup.css">
<link rel="stylesheet" type="text/css" href="../../../css/consueppc1.css">
<link rel="stylesheet" type="text/css" href="../../../css/consul.css">
<title>CONSULTA EPP REPOSICION</title>
<link rel="icon" type="image/png" href="../../../img/icono.png">
</head>
<body style="height: 100vh;background-image: linear-gradient(to right, #e2e2e2, #ffe5c9);">
<div class="wrapper" style="background-image: linear-gradient(to right, #e2e2e2, #ffe5c9);display: flex;align-items: center;flex-direction: column;justify-content: center;width: 100%;min-height: 100%;padding: 20px;background-repeat: no-repeat;background-position: top center;">
<FORM action="CONSUEPPC1.PHP" method="post" style="background: white;border-radius: 25px;padding: 10px; box-shadow: 0px 10px 20px 10px rgb(0 0 0 / 10%);">
<table>
<tr>
<td height="87">
<center class="centerTitulo" style="margin-bottom: 20px;">
<H3>CONSULTA INVENTARIO EPP NUEVO</H3>
</center>
</td>
</tr>
</table>
<CENTER>
<table style="width: 95%; box-shadow: 0px 10px 20px 10px rgb(0 0 0 / 10%);" class="table table-bordered" id="tablaManual">
<thead style="background-color: rgb(255, 138, 55); color: white;">
<tr>
<th style="vertical-align: middle;"><strong><center>ID</center></strong></th>
<th style="vertical-align: middle;"><strong><center>CODIGO</center></strong></th>
<th style="vertical-align: middle;"><strong><center>DESCRIPCION</center></strong></th>
<th style="vertical-align: middle;"><strong><center>CANTIDAD</center></strong></th>
</tr>
</thead>
<tbody>
<?php
$consulta_inventario = $conexion->query("SELECT ID, CODIGO, DESCRIPCION, CANTIDAD FROM inventariousado");
if ($consulta_inventario->num_rows > 0) {
while ($fila_inventario = $consulta_inventario->fetch_assoc()) {
echo "<tr>
<td><center><b>{$fila_inventario['ID']}</b></center></td>
<td><center><b>{$fila_inventario['CODIGO']}</b></center></td>
<td><center><b>{$fila_inventario['DESCRIPCION']}</b></center></td>
<td><center><b>{$fila_inventario['CANTIDAD']}</b></center></td>
</tr>";
}
} else {
echo "<tr><td colspan='4'><center>No se encontraron registros</center></td></tr>";
}
?>
</tbody>
</table>
<a class="btn btn-green btn-lg" href="excelReposicion.php"><i class="fa-solid fa-file-excel" style="margin-right: 8px;"></i>Descargar inventario</a>
<a class="btn btn-red btn-lg" href="../../dotacion/menup.PHP"><i class="fa-solid fa-circle-arrow-left"></i></a>
<br>
<a class="btn-orange" href="../movimiento.php">Movimiento inventario</a>
<p> </p>
</CENTER>
</form>
</div>
<script>
$(document).ready(function() {
$('#tablaManual').DataTable({
language: {
"decimal": "",
"emptyTable": "No hay información",
"info": "Mostrando _START_ a _END_ de _TOTAL_ Entradas",
"infoEmpty": "Mostrando 0 to 0 of 0 Entradas",
"infoFiltered": "(Filtrado de _MAX_ total entradas)",
"infoPostFix": "",
"thousands": ",",
"lengthMenu": "Mostrar _MENU_ Entradas",
"loadingRecords": "Cargando...",
"processing": "Procesando...",
"search": "Buscar:",
"zeroRecords": "Sin resultados encontrados",
"paginate": {
"first": "Primero",
"last": "Ultimo",
"next": "Siguiente",
"previous": "Anterior"
}
}
});
});
</script>
<script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.4/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js" integrity="sha384-w76AqPfDkMBDXo30jS1Sgez6pr3x5MlQ1ZAGC+nuZB+EYdgRZgiwxhTBTkF7CXvN" crossorigin="anonymous"></script>
</body>
</html>