{% extends '::base.html.twig' %}
{% block title %}Consulta Inventario{% endblock %}

{% block dashboard %}
<script>
    $(function(){
        $('button').button();
                    $('.reportes').buttonset();
                    /*$('#sitio').change(function(){
                        if($('#sitio').val()=='todos'){
                        $('#region').removeAttr('disabled');
                            
                        }else{
                        $('#region').attr('disabled', 'disabled');
                        $('#region option[name="todos"]').attr('selected','selected');
                        }
                    });*/
                    $('#region').change(function(){
                        $('#consultaSitiosReportes').load('{{path("consultaSitiosReportesCO")}}',{$region:$('#region').val()});
                        if($('#region').val()=='todos'){
                        $('#sitio').removeAttr('disabled');
                            
                        }else{
                        $('#sitio').attr('disabled', 'disabled');
                        $('#sitio option[name="todos"]').attr('selected','selected');
                        }
                    });
                    $('input:radio').click(function(){
                        if($(this).val()=='energia'){
                            $('#MarcaEnergia').css('display','');
                            $('#MarcaRf').css('display','none');
                            $('#MarcaEnlaces').css('display','none');
                            $('#MarcaMux').css('display','none');
                        }else if($(this).val()=='rf'){
                            $('#MarcaEnergia').css('display','none');
                            $('#MarcaRf').css('display','');
                            $('#MarcaEnlaces').css('display','none');
                            $('#MarcaMux').css('display','none');
                            
                        }else if($(this).val()=='enlaces'){
                            $('#MarcaEnergia').css('display','none');
                            $('#MarcaRf').css('display','none');
                            $('#MarcaEnlaces').css('display','');
                            $('#MarcaMux').css('display','none');
                            
                        }else if($(this).val()=='mux'){
                            $('#MarcaEnergia').css('display','none');
                            $('#MarcaRf').css('display','none');
                            $('#MarcaEnlaces').css('display','none');
                            $('#MarcaMux').css('display','');
                            
                        }
                    });
    })
    function chekea(){
    $("#sitio2").val($("#sitio").val());
    }
</script>
<style>
#content_outmiddle {
float: right;
width: 78%;
color: #002561;
}
.column { width: 100%; padding-bottom: 100px; }
	.portlet { margin: 0 1em 1em 0; }
	.portlet-header { margin: 0.3em; padding-bottom: 4px; padding-left: 0.2em; }
	.portlet-header .ui-icon { float: right; }
	.portlet-content { padding: 0.4em; }
	.ui-sortable-placeholder { border: 1px dotted black; visibility: visible !important; height: 50px !important; }
	.ui-sortable-placeholder * { visibility: hidden; }
</style>

<table style=" margin: auto;" class=" ui-widget ui-widget-content tabla1">
    <tr class=" ui-widget-header " style=" font-size: 12px;">
        <td colspan="4">RESUMEN INVENTARIOS POR SITIOS</td>
    </tr>
    <tr style=" font-size: 16px;">
        <td colspan="2">Sitios inventariados</td>
        <td Colspan="2">{{porcInv}}</td>
    </tr>
    <tr  class=" ui-widget-header ">
        <td colspan="2">ENERGIA</td>
        <td colspan="2">CELULAR</td>
    </tr>
    <tr>
    
                <td>Aires</td>
                <td>{{inv3}}</td>
                <td >Bastidor 2G</td>
                <td>{{inv1}}</td>
    </tr>
    <tr>
                <td>Baterias</td>
                <td>{{inv4}}</td>
                <td >Bastidor 3G</td>
                <td>{{inv2}}</td>
    </tr>
    <tr>
                <td>Plantas</td>
                <td>{{inv7}}</td>
                <td >DAS</td>
                <td>{{inv5}}</td>
    </tr>
    <tr>
                <td>Rectificadores</td>
                <td>{{inv9}}</td>
                <td >MULTIPLEXOR NEC</td>
                <td>{{inv6}}</td>
    </tr>
    <tr>
                <td>SPT</td>
                <td>{{inv11}}</td>
                <td >Radio MO</td>
                <td>{{inv8}}</td>
    </tr>
    <tr>
                <td>Tablero TGD</td>
                <td>{{inv12}}</td>
                <td >Router</td>
                <td>{{inv10}}</td>
    </tr>
    <tr>
                <td>Tansformador</td>
                <td>{{inv13}}</td>
                <td >Sonda</td>
                <td>{{inv14}}</td>
    </tr>
    <tr>
    <tr>
                <td></td>
                <td></td>
                <td>XPIC</td>
                <td>{{inv1}}</td>
    </tr>
    <tr>
        <td></td>
        <td></td>
        <td>LTE</td>
        <td>{{inv15}}</td>
    </tr>
    <tr>
</table>
<form action="{{path('ExcelEnergiaCOCLARO')}}" method="POST" onsubmit="return chekea()" >
<table class="ui-widget ui-widget-content reportes" style="width: 80%; margin: auto;">
    <tr>
        <td colspan="4" style="text-align:center;">
            <div class="col-lg-4">
                <label>Seleccione</label>

                <select class="form-control" name="reporte">
                    <option VALUE="energia">ENERGIA</option>
                    <option VALUE="rf">Celular</option>
                </select>
            </div>
        </td>
    </tr>
    <tr>
        <td>Sitios</td>
        <td>
            <input type="hidden" name="sitio2" id="sitio2">
            <div id="consultaSitiosReportes">
            <select id="sitio"  size="10"  name="sitio" multiple="multiple"  tabindex="1">
                <option selected="true" value="todos">Todos</option>
                {% for sitio in sitios%}
                    <option value="{{sitio.site_id}}">{{sitio.nombre}} </option>
                {%endfor%}
            </select>
                </div>
        </td>
        <td>Región</td>
        <td>
            <select id="region" name="region">
                <option value="todos">Todos</option>
               {%  for region in regiones %}
                    <option value="{{region.idregion}}">{{region.region}}</option>
                {% endfor %}
            </select>
        </td>
        </tr>
        <tr>
        <td>
        TIPO
        </td>
        <td>
            <select id="MarcaEnergia" name="tipo" style="width: 350px;">
                <option value="todas">Todas</option>
                <option value="aa">Aires</option>
                <option value="baterias">Baterias</option>
                <option value="planta">Plantas</option>
                <option value="rectificador">Rectificadores</option>
                <option value="spt">SPT</option>
                <option value="tableroTGD">Tablero TGD</option>
                <option value="transformador">Tansformador</option>
            </select>
            <select id="MarcaRf" name="tipo2"  style="width: 350px; display: none;">
                <option value="todas">Todas</option>
                <option value="bastidor2g">Bastidor 2G</option>
                <option value="bastidor3g">Bastidor 3G</option>
                <option value="das">DAS</option>
                <option value="multiplexorNEC">MULTIPLEXOR NEC</option>
                <option value="radiomo">Radio MO</option>
                <option value="router">Router</option>
                <option value="sonda">Sonda</option>
                <option value="xpic">XPIC</option>
                <option value="lte">LTE</option>
                {%for marca in marcaRf%}
                    <option value="{{marca.idMarca}}">{{marca.nomTipo}}--{{marca.nomMarca}}</option>
                {%endfor%}
            </select>
        </td>
        </tr>
        <tr>
            <td colspan="4" style="text-align:center">
            <button type="submit">Descargar</button>
        </td>
    </tr>
</table>
</form>
<br>
<div id="consultaInventario"></div>


{% endblock %}    
{% block menuRight %}
{% endblock %}
{% block menuleft %}  
        {% render "PortalBundle:Default:MenuLeftInventarioCOCLARO"  %}
{% endblock %}
{% block menuTop %}
{% endblock %}