File: /home/asjudine/www/exp_pagad.php
<?PHP
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: filename=\"REPORTE_MINDEFENSA.XLS\";");
require_once("mainfile.php");
include ("config.php");
global $dbi;
$sql = "select codigo, nombre, grado, cod_desc, libranza, fecha_libranza, valor_descuento, cuotas, pagaduria, mes_inicio, aņo_inicio, mes_termino, aņo_termino, proveedor from reporte_mindefensa where estado = '0' order by nombre";
$control = mysql_query($sql, $dbi) or die(mysql_error());
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE widTD='1000' border='0' align='center' cellpadding='0' cellspacing='1'>";
echo "<TR><TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>CODIGO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>GRADO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>COD DESC</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>N. LIB</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>FECHA LIB</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>DESCUENTO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>CUOTAS</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>PAGADURIA</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>MES INICIO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>AŅO INICIO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>MES TERMINO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>AŅO TERMINO</span></div></TH>
<TH bgcolor='#FFFFCC'><div align='center'><span class='texto'>PROVEEDOR</span></div></TH> </TR>";
while(list($codigo, $nombre, $grado, $cod_desc, $libranza, $fecha_libranza, $valor_descuento, $cuotas, $pagaduria, $mes_inicio, $aņo_inicio, $mes_termino, $aņo_termino, $proveedor) = mysql_fetch_array($control))
{
echo "<TR>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$codigo."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombre."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$grado."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$cod_desc."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$libranza."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$fecha_libranza."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$valor_descuento."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$cuotas."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$pagaduria."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$mes_inicio."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$aņo_inicio."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$mes_termino."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$aņo_termino."</span></div></TD>
<TD bgcolor='#C5D6FC'><div align='center' class='lista'>".$proveedor."</span></div></TD> </TR>";
}
}
echo "</TABLE>";
?>