File: /home/asjudine/www/ingreso_recaudo_cartera.php
<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;
if(isset($_POST["consultar"]))
{
/*$sqlnom = "select cedula, apellidos_noms, codigo, grado, direccion, celular, telefono, email, entidad_laboral from datos_basicos_rc where cedula = '$ced'";
$control = mysql_query($sqlnom, $dbi) or die(mysql_error());
list($cedu, $apeno, $cod, $grad, $dire, $celul, $tele, $em, $el ) = mysql_fetch_array($control);*/
$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);
if($num==0)
{
$sqlnom2 = "select cedula, grado, nombre, neto from datos_credito where cedula = '$ced'";
$num2=mysql_num_rows($sqlnom2);
$control2 = mysql_query($sqlnom2, $dbi) or die(mysql_error());
list($cedu, $grad, $apeno, $sal) = mysql_fetch_array($control2);
}
}
if(isset($_POST["guardar"]))
{
$sql = "insert into datos_basicos_rc(cedula, apellidos_noms, codigo, grado, direccion, celular, telefono, ciudad, email, entidad_laboral)
value
('$cedb', '$apenom', '$cod', '$gra', '$dir', '$cel', '$tel', '$ciud','$email', '$entlab')";
mysql_query($sql, $dbi) or die(mysql_error());
echo "<script>alert('Los DATOS BASICOS fueron grabados correctamente');</script>";
}
?>
<!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>Recaudo Cartera</title>
<style type="text/css">
<!--
.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;
}
.Estilo1 {
color: #FF6633;
font-size: 24px;
font-style: italic;
}
.Estilo2 {
color: #FF6633;
font-size: 16px;
}
.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;
}
.Estilo3 {
color: #2492FF;
font-weight: bold;
}
.Estilo4 {
color: #FF1A1A;
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: 16px;
color: #5151FF;
background-color: #C4E4FD;
border: thin solid #009999;
}
.datos1 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 16px;
background-color: #FDE0C1;
margin: 2px;
padding: 3px;
border: medium doble #DBAED7;
}
.datos2 {
font-family: "Courier New", Courier, monospace;
font-size: 16px;
font-style: normal;
font-weight: normal;
color: #0033FF;
background-color: #FFE2C6;
margin: 2px;
padding: 3px;
border: medium doble #EEBFEB;
}
.datos1 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 16px;
font-weight: normal;
background-color: #B8F5E8;
margin: 4px;
padding: 5px;
border: thin outset #009999;
}
.Estilo8 {
font-size: 20px;
font-weight: bold;
}
.datos3 {
font-family: Arial, Helvetica, sans-serif;
font-size: 16px;
font-style: normal;
font-weight: normal;
color: #FF3300;
background-color: #A6ECD7;
margin: 4px;
padding: 4px;
border: medium groove #CCCCFF;
}
.Estilo10 {
font-size: 14px;
font-weight: bold;
}
.Estilo12 {font-size: 14px}
body {
background-color: #FBFCC9;
}
.Estilo15 {
font-size: 12px;
color: #000000;
font-weight: bold;
}
.Estilo16 {
color: #000000;
font-size: 12px;
}
.Estilo17 {color: #FF0000}
.boton111 {background-color: #FFCCCC; color:#FFFFFF; width:180px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
.Estilo50 {color: #CC3333;
font-family: "Arial Narrow";
font-weight: bold;
}
-->
</style>
<script type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</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">RECAUDO DE CARTERA</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>
<p> </p>
<table width="718" border="3" cellpadding="3" cellspacing="3" class="datos2">
<caption>
<span class="Estilo8">DATOS BASICOS </span>
</caption>
<tr>
<td width="154"><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 $apeno ?>" size="50" maxlength="50" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Cedula : </strong></div></td>
<td width="159"><div align="left">
<input name="cedb" type="text" class="campo1" id="cedb" value="<?php echo $cedu ?>" size="15" maxlength="15" />
</div></td>
<td width="96"><div align="center" class="Estilo12"><strong>Codigo : </strong></div></td>
<td width="256"><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="Estilo12"><strong>Grado : </strong></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="Estilo12"><strong>Direccion : </strong></div></td>
<td><div align="left">
<input name="dir" type="text" class="campo1" id="dir" value="<?php echo $dire ?>" size="30" maxlength="30" />
</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo12"><strong>Celular : </strong></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="Estilo12"><strong>Telefono : </strong></div></td>
<td><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="Estilo12"><strong>Ciudad : </strong></div></td>
<td colspan="3"><div align="left">
<input name="ciud" type="text" class="campo1" id="ciud" value="<?php echo $ciue ?>" size="25" maxlength="25" />
</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 $em ?>" size="25" maxlength="25" />
</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 $el ?>" size="35" maxlength="35" />
</div></td>
</tr>
</table>
<table width="406" height="46" border="3" cellpadding="3" cellspacing="3" class="datos2">
<tr>
<td width="282" height="32"><div align="center"><dfn><span class="Estilo15">Guardar Informacion Suministrada </span></dfn></div></td>
<td width="91"><label>
<div align="center">
<input name="guardar" type="submit" class="Estilo3" id="guardar" value="Guardar" />
</div>
</label></td>
</tr>
</table>
<table width="707" border="3" cellpadding="3" cellspacing="3" class="datos1">
<caption>
<span class="Estilo3"><br />
DATOS CREDITO </span>
<br />
</caption>
<tr>
<th scope="col"><div align="right"><span class="Estilo4">Proveedor : </span></div></th>
<th scope="col"><input name="proveedorcre" type="text" class="campo1" id="proveedorcre" value="<?php echo $pro ?>" size="15" maxlength="12" /></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" />
</div></th>
</tr>
<tr>
<th width="162" scope="col"><div align="right"><span class="Estilo4">Monto solicitado : </span></div></th>
<th width="157" scope="col"><label>
<input name="mon_sol" type="text" class="campo1" id="mon_sol" value="<?php echo $ms ?>" size="15" maxlength="12" />
</label></th>
<th width="165" scope="col"><div align="right"><span class="Estilo4">Salario :</span></div></th>
<th width="172" scope="col"><div align="left">
<input name="sala" type="text" class="campo1" id="sala" value="<?php echo $sal ?>" size="15" maxlength="12" />
</div></th>
</tr>
<tr>
<td><div align="right"><span class="Estilo4">Numero Cuotas : </span></div></td>
<td><input name="numerocuo" type="text" class="campo1" id="numerocuo" value="<?php echo $nc ?>" size="5" maxlength="2" /></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" />
</div></td>
</tr>
<tr>
<td><div align="right"><span class="Estilo4">Numero Cuenta :</span></div></td>
<td><input name="numcue" type="text" class="campo1" id="numcue" value="<?php echo $cah ?>" size="15" maxlength="15" /></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" />
</div></td>
</tr>
</table>
<p> </p>
<table width="655" border="3" cellpadding="3" cellspacing="3" class="campo1">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td width="282"><span class="Estilo16">Seleccione "<span class="Estilo17">proveedor</span>" para continuar</span></td>
<td width="212"><select name="menu1" onchange="MM_jumpMenu('parent',this,0)">
<option value="0">--SELECCIONE PROVEEDOR--</option>
<option value="../val_datos_cartera.php">SERVIASJUDINET</option>
</select></td>
<td width="121"><label></label></td>
</tr>
</table>
<p>
<input name="menu2" type="button" class="Estilo50" id="menu2" onclick="window.location.href='menu_recaudo_cartera.php'" value="IR AL MENU" />
</p>
</div>
</form>
</body>
</html>