File: /home/asjudine/www/info_serviasjudinet_mc.php
<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;
$linea = '-';
function Conectarse()
{
if (!($link=@mysql_connect("localhost","asjudine","as2006")))
{
echo "Error conectando con el servidor.";
exit();
}
$dbname = "asjudinet";
if (!@mysql_select_db($dbname,$link))
{
echo "Error seleccionando la base de datos.";
exit();
}
return $link;
}
Conectarse();
if(isset($_POST["consultar"]))
{
/* $mssql = "select ciudad, fecha, nombres, cedula, codigo, grado, direccion_envio, ciudad_envio, telefono , celular, email, numero_libranza, empresa from creditos where cedula = '$ced'";
$control = mysql_query($mssql, $dbi) or die(mysql_error()); */
$resul = mysql_query('SELECT ciudad, fecha, nombres, cedula, codigo, grado, direccion_envio, ciudad_envio, telefono , celular, email, numero_libranza, empresa FROM creditos WHERE cedula = "' . $_POST["ced"] . '" ');
if (!$resul) {
die('Invalid query: ' . mysql_error());
}
$num=mysql_num_rows($resul);
list($nombre_sucursal, $fecha, $apeno, $cedu, $codi, $grad, $dire, $ciue, $tele, $celul, $em, $numero_libranza, $el) = mysql_fetch_row($resul);
/* $sqlnom3 = "select nombre from empresas where codigo = '$el'";
$control3 = mysql_query($sqlnom3, $dbi) or die(mysql_error());*/
$result = mysql_query('SELECT nombre FROM empresas WHERE codigo = "' . $_POST["el"] . '" ');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
list($el) = mysql_fetch_row($result);
if($num==0)
{
/* $sqlnom2 = "select cedula, grado, nombre, neto from datos_credito where cedula = '$ced'";
$control2 = mysql_query($sqlnom2, $dbi) or die(mysql_error());*/
$resulte = mysql_query('SELECT cedula, grado, nombre, neto FROM datos_credito WHERE cedula = "' . $_POST["ced"] . '" ');
if (!$resulte) {
die('Invalid query: ' . mysql_error());
}
$num2=mysql_num_rows($resulte);
list($cedu, $grad, $apeno, $sal) = mysql_fetch_row($resulte);
}
}
if(isset($_POST["grabar"]))
{
//$mssql9 = mysql_query("select * from info_asjudinet where cedula = '$cedb'",$dbi);
$resu = mysql_query('SELECT * FROM info_asjudinet WHERE cedula = "' . $_POST["cedb"] . '" ');
if (!$resu) {
die('Invalid query: ' . mysql_error());
}
$num=mysql_num_rows($resu);
if($num==0)
{
$mt = floor(($mes_inicio + $numcuo)/12);
$submt = (($mes_inicio + $numcuo)%12)-1;
$at = $mt + $aņo_inicio;
if($submt==0)
{
$submt = 12;
$at = $at-1;
}
//$sqlnom3 = "select codigo, unidad from descuentos where id = '$unidt2'";
//$control3 = mysql_query($sqlnom3, $dbi) or die(mysql_error());
$resu3 = mysql_query('SELECT codigo, unidad FROM descuentos WHERE id = "' ."$unidt2". '" ');
if (!$resu3) {
die('Invalid query: ' . mysql_error());
}
list($codcd, $unidt) = mysql_fetch_row($resu3);
//$sqlnoms4 = "select codigo from sucursal where nombre = '$suc'";
//$controls4 = mysql_query($sqlnoms4, $dbi) or die(mysql_error());
$resu4 = mysql_query('SELECT codigo, nombre FROM sucursal WHERE codigo = "' . "$suc". '" ');
if (!$resu4) {
die('Invalid query: ' . mysql_error());
}
list($codsu, $nomsu) = mysql_fetch_row($resu4);
mysql_query ("INSERT INTO info_asjudinet(cedula, sucursal, pagaduria, unidad_desc, cod_desc, entidad_recaudo, libranza, fecha_libranza, val_contrato, cuotas, valor_cuota, contrato, tipo_contrato, beneficiarios, mes_inicio, ano_inicio, mes_termino, ano_termino, vendedor, renovacion) VALUES ('" . $_POST["cedb"] . "','" . "$codsu". "','" . $_POST["pag"] . "','" ."$unidt". "','" . "$codcd". "','" . $_POST["entrec"] . "','" . $_POST["numlib"] . "','" . $_POST["fecha_lib"] . "','" . $_POST["valcon"] . "','" . $_POST["numcuo"] . "','" . $_POST["valcuo"] . "','" . $_POST["numcon"] . "','" . $_POST["tipoc"] . "','" . $_POST["numben"] . "','" . "$mes_inicio" . "','" . "$aņo_inicio" . "','" . "$submt" . "','" . "$at" . "','" . "$vend" . "','SI')");
$fecha_nac = $mesfn.$linea.$diafn;
mysql_query ("INSERT INTO datos_basicos_rc(cedula, apellidos_noms, codigo, grado, direccion, celular, telefono, ciudad, email, entidad_laboral, fecha_nacimiento) VALUES('" . $_POST["cedb"] . "','" . $_POST["apenom"] . "','" . $_POST["cod"] . "','" . $_POST["gra"] . "','" . $_POST["dir"] . "','" . $_POST["cel"] . "','" . $_POST["tel"] . "','" . $_POST["ciud"] . "','" . $_POST["email"] . "','" . $_POST["entlab"] . "','" . $_POST["fecha_nac"] . "')");
mysql_query("INSERT INTO reporte_mindefensa(codigo, cedula, nombre, grado, cod_desc, libranza, fecha_libranza, tipo_doc, valor_descuento, cuotas, pagaduria, mes_inicio, ano_inicio, mes_termino, ano_termino, proveedor) VALUES ('" . $_POST["cod"] . "','" . $_POST["cedb"] . "','" . $_POST["apenom"] . "','" . $_POST["gra"] . "','" . $_POST["codcd"] . "','" . $_POST["numlib"] . "','" . $_POST["fecha_lib"] . "','LIB','" . $_POST["valcuo"] . "','" . $_POST["numcuo"] . "','" . $_POST["pag"] . "' ,'" . $_POST["mes_inicio"] . "','" . $_POST["aņo_inicio"] . "','" . $_POST["submt"] . "','" . $_POST["at"] . "','SERVIASJUDINET')");
$salant=$numcuo*$valcuo;
mysql_query("INSERT INTO estado_contable (codigo, saldo_ant, cuotas_pend, nuevo_saldo, cuotas_desc, fecha_udesc, tipo_pago) VALUES ('" . $_POST["cedb"] . "', '" . $_POST["salant"] . "', '" . $_POST["numcuo"] . "', '" . $_POST["salant"] . "', '0', '', 'JUR')");
//$sqlnom4 = "select valor_comision from valor_comisiones_planes where = '$tipoc'";
//$control4 = mysql_query($sqlnom4, $dbi) or die(mysql_error());
$resu4 = mysql_query('SELECT valor_comision FROM valor_comisiones_planes WHERE codigo_plan = "' ."$tipoc". '" ');
if (!$resu4) {
die('Invalid query: ' . mysql_error());
}
list($valorcomip) = mysql_fetch_row($resu4);
mysql_query("INSERT INTO comisiones_ventas(cedula, valor_comision, codigo_asesor) VALUES
('" . $_POST["cedb"] . "','" . $_POST["valorcomip"] . "','" . $_POST["vend"] . "')");
/*$mssqlsol = "update solicitud_credito set estado='3' where cedula = '$cedb' ";
mysql_query($mssqlsol, $dbi) or die(mysql_error()); */
echo "<script>alert('La informacion fue grabada correctamente');</script>";
}else{
echo "<script>alert('Tiene un PLAN de JURIDICA pendiente');</script>";
}
}
/*$query_sql = "SELECT * FROM empresas order by nombre";
$sql = mysql_query($query_sql, $dbi) or die(mysql_error());*/
$sql = mysql_query('SELECT * FROM empresas order by nombre ');
if (!$sql) {
die('Invalid query: ' . mysql_error());
}
$row_sql = mysql_fetch_assoc($sql);
$totalRows_sql = mysql_num_rows($sql);
/*$query_sql2 = "SELECT * FROM descuentos order by codigo";
$sql2 = mysql_query($query_sql2, $dbi) or die(mysql_error());*/
$sql2 = mysql_query('SELECT * FROM descuentos order by codigo ');
if (!$sql2) {
die('Invalid query: ' . mysql_error());
}
$row_sql2 = mysql_fetch_assoc($sql2);
$totalRows_sql2 = mysql_num_rows($sql2);
/*$query_sql3 = "SELECT * FROM descuentos order by codigo";
$sql3 = mysql_query($query_sql3, $dbi) or die(mysql_error());*/
$sql3 = mysql_query('SELECT * FROM descuentos order by codigo ');
if (!$sql3) {
die('Invalid query: ' . mysql_error());
}
$row_sql3 = mysql_fetch_assoc($sql3);
$totalRows_sql3 = mysql_num_rows($sql3);
/*$query_sql4 = "SELECT * FROM vendedores order by vendedor";
$sql4 = mysql_query($query_sql4, $dbi) or die(mysql_error());*/
$sql4 = mysql_query('SELECT * FROM vendedores order by vendedor ');
if (!$sql4) {
die('Invalid query: ' . mysql_error());
}
$row_sql4 = mysql_fetch_assoc($sql4);
$totalRows_sql4 = mysql_num_rows($sql4);
/*$query_sql5 = "SELECT * FROM sucursal order by nombre";
$sql5 = mysql_query($query_sql5, $dbi) or die(mysql_error());*/
$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);
/*$query_sql6 = "SELECT * FROM entidades_recaudo order by nombre";
$sql6 = mysql_query($query_sql6, $dbi) or die(mysql_error());}*/
$sql6 = mysql_query('SELECT * FROM entidades_recaudo order by nombre ');
if (!$sql6) {
die('Invalid query: ' . mysql_error());
}
$row_sql6 = mysql_fetch_assoc($sql6);
$totalRows_sql6 = mysql_num_rows($sql6);
/*$query_sql7 = "SELECT * FROM planes_ventas order by codigo";
$sql7 = mysql_query($query_sql7, $dbi) or die(mysql_error());*/
$sql7 = mysql_query('SELECT * FROM planes_ventas 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 sucursal order by codigo ');
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=iso-8859-1" />
<title>Documento sin título</title>
<style type="text/css">
<!--
.Estilo10 { font-size: 14px;
font-weight: bold;
}
.Estilo12 {
font-size: 10px;
font-family: "Times New Roman", Times, serif;
}
.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: "Times New Roman", Times, serif;
font-size: 10px;
color: #5151FF;
background-color: #C4E4FD;
border: thin solid #009999;
height: 16px;
width: auto;
font-weight: bold;
}
.datos3 {
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
font-style: normal;
font-weight: normal;
color: #FF3300;
background-color: #A6ECD7;
margin: 1px;
padding: 2px;
border: medium groove #CCCCFF;
}
body {
background-color: #DCFAF3;
}
.campo {background-color: #FFFFCC; border:1px solid #990000; font-family:Arial; font-size:11px; height: inherit}
.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: 10px;
font-style: normal;
font-weight: normal;
color: #0033FF;
background-color: #FFE2C6;
margin: 1px;
padding: 2px;
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;
}
.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;
}
.Estilo51 {font-size: 16px}
.Estilo55 {
font-size: 10px;
font-weight: bold;
font-family: "Times New Roman", Times, serif;
}
.Estilo56 {font-size: 11px}
.Estilo58 {font-size: 14px}
.Estilo64 { font-size: 8px;
font-weight: bold;
color: #000000;
}
.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;
}
.Estilo68 {font-size: 10px; font-weight: bold; }
.Estilo1 {color: #FF6633;
font-size: 24px;
font-style: italic;
}
.Estilo2 {color: #FF6633;
font-size: 16px;
}
.Estilo50 {color: #CC3333;
font-family: "Arial Narrow";
font-weight: bold;
}
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<div align="center">
<table width="330" border="3" cellpadding="3" cellspacing="3" class="recaudo">
<caption>
<span class="Estilo1">rmido<br />
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>
<table width="663" border="3" cellpadding="3" cellspacing="3" class="datos3">
<caption>
<div align="center"><strong><span class="Estilo12"><br />
</span></strong><strong><span class="Estilo58">INFORMACION SERVIASJUDINET</span><br />
</strong>
<table width="554" border="3" cellpadding="3" cellspacing="3" class="datos2">
<caption>
<span class="Estilo8"><br />
<span class="Estilo58">DATOS BASICOS </span></span>
</caption>
<tr>
<td width="93"><div align="left"><span class="Estilo55">Apellidos y Nombres :</span></div></td>
<td colspan="4"><div align="left">
<input name="apenom" type="text" class="campo1" id="apenom" value="<?php echo $apeno ?>" size="50" maxlength="50" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo55">
<div align="right">Cedula : </div>
</div></td>
<td width="142"><div align="left">
<input name="cedb" type="text" class="campo1" id="cedb" value="<?php echo $cedu ?>" size="15" maxlength="15"/>
</div></td>
<td width="93"><div align="center" class="Estilo55">
<div align="right">Codigo : </div>
</div></td>
<td colspan="2"><div align="left">
<input name="cod" type="text" class="campo1" id="cod" value="<?php echo $codi ?>" size="15" maxlength="15" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo55">
<div align="right">Grado : </div>
</div></td>
<td><div align="left">
<input name="gra" type="text" class="campo1" id="gra" value="<?php echo $grad ?>" size="15" maxlength="15" />
</div></td>
<td><div align="center" class="Estilo55">
<div align="right">Direccion : </div>
</div></td>
<td colspan="2"><div align="left">
<input name="dir" type="text" class="campo1" id="dir" value="<?php echo $dire ?>" size="40" maxlength="40" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo55">
<div align="right">Celular : </div>
</div></td>
<td><div align="left">
<input name="cel" type="text" class="campo1" id="cel" value="<?php echo $celul ?>" size="15" maxlength="15" />
</div></td>
<td><div align="center" class="Estilo55">
<div align="right">Telefono : </div>
</div></td>
<td colspan="2"><div align="left">
<input name="tel" type="text" class="campo1" id="tel" value="<?php echo $tele ?>" size="15" maxlength="15" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo55">
<div align="right">Fecha Nacimiento : </div>
</div></td>
<td><div align="left"><span class="Estilo64">MES</span>
<input name="mesfn" type="text" class="campo1" id="mesfn" value="<?php echo $mesnaci ?>" size="2" maxlength="2" />
<span class="Estilo64">-DIA</span>
<input name="diafn" type="text" class="campo1" id="diafn" value="<?php echo $dianaci ?>" size="2" maxlength="2" />
</div></td>
<td><div align="center" class="Estilo55">
<div align="right">Entidad Laboral: </div>
</div></td>
<td colspan="2"><input name="entlab" type="text" class="campo1" id="entlab" value="<?php echo $el ?>" size="40" maxlength="50" /></td>
</tr>
<tr>
<td><div align="center" class="Estilo55">
<div align="right">Ciudad : </div>
</div></td>
<td colspan="2"><div align="left">
<input name="ciud" type="text" class="campo1" id="ciud" value="<?php echo $ciue ?>" size="25" maxlength="25" />
</div></td>
<td width="47"><div align="center" class="Estilo55">
<div align="right">Email : </div>
</div></td>
<td width="113"><div align="left">
<input name="email" type="text" class="campo1" id="email" value="<?php echo $em ?>" size="25" maxlength="40" />
</div></td>
</tr>
</table>
<strong><br />
<br />
<span class="Estilo51">INFORMACION SERVIASJUDINET </span><br />
<br />
</strong>
<label></label>
</div>
</caption>
<tr>
<td><div align="center" class="Estilo12">
<div align="right"><strong> Sucursal :</strong></div>
</div></td>
<td><div align="left">
<select name="suc" class="est_cont2" id="suc">
<option value="">-SELECCIONE SUCURSAL-</option>
<?php
do {
?>
<option value="<?php echo $row_sql8['codigo'];?>"><?php echo $row_sql8['nombre']?></option>
<?php
} while ($row_sql8 = mysql_fetch_assoc($sql8));
$rows8 = mysql_num_rows($sql8);
if($rows8 > 0) {
mysql_data_seek($sql8, 0);
$row_sql8 = mysql_fetch_assoc($sql8);
}
?>
</div></th>
<th width="106" scope="col"><div align="right"><span class="Estilo12">Pagaduria : </span></div></th>
<th width="199" scope="col"><div align="left">
<select name="pag" class="est_cont2" id="pag">
<option value="">--SELECCIONE PAGADURIA--</option>
<?php
do {
?>
<option value="<?php echo $row_sql['codigo'];?>"><?php echo $row_sql['nombre']?></option>
<?php
} while ($row_sql = mysql_fetch_assoc($sql));
$rows = mysql_num_rows($sql);
if($rows > 0) {
mysql_data_seek($sql, 0);
$row_sql = mysql_fetch_assoc($sql);
}
?>
</select>
</tr>
<tr>
<td height="26" class="Estilo12"><div align="center" class="Estilo12">
<div align="right"><strong>Unidad y Codigo Descuento :</strong></div>
</div></td>
<td><label>
</label>
<div align="left">
<select name="unidt2" class="est_cont2" id="unidt2">
<option value="">--SELECIONE UNIDAD--</option>
<?php
do {
?>
<option value="<?php echo $row_sql2['id'];?>"><?php echo $row_sql2['unidad'].'-'.$row_sql2['codigo']?></option>
<?php
} while ($row_sql2 = mysql_fetch_assoc($sql2));
$rows2 = mysql_num_rows($sql2);
if($rows2 > 0) {
mysql_data_seek($sql2, 0);
$row_sql2 = mysql_fetch_assoc($sql2);
}
?>
</select>
</div></td>
<td><div align="center" class="Estilo56">
<div align="right" class="Estilo12"><strong>Entidad Recaudo :</strong></div>
</div></td>
<td><div align="left">
<select name="entrec" class="est_cont2" id="entrec">
<option value="">--SELECIONE ENTIDAD--</option>
<?php
do {
?>
<option value="<?php echo $row_sql6['codigo'];?>"><?php echo $row_sql6['nombre']?></option>
<?php
} while ($row_sql6 = mysql_fetch_assoc($sql6));
$rows6 = mysql_num_rows($sql6);
if($rows6 > 0) {
mysql_data_seek($sql6, 0);
$row_sql6 = mysql_fetch_assoc($sql6);
}
?>
</select>
</div> <label>
</label></td>
</tr>
<tr>
<td height="28" class="Estilo12"><div align="center" class="Estilo56">
<div align="right" class="Estilo12"><strong>Numero Libranza : </strong></div>
</div></td>
<td><div align="left">
<input name="numlib" type="text" class="campo1" id="numlib" value="<?php echo $numero_libranza ?>" size="15" maxlength="15" />
</div> <label></label></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong> Vendedor :</strong></div>
</div></td>
<td><div align="left">
<select name="vend" class="est_cont2" id="vend">
<option value="">-SELECCIONE VENDEDOR-</option>
<?php
do {
?>
<option value="<?php echo $row_sql4['codigo'];?>"><?php echo $row_sql4['vendedor']?></option>
<?php
} while ($row_sql4 = mysql_fetch_assoc($sql4));
$rows4 = mysql_num_rows($sql4);
if($rows4 > 0) {
mysql_data_seek($sql4, 0);
$row_sql4 = mysql_fetch_assoc($sql4);
}
?>
</select>
</div></td>
</tr>
<tr>
<td class="Estilo12"><div align="center" class="Estilo12">
<div align="right"><strong>Numero Cuotas : </strong></div>
</div></td>
<td><div align="left">
<select name="numcuo" class="est_cont2" id="numcuo">
<option value="6" selected="selected">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
</select>
</div></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Valor Contrato : </strong></div>
</div></td>
<td><div align="left">
<input name="valcon" type="text" class="campo1" id="valcon" size="15" maxlength="15" />
</div></td>
</tr>
<tr>
<td class="Estilo12"><div align="center" class="Estilo56">
<div align="right" class="Estilo12"><strong>Numero Contrato : </strong></div>
</div></td>
<td><div align="left">
<input name="numcon" type="text" class="campo1" id="numcon" size="15" maxlength="15" />
</div></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Valor Cuota: </strong></div>
</div></td>
<td><div align="left">
<input name="valcuo" type="text" class="campo1" id="valcuo" size="15" maxlength="15" />
</div></td>
</tr>
<tr>
<td height="28" class="Estilo12"><div align="center" class="Estilo56">
<div align="right" class="Estilo12"><strong>Inicio Pagos :</strong></div>
</div></td>
<td><div align="left"><span class="Estilo15">MES</span>-
<label>
<select name="mes_inicio" class="est_cont2" id="mes_inicio">
<option value="01" selected="selected">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
</label>
-<span class="Estilo15">AÑO</span>-
<input name="año_inicio" type="text" class="campo1" id="año_inicio" value="0000" size="5" maxlength="4" />
</div>
<label></label></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Tipo Contrato : </strong></div>
</div></td>
<td><div align="left">
<select name="tipoc" class="est_cont2" id="tipoc">
<option value="">-PLAN-</option>
<?php
do {
?>
<option value="<?php echo $row_sql7['codigo'];?>"><?php echo $row_sql7['plan']?></option>
<?php
} while ($row_sql7 = mysql_fetch_assoc($sql7));
$rows7 = mysql_num_rows($sql7);
if($rows7 > 0) {
mysql_data_seek($sql7, 0);
$row_sql7 = mysql_fetch_assoc($sql7);
}
?>
</select>
</div></td>
</tr>
<tr>
<td class="Estilo12"><div align="center" class="Estilo10">
<div align="right" class="Estilo12">Fecha Termino :</div>
</div></td>
<td><div align="left"><span class="Estilo15">MES</span>-
<input name="mes_term" type="text" class="campo1" id="mes_term" value="<?php echo $submt ?>" size="2" maxlength="2" readonly=""/>
-<span class="Estilo15">AÑO</span>-
<input name="año_term" type="text" class="campo1" id="año_term" value="<?php echo $at ?>" size="5" maxlength="4" readonly=""/>
</div></td>
<td><div align="center" class="Estilo56">
<p align="right" class="Estilo12"><strong>Fecha Afiliacion:</strong></p>
</div></td>
<td><div align="left">
<input name="fecha_lib" type="text" class="campo1" id="fecha_lib" value="<?php echo $fecha ?>" size="10" maxlength="10" />
</div></td>
</tr>
<tr>
<td height="28" class="Estilo12"> </td>
<td bordercolor="#1941A5"><label>
</label></td>
<td><div align="center" class="Estilo12">
<div align="right"><strong>Numero Beneficiarios : </strong></div>
</div></td>
<td><div align="left">
<input name="numben" type="text" class="campo1" id="numben" value="<?php echo $nbf ?>" size="4" maxlength="2" />
</div></td>
</tr>
</table>
<p align="center">
<input name="grabar" type="submit" class="Estilo3" id="grabar" value="Enviar" />
</p>
<p align="center">
<input name="menu2" type="button" class="Estilo50" id="menu2" onclick="window.location.href='menu_credito.php'" value="IR AL MENU" />
</p>
</form>
</body>
</html>