@php
    use Carbon\Carbon;
    $party = 'Dr';
    switch ($name) {
        case 'Purchase':
            $party = 'Cr';
            break;
        case 'Sales':
            $party = 'Dr';
            break;
        case 'Purchase Return':
            $party = 'Dr';
            break;
        case 'Sales Return':
            $party = 'Cr';
            break;
        default:
            $party = 'Dr';
            break;
    }
@endphp
<table>
    <thead>
        <tr>
            <th>Voucher Number</th>
            <th>Voucher Date</th>
            <th>Voucher Type</th>
            <th>Party Name</th>
            <th>Party Address</th>
            <th>Party Pincode</th>
            <th>Party GSTIN</th>
            <th>Party Code</th>
            <th>Taxable Value</th>
            <th>CGST</th>
            <th>SGST</th>
            <th>IGST</th>
            <th>CESS</th>
            <th>Total</th>
            <th>Business Type</th>
            <th>Supplier Inv No</th>
            <th>Supplier Inv Date</th>
            <th>Status</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>B2B</td>
        </tr>
        @foreach ($vouchers as $voucher)
            @php
                $businessType =
                    $party == 'Cr'
                        ? ($voucher->creditLedger != null &&
                        $voucher->creditLedger->gst != null &&
                        $voucher->creditLedger->gst != 0
                            ? 'B2B'
                            : 'B2C')
                        : ($voucher->debitLedger != null &&
                        $voucher->debitLedger->gst != null &&
                        $voucher->debitLedger->gst != 0
                            ? 'B2B'
                            : 'B2C');
            @endphp
            @if ($businessType == 'B2B')
                @if (($party == 'Cr' && $voucher->creditLedger == null) || ($party == 'Dr' && $voucher->debitLedger == null))
                    @php
                        $ledgerName = '';
                    @endphp
                    @foreach ($paymentLedgers as $paymentLedger)
                        @php
                            $ledger = App\Models\AccountingVoucherDetails::where('accounting_voucher_id', $voucher->id)
                                ->where('ledger_id', $paymentLedger->id)
                                ->first();
                            if ($ledger) {
                                $ledgerName .= $paymentLedger->name . ', ';
                            }
                        @endphp
                    @endforeach
                @endif
                @if ($voucher->status != 0)
                    @if ($voucher->is_accounts_only == 0)
                        @php
                            $taxableValue = $voucher->items->sum('taxable_value');
                            $cgst = $voucher->items->sum('cgst');
                            $sgst = $voucher->items->sum('sgst');
                            $igst = $voucher->items->sum('igst');
                            $cess = $voucher->items->sum('cess');
                            $total = $voucher->items->sum('total');
                        @endphp
                    @else
                        @php
                            $taxableValue = 0;
                            $cgst = 0;
                            $sgst = 0;
                            $igst = 0;
                            $cess = 0;
                            $total = $voucher->amount;
                            foreach ($voucher->accountingVoucherDetails as $key => $detail) {
                                if ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'CGST') {
                                    $cgst += $detail->amount;
                                } elseif ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'SGST') {
                                    $sgst += $detail->amount;
                                } elseif ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'IGST') {
                                    $igst += $detail->amount;
                                } elseif ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'CESS') {
                                    $cess += $detail->amount;
                                } elseif (
                                    $detail->ledger->group->name == 'Sales Accounts' ||
                                    $detail->ledger->group->name == 'Purchase Accounts'
                                ) {
                                    $taxableValue += $detail->amount;
                                }
                            }
                            $total = $cgst + $sgst + $igst + $cess + $taxableValue;
                        @endphp
                    @endif
                    <tr>
                        <td>{{ $voucher->voucher_number }}</td>
                        <td>{{ Carbon::parse($voucher->voucher_date)->format('d-m-Y') }}</td>
                        <td>{{ $voucher->voucherType->name }}</td>
                        <td>{{ $party == 'Cr'
                            ? ($voucher->creditLedger != null
                                ? $voucher->creditLedger->name
                                : $ledgerName)
                            : ($voucher->debitLedger != null
                                ? $voucher->debitLedger->name
                                : $ledgerName) }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->address : $voucher->debitLedger?->address }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->pin_code : $voucher->debitLedger?->pin_code }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->gst : $voucher->debitLedger?->gst }}</td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->ledger_code : $voucher->debitLedger?->ledger_code }}
                        </td>
                        <td>{{ $taxableValue }}</td>
                        <td>{{ $cgst }}</td>
                        <td>{{ $sgst }}</td>
                        <td>{{ $igst }}</td>
                        <td>{{ $cess }}</td>
                        <td>{{ $total }}</td>
                        <td>{{ $businessType }}
                        </td>
                        <td>{{ $voucher->supplier_invoice_no }}</td>
                        <td>{{ $voucher->supplier_invoice_date != null ? Carbon::parse($voucher->supplier_invoice_date)->format('d-m-Y') : '' }}
                        </td>
                        <td>{{ $voucher->status == 0 ? 'Cancelled' : '' }}</td>
                    </tr>
                @else
                    <tr>
                        <td>{{ $voucher->voucher_number }}</td>
                        <td>{{ Carbon::parse($voucher->voucher_date)->format('d-m-Y') }}</td>
                        <td>{{ $voucher->voucherType->name }}</td>
                        <td>{{ $party == 'Cr'
                            ? ($voucher->creditLedger != null
                                ? $voucher->creditLedger->name
                                : $ledgerName)
                            : ($voucher->debitLedger != null
                                ? $voucher->debitLedger->name
                                : $ledgerName) }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->address : $voucher->debitLedger?->address }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->pin_code : $voucher->debitLedger?->pin_code }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->gst : $voucher->debitLedger?->gst }}</td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->ledger_code : $voucher->debitLedger?->ledger_code }}
                        </td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td>{{ $businessType }}
                        </td>
                        <td>{{ $voucher->supplier_invoice_no }}</td>
                        <td>{{ $voucher->supplier_invoice_date != null ? Carbon::parse($voucher->supplier_invoice_date)->format('d-m-Y') : '' }}
                        </td>
                        <td>Cancelled</td>
                    </tr>
                @endif
            @endif
        @endforeach
        <tr></tr>
        <tr>
            <td>B2C</td>
        </tr>
        @foreach ($vouchers as $voucher)
            @php
                $businessType =
                    $party == 'Cr'
                        ? ($voucher->creditLedger != null &&
                        $voucher->creditLedger->gst != null &&
                        $voucher->creditLedger->gst != 0
                            ? 'B2B'
                            : 'B2C')
                        : ($voucher->debitLedger != null &&
                        $voucher->debitLedger->gst != null &&
                        $voucher->debitLedger->gst != 0
                            ? 'B2B'
                            : 'B2C');
            @endphp
            @if ($businessType == 'B2C')
                @if (($party == 'Cr' && $voucher->creditLedger == null) || ($party == 'Dr' && $voucher->debitLedger == null))
                    @php
                        $ledgerName = '';
                    @endphp
                    @foreach ($paymentLedgers as $paymentLedger)
                        @php
                            $ledger = App\Models\AccountingVoucherDetails::where('accounting_voucher_id', $voucher->id)
                                ->where('ledger_id', $paymentLedger->id)
                                ->first();
                            if ($ledger) {
                                $ledgerName .= $paymentLedger->name . ', ';
                            }
                        @endphp
                    @endforeach
                @endif
                @if ($voucher->status != 0)
                    @if ($voucher->is_accounts_only == 0)
                        @php
                            $taxableValue = $voucher->items->sum('taxable_value');
                            $cgst = $voucher->items->sum('cgst');
                            $sgst = $voucher->items->sum('sgst');
                            $igst = $voucher->items->sum('igst');
                            $cess = $voucher->items->sum('cess');
                            $total = $voucher->items->sum('total');
                        @endphp
                    @else
                        @php
                            $taxableValue = 0;
                            $cgst = 0;
                            $sgst = 0;
                            $igst = 0;
                            $cess = 0;
                            $total = $voucher->amount;
                            foreach ($voucher->accountingVoucherDetails as $key => $detail) {
                                if ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'CGST') {
                                    $cgst += $detail->amount;
                                } elseif ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'SGST') {
                                    $sgst += $detail->amount;
                                } elseif ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'IGST') {
                                    $igst += $detail->amount;
                                } elseif ($detail->ledger->tax_type != null && $detail->ledger->tax_type == 'CESS') {
                                    $cess += $detail->amount;
                                } elseif (
                                    $detail->ledger->group->name == 'Sales Accounts' ||
                                    $detail->ledger->group->name == 'Purchase Accounts'
                                ) {
                                    $taxableValue += $detail->amount;
                                }
                            }
                            $total = $cgst + $sgst + $igst + $cess + $taxableValue;
                        @endphp
                    @endif
                    <tr>
                        <td>{{ $voucher->voucher_number }}</td>
                        <td>{{ Carbon::parse($voucher->voucher_date)->format('d-m-Y') }}</td>
                        <td>{{ $voucher->voucherType->name }}</td>
                        <td>{{ $party == 'Cr'
                            ? ($voucher->creditLedger != null
                                ? $voucher->creditLedger->name
                                : $ledgerName)
                            : ($voucher->debitLedger != null
                                ? $voucher->debitLedger->name
                                : $ledgerName) }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->address : $voucher->debitLedger?->address }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->pin_code : $voucher->debitLedger?->pin_code }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->gst : $voucher->debitLedger?->gst }}</td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->ledger_code : $voucher->debitLedger?->ledger_code }}
                        </td>
                        <td>{{ $taxableValue }}</td>
                        <td>{{ $cgst }}</td>
                        <td>{{ $sgst }}</td>
                        <td>{{ $igst }}</td>
                        <td>{{ $cess }}</td>
                        <td>{{ $total }}</td>
                        <td>{{ $businessType }}
                        </td>
                        <td>{{ $voucher->supplier_invoice_no }}</td>
                        <td>{{ $voucher->supplier_invoice_date != null ? Carbon::parse($voucher->supplier_invoice_date)->format('d-m-Y') : '' }}
                        </td>
                        <td>{{ $voucher->status == 0 ? 'Cancelled' : '' }}</td>
                    </tr>
                @else
                    <tr>
                        <td>{{ $voucher->voucher_number }}</td>
                        <td>{{ Carbon::parse($voucher->voucher_date)->format('d-m-Y') }}</td>
                        <td>{{ $voucher->voucherType->name }}</td>
                        <td>{{ $party == 'Cr'
                            ? ($voucher->creditLedger != null
                                ? $voucher->creditLedger->name
                                : $ledgerName)
                            : ($voucher->debitLedger != null
                                ? $voucher->debitLedger->name
                                : $ledgerName) }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->address : $voucher->debitLedger?->address }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->pin_code : $voucher->debitLedger?->pin_code }}
                        </td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->gst : $voucher->debitLedger?->gst }}</td>
                        <td>{{ $party == 'Cr' ? $voucher->creditLedger?->ledger_code : $voucher->debitLedger?->ledger_code }}
                        </td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td>{{ $businessType }}
                        </td>
                        <td>{{ $voucher->supplier_invoice_no }}</td>
                        <td>{{ $voucher->supplier_invoice_date != null ? Carbon::parse($voucher->supplier_invoice_date)->format('d-m-Y') : '' }}
                        </td>
                        <td>{{ $voucher->status == 0 ? 'Cancelled' : '' }}</td>
                    </tr>
                @endif
            @endif
        @endforeach
    </tbody>
</table>