@include('junta::sidebar.dyna')

<ol class="breadcrumb">
    <li>
        <a href="/dashboard"><i class="entypo-home"></i> INICIO</a>
    </li>
    <li>
        <a href="/dashboard/15/junta?company=dyna"><i class="fa fa-dollar"></i> JUNTA DIRECTIVA</a>
    </li>

    <li>
        <a href="/dashboard/15/junta?company=dyna"><i class="fa fa-building-o"></i> DYNA</a>
    </li>

    <li class="active">
        <strong>{{ $title }}</strong>
    </li>
</ol>

<hr />

<div class="row">

    <div class="col-md-12">

        <div class="panel panel-warning">
            <div class="panel-heading">
                <div class="panel-title">
                    <h2><i class="fa fa-bank"></i> {{ $title }}</h2>
                </div>
                <div class="panel-options">

                </div>
            </div>
            <div class="panel-body">

                <form>
                    <div class="form-group col-md-3">
                        <label for="minimal-radio-1-2" class="control-label" id="minimal-radio-1-2">Seleccione Año</label>&nbsp;
                        <select name="historico" class="form-control select2" data-allow-clear="true" placeholder="Seleccione...">

                            <!--<option value="2020"{{ (Input::get('historico', date('Y')) == 2020 ) ? 'selected' : ''  }} >2020</option>
                            <option value="2019"{{ (Input::get('historico', date('Y')) == 2019 ) ? 'selected' : ''  }} >2019</option>
                            <option value="2018"{{ (Input::get('historico', date('Y')) == 2018 ) ? 'selected' : ''  }} >2018</option>
                            <option value="2017"{{ (Input::get('historico', date('Y')) == 2017 ) ? 'selected' : ''  }} >2017</option>-->
                            <option value="2016"{{ (Input::get('historico', date('Y')) == 2016 ) ? 'selected' : ''  }} >2016</option>
                            <option value="2015"{{ (Input::get('historico', date('Y')) == 2015 ) ? 'selected' : ''  }} >2015</option>
                            <option value="2014"{{ (Input::get('historico', date('Y')) == 2014 ) ? 'selected' : ''  }} >2014</option>
                        </select>
                    </div>
                    <div class="col-md-3">
                        <label class="control-label">&nbsp;<br /></label>
                        <br />
                        <button type="submit" class="btn btn-lg btn-default btn-icon"><i class="fa fa-search"></i> Buscar</button>
                    </div>
                </form>

                <div class="clearfix"></div>

                <hr />

                @if( $exitsData == true )
                    <table class="table table-striped table-bordered table-hover" cellspacing="0"  style="width: 2000px;" id="pyg-table">
                        <thead>
                            <tr>
                                <th style="text-align: center; width: 300px;">Detalle</th>
                                @for ($i = 1; $i <= 12; $i++)
                                    <th style="text-align: center">{{ \Utils::getNombreMes( $i ) }}</th>
                                    <th style="text-align: center">P%</th>
                                @endfor
                            </tr>
                        </thead>
                        <tbody>

                            <!-- VENTAS NETAS -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-ventas-netas">VENTAS NETAS</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $total_41['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($total_41['saldo'.$i] / $total_41['saldo'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- COSTO VENTAS NETAS -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-costo-neto">COSTO DE VENTAS NETO</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $total_costo['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($total_costo['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- MARGEN DE CONTRIBUCIÓN -->
                            <tr class="revisadoRow">
                                <td>MARGEN DE CONTRIBUCIÓN</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $margen_contribucion['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($margen_contribucion['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <tr>
                                <td></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td></td>
                                    <td></td>
                                @endfor
                            </tr>

                            <!-- GASTOS DE VENTAS -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-gastos-ventas">GASTOS DE VENTAS</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $total_52['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($total_52['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- GASTOS DE ADMON -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-gastos-admon">GASTOS DE ADMINISTRACIÓN</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $total_51['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($total_51['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- TOTAL GASTOS OPERACIONALES -->
                            <tr class="revisadoRow4">
                                <td>TOTAL GASTOS OPERACIONALES</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $calculos['gastosop_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @( $calculos['gastosop_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor

                            </tr>
                            <tr class="revisadoRow">
                                <td>EBITDA</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $calculos['ebitda_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @( $calculos['ebitda_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <tr>
                                <td></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td></td>
                                    <td></td>
                                @endfor
                            </tr>


                            <!-- GASTO DE ADMON - DEPRECIACIONES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-5160">{{ $datos[5160]['descripcion'] }}</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $datos[5160]['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($datos[5160]['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- GASTO DE ADMON - AMORTIZACIONES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-5165">{{ $datos[5165]['descripcion'] }}</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $datos[5165]['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($datos[5165]['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- TOTAL GASTOS OPERACIONALES -->
                            <tr class="revisadoRow">
                                <td>UTILIDAD OPERACIONAL</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $calculos['utilidad_op_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @( $calculos['utilidad_op_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <tr>
                                <td></td>

                                @for ($i = 1; $i <= 12; $i++)
                                <td></td>
                                <td></td>
                                @endfor
                            </tr>

                            <!-- INGRESOS NO OPERACIONALES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-42">{{ $datos[42]['descripcion'] }}</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $total_42['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($total_42['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>
                            <!-- GASTOS NO OPERACIONALES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-53">{{ $datos[53]['descripcion'] }}</a></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $datos[53]['saldo_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($datos[53]['saldo_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- UTILIDAD ANTES DE IMPUESTOS = UTILIDAD OPERACIONAL + 42 - 53 (UIA)-->
                            <tr class="revisadoRow">
                                <td>UTILIDAD ANTES DE IMPUESTOS (UIA)</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $calculos['uia_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($calculos['uia_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor

                            </tr>

                            <tr>
                                <td></td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td></td>
                                    <td></td>
                                @endfor
                            </tr>

                            <!-- PROVISIÓN DE IMPUESTOS-->
                            <tr>
                                <td>PROVISIÓN DE IMPUESTOS</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $calculos['prov_impuestos_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($calculos['prov_impuestos_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                            <!-- UTILIDAD NETA -->
                            <tr class="revisadoRow">
                                <td>UTILIDAD NETA</td>

                                @for ($i = 1; $i <= 12; $i++)
                                    <td class="right-aligned">${{ number_format( $calculos['utilidad_neta_'.$i], 0 ) }}</td>
                                    <td class="right-aligned">{{ number_format( @($calculos['utilidad_neta_'.$i] / $total_41['saldo_'.$i]) * 100, 2 ) }}%</td>
                                @endfor
                            </tr>

                        </tbody>
                    </table>
                @else
                    <div class="alert alert-warning alert-dismissible" role="alert">
                        <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                        <strong>Atención!</strong> No hay datos disponibles en el periodo seleccionado.
                    </div>
                @endif

            </div>
        </div>

    </div>

</div>

<div class="clearfix"></div>

<div class="clearfix"></div>

@section('header')
    <link rel="stylesheet" href="https://cdn.datatables.net/fixedcolumns/3.2.1/css/fixedColumns.dataTables.min.css">

    <style>
        td.highlight {
            background-color: #FFF6D1 !important;
            color: #333 !important;
        }
        .table-hover>tbody>tr:hover>td, .table-hover>tbody>tr:hover>th {
            background-color: #FFF6D1 !important;
            color: #333 !important;
        }

    </style>
@stop

@section('footer')

    @if( $exitsData == true )
        @include('junta::informes_generales.pyg.ventas_netas_anual')
        @include('junta::informes_generales.pyg.costo_neto_anual')
        @include('junta::informes_generales.pyg.gastos_ventas_anual')
        @include('junta::informes_generales.pyg.gastos_admon_anual')
        @include('junta::informes_generales.pyg.gastos_admon_anual')

        @foreach( $modales as $modal )
            @if( $modal['count'] > 0 )
                {{ $modal['html'] }}
            @endif
        @endforeach
    @endif

<script src="https://cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/fixedcolumns/3.2.1/js/dataTables.fixedColumns.min.js"></script>
<script>
    $(document).ready(function() {

        var pygTable = $('.cuentas-pyg-table').DataTable( {
            "oLanguage": {
                "sUrl": "/layout/data/dataTables.es.txt"
            },
            "paging": false,
            "searching": false,
            "info": false,
            "autoWidth": false
        });

        $('.cuentas-pyg-table tbody').on( 'click', 'tr', function () {
            if ( $(this).hasClass('selectedRow') ) {
                $(this).removeClass('selectedRow');
            }
            else {
                pygTable.$('tr.selectedRow').removeClass('selectedRow');
                $(this).addClass('selectedRow');
            }
        } );

        var pygTable = $('#pyg-table').DataTable( {
            "oLanguage": {
                "sUrl": "/layout/data/dataTables.es.txt"
            },
            "paging": false,
            "ordering": false,
            "info": false,
            "searching": false,
            scrollY:        "500px",
            scrollX:        true,
            scrollCollapse: true,
            columnDefs: [
                { width: 300, targets: 0 }
            ],
            fixedColumns:   true
        });

        $('#pyg-table tbody').on( 'click', 'tr', function () {
            if ( $(this).hasClass('selectedRow') ) {
                $(this).removeClass('selectedRow');
            }else {
                $(this).addClass('selectedRow');
            }
        } );

        $('#pyg-table tbody').on( 'mouseenter', 'td', function () {
            var colIdx = pygTable.cell(this).index().column;

            $( pygTable.cells().nodes() ).removeClass( 'highlight' );
            $( pygTable.column( colIdx ).nodes() ).addClass( 'highlight' );
        } );

        var allCells = $(".cuentas-pyg-table td");

        allCells
            .on("mouseover", function() {
                var el = $(this),
                    pos = el.index();
                //el.parent().find("td").addClass("highlight");
                allCells.filter(":nth-child(" + (pos+1) + ")").addClass("highlight");
            })
            .on("mouseout", function() {
                allCells.removeClass("highlight");
            });
    });
</script>
@stop