<div class="content-wrapper">

  <section class="content-header">

    <h1>

      Reporte de Recuperacion

    </h1>

    <ol class="breadcrumb">

      <li><a href="inicio"><i class="fa fa-dashboard"></i> Inicio</a></li>

      <li class="active">Reporte de Recuperacion</li>

    </ol>

  </section>

  <section class="content">

    <div class="box">

      <div class="box-header with-border">



        <div class="form-row">

                    <div class="form-group col-md-3">
                      
                      <label for="inputCity">fecha de inicio:</label>
                      <div class="input-group">
                        <span class="input-group-addon"><i class="fa fa-audio-description"></i></span>
                        <input type="date" class="form-control" id="tipoServicio" name="tipoServicio" required>

                      </select>
                      </div>
                    </div>

                    <div class="form-group col-md-3">
                      <label for="inputCity">futuros filtros:</label>
                      <div class="input-group">
                      <span class="input-group-addon"><i class="fa fa-flag-checkered"></i></span>
                      <select class="form-control" id="estadoServicio" name="estadoServicio" required>
                              <option value="">Seleccione</option>
                              <option value="0">Activo</option>


                      </select>
                      </div>
                    </div>

                    <div class="form-group col-md-3">
                      <label for="inputCity">BLOQUE</label>
                      <div class="input-group">
                      <span class="input-group-addon"><i class="fa fa-flag-checkered"></i></span>
                      <?php
                        $zonas = ControladorDirecciones::ctrMostrarZona(); ?>
                      <select class="form-control" id="zonaReport" name="zonaReport" required>
                              <option value="">Seleccione</option>
                              <?php foreach($zonas as $fila){ ?>
                              <option value="<?= $fila['nombre_zona'] ?>"><?= $fila['nombre_zona'] ?></option>
                              <?php } ?>

                            </select>
                      </div>
                    </div>

                    <div class="form-group col-md-3">
                      <label for="inputCity"><i class="fa fa-file-pdf-o"></i> </label>
                      <div class="input-group">


                      
                      <button id="btnExportarExcel" class="btn btn-success">
                            <i class="fas fa-file-excel"></i> Exportar a Excel
                      </button>

                      </div>
                    </div>

                  </div>





      </div>

      <div class="box-body">

       <table class="table table-bordered table-striped dt-responsive tablas serviConti">

        <thead>

         <tr>

           <th style="width:10px">#</th>
           <th style="width: 50px;">BLOQUE</th>
           <th>DIPLOMADO</th>
           <th>TOTAL DE INSCRITOS</th>
           <th>ALUMNOS EN LISTA</th>
           <th>MONTO TOTAL</th>
           <th>MONTO COBRADO</th>
           <th>MONTO POR RECUPERAR</th>
           <th>MONTO ATRASADO</th>
           <th>PERDIDO POR BAJAS</th>
           <th>COMPLETADO</th>
           <th>ACTIVO</th>
           <th>ATRASADO</th>
           <th>BAJAS</th>

         </tr>

        </thead>

        <tbody id="serviCont">

        <?php

        $item = null;
        $valor = null;

        $contratos = ControladorContratos::ctrRecuperacion($item, $valor);
        //Parse error: syntax error, unexpected end of file in C:\xampp\htdocs\SisRecoleccion\vistas\modulos\contratos.php on line 111

       foreach ($contratos as $key => $value){

          echo ' <tr>
                  <td>'.($key+1).'</td>
                  <td>'.$value["BLOQUE"].'</td>';
                echo '<td>'.$value["DIPLOMADO"].'</td>';

                echo '<td>'.$value["TOTAL_INSCRITOS"].'</td>';
                echo '<td>'.$value["ALUMNOS ACTIVOS"].'</td>';
                echo '<td>$' . number_format($value["MONTO TOTAL"], 2) . '</td>';
                echo '<td>$' . number_format($value["MONTO_COBRADO"], 2) . '</td>';
                echo '<td>$' . number_format($value["MONTO_POR_RECUPERAR"], 2) . '</td>';
                echo '<td>$' . number_format($value["MONTO_ATRASADO"], 2) . '</td>';
                echo '<td>$' . number_format($value["PERDIDO_POR_BAJAS"], 2) . '</td>';
               echo '<td>'.$value["COMPLETADO"].'</td>';
               echo '<td>'.$value["ACTIVO"].'</td>';
               echo '<td>'.$value["ATRASADO"].'</td>';
               echo '<td>'.$value["BAJAS"].'</td>';
                

                echo '<td>'.$value["numromeses"].'</td>';


                      echo '</div>

                    </td>



                </tr>';
        }


        ?>

        </tbody>

       </table>

      </div>

    </div>

  </section>

</div>



<div id="modalEditarContrato" class="modal fade" role="dialog">

<div class="modal-dialog modal-lg">
    <div class="modal-content">

      <form role="form" method="post">







        <!--=====================================
        PIE DEL MODAL
        ======================================-->

        <div class="modal-footer">

          <button type="button" class="btn btn-danger pull-right" data-dismiss="modal">Close</button>


        </div>

      </form>

      </div>

  </div>

</div>
