| Server IP : 74.208.127.88 / Your IP : 216.73.216.185 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
date_default_timezone_set("America/Mexico_City");
session_start();
require_once ("../model/dbconn.php");
require_once ("../model/pos.php");
if(isset($_GET['xid_sales'])){
$sale_id = $_GET['xid_sales'];
//obtenemos la venta
$pos = new pos();
$data = $pos->getSale_id($sale_id);
$client = $data[2];
print_r($client[0]);
// Conexión a la base de datos (ajusta según tu configuración)
$host = "localhost";
$dbname = "victoria";
$username = "root";
$password = "Hues198020";
try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password, [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);
// Obtener el contrato del cliente (suponiendo que viene de una variable existente)
$contrato = $client[0]['id_client'];
// Consulta para obtener la fechaPrimerPago desde jobok
$stmt = $pdo->prepare("SELECT paydate as fechaPrimerPago FROM collection_data WHERE contract = :contrato LIMIT 1");
$stmt->bindParam(':contrato', $contrato, PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
//print_r($result);
} catch (PDOException $e) {
die("Error en la conexión: " . $e->getMessage());
}
}
// Si hay resultado, se usa la fecha de primer pago; de lo contrario, se usa la fecha actual
if(isset($result)){
$fechaPrimerPago = $result ? $result['fechaPrimerPago'] : date("Y-m-d");
}else{
$fechaPrimerPago = date("Y-m-d");
}
// Suponiendo que la variable $contrato proviene de la base de datos o una consulta previa
$contrato = isset($client[0]['id_client']) ? $client[0]['id_client'] : "";
$contrato = isset($client[0]['total']) ? $total = $client[0]['total'] + $client[0]['disc_rp'] : $total=0;
$readonly = !empty($contrato) ? "readonly" : "";
if($total > 0){
}else{
}
?>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Editar pago</title>
<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" rel="stylesheet">
<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>
<style>
.titulo-barra {
background-color: black; /* Fondo negro */
color: white; /* Texto blanco */
text-align: center; /* Centrar el texto */
padding: 10px; /* Espaciado interno */
font-size: 24px; /* Tamaño de fuente más grande */
font-weight: bold; /* Negrita */
border-radius: 5px; /* Bordes redondeados opcionales */
}
</style>
</head>
<body>
<div class="titulo-barra">
<h2>Formulario de Pagos</h2>
</div>
<div class="container mt-5">
<div class="container-fluid">
<div class="row justify-content-center">
<div class="col-md-10">
<div class="card">
<div class="card-body">
<div class="form-group">
<label for="created_pay" class="control-label">Fecha de cobro</label>
<input type="date" name="created_pay" min="2018-01-01" max="2035-12-31" class="form-control" id="created_pay" value="<?php echo $fechaPrimerPago; ?>" required>
</div>
<div class="form-group">
<label for="id_collector" class="control-label">Cobrador</label>
<select name="id_collector" id="id_collector" class="form-control">
<option value="0">-- OFICINA --</option>
</select>
</div>
<div class="form-group">
<label for="type_pay" class="control-label">Tipo Pago</label>
<select name="type_pay" id="type_pay" class="form-control">
<option value="0">--Abono--</option>
<option value="1">Enganche</option>
</select>
</div>
<div class="form-group">
<label for="product_code" class="control-label">Contrato</label>
<input type="text" id="product_code" class="form-control" placeholder="Contrato"
value="<?php echo $contrato; ?>" <?php echo $readonly; ?>>
</div>
<?php if($total>0):?>
<div class="form-group">
<label for="total_deuda" class="control-label">Total Credito</label>
<input type="text" id="total_deuda" class="form-control" placeholder="Total adeudado" value="">
</div>
<?php endif;?>
<div class="form-group">
<label for="total_deuda" class="control-label">Saldo de Pagos</label>
<input type="text" id="total_deuda" class="form-control" placeholder="Total adeudado" value="">
</div>
<div class="form-group">
<label for="val" class="control-label">Pago a Recibir*</label>
<input type="text" name="val" id="val" class="form-control" placeholder="Pago a recibir" required readonly>
</div>
<div class="form-group text-center">
<button id="btnsavetrans" type="submit" class="btn btn-primary">Realizar Cobro</button>
<a href="./?view=credit" class="btn btn-danger">Cancelar</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Modal para editar el valor -->
<div class="modal" id="editValModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Editar Valor</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="new_val">Nuevo Valor</label>
<input type="number" class="form-control" id="new_val" placeholder="Nuevo valor">
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cerrar</button>
<button type="button" class="btn btn-primary" id="saveValBtn">Guardar Cambios</button>
</div>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
document.addEventListener("DOMContentLoaded", function () {
// Seleccionar los inputs
let totalInput = document.getElementById("total_deuda"); // Total adeudado
let pagosInput = document.getElementById("pagos"); // Input donde se captura el pago
let valInput = document.getElementById("val"); // Input donde se mostrará la diferencia
// Evento para calcular automáticamente la diferencia
pagosInput.addEventListener("input", function () {
let total = parseFloat(totalInput.value) || 0; // Convertir a número (si está vacío, usar 0)
let pagos = parseFloat(pagosInput.value) || 0;
let diferencia = total - pagos;
valInput.value = diferencia.toFixed(2); // Mostrar con dos decimales
});
});
window.onload = function() {
document.getElementById("total_deuda").focus();
};
</script>
</script>
<script src="app.js"></script>
</body>
</html>