File: /home/asjudine/www/consulta_pagos_redencion2.php
<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;
$espacio = ' ';
$linea = '-';
require_once("Conectarse.php");
//SE BUSCA EN LA TALA DE REDENCION PARA BONOS
$consultabonos = mysql_query('SELECT bono1, bono2, bono3, bono4, bono5 FROM redencion_bonos where cedula = "' . $_GET[ced2] . '" ');
if (!$consultabonos) {die('Invalid query bonos: ' . mysql_error());}
list($bono1,$bono2,$bono3,$bono4,$bono5) = mysql_fetch_row($consultabonos);
$resu = mysql_query('SELECT cedula,ced_ciudad,nombre,fecha,direccion,ciudad,telefono,celular,email,unidad,codigo_plan , numero_cuenta,banco,codigo_asesor,codigo_militar,grado,codigo_sucursal,con_valor_mensual, con_valor_total,fecha_nac,numero_libranza,numero_contrato,renovacion_cuotas,permanencia,bono,numero_bono,bono1,bono2,bono3,bono4,bono5,bono6,bono7,bono8,bono9,bono10,bono11,bono12,bono13,bono14,bono15,bono16,bono17,bono18,bono19,bono20,bono21,redbono1,redbono2,redbono3,redbono4,redbono5,redbono6,redbono7,redbono8,redbono9,redbono10,redbono11,redbono12,redbono13,redbono14,redbono15,redbono16,redbono17,redbono18,redbono19,redbono20,redbono21 FROM redencion_bonos WHERE cedula = "'.$_GET[ced2].'" and numero_contrato = "'.$_GET[numcon].'" ');
if (!$resu) {
die('Invalid query sasa: ' . mysql_error());
}
list($cedula, $ced_ciudad, $apes, $fechs, $direccion, $ciudad, $telefono, $celular, $email, $unidad, $plant, $numero_cuenta, $banco, $ase1, $codm, $grado, $sucur, $val_menj, $val_ment, $fechanac, $numero_libranza, $numero_contrato,$renovacion_cuotas,$permanencia,$bono,$numbono,$bono1,$bono2,$bono3,$bono4,$bono5,$bono6,$bono7,$bono8,$bono9,$bono10,$bono11,$bono12,$bono13,$bono14,$bono15,$bono16,$bono17,$bono18,$bono19,$bono20,$bono21,$redbono1,$redbono2,$redbono3,$redbono4,$redbono5,$redbono6,$redbono7,$redbono8,$redbono9,$redbono10,$redbono11,$redbono12,$redbono13,$redbono14,$redbono15,$redbono16,$redbono17,$redbono18,$redbono19,$redbono20,$redbono21) = mysql_fetch_row($resu);
//$valortotabono= $numbono*50000;
$sqlo = mysql_query('SELECT vendedor FROM vendedores WHERE codigo = "' ."$ase1". '"');
if (!$sqlo) {
die('Invalid query sa: ' . mysql_error());
}
list($ase1) = mysql_fetch_row($sqlo);
$resul4 = mysql_query('SELECT nombre FROM sucursal WHERE codigo = "'.$sucur.'" ');
if (!$resul4) {
die('Invalid query ooo: ' . mysql_error());
}
list($sucur) = mysql_fetch_row($resul4);
$resul5 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "'.$plant.'" ');
if (!$resul5) {
die('Invalid query ooo: ' . mysql_error());
}
list($plant) = mysql_fetch_row($resul5);
if(isset($_POST["guardar"]))
{
$mssql = mysql_query("UPDATE redencion_bonos set numero_bono= '".$_POST[numbono]."'WHERE cedula= '".$_GET[ced2]."' and numero_contrato = '".$_GET[numcon]."' ");
if (!$mssql) {
die('Invalid query udate: ' . mysql_error());
}
echo "<script>alert('Los datos fueron Guardados ');</script>";
}
$sql2 = mysql_query('SELECT * FROM descuentos order by codigo ');
if (!$sql2) {
die('Invalid query m2: ' . mysql_error());
}
$row_sql2 = mysql_fetch_assoc($sql2);
$totalRows_sql2 = mysql_num_rows($sql2);
$sql3 = mysql_query('SELECT * FROM descuentos order by codigo ');
if (!$sql3) {
die('Invalid query 3: ' . mysql_error());
}
$row_sql3 = mysql_fetch_assoc($sql3);
$totalRows_sql3 = mysql_num_rows($sql3);
$sql4 = mysql_query('SELECT * FROM vendedores WHERE (tipo = "AC" || tipo = "AE") and estado = "1" order by vendedor ');
if (!$sql4) {
die('Invalid query: ' . mysql_error());
}
$row_sql4 = mysql_fetch_assoc($sql4);
$totalRows_sql4 = mysql_num_rows($sql4);
$sql5 = mysql_query('SELECT * FROM sucursal order by nombre ');
if (!$sql5) {
die('Invalid query: ' . mysql_error());
}
$row_sql5 = mysql_fetch_assoc($sql5);
$totalRows_sql5 = mysql_num_rows($sql5);
$sql7 = mysql_query('SELECT * FROM planes_contratos WHERE estado = "1" order by codigo ');
if (!$sql7) {
die('Invalid query: ' . mysql_error());
}
$row_sql7 = mysql_fetch_assoc($sql7);
$totalRows_sql7 = mysql_num_rows($sql7);
$sql8 = mysql_query('SELECT * FROM director_ventas order by nombre ');
if (!$sql8) {
die('Invalid query: ' . mysql_error());
}
$row_sql8 = mysql_fetch_assoc($sql8);
$totalRows_sql8 = mysql_num_rows($sql8);
$sql8 = mysql_query('SELECT * FROM sucursal order by nombre ');
if (!$sql8) {
die('Invalid query: ' . mysql_error());
}
$row_sql8 = mysql_fetch_assoc($sql8);
$totalRows_sql8 = mysql_num_rows($sql8);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>INGRESAR SOLICITUD DE CREDITO</title>
<style type="text/css">
<!--
.est_cont5 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
font-style: normal;
font-weight: normal;
background-color: #EDFAF4;
margin: 2px;
padding: 2px;
height: auto;
width: auto;
border: thin groove #E9AAF0;
color: #C72350;
}
.color_fondo_sc {
background-color: #DCE0E4;
}
.Estilo1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 16px;
font-style: normal;
font-weight: bold;
background-color: #D6ECFE;
margin: 2px;
padding: 2px;
height: auto;
width: auto;
border: thin groove #E9AAF0;
color: #C72350;
}
body {
background-image: url(ELEMENTOS/gri06.jpg );
}
.Estilo2 {
font-size: 14px;
font-weight: bold;
}
.est_cont2 {
font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #2B39EC;
background-color: #F0F5CF;
height: 18px;
width: auto;
border: thin solid #FABF85;
}
.est_cont6 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 11px;
font-style: normal;
font-weight: normal;
color: #006262;
background-color: #EDFED3;
margin: 1px;
padding: 1px;
height: auto;
width: auto;
border: thin solid #D9B6F8;
}
.Estilo3 {
color: #C72350;
font-weight: bold;
}
.sol_cre1 {
font-family: "Times New Roman", Times, serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #0B3495;
background-color: #E6FAFF;
margin: 1px;
padding: 1px;
height: 18px;
width: auto;
border: thin outset #56AD95;
}
.col_cre2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
font-weight: bold;
color: #F92F0B;
background-color: #B3D9F0;
height: auto;
width: auto;
border: medium groove #FC9227;
}
.Estilo50 {color: #CC3333;
font-family: "Arial Narrow";
font-weight: bold;
}
.Estilo52 {color: #FF6633;
font-size: 16px;
}
.Estilo53 {color: #2492FF;
font-weight: bold;
}
.recaudo {font-family: "Courier New", Courier, monospace;
font-size: 12px;
font-style: normal;
font-weight: bold;
font-variant: normal;
color: #000000;
background-color: #B6CBDC;
margin: 4px;
padding: 8px;
width: auto;
border: medium outset #339966;
}
.Estilo54 {
color: #7DD096;
font-weight: bold;
}
.campo1 {background-color: #B7FFFF;
border: thin dashed #B6B6B6;
}
.campo1 {font-family: "Courier New", Courier, monospace;
font-size: 16px;
font-style: normal;
font-weight: bold;
background-color: #E1EFFD;
border: thin doble #009999;
}
.campo1 { font-family: "Courier New", Courier, monospace;
font-size: 11px;
color: #5151FF;
background-color: #C4E4FD;
border: thin solid #009999;
height: 18px;
width: auto;
}
.datos1 {font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 16px;
font-style: normal;
text-decoration: blink;
background-color: #CCFFCC;
margin: 5px;
padding: 7px;
height: auto;
width: auto;
border: thin solid #0099FF;
}
.datos1 {font-family: Georgia, "Times New Roman", Times, serif;
font-size: 16px;
background-color: #FDE0C1;
margin: 2px;
padding: 3px;
border: medium doble #DBAED7;
}
.datos1 { font-family: Georgia, "Times New Roman", Times, serif;
font-size: 11px;
font-weight: normal;
background-color: #B8F5E8;
margin: 4px;
padding: 5px;
border: thin outset #009999;
}
.datos2 { font-family: "Courier New", Courier, monospace;
font-size: 10px;
font-style: normal;
font-weight: normal;
color: #0033FF;
background-color: #FFE2C6;
margin: 2px;
padding: 3px;
border: medium doble #EEBFEB;
}
.datos3 { font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
font-style: normal;
font-weight: normal;
color: #FF3300;
background-color: #A6ECD7;
margin: 4px;
padding: 4px;
border: medium groove #CCCCFF;
}
.go { font-family: "Times New Roman", Times, serif;
font-size: 9px;
font-style: normal;
color: #FF6633;
background-color: #FBDCBD;
padding: 1px;
height: auto;
width: auto;
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
}
.Estilo64 {
font-size:12px;
font-weight: bold;
color: #000000;
}
.Estilo65 {color: #C72350}
.Estilo66 {
font-size: 12px;
font-weight: bold;
}
.label {background-color: #FFFFCC; font-size: 16px; font-family: Arial; color:#0000CC; display: block;}
-->
</style>
<script Language="JavaScript">
function validarEntero(valor){
//intento convertir a entero.
//si era un entero no le afecta, si no lo era lo intenta convertir
valor = parseInt(valor)
//Compruebo si es un valor numérico
if (isNaN(valor)) {
//entonces (no es numero) devuelvo el valor cadena vacia
return ""
}else{
//En caso contrario (Si era un número) devuelvo el valor
return valor
}
}
/*
function valida_envia(){
//valido la fecha solicitud
if (document.form1.fechas.value=="0000-00-00"){
alert("Tiene que escribir la Fecha de Solicitud")
document.form1.fechas.focus()
return (false);
}
//valido la cedula
if (document.form1.ced.value==""){
alert("Tiene que escribir el numero de cedula")
document.form1.ced.focus()
return (false);
}
if (document.form1.numcont.value==""){
alert("Tiene que escribir el numero de Contrato")
document.form1.numcont.focus()
return (false);
}
//valido la fecha dia de nacimiento
if (document.form1.num_lib.value==""){
alert("Tiene que escribir el numero de Libranza")
document.form1.num_lib.focus()
return (false);
}
return (true);
}*/
</script>
</head>
<body >
<form action="" method="post" onsubmit="return valida_envia()" enctype="multipart/form-data" name="form1" class="color_fondo_sc" id="form1">
<center> <img src="ELEMENTOS\CABEZOTE SERVIASJUDINET.jpg" WIDTH=60% > </center>
<div align="center">
<div class="Estilo3">PAGO DE BONOS</div>
<table width="980" border="8" cellpadding="1" cellspacing="1" class="Estilo2">
<caption>
<div align="center" class="Estilo65"><br />
DATOS BASICOS <br />
</div>
</caption>
<tr>
<th scope="col"> </th>
<th scope="col"><div align="right">
<div align="right"><strong>Fecha Afiliacion: </strong> </div>Año-Mes-dia
</div></th>
<th width="135" scope="col"><div align="left">
<input name="fechas" type="text" class="Estilo2" id="fechas" value="<?php echo $fechs ?>" size="10" maxlength="10" readonly=""/>
</div></th>
<th width="152" scope="col"><div align="right"><strong>Sucursal :</strong></div></th>
<th colspan="3" scope="col">
<input name="sucur" type="text" class="Estilo2" id="sucur" value="<?php echo $sucur ?>" size="20" maxlength="20" readonly=""/>
</tr>
<tr>
<td width="86"><div align="right"><strong>Apellidos y Nombres:</strong></div></td>
<td colspan="3"><div align="left">
<input name="ape" type="text" class="Estilo66" id="ape" value="<?php echo $apes ?>" size="66" maxlength="65" readonly=""/>
</div></td>
<td width="143"><div align="right"><strong>Cogido Militar :</strong></div></td>
<td colspan="2"><div align="left">
<input name="codigom" type="text" class="Estilo2" id="codigom" value="<?php echo $codm ?>" size="20" maxlength="20" readonly=""/>
</div></td>
</tr>
<tr>
<td height="21"><div align="right"><strong>Cedula No:</strong></div></td>
<td width="149"><div align="left">
<input name="ced" type="text" class="Estilo2" id="ced" value="<?php echo $cedula ?>" size="20" maxlength="20" readonly=""/>
</div></td>
<td><div align="right"><strong>De:</strong></div></td>
<td><div align="left">
<input name="ciuced" type="text" class="Estilo2" id="ciuced" value="<?php echo $ced_ciudad ?>" size="20" maxlength="20" readonly=""/>
</div></td>
<td><div align="right"><strong>Unidad :</strong></div></td>
<td colspan="2"><div align="left">
<input name="uni" type="text" class="Estilo2" id="uni" value="<?php echo $unidad ?>" size="35" maxlength="35" readonly=""/>
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Ciudad :</strong></div></td>
<td><div align="left">
<input name="ciu" type="text" class="Estilo2" id="ciu" value="<?php echo $ciudad ?>" size="20" maxlength="20" readonly=""/>
</div></td>
<td><div align="right"><strong>Direccion :</strong></div></td>
<td colspan="2"><div align="left">
<input name="dir" type="text" class="Estilo2" id="dir" value="<?php echo $direccion ?>" size="40" maxlength="40" readonly=""/>
</div></td>
<td width="147"><div align="right"><strong>Grado :</strong></div></td>
<td width="107"><div align="left">
<input name="gra" type="text" class="Estilo2" id="gra" value="<?php echo $grado ?>" size="12" maxlength="10" readonly=""/>
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Telefono :</strong></div></td>
<td><div align="left">
<input name="tel" type="text" class="Estilo2" id="tel" value="<?php echo $telefono ?>" size="20" maxlength="20" readonly=""/>
</div></td>
<td><div align="right"><strong>Celular :</strong></div></td>
<td>
<div align="left">
<input name="cel" type="text" class="Estilo2" id="cel" value="<?php echo $celular ?>" size="20" maxlength="20" readonly=""/>
</div></td>
<td><div align="right"><strong>E-mail :</strong></div></td>
<td colspan="2"><div align="left">
<input name="email" type="text" class="Estilo2" id="email" value="<?php echo $email ?>" size="35" maxlength="35" readonly=""/>
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Plan :</strong></div></td>
<td>
<input name="plant" type="text" class="Estilo2" id="plant" value="<?php echo $plant ?>" size="5" maxlength="5" readonly=""/>
</td>
<td><div align="right"><strong>Cuenta No :</strong></div></td>
<td><div align="left">
<input name="cue" type="text" class="Estilo2" id="cue" value="<?php echo $numero_cuenta ?>" size="20" maxlength="20" readonly=""/>
</div></td>
<td><div align="right"><strong>Banco :</strong></div></td>
<td colspan="2"><div align="left">
<input name="ban" type="text" class="Estilo2" id="ban" value="<?php echo $banco ?>" size="20" maxlength="20" readonly=""/>
</div></td>
</tr>
<tr>
<td height="28"><div align="right"><strong>Numero Contrato :</strong></div></td>
<td><div align="left">
<input name="numcont" type="text" class="Estilo2" id="numcont" value="<?php echo $numero_contrato ?>" size="12" maxlength="10" readonly=""/>
</div></td>
<td><div align="right"><strong>Fecha Nacimiento :</strong></div></td>
<td><div align="left">
<span class="Estilo64">dia-mes</span>
<input name="fechanac" type="text" class="Estilo2" id="fechanac" value="<?php echo $fechanac ?>" size="6" maxlength="6" readonly=""/>
</div></td>
<td><div align="right"><strong>Vendedor :</strong></div></td>
<td colspan="2" align="left">
<input name="ase1" type="text" class="Estilo2" id="ase1" value="<?php echo $ase1 ?>" size="20" maxlength="20" readonly=""/>
</tr>
<tr>
<td height="28"><div align="right"><strong>Renovacion Cuotas :</strong></div></td>
<td>
<input name="renovacion_cuotas" type="text" class="Estilo2" id="renovacion_cuotas" value="<?php echo $renovacion_cuotas ?>" size="20" maxlength="20"/>
<td height="28"><div align="right"><strong>Permanencia :</strong></div></td>
<td><div align="left">
<input name="permanencia" type="text" class="Estilo2" id="permanencia" value="<?php echo $permanencia?>" size="12" maxlength="10" readonly=""/>
</div></td>
<td><div align="right"><strong>Numero libranza:</strong></div></td>
<td colspan="2"><div align="left">
<input name="num_lib" type="text" class="Estilo2" id="num_lib" value="<?php echo $numero_libranza ?>" size="12" maxlength="12">
</div></td>
</tr>
<tr>
<td height="28"><div align="right" class="Estilo3"><strong>Valor Total Bonos :</strong></div></td>
<td>
<input name="valortotabono" type="text" class="Estilo2" id="valortotalbon" value="<?php echo $valortotabono ?>" size="20" maxlength="20"/>
<td colspan="1"><div align="right" class="Estilo3"><strong>Bono:</strong></div></td>
<td><div align="left">
<input name="bono" type="text" class="Estilo2" id="bono" value="<?php echo $bono ?>" size="4" maxlength="4"/>
<td colspan="2" bgcolor="#DCE0E4"><div align="right" class="Estilo3"><strong>Numero De Bonos:</strong></div></td>
<td><div align="left">
<input name="numbono" type="text" class="Estilo2" id="numbono" value="<?php echo $numbono?>" size="12" maxlength="12" />
</div></td>
<td width="4"><div align="right"><strong></strong></div></td>
</tr>
<tr>
<td></td>
<td height="28"><div align="right"><strong>BONO 1 :</strong>
<?php
if($redbono1 != "SI")
{
echo "<input type='button' value='$bono1' name=boton class=Estilo53 onClick =window.open('formulario_redencion_bonos.php?cedula=$cedula&bono=$bono1&redbono=bono1','','top=50,left=100,toolbar=no,scrollbars=yes,width=800,height=450,status=yes')></a>";
}else
{
?>
<input name="bono1" type="text" class="Estilo2" id="bono1" value="<?php echo $bono1?>" size="12" maxlength="10" readonly=""/>
<?php
}
?>
</div></td>
<td height="28"><div align="right"><strong></strong>BONO 2
<!--************************************-->
<?php
if($redbono2 != "SI")
{
echo "<input type='button' value='$bono2' name=boton class=Estilo53 onClick =window.open('formulario_redencion_bonos.php?cedula=$cedula&bono=$bono2&redbono=bono2','','top=50,left=100,toolbar=no,scrollbars=yes,width=800,height=450,status=yes')></a>";
}else
{
?>
<input name="bono1" type="text" class="Estilo2" id="bono1" value="<?php echo $bono2?>" size="12" maxlength="10" readonly=""/>
<?php
}
?>
</div></td>
<td><div align="right"><strong>BONO 3</strong>
<!--************************************-->
<?php
if($redbono3 != "SI")
{
echo "<input type='button' value='$bono3' name=boton class=Estilo53 onClick =window.open('formulario_redencion_bonos.php?cedula=$cedula&bono=$bono3&redbono=bono3','','top=50,left=100,toolbar=no,scrollbars=yes,width=800,height=450,status=yes')></a>";
}else
{
?>
<input name="bono1" type="text" class="Estilo2" id="bono1" value="<?php echo $bono3?>" size="12" maxlength="10" readonly=""/>
<?php
}
?>
</div></td>
<td ><div align="right">BONO 4
<!--************************************-->
<?php
if($redbono4 != "SI")
{
echo "<input type='button' value='$bono4' name=boton class=Estilo53 onClick =window.open('formulario_redencion_bonos.php?cedula=$cedula&bono=$bono4&redbono=bono4','','top=50,left=100,toolbar=no,scrollbars=yes,width=800,height=450,status=yes')></a>";
}else
{
?>
<input name="bono1" type="text" class="Estilo2" id="bono1" value="<?php echo $bono4?>" size="12" maxlength="10" readonly=""/>
<?php
}
?>
</div></td>
<td ><div align="right">BONO 5
<!--************************************-->
<?php
if($redbono5 != "SI")
{
echo "<input type='button' value='$bono5' name=boton class=Estilo53 onClick =window.open('formulario_redencion_bonos.php?cedula=$cedula&bono=$bono5&redbono=bono5','','top=50,left=100,toolbar=no,scrollbars=yes,width=800,height=450,status=yes')></a>";
}else
{
?>
<input name="bono1" type="text" class="Estilo2" id="bono1" value="<?php echo $bono5?>" size="12" maxlength="10" readonly=""/>
<?php
}
?>
</tr>
</tr>
<tr>
</tr>
</table>
<p class="Estilo2"> </p>
<p>
<label>
<input name="guardar" type="submit" class="Estilo53" id="guardar" value="GUARDAR" />
<input name="menu2" type="button" class="Estilo50" id="menu2" onclick="window.location.href='consulta_redencion.php'" value="REGRESAR" />
</label>
</p>
</div>
</form>
</body>
</html>