File: /home/asjudine/public_html/mostrar_solicitud4.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["enviar"]))
{
if($codigo_sucursal==0)
{
//$sqlnom8 = "select codigo from sucursal where nombre = '$sucu'";
//$control8 = mysql_query($sqlnom8, $dbi) or die(mysql_error());
$control8 = mysql_query('SELECT * FROM sucursal WHERE nombre = "' ."$sucu". '" ');
if (!$control8) {
die('Invalid query NO SIRVE: ' . mysql_error());
}
list($csuc, $nom, $dire, $cel, $tip ) = mysql_fetch_row($control8);
$codigo_sucursal =$csuc;
}
if($ase==0)
{
//$sqlnom9 = "select codigo from vendedores where vendedor = '$vend'";
//$control9 = mysql_query($sqlnom9, $dbi) or die(mysql_error());
$result = mysql_query('SELECT * FROM vendedores WHERE vendedor = "' ."$vend". '" ');
if (!$result) {
die('Invalid query ESTA DAÑADO: ' . mysql_error());
}
list($cvend, $vend, $estd ) = mysql_fetch_row($result);
$ase =$cvend;
}
$re = mysql_query("UPDATE solicitud_credito set ced_ciudad = '" . $_POST[ciuced] . "', nombre = '" . $_POST[ape] . "', fecha = '" . $_POST[fechas] . "', direccion = '" . $_POST[dire] . "', ciudad = '" . $_POST[ciu] . "', telefono = '" . $_POST[tel] . "', celular = '" . $_POST[cel] . "', email = '" . $_POST[email] . "', devengado = '" . $_POST[dev] . "', descuentos = '" . $_POST[desc] . "', neto = '" . $_POST[net] . "', unidad = '" . $_POST[uni] . "', monto_solicitado = '" . $_POST[mon] . "', numero_cuenta = '" . $_POST[cue] . "', banco = '" . $_POST[ban] . "',codigo_director = '" . $_POST[cod_dir] . "', codigo_militar = '" . $_POST[codigom] . "', codigo_asesor = '" . $_POST[ase] . "', grado = '" . $_POST[gra] . "', codigo_sucursal = '" . $_POST[codigo_sucursal] . "', numero_libranza = '" . $_POST[num_lib] . "', cuotas_credito = '" . $_POST[cuo_cre] . "', con_valor_mensual = '" . $_POST[vmj] . "', con_valor_total = '" . $_POST[vmt] . "', fecha_nac = '" . $_POST[fecna] . "', concepto_rechazo = '" . $_POST[motem] . "', estado = '2' , numero_contrato = '" . $_POST[numct] . "' , entidad_laboral = '" . $_POST[nomem] . "' WHERE cedula = '" . $_POST[ced] . "'");
if (!$re) {
die('No se actualizó la BD : ' . mysql_error());
}
$mssql2 = mysql_query("UPDATE datos_empresa set nombre = '" . $_POST[ape] . "', nit= '" . $_POST[nitem] . "', direccion= '" . $_POST[direm] . "', ciudad = '" . $_POST[ciuem] . "', telefono = '" . $_POST[telem] . "', email = '" . $_POST[emaem] . "', convenio = '" . $_POST[conv] . "', representante = '" . $_POST[repem] . "', registro_mercantil = '" . $_POST[regem] . "', ciudad_camara = '" . $_POST[ciuem] . "', objeto_social = '" . $_POST[objem] . "' WHERE cedula = '" . $_POST[ced] . "'");
if (!$mssql2) {
die('Invalid query NO SE SABE: ' . mysql_error());
}
$res = mysql_query('SELECT cedula, nombre FROM asjudinet_cartera WHERE cedula = "' . $HTTP_GET_VARS["ced2"] . '" ');
if (!$res) {
die('Invalid query: ' . mysql_error());
}
list($cedud, $nombr) = mysql_fetch_row($res);
if ($cedud == $ced )
{
$mssql3 = mysql_query("UPDATE asjudinet_cartera set nombre = '" . $_POST[ape] . "', direccion= '" . $_POST[direm] . "', telefono = '" . $_POST[telem] . "', celular = '" . $_POST[cel] . "', ciudad = '" . $_POST[ciuem] . "', email = '" . $_POST[emaem] . "' WHERE cedula = '" . $_POST[ced] . "'");
if (!$mssql3) {
die('Invalid query asjudinet_cartera: ' . mysql_error());
}
}
else
{
mysql_query("INSERT INTO asjudinet_cartera (cedula, nombre, numerocontrato, tipocontrato, codigo_sucursal, direccion, telefono, celular, ciudad, email) VALUES ('" . $_POST["ced"] . "','" . $_POST["ape"] . "' , '" . $_POST["numct"] . "', '" . $_POST["planc"] . "', '" . $_POST["codigo_sucursal"] . "', '" . $_POST["direm"] . "', '" . $_POST["telem"] . "', '" . $_POST["cel"] . "', '" . $_POST["ciuem"] . "', '" . $_POST["emaem"] . "')");
}
$mssql4 = mysql_query("UPDATE cartera_datos set nombre = '" . $_POST[ape] . "', direccion= '" . $_POST[direm] . "', telefono = '" . $_POST[telem] . "', celular = '" . $_POST[cel] . "', ciudad = '" . $_POST[ciuem] . "', email = '" . $_POST[emaem] . "' WHERE cedula = '" . $_POST[ced] . "'");
if (!$mssql4) {
die('Invalid query cartera datos: ' . mysql_error());
}
$control5 = mysql_query('SELECT fecha_libranza FROM info_asjudinet WHERE cedula = "' . $_POST[ced] . '" ');
if (!$control5) {
die('Invalid query: ' . mysql_error());
}
list($fecafili) = mysql_fetch_row($control5);
//$sqlnom7 = "select tipo_solicitud from solicitud_credito where cedula = '$ced'";
//$control7 = mysql_query($sqlnom7, $dbi) or die(mysql_error());
$resul7 = mysql_query('SELECT tipo_solicitud FROM solicitud_credito WHERE cedula = "' . $_POST[ced] . '" ');
if (!$resul7) {
die('Invalid query: ' . mysql_error());
}
list($tip_sol) = mysql_fetch_row($resul7);
if($tip_sol== '1'|| $tip_sol== '3')
{
$control6 = mysql_query('SELECT codigo FROM planes_ventas WHERE plan = "' . "$planc". '" ');
if (!$control6) {
die('Invalid query: ' . mysql_error());
}
list($cod_p) = mysql_fetch_row($control6);
$resut6 = mysql_query('SELECT valor_comision FROM valor_comisiones_planes WHERE codigo_plan = "' . "$cod_p". '" ');
if (!$resut6) {
die('Invalid query: ' . mysql_error());
}
list($valorcomip) = mysql_fetch_row($resut6);
mysql_query("INSERT INTO comisiones_ventas(cedula, valor_comision, estado, codigo_asesor, codigo_dir_nacional) VALUES ('" . $_POST["ced"] . "','" . "$valorcomip" . "', '0','" . $_POST["ase"] . "', '" . $_POST["cod_dir"] . "')");
}
if($tip_sol== '1' || $tip_sol== '2')
{
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='actualizar_creditos_sol.php?ced2=$ced'</SCRIPT>";
}
if($tip_sol== '3')
{
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='actualizar_info_serviasjudinet_sol.php?ced2=$ced'</SCRIPT>";
}
echo "<script>alert('La Solicitud de Credito se a enviado correctamente');</script>";
}
// $sqlnom = "select cedula, ced_ciudad, nombre, direccion, ciudad, telefono, celular, email, devengado, descuentos, neto, unidad, monto_solicitado, codigo_plan, numero_cuenta, banco, codigo_asesor, codigo_militar, grado, codigo_sucursal, numero_libranza, cuotas_credito, con_valor_mensual, con_valor_total, fecha_nac, numero_contrato from solicitud_credito where cedula = '$ced2'";
// $control = mysql_query($sqlnom, $dbi) or die(mysql_error());
$res = mysql_query('SELECT cedula, ced_ciudad, nombre, direccion, ciudad, telefono, celular, email, devengado, descuentos, neto, unidad, monto_solicitado, codigo_plan, numero_cuenta, banco, codigo_asesor, codigo_militar, grado, codigo_sucursal, numero_libranza, cuotas_credito, valor_mensual_cre ,con_valor_mensual, con_valor_total, fecha_nac, numero_contrato, entidad_laboral FROM solicitud_credito WHERE cedula = "' . $HTTP_GET_VARS["ced2"] . '" ');
if (!$res) {
die('Invalid query: ' . mysql_error());
}
list($cedula, $ced_ciudad, $ape2, $direccion, $ciudad, $telefono, $celular, $email, $devengado, $descuentos, $neto, $unidad, $monto_solicitado, $codigo_plan, $numero_cuenta, $banco, $codigo_asesor, $codm, $grad, $codigo_sucursal, $numero_libranza, $cuotas_credito, $valor_mensual ,$val_menj, $val_ment, $fecna, $numero_contrato, $nombreem) = mysql_fetch_row($res);
$resd = mysql_query('SELECT grado FROM solicitud_credito WHERE cedula = "' ."$cedula". '" ');
if (!$resd) {
die('Invalid query: ' . mysql_error());
}
list( $grado) = mysql_fetch_row($resd);
//$sqlnom2 = "select nombre, nit, direccion, ciudad, telefono, email, convenio, representante, registro_mercantil, ciudad_camara, objeto_social from datos_empresa where cedula = '$ced2'";
//$control2 = mysql_query($sqlnom2, $dbi) or die(mysql_error());
$res2 = mysql_query('SELECT nit, direccion, ciudad, telefono, email, convenio, representante, registro_mercantil, ciudad_camara, objeto_social FROM datos_empresa WHERE cedula = "' . $HTTP_GET_VARS["ced2"] . '" ');
if (!$res2) {
die('Invalid query: ' . mysql_error());
}
list($nitem2, $direccionem, $ciudadem, $telefonoem, $emailem, $convenio, $representanteem, $registro_mercantilem, $ciudad_camaraem, $objeto_socialem) = mysql_fetch_row($res2);
//$sqlnom3 = "select cedula, nombre, direccion, telefono, celular, email from datos_codeudor where cedula_titular = '$ced2'";
//$control3 = mysql_query($sqlnom3, $dbi) or die(mysql_error());
$control3 = mysql_query('SELECT cedula, nombre, direccion, telefono, celular, email FROM datos_codeudor WHERE cedula_titular = "' . $HTTP_GET_VARS["ced2"] . '" ');
if (!$control3) {
die('Invalid query: ' . mysql_error());
}
list($cedulaco, $apesco, $direccionco, $telefonoco, $celularco, $emailco) = mysql_fetch_row($control3);
/*$sqlnom4 = "select plan from planes_ventas where codigo = '$codigo_plan'";
$control4 = mysql_query($sqlnom4, $dbi) or die(mysql_error());*/
$control4 = mysql_query('SELECT * FROM planes_ventas WHERE codigo = "' ."$codigo_plan". '" ');
if (!$control4) {
die('Invalid query: ' . mysql_error());
}
list($cods, $plan, $valmen, $meses, $beneficia, $proceso, $ausxil, $valorcon) = mysql_fetch_row($control4);
//$sqlnom5 = "select vendedor from vendedores where codigo = '$codigo_asesor'";
//$control5 = mysql_query($sqlnom5, $dbi) or die(mysql_error());
$control5 = mysql_query('SELECT * FROM vendedores WHERE codigo = "' ."$codigo_asesor". '" ');
if (!$control5) {
die('Invalid query: ' . mysql_error());
}
list($cod, $vendedor, $estd) = mysql_fetch_row($control5);
//$sqlnom6 = "select nombre from sucursal where codigo = '$codigo_sucursal'";
//$control6 = mysql_query($sqlnom6, $dbi) or die(mysql_error());
$control6 = mysql_query('SELECT * FROM sucursal WHERE codigo = "' ."$codigo_sucursal". '" ');
if (!$control6) {
die('Invalid query: ' . mysql_error());
}
list($cod, $nombre_sucursal, $direc, $cedl, $tio) = mysql_fetch_row($control6);
//$query_sql7 = "SELECT * FROM director_ventas where estado = '1' order by nombre";
//$sql7 = mysql_query($query_sql7, $dbi) or die(mysql_error());
$sql7 = mysql_query('SELECT * FROM director_ventas WHERE estado = "1" order by nombre');
if (!$sql7) {
die('Invalid query: ' . mysql_error());
}
$row_sql7 = mysql_fetch_assoc($sql7);
$totalRows_sql7 = mysql_num_rows($sql7);
//$query_sql4 = "SELECT * FROM vendedores where estado = '1' order by vendedor";
//$sql4 = mysql_query($query_sql4, $dbi) or die(mysql_error());
$sql4 = mysql_query('SELECT * FROM vendedores WHERE estado = "1" order by vendedor');
if (!$sql4) {
die('Invalid query: ' . mysql_error());
}
$row_sql4 = mysql_fetch_assoc($sql4);
$totalRows_sql4 = mysql_num_rows($sql4);
//$query_sql8 = "SELECT * FROM sucursal order by nombre";
//$sql8 = mysql_query($query_sql8, $dbi) or die(mysql_error());
$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>Documento sin título</title>
<style type="text/css">
<!--
.est_cont5 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
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;
}
.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: Georgia, "Times New Roman", Times, serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #0B3495;
background-color: #E6FAFF;
margin: 1px;
padding: 1px;
height: 15px;
width: auto;
border: thin outset #56AD95;
}
.Estilo5 {font-size: 12px; font-style: normal; color: #0B3495; background-color: #E6FAFF; margin: 1px; padding: 1px; height: 15px; width: auto; border: thin outset #56AD95; font-family: Georgia, "Times New Roman", Times, serif;}
.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;
}
.Estilo51 {color: #FF6633;
font-size: 24px;
font-style: italic;
}
.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 {font-weight: bold}
.sol_cre11 { 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;
}
.Estilo55 { color: #FF0000;
font-weight: bold;
}
.Estilo65 { color: #7DD096;
font-weight: bold;
}
.Estilo64 { font-size: 8px;
font-weight: bold;
color: #000000;
}
.Estilo65 {color: #C72350}
.est_cont51 { 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;
}
.Estilo66 {font-size: 12px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<form action="" method="post" enctype="multipart/form-data" name="form1" class="color_fondo_sc" id="form1">
<div align="center">
<div class="Estilo1">SOLICITUD CREDITO APROBADA</div>
<table width="760" border="2" cellpadding="1" cellspacing="1" class="est_cont51">
<caption>
<div align="center"><br />
<span class="Estilo2">DATOS BASICOS - DEUDOR </span><br />
</div>
</caption>
<tr>
<th scope="col"> </th>
<th scope="col"><div align="right">
<div align="right"><strong>Fecha Solicitud :</strong></div>
</div></th>
<th width="98" scope="col"><div align="left">
<input name="fechas" type="text" class="est_cont2" id="fechas" value="<?php echo date("Y-m-d"); ?>" size="10" maxlength="10" readonly=""/>
</div></th>
<th scope="col"><div align="right"><strong>Sucursal :</strong></div></th>
<th colspan="3" scope="col"><div align="left">
<input name="sucu" type="text" class="est_cont2" id="sucu" value="<?php echo $nombre_sucursal ?>" size="35" maxlength="35" readonly=""/>
</div></th>
</tr>
<tr>
<th colspan="4" scope="col"> </th>
<th colspan="3" scope="col"><div align="left">
<select name="codigo_sucursal" class="est_cont2">
<option value="0">--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));
$rows = mysql_num_rows($sql8);
if($rows8 > 0) {
mysql_data_seek($sql8, 0);
$row_sql8 = mysql_fetch_assoc($sql8);
}
?>
</select>
</div></th>
</tr>
<tr>
<td width="59"><div align="right"><strong>Apellidos y Nombres:</strong></div></td>
<td colspan="3"><div align="left">
<input name="ape" type="text" class="est_cont2" id="ape" value="<?php echo $ape2 ?>" size="66" maxlength="65" />
</div></td>
<td><div align="right"><strong>Cogido Militar :</strong></div></td>
<td colspan="2"><div align="left">
<input name="codigom" type="text" class="est_cont2" id="codigom" value="<?php echo $codm ?>" size="20" maxlength="20"/>
</div></td>
</tr>
<tr>
<td height="21"><div align="right"><strong>Cedula No:</strong></div></td>
<td width="126"><div align="left">
<input name="ced" type="text" class="est_cont2" 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="est_cont2" id="ciuced" value="<?php echo $ced_ciudad ?>" size="20" maxlength="20" />
</div></td>
<td><div align="right"><strong>Unidad :</strong></div></td>
<td colspan="2"><div align="left">
<input name="uni" type="text" class="est_cont2" id="uni" value="<?php echo $unidad ?>" size="35" maxlength="35" />
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Cuidad :</strong></div></td>
<td><div align="left">
<input name="ciu" type="text" class="est_cont2" id="ciu" value="<?php echo $ciudad ?>" size="20" maxlength="20" />
</div></td>
<td><div align="right"><strong>Direccion :</strong></div></td>
<td colspan="2"><div align="left">
<input name="dire" type="text" class="est_cont2" id="dire" value="<?php echo $direccion ?>" size="50" maxlength="50" />
</div></td>
<td width="116"><div align="right"><strong>Grado :</strong></div></td>
<td width="72"><div align="left">
<input name="gra" type="text" class="est_cont2" id="gra" value="<?php echo $grado ?>" size="12" maxlength="10" />
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Telefono :</strong></div></td>
<td><div align="left">
<input name="tel" type="text" class="est_cont2" id="tel" value="<?php echo $telefono ?>" size="20" maxlength="20" />
</div></td>
<td><div align="right"><strong>Celular :</strong></div></td>
<td><div align="left">
<input name="cel" type="text" class="est_cont2" id="cel" value="<?php echo $celular ?>" size="20" maxlength="20" />
</div></td>
<td><div align="right"><strong>E-mail :</strong></div></td>
<td colspan="2"><div align="left">
<input name="email" type="text" class="est_cont2" id="email" value="<?php echo $email ?>" size="35" maxlength="35" />
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Total Devengado $:</strong></div></td>
<td><div align="left">
<input name="dev" type="text" class="est_cont2" id="dev" value="<?php echo $devengado ?>" size="12" maxlength="10" />
</div></td>
<td><div align="right"><strong>Descuentos $:</strong></div></td>
<td width="117"><div align="left">
<input name="desc" type="text" class="est_cont2" id="desc" value="<?php echo $descuentos ?>" size="12" maxlength="10" />
</div></td>
<td width="132"><div align="right"><strong>Neto a Recibir $:</strong></div></td>
<td colspan="2"><div align="left">
<input name="net" type="text" class="est_cont2" id="net" value="<?php echo $neto ?>" size="12" maxlength="10" />
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Monto Solicitado $ :</strong></div></td>
<td><div align="left">
<input name="mon" type="text" class="est_cont2" id="mon" value="<?php echo $monto_solicitado ?>" size="12" maxlength="10" />
</div></td>
<td><div align="right" class="Estilo65"> Cuotas credito:</div></td>
<td><div align="left">
<label></label>
<input name="cuo_cre" type="text" class="est_cont2" id="cuo_cre" value="<?php echo $cuotas_credito ?>" size="2" maxlength="2" />
</div></td>
<td><div align="center" class="Estilo65"> Valor Mensual CRE:</div>
<div align="center">
<input name="num_lib" type="text" class="est_cont2" id="num_lib" value="<?php echo $valor_mensual ?>" size="12" maxlength="12" />
</div> </td>
<td><div align="center" class="Estilo65"> Numero libranza:</div>
<div align="center">
<input name="num_lib" type="text" class="est_cont2" id="num_lib" value="<?php echo $numero_libranza ?>" size="12" maxlength="12" />
</div> </td>
</tr>
<tr>
<td><div align="right"><strong>Plan :</strong></div></td>
<td><div align="left">
<input name="planc" type="text" class="est_cont2" id="planc" value="<?php echo $plan ?>" size="12" maxlength="10" readonly=""/>
</div></td>
<td><div align="right" class="Estilo54 Estilo65">Valor Mensual JUR:</div></td>
<td><div align="left">
<input name="vmj" type="text" class="est_cont2" id="vmj" value="<?php echo $val_menj ?>" size="12" maxlength="10" />
</div></td>
<td><div align="right" class="Estilo3">Valor Total :</div></td>
<td colspan="2"><div align="left">
<input name="vmt" type="text" class="est_cont2" id="vmt" value="<?php echo $val_ment ?>" size="12" maxlength="10" />
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Cuenta No :</strong></div></td>
<td><div align="left">
<input name="cue" type="text" class="est_cont2" id="cue" value="<?php echo $numero_cuenta ?>" size="20" maxlength="20" />
</div></td>
<td><div align="right"><strong>Banco :</strong></div></td>
<td><div align="left">
<input name="ban" type="text" class="est_cont2" id="ban" value="<?php echo $banco ?>" size="20" maxlength="20" />
</div></td>
<td><div align="right"><strong>Vendedor :</strong></div></td>
<td colspan="2"><div align="left">
<input name="vend" type="text" class="est_cont2" id="vend" value="<?php echo $vendedor ?>" size="35" maxlength="35" readonly=""/>
</div></td>
</tr>
<tr>
<td><div align="right"><strong>Fecha Nacimiento :</strong></div></td>
<td><div align="left"> <span class="Estilo64">MES - DIA </span>
<input name="fecna" type="text" class="est_cont2" id="fecna" value="<?php echo $fecna ?>" size="6" maxlength="6" />
</div></td>
<td><div align="right" class="Estilo54 Estilo65">Nro Contrato :</div></td>
<td><div align="left">
<input name="numct" type="text" class="est_cont2" id="numct" value="<?php echo $numero_contrato ?>" size="12" maxlength="10" />
</div></td>
<td> </td>
<td colspan="2"><div align="left">
<select name="ase" class="est_cont2" id="ase">
<option value="0">-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 colspan="4"> </td>
<td><div align="right"><strong>Director :</strong></div></td>
<td colspan="2"><div align="left">
<select name="cod_dir" class="est_cont2" id="cod_dir">
<option value="">-SELECCIONE DIRECTOR-</option>
<?php
do {
?>
<option value="<?php echo $row_sql7['codigo'];?>"><?php echo $row_sql7['nombre']?></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>
</table>
<table width="624" height="62" border="1" class="est_cont51">
<caption>
<span class="Estilo66"><br />
DATOS CODEUDOR </span>
</caption>
<tr>
<th width="107" height="16" scope="col"><div align="right"><strong>Apellidos y Nombres:</strong></div></th>
<th width="334" scope="col"><div align="left">
<input name="apeco" type="text" class="est_cont2" id="apeco" value="<?php echo $apesco ?>" size="66" maxlength="65" />
</div></th>
<th width="49" scope="col"><div align="right"><strong>Cedula:</strong></div></th>
<th width="104" scope="col"><div align="left">
<input name="cedco" type="text" class="est_cont2" id="cedco" value="<?php echo $cedulaco ?>" size="20" maxlength="20" />
</div></th>
</tr>
<tr>
<td height="16"><div align="right"><strong>Dreccion :</strong></div></td>
<td><div align="left">
<input name="dirco" type="text" class="est_cont2" id="dirco" value="<?php echo $direccionco ?>" size="50" maxlength="50" />
</div></td>
<td><div align="right"><strong>Telefono:</strong></div></td>
<td><div align="left">
<input name="telco" type="text" class="est_cont2" id="telco" value="<?php echo $telefonoco ?>" size="20" maxlength="20" />
</div></td>
</tr>
<tr>
<td height="18"><div align="right"><strong>Email:</strong></div></td>
<td><div align="left">
<input name="emaco" type="text" class="est_cont2" id="emaco" value="<?php echo $emailco ?>" size="35" maxlength="35" />
</div></td>
<td><div align="right"><strong>Celular:</strong></div></td>
<td><div align="left">
<input name="celco" type="text" class="est_cont2" id="celco" value="<?php echo $celularco ?>" size="20" maxlength="20" />
</div></td>
</tr>
</table>
<p> </p>
<p class="Estilo3">DATOS BASICOS - ENTIDAD LABORAL</p>
<table width="630" height="253" border="2" cellpadding="1" cellspacing="1" class="est_cont6">
<tr>
<th width="71" height="25" scope="col"><div align="right"><strong>Nombre :</strong></div></th>
<th colspan="3" scope="col"><label> </label>
<div align="left">
<input name="nomem" type="text" class="sol_cre11" id="nomem" value="<?php echo $nombreem ?>" size="66" maxlength="60" />
</div></th>
<th width="90" scope="col"><div align="right"><strong>Nit :</strong></div></th>
<th width="133" scope="col"> <div align="left">
<input name="nitem" type="text" class="sol_cre11" id="nitem" value="<?php echo $nitem2 ?>" size="25" maxlength="22" />
</div></th>
</tr>
<tr>
<td><div align="right"><strong>Direccion :</strong></div></td>
<td colspan="3"><div align="left">
<input name="direm" type="text" class="sol_cre11" id="direm" value="<?php echo $direccionem ?>" size="60" maxlength="55" />
</div></td>
<td><div align="right"><strong>Ciudad :</strong></div></td>
<td><div align="left"><span class="Estilo54">
<input name="ciuem" type="text" class="sol_cre11" id="ciuem" value="<?php echo $ciudadem ?>" size="25" maxlength="22" />
</span></div></td>
</tr>
<tr>
<td><div align="right"><strong>Telefono :</strong></div></td>
<td width="68"><div align="left">
<input name="telem" type="text" class="sol_cre11" id="telem" value="<?php echo $telefonoem ?>" size="12" maxlength="12" />
</div></td>
<td width="79"><div align="right"><strong>E-mail:</strong></div></td>
<td width="154"><div align="left">
<input name="emaem" type="text" class="sol_cre11" id="emaem" value="<?php echo $emailem ?>" size="29" maxlength="29" />
</div></td>
<td><div align="right"><strong>Convenio No:</strong></div></td>
<td><input name="conv" type="text" class="sol_cre1" id="conv" value="<?php echo $convenio ?>" size="25" maxlength="22" /></td>
</tr>
<tr>
<td colspan="6" bgcolor="#DDFFEF"><div align="center"><strong> INFORMACION CAMARA DE COMERCIO</strong></div></td>
</tr>
<tr>
<td height="25" colspan="2" bgcolor="#E2EDD8"><div align="right"><strong>Registro Mercantil No:</strong></div></td>
<td bgcolor="#E2EDD8"><div align="left">
<input name="regem" type="text" class="sol_cre11" id="regem" value="<?php echo $registro_mercantilem ?>" size="14" maxlength="14" />
</div></td>
<td bgcolor="#E2EDD8"><div align="right"><strong>Camara Comercio de :</strong></div></td>
<td colspan="2" bgcolor="#E2EDD8"><div align="left">
<input name="camem" type="text" class="sol_cre11" id="camem" value="<?php echo $ciudad_camaraem ?>" size="25" maxlength="25" />
</div></td>
</tr>
<tr>
<td height="25" colspan="2" bgcolor="#E2EDD8"><div align="right"><strong>Representante Legal :</strong></div></td>
<td colspan="2" bgcolor="#E2EDD8"><div align="left">
<input name="repem" type="text" class="sol_cre11" id="repem" value="<?php echo $representanteem ?>" size="46" maxlength="45" />
</div></td>
<td colspan="2" bgcolor="#E2EDD8"> </td>
</tr>
<tr>
<td height="55" colspan="2" bgcolor="#E2EDD8"><div align="right"><strong>Objeto Social :</strong></div></td>
<td colspan="4" bgcolor="#E2EDD8"><label> <span class="Estilo54">
<textarea name="objem" id="objem" cols="60" rows="3"><?php echo $objeto_socialem ?></textarea>
</span> </label></td>
</tr>
</table>
<p class="Estilo3"> </p>
<p>
<input name="enviar" type="submit" class="col_cre2" id="enviar" value="Enviar" />
</p>
</div>
</form>
</body>
</html>