<style type="text/css">
  <!--
  table { vertical-align: top; }
  tr    { vertical-align: top; }
  td    { vertical-align: top; }
  .midnight-blue{
    background:#2c3e50;
    padding: 4px 4px 4px;
    color:white;
    font-weight:bold;
    font-size:12px;
  }
  .silver{
    background:white;
    padding: 3px 4px 3px;
  }
  .clouds{
    background:#ecf0f1;
    padding: 3px 4px 3px;
  }
  .border-top{
    border-top: solid 1px #bdc3c7;

  }
  .border-left{
    border-left: solid 1px #bdc3c7;
  }
  .border-right{
    border-right: solid 1px #bdc3c7;
  }
  .border-bottom{
    border-bottom: solid 1px #bdc3c7;
  }
  table.page_footer {width: 100%; border: none; background-color: white; padding: 2mm;border-collapse:collapse; border: none;}
}
-->
</style>
<page pageset='new' backtop='10mm' backbottom='10mm' backleft='20mm' backright='20mm' style="font-size: 13px; font-family: helvetica">
  <page_header>
  <table style="width: 100%; border: solid 0px black;" cellspacing=0>
    <tr>
      <td style="text-align: left;    width: 33%"></td>
      <td style="text-align: center;    width: 34%;font-size: 14px; font-weight: bold">Reporte de Clientes</td>
      <td style="text-align: right;    width: 33%"><?php echo date('d/m/Y'); ?></td>
    </tr>
  </table>
  </page_header>
  <?php include "encabezado_general.php";?>

  <table class="table-bordered" style="width:100%;">
    <tr class="midnight-blue">
      <th style="width:6%;">ID</th>
      <th style="width:20%;">NOMBRE</th>
      <th style="width:10%;">DOCUMENTO</th>
      <th style="width:8%;">TELEFONO</th>
      <th style="width:15%;">EMAIL</th>
      <th style="width:25%;">DIRECCIÓN</th>
      <th style="width:10%;">AGREGADO</th>
      <th style="width:8%;">ESTADO</th>
    </tr>
    <?php
$sumador_total  = 0;
$simbolo_moneda = get_row('perfil', 'moneda', 'id_perfil', 1);
while ($row = mysqli_fetch_array($query)) {
    $codigo              = $row['id_proveedor'];
    $nombre_proveedor    = $row['nombre_proveedor'];
    $fiscal_documento    = $row['fiscal_proveedor'];
    $telefono_proveedor  = $row['telefono_proveedor'];
    $email_proveedor     = $row['email_proveedor'];
    $direccion_proveedor = $row['direccion_proveedor'];
    $status_proveedor    = $row['estado_proveedor'];
    $date_added          = date('d/m/Y', strtotime($row['date_added']));

    if ($status_proveedor == 1) {
        $estado = "Activo";
    } else {
        $estado = "Inactivo";
    }
    ?>
    <tr>
     <td class='text-center'><?php echo $codigo; ?></td>
     <td class='text-left'><?php echo $nombre_proveedor; ?></td>
     <td class='text-left'><?php echo $fiscal_documento; ?></td>
     <td class='text-center'><?php echo $telefono_proveedor ?></td>
     <td class='text-center'><?php echo $email_proveedor ?></td>
     <td class='text-center'><?php echo $direccion_proveedor ?></td>
     <td class='text-center'><?php echo $date_added ?></td>
     <td class='text-center'><?php echo $estado ?></td>
   </tr>
   <?php
}

?>
</table>
<page_footer>
<table style="width: 100%; border: solid 0px black;">
  <tr>
    <td style="text-align: left;    width: 50%"></td>
    <td style="text-align: right;    width: 50%">page [[page_cu]]/[[page_nb]]</td>
  </tr>
</table>
</page_footer>
</page>