| Server IP : 74.208.127.88 / Your IP : 216.73.216.37 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>
<!-- Bootstrap JS -->
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.bundle.min.js"></script>
<script>
$(document).ready(function() {
$('#miTabla').DataTable();
$('#toggleMoreInfo').click(function() {
$('.extra-info').toggle();
});
});
</script>
</head>
<body>
<div class="container mt-5">
<h2>Lista de Pagos</h2>
<table id="miTabla" class="table table-bordered">
<thead>
<tr>
<th>Folio</th>
<th>Contrato ID</th>
<th>Pago</th>
<th>Fecha de Pago</th>
<th>ID del Recolector</th>
<th>Programado</th>
<th>Acciones</th>
</tr>
</thead>
<tbody>
<?php
// Realizamos la consulta para obtener los datos
$sql = "SELECT CASE
WHEN id_collector = 0 OR id_collector IS NULL THEN 'S/C Asignado'
ELSE id_collector
END AS id_collector,
id,payment_type_id,sale_id,person_id,val,pay_date,programmed FROM payment order by pay_date DESC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Mostramos los datos en filas
while($row = $result->fetch_assoc()) {
if (isset($row["sale_id"])){
echo "<tr>
<td>" .
$row["sale_id"]
. "</td>
<td>" . $row["person_id"] . "</td>
<td>" . $row["val"] . "</td>
<td>" . $row["pay_date"] . "</td>
<td>" . $row["id_collector"] . "</td>
<td>" . ($row["programmed"] ? "Sí" : "No") . "</td>
<td>
<button class='btn btn-warning btn-sm' id ='deletePayment' onclick='editar(" . $row["id"] . ", \"" . $row["val"] . "\", \"" . $row["pay_date"] . "\", \"" . $row["person_id"] . "\")'>Editar</button>
<button class='btn btn-danger btn-sm' onclick='borrar(" . $row["id"] . ")'>Borrar</button>
</td>
</tr>";
}else{
echo "<tr>
<td> Pago: " .
$row["id"]
. "</td>
<td>" . $row["person_id"] . "</td>
<td>" . $row["val"] . "</td>
<td>" . $row["pay_date"] . "</td>
<td>" . $row["id_collector"] . "</td>
<td>" . ($row["programmed"] ? "Sí" : "No") . "</td>
<td>
<button class='btn btn-warning btn-sm' onclick='editar(" . $row["id"] . ", \"" . $row["val"] . "\", \"" . $row["pay_date"] . "\", \"" . $row["person_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>
<!-- Modal para editar -->
<div class="modal fade" id="editModal" tabindex="-1" role="dialog" aria-labelledby="editModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="editModalLabel">Editar Pago</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form id="editForm">
<input type="hidden" id="editId">
<div class="form-group">
<label for="editVal">Contrato:</label>
<input type="number" class="form-control" id="editPersonId" disabled>
</div>
<div class="form-group">
<label for="editVal">Pago Nuevo:</label>
<input type="number" class="form-control" id="editVal" step="any" required>
</div>
<div class="form-group">
<label for="editPayDate">Fecha de Pago:</label>
<input type="datetime-local" class="form-control" id="editPayDate" required>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cerrar</button>
<button type="button" class="btn btn-primary" onclick="guardarEdicion()">Guardar cambios</button>
</div>
</div>
</div>
</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 = "api.php?id=" + id; // Crear archivo borrar.php
}
}
// Eliminar pago
$(document).on('click', '.deletePayment', function() {
let paymentId = $(this).data('id');
if (confirm('¿Estás seguro de que deseas eliminar este pago?')) {
$.ajax({
url: 'api.php',
method: 'POST',
data: { action: 'delete', id: paymentId },
success: function(response) {
alert('Pago eliminado');
loadPayments();
}
});
}
});
$(document).ready(function() {
$('#miTabla').DataTable();
});
// Función para editar
function editar(id, val, pay_date, person_id) {
// Establecer los valores en el formulario del modal editperson_id
$('#editPersonId').val(person_id); // Establecer el person_id en el modal
$('#editId').val(id);
$('#editVal').val(val);
$('#editPayDate').val(pay_date);
// Mostrar el modal
$('#editModal').modal('show');
}
// Función para enviar los datos editados
function guardarEdicion() {
var id = $('#editId').val();
var val = $('#editVal').val();
var pay_date = $('#editPayDate').val();
$.ajax({
url: 'payment_action.php',
type: 'POST',
data: {
id: id,
val: val,
pay_date: pay_date
},
success: function(response) {
alert(response);
// Cerrar el modal
$('#editModal').modal('hide');
// Recargar la página para ver los cambios
location.reload();
}
});
}
</script>
</body>
</html>