File: /home/asjudine/www/creditos_seleccion_proveedor.php
<!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>Seleccion Proveedor Creditos</title>
<style type="text/css">
<!--
.lista {font-family: Arial; font-size: 11px; color: #990000;}
.texto {background-color: #CCFFCC; font-size: 11px; font-family: Arial; color:#0000CC; display: block;}
.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;
}
.Estilo16 { color: #000000;
font-size: 12px;
}
.Estilo17 {color: #FF0000}
.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;
}
.provd {
background-color: #FCF1DC;
}
.Estilo50 {color: #CC3333;
font-family: "Arial Narrow";
font-weight: bold;
}
.Estilo51 {color: #000099}
-->
</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 action="" method="post" name="form1" id="form1">
<div align="center">
<table width="655" border="3" cellpadding="3" cellspacing="3" class="campo1">
<tr>
<td colspan="3" bgcolor="#FEFFEA"><div align="center" class="Estilo51">PROVEEDORES CREDITOS </div></td>
</tr>
<tr>
<td width="282" bgcolor="#FEFFEA"><span class="Estilo16">Seleccione "<span class="Estilo17">proveedor</span>" para continuar</span></td>
<td width="212" bgcolor="#FEFFEA"><select name="proveedor" id="proveedor">
<option value="">--SELECCIONE PROVEEDOR--</option>
<option value="COOMANUFACTURAS">COOMANUFACTURAS</option>
<option value="HERNANDO ROSERO">HERNANDO ROSERO</option>
<option value="EFRAIN LARGO">EFRAIN LARGO</option>
<option value="EFRAIN LARGO DOS">EFRAIN LARGO DOS</option>
<option value="SERVIASJUDINET LTDA">SERVIASJUDINET LTDA</option>
</select></td>
<td width="121" bgcolor="#FEFFEA"><label></label></td>
</tr>
</table>
<p>
<input name="consultar" type="submit" class="Estilo50" value ="CONSULTAR" >
<input name="menu2" type="button" class="Estilo50" id="menu2" onclick="window.location.href='menu_gerencia_financiera.php'" value="IR AL MENU" />
</p>
</div>
</form>
</body>
</html>
<?php
if(isset($_POST["consultar"]))
{
echo "<form name='form' action='' method='post'>";
require_once("mainfile.php");
include ("config.php");
global $dbi;
require_once("Conectarse.php");
$total_desembolso = 0;
$total_int_ded = 0;
$nocred=0;
$mssql = mysql_query('SELECT * FROM creditos_serviasjudinet WHERE estado = "1"');
if (!$mssql) {
die('Invalid query: ' . mysql_error());
}
if($mssql)
{
$filas = mysql_num_rows($mssql);
if ($filas > 0)
{
$control = mysql_query('SELECT cedula, nombre, grado, cuenta_ahorros, banco, valor_credito, neto_consignar, interes_deducible, numero_libranza FROM creditos_serviasjudinet WHERE proveedor = "' . $_POST[proveedor] . '" and estado = "1" order by nombre ');
if (!$control) {
die('Invalid query: ' . mysql_error());
}
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE width='900' border='1' align='center' cellpadding='0' cellspacing='1'>
<TR>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>GRADO</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'># CUENTA</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>BANCO</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>MONTO SOLICITADO</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VALOR CONSIGNAR</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>INTERES DEDUCIBLE</span></div></TD>
<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>No. LIBRANZA</span></div></TD>";
while(list($cedula, $nombres, $grad, $cuenta_ahorros, $banco_cuenta, $monto, $neto_consignar, $interes, $numlib) = mysql_fetch_row($control))
{
$nocred++;
$valor_desembolso = $valor_desembolso + $neto_consignar;
$total_int_ded = $total_int_ded + $interes;
printf("<tr>
<TD bgcolor='#F7FFE1'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='credito_consulta_proveedor_mf.php?ced2=$cedula&numlib=$numlib'></a></span></div></TD>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$nombres."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$grad."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$cuenta_ahorros."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$banco_cuenta."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$monto."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$neto_consignar."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$interes."</span></div></td>
<td bgcolor='#F7FFE1'><div align='center' class='lista'>".$numlib."</span></div></td>");
}
echo "</table>";
}
echo "<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TOTAL DESEMBOLSO</span></div></TD>";
echo "<td bgcolor='#C5D6FC'><div align='center' class='lista2'>".$valor_desembolso."</span></div></td>";
echo "<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TOTAL INTERES DEDUCIBLE</span></div></TD>";
echo "<td bgcolor='#C5D6FC'><div align='center' class='lista2'>".$total_int_ded."</span></div></td>";
echo "<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>No CREDITOS</span></div></TD>";
echo "<td bgcolor='#C5D6FC'><div align='center' class='lista2'>".$nocred."</span></div></td>";
}
}
echo "</form>";
}
?>