carpeta-videos
tsj-C--carpeta-HECHOS
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- jQuery -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/2.1.2/sweetalert.min.js" integrity="sha512-AA1Bzp5Q0K1KanKKmvN/4d3IRKVlv9PYgwFPvm32nPO6QS8yH1HO7LbgB1pgiOxPtfeg5zEn2ba64MUcqJx6CA==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.10.3/dist/sweetalert2.all.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/sweetalert2@11.10.3/dist/sweetalert2.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<input type="hidden" name="carpeta" id="carpeta" value="<?php //echo "C-10-34";?>">
<?php
class Conexion{
static public function conectar()
{
$conexion = new PDO ("mysql:host=localhost;dbname=dbaudiencias", "root","");
$conexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $conexion;
}
}
class AudienciaExpModel extends Conexion{
static public function AudienciaExpVistasModels($tabla, $nombre = null)
{
if ($nombre) {
$stmt = Conexion::conectar()->prepare("SELECT * FROM $tabla WHERE nombre = :nombre");
$stmt->bindParam(":nombre", $nombre, PDO::PARAM_STR);
} else {
$stmt= Conexion::conectar()->prepare("SELECT * FROM $tabla");
}
$stmt->execute();
return $stmt->fetchAll();
}
}
?>
<br>
<?php
$carpetas = new AudienciaExpController();
?>
<table id="audiencia-carpetas" class="table">
<thead class="thead-dark">
<tr>
<th>id</th>
<th>tipoaudiencia</th>
<th>Resolvio</th>
<th>Acta</th>
<th>Video</th>
</tr>
</thead>
<!--Muestra todas las carpetas -->
<tbody id="tablaCarpetas">
<?php
$carpetas->AudienciaExpVistasController();
?>
</tbody>
</table>
<?php
class AudienciaExpController{
# Muestra todas las carpetas - llama los métodos CreateCarpeta, AsignarCarpeta, Historial
public function AudienciaExpVistasController()
{
// Obtener el valor de la carpeta desde $_GET-$carpeta = isset($_GET['carpeta']) ? $_GET['carpeta'] : null;
$nombre = "JO-03/2019";
// Llamar al modelo con o sin filtro de carpeta
$audiencias = AudienciaExpModel::AudienciaExpVistasModels("audiencia", $nombre);
// Renderizar las filas de la tabla
foreach ($audiencias as $audiencia) {
echo '
<tr>
<td>'.$audiencia["id_audiencia"].'</td>
<td>'.$audiencia["tipoaudiencia"].'</td>
<td>Esto esto esto</td>
<td>
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#exampleModal">
A
</button>
<!-- Modal -->
<div class="modal fade" id="exampleModal" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Acta</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
...
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary">Save changes</button>
</div>
</div>
</div>
</div>
</td>
<td>
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#VideoModal">
V
</button>
<!-- Modal -->
<div class="modal fade" id="VideoModal" tabindex="-1" aria-labelledby="VideoModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="VideoModalLabel">Video</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
...
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary">Save changes</button>
</div>
</div>
</div>
</div>
</td>
</tr>
';
}
}
}
?>
<script>
$(document).ready(function() {
$('#audiencia-carpetas').DataTable({
"order": [[ 4, "desc" ]],
pageLength: 4,
lengthMenu: [
[4, 10, 20, -1],
[4, 10, 20, 'Todos']
],
columnDefs: [{
orderable: false,
targets: -1
}],
dom: '<"row"<"col-sm-1 col-md-1"l><"col-sm-8 col-md-8"f><"col-sm-3 col-md-3"<"dt-buttons btn-group flex-wrap"B>>>t<"row"<"col-sm-12 col-md-3"p><"col-sm-12 col-md-7"i>>',
botones: [{
text: 'csv',
extend: 'csvHtml5',
},
{
texto: 'excel',
extensión: 'excelHtml5',
},
{
texto: 'pdf',
extensión: 'pdfHtml5',
},
{
texto: 'imprimir',
extend: 'print',
},
]
});
});
</script>
</div>
</body>
</html>
Comentarios
Publicar un comentario