| Server IP : 74.208.127.88 / Your IP : 216.73.216.9 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
$host = "localhost";
$user = "root";
$password = "Hues198020";
$dbname = "victoria"; // Cambia esto por el nombre de tu base de datos
$conn = new mysqli($host, $user, $password, $dbname);
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>CRUD con Ajax, Bootstrap y PHP</title>
<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" rel="stylesheet">
<!-- CSS de DataTables -->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css">
<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<!-- JS de DataTables -->
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
<style>
/* Modal */
.modal-header, .modal-footer {
background-color: #f8f9fa;
}
</style>
</head>
<body>
<div class="container mt-5">
<h2>Formulario de Pagos</h2>
<!-- Formulario de ingreso -->
<!-- Botón para abrir el modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#paymentModal">
Abrir de Pago
</button>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Pagos</title>
<!-- CSS de DataTables -->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css">
<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<!-- JS de DataTables -->
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
</head>
<body>
<div class="container">
<table class="table table-bordered" id="paymentsTable">
<thead>
<tr>
<th>ID</th>
<th>Tipo de Pago</th>
<th>ID de Venta</th>
<th>ID de Persona</th>
<th>Semana</th>
<th>Valor</th>
<th>Fecha de Pago</th>
<th>ID del Colector</th>
<th>Programado</th>
<th>Acciones</th>
</tr>
</thead>
<tbody>
<!-- Aquí se generan las filas con los datos, por ejemplo usando PHP -->
<?php
// Asegúrate de cargar los datos correctamente desde la base de datos
$sql = "SELECT * FROM payment";
$result = $conn->query($sql);
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'] == 1 ? 'Sí' : 'No') . "</td>
<td>
<button class='btn btn-primary editPayment' data-id='" . $row['id'] . "'>Editar</button>
<button class='btn btn-danger deletePayment' data-id='" . $row['id'] . "'>Eliminar</button>
</td>
</tr>";
}
?>
</tbody>
</table>
</div>
<script>
$(document).ready(function() {
// Inicializar DataTable
$('#paymentsTable').DataTable();
});
</script>
</body>
</html>
<!-- Modal -->
<div class="modal fade" id="paymentModal" tabindex="-1" role="dialog" aria-labelledby="paymentModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="paymentModalLabel">Formulario de Pago</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Cerrar">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<!-- Formulario -->
<form id="paymentForm">
<div class="form-group">
<label for="payment_type_id">Tipo de Pago</label>
<input type="number" class="form-control" id="payment_type_id" placeholder="ID Tipo de Pago" required>
</div>
<div class="form-group">
<label for="sale_id">ID de Venta</label>
<input type="text" class="form-control" id="sale_id" placeholder="ID de Venta" required>
</div>
<div class="form-group">
<label for="person_id">ID de Persona</label>
<input type="number" class="form-control" id="person_id" placeholder="ID de Persona" required>
</div>
<div class="form-group">
<label for="week">Semana</label>
<input type="number" class="form-control" id="week" placeholder="Semana" required>
</div>
<div class="form-group">
<label for="val">Valor</label>
<input type="number" class="form-control" id="val" placeholder="Valor" required>
</div>
<div class="form-group">
<label for="pay_date">Fecha de Pago</label>
<input type="datetime-local" class="form-control" id="pay_date" required>
</div>
<div class="form-group">
<label for="id_collector">ID del Colector</label>
<input type="number" class="form-control" id="id_collector" placeholder="ID del Colector" required>
</div>
<div class="form-group">
<label for="programmed">Programado</label>
<select class="form-control" id="programmed">
<option value="1">Sí</option>
<option value="0">No</option>
</select>
</div>
<div class="form-group">
<label for="note">Nota</label>
<input type="text" class="form-control" id="note" placeholder="Nota">
</div>
<button type="submit" class="btn btn-primary">Guardar</button>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cerrar</button>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.bundle.min.js"></script>
<script src="app.js"></script>
</body>
</html>