{{-- Excel table title format start --}}
<table>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="3" 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="3">
            {{ config('settings.address_1') }}
        </td>
    </tr>

</table>

<table>

    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="3" style="font-size: 20px!important;text-align: center;">
            {{ $heading }}
        </td>
    </tr>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td style="text-align: center;" colspan="3">
            @if ($search_by['from'] && $search_by['to'])
                <b>From:</b> {{ $transaction->date_format($search_by['from']) }}
                <b>To:</b> {{ $transaction->date_format($search_by['to']) }}
            @else
                <b>{{ 'Upto ' . $transaction->date_format(now()) }} </b>
            @endif
        </td>
    </tr>

</table>
{{-- Excel title format end --}}

@if (!$items['customers']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="10" >CUSTOMERS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >{{__('lang.head_code')}}</th>
                <th scope="col" >{{__('lang.name')}}</th>
                <th scope="col" >Father / Husband Name</th>
                <th scope="col" >{{__('lang.phone')}}</th>
                <th scope="col" >Email</th>
                <th scope="col" >Mailing Address</th>
                <th scope="col" >NIC </th>
                <th scope="col">Created At </th>
            </tr>
        </thead>
        <tbody>
            @foreach ($items['customers'] as $key => $customer)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td> {{ $customer->head->code }}</td>
                    <td> <a href="{{ route('customer.edit', $customer->id) }}" target="_blank">{{ $customer->name }}</a></td>
                    <td> {{ $customer->father_or_husband_name }}</td>
                    <td> {{ $customer->phone }}</td>
                    <td> {{ $customer->email }}</td>
                    <td> {{ $customer->mailing_address }}</td>
                    <td> {{ $customer->nid }}</td>
                    <td> {{ date(config('settings.date_format'), strtotime($customer->created_at)) }}  </td>
                </tr>
            @endforeach
        </tbody>
    </table>
    <hr>
@endif

@if (!$items['vendors']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th  colspan="100">VENDORS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >{{__('lang.head_code')}}</th>
                <th scope="col" >{{__('lang.name')}}</th>
                <th scope="col" >{{__('lang.phone')}}</th>
                <th scope="col" >Email</th>
                <th scope="col" >Mailing Address</th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>

            @foreach ($items['vendors'] as $key => $vendor)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td> {{ $vendor->head->code }}</td>
                    <td> <a href="{{ route('vendor.edit', $vendor->id) }}" target="_blank">{{ $vendor->name }}</a></td>
                    <td> {{ $vendor->phone }}</td>
                    <td> {{ $vendor->email }}</td>
                    <td> {{ $vendor->mailing_address }}</td>
                    <td> {{ date(config('settings.date_format'), strtotime($vendor->created_at)) }}  </td>
                    {{-- <td class="text-right">
                        {{ $transaction->convert_money_format(100) }}
                    </td> --}}
                </tr>


            @endforeach
            {{-- <tr>
                <th class="text-right" colspan="">TOTAL </th>
                </th>
            </tr> --}}
        </tbody>
    </table>
    <hr>
@endif

@if (!$items['purchase_requisitions']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="10">PAYMENT REQUISITIONS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >PR No.</th>
                <th scope="col" >Employee</th>
                <th scope="col" >Project</th>
                <th scope="col" >Remarks</th>
                <th scope="col" >Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_pr_amount = 0;
            @endphp
            @foreach ($items['purchase_requisitions'] as $key => $pr)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td><a href="{{ route('requisition_confirmed.edit', $pr->id) }}" target="_blank"> {{ $pr->requisition_id }}</a></td>
                    <td> {{ $pr->employee_id }}</td>
                    <td> {{ $pr->branch->name }}</td>
                    <td> {{ $pr->comment }}</td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($pr->amount) }}
                    </td>
                    <td> {{ date(config('settings.date_format'), strtotime($pr->created_at)) }}  </td>
                </tr>

            @php
                $total_pr_amount += $pr->amount;
            @endphp
            @endforeach
        </tbody>
        <tfoot>
            <th colspan="5">Total</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_pr_amount) }}</th>
            <th></th>
        </tfoot>
    </table>
    <hr>
@endif
        
@if (!$items['purchase_orders']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="100">PURCHASE ORDERS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >PO No.</th>
                <th scope="col" >PR No.</th>
                <th scope="col" >Vendor</th>
                <th scope="col" >Project</th>
                <th scope="col" >Issue Date</th>
                <th scope="col" >Delivery Date</th>
                <th scope="col" >Total {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Discount</th>
                <th scope="col" >Paid Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >GRN Status</th>
                <th scope="col" >Payment Status</th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_of_po_amount = 0;
                $total_po_discount = 0;
                $total_po_amount = 0;
            @endphp
            @foreach ($items['purchase_orders'] as $key => $po)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td><a href="{{ route('purchase_order.edit', $po->id) }}" target="_blank"> {{ $po->purchase_id }}</a></td>
                    <td> {{ $po->requisition_id }}</td>
                    <td> {{ $po->vendor->name }}</td>
                    <td> {{ $po->branch->name }}</td>
                    <td> {{ date(config('settings.date_format'), strtotime($po->issuing_date)) }}  </td>
                    <td> {{ date(config('settings.date_format'), strtotime($po->date_of_delevery)) }}  </td>
                    <td class="text-right">{{ $transaction->convert_money_format($po->totalAmount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($po->totalPODiscount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($po->totalPOAmount) }}</td>
                    <td> {{ $po->status }}</td>
                    <td> {{ $po->payment_status }}</td>
                    <td> {{ date(config('settings.date_format'), strtotime($po->created_at)) }}  </td>
                </tr>

                @php
                    $total_of_po_amount += $po->totalAmount;
                    $total_po_discount += $po->totalPODiscount;
                    $total_po_amount += $po->totalPOAmount;
                @endphp

            @endforeach
            
        </tbody>
        <tfoot>
            <th colspan="7">Total</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_of_po_amount)  }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_po_discount) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_po_amount) }}</th>
            <th></th>
            <th></th>
            <th></th>
        </tfoot>
    </table>
    <hr>
@endif

@if (!$items['sells']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="100">SELLS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >Customer</th>
                <th scope="col" >Registration No.</th>
                <th scope="col" >Project</th>
                <th scope="col" >I Rebate Employee</th>
                <th scope="col" >I Rebate Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >E Rebate Employee</th>
                <th scope="col" >E Rebate Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Additional Charges</th>
                <th scope="col" >Discount</th>
                <th scope="col" >Net Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Sell Date</th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_cost_amount = 0;
                $total_additional_cost = 0;
                $total_discount_amount = 0;
                $total_net_amount = 0;
                $total_employee_rebate = 0;
                $total_external_employee_rebate = 0;
            @endphp
            @foreach ($items['sells'] as $key => $sell)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td><a href="{{ route('customer.edit',['id' => $sell->customer->id]) }}" target="_blank">{{ $sell->customer->name }}</a> </td>
                    <td> <a href="{{ route('sell.edit', ['id' => $sell->id]) }}" target="_blank">{{ $sell->registration_no }}</a></td>
                    <td>{{ $sell->branch->name }}</td>
                    <td> {{ $sell->employee->name }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sell->employee_rebate) }}</td>
                    <td> {{ $sell->ext_employee->name }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sell->external_employee_rebate) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sell->cost_amount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sell->additional_charges) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sell->discount_amount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($sell->net_amount) }}</td>
                    <td> {{ date(config('settings.date_format'), strtotime($sell->sale_date_v2)) }}  </td>
                    <td> {{ date(config('settings.date_format'), strtotime($sell->created_at)) }}  </td>
                </tr>
            @php
                $total_cost_amount += $sell->cost_amount;
                $total_additional_cost += $sell->additional_charges;
                $total_discount_amount += $sell->discount_amount;
                $total_net_amount += $sell->net_amount;
                $total_employee_rebate += $sell->employee_rebate;
                $total_external_employee_rebate += $sell->external_employee_rebate;
            @endphp
            @endforeach
        </tbody>
        <tfoot>
            <th colspan="5">Total</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_employee_rebate) }}</th>
            <th></th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_external_employee_rebate) }}</th>
            <th  style="text-align: right">{{ $transaction->convert_money_format($total_cost_amount) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_additional_cost) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_discount_amount) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($total_net_amount) }}</th>
            <th></th>
            <th></th>
        </tfoot>
    </table>
    <hr>
@endif

@if (!$items['receipts']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="11">RECEIPTS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >Receipt No.</th>
                <th scope="col" >Customers / Heads</th>
                <th scope="col" >Registration No.</th>
                <th scope="col">Unit No</th>
                <th scope="col" >Payment</th>
                <th scope="col" >Mode of Payment</th>
                <th scope="col" >Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Date of Collection</th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $rv_total_amount = 0;
            @endphp
    
            @foreach ($items['receipts'] as $key => $rv)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    @if ($rv->type == NULL || $rv->type =="")
                        <td><a href="{{ route('actual_payment.edit', ['id' => $rv->id, 'sell_id' => $rv->sell_id]) }}" target="_blank">{{ $rv->receipt_no }}</a> </td>
                    @else
                        <td><a href="{{ route('general.receipts.edit', ['id' => $rv->id]) }}" target="_blank">{{ $rv->receipt_no }}</a> </td>
                    @endif
                    @if($rv->type == 'general' && !empty($rv->customer_id))
                        <td> {{ App\Models\IncomeExpenseHead::find($rv->customer_id)->name  }}</td>
                    @else
                        <td> {{ $rv->customer }}</td>
                    @endif
                    <td><a href="{{ route('sell.edit',['id' =>  $rv->sell_id]) }}" target="_blank"> {{ $rv->registration_no ?? '-' }}</a> </td>
                    <td>
                        {{ App\Models\Sell::find($rv->sell_id)->product_id ?? '-' }}
                    </td>
                    <td> {{ $rv->term }}</td>
                    <td> {{ (strtolower($rv->made_of_payment) == 'bank' ? 'Cheque' .' - '. App\Models\IncomeExpenseHead::bankdetail()->where('id',$rv->bank_id)->first()->name : ucwords($rv->made_of_payment) ) }}</td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($rv->actual_amount) }}
                    </td>
                    <td> {{  !empty($rv->date_of_collection) ? $rv->date_of_collection : date(config('settings.date_format'), strtotime($rv->created_at))   }}  </td>
                    <td> {{ date(config('settings.date_format'), strtotime($rv->created_at)) }}  </td>
                </tr>
                @php
                    $rv_total_amount += $rv->actual_amount;
            @endphp
            @endforeach
        </tbody>
        <tfoot>
            <th colspan="8">Total</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($rv_total_amount) }}</th>
            <th></th>
            <th></th>
        </tfoot>
    </table>
    <hr>
@endif

@if (!$items['payment_vouchers']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="10">PAYMENT VOUCHERS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >PV No.</th>
                <th scope="col" >{{__('lang.type')}}</th>
                <th scope="col" >Project</th>
                <th scope="col" >Mode of Payment</th>
                <th scope="col" >Payee Name</th>
                <th scope="col" >Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Voucher Date </th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $total_payments = 0;
            @endphp
            @foreach ($items['payment_vouchers'] as $key => $pv)
            
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td><a href="{{ route('payment_voucher.edit', $pv->id) }}" target="_blank">{{ $pv->pv_no }}</a> </td>
                    <td> {{ ucfirst(str_replace('_', " ", $pv->type)) }}</td>
                    <td> {{ $pv->branch->name }}</td>
                    <td> {{ (strtolower($pv->mode_of_payment) == 'bank' ? 'Cheque' .' - '. App\Models\IncomeExpenseHead::bankdetail()->where ('id',$pv['report_transaction_cr']->income_expense_head_id)->first()->name :ucwords($pv->mode_of_payment)) }}</td>
                    <td> {{ $pv->payee_name }}</td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($pv->amount) }}
                    </td>
                    <td> {{ date(config('settings.date_format'), strtotime($pv->voucher_date)) }}  </td>
                    <td> {{ date(config('settings.date_format'), strtotime($pv->created_at)) }}  </td>
                </tr>
                @php
                    $total_payments+= $pv->amount;
                @endphp
            @endforeach
        </tbody>
        <tfoot>
            <th colspan="6">Total</th>
            <th>{{ $transaction->convert_money_format($total_payments) }}</th>
            <th></th>
            <th></th>
        </tfoot>
    </table>
    <hr>
@endif

@if (!$items['journal_vouchers']->isEmpty())
    <table class="table  table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="11">JOURNAL VOUCHERS</th>
            </tr>
            <tr>
                <th scope="col" >S. No.</th>
                <th scope="col" >JV No.</th>
                <th scope="col" >Project</th>
                <th scope="col">Head Of Account</th>
                <th scope="col" >Particulars</th>
                <th scope="col" >CR {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >DR {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Voucher Date </th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $jv_total_cr_amount = 0;
                $jv_total_dr_amount = 0;
            @endphp
            @foreach ($items['journal_vouchers'] as $key => $jv)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td> <a href="{{ route('jnl_voucher.edit', ['id' => $jv->jv_id]) }}" target="_blank">{{ $jv->voucher_no }}</a></td>
                    <td> {{ $jv->name }}</td>
                    <td>
                        <a href="{{ route('reports_accounts_ledger.branch_wise.report',['income_expense_head_id' => $jv->income_expense_head_id , 'branch_id' => $jv->branch_id , 'action' => 'Show' ]) }}" target="_blank">  {{ App\Models\IncomeExpenseHead::find($jv->income_expense_head_id)->name }}</a>
                    </td>
                    <td> {{ $jv->particulars }}</td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($jv->cr) }}
                    </td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($jv->dr) }}
                    </td>
                    <td> {{ date(config('settings.date_format'), strtotime($jv->voucher_date)) }}  </td>
                    <td> {{ !empty($jv->created_at) ? date(config('settings.date_format'), strtotime($jv->created_at)) : date(config('settings.date_format'), strtotime($jv->voucher_date)) }}  </td>
                </tr>
                @php
                $jv_total_cr_amount += $jv->cr;
                $jv_total_dr_amount += $jv->dr;
            @endphp
            @endforeach
        </tbody>
        <tfoot>
            <th colspan="5">Total</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($jv_total_cr_amount) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($jv_total_dr_amount) }}</th>
            <th></th>
            <th></th>
        </tfoot>
    </table>
@endif

@if (!$items['refunds']->isEmpty())
    <table class="table table-bordered table-hover"  style="font-size: 12px;">
        <thead>
            <tr style="border-top:4px solid;border-bottom:4px solid; border-color:#fff;">
                <th colspan="11">REFUNDS</th>
            </tr>
            <tr>
                <th scope="col" >S No.</th>
                <th scope="col" >JV No.</th>
                <th scope="col" >Project</th>
                <th scope="col">Customer</th>
                <th scope="col" >Actual Amount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Discount {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Total Refund {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" >Payment Status </th>
                <th scope="col" width="8%">Created At </th>
            </tr>
        </thead>
        <tbody>
            @php
                $rf_total_amount = 0;
                $rf_total_discount_amount = 0;
                $rf_total_refund_amount = 0;
            @endphp
            @foreach ($items['refunds'] as $key => $rc)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td> <a href="{{ route('refund_computation.edit', ['id' => $rc->id]) }}" target="_blank">{{ $rc->refrence_computation }}</a></td>
                    <td> {{ $rc->branch->name }}</td>
                    <td>
                        {{ $rc->customer->name }}
                    </td>
                    <td> {{ $transaction->convert_money_format($rc->actual_amount) }}</td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($rc->discounted_amount_deduction) }}
                    </td>
                    <td class="text-right">
                        {{ $transaction->convert_money_format($rc->total_refund_amount) }}
                    </td>
                    <td> {{ $rc->payment_status }}  </td>
                    <td> {{date(config('settings.date_format'), strtotime($rc->created_at)) }}  </td>
                </tr>
                @php
                    $rf_total_amount += $rc->actual_amount;
                    $rf_total_discount_amount += $rc->discounted_amount_deduction;
                    $rf_total_refund_amount += $rc->total_refund_amount;
                @endphp
            @endforeach
        </tbody>
        <tfoot>
            <th colspan="4">Total</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($rf_total_amount) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($rf_total_discount_amount) }}</th>
            <th style="text-align: right">{{ $transaction->convert_money_format($rf_total_refund_amount) }}</th>
            <th style="text-align: right"></th>
            <th style="text-align: right"></th>

        </tfoot>
    </table>
@endif