/sicpri/01_cobranzas/_pdf.php

<?php 
session_start(); 
ob_start();
require("../../poo/clases/getConection.php");
$cn=new getConection();
$sql=utf8_decode(base64_decode($_GET['s']));
$cn->ejecutar_sql(base64_encode($sql));
?>
<style type="text/css">
<!--
    table.page_header {width: 100%; border: none; background-color: #ededed; color:#666666; border-bottom: solid 1mm #666666; padding: 2mm }
    table.page_footer {width: 100%; border: none; background-color: #ededed; color:#666666; border-top: solid 1mm #666666; padding: 2mm}
	#list_rpt{ margin:0 auto; font-size:10px;}
-->
</style>
<page backtop="15mm" backbottom="15mm" backleft="3mm" backright="3mm" style="font-size: 11pt">
    <page_header>
        <table class="page_header">
            <tr><td style="width: 100%; text-align: left">Sistema Integral de Control y Procesos de Racaudaci&oacute;n de Inmuebles</td></tr>
        </table>
    </page_header>
    <page_footer>
        <table class="page_footer">
            <tr><td style="width: 100%; text-align: right">p&aacute;gina [[page_cu]]/[[page_nb]]</td></tr>
        </table>
    </page_footer>
    <!-- ############################################## inicio ############################################## -->  
	<table id="list_rpt" style="width: 100%;" align="center">
	<thead>
	   <tr bgcolor="#b9bdc4">
	        <th style="width: 2%; text-align: center;">N&ordm;</th> 
	        <th style="width: 8%; text-align: center;">CODIGO</th>
	        <th style="width: 8%; text-align: center;">FECHA REG.</th>
	        <th style="width: 10%; text-align: center;">ESTADO</th>
            <th style="width: 5%; text-align: center;">TIPO</th>
   	        <th style="width: 10%; text-align: center;">UBICACI&Oacute;N</th>                   
   	        <th style="width: 10%; text-align: center;">OPERACI&Oacute;N</th>
   	        <th style="width: 10%; text-align: center;">PRECIO</th>
            <th style="width: 10%; text-align: center;">AREA TOTAL</th>
            <th style="width: 10%; text-align: center;">AREA CONST</th>            
        </tr>     
	</thead>
	<tbody>
    <?php $i=1; while($cell=$cn->resultado_sql()){ ?>
      <tr bgcolor="<?=($i%2==0)?"#ffffff":"#e2e4ff"?>">
        <td align="center"><?=$i++?></td>        
        <td align="center"><?=$cell['cod_prp']?></td>
        <td align="center"><?=$cell['fecha']?></td>    
        <td align="center"><?=$cell['est']?></td>
        <td align="center">
		<?php 
		echo ($cell['residencial']==1)?" R":"";
		echo ($cell['comercial']==1)?" C":"";
		echo ($cell['industrial']==1)?" I":"";
		echo ($cell['terreno']==1)?" T":"";
		echo ($cell['proyecto']==1)?" P":"";
		?>
        </td>
        <td align="left"><?=$cell['nom_dep']." - ".$cell['nom_prv']." - ".$cell['nom_dst'];?></td>
        <td align="center"><?=$cell['opr']?></td>    
        <td align="right"><span><?=($cell['mon_prp']=="$")?$cell['mon_prp']:"S/."?></span><?=number_format($cell['prc_prp'],2,".",",")?></td>  
        <td align="right"><?=$cell['art_prp']?></td>  
        <td align="right"><?=$cell['act_prp']?></td>    
      </tr>
    <?php } $cn->limpiar_sql(); $cn->cerrar_sql(); ?>
    </tbody>
    </table>
    <!-- ############################################## inicio ############################################## -->    
</page>
    <?php
	
    $content = ob_get_clean();
    $nombre="reporte.pdf";
	#$fuente=$cell['fuente'];

    require_once('../../poo/html2pdf_v4.03/html2pdf.class.php');
    try{
        #$html2pdf = new HTML2PDF('P', 'A4', 'fr');
		$html2pdf = new HTML2PDF('P', 'A4', 'es', true, 'UTF-8', 0);
        #$html2pdf->pdf->IncludeJS($script);
		#$html2pdf->setDefaultFont($fuente);
        $html2pdf->writeHTML($content, isset($_GET['vuehtml']));
		#$html2pdf->createIndex('Índice', 25, 12, false, true, 1);
        $html2pdf->Output("sicpri_reporte_propiedades.pdf");
    }catch(HTML2PDF_exception $e) {
        echo $e;
        exit;
    }
?>