@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 =='pdf' ? 'margin: 30px 30px;' : '' ;
            @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;
        }
        thead {display: table-row-group;}
        .btn:focus {
            outline: none !important;
        }
        .btn:not(.btn-link):not(.btn-circle) {
            box-shadow: 0 2px 5px rgba(0, 0, 0, 0.16), 0 2px 10px rgba(0, 0, 0, 0.12);
            -webkit-border-radius: 2px;
            -moz-border-radius: 2px;
            -ms-border-radius: 2px;
            border-radius: 2px;
            border: none;
            font-size: 14px;
            outline: none;
        }
        .btn:not(.btn-link):not(.btn-circle):hover {
            outline: none;
        }
        .btn:not(.btn-link):not(.btn-circle) i {
            font-size: 20px;
            position: relative;
            top: 3px;
        }
        .btn:not(.btn-link):not(.btn-circle) span {
            position: relative;
            top: -2px;
            margin-left: 3px;
        }
        .btn-warning,
        .btn-warning:hover,
        .btn-warning:active,
        .btn-warning:focus {
            background-color: #ff9600 !important;
        }
        .btn-danger,
        .btn-danger:hover,
        .btn-danger:active,
        .btn-danger:focus {
            background-color: #fb483a !important;
        }
        .btn-info,
        .btn-info:hover,
        .btn-info:active,
        .btn-info:focus {
            background-color: #00b0e4 !important;
        }
        .btn-success,
        .btn-success:hover,
        .btn-success:active,
        .btn-success:focus {
            background-color: #2b982b !important;
        }
        .btn-primary,
        .btn-primary:hover,
        .btn-primary:active,
        .btn-primary:focus {
            background-color: #1f91f3 !important;
        }
        .table td, .table th {
          padding: .75rem !important;
        vertical-align: top !important;
        border-top: 1px solid #dee2e6 !important;        
    }
    /* .table th
    {
        background-color: #000 !important;
    } */
    
    </style>
    <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  style="max-width: 100%;">
    <div size="A4">
        @include('admin.partials.header', ['extra' => $extra])
        
        {{-- @php
            $collection = collect($query)->mapToGroups(function ($item, $key) {
                return [$item->cr_account => $item->dr];
            }); 
            $arr = [];
            foreach ($collection as $key => $row) {
                $arr[$key]= array_sum($row->toArray());
            }
        @endphp
        <table class="table  table-bordered table-hover"  style="font-size: 12px;">
            <thead>
                <tr>
                    <th scope="col" >Head</th>
                    <th scope="col"  class="text-right">Amount {{$transaction->systemSettingCurrency()}}</th>         
               </tr>
            </thead>
            <tbody>
                @php
                    $total_amount=0;
                @endphp


                @foreach($arr as $key => $row)   

                    <tr>
                        <td>{{$key}}</td>
                        <td class="text-right">{{$transaction->convert_money_format($row)}}</td>
                    </tr>

                    @php
                        $total_amount +=$row; 
                    @endphp
                @endforeach
            </tbody>
            <thead>
                <tr>
                    <th class="text-right">Total </th>
                    <th class="text-right">{{$transaction->convert_money_format($total_amount)}}</th>
                </tr>
            </thead>
        </table> --}}


        <table class="table  table-bordered table-hover"  style="font-size: 12px; " width="50%">
            <thead>
                <tr>
                    <th scope="col" >{{__('lang.HEADS')}}</th>
                    <th scope="col"  class="text-right">{{__('lang.TOTAL_AMOUNT')}} {{$transaction->systemSettingCurrency()}}</th>         
                    <th scope="col"  class="text-right">{{__('lang.PAID_AMOUNT')}} {{$transaction->systemSettingCurrency()}}</th>         
                    <th scope="col"  class="text-right">{{__('lang.balance_amount')}} {{$transaction->systemSettingCurrency()}}</th>         
               </tr>
            </thead>
            <tbody>
                @php
                    $total_amount=0;
                    $head_total_amount=0;
                    $expense_array = [];

                    $collection = collect($query)->mapToGroups(function ($item, $key) {
                       
                        return  
                        [ $item->group_code.'.'. $item->sub_group_code.'. '.$item->subgroupname =>  
                            [ $item->group_code.'.'. $item->sub_group_code.'.'.$item->head_code.'. '.$item->headname.'= '.$item->head_id =>
                                [
                                    'dr' => $item->dr,
                                    'cr' => $item->cr ?? 0
                                ]
                            ]
                        ];
                    }); 

                 
                 
                    foreach ($collection as $key => $row) {
                        foreach ($row as $innerKey => $innerValue) {
                            foreach ($innerValue as $ikey => $ivalue) {
                               
                                $expense_array[$key][$ikey]['dr'] = $ivalue['dr'];
                                $expense_array[$key][$ikey]['cr'] = $ivalue['cr'];
                            }
                        }
                    }
                    

                @endphp

                
                @foreach($expense_array as $key => $row)
                    <tr>
                        <th colspan="4">{{$key}}</th>
                    </tr>
                    @foreach ($row as $innerKey => $innerValue)

                        @php
                            $head = explode("=",$innerKey);
                            if(!empty($extra['branch']) || !empty($search_by['from']) || !empty($search_by['to']))
                            {
                                $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $head[1]  . '&branch_id=' . $extra['branch']->id. '&from=' . $search_by['from'] . '&to=' . $search_by['to'] . '&date_type=1&status=1&voucher_type=0&action=Show';
                            }
                            else
                            {
                                $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $head[1]  . '&branch_id=0&from=&to=&date_type=1&status=1&voucher_type=0&action=Show';
                            }
                        @endphp
                         
                        <tr>
                            <td><a target="_blank" href="{{ $route }}"> {{$head[0]}}</a> </td>
                            <td class="text-right">{{$transaction->convert_money_format($innerValue['dr'])}}</td>
                            <td class="text-right">{{$transaction->convert_money_format($innerValue['cr'])}}</td>

                            @php
                                $balance = $innerValue['dr'] - $innerValue['cr']; 
                            @endphp

                            <td class="text-right">{{($balance < 0 ? '('. $transaction->convert_money_format( abs($balance)) . ')' :$transaction->convert_money_format($balance)  )}}</td>
                        </tr>

                        @php
                            $total_amount_dr +=$innerValue['dr']; 
                            $head_total_amount_dr+=$innerValue['dr'];


                            $total_amount_cr +=$innerValue['cr']; 
                            $head_total_amount_cr+=$innerValue['cr'];

                        @endphp

                    @endforeach
                    <tr>
                        <th class="text-right">{{__('lang.TOTAL')}} </th>
                        <th class="text-right">{{$transaction->convert_money_format($head_total_amount_dr)}}</th>
                        <th class="text-right">{{$transaction->convert_money_format($head_total_amount_cr)}}</th>

                        @php
                            $balance = $head_total_amount_dr - $head_total_amount_cr; 
                        @endphp
                        <th class="text-right">{{($balance < 0 ? '('. $transaction->convert_money_format( abs($balance)) . ')' :$transaction->convert_money_format($balance)  )}}</th>
                    </tr>


                    @php
                        $head_total_amount_dr=0;
                        $head_total_amount_cr=0;
                    @endphp


                @endforeach
            </tbody>
            <thead>
                <tr>
                    <th class="text-right">{{__('lang.GRAND_TOTAL')}} </th>
                    <th class="text-right">{{$transaction->convert_money_format($total_amount_dr)}}</th>
                    <th class="text-right">{{$transaction->convert_money_format($total_amount_cr)}}</th>
                    <th class="text-right">{{$transaction->convert_money_format($total_amount_dr - $total_amount_cr)}}</th>
                </tr>
            </thead>
        </table>

    </div>
</section>
@stop