<table>
    <tr>
        <th>SL No</th>
        <th>Inv Date</th>
        <th>Inv No</th>
        <th>Party Name</th>
        <th>GSTR No</th>
        <th>Total Qty</th>
        <th>None Taxable</th>
        @foreach($gstPercentages as $gstPercentage)
            <th>{{$gstPercentage->gst}}% Sales</th>
            <th>IGST Amt</th>
            <th>CGST Amt</th>
            <th>SGST Amt</th>
        @endforeach
        <th>Total Tax</th>
        <th>Cess Amt</th>
        <th>Round Off</th>
        <th>Bill Amt</th>
    </tr>
    @foreach ($accountingVouchers as $accountingVoucher )
      <tr>
            <th>{{$loop->iteration}}</th>
            <th>{{date('d/m/Y', strtotime($accountingVoucher->voucher_date))}}</th>
            @php
                $totalGroupedAmount = 0;
                $firstVoucher = \App\Models\AccountingVoucher::where('voucher_type_id', $accountingVoucher->voucher_type_id)->where('voucher_date', $accountingVoucher->voucher_date)->where('status', 1)->orderBy('id', 'asc')->first();
                $lastVoucher = \App\Models\AccountingVoucher::where('voucher_type_id', $accountingVoucher->voucher_type_id)->where('voucher_date', $accountingVoucher->voucher_date)->where('status', 1)->orderBy('id', 'desc')->first();
                $totalTax = 0;
                $nonTaxable = \App\Models\AccountingVoucherItem::whereHas('accountingVoucher', function ($query) use ($accountingVoucher,$cashAndBankLedgerId) {
                    $query->where('accounting_vouchers.voucher_type_id', $accountingVoucher->voucher_type_id)->where('accounting_vouchers.voucher_date', $accountingVoucher->voucher_date)->where('status', 1)
                    ->whereHas('debitLedger',function ($q) use ($cashAndBankLedgerId) {
                        $q->whereIn('group_id', $cashAndBankLedgerId);
                    });
                })->where(function ($query) { $query->where('gst_per', 0)->orWhere('gst_per', null); })->sum('taxable_value');
                $nonTaxable = round($nonTaxable, 2);
                $totalGroupedAmount += $nonTaxable;
                $totalQty = \App\Models\AccountingVoucherItem::whereHas('accountingVoucher', function ($query) use ($accountingVoucher,$cashAndBankLedgerId) {
                    $query->where('accounting_vouchers.voucher_type_id', $accountingVoucher->voucher_type_id)->where('accounting_vouchers.voucher_date', $accountingVoucher->voucher_date)->where('status', 1)
                    ->whereHas('debitLedger',function ($q) use ($cashAndBankLedgerId) {
                        $q->whereIn('group_id', $cashAndBankLedgerId);
                    });
                })->sum('base_qty');
            @endphp
            <th>{{ $firstVoucher->voucher_number }} - {{ $lastVoucher->voucher_number }}</th>
            <th>Cash</th>
            <th></th>
            <th>{{ $totalQty }}</th>

            <th>{{ $nonTaxable }}</th>
            @foreach ($gstPercentages as $gstPercentage)
                @php
                    $gst = $gstPercentage->gst;
                    $acVoucherItems = \App\Models\AccountingVoucherItem::whereHas('accountingVoucher', function ($query) use ($accountingVoucher,$cashAndBankLedgerId) {
                        $query->where('voucher_type_id', $accountingVoucher->voucher_type_id)->where('voucher_date', $accountingVoucher->voucher_date)->where('status', 1)
                        ->whereHas('debitLedger',function ($q) use ($cashAndBankLedgerId) {
                            $q->whereIn('group_id', $cashAndBankLedgerId);
                        });
                    })->where('gst_per', $gst)->get();
                    $igst = round($acVoucherItems->sum('igst'),2);
                    $cgst = round($acVoucherItems->sum('cgst'),2);
                    $sgst = round($acVoucherItems->sum('sgst'),2);
                    $totalTax += $igst + $cgst + $sgst;
                    $taxableValue = round($acVoucherItems->sum('taxable_value'),2);
                    $totalGroupedAmount += $taxableValue;

                @endphp
                <td>{{ $taxableValue }}</td>
                <td>{{ $igst }}</td>
                <td>{{ $cgst }}</td>
                <td>{{ $sgst }}</td>
            @endforeach
            <td>{{ round($totalTax ,2)}}</td>
            @php
                $cess = \App\Models\AccountingVoucherItem::whereHas('accountingVoucher', function ($query) use ($accountingVoucher,$cashAndBankLedgerId) {
                    $query->where('voucher_type_id', $accountingVoucher->voucher_type_id)->where('voucher_date', $accountingVoucher->voucher_date)->where('status', 1)
                    ->whereHas('debitLedger',function ($q) use ($cashAndBankLedgerId) {
                        $q->whereIn('group_id', $cashAndBankLedgerId);
                    });
                })->sum('cess');
                $cess = round($cess,2);
                $totalGroupedAmount += $cess;
                $totalGroupedAmount += $totalTax;
            @endphp
            <td>{{ $cess }}</td>
            @php
                $round_off = round($totalGroupedAmount) - $totalGroupedAmount;
                $amount = $totalGroupedAmount + $round_off;
            @endphp
            <td>{{ $round_off }}</td>
            <td>{{ round($amount) }}</td>
        </tr>
    @endforeach
</table>