@extends('layouts.pdf')

@section('title')
    {{ $extra['module_name'] }}
@endsection
@section('content')

    
    <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 td,
        table th,
        h6,
        p {
            font-size: 12px !important;
        }

        h5 {
            font-size: 12px !important;
            font-weight: 600;
        }

        .table td {
            border-top: 0px;
        }

        table th,
        table td {
            padding: 5px !important;
        }

        .table-sm td {
            padding: 0px !important;
        }

        body {
            font-size: 1rem;
        }

        table {
            font-size: 1rem;
        }

        .width-5 {
            width: 5% !important;
        }

        .width-10 {
            width: 10% !important;
        }

        .width-20 {
            width: 20% !important
        }

        .width-30 {
            width: 30% !important
        }

        .width-40 {
            width: 40% !important
        }

        .width-50 {
            width: 50% !important
        }

        .width-60 {
            width: 60% !important
        }

        .width-70 {
            width: 70% !important
        }

        .width-80 {
            width: 80% !important
        }

        .width-90 {
            width: 90% !important
        }

        .width-100 {
            width: 100% !important
        }

        .company-settings {
            padding: 2px;
            margin: 5px 0px;
            text-align: center !important;
            font-size: 24px !important
        }

        .company-address {
            padding: 2px;
            text-align: center !important;
            font-size: 16px !important
        }

        .table-margin-width {
            width: 100%;
            margin: auto;
        }

        /* .table th {
            background-color: #000 !important;
        } */

        .table td,
        .table th {
            padding: .75rem !important;
            vertical-align: top !important;
            border-top: 1px solid #dee2e6 !important;
        }
    </style>

    {{-- <p>Printing Date & Time: {{ $extra['current_date_time']  }}</p> --}}
    <script type="text/php">
        if (isset($pdf)) {
            $x = 400;
            $y = 10;
            $text = "Page {PAGE_NUM} of {PAGE_COUNT}";
            $font = null;
            $size = 8;
            $color = array(0,0,0);
            $word_space = 0.0;  //  default
            $char_space = 0.0;  //  default
            $angle = 0.0;   //  default
            $pdf->page_text($x, $y, $text, $font, $size, $color, $word_space, $char_space, $angle);
        }
    </script>
    <section class="container">
        <div size="A4">
             
            @include('admin.partials.header', ['extra' => $extra])
            
            <table class="table table-bordered table-hover table-margin-width">
                <thead>
                    <tr>
                        @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" >  </th>
                            @endif
                            <th colspan="2" scope="col" class="text-center"></th>
 
                            <th colspan="2" scope="col" class="text-center">{{__('lang.dr')}}</th>
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" >  </th>
                            @endif
                            <th colspan="2" scope="col" class="text-center">{{__('lang.cr')}}</th>
 
                        
                        @endif

                    </tr>

                    <tr>
                        <th scope="col" colspan="{{ $params['report_type'] == "detailed" ? '' : '3' }}" style="width:27%;">{{__('lang.code')}}</th>
                        <!--  <th scope="col" style=""></th> -->
                        @if ($params['report_type'] == "detailed")
                            <th scope="col" class="width-40">{{__('lang.name')}}</th>
                        @endif

                        @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "all")
 
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                            @endif
                            <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.dr')}} {{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                            @endif
                            <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.cr')}} {{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
                        @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "official")
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                            @endif
                            <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>
                        @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "unofficial")
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                            @endif
                            <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>
                        @elseif(!isset($params['official_unofficial']))
                            @if (isset($params['from']) && isset($params['to']))
                                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                            @endif
 
                            <th scope="col" class="text-right" style="width: 40%;padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}} {{$transaction->systemSettingCurrency()}}</th>
                            <th scope="col" class="text-right" style="padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}}  {{$transaction->systemSettingCurrency()}}</th>
                        @endif
                      
                    </tr>
                </thead>
                @php
                    $totalCR_official = 0;
                    $totalDR_official = 0;

                    $totalSubGroupCR_official = 0;
                    $totalSubGroupDR_official = 0;

                    $totalGroupCR_official = 0;
                    $totalGroupDR_official = 0;

                    $totalCR_unofficial = 0;
                    $totalDR_unofficial = 0;

                    $totalSubGroupCR_unofficial = 0;
                    $totalSubGroupDR_unofficial = 0;
                    
                    $totalGroupCR_unofficial = 0;
                    $totalGroupDR_unofficial = 0;



                @endphp

                @foreach ($data as $key_t => $type)
                    <tbody>
                        <tr style="border-top:4px solid;border-bottom:4px solid">
                            <th colspan="100%"  > {{ $key_t }}
                            </th>
                        </tr>
                    @foreach ($type as $key => $group)
                        <tbody>
                            <tr style="border-top:4px solid;border-bottom:4px solid">
                                <th colspan="100%" style="background: #ffffff !important;color: #000;"> <p style="margin:0px;padding-left:60px">{{ $key }}</p>
                                </th>
                            </tr>

                            @foreach ($group as $sub_key => $sub_group)
                                <tr style="border-top:4px solid;border-bottom:4px solid">
                                    <th colspan="4" style="background: #ffffff !important;color: #000;"><p style="margin:0px;padding-left:100px">{{ $sub_key }}</p> </th>
                                </tr>
                                @php
                                    $totalSubGroupCR_official = 0;
                                    $totalSubGroupDR_official = 0;
                                @endphp
                                <!-- Heads -->
                                @foreach ($sub_group as $key => $value)
                                {{--     @php
                                        echo "<pre>";
                                        print_r($value);exit;
                                    @endphp --}}
                                    @php
                                        $dr_official = 0;
                                        $cr_official = 0;
                                        
                                        if ($value->official->dr > $value->official->cr) {
                                            $dr_official = $value->official->dr - $value->official->cr;
                                        } else {
                                            $cr_official = $value->official->cr - $value->official->dr;
                                        }
                                        
                                        $totalSubGroupCR_official += $cr_official;
                                        $totalSubGroupDR_official += $dr_official;
                                        
                                        $totalGroupCR_official += $cr_official;
                                        $totalGroupDR_official += $dr_official;
                                        
                                        $totalCR_official += $cr_official;
                                        $totalDR_official += $dr_official;




                                        $dr_unofficial = 0;
                                        $cr_unofficial = 0;
                                        
                                        if ($value->unofficial->dr > $value->unofficial->cr) {
                                            $dr_unofficial = $value->unofficial->dr - $value->unofficial->cr;
                                        } else {
                                            $cr_unofficial = $value->unofficial->cr - $value->unofficial->dr;
                                        }
                                        
                                        $totalSubGroupCR_unofficial += $cr_unofficial;
                                        $totalSubGroupDR_unofficial += $dr_unofficial;
                                        
                                        $totalGroupCR_unofficial += $cr_unofficial;
                                        $totalGroupDR_unofficial += $dr_unofficial;
                                        
                                        $totalCR_unofficial += $cr_unofficial;
                                        $totalDR_unofficial += $dr_unofficial;

                                    @endphp
                                    @if ($params['report_type'] == "detailed")
                                        <tr
                                            @if ($search_by['transactions'] == 1) {{ App\Models\Common::hideCrAndDrColumn($dr_official, $cr_official) }} @endif>
                                            @php
                                                $offical_param=   null;

                                                if($params['official_unofficial'] == 'official'){
                                                    $offical_param = 1;
                                                }
                                                elseif($params['official_unofficial'] == 'unofficial'){
                                                    $offical_param = 0;
                                                }
                                                elseif($params['official_unofficial'] == 'all'){
                                                    $offical_param = 'null';
                                                }

                                                if (!empty($extra['branch']) || !empty($search_by['from']) || !empty($search_by['to'])) {
                                                    $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $value->head_id . '&branch_id=' . $extra['branch']->id . '&from=' . $search_by['from'] . '&to=' . $search_by['to'] . '&date_type=1&status=1&voucher_type=0&official_unofficial='.$offical_param.'&action=Show';
                                                } else {
                                                    $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $value->head_id . '&branch_id=0&from=&to=&date_type=1&status=1&voucher_type=0&action=Show';
                                                }
                                            @endphp


                                            <td class="text-right"> {{ $value->group_code . '.' . $value->sub_group_code . '.' . $value->head_code }} </td>
                                            <td class="width-10"><a target="_blank"href="{{ $route }}">{{ $value->head_name }}</a></td>

                                            


                                            @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "all")
                                                @if (isset($params['from']) && isset($params['to']))
                                                    <td class="text-right">{{ ($value->official->bf < 0 ? '('.$transaction->convert_money_format(abs($value->official->bf)).')' :$transaction->convert_money_format($value->official->bf)) }}   </td>
                                                @endif
                                                <td class="text-right"> {{ $transaction->convert_money_format($dr_official) }} </td>
                                                <td class="text-right"> {{ $transaction->convert_money_format($dr_unofficial) }} </td>
                                                @if (isset($params['from']) && isset($params['to']))
                                                    <td class="text-right"> {{ ($value->unofficial->bf < 0 ? '('.$transaction->convert_money_format(abs($value->unofficial->bf)).')' :$transaction->convert_money_format($value->unofficial->bf)) }}  </td>
                                                @endif
                                                <td class="text-right"> {{ $transaction->convert_money_format($cr_official) }} </td>
                                                <td class="text-right"> {{ $transaction->convert_money_format($cr_unofficial) }} </td>
                                                

                                            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "official")
                                                @if (isset($params['from']) && isset($params['to']))
                                                    <td class="text-right"> {{ ($value->official->bf < 0 ? '('.$transaction->convert_money_format(abs($value->official->bf)).')' :$transaction->convert_money_format($value->official->bf)) }} </td>
                                                @endif
                                                <td class="text-right"> {{ $transaction->convert_money_format($dr_official) }} </td>
                                                <td class="text-right"> {{ $transaction->convert_money_format($cr_official) }} </td>

                                            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "unofficial")
                                                @if (isset($params['from']) && isset($params['to']))
                                                    <td class="text-right"> {{ ($value->unofficial->bf < 0 ? '('.$transaction->convert_money_format(abs($value->unofficial->bf)).')' :$transaction->convert_money_format($value->unofficial->bf)) }}  </td>
                                                @endif
                                                <td class="text-right"> {{ $transaction->convert_money_format($dr_unofficial) }} </td>
                                                <td class="text-right"> {{ $transaction->convert_money_format($cr_unofficial) }} </td>

                                            @elseif(!isset($params['official_unofficial']))
                                                @if (isset($params['from']) && isset($params['to']))
                                                    <td class="text-right"> {{ ($value->official->bf < 0 ? '('.$transaction->convert_money_format(abs($value->official->bf)).')' :$transaction->convert_money_format($value->official->bf)) }} </td>
                                                @endif
                                                <td class="text-right" style=" ">{{ $transaction->convert_money_format($dr_official) }} </td>
                                                <td class="text-right" style=" ">{{ $transaction->convert_money_format($cr_official) }}</td>
                                            @endif
                                        </tr>
                                    @endif
                                @endforeach
                                {{-- total subgroup --}}
                                <tr>
                                    @if($params['report_type'] == "detailed")
                                        <th class="text-right" colspan="2" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important; color:black !important' }}"> {{__('lang.sub_total')}}</th>
                                    @else
                                        <th class="text-right" colspan="3" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important; color:black !important' }}"> <span style="margin: 0px;padding-left: 170px;">{{__('lang.sub_total')}}</span></th>
                                    @endif

                                    @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "all") 
                                            @if (isset($params['from']) && isset($params['to']))
                                                <th class="text-right" >  </th>
                                            @endif
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_official) }}</th>
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_unofficial) }} </th>
                                            @if (isset($params['from']) && isset($params['to']))
                                                <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                                            @endif
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_official) }}</th>
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_unofficial) }} </th>
                                     

                                    @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "official")
                                        @if (isset($params['from']) && isset($params['to']))
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                                        @endif
                                        <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_official) }}</th>
                                        <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_official) }}</th>
                                        
                                    @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "unofficial")
                                        @if (isset($params['from']) && isset($params['to']))
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                                        @endif

                                        <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_unofficial) }} </th>
                                        <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_unofficial) }} </th>

                                    @elseif(!isset($params['official_unofficial']))
                                        
                                        @if (isset($params['from']) && isset($params['to']))
                                            <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                                        @endif
                                        <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_official) }}</th>
                                        <th class="text-right" style="{{ $params['report_type'] == "detailed" ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_official) }}</th>
                                    @endif


                                    
                                    
                                    
                                </tr>
                            @endforeach
                            <tr>
                                <th class="text-right" colspan="{{ $params['report_type'] == "detailed" ? '2' : '3' }}">{{__('lang.group_total')}}</th>

                                @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "all")
                                        @if (isset($params['from']) && isset($params['to']))
                                            <th class="text-right">  </th>
                                        @endif
                                        <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupDR_official) }}</th>
                                        <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupDR_unofficial) }} </th>
                                        @if (isset($params['from']) && isset($params['to']))
                                            <th class="text-right">  </th>
                                        @endif
                                        <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupCR_official) }}</th>
                                        <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupCR_unofficial) }} </th>
                                        
                                
                                     

                                @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "official")
                                    @if (isset($params['from']) && isset($params['to']))
                                        <th class="text-right">  </th>
                                    @endif
                                    <th class="text-right"> {{ $transaction->convert_money_format($totalGroupDR_official) }}</th>
                                    <th class="text-right"> {{ $transaction->convert_money_format($totalGroupCR_official) }}</th>

                                @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "unofficial")
                                    @if (isset($params['from']) && isset($params['to']))
                                        <th class="text-right">  </th>
                                    @endif
                                    <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupDR_unofficial) }} </th>
                                    <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupCR_unofficial) }} </th>

                                @elseif(!isset($params['official_unofficial']))
                                    @if (isset($params['from']) && isset($params['to']))
                                        <th class="text-right">  </th>
                                    @endif
                                    <th class="text-right" > {{ $transaction->convert_money_format($totalGroupDR_official) }}</th>
                                    <th class="text-right" > {{ $transaction->convert_money_format($totalGroupCR_official) }}</th>
                                @endif
                            </tr>
                    @endforeach
                @endforeach
                <tr>
                    <th class="text-right" colspan="{{ $params['report_type'] == "detailed" ? '2' : '3' }}">{{__('lang.total')}}</th>

                        @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "all") 
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif
                                <th class="text-right" > {{ $transaction->convert_money_format($totalDR_official) }}</th>
                                <th class="text-right" > {{ $transaction->convert_money_format($totalDR_unofficial) }}</th>
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif        
                                <th class="text-right" > {{ $transaction->convert_money_format($totalCR_official) }} </th>
                                <th class="text-right" > {{ $transaction->convert_money_format($totalCR_unofficial) }} </th>
                          

                        @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "official")
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalDR_official) }}</th>
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalCR_official) }}</th>

                        @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == "unofficial")
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalDR_unofficial) }} </th>
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalCR_unofficial) }} </th>

                        @elseif(!isset($params['official_unofficial']))
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalDR_official) }}</th>
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalCR_official) }}</th>
                        @endif
                    </tr>
                </tbody>

            </table>
        </div>
    </section>
@stop