<?php 
//=====================================================================================
//INICIO LA SESION---------------------------------------------------------------------
//=====================================================================================
session_start();
//=====================================================================================
//CONEXION-----------------------------------------------------------------------------
//=====================================================================================
require_once '../../../conn/conexion.php';
$bd = new connexion();
$bd->query("SET NAMES 'utf8'");
//=====================================================================================
//----------------VARIBLES-------------------------------------------------------------
//=====================================================================================

//=====================================================================================
//----------------ACCIONES-------------------------------------------------------------
//=====================================================================================
//=====================================================================================

echo'
<div class="container-fluid mt--6">
    <div class="col-12">
        <div class="row" id="panel_busq_incentivo">
            <div class="col-12">
                <div class="card bg-gradient-default shadow">
                    <div class="card-body">
                        <div class="row" align="center">
                            <div class="col-lg-10">
                                <div class="form-group">
                                    <div class="form-group mb-4" id="box_busq_incentivo">
                                        <input class="form-control" placeholder="Buscar por Nombre o c&oacute;digo de incentivo" type="text" id="txt_busq_incentivo">
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-2">
                                <button onclick="consultaIncentivos()" class="btn btn-icon btn-3 btn-primary btn-block" type="button">
                                    <span class="btn-inner--icon"><i class="fas fa-search"></i></span>
                                    <span class="btn-inner--text">Buscar</span>
                                </button>
                            </div>
                        </div>
                        <div class="row" align="left">
                            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                                <div class="custom-control custom-checkbox mb-3">
                                  <input class="custom-control-input" id="chk_fechas" type="checkbox">
                                  <label class="custom-control-label text-light" for="chk_fechas">Buscar por rango de fechas</label>
                                </div>
                            </div>
                        </div>
                        <div class="row" align="left" id="row_rango_fechas" style="display:none;">
                            <div class="col-xs-12 col-sm-12 col-md-6 col-lg-6">
                                <div class="form-group">
                                    <div class="input-group input-group-alternative">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text"><i class="ni ni-calendar-grid-58"></i></span>
                                        </div>
                                        <input class="form-control" placeholder="Select date" type="date" value="'.date("Y-m-d").'" id="txt_fecha_inicio">
                                    </div>
                                </div>
                            </div>
                            <div class="col-xs-12 col-sm-12 col-md-6 col-lg-6">
                                <div class="form-group">
                                    <div class="input-group input-group-alternative">
                                        <div class="input-group-prepend">
                                            <span class="input-group-text"><i class="ni ni-calendar-grid-58"></i></span>
                                        </div>
                                        <input class="form-control" placeholder="Select date" type="date" value="'.date("Y-m-d").'" id="txt_fecha_fin">
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row" align="left">
                            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                                <div class="custom-control custom-checkbox mb-3">
                                  <input class="custom-control-input" id="chk_estados" type="checkbox">
                                  <label class="custom-control-label text-light" for="chk_estados">Buscar por estado</label>
                                </div>
                            </div>
                        </div>
                        <div class="row" align="left" id="row_estados" style="display:none;">
                            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                                <div class="form-group">
                                    <select class="form-control" id="list_estados">
';
//CONSULTO LOS ESTADOS DISPONIBLES-----------------------------------------------------
$lista = consultarEstadosIncentivos($bd);
//RECORRO LOS CLIENTES-----------------------------------------------------------------
while ($row = $lista->fetch_object()){
            
echo'
                                        <option value="'.$row->MARCA2.'">'.$row->LITERAL.'</option> 
';
}
echo'
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
';
//=====================================================================================
//----------------FUNCIONES------------------------------------------------------------
//=====================================================================================
function consultarEstadosIncentivos($bd)
{
    $sql =  "   SELECT L.MARCA2, L.LITERAL
                FROM LISTAS_VALORES L
                WHERE L.TIPO = 'EST_VER' ORDER BY L.MARCA1 ASC";
    $base = $bd->query($sql);
    return $base;
    $base->close();
}
?>
