File: /home/asjudine/www/includes/consulta_ced_info_servi.php
<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;
if(isset($_POST["consultar"]))
{
$sqlnom = "select fecha, nombres, cedula, codigo, grado, direccion_envio, ciudad_envio, telefono , celular, email, monto_solicitado, salario, numero_cuotas, valor_mensual , cuenta_ahorros, banco_cuenta, empresa, proveedor from creditos where cedula = '$ced'";
$num=mysql_num_rows($sqlnom);
$control = mysql_query($sqlnom, $dbi) or die(mysql_error());
list($fecha, $apeno, $cedu, $codi, $grad, $dire, $ciue, $tele, $celul, $em, $ms, $sal, $nc, $vm, $cah, $bcu, $el, $pro) = mysql_fetch_array($control);
$sqlnom3 = "select nombre from empresas where codigo = '$el'";
$control3 = mysql_query($sqlnom3, $dbi) or die(mysql_error());
list($el) = mysql_fetch_array($control3);
$sqlnom4 = "select cedula, apellidos_noms, codigo, grado, direccion, celular, telefono, ciudad, email, entidad_laboral, fecha_nacimiento from datos_basicos_rc where cedula = '$ced'";
$control4 = mysql_query($sqlnom4, $dbi) or die(mysql_error());
list($cedulab, $apellidos_nomsb, $codigob, $gradob, $direccionb, $celularb, $telefonob, $ciudadb, $emailb, $entidad_laboralb, $nacimiento) = mysql_fetch_array($control4);
$sqlnom5 = "select sucursal, pagaduria, unidad_desc, cod_desc, entidad_recaudo, libranza, val_contrato, cuotas, valor_cuota, contrato, tipo_contrato, beneficiarios, mes_inicio, ano_inicio, mes_termino, ano_termino, vendedor from info_asjudinet where cedula = '$ced'";
$control5 = mysql_query($sqlnom5, $dbi) or die(mysql_error());
list($sucursal, $pagaduria, $unidad_desc, $cod_desc, $entidad_recaudo, $libranza, $val_contrato, $cuotas, $valor_cuota, $contrato, $tipo_contrato, $beneficiarios, $mes_inicio, $aņo_inicio, $mes_termino, $aņo_termino, $vendedor) = mysql_fetch_array($control5);
}
$sqlnom6 = "select nombre from sucursal where codigo = '$sucursal'";
$control6 = mysql_query($sqlnom6, $dbi) or die(mysql_error());
list($sucursal2) = mysql_fetch_array($control6);
$sqlnom7 = "select nombre from empresas where codigo = '$pagaduria'";
$control7 = mysql_query($sqlnom7, $dbi) or die(mysql_error());
list($pagaduria2) = mysql_fetch_array($control7);
$sqlnom8 = "select nombre from entidades_recaudo where codigo = '$entidad_recaudo'";
$control8 = mysql_query($sqlnom8, $dbi) or die(mysql_error());
list($entidad_recaudo2) = mysql_fetch_array($control8);
$sqlnom9 = "select vendedor from vendedores where codigo = '$vendedor'";
$control9 = mysql_query($sqlnom9, $dbi) or die(mysql_error());
list($vendedor2) = mysql_fetch_array($control9);
?>
<!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=iso-8859-1" />
<title>Documento sin título</title>
<style type="text/css">
<!--
.Estilo10 { font-size: 14px;
font-weight: bold;
}
.Estilo12 {
font-size: 11px
}
.Estilo15 { font-size: 12px;
color: #000000;
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: 12px;
color: #5151FF;
background-color: #C4E4FD;
border: thin solid #009999;
height: 20px;
width: auto;
}
.datos3 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #FF3300;
background-color: #A6ECD7;
margin: 4px;
padding: 4px;
border: medium groove #CCCCFF;
}
body {
background-color: #DCFAF3;
}
.campo {background-color: #FFFFCC; border:1px solid #990000; font-family:Arial; font-size:11px; height: inherit}
.Estilo50 {color: #CC3333;
font-family: "Arial Narrow";
font-weight: bold;
}
.Estilo1 { color: #FF6633;
font-size: 24px;
font-style: italic;
}
.Estilo2 { color: #FF6633;
font-size: 16px;
}
.Estilo3 { 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;
}
.datos2 {
font-family: "Courier New", Courier, monospace;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #0033FF;
background-color: #FFE2C6;
margin: 2px;
padding: 3px;
border: medium doble #EEBFEB;
}
.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;
}
.Estilo8 { font-size: 20px;
font-weight: bold;
}
.Estilo4 { color: #FF1A1A;
font-weight: bold;
}
.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: 12px;
font-weight: normal;
background-color: #B8F5E8;
margin: 4px;
padding: 5px;
border: thin outset #009999;
}
.Estilo52 {font-size: 16px}
.Estilo54 {font-size: 14px}
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<div align="center">
<table width="694" border="3" cellpadding="3" cellspacing="3" class="datos3">
<caption>
<div align="center"><strong><span class="Estilo12"><br />
</span></strong>
<table width="330" border="3" cellpadding="3" cellspacing="3" class="recaudo">
<caption>
<span class="Estilo1">SERVIASJUDINET</span>
</caption>
<tr>
<th colspan="2" scope="col"><label>Digite el Numero de Cedula </label></th>
</tr>
<tr>
<td width="162"><div align="center"><span class="Estilo2">CEDULA : </span></div></td>
<td width="135"><div align="center">
<input name="ced" type="text" id="ced" size="20" maxlength="20" />
</div></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="consultar" type="submit" class="Estilo3" id="consultar" value="Consultar" />
</div></td>
</tr>
</table>
<strong><br />
</strong>
<table width="543" border="3" cellpadding="3" cellspacing="3" class="datos1">
<caption>
<span class="Estilo3"><br />
<span class="Estilo52">DATOS CREDITO </span></span> <br />
</caption>
<tr>
<th scope="col"><div align="right"><span class="Estilo4">Proveedor : </span></div></th>
<th scope="col">
<div align="left">
<input name="proveedorcre" type="text" class="campo1" id="proveedorcre" value="<?php echo $pro ?>" size="20" maxlength="20" readonly=""/>
</div></th>
<th scope="col"><div align="right"><span class="Estilo4">Fecha Credito : </span></div></th>
<th scope="col"><div align="left">
<input name="fechcre" type="text" class="campo1" id="fechcre" value="<?php echo $fecha ?>" size="10" maxlength="10" readonly="" />
</div></th>
</tr>
<tr>
<th width="125" height="32" scope="col"><div align="right"><span class="Estilo4">Monto solicitado : </span></div></th>
<th width="144" scope="col"><div align="left">
<input name="mon_sol" type="text" class="campo1" id="mon_sol" value="<?php echo $ms ?>" size="15" maxlength="12" readonly="" />
<label> </label>
</div></th>
<th width="112" scope="col"><div align="right"><span class="Estilo4">Salario :</span></div></th>
<th width="111" scope="col"><div align="left">
<input name="sala" type="text" class="campo1" id="sala" value="<?php echo $sal ?>" size="15" maxlength="12" readonly="" />
</div></th>
</tr>
<tr>
<td><div align="right"><span class="Estilo4">Numero Cuotas : </span></div></td>
<td><div align="left">
<input name="numerocuo" type="text" class="campo1" id="numerocuo" value="<?php echo $nc ?>" size="5" maxlength="2" readonly="" />
</div></td>
<td><div align="right"><span class="Estilo4">Valor Mensual :</span></div></td>
<td><div align="left">
<input name="valmen" type="text" class="campo1" id="valmen" value="<?php echo $vm ?>" size="15" maxlength="12" readonly="" />
</div></td>
</tr>
<tr>
<td><div align="right"><span class="Estilo4">Numero Cuenta :</span></div></td>
<td><div align="left">
<input name="numcue" type="text" class="campo1" id="numcue" value="<?php echo $cah ?>" size="20" maxlength="20" readonly="" />
</div></td>
<td><div align="right"><span class="Estilo4">Banco Cuenta :</span></div></td>
<td><div align="left">
<input name="bancue" type="text" class="campo1" id="bancue" value="<?php echo $bcu ?>" size="15" maxlength="15" readonly="" />
</div></td>
</tr>
</table>
<table width="655" border="3" cellpadding="3" cellspacing="3" class="datos2">
<caption>
<span class="Estilo8"><br />
<span class="Estilo52">DATOS BASICOS </span></span>
</caption>
<tr>
<td width="88"><span class="Estilo12"><strong>Apellidos y Nombres </strong></span></td>
<td colspan="3"><div align="left">
<input name="apenom" type="text" class="campo1" id="apenom" value="<?php echo $apellidos_nomsb ?>" size="75" maxlength="75" readonly="" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Cedula : </strong></div></td>
<td width="109"><input name="cedb" type="text" class="campo1" id="cedb" value="<?php echo $cedulab ?>" size="15" maxlength="15" readonly="" /></td>
<td width="84"><div align="center" class="Estilo12"><strong>Codigo : </strong></div></td>
<td width="319"><div align="left">
<input name="cod" type="text" class="campo1" id="cod" value="<?php echo $codigob ?>" size="15" maxlength="15" readonly="" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Grado : </strong></div></td>
<td><input name="gra" type="text" class="campo1" id="gra" value="<?php echo $gradob ?>" size="15" maxlength="15" readonly="" /></td>
<td><div align="center" class="Estilo12"><strong>Direccion : </strong></div></td>
<td><input name="dir" type="text" class="campo1" id="dir" value="<?php echo $direccionb ?>" size="45" maxlength="45" readonly="" /></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Celular : </strong></div></td>
<td><input name="cel" type="text" class="campo1" id="cel" value="<?php echo $celularb ?>" size="15" maxlength="15" readonly="" /></td>
<td><div align="center" class="Estilo12"><strong>Telefono : </strong></div></td>
<td><div align="left">
<input name="tel" type="text" class="campo1" id="tel" value="<?php echo $telefonob ?>" size="15" maxlength="15" readonly="" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Ciudad : </strong></div></td>
<td colspan="3"><div align="left">
<input name="ciud" type="text" class="campo1" id="ciud" value="<?php echo $ciudadb ?>" size="25" maxlength="25" readonly="" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Email : </strong></div></td>
<td colspan="3"><div align="left">
<input name="email" type="text" class="campo1" id="email" value="<?php echo $emailb ?>" size="25" maxlength="25" readonly="" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Entidad Laboral: </strong></div></td>
<td colspan="3"><div align="left">
<input name="entlab" type="text" class="campo1" id="entlab" value="<?php echo $entidad_laboralb ?>" size="35" maxlength="35" readonly="" />
</div></td>
</tr>
</table>
<strong><br />
<br />
<span class="Estilo54">INFORMACION SERVIASJUDINET </span><br />
<br />
</strong>
<label></label>
</div>
</caption>
<tr>
<th width="110" scope="col"><div align="right"><span class="Estilo12">Sucursal : </span></div></th>
<th width="181" scope="col"><div align="left">
<input name="ciud2" type="text" class="campo1" id="ciud2" value="<?php echo $sucursal2 ?>" size="25" maxlength="25" readonly="" />
</div></th>
<th width="134" scope="col"><div align="right"><span class="Estilo12">Pagaduria : </span></div></th>
<th width="214" scope="col"><input name="ciud24" type="text" class="campo1" id="ciud24" value="<?php echo $pagaduria2 ?>" size="30" maxlength="30" readonly="" /></th>
</tr>
<tr>
<td height="31"><div align="center" class="Estilo12">
<div align="right"><strong>Unidad Descuento :</strong></div>
</div></td>
<td><label>
<input name="ciud22" type="text" class="campo1" id="ciud22" value="<?php echo $unidad_desc ?>" size="25" maxlength="25" readonly="" />
</label></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Codigo Descuento : </strong></div>
</div></td>
<td><label>
</label>
<input name="code" type="text" class="campo1" id="code" value="<?php echo $cod_desc ?>" size="5" maxlength="5" readonly="" /></td>
</tr>
<tr>
<td height="31"><div align="center" class="Estilo12">
<div align="right"><strong>Entidad Recaudo :</strong></div>
</div></td>
<td><label>
<input name="ciud23" type="text" class="campo1" id="ciud23" value="<?php echo $entidad_recaudo2 ?>" size="25" maxlength="25" readonly="" />
</label></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Vendedor :</strong></div>
</div></td>
<td><input name="ciud25" type="text" class="campo1" id="ciud25" value="<?php echo $vendedor2 ?>" size="30" maxlength="30" readonly="" /></td>
</tr>
<tr>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Numero Libranza : </strong></div>
</div></td>
<td><input name="numlib" type="text" class="campo1" id="numlib" value="<?php echo $libranza ?>" size="15" maxlength="15" readonly="" /></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Valor Contrato : </strong></div>
</div></td>
<td><input name="valcon" type="text" class="campo1" id="valcon" value="<?php echo $val_contrato ?>" size="15" maxlength="15" readonly="" /></td>
</tr>
<tr>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Numero Cuotas : </strong></div>
</div></td>
<td><input name="numcuo" type="text" class="campo1" id="numcuo" value="<?php echo $cuotas ?>" size="4" maxlength="2" readonly="" /></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Valor Cuota: </strong></div>
</div></td>
<td><input name="valcuo" type="text" class="campo1" id="valcuo" value="<?php echo $valor_cuota ?>" size="15" maxlength="15" readonly="" /></td>
</tr>
<tr>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Numero Contrato : </strong></div>
</div></td>
<td><input name="numcon" type="text" class="campo1" id="numcon" value="<?php echo $contrato ?>" size="15" maxlength="15" readonly="" /></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Tipo Contrato : </strong></div>
</div></td>
<td><input name="numcon2" type="text" class="campo1" id="numcon2" value="<?php echo $tipo_contrato ?>" size="8" maxlength="8" readonly="" /></td>
</tr>
<tr>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Inicio Pagos :</strong></div>
</div></td>
<td><span class="Estilo15">MES</span>-
<input name="mes_inicio2" type="text" class="campo1" id="mes_inicio2" value="<?php echo $mes_inicio ?>" size="5" maxlength="4" readonly="" />
<label></label>
-<span class="Estilo15">AÑO</span>-
<input name="año_inicio" type="text" class="campo1" id="año_inicio" value="<?php echo $aņo_inicio ?>" size="5" maxlength="4" readonly="" /></td>
<td><div align="center" class="Estilo10">
<div align="right"><span class="Estilo12">Fecha Termino</span> :</div>
</div></td>
<td><span class="Estilo15">MES</span>-
<input name="mes_termino2" type="text" class="campo1" id="mes_termino2" value="<?php echo $mes_termino ?>" size="5" maxlength="4" readonly="" />
<label></label>
-<span class="Estilo15">AÑO</span>-
<input name="año_termino2" type="text" class="campo1" id="año_termino2" value="<?php echo $aņo_termino ?>" size="5" maxlength="4" readonly="" /></td>
</tr>
<tr>
<td height="32"><div align="center" class="Estilo12">
<div align="right"><strong>Fecha Nacimiento :</strong></div>
</div></td>
<td bordercolor="#1941A5"><label>
</label>
<input name="fecha_nac" type="text" class="campo1" id="fecha_nac" value="<?php echo $nacimiento ?>" size="10" maxlength="10" readonly="" /></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Numero Beneficiarios : </strong></div>
</div></td>
<td><input name="numben" type="text" class="campo1" id="numben" value="<?php echo $beneficiarios ?>" size="4" maxlength="2" readonly="" /></td>
</tr>
</table>
</div>
<p align="center"> </p>
<p align="center">
<input name="menu2" type="button" class="Estilo50" id="menu2" onclick="window.location.href='menu_cartera_servi.php'" value="IR AL MENU" />
</p>
</form>
</body>
</html>