@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>BALANCE GENERAL</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-balance-scale"></i> BALANCE GENERAL MES A MES</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" id="balance-table" style="width: 2000px;">
                        <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>

                        <tr class="revisadoRow4">
                            <td>{{ $datos[1]['descripcion'] }}</td>

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

                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-11">{{ $datos[11]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[11]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[11]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-12">{{ $datos[12]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[12]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[12]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-13">{{ $datos[13]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[13]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[13]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-14">{{ $datos[14]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[14]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[14]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-15">{{ $datos[15]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[15]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[15]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-16">{{ $datos[16]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[16]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[16]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-17">{{ $datos[17]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[17]['final_'.$i], 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[17]['final_'.$i] / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                        @endfor

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

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


                        <tr class="revisadoRow">
                            <td>{{ $datos[2]['descripcion'] }}</td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[2]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[2]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-21">{{ $datos[21]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[21]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[21]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-22">{{ $datos[22]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[22]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[22]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-23">{{ $datos[23]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[23]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[23]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-24">{{ $datos[24]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[24]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[24]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-25">{{ $datos[25]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[25]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[25]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-26">{{ $datos[26]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[26]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[26]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-28">{{ $datos[28]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[28]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[28]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>

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

                        <tr class="revisadoRow3">
                            <td>{{ $datos[3]['descripcion'] }}</td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[3]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[3]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-31">{{ $datos[31]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[31]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[31]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-32">{{ $datos[32]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[32]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[32]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-33">{{ $datos[33]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[33]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[33]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-34">{{ $datos[34]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[34]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[34]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-36">{{ $datos[36]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[36]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[36]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-37">{{ $datos[37]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[37]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[37]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>
                        <tr class="">
                            <td><a class="link" data-toggle="modal" data-target="#modal-cuenta-38">{{ $datos[38]['descripcion'] }}</a></td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( $datos[38]['final_'.$i] * -1, 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( $datos[38]['final_'.$i] * -1 / $datos[1]['final_'.$i]) * 100, 2 ) }}%</td>
                            @endfor
                        </tr>

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

                        <tr class="revisadoRow4">
                            <td>PASIVO + PATRIMONIO</td>
                            @for ($i = 1; $i <= 12; $i++)
                                <td class="right-aligned">${{ number_format( ($datos[2]['final_'.$i] + $datos[3]['final_'.$i]) * -1 , 0 ) }}</td>
                                <td class="right-aligned">{{ number_format( @( (($datos[2]['final_'.$i] + $datos[3]['final_'.$i]) * -1) / $datos[1]['final_'.$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 )

        @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 balanceTable = $('#balance-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
            });

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

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

                $( balanceTable.cells().nodes() ).removeClass( 'highlight' );
                $( balanceTable.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