@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>Gst Percentage</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>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');
                $gstPercentages = \App\Models\AccountingVoucherItem::where('accounting_voucher_id', $voucher->id)
                    ->select('gst_per')
                    ->groupBy('gst_per')
                    ->get();

            @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
                @foreach ($gstPercentages as $gst)
                    @php
                        $acVoucher = \App\Models\AccountingVoucherItem::where('accounting_voucher_id', $voucher->id)
                            ->where('gst_per', $gst->gst_per)
                            ->get();
                    @endphp
                    @if ($voucher->status != 0)
                        <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>{{ $gst->gst_per }}</td>
                            <td>{{ $acVoucher->sum('taxable_value') }}</td>
                            <td>{{ $acVoucher->sum('cgst') }}</td>
                            <td>{{ $acVoucher->sum('sgst') }}</td>
                            <td>{{ $acVoucher->sum('igst') }}</td>
                            <td>{{ $acVoucher->sum('cess') }}</td>
                            <td>{{ $acVoucher->sum('total') }}</td>
                            <td>{{ $businessType }}
                            </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>{{ $gst->gst_per }}</td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td>{{ $businessType }}
                            </td>
                            <td>Cancelled</td>
                        </tr>
                    @endif
                @endforeach
            @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');
                $gstPercentages = \App\Models\AccountingVoucherItem::where('accounting_voucher_id', $voucher->id)
                    ->select('gst_per')
                    ->groupBy('gst_per')
                    ->get();
            @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
                @foreach ($gstPercentages as $gst)
                    @php
                        $acVoucher = \App\Models\AccountingVoucherItem::where('accounting_voucher_id', $voucher->id)
                            ->WhereHas('stockItem', function ($query) use ($gst) {
                                $query->where('stock_items.gst', $gst->gst_per);
                            })
                            ->get();
                    @endphp
                    @if ($voucher->status != 0)
                        <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>{{ $gst->gst_per }}</td>
                            <td>{{ $acVoucher->sum('taxable_value') }}</td>
                            <td>{{ $acVoucher->sum('cgst') }}</td>
                            <td>{{ $acVoucher->sum('sgst') }}</td>
                            <td>{{ $acVoucher->sum('igst') }}</td>
                            <td>{{ $acVoucher->sum('cess') }}</td>
                            <td>{{ $acVoucher->sum('total') }}</td>
                            <td>{{ $businessType }}
                            </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>{{ $gst->gst_per }}</td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td>{{ $businessType }}
                            </td>
                            <td>Cancelled</td>
                        </tr>
                    @endif
                @endforeach
            @endif
        @endforeach
    </tbody>
</table>