@php
     $request             = request();

    $is_official         = $request->is_official;
    $is_combined         = (empty($is_official) || $is_official == 'combine') ;

    if($is_combined){
        $brought_forward    = $brought_forward + $brought_forward_unofficial;
    }

    $currency_code          = $transaction->systemSettingCurrency();
    $show_official_tag      = !empty($is_official) && $is_official != 'combine';

    $show_official          = ($is_official == 'official' ||  $is_official == 'separate' ||  $is_official == 'combine' || empty($is_official)); 
    $show_unofficial        = ($is_official == 'unofficial' ||  $is_official == 'separate'); 


    $hide_columns           = request()->get('hide_columns',[]);

    $total_colspan          = 10 - count(array_filter($hide_columns, function($cond) {
                                    return $cond != 'custom_particulars';
                            }));


@endphp
<table>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="9" style="font-size: 20px!important;text-align: center;">
            {{ config('settings.company_name') }}
        </td>
    </tr>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td style="text-align: center;" colspan="9">
            {{ config('settings.address_1') }}
        </td>
    </tr>

</table>

<table>

    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="9" style="font-size: 20px!important;text-align: center;">
            {{ $heading }}
        </td>
    </tr>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td style="text-align: center;" colspan="9">
            @if ($search_by['from'])
                <b>{{__('lang.from')}}</b> {{ $transaction->date_format($search_by['from']) }}
            @endif

            Till
            
            @if ( $search_by['to'])
                <b>{{__('lang.from')}}</b> {{ $transaction->date_format($search_by['to']) }}
            @endif

            @if (  !$search_by['to'] ||  !$search_by['to'])
                <b>{{  $transaction->date_format(now()) }} </b>
            @endif

           
        </td>
    </tr>

</table>


<table class="table table-bordered" style="font-size: 12px; width: 100%;">
    <thead>
        <tr>
            <th colspan="100%" style="font-size:18px !important">
                {{ $common->head_code_with_parent_code($head->id) }} {{ $head->name }} ({{ ucwords($head->reference_type) }})
            </th>
        </tr>
        <tr class="fixed_tr">
            <th>{{__('lang.s_no')}}</th>
            <th>{{$date_type == 'cheque_date' ?  __('lang.cheque') : __('lang.voucher')}} {{__('lang.date')}}</th>
            <th>{{__('lang.voucher_no')}}</th>

            @if(!in_array('registration_no',$hide_columns))
                <th>{{__('lang.registration_no')}}</th>
            @endif
            <th>{{__('lang.project')}}</th>

            @if(!in_array('instrument_no',$hide_columns))
                <th>{{__('lang.instrument_no')}}</th>
            @endif

            @if(!in_array('reference_no',$hide_columns))
                <th>{{__('lang.reference_no')}}</th>
            @endif

            @if(!in_array('mode_of_payment',$hide_columns))
                <th>{{__('lang.mode_of_payment')}}</th>
            @endif
            <th>{{__('lang.particulars')}}</th>

            @if(!in_array('payee_name',$hide_columns))
                <th>{{__('lang.payee_name')}}	</th>
            @endif

            @if($show_official)
            <th class="text-right">{{__('lang.dr')}} {{ $currency_code }} @if($show_official_tag)  <br> ({{__('lang.official')}}) @endif</th>
            <th class="text-right">{{__('lang.cr')}} {{ $currency_code }}@if($show_official_tag)   <br> ({{__('lang.official')}}) @endif</th>
            @endif

            @if($show_unofficial)
            <th class="text-right">{{__('lang.dr')}} {{ $currency_code }}        <br> ({{__('lang.unofficial')}}) </th>
            <th class="text-right">{{__('lang.cr')}} {{ $currency_code }}        <br> ({{__('lang.unofficial')}}) </th>
            @endif
         
            @if($show_official)
            <th class="text-right">{{__('lang.balance')}} {{ $currency_code }}  @if($show_official_tag)<br> ({{__('lang.official')}}) @endif</th>
            @endif

            @if($show_unofficial)
            <th class="text-right">{{__('lang.balance')}} {{ $currency_code }}   <br> ({{__('lang.unofficial')}})</th>
            @endif

        </tr>
    </thead>
    <tbody>

        @php
            $grand_dr                   = 0;
            $grand_cr                   = 0;
            $grand_dr_unofficial        = 0;
            $grand_cr_unofficial        = 0;
            $grand_balance              = $brought_forward;
            $grand_balance_unofficial   = $brought_forward_unofficial;
            $bf_colspan                 = $total_colspan + 2;
            if($is_official=='separate'){
                $bf_colspan                 =  $total_colspan + 4;
            }
        @endphp

        <tr>
            <td colspan="{{ $bf_colspan }}" class="text-right">Balance B/F &nbsp; &nbsp;</td>

            @if($show_official)
            <td class="text-right">{{ Transaction::isNegative($brought_forward) }}</td>
            @endif

            @if($show_unofficial)
            <td class="text-right">{{ Transaction::isNegative($brought_forward_unofficial) }}</td>
            @endif
        </tr>

        @if(count($transactions)==0)
        <tr>
            <td colspan="100%" class="text-center">
                No Transactions
            </td>
        </tr>

        @endif

        @foreach ($transactions as $transaction)
            @php

                $transaction_detail                 = Transaction::getTransactionDetails($transaction,$hide_columns);
                if($transaction->get_actual_received->status != "Void") {
                    $route                          = $transaction_detail->route;
                } else {
                    $route                          = "#";
                }

                $voucher_date                       = $transaction->voucher_date;

                if($date_type == 'cheque_date'){
                    $voucher_date                   = $transaction->cheque_date;
                }

                $voucher_no                         = $transaction->voucher_no;
                $registration_no                    = '-';
                $sell                               = $transaction_detail->sell ?? null;
                $branch                             = $transaction->branch->name;
                $instrument_no                      = $transaction->cheque_number;
                $reference_no                       = $transaction_detail->ref_no ?? null;
                $mode_of_payment                    = $transaction_detail->mode_of_payment ?? null;
                $particulars                        = $transaction_detail->particulars ?? null;
                $particulars                        = $particulars ? $particulars : $transaction->particulars;
                $payee_name                         = $transaction_detail->payee_name ?? null;

                $dr                                 = $transaction->dr;
                $cr                                 = $transaction->cr;
                $dr_unofficial                      = 0;
                $cr_unofficial                      = 0;


                if($transaction->is_official == 0 && !$is_combined){

                    $dr                             = 0;
                    $cr                             = 0;
                    $dr_unofficial                  = $transaction->dr;
                    $cr_unofficial                  = $transaction->cr;
                }

                $balance                            = $grand_balance            + $dr            -$cr;
                $balance_unofficial                 = $grand_balance_unofficial + $dr_unofficial -$cr_unofficial;
             
                $grand_dr                           += $dr;
                $grand_cr                           += $cr;
                $grand_dr_unofficial                += $dr_unofficial;
                $grand_cr_unofficial                += $cr_unofficial;
                $grand_balance                      = $balance;
                $grand_balance_unofficial           = $balance_unofficial;

            @endphp
            <tr>
                <td>{{ $loop->iteration }}</td>
                <td>{{ Transaction::date_format($voucher_date)}}</td>
                <td><a href="{{ $route }}" target="_blank">{{$voucher_no}}</a>  </td>

                @if(!in_array('registration_no',$hide_columns))
                <td>
                    @if($sell)
                        <a href="{{ route('sell.edit',['id'=>$sell->id]) }}" target="_blank">{{ $sell->registration_no }} <br> ({{$sell->customer->name}})</a>
                    @else
                        -
                    @endif
                </td>

                @endif
                <td>{{$branch}}</td>

                @if(!in_array('instrument_no',$hide_columns))
                    <td>{{$instrument_no}}</td>
                @endif

                @if(!in_array('reference_no',$hide_columns))
                    <td>{{$reference_no}}</td>
                @endif

                @if(!in_array('mode_of_payment',$hide_columns))
                    <td>{{$mode_of_payment}}</td>
                @endif
                <td>{!! $particulars !!}</td>

                @if(!in_array('payee_name',$hide_columns))
                    <td>{{$payee_name}}</td>
                @endif


                @if($show_official)
                <td class="text-right">{{Transaction::isNegative($dr)}}</td>
                <td class="text-right">{{Transaction::isNegative($cr)}}</td>
                @endif

                @if($show_unofficial)
                <td class="text-right">{{Transaction::isNegative($dr_unofficial)}}</td>
                <td class="text-right">{{Transaction::isNegative($cr_unofficial)}}</td>
                @endif

                @if($show_official)
                <td class="text-right">{{Transaction::isNegative($balance)}}</td>
                @endif

                @if($show_unofficial)
                <td class="text-right">{{Transaction::isNegative($balance_unofficial)}}</td>
                @endif

            </tr>
        @endforeach 
        <tr>

            
            <th class="text-right"  colspan="{{ $total_colspan }}">{{__('lang.total')}}</th>
            @if($show_official)
            <th class="text-right" >{{ Transaction::isNegative($grand_dr) }}</th>
            <th class="text-right" >{{ Transaction::isNegative($grand_cr) }}</th>
            @endif

            @if($show_unofficial)
            <th class="text-right" >{{ Transaction::isNegative($grand_dr_unofficial) }}</th>
            <th class="text-right" >{{ Transaction::isNegative($grand_cr_unofficial) }}</th>
            @endif

            @if($show_official)
            <th class="text-right" >{{ Transaction::isNegative($grand_balance) }}</th>
            @endif

            @if($show_unofficial)
            <th class="text-right" >{{ Transaction::isNegative($grand_balance_unofficial) }}</th>
            @endif
        </tr>
    </tbody>
</table>