@extends('layouts.pdf')

@section('title')
     Bank Balance Report
@endsection
@section('content')

    @php
        
        $head_name = array();
    @endphp
   <style type="text/css" media="all">  
    div[size="A4"]{
        font-family: Verdana,Geneva,sans-serif !important;
        line-height:18px;
        @php
            echo $type =='show' ? 'margin: 30px 50px auto;' : '' ;
        @endphp
    }
    h5,h6,p{
        font-family: Verdana,Geneva,sans-serif;
    }
    .table th {
        background-color: #000 !important;
    }
</style>

    <div size="A4" style="width: 100%;height: auto%;position: relative;page-break-after: never;">
        @include('admin.partials.header', ['extra' => $extra])


        @php
            
            $dr_official_amount  = 0;
            $dr_unofficial_amount  = 0;
            $cr_official_amount  = 0;
            $cr_unofficial_amount  = 0;

            $total_balance_amount  = 0;
            $total_unofficial_balance_amount  = 0; 
        @endphp
        
        <table class="table  table-bordered table-hover"  style="font-size: 12px;">
            <thead>

                    <tr>
                        @if (isset($params['official_unofficial']) &&  $params['official_unofficial'] == "null")
                            <th colspan="2" scope="col" class="text-center"></th>
                            <th colspan="2" scope="col" class="text-center">{{__('lang.dr')}}</th>
                            <th colspan="2" scope="col" class="text-center">{{__('lang.cr')}}</th>
                            <th colspan="2" scope="col" class="text-center">{{__('lang.balance')}}</th>
                        @endif
    
                    </tr>

            <tr>
                <th scope="col" style=" ">S. No.</th>
                <th scope="col" style=" margin-top:19px;" > {{__('lang.bank')}}</th>
                @if (isset($params['official_unofficial']) &&  $params['official_unofficial'] == "null")
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.unofficial')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.official')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.unofficial')}}  {{$transaction->systemSettingCurrency()}}</th>

                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">  {{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">   {{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
                @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}}  {{__('lang.official')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}}  {{__('lang.official')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.balance')}} {{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
                @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}}  {{__('lang.unofficial')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}}  {{__('lang.unofficial')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> {{__('lang.balance')}} {{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>

                @elseif(!isset($params['official_unofficial']))
                    <th scope="col" class="text-center" style="padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}}  {{$transaction->systemSettingCurrency()}}</th>
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.balance')}}  {{$transaction->systemSettingCurrency()}}</th>
                @endif
            </tr>
            </thead>
            <tbody>
                @foreach ($sorted_array as $key => $values)
                    <tr>
                        <td colspan="100%"><strong>{{ \App\Models\Branch::find($key)->name  }}</strong> </td>
                    </tr>
                    @foreach ($values as $innerKey => $innerValues)
                        @php    
                            $balance_amount = 0;
                            $balance_amount_unofficial = 0;
                            if(isset($innerValues['official']['bf'])){
                                $balance_amount = $innerValues['official']['bf'];
                            }
                            if(isset($innerValues['unofficial']['bf'])){
                                $balance_amount_unofficial = $innerValues['unofficial']['bf'];
                            }

                            if($innerValues['official']['dr'] > $innerValues['official']['cr']){
                                $balance_amount += $innerValues['official']['dr'] - $innerValues['official']['cr'];

                            }else if( $innerValues['official']['cr']  > $innerValues['official']['dr']){
                                $balance_amount += ($innerValues['official']['cr'] -  $innerValues['official']['dr']) * -1;
                            }


                            if($innerValues['unofficial']['dr'] > $innerValues['unofficial']['cr']){
                                $balance_amount_unofficial += $innerValues['unofficial']['dr'] - $innerValues['unofficial']['cr'];
                            }else if( $innerValues['unofficial']['cr']  > $innerValues['unofficial']['dr']){
                                $balance_amount_unofficial += ($innerValues['unofficial']['cr'] -  $innerValues['unofficial']['dr']) * -1;
                            }
                    
                            // $balance_amount +=  $innerValues['official']['dr'] - $innerValues['official']['cr'];
                            // $balance_amount_unofficial += $innerValues['unofficial']['dr'] - $innerValues['unofficial']['cr'];


                            $dr_official_amount  += $innerValues['official']['dr'];
                            $dr_unofficial_amount  += $innerValues['unofficial']['dr'];
                            $cr_official_amount +=$innerValues['official']['cr'];
                            $cr_unofficial_amount  +=$innerValues['unofficial']['cr'];

                            $total_balance_amount  += $balance_amount ;
                            $total_unofficial_balance_amount  += $balance_amount_unofficial;

                            if (!empty($params['branch']) || !empty($params['from']) || !empty($params['to'])) {
                                $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $innerValues['head_id'] . '&branch_id=' . $params['branch'] . '&from=' . $params['from'] . '&to=' . $params['to'] . '&status=1&voucher_type=0&official_unofficial='.$params['official_unofficial'].'&action=Show';
                            } else {
                                $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $innerValues['head_id'] . '&branch_id=0&from=&to=&status=1&voucher_type=0&action=Show';
                            }
                        @endphp
                        <tr>
                            <td>  {{ $loop->iteration }} </td>
                            <td> <a target="_blank"href="{{ $route }}">{{ \App\Models\IncomeExpenseHead::find($innerKey)->name  }}</a> </td>


                            @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['official']['dr']) }} </td>
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['unofficial']['dr']) }} </td>
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['official']['cr']) }} </td>
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['unofficial']['cr']) }} </td>
                                <td class="text-right" >
                                    @if($balance_amount > 0)
                                        {{ $transaction->convert_money_format($balance_amount) }}
                                    @else
                                        ({{ $transaction->convert_money_format(abs($balance_amount)) }})
                                    @endif
                                </td>
                                <td class="text-right" >
                                    @if($balance_amount_unofficial > 0)
                                        {{ $transaction->convert_money_format($balance_amount_unofficial) }}
                                    @else
                                        ({{ $transaction->convert_money_format(abs($balance_amount_unofficial)) }})
                                    @endif
                                </td>

                            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                                
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['official']['dr']) }} </td>
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['official']['cr']) }} </td>
                                <td class="text-right" >
                                    @if($balance_amount > 0)
                                        {{ $transaction->convert_money_format($balance_amount) }}
                                    @else
                                        ({{ $transaction->convert_money_format(abs($balance_amount)) }})
                                    @endif
                                </td>
                            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                                 
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['unofficial']['dr']) }} </td>
                                <td class="text-right"> {{ $transaction->convert_money_format($innerValues['unofficial']['cr']) }} </td>
                                <td class="text-right" >
                                    @if($balance_amount_unofficial > 0)
                                        {{ $transaction->convert_money_format($balance_amount_unofficial) }}
                                    @else
                                        ({{ $transaction->convert_money_format(abs($balance_amount_unofficial)) }})
                                    @endif
                                </td>
                            @elseif(!isset($params['official_unofficial']))
                                
                                <td class="text-right" style=" ">{{ $transaction->convert_money_format($innerValues['official']['dr']) }}  </td>
                                <td class="text-right" style=" ">{{ $transaction->convert_money_format($innerValues['official']['cr']) }}</td>
                                <td class="text-right" >
                                    @if($balance_amount > 0)
                                        {{ $transaction->convert_money_format($balance_amount) }}
                                    @else
                                        ({{ $transaction->convert_money_format(abs($balance_amount)) }})
                                    @endif
                                </td>
                            @endif
                        </tr>
                    @endforeach
                @endforeach

                <tr>
                    <th class="text-right" colspan="2" >{{__('lang.total')}}  </th>
                    
             


                    @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")
                        <th class="text-right"  >{{ $transaction->convert_money_format($dr_official_amount) }}</th>
                        <th class="text-right"  >{{ $transaction->convert_money_format($dr_unofficial_amount) }}</th>
                        <th class="text-right"  >{{ $transaction->convert_money_format($cr_official_amount) }}</th>
                        <th class="text-right"  >{{ $transaction->convert_money_format($cr_unofficial_amount) }}</th>
                        <th class="text-right"  >
                            @if($total_balance_amount >= 0)
                                {{ $transaction->convert_money_format($total_balance_amount) }}
                            @else
                                ({{ $transaction->convert_money_format(abs($total_balance_amount)) }})
                            @endif
                        </th> 
                        <th class="text-right"  >
                            @if($total_unofficial_balance_amount >= 0)
                                {{ $transaction->convert_money_format($total_unofficial_balance_amount) }}
                            @else
                                ({{ $transaction->convert_money_format(abs($total_unofficial_balance_amount)) }})
                            @endif
                        </th>
                        
                    @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                        <th class="text-right"  >{{ $transaction->convert_money_format($dr_official_amount) }}</th>
                        <th class="text-right"  >{{ $transaction->convert_money_format($cr_official_amount) }}</th>

                        <th class="text-right"  >
                            @if($total_balance_amount >= 0)
                                {{ $transaction->convert_money_format($total_balance_amount) }}
                            @else
                                ({{ $transaction->convert_money_format(abs($total_balance_amount)) }})
                            @endif
                        </th> 
                       
                    @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                        <th class="text-right"  >{{ $transaction->convert_money_format($dr_unofficial_amount) }}</th>
                        <th class="text-right"  >{{ $transaction->convert_money_format($cr_unofficial_amount) }}</th>
                        <th class="text-right"  >
                            @if($total_unofficial_balance_amount >= 0)
                                {{ $transaction->convert_money_format($total_unofficial_balance_amount) }}
                            @else
                                ({{ $transaction->convert_money_format(abs($total_unofficial_balance_amount)) }})
                            @endif
                        </th>
                    @elseif(!isset($params['official_unofficial']))
                        <th class="text-right"  >{{ $transaction->convert_money_format($dr_official_amount) }}</th>
                        <th class="text-right"  >{{ $transaction->convert_money_format($cr_official_amount) }}</th>
                        <th class="text-right"  >
                            @if($total_balance_amount >= 0)
                                {{ $transaction->convert_money_format($total_balance_amount) }}
                            @else
                                ({{ $transaction->convert_money_format(abs($total_balance_amount)) }})
                            @endif
                        </th> 
                    @endif   
                </tr>
            </tbody>
        </table>
     
        <br>    
    </div>

@stop