@include('forms.fbncheader')
@include('forms.fdatatables')


  {!! Html::style('css/bootstrap-select.min.css') !!}


<div style="background-color:rgba(204,204,255,.2);"  
    class="col-lg-max col-lg-offset-1 container-fluid">

    <div style="padding-left:0px" class="col-lg-max">
         <div class="row" style="">   
            <div class="col-xs-1" style="padding-left:0px;">
               {!! Html::image("img/bilan.png", "Plan", array( 'width'=>'100%',"style"=>"padding:4px" )) !!} 
            </div>
            <div class="col-xs-2" style="padding-left:0px;">
                <h1>Bilan <small>{!! $exercice !!}</small></h1>
            </div>
            <div class="col-xs-4" style="padding-left:0px;padding-top:10px"> 
                {!! Form::select(
                    'categ',["R"=>"CLR","F"=>"CCPF","A"=>"AS/AV"],$categ,
                    ['id' => 'categ2','class' => 'form-control selectpicker',
                        'data-width' => '100%',
                        'style' => 'height:50px;font-size:24px;font-weight:bold;
                        background-color: rgba(255,255,255,.5);']
                ) 
                !!}
                <script>
                    $(document).ready(function() {
                        $('#categ2').on('change', function() {
                            location.href="{!! url('compta/bilan') !!}/"+$('#categ2').val();
                        });
                    });
                </script>
            </div>
        </div>
    </div>

    <div class="table-responsive">

        <table id="" style="background-color:white"  class="table table-condensed table-striped table-bordered">
            <thead style="background-color:lightgrey;font-weight:bold">
                <tr class="bg-success">
                    <th width='1%' colspan="6" class="text-center">ACTIF AU 31/12</th>
                </tr>
                <tr>
                    <th rowspan="2" width='1%'>Compte</th>
                    <th rowspan="2">Nom</th>
                    <th rowspan="2" width='1%'>(N-1)</th>
                    <th colspan="3" width='1%'>N</th>
                </tr>
                <tr>
                    <th width='1%'>BRUT</th>
                    <th width='1%'>AMORT</th>
                    <th width='1%'>NET</th>
                </tr>
            </thead>

            <tbody>
                                @foreach($t_bilan_actif as $value)
                                @if(($categ!=$categ_old)&&($categ_old!=""))
                <tr style="background-color:lightgrey;font-weight:bold" class="text-center">
                    <td nowrap colspan='2'>TOTAL</td>
                    <td nowrap align='right'>{!! number_format($total_netprec,0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($total_brut,0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($total_amort,0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($total_brut-$total_amort,0,","," ") !!}</td>
                </tr>
                @endif
                <tr>
                    <td nowrap>
                        <a href="{!! url('compta/journal_ltd')."/".$exercice."/".$t_value[0] !!}" 
                            class="jnx_detail fancybox.iframe" 
                            style="margin-right: 3px;">
                            {!! $t_value[0]   !!}
                        </a>
                    </td>
                    <td nowrap>{!! $t_value[1] !!}</td>
                    <td nowrap align='right'>{!! number_format($t_value[2],0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($t_value[3],0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($t_value[4],0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($t_value[5],0,","," ") !!}</td>
                </tr>
                                @endforeach
            </tbody>
            <tfooter>
                <tr style="background-color:lightgrey;font-weight:bold" class="text-center">
                    <td nowrap colspan='2'>TOTAL ACTIF</td>
                    <td nowrap align='right'>{!! number_format($totalgene_netprec,0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($totalgene_brut,0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($totalgene_amort,0,","," ") !!}</td>
                    <td nowrap align='right'>{!! number_format($totalgene_brut-$totalgene_amort,0,","," ") !!}</td>
                </tr>
            </tfooter>
        </table>
    </div>



    <div class="table-responsive" style="margin-top:50px">
        <table id="" style="background-color:white"  class="table table-condensed table-striped table-bordered">
            <thead style="background-color:lightgrey;font-weight:bold">
                <tr class="bg-danger">
                    <th width='1%' colspan="6" class="text-center">PASSIF AU 31/12</th>
                </tr>
                <tr>
                    <th width='1%'>Compte</th>
                    <th >Nom</th>
                    <th width='1%'>(N-1)</th>
                    <th width='1%'>N</th>
                </tr>
            </thead>

            <tbody>
                                @foreach($t_bilan_passif as $value)
                
                <tr>
                    <td nowrap>
                        <a href="{!! url('compta/journal_ltd')."/".$exercice."/".$t_value[0] !!}" 
                            class="jnx_detail fancybox.iframe" 
                            style="margin-right: 3px;">
                            {!! $t_value[0]   !!}
                        </a>

                    </td>
                    <td nowrap>{!! $t_value[1] !!}</td>
                    <td nowrap align='right'>{!! number_format(abs($t_value[2]),0,",","") !!}</td>
                    <td nowrap align='right'>{!! number_format(abs($t_value[3]),0,",","") !!}</td>                </tr>
                                @endforeach
            </tbody>

            <tfooter>
                <tr style="background-color:lightgrey;font-weight:bold" class="text-center">
                    <td nowrap colspan='2'>TOTAL PASSIF</td>
                    <td nowrap align='right'>{!! number_format(abs($totalgene_netprec),0,",","") !!}</td>
                    <td nowrap align='right'>{!! number_format(abs($totalgene_net),0,",","") !!}</td>
                </tr>
            </tfooter>
        </table>
    </div>
</div>


</body></html>

<script>

      $(".jnx_detail").fancybox({
                //maxWidth    : 800,
                //maxHeight   : 600,
                fitToView   : false,
                width       : '80%',
                height      : '40%',
                autoSize    : true,
                autoScale   : true,
                closeClick  : false,
                openEffect  : 'none',
                closeEffect : 'none',
                       afterClose  : function() { 
            window.location.reload();
        }
    });
</script>