<?php
  $seccion      = 'Eventos';
  $position     = '../';

  require_once($position.'../switch/access.php');
  require_once($position.'assets/global.php');
  require_once($position.'assets/session.php');
  require_once($position.'assets/funciones.php');

  //Buscador
  $Where = "
    WHERE
      eve.id != 0
  ";

  if( $_GET['buscar'] == 'Ok' ){

    //Nombre
    if( $_GET['nombre'] ){
      $nom = $_GET['nombre'];
      $Where .= "
        AND eve.nombre LIKE '$nom%'
      ";
    }

    //Fecha Inicio
    if( $_GET['fechainicio'] && $_GET['fechalimite'] ){
      $fei = $_GET['fechainicio'];
      $Where .= "
        AND eve.fecha_inicio BETWEEN '$fei' AND '$fel'
      ";
    }

  }

  //Query's
  $Query = "
    SELECT
      eve.id,
      eve.fecha_inicio, eve.fecha_limite,
      eve.nombre, eve.activo,
      cli.id AS idcliente, cli.nombre as cliente,
      tip.nombre AS tipo_usuario
    FROM eventos eve
    LEFT JOIN clientes cli ON cli.id = eve.fk_cliente
    LEFT JOIN usuarios_tipos tip ON tip.id = eve.fk_usuario_tipo
    $Where
      ORDER BY eve.fecha_inicio ASC
  ";
  $Eventos = mysqli_query($mysqli, $Query);

?>
<!DOCTYPE html>
<html lang="es_MX">
  <?php require_once($position.'head.php'); ?>
  <body class="loading" data-layout='{"mode": "light", "width": "fluid", "menuPosition": "fixed", "sidebar": { "color": "dark", "size": "default", "showuser": false}, "topbar": {"color": "light"}, "showRightSidebarOnPageLoad": false}'>

      <!-- Pagina de inicio -->
      <div id="wrapper">

          <!-- ========== Inicio nav-izq ========== -->
          <?php include_once($position.'assets/nav.php'); ?>
          <!-- Fin nav-izq -->

          <!-- ============================================================== -->
          <!-- Incio de Contenido -->
          <!-- ============================================================== -->

          <div class="content-page">
              <div class="content">

                  <!-- Topbar -->
                  <?php include_once($position.'assets/topbar.php'); ?>
                  <!-- /Topbar -->

                  <!-- Content-->
                  <div class="container-fluid">

                      <!-- page title -->
                      <div class="row">
                        <div class="col-12">
                          <div class="page-title-box">
                            <h4 class="page-title"><?php echo $seccion; ?></h4>
                            <div class="page-title-right">
                              <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="<?php echo $dir; ?>inicio/">Inicio</a></li>
                                <li class="breadcrumb-item active"><?php echo $seccion; ?></li>
                              </ol>
                            </div>
                          </div>
                        </div>
                      </div>
                      <!-- /page title -->

                      <!-- Botones -->
          						<div class="row">
          							<div class="col-12 text-right">
          								<button type="button" class="btn btn-sp btn-sm" onclick="window.location.href='evento'">
                            <i class="fe-plus"></i>&nbsp; Nuevo Evento</button>
          							</div>
          							<div class="col-12" style="height: 5px;">&nbsp;</div>
          						</div>

          						<!-- usuarios -->
                      <div class="row">
                        <div class="col-12">
                          <div class="card">
                              <div class="card-body">
                                <h4 class="header-title">Lista de <?php echo $seccion; ?></h4>
                                <p class="text-muted font-13 mb-4">
                                  Eventos
                                </p>

                                <!-- Tabla -->
                                <table id="" class="table dt-responsive nowrap w-100">
                                  <thead>
                                    <tr>
                                      <th>Nombre</th>
                                      <th>Tipo de Usuario</th>
                                      <th>Cliente</th>
                                      <th>Estatus</th>
            													<th></th>
                                      <th></th>
                                    </tr>
                                  </thead>
                                  <tbody>
										              <?php
                                    mysqli_data_seek($Eventos, 0);
                                    while($Eve = mysqli_fetch_array($Eventos)) {
                                  ?>
                                    <tr>

                                      <!-- Nombre -->
                                      <td>
                                        <div>
                                          <?php echo $Eve['nombre']; ?>
                                        </div>
                                        <div>
                                          <i class="fa fa-calendar text-success m-r-5"></i>
                                          <?php echo cambio_fecha_numerica_texto($Eve['fecha_inicio']); ?>
                                        </div>
                                        <div>
                                          <i class="fa fa-calendar text-danger m-r-5"></i>
                                          <?php echo cambio_fecha_numerica_texto($Eve['fecha_limite']); ?>
                                        </div>
                                      </td>
                                      <!-- End Nombre -->

                                      <!-- Tipo de Usuario -->
                                      <td>
                                        <i class="fa fa-user text-success m-r-5"></i>
                                        <?php echo $Eve[tipo_usuario]; ?>
                                      </td>
                                      <!-- End Tipo de Usuario -->

                                      <!-- Cliente-->
                                      <td>
                                        <?php echo $Eve['cliente']; ?>
                                      </td>
                                      <!-- End Cliente -->

                                      <!-- Btn Activo-->
                                      <td>
            														<?php if ($Eve['activo'] == 1){$btnClass = "btn-success"; $btnStatus = "Activo";}else{$btnClass = "btn-primary"; $btnStatus = "Inactivo";}?>
            														<button class="btn <?php echo $btnClass ?> btn-xs"><?php echo $btnStatus ?></button>
                                      </td>
                                      <!-- End Btn Activo-->

                                      <!-- Btn Editar -->
                                      <td>
                                        <a class="btn  btn-outline-secondary waves-effect btn-xs" href="evento?id=<?php echo $Eve['id'];?>">
                                          <i class="fe-edit-1"></i>
                                          Editar
                                        </a>
                                      </td>
                                      <!-- End Btn Editar -->

                                      <!-- Btn Borrar -->
                                      <td>
                                        <a class="btn btn-danger waves-effect waves-light btn-xs" href="#?id=<?php echo $Eve['id'];?>">
                                          <i class="fa fa-times"></i>
                                        </a>
                                      </td>
                                      <!-- End Btn Borrar -->

                                    </tr>
										               <?php } ?>
                                </tbody>
                              </table>
                              <!-- End Tabla -->

                            </div> <!-- end card body-->
                          </div> <!-- end card -->
                        </div><!-- end col-->
                      </div>
                      <!-- /secciones -->

                  </div> <!-- /container -->

              </div> <!-- /content -->

              <!-- Footer -->
              <?php include_once($position.'assets/footer.php'); ?>
              <!-- /Footer -->

          </div>

          <!-- ============================================================== -->
          <!-- Fin de Contenido -->
          <!-- ============================================================== -->


      </div>
      <!--  /wrapper -->

      <?php require_once($position.'scripts.php') ?>

  </body>
</html>
