| Server IP : 74.208.127.88 / Your IP : 216.73.216.205 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/muebles/application/payment/nppBackup/ |
Upload File : |
<?php
$servername = "localhost";
$username = "root"; // tu usuario
$password = "Hues198020"; // tu contraseña
$dbname = "victoria"; // nombre de tu base de datos
// Crear conexión
$conn = new mysqli($servername, $username, $password, $dbname);
// Comprobar la conexión
if ($conn->connect_error) {
die("Conexión fallida: " . $conn->connect_error);
}
?>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Lista de Pagos</title>
<!-- Bootstrap CSS -->
<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
<!-- DataTables CSS -->
<link href="https://cdn.datatables.net/1.10.21/css/jquery.dataTables.min.css" rel="stylesheet">
<!-- jQuery y DataTables JS -->
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
<script>
$(document).ready(function() {
$('#miTabla').DataTable();
});
</script>
</head>
<body>
<div class="container mt-5">
<h2>Lista de Pagos</h2>
<table id="miTabla" class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Tipo de Pago</th>
<th>Venta ID</th>
<th>Persona ID</th>
<th>Semana</th>
<th>Valor</th>
<th>Fecha de Pago</th>
<th>ID del Recolector</th>
<th>Programado</th>
<th>Nota</th>
<th>Fecha de Creación</th>
<th>Acciones</th>
</tr>
</thead>
<tbody>
<?php
// Realizamos la consulta para obtener los datos
$sql = "SELECT * FROM payment order by id ASC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Mostramos los datos en filas
while($row = $result->fetch_assoc()) {
echo "<tr>
<td>" . $row["id"] . "</td>
<td>" . $row["payment_type_id"] . "</td>
<td>" . $row["sale_id"] . "</td>
<td>" . $row["person_id"] . "</td>
<td>" . $row["week"] . "</td>
<td>" . $row["val"] . "</td>
<td>" . $row["pay_date"] . "</td>
<td>" . $row["id_collector"] . "</td>
<td>" . ($row["programmed"] ? "Sí" : "No") . "</td>
<td>" . $row["note"] . "</td>
<td>" . $row["created_at"] . "</td>
<td>
<button class='btn btn-warning btn-sm' onclick='editar(" . $row["id"] . ")'>Editar</button>
<button class='btn btn-danger btn-sm' onclick='borrar(" . $row["id"] . ")'>Borrar</button>
</td>
</tr>";
}
} else {
echo "<tr><td colspan='12'>No hay pagos disponibles</td></tr>";
}
?>
</tbody>
</table>
</div>
<!-- Bootstrap y jQuery -->
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.bundle.min.js"></script>
<script>
// Función para editar
function editar(id) {
// Aquí puedes redirigir a un formulario de edición con el ID
alert("Editar pago con ID: " + id);
}
// Función para borrar
function borrar(id) {
if (confirm("¿Estás seguro de eliminar este pago?")) {
// Realiza una petición AJAX para eliminar el pago
window.location.href = "borrar.php?id=" + id; // Crear archivo borrar.php
}
}
</script>
</body>
</html>