<?php

include ("../conexion.php");
    
require_once '../dompdf/autoload.inc.php';


require_once '../dompdf/lib/html5lib/Parser.php';
require_once '../dompdf/lib/php-font-lib/src/FontLib/Autoloader.php';
require_once '../dompdf/lib/php-svg-lib/src/autoload.php';
require_once '../dompdf/src/Autoloader.php';
Dompdf\Autoloader::register();

use Dompdf\Dompdf;





  $subtotcre = 0;
  $destotcre = 0;
  $impvencre = 0;
  $totalcre  = 0;
  $subtotcon = 0;
  $destotcon = 0;
  $impvencon = 0;
  $totalcon  = 0;
  $totalventas=0;
  	
  $where     = "";
	

$codigoHTML='

<!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>Lista</title>

</head>

   <script type="text/php">


        if ( isset($pdf) ) {

          $font = Font_Metrics::get_font("helvetica", "bold");
          $pdf->page_text(72, 18, "Header: {PAGE_NUM} of {PAGE_COUNT}", $font, 6, array(0,0,0));

        }
        
</script>
<body>
<div align="center">
  <p>&nbsp;</p>';
  
       $parametros = "SELECT * FROM web_0000 ";
       $result_parametros = $mysqli->query($parametros);
       $row_para = $result_parametros->fetch_array();
     
	   $NombreComercial =  $row_para["NOMCOM"];
	   $razsoc          =  $row_para["RAZSOC"];
	   $Direccion       =  $row_para["DIREMP"];
	   $Cedula          =  $row_para["CEDJUR"];
	   $Telefono        =  $row_para["NUMTEL"];


 
$codigoHTML='
    <table width="100%"  cellpadding="0" cellspacing="0"  border="0">
      <tr>
        <td width="13%" rowspan="4"><img src="../img/logo.jpg"  /></td>
        <td width="87%"><font color="red" size=4><strong>'.$NombreComercial.'</strong></font></td>
      </tr>
      <tr>
        <td height="12"><font size=2 >Cedula '.$Cedula.'</font></td>
      </tr>
      <tr>
        <td height="12"><font size=2 >'.$Direccion.'</font></td>
      </tr>
      <tr>
        <td height="22"><font size=2 >Numero de Telefono '.$Telefono.'</font></td>
      </tr>
    </table>';
  
  
  	 $fecini    = $_GET["fechainicio"];
	 $fecfin    = $_GET["fechafin"];
	 $cdgtipven = $_GET["combotipoventa"];
	 $cdgcli    = $_GET["cdgcli"];
	 	
	 
 $fechainicio = implode("-", array_reverse(explode("-", $fecini))); 
 $fechafin    = implode("-", array_reverse(explode("-", $fecfin))); 
   

	
	$where="1=1";
if ($cdgtipven <> "") { $where.=" AND cdgtipven='$cdgtipven'"; }
if ($cdgcli <> "") { $where.=" AND cdgcli='$cdgcli'"; }

if (($fechainicio<>"") and ($fechafin<>"")) {
	$where.=" AND fecha between '".$fechainicio."' AND '".$fechafin."'";
} else {
	if ($fechainicio<>"") {
		$where.=" and fecha >='".$fechainicio."'";
	} else {
		if ($fechafin<>"") {
			$where.=" and fecha <='".$fechafin."'";
		}
	}
}

 $fechainicio= implode("-", array_reverse(explode("-", $fecini))); 
 $fechafin= implode("-", array_reverse(explode("-", $fecfin))); 
	 

//$where.=" ORDER BY dsccli ASC";					
		
 if ($cdgcli=="") {
	   
	   	$dsccli="TODOS LOS CLIENTES";
	 
	     } else {

	 
	   $query_codcaj="SELECT * FROM web_0301 WHERE cdgcli=$cdgcli ";
       $resultado = $mysqli->query( $query_codcaj);
       $row = $resultado->fetch_array();
        
		 $dsccli    = $row["DSCCLI"];
	
     }
			
						 
	 $codigoHTML.='
  <table width="100%" height="16%" border="1" cellpadding="0" cellspacing="0" >
      <tr>
        <td width="100%" height="21" colspan="3" align="center"><font size=3 ><strong>Reporte  Ventas a Credito de '.$dsccli.' </strong></font></td>
      </tr>
      <tr>
        <td height="14" colspan="3" align="center">Fecha del <font size="2" >'.$fecini.'</font> al <font size="2" >'.$fecfin.'</font></td>
      </tr>
    </table>
  ';
	
	
	 $codigoHTML.='
<table width="100%" role="rows" cellpadding="0" cellspacing="0" border="1">
    <tr>
    

        <td width="80%" align="center" bgcolor="#CCCCCC"><font size=1 ><strong>Cliente</strong></font></td>
		<td width="10%" align="center" bgcolor="#CCCCCC"><font size=1 ><strong></strong></font></td>
        <td width="20%" align="right" bgcolor="#CCCCCC"><font size=1 ><strong>Subtotal </strong></font></td>
        <td width="20%" align="right" bgcolor="#CCCCCC"><font size=1 ><strong>Descuento </strong></font></td>
		<td width="20%" align="right" bgcolor="#CCCCCC"><font size=1 ><strong>Impuesto </strong></font></td>
        <td width="20%" align="right" bgcolor="#CCCCCC"><font size=1 ><strong>Total </strong></font></td>
 
      </tr>
	   </table>';
	   

	
		  $consulta2="SELECT  fecha, codfactura, numfactura, cdgcli, dsccli, pladia, sum(totalfactura) as totalfactura , sum(subtot) as subtot, sum(destot) as destot, sum(impven) as impven  FROM facturas WHERE borrado=0   AND cdgcli <> 9999 AND ".$where. " GROUP BY cdgcli ORDER BY dsccli ASC " ;

 		if ($resultado2 = $mysqli->query($consulta2)) 
        $count = 0;
 
  		while ($dato1 = $resultado2->fetch_assoc()) {
				$codfactura = $dato1['codfactura'];
				$numfactura = $dato1['numfactura'];
				$fecha      = $dato1['fecha'];
 				$fecha      = implode("-", array_reverse(explode("-", $fecha))); 		
				$cdgcli     = $dato1['cdgcli'];
				$cdgcli     = sprintf('%04d',$cdgcli) ;
				$dsccli     = $dato1['dsccli'];
				$dsccli     = substr($dsccli, 0, 45);
				$pladia     = $dato1['pladia'];
				$totalfactura = $dato1['totalfactura'];
				$subtot     = $dato1['subtot'];
				$impven     = $dato1['impven'];
				$destot     = $dato1['destot'];			 
		
		
		            if($count == 0 )		
                $codigoHTML.='<table width="100%"  rules="none" border="0">';

            $codigoHTML.='    		
			
    
      <tr>
  
   	    <td width="10%">  <font size=1 align="right">'.$cdgcli.'</font></td>
   	    <td width="70%">  <font size=1 align="left">'.$dsccli.'</font></td>
		<td width="10%" align="center">  <font size=1 ></font></td>
        <td width="20%" align="right">  <font size=1 >'.number_format($subtot, 2).'</font></td>
        <td width="20%" align="right">  <font size=1 >'.number_format($destot, 2).'</font></td>
		<td width="20%" align="right">  <font size=1 >'.number_format($impven, 2).'</font></td>
		<td width="20%" align="right">  <font size=1 >'.number_format($totalfactura, 2).'</font></td>
                  </tr> ';
              $count++;
       }
        if($count > 1) 
            $codigoHTML.='</table>';

		

		      /////////////////////////////   CIERRA LLAVES AGRUPADO POR CODIGO DIFERENTE A 9999 //////////////////////////////////////
		  
		  
		  
	
		  
	

	 $consulta3= ("SELECT SUM(totalfactura) AS total , SUM(subtot) AS subtotal, SUM(destot) AS descuento , SUM(impven) AS impuesto  FROM facturas WHERE borrado=0 AND ".$where );

	if ($resultado3 = $mysqli->query($consulta3)) 

  	 while ($dato = $resultado3->fetch_assoc()) {

				$total     = $dato["total"];
				$subtotal  = $dato["subtotal"];
				$descuento = $dato["descuento"];
				$impuesto  = $dato["impuesto"];
		
}

	
	
$codigoHTML.='
   <table width="100%" height="15" role="rows" cellpadding="0" cellspacing="0" border="1">
     <tr>
       <td height="15"><table width="100%" border="0" cellpadding="0" cellspacing="0">
         <tr>
            <td width="90%" height="12" align="left"><font size=2 > TOTALES FINALES</font></td>
              <td width="20%" align="right"><font size=1 >'.number_format($subtotal, 2).'</font></td>
               <td width="20%" align="right"><font size=1 >'.number_format($descuento, 2).'</font></td>
			  <td width="20%" align="right"><font size=1 >'.number_format($impuesto, 2).'</font></td>
		      <td width="20%" align="right"><font size=1 >'.number_format($total, 2).'</font></td>
         </tr>
       </table></td>
     </tr>
   </table>
   <p>';
   
    
$codigoHTML.='

   </p>

</div>
</body>
</html>';

$codigoHTML=utf8_decode($codigoHTML);
$dompdf=new DOMPDF();
$dompdf->set_paper( "A4", "landscape" ); // a4,horizontal
$dompdf->load_html($codigoHTML);
$dompdf->render();
// add the header
//$canvas = $dompdf->get_canvas();
//$font = Font_Metrics::get_font("helvetica", "bold");
//
//// the same call as in my previous example
//$canvas->page_text(745, 555, "Pagina : {PAGE_NUM} de {PAGE_COUNT}",
//                   $font, 8, array(0,0,0));

ini_set("memory_limit","7000M");

$dompdf->stream("Reporte_ventas_Credito.pdf", array("Attachment" => false));
 


?>
