@php
    if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code)
        $currencyCode = Auth::user()->franchise->countries->currency_code;
    else
        $currencyCode = 'TZS';
@endphp

<table>
    <!-- start:: table head -->
        <thead>
            <tr>
                <!-- <th><b>Month</b></th>
                <th>{{ date('M-Y', strtotime($dates[0])) }} to {{ date('M-Y', strtotime($dates[1])) }}</th> -->
                <th><b>Start Date</b></th>
                <th>{{ $dates[0] }}</th>
                <th></th>
                <th><b>End Date</b></th>
                <th>{{ $dates[1] }}</th>
                <th colspan="4" style="border: 1px solid black; text-align: center;"><b>Total</b></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th colspan="5" style="border: 1px solid black; background-color: #D3D3D3;   text-align: center;"><b>Accounts</b></th>
            </tr>
            <tr>
                <th style="border: 1px solid black; text-align: center;">PV Date</th>
                <th style="border: 1px solid black; text-align: center;">PV Pay Date</th>
                <th style="border: 1px solid black; text-align: center;">PV NO</th>
                <th style="border: 1px solid black; text-align: center;">Company</th>
                <th style="border: 1px solid black; text-align: center;">Description</th>
                <th style="border: 1px solid black; text-align: center;">TZS</th>
                <th style="border: 1px solid black; text-align: center;">USD</th>
                <th style="border: 1px solid black; text-align: center;">Xrate</th>
                <th style="border: 1px solid black; text-align: center;">TZS Total</th>
                @foreach($taxList->sortBy('tax_title') as $tax)
                    <th style="border: 1px solid black; text-align: center;">{{ ($tax->tax_title == 'Withholding Tax') ? 'WHT' : $tax->tax_title }} (%)</th>
                @endforeach
                @foreach($taxList->sortBy('tax_title') as $tax)
                    @if($tax->tax_title == 'Withholding Tax')
                        <th style="border: 1px solid black; text-align: center;">WHT Amount</th>
                        <th style="border: 1px solid black; text-align: center;">WHT Status</th>
                        <th style="border: 1px solid black; text-align: center;">WHT Outstanding</th>
                    @elseif($tax->tax_title !== 'VAT')
                        <th style="border: 1px solid black; text-align: center;"></th>
                        <th style="border: 1px solid black; text-align: center;"></th>
                        <th style="border: 1px solid black; text-align: center;"></th>
                    @endif
                @endforeach
                <th style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">Cost of Goods Sold</th>
                <th style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">Human Capital</th>
                <th style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">Operational Expense</th>
                <th style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">Investment</th>
                <th style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">Tax</th>
            </tr>
        </thead>
    <!-- end:: table head -->
    <!-- start:: table body -->
        <tbody>
            <!-- start department wise rows -->
                @foreach($paymentVoucherList as $paymentVoucher)
                    @php
                        $whtAmount = 0;
                    @endphp

                        @foreach($taxList->sortBy('tax_title') as $tax)
                            @php
                                $taxValue = $paymentVoucher->taxes->where('tax_title', $tax->tax_title)->first();

                                if($tax->tax_title == 'Withholding Tax')
                                    $whtAmount = $paymentVoucher->total_amount_converted * $taxValue->tax_value / 100;
                            @endphp
                        @endforeach

                        @if($whtAmount != 0)
                            @if($paymentVoucher->certificate)
                                @php $bgclr = '#c3e6cb'; @endphp
                            @else
                                @php $bgclr = '#ffeeba'; @endphp
                            @endif
                        @else
                            @php $bgclr = '#c3e6cb'; @endphp
                        @endif


                    <tr>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ $paymentVoucher->pv_date_formatted_full }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ $paymentVoucher->date_collected_formatted_full }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ $paymentVoucher->pv_serial_number }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ $paymentVoucher->company->name ?? '' }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ $paymentVoucher->description }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">
                            @if($paymentVoucher->currency == $currencyCode)
                                {{ round($paymentVoucher->total_amount, 2) }}
                            @endif
                        </td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">
                            @if($paymentVoucher->currency == 'USD')
                                {{ round($paymentVoucher->total_amount, 2) }}
                            @endif
                        </td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">@if($paymentVoucher->currency == 'USD') {{ round($paymentVoucher->conversion_rate, 2) }} @endif</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ round($paymentVoucher->total_amount_converted, 2) }}</td>
                        @foreach($taxList->sortBy('tax_title') as $tax)
                            @php
                                $taxValue = $paymentVoucher->taxes->where('tax_title', $tax->tax_title)->first();

                                if($tax->tax_title == 'Withholding Tax')
                                    $whtAmount = $paymentVoucher->total_amount_converted * $taxValue->tax_value / 100;
                            @endphp
                            <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ $taxValue->tax_value ?? '-' }}</td>
                        @endforeach
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ ($whtAmount != 0) ? round($whtAmount, 2) : '-' }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ ($whtAmount != 0) ? ($paymentVoucher->certificate ? 'Paid' : 'Not Paid') : '-' }}</td>
                        <td style="border: 1px solid black; background-color: {{ $bgclr}}; text-align: center;">{{ ($whtAmount != 0) ? ($paymentVoucher->certificate ? '-' : round($whtAmount, 2)) : '-' }}</td>

                        @php

                            $conversion_rate = ($paymentVoucher->currency == 'USD') ? $paymentVoucher->conversion_rate: 1;

                            $accounts = $paymentVoucher->splits->groupBy('account')->mapWithKeys(function ($group, $key) use($conversion_rate) {
                                return [ $key => $group->sum('amount') * $conversion_rate];
                            })->all();
                        @endphp

                        <td style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">{{ isset($accounts['cost_of_goods_sold']) ? round($accounts['cost_of_goods_sold'], 2) : '-' }}</td>
                        <td style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">{{ isset($accounts['human_capital']) ? round($accounts['human_capital'], 2) : '-' }}</td>
                        <td style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">{{ isset($accounts['operational_expense']) ? round($accounts['operational_expense'], 2) : '-' }}</td>
                        <td style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">{{ isset($accounts['investment']) ? round($accounts['investment'], 2) : '-' }}</td>
                        <td style="border: 1px solid black; background-color: #D3D3D3; text-align: center;">{{ isset($accounts['tax']) ? round($accounts['tax'], 2) :  '-' }}</td>
                    </tr>
                @endforeach
            <!-- end department wise rows -->
        </tbody>
    <!-- end:: table body -->
</table>