@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">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="fancy-btn btn btn3d 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">Presupuesto</th>
                                <th style="text-align: center">% Participación</th>
                                <th style="text-align: center">Variación<br/>{{ $year }} vs {{ $yearAnt }}</th>
                                <th style="text-align: center">Cumplimiento<br/>Presupuesto</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">Presupuesto</th>
                                <th style="text-align: center">% Participación</th>
                                <th style="text-align: center">Variación<br/>{{ $year }} vs {{ $yearAnt }}</th>
                                <th style="text-align: center">Cumplimiento<br/>Presupuesto</th>
                            </tr>
                        </tfoot>
                        <tbody>

                            <!-- VENTAS NETAS -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-ventas-netas">VENTAS NETAS</a></td>
                                <td class="right-aligned">${{ number_format( $total_41['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_41['saldo_ant'] / $total_41['saldo_ant']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_41['saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_41['saldo'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_41['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_41['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_41['saldo'], $total_41['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($total_41['saldo'] * 100) / $total_41['ppto_saldo'] ), 2 ) }}%</td>
                            </tr>

                            <!-- COSTO VENTAS NETAS -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-costo-neto">COSTO DE VENTAS NETO</a></td>
                                <td class="right-aligned">${{ number_format( $total_costo['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_costo['saldo_ant'] / $total_41['saldo_ant']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_costo['saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_costo['saldo'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_costo['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_costo['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_costo['saldo'], $total_costo['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($total_costo['saldo'] * 100) / $total_costo['ppto_saldo'] ), 2 ) }}%</td>
                            </tr>

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

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

                            <!-- GASTOS DE VENTAS -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-gastos-ventas">GASTOS DE VENTAS</a></td>
                                <td class="right-aligned">${{ number_format( $total_52['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_52['saldo_ant'] / $total_41['saldo_ant']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_52['saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_52['saldo'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_52['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_52['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_52['saldo'], $total_52['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($total_52['saldo'] * 100) / $total_52['ppto_saldo'] ), 2 ) }}%</td>
                            </tr>

                            <!-- GASTOS DE ADMON -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-gastos-admon">GASTOS DE ADMINISTRACIÓN</a></td>
                                <td class="right-aligned">${{ number_format( $total_51['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_51['saldo_ant'] / $total_41['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'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_51['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_51['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_51['saldo'], $total_51['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($total_51['saldo'] * 100) / $total_51['ppto_saldo'] ), 2 ) }}%</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 ) / $total_41['saldo_ant']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $gastosop, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $gastosop / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $gastosop_ppto, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $gastosop_ppto / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $gastosop, $gastosop_ant ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($gastosop * 100) / $gastosop_ppto ), 2 ) }}%</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 ) / $total_41['saldo_ant']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $ebitda, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $ebitda / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $ebitda_ppto, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $ebitda_ppto / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $ebitda, $ebitda_ant ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($ebitda * 100) / $ebitda_ppto ), 2 ) }}%</td>
                            </tr>

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


                            <!-- GASTO DE ADMON - DEPRECIACIONES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-5160">{{ $datos[5160]['descripcion'] }}</a></td>
                                <td class="right-aligned">${{ number_format( $datos[5160]['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($datos[5160]['saldo_ant'] / $total_41['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'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $datos[5160]['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($datos[5160]['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $datos[5160]['saldo'], $datos[5160]['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($datos[5160]['saldo'] * 100) / $datos[5160]['ppto_saldo'] ), 2 ) }}%</td>
                            </tr>

                            <!-- GASTO DE ADMON - AMORTIZACIONES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-5165">{{ $datos[5165]['descripcion'] }}</a></td>
                                <td class="right-aligned">${{ number_format( $datos[5165]['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($datos[5165]['saldo_ant'] / $total_41['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'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $datos[5165]['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($datos[5165]['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $datos[5165]['saldo'], $datos[5165]['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($datos[5165]['saldo'] * 100) / $datos[5165]['ppto_saldo'] ), 2 ) }}%</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 / $total_41['saldo_ant']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $utilidad_op, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($utilidad_op / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $utilidad_op_ppto, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($utilidad_op_ppto / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $utilidad_op, $utilidad_op_ant ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($utilidad_op * 100) / $utilidad_op_ppto ), 2 ) }}%</td>
                            </tr>

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

                            <!-- INGRESOS NO OPERACIONALES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-42">{{ $datos[42]['descripcion'] }}</a></td>
                                <td class="right-aligned">${{ number_format( $total_42['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_42['saldo_ant'] / $total_41['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'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $total_42['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($total_42['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $total_42['saldo'], $total_42['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($total_42['saldo'] * 100) / $total_42['ppto_saldo'] ), 2 ) }}%</td>
                            </tr>
                            <!-- GASTOS NO OPERACIONALES -->
                            <tr>
                                <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-53">{{ $datos[53]['descripcion'] }}</a></td>
                                <td class="right-aligned">${{ number_format( $datos[53]['saldo_ant'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($datos[53]['saldo_ant'] / $total_41['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'] / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $datos[53]['ppto_saldo'], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($datos[53]['ppto_saldo'] / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $datos[53]['saldo'], $datos[53]['saldo_ant'] ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($datos[53]['saldo'] * 100) / $datos[53]['ppto_saldo'] ), 2 ) }}%</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 / $total_41['saldo_ant'] ) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $uia, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($uia / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $uia_ppto, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($uia_ppto / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $uia, $uia_ant ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($uia * 100) / $uia_ppto ), 2 ) }}%</td>
                            </tr>

                            <tr>
                                <td></td>
                                <td></td>
                                <td></td>
                                <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 / $total_41['saldo_ant'] ) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $prov_impuestos, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($prov_impuestos / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $prov_impuestos_ppto, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($prov_impuestos_ppto / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $prov_impuestos, $prov_impuestos_ant ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($prov_impuestos * 100) / $prov_impuestos_ppto ), 2 ) }}%</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 / $total_41['saldo_ant'] ) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $utilidad_neta, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($utilidad_neta / $total_41['saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">${{ number_format( $utilidad_neta_ppto, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @($utilidad_neta_ppto / $total_41['ppto_saldo']) * 100, 2 ) }}%</td>
                                <td class="right-aligned">{{ \FncCuentaValor::variacion( $utilidad_neta, $utilidad_neta_ant ) }}%</td>
                                <td class="right-aligned">{{ number_format( @( ($utilidad_neta * 100) / $utilidad_neta_ppto ), 2 ) }}%</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>

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

@section('header')
@stop

@section('footer')

    @if( $exitsData == true )
        @include('junta::informes_generales.pyg.ventas_netas')
        @include('junta::informes_generales.pyg.costo_neto')
        @include('junta::informes_generales.pyg.gastos_ventas')
        @include('junta::informes_generales.pyg.gastos_admon')

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

<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