{{-- bhai ye code pura revamp hoga fast fixing --}}

@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
        }

        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;
        }

        .table th {
            background: #000 !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>
    <div size="A4" @if ($action == 'Show') style="margin: 30px 50px auto;" @endif>
        @include('admin.partials.header', ['extra' => $extra])

        @php
            $counter = 1;
            $total_doc_total_amount = 0;
            $total_doc_paid_amount = 0;
            $total_doc_balance_amount = 0;
            $total_amount = 0;
            $counter2 = 1;
            $total_received_amount = 0;
            $total_amount = 0;
            $total_amount_purchase_order = 0;
        @endphp

        @if ($list_extra_data['pr_status'] == 'Received' || $list_extra_data['pr_status'] == 'All')

            <div>
                <h3>
                    <u>{{__('lang.received_amount')}} {{$transaction->systemSettingCurrency()}}</u>
                </h3>
            </div>
            <table class="table  table-bordered table-hover" style="font-size: 11px;">
                <thead>
                    <tr>
                        @if ($extra['status'] == 1)
                            <th scope="col" style="width: 4%">{{__('lang.sno')}}</th>
                        @endif
                        <th scope="col" {{ $extra['status'] == 0 ? 'style=width:50%' : 'style=width:17%' }}>{{__('lang.account_name')}}
                        </th>
                        @if ($extra['status'] == 1)
                            <th scope="col" style="width: 12%">{{__('lang.registration_no')}}</th>
                            <th scope="col" style="width: 10%;">{{__('lang.mode_of_payment')}}</th>
                            <th scope="col" style="width: 20%"> {{__('lang.bank')}} {{__('lang.name')}}</th>
                            <th scope="col" style="width: 12%">{{__('lang.voucher_no')}}</th>
                        @endif
                        @if ($extra['status'] == 1)
                            <th scope="col" style="width: 12%">{{__('lang.voucher_date')}}</th>
                        @endif
                        <th scope="col" {{ $extra['status'] == 0 ? 'style=width:50%' : 'style=width:12%' }}>{{__('lang.received_amount')}} {{$transaction->systemSettingCurrency()}}</th>
                    </tr>
                </thead>

                <tbody>
                    @if ($list_extra_data['group'] == 1)
                        @php
                            $receipt_with_group = [];
                            foreach ($receipts as $rv) {
                                if (empty($rv->deleted_at)) {
                                    $transaction_cr = App\Models\ActualReceived::where('id', $rv->id)
                                        ->with('transaction_cr')
                                        ->first();
                                    $customer_name = App\Models\IncomeExpenseHead::find($transaction_cr['transaction_cr'][0]->income_expense_head_id);
                            
                                    $receipt_with_group[$customer_name->IncomeExpenseGroup->name][$customer_name->IncomeExpenseType->name][] = $rv;
                                }
                            }
                            
                        @endphp
                    @endif
                    @if ($list_extra_data['group'] == 1)
                        @foreach ($receipt_with_group as $parent_key => $parent)
                            <tr>
                                <th colspan="8">
                                    {{ $parent_key }}
                                </th>
                            </tr>
                            @foreach ($parent as $child_key => $childs)
                                <tr>
                                    <th colspan="8">
                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {{ $child_key }}
                                    </th>
                                </tr>
                                @foreach ($childs as $receipt)
                                    <tr>
                                        @if ($extra['status'] == 1)
                                            <td>{{ $loop->index + 1 }}</td>
                                        @endif
                                        @php
                                            $transaction_cr = App\Models\ActualReceived::where('id', $receipt->id)
                                                ->with('transaction_cr')
                                                ->first();
                                            $customer_name = App\Models\IncomeExpenseHead::find($transaction_cr['transaction_cr'][0]->income_expense_head_id);
                                        @endphp
                                        <td><a target="_blank"
                                                href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $transaction_cr['transaction_cr'][0]->income_expense_head_id ?? $receipt->income_expense_head_id) }}">{{ App\Models\Common::showHeads($customer_name) == '.. ' ? $receipt->name : App\Models\Common::showHeads($customer_name) }}</a>
                                        </td>
                                        @if ($extra['status'] == 1)
                                            <td>
                                                <a target="_blank"
                                                    href="{{ !empty($receipt->sell_id) ? route('sell.edit', $receipt->sell_id) : '#' }}">{{ $receipt->registration_no ?? '-' }}</a>
                                            </td>
                                            <td>{{ ucfirst(!empty($receipt->made_of_payment) ? $receipt->made_of_payment : 'JV') ?? 'JV' }}
                                            </td>

                                            <td>
                                                <a href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $receipt->receipt_head_id ?? $receipt->income_expense_head_id) }}"
                                                    target="_blank">{{ $receipt->head_name ?? $receipt->name }}</a>
                                            </td>
                                            <td>
                                                {{ $receipt->receipt_no ?? $receipt->jv_no }}
                                            </td>
                                        @endif
                                        @if ($extra['status'] == 1)
                                            <td>
                                                {{ App\Models\Common::viewDate($receipt->voucher_date) }}
                                            </td>
                                        @endif
                                        <td class="text-right">
                                            {{ $transaction->convert_money_format($receipt->actual_amount ?? $receipt->cr) }}
                                        </td>

                                    </tr>

                                                                    @endforeach
                            @endforeach
                        @endforeach

                        <tr>
                            @if ($extra['status'] == 1)
                                <th colspan="5" class="text-right"class="text-right"></th>
                                <th></th>
                                <th class="text-right"><b>{{__('lang.total_received')}}</b></th>
                                <th class="text-right">
                                    <b>{{ $transaction->convert_money_format($total_received_amount) }}</b>
                                </th>
                            @else
                                <th class="text-right"><b>{{__('lang.total_received')}} </b></th>
                                <th class="text-right">
                                    <b>{{ $transaction->convert_money_format($total_received_amount) }}</b>
                                </th>
                            @endif
                        </tr>
                    @else
                        @foreach ($receipts as $receipt)
                            {{-- Deleted At not working on query end will check why hotfixing for now. --}}
                            @if (empty($receipt->deleted_at))
                                <tr>
                                    @if ($extra['status'] == 1)
                                        <td>{{ $counter2 }}</td>
                                    @endif
                                    @php
                                        $transaction_cr = App\Models\ActualReceived::where('id', $receipt->id)
                                            ->with('transaction_cr')
                                            ->first();
                                        $customer_name = App\Models\IncomeExpenseHead::find($transaction_cr['transaction_cr'][0]->income_expense_head_id);
                                    @endphp
                                    <td><a target="_blank"
                                            href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $transaction_cr['transaction_cr'][0]->income_expense_head_id ?? $receipt->income_expense_head_id) }}">{{ App\Models\Common::showHeads($customer_name) == '.. ' ? $receipt->name : App\Models\Common::showHeads($customer_name) }}</a>
                                    </td>
                                    @if ($extra['status'] == 1)
                                        <td>
                                            <a target="_blank"
                                                href="{{ !empty($receipt->sell_id) ? route('sell.edit', $receipt->sell_id) : '#' }}">{{ $receipt->registration_no ?? '-' }}</a>
                                        </td>
                                        <td>{{ ucfirst(!empty($receipt->made_of_payment) ? $receipt->made_of_payment : 'JV') ?? 'JV' }}
                                        </td>

                                        <td>
                                            <a href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $receipt->receipt_head_id ?? $receipt->income_expense_head_id) }}"
                                                target="_blank">{{ $receipt->head_name ?? $receipt->name }}</a>
                                        </td>
                                        <td>
                                            {{ $receipt->receipt_no ?? $receipt->jv_no }}
                                        </td>
                                    @endif
                                    @if ($extra['status'] == 1)
                                        <td>
                                            {{ App\Models\Common::viewDate($receipt->voucher_date) }}
                                        </td>
                                    @endif
                                    <td class="text-right">
                                        {{ $transaction->convert_money_format($receipt->actual_amount ?? $receipt->cr) }}
                                    </td>

                                </tr>
                                                            @endif
                        @endforeach

                        <tr>
                            @if ($extra['status'] == 1)
                                <th colspan="5" class="text-right"class="text-right"></th>
                                <th></th>
                                <th class="text-right"><b>{{__('lang.total_received')}} </b></th>
                                <th class="text-right">
                                    <b>{{ $transaction->convert_money_format($total_received_amount) }}</b>
                                </th>
                            @else
                                <th class="text-right"><b>{{__('lang.total_received')}} </b></th>
                                <th class="text-right">
                                    <b>{{ $transaction->convert_money_format($total_received_amount) }}</b>
                                </th>
                            @endif
                        </tr>
                    @endif
                </tbody>
            </table>

        @endif

        @if ($list_extra_data['pr_status'] == 'Paid' || $list_extra_data['pr_status'] == 'All')
            <div>
                <h3>
                    <u>{{__('lang.paid_amount')}} </u>
                </h3>
            </div>
            <table class="table  table-bordered table-hover" style="font-size: 12px;">
                <thead>
                    <tr>
                        @if ($extra['status'] == 1)
                            <th scope="col" style="width: 4%">{{__('lang.sno')}}</th>
                        @endif
                        <th scope="col" {{ $extra['status'] == 0 ? 'style=width:50%' : 'style=width:17%' }}>{{__('lang.account_name')}}
                        </th>
                        @if ($extra['status'] == 1)
                            <th scope="col" style="width: 12%">{{__('lang.expense_type')}}</th>
                            <th scope="col" style="width: 10%;">{{__('lang.mode_of_payment')}}</th>
                            <th scope="col" style="width: 20%"> {{__('lang.bank')}} {{__('lang.name')}}</th>
                            <th scope="col" style="width: 12%">{{__('lang.voucher_no')}}</th>
                        @endif
                        @if ($extra['status'] == 1)
                            <th scope="col" style="width: 12%">{{__('lang.voucher_date')}}</th>
                        @endif
                        <th scope="col" 
                        
                        @if($extra['status'] == 0)
                        colspan="7"
                        @else
                        style="width:20%"
                        @endif
                        >
                        {{__('lang.paid_amount')}}
                        
                        </th>
                    </tr>
                </thead>

                <tbody>
                    @if ($list_extra_data['group'] == 1)
                        @php
                            $arr = [];
                            $sorted_array = [];
                            
                            foreach ($infos->merge($journal_cr) as $in) {
                                if($in->type == 'purchase_order') {
                                    $head_code = App\Models\IncomeExpenseHead::where(['reference_id' => $in->vendor_id, 'reference_type' => 'vendor'])->first();
                                    $name = ucfirst($head_code->IncomeExpenseGroup->code . '.' . $head_code->IncomeExpenseType->code . '.' . $head_code->code . ' ' . $head_code->name);
                                }
                                else  {
                                    $dr_account = App\Models\Transaction::where(['voucher_no' => trim($in->pv_no), 'voucher_type' => 'PV'])->get();
                                    $head_code = App\Models\IncomeExpenseHead::find($dr_account[1]->income_expense_head_id);
                                    $name = ucfirst($head_code->IncomeExpenseGroup->code . '.' . $head_code->IncomeExpenseType->code . '.' . $head_code->code . ' ' . $head_code->name);
                                } 
                            
                                $arr[] = [
                                    'name' => $name == '.. ' ? $in->name : $name,
                                    'pv_no' => !empty($in->pv_no) ? $in->pv_no : $in->jv_no,
                                    'head_code' => !empty($head_code->id) ? $head_code->id : $in->income_expenses_head_id,
                                    'type' => $in->type,
                                    'voucher_type' => $in->voucher_type,
                                    'particulars' => $in->particulars,
                                    'amount' => !empty($in->amount) ? $in->amount : $in->dr,
                                    'payee_name' => $in->payee_name,
                                    'mode_of_payment' => !empty($in->mode_of_payment) ? $in->mode_of_payment : 'JV',
                                    'branch' => $in->branch,
                                    'voucher_date' => $in->voucher_date,
                                    'created_by' => $in->created_by,
                                    'vendor_id' => $in->vendor_id,
                                    'purchase_id' => $in->purchase_id,
                                    'vendor_name' => $in->vendor_name,
                                    'group' => !empty($head_code->IncomeExpenseGroup->name) ? $head_code->IncomeExpenseGroup->name : App\Models\IncomeExpenseGroup::find($in->income_expense_group_id)->name,
                                    'sub_group' => !empty($head_code->IncomeExpenseType->name) ? $head_code->IncomeExpenseType->name : App\Models\IncomeExpenseType::find($in->income_expense_type_id)->name,
                                ];
                            }

                            foreach ($arr as $item) {
                                if ($extra['status'] == 1) {
                                    $sorted_array[$item['group']][$item['sub_group']][] = $item;
                                    $sorted_array[$item['group']][$item['sub_group']]['sub_amount'] += $item['amount'];
                                } else {
                                    $sorted_array[$item['group']][$item['sub_group']][$item['name']]['name'] = $item['name'];
                                    $sorted_array[$item['group']][$item['sub_group']][$item['name']]['head_code'] = $item['head_code'];
                                    $sorted_array[$item['group']][$item['sub_group']][$item['name']]['amount'] += $item['amount'];
                                    $sorted_array[$item['group']][$item['sub_group']]['sub_amount'] += $item['amount'];
                                }
                            }

                        @endphp
                        @foreach ($sorted_array as $key1 => $values)
                            @if ($extra['status'] == 1)
                                <tr>
                                    <th colspan="9">
                                        {{ $key1 }}
                                    </th>
                                </tr>

                                @foreach ($values as $key => $item)
                                    @php
                                        unset($item['sub_amount']);
                                    @endphp
                                    <tr>
                                        <th colspan="9">
                                            &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;{{ $key }}
                                        </th>
                                    </tr>
                                    @foreach ($item as $i)
                                        <tr>
                                            <td>{{ $counter }}</td>
                                            <td>
                                                <a href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $i['head_code']) }}"
                                                    target="_blank">{{ $i['name'] ?? $i['vendor_name'] }}</a>
                                            </td>
                                            <td style="text-align: right">
                                                {{ $type ?? '-' }}
                                            </td>
                                            @php
                                                if ($i['type'] == 'general') {
                                                    $type = 'General';
                                                } else {
                                                    $type = 'Purchase Order';
                                                }
                                            @endphp
                                            <td>{{ ucfirst($i['mode_of_payment']) }}</td>
                                            @php
                                                $bank = App\Models\PaymentVoucher::with('transaction_cr')
                                                    ->where('pv_no', trim($i['pv_no']))
                                                    ->first();
                                                $dr_account = App\Models\PaymentVoucher::with('transaction_dr')
                                                    ->where('pv_no', trim($i['pv_no']))
                                                    ->first();
                                                
                                                if ($info->mode_of_payment == 'cash') {
                                                    $bank_name = '-';
                                                } else {
                                                    $head_code = App\Models\IncomeExpenseHead::find($dr_account['transaction_cr'][0]->income_expense_head_id);
                                                    $bank_name = $head_code->IncomeExpenseGroup->code . '.' . $head_code->IncomeExpenseType->code . '.' . $head_code->code . ' ' . $head_code->name;
                                                }
                                            @endphp
                                            <td>{{ $bank_name }}</td>
                                            <td>{{ $i['pv_no'] ?? '-' }}</td>
                                            <td>
                                                {{ $i['voucher_date'] ?? '-' }}
                                            </td>
                                            <td style="text-align: right">
                                                {{ $transaction->convert_money_format($i['amount']) }}
                                            </td>
                                        </tr>
                                                                            @endforeach

                                    <tr>
                                        @if ($extra['status'] == 1)
                                            <th colspan="5" class="text-right"></th>
                                            <th></th>
                                            <th class="text-right">{{__('lang.sub_group_total')}} </th>
                                            <th class="text-right">
                                                {{ $transaction->convert_money_format($values[$key]['sub_amount'] ?? 0) }}
                                            </th>
                                        @else
                                            <th class="text-right">
                                                <b>{{__('lang.sub_group_total')}} </b>
                                            </th>
                                            <th class="text-right">
                                                <b>{{ $transaction->convert_money_format($values[$key]['sub_amount'] ?? 0) }}</b>
                                            </th>
                                        @endif
                                    </tr>
                                @endforeach
                            @else

									@php
										$counter++;
										$total_amount += $item['amount'];
									@endphp
                                <tr>
                                    <th colspan="9">
                                        {{ $key1 }}
                                    </th>
                                </tr>

                                @foreach ($values as $key => $item)
                                    @php
                                        unset($item['sub_amount']);
                                    @endphp
                                    <tr>
                                        <th colspan="9">
                                            &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;{{ $key }}
                                        </th>
                                    </tr>
                                    <tr>
                                            @foreach ($item as $k => $small_item)
											<tr>
												<td>
													<a href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $small_item['head_code']) }}"
														target="_blank">{{ $small_item['name'] }}</a>
												</td>
												<td style="text-align: right">
													{{ $transaction->convert_money_format($small_item['amount']) }}
												</td>
											</tr>

											@php
												$total_amount += $small_item['amount'];
											@endphp
									 </tr>
                                @endforeach
								<tr>
									<th class="text-right"> <b>{{__('lang.sub_group_total')}} </b> </th>
									<th class="text-right"> <b>{{ $transaction->convert_money_format($values[$key]['sub_amount']) }}</b></th>
								</tr>
									 
                       	 		@endforeach
                    		@endif
        @endforeach
    @else
        @foreach ($infos->merge($journal_cr) as $info)
            <tr>
                @if ($extra['status'] == 1)
                    <td>{{ $counter }}</td>
                @endif
                @php
                    if ($info->type == 'general') {
                        $dr_account = App\Models\PaymentVoucher::with('transaction_dr')
                            ->where('pv_no', trim($info->pv_no))
                            ->first();
                        $head_code = App\Models\IncomeExpenseHead::find($dr_account['transaction_dr'][0]->income_expense_head_id);
                        $name = ucfirst($head_code->IncomeExpenseGroup->code . '.' . $head_code->IncomeExpenseType->code . '.' . $head_code->code . ' ' . $head_code->name);
                    } else {
                        $name = $info->vendor_name ?? $info->name;
                    }
                    
                @endphp
                <td><a href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $head_code->id) }}"
                        target="_blank">{{ $name == '.. ' ? $info->name : $name }}</a></td>
                @if ($extra['status'] == 1)
                    @php
                        if ($info->type == 'general') {
                            $type = 'General';
                        } else {
                            $type = 'Purchase order';
                        }
                    @endphp
                    <td>{{ $type ?? '-' }}</td>
                    <td>{{ ucfirst($info->mode_of_payment) }}</td>
                @endif

                @php
                    $bank = App\Models\PaymentVoucher::with('transaction_cr')
                        ->where('pv_no', trim($info->pv_no))
                        ->first();
                    
                    if ($info->mode_of_payment == 'cash') {
                        $bank_name = '-';
                    } else {
                        $head_code = App\Models\IncomeExpenseHead::find($dr_account['transaction_cr'][0]->income_expense_head_id);
                        $bank_name = $head_code->IncomeExpenseGroup->code . '.' . $head_code->IncomeExpenseType->code . '.' . $head_code->code . ' ' . $head_code->name;
                    }
                @endphp
                @if ($extra['status'] == 1)
                    <td><a href="{{ redirectRoute(request()->get('branch'), $search_by['from'], $search_by['to'], $head_code->id) }}"
                            target="_blank">{{ $bank_name }}</a> </td>
                    @php
                        if ($info->type == 'general') {
                            $pv_no = $info->pv_no;
                        } else {
                            $pv_no = $info->purchase_id;
                        }
                    @endphp
                    <td>{{ $pv_no ?? $info->jv_no }}</td>
                @endif
                @if ($extra['status'] == 1)
                    <td>
                        {{ $info->voucher_date }}
                    </td>
                @endif
                <td class="text-right">
                    {{ $transaction->convert_money_format($info->amount ?? $info->total_dr_amount) }}
                </td>

            </tr>

            @php
                $total_amount += $info->amount ?? $info->total_dr_amount;
            @endphp
        @endforeach
        @endif


        <tr>
            @if ($extra['status'] == 1)
                <th colspan="5" class="text-right"></th>
                <th></th>
                <th class="text-right">{{__('lang.total_paid')}} </th>
                <th class="text-right">{{ $transaction->convert_money_format($total_amount) }}</th>
            @else
                <th class="text-right">
                    <b>{{__('lang.total_paid')}}</b>
                </th>
                <th class="text-right"><b>{{ $transaction->convert_money_format($total_amount) }}</b></th>
            @endif

        </tr>
        </tbody>
        </table>
        <br>
        @if ($list_extra_data['pr_status'] == 'All')
            <table class="table  table-bordered table-hover" style="font-size: 12px;">
                <thead>

                </thead>
                <tbody>
                    <tr>
                        <th class="text-right" style="border: none !important"></th>
                        <th class="text-right" style="border: none !important"></th>
                        <th class="text-right" style="border: none !important">
                            <div
                                style="display: flex;
                        position: absolute;
                        margin-left: 60%;">
                                {{__('lang.balance')}}</div>
                            {{ $transaction->convert_money_format($total_received_amount - $total_amount) }}
                        </th>
                    </tr>
                </tbody>
            </table>
        @endif
        @endif

    </div>
@stop