@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><i class="{{ $icon }}" aria-hidden="true"></i> {{ $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="{{ $icon }}" aria-hidden="true"></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">Historico</label>&nbsp;
                        <select name="historico" class="form-control select2" data-allow-clear="true" placeholder="Seleccione...">
                            @foreach( $meses as $mes )
                                <option value="{{ $mes['id'] }}"{{ (Input::get('historico', $fecha) == $mes['id'] ) ? 'selected' : ''  }} >{{ $mes['mes'] }}</option>
                            @endforeach
                        </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" width="100%">
                        <thead>
                        <tr>
                            <th style="text-align: center">Detalle</th>
                            <th style="text-align: center">Año {{ $yearAnt }}</th>
                            <th style="text-align: center">% Participación</th>
                            <th style="text-align: center">Año {{ $year }}</th>
                            <th style="text-align: center">% Participación</th>
                            <th style="text-align: center">Variación<br/>{{ $year }} vs {{ $yearAnt }}</th>
                        </tr>
                        </thead>
                        <tfoot>
                        <tr>
                            <th style="text-align: center">Detalle</th>
                            <th style="text-align: center">Año {{ $yearAnt }}</th>
                            <th style="text-align: center">% Participación</th>
                            <th style="text-align: center">Año {{ $year }}</th>
                            <th style="text-align: center">% Participación</th>
                            <th style="text-align: center">Variación<br/>{{ $year }} vs {{ $yearAnt }}</th>
                        </tr>
                        </tfoot>
                        <tbody>

                        <!-- VENTAS NETAS -->
                        <tr>
                            <td>VENTAS NETAS</td>
                            <td class="right-aligned">${{ number_format( $venta_neta['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($venta_neta['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $venta_neta['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($venta_neta['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $venta_neta['saldo'], $venta_neta['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- COSTO VENTAS NETAS -->
                        <tr>
                            <td>COSTO DE VENTAS NETO</td>
                            <td class="right-aligned">${{ number_format( $costo_banco['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($costo_banco['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $costo_banco['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($costo_banco['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $costo_banco['saldo'], $costo_banco['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- MARGEN DE CONTRIBUCIÓN -->
                        <tr class="revisadoRow">
                            <td>MARGEN DE CONTRIBUCIÓN</td>
                            <td class="right-aligned">${{ number_format( $margen_contribucion_banco['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($margen_contribucion_banco['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $margen_contribucion_banco['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($margen_contribucion_banco['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $margen_contribucion_banco['saldo'], $margen_contribucion_banco['saldo_ant'] ) }}%</td>
                        </tr>

                        <tr>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                        </tr>

                        <!-- GASTOS DE VENTAS -->
                        <tr>
                            <td>GASTOS DE VENTAS</td>
                            <td class="right-aligned">${{ number_format( $gasto_venta_banco['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($gasto_venta_banco['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $gasto_venta_banco['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($gasto_venta_banco['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $gasto_venta_banco['saldo'], $gasto_venta_banco['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- GASTOS DE ADMON -->
                        <tr>
                            <td>GASTOS DE ADMINISTRACIÓN</td>
                            <td class="right-aligned">${{ number_format( $total_51['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($total_51['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $total_51['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($total_51['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_51['saldo'], $total_51['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- TOTAL GASTOS OPERACIONALES -->
                        <tr class="revisadoRow4">
                            <td>TOTAL GASTOS OPERACIONALES</td>
                            <td class="right-aligned">${{ number_format( $gastosop_ant, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( ( $gastosop_ant ) / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $gastosop, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( $gastosop / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $gastosop, $gastosop_ant ) }}%</td>
                        </tr>
                        <tr class="revisadoRow">
                            <td>EBITDA</td>
                            <td class="right-aligned">${{ number_format( $ebitda_ant, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( ( $ebitda_ant ) / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $ebitda, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( $ebitda / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $ebitda, $ebitda_ant ) }}%</td>
                        </tr>

                        <tr>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                        </tr>


                        <!-- GASTO DE ADMON - DEPRECIACIONES -->
                        <tr>
                            <td>{{ $datos[5160]['descripcion'] }}</td>
                            <td class="right-aligned">${{ number_format( $datos[5160]['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($datos[5160]['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $datos[5160]['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($datos[5160]['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $datos[5160]['saldo'], $datos[5160]['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- GASTO DE ADMON - AMORTIZACIONES -->
                        <tr>
                            <td>{{ $datos[5165]['descripcion'] }}</td>
                            <td class="right-aligned">${{ number_format( $datos[5165]['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($datos[5165]['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $datos[5165]['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($datos[5165]['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $datos[5165]['saldo'], $datos[5165]['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- TOTAL GASTOS OPERACIONALES -->
                        <tr class="revisadoRow">
                            <td>UTILIDAD OPERACIONAL</td>
                            <td class="right-aligned">${{ number_format( $utilidad_op_ant, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( $utilidad_op_ant / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $utilidad_op, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($utilidad_op / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $utilidad_op, $utilidad_op_ant ) }}%</td>
                        </tr>

                        <tr>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                        </tr>

                        <!-- INGRESOS NO OPERACIONALES -->
                        <tr>
                            <td>{{ $datos[42]['descripcion'] }}</td>
                            <td class="right-aligned">${{ number_format( $total_42['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($total_42['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $total_42['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($total_42['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_42['saldo'], $total_42['saldo_ant'] ) }}%</td>
                        </tr>
                        <!-- GASTOS NO OPERACIONALES -->
                        <tr>
                            <td>{{ $datos[53]['descripcion'] }}</td>
                            <td class="right-aligned">${{ number_format( $datos[53]['saldo_ant'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($datos[53]['saldo_ant'] / $venta_neta['saldo_ant']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $datos[53]['saldo'], 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($datos[53]['saldo'] / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $datos[53]['saldo'], $datos[53]['saldo_ant'] ) }}%</td>
                        </tr>

                        <!-- UTILIDAD ANTES DE IMPUESTOS = UTILIDAD OPERACIONAL + 42 - 53 (UIA)-->
                        <tr class="revisadoRow">
                            <td>UTILIDAD ANTES DE IMPUESTOS (UIA)</td>
                            <td class="right-aligned">${{ number_format( $uia_ant, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( $uia_ant / $venta_neta['saldo_ant'] ) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $uia, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($uia / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $uia, $uia_ant ) }}%</td>
                        </tr>

                        <tr>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                        </tr>

                        <!-- PROVISIÓN DE IMPUESTOS-->
                        <tr>
                            <td>PROVISIÓN DE IMPUESTOS</td>
                            <td class="right-aligned">${{ number_format( $prov_impuestos_ant, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( $prov_impuestos_ant / $venta_neta['saldo_ant'] ) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $prov_impuestos, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($prov_impuestos / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $prov_impuestos, $prov_impuestos_ant ) }}%</td>
                        </tr>

                        <!-- UTILIDAD NETA -->
                        <tr class="revisadoRow">
                            <td>UTILIDAD NETA</td>
                            <td class="right-aligned">${{ number_format( $utilidad_neta_ant, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @( $utilidad_neta_ant / $venta_neta['saldo_ant'] ) * 100, 2 ) }}%</td>
                            <td class="right-aligned">${{ number_format( $utilidad_neta, 0 ) }}</td>
                            <td class="right-aligned">{{ number_format( @($utilidad_neta / $venta_neta['saldo']) * 100, 2 ) }}%</td>
                            <td class="right-aligned">{{ \FncCuentaValor::variacion( $utilidad_neta, $utilidad_neta_ant ) }}%</td>
                        </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>

@section('header')
@stop

@section('footer')
    <script>
        $(document).ready(function() {

            var pygTable = $('.cuentas-pyg-table').DataTable( {
                "oLanguage": {
                    "sUrl": "/layout/data/dataTables.es.txt"
                },
                "paging": false,
                "search": 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');
                }
            } );
        });
    </script>
@stop