| 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
date_default_timezone_set("America/Mexico_City");
session_start();
require_once ("../model/dbconn.php");
require_once ("../model/pos.php");
$sale_id = $_GET['xid_sales'];
if(isset($sale_id)){
//obtenemos la venta
$pos = new pos();
$data = $pos->getSale_id($sale_id);
$client = $data[2];
// 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->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);
// Si hay resultado, se usa la fecha de primer pago; de lo contrario, se usa la fecha actual
echo $fechaPrimerPago = $result ? $result['fechaPrimerPago'] : date("Y-m-d");
} catch (PDOException $e) {
die("Error en la conexión: " . $e->getMessage());
}
}
?>
<!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>
</head>
<body>
<h2>Formulario de Pagos</h2>
<div class="container mt-5">
<!-- Formulario de ingreso con autocompletado -->
<button class="btn btn-primary" id="editValBtn">Editar Valor</button>
<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 = $result ? $result['fechaPrimerPago'] : date("Y-m-d");?>" 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">Cliente</label>
<input type="text" id="product_code" class="form-control" placeholder="Cliente" value="<?php echo $fechaPrimerPago = $result ? $client->name : date("Y-m-d");; ?>" readonly>
</div>
<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>
</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="app.js"></script>
</body>
</html>