File: /home/asjudine/public_html/comercial/informacion_credito_ced.php
<?php
require_once("../Conectarse.php");
$result = mysql_query('SELECT ciudad, fecha_credito, nombre, cedula, codigo, grado, direccion, ciudad, telefono, celular, email, cuotas_credito, valor_credito , valor_cuota, cuenta_ahorros, banco, neto_consignar, interes_deducible, numero_libranza, mes_inicio, ano_inicio, mes_termino, ano_termino, empresa, proveedor FROM creditos_serviasjudinet WHERE cedula = "' . $_GET["ced"] . '" ');
if (!$result) {
die('Invalid query sd: ' . mysql_error());
}
list($suc, $fecha, $ape, $cc, $cod, $gra, $dir, $ciu, $tel, $cel, $em, $num_cuo, $monto_sol, $valmen, $cuent, $banc, $consig, $intded, $num_lib, $mi, $ai, $mt, $at, $emp, $prov) = mysql_fetch_row($result);
$vmt=$valmen+$vj;
/* $sqlnom6 = "select nombre from empresas where codigo = '$emp'";
$control6 = mysql_query($sqlnom6, $dbi) or die(mysql_error());*/
$resul = mysql_query('SELECT nombre FROM entidad_laboral WHERE codigo = "' ."$emp". '" ');
if (!$resul) {
die('Invalid query: ' . mysql_error());
}
list($emp1) = mysql_fetch_row($resul);
?>
<!DOCTYPE HTML>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Consulta Credito</title>
<style type="text/css">
<!--
.Estilo14 {background-color: #CCFFCC; font-size: 13px; font-family: Arial; color: #0000CC; display: block; font-weight: bold; }
.campo {background-color: #FFFFCC; border:1px solid #990000; font-family:Arial; font-size:11px; height: inherit}
.label {background-color: #00CCFF ; font-size: 14px; font-family: Arial; color:#0000CC; display: block;}
*{margin: 0;padding: 0;}
body{background-color:#EAEAEA;font-family:Geneva, Arial, Helvetica, sans-serif;}
header {background-color: #B7271F; text-align: center;}
.titulo{width: 100%;text-align: center;background-color: #dbd8c9;color: #b20606;padding: 6px 0;font-size: 18px;}
table{margin: 0 auto;border: 8px solid #bebebe; text-align: center;}
.divirmenu{text-align: center;}
.irmenu{width: 200px;background-color: #1c4fa0;color: #fff; padding: 4px;border-radius: 6px;}
.irmenu:hover{background-color: #67a0d9; color: #000;}
.fecha{background-color: #d6e08b; padding: 2px;color: #000;font-size: 15px; text-align: center;}
td{padding: 1px; border: 1px solid #a0a0a0;}
.td{background-color: #e5e5e5; padding: 1px 30px;color: #00135F;font-size: 14px;font-weight: 600; text-align: center;}
.boton1{width:30%;background-color: #ffffff;color: #000;padding: 2px;border:2px solid #580000;border-radius:10px;}
.boton1:hover{background-color: #6f0000;color: #fff;cursor: pointer;}
input[type=text]{border-radius: 5px; padding: 3px;background-color: #FFFFF4;}
.tdtitulo{background-color: #e3dec0; color: #b20606; padding: 2px; text-align: center; font-size: 12px; font-weight: 900}
.tdfull{background-color: #fff; color: #000; padding: 1px; text-align: center; font-size: 12px;}
.botonnew{width: 90px; background-color: #e3dec0;color: #b20606;padding: 1px;border-radius:5px;}
.botonnew:hover{width: 90px; background-color: #cbbd6a;color: #000;padding: 1px;border-radius:5px;}
.tdder{background-color: #e5e5e5; padding: 1px 10px;color: #00135F;font-size: 12px;font-weight: 600; text-align: right;}
.tdizq{background-color: #e5e5e5; padding: 1px 10px;color: #00135F;font-size: 12px;font-weight: 600; text-align: left;}
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<header>
<img src="../ELEMENTS/bannerInterasjudinet.png" alt="" width=" 700" height="70">
</header>
<br>
<p><span class="titulo">Datos del cliente:</span></p>
<table width="744" height="219" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td class="tdder">Sucursal:</td>
<td class="tdizq">
<input name="sucur" type="text" id="sucur" value="<?php echo $suc?>" size="50" maxlength="50" />
</td>
<td class="tdder">Fecha:</td>
<td class="tdizq"><input name="fecha" type="text" id="fecha" value="<?php echo $fecha ?>" size="15" maxlength="10" readonly />
</td>
</tr>
<tr>
<td class="tdder">Apellidos y Nombres:</td>
<td colspan="3" class="tdizq"><input name="apellidos" type="text" id="apellidos" value="<?php echo $ape ?>" size="80" maxlength="80" />
</td>
</tr>
<tr>
<td class="tdder">C.C No :</td>
<td class="tdizq"><input name="cedula" type="text" id="cedula" value="<?php echo $cc ?>" size="25" maxlength="25" /></td>
<td class="tdder">Codigo:</td>
<td class="tdizq"><input name="codigo" type="text" id="codigo" value="<?php echo $cod ?>" size="25" maxlength="25" /></td>
</tr>
<tr>
<td class="tdder">Grado:</td>
<td class="tdizq"><input name="grado" type="text" id="grado" value="<?php echo $gra ?>" size="15" maxlength="15" /></td>
<td colspan="4"><div align="center"></div></td>
</tr>
<tr>
<td class="tdder">Direccion Envio de Documentos:</td>
<td class="tdizq"><input name="direccion_envio" type="text" id="despacho_judicial4" value="<?php echo $dir ?>" size="50" maxlength="60" /></td>
<td class="tdder">Ciudad:</td>
<td class="tdizq"><input name="ciudad_envio" type="text" id="ciudad_envio" value="<?php echo $ciu ?>" size="35" maxlength="35" /></td>
</tr>
<tr>
<td class="tdder">Telefono:</td>
<td class="tdizq"><input name="telefono" type="text" id="telefono" value="<?php echo $tel ?>" size="20" maxlength="35" /></td>
<td class="tdder">Celular:</td>
<td class="tdizq"><input name="celular" type="text" id="celular" value="<?php echo $cel ?>" size="20" maxlength="20" /></td>
</tr>
<tr>
<td class="tdder">Email:</td>
<td class="tdizq"><input name="email" type="text" id="email" value="<?php echo $em ?>" size="35" maxlength="35" /></td>
<td colspan="2"> </td>
</tr>
</table><br>
<p><span class="titulo">Datos del credito:</span></p>
<tr bgcolor="#FFFFFF">
<td><table width="869" height="208" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#FFFFFF">
<td colspan="2" class="tdder">Monto Solicitado $ :</td>
<td colspan="2" class="tdizq" ><input name="monto_sol" type="text" id="monto_sol" value="<?php echo $monto_sol ?>" size="35" maxlength="35" /></td>
<td class="tdder">Salario Neto $:</td>
<td class="tdizq"><input name="salario" type="text" id="salario" value="<?php echo $sala ?>" size="35" maxlength="35" readonly /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" class="tdder">Numero de Cuotas :</td>
<td colspan="2" class="tdizq"><input name="fecha_inicio2" type="text" id="fecha_inicio2" value="<?php echo $num_cuo ?>" size="2" maxlength="2" /></td>
<td class="tdder">Valor Mensual Juridica $:</td>
<td class="tdizq"><input name="val_jur" type="text" id="val_jur" value="<?php echo $vj ?>" size="35" maxlength="35" /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" class="tdder">Valor Mensual $ :</td>
<td colspan="2" class="tdizq"><input name="val_mensual" type="text" id="val_mensual" value="<?php echo $valmen ?>" size="35" maxlength="35" readonly /></td>
<td class="tdder">Valor Mensual TOTAL $:</td>
<td class="tdizq"><input name="val_men_tot" type="text" id="val_men_tot" value="<?php echo $vmt ?>" size="35" maxlength="35" readonly /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" class="tdder">Neto a Consignar $ :</td>
<td colspan="2" class="tdizq"><input name="val_neto" type="text" id="val_neto" value="<?php echo $consig ?>" size="35" maxlength="35" readonly /></td>
<td class="tdder">Cuenta ahorros No :</td>
<td class="tdizq"><input name="cuenta_aho" type="text" id="cuenta_aho" value="<?php echo $cuent ?>" size="35" maxlength="35" /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" class="tdder">Interes Deducible $ :</td>
<td colspan="2" class="tdizq"><input name="interesd" type="text" id="interesd" value="<?php echo $intded ?>" size="35" maxlength="35" readonly /></td>
<td class="tdder">Banco :</td>
<td class="tdizq"><input name="banco_cuenta" type="text" id="banco_cuenta" value="<?php echo $banc ?>" size="35" maxlength="35" /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2" class="tdder">Primer Descuento $ :</td>
<td colspan="2" class="tdizq"><input name="fecha_inicio" type="text" id="fecha_inicio" value="<?php echo $inicio_pag ?>" size="13" maxlength="10" /></td>
<td class="tdder">Empresa :</td>
<td class="tdizq"><input name="empresa" type="text" id="empresa" value="<?php echo $emp1 ?>" size="35" maxlength="35" /></td>
</tr>
<tr>
<td class="tdder">Mes inicio:</td>
<td class="tdizq"><input name="mi2" type="text" id="mi2" value="<?php echo $mi ?>" size="2" maxlength="2" /></td>
<td class="tdder">Año Inicio :</td>
<td class="tdizq"><input name="ai2" type="text" id="ai2" value="<?php echo $ai ?>" size="4" maxlength="4" /></td>
<td class="tdder">Proveedor :</td>
<td class="tdizq"><input name="proveedor" type="text" id="proveedor" value="<?php echo $prov ?>" size="35" maxlength="35" /></td>
</tr>
<tr >
<td class="tdder">Mes termino:</td>
<td class="tdizq"><input name="mt2" type="text" id="mt2" value="<?php echo $mt ?>" size="2" maxlength="2" /></td>
<td class="tdder">Año Termino :</td>
<td class="tdizq"><input name="at2" type="text" id="at2" value="<?php echo $at ?>" size="4" maxlength="4" /></td>
<td class="tdder">No Libranza :</td>
<td class="tdizq"><input name="nolib" type="text" id="nolib" value="<?php echo $num_lib ?>" size="35" maxlength="35" /></td>
</tr>
</table></td>
</tr>
</form>
</body>
</html>