@extends('report.pdf.layouts.app')
@section('pdf_content')
    <table class="table table-border">
        <thead>
            <tr>
                <th width="1%" class="table-border text-center">@lang('SL No')</th>
                <th class="table-border text-center">@lang('Sale Date')</th>
                <th class="table-border text-center">@lang('Invoice Number')</th>
                <th class="table-border text-center">@lang('Location')</th>
                <th class="table-border text-center">@lang('Customer')</th>
                <th class="table-border text-center">@lang('Subtotal')</th>
                <th class="table-border text-center">@lang('Discount')</th>
                <th class="table-border text-center">@lang('Tax / Vat')</th>
                <th class="table-border text-center">@lang('Shiping Charge')</th>
                <th class="table-border text-center">@lang('Payable Amount')</th>
                <th class="table-border text-center">@lang('Total Payment')</th>
                <th class="table-border text-center">@lang('Due Amount')</th>
                <th class="table-border text-center">@lang('Sale Profit')</th>
            </tr>
        </thead>
        <tbody>
            @php
                $net_payment = 0;
                $net_due = 0;
                $net_profit=0;
            @endphp
            @foreach ($items as $key => $item)
                @php
                    $amount = $item->nettotal;
                    $payment = $item->payments->sum('amount');
                    $due = $amount - $payment;

                    $net_payment += $payment;
                    $net_due += $due;
                    $net_profit += sale_profit($item->id);
                @endphp

                <tr>
                    <td class="table-border">{{ $key + 1 }}</td>
                    <td class="table-border">{{ dateformat($item->sale_date) }}</td>
                    <td class="table-border">{{ $item->invoice_no }}</td>
                    <td class="table-border">{{ $item->branch_name }}</td>
                    <td class="table-border">{{ $item->customer }}</td>
                    <td class="text-end table-border">{{ numberformat($item->amount) }}</td>
                    <td class="text-end table-border">{{ numberformat($item->total_discount) }}</td>
                    <td class="text-end table-border">{{ numberformat($item->total_vat) }}</td>
                    <td class="text-end table-border">{{ numberformat($item->shiping_charge) }}</td>
                    <td class="text-end table-border">{{ numberformat($item->nettotal) }}</td>
                    <td class="text-end table-border">{{ numberformat($payment) }}</td>
                    <td class="text-end table-border">{{ numberformat($due) }}</td>
                    <td class="text-end table-border">
                        {{ numberformat(sale_profit($item->id)) }}
                    </td>
                </tr>
            @endforeach
        </tbody>
        <tfoot>
            <tr>
                <td colspan="5" class="text-end">Total</td>
                <td class="text-end">{{ numberFormat(calculateSubtotal($items, 'amount')) }}</td>
                <td class="text-end">{{ numberFormat(calculateSubtotal($items, 'total_discount')) }}</td>
                <td class="text-end">{{ numberFormat(calculateSubtotal($items, 'total_vat')) }}</td>
                <td class="text-end">{{ numberFormat(calculateSubtotal($items, 'shiping_charge')) }}</td>
                <td class="text-end">{{ numberFormat(calculateSubtotal($items, 'nettotal')) }}</td>
                <td class="text-end">{{ numberFormat($net_payment) }}</td>
                <td class="text-end">{{ numberFormat($net_due) }}</td>
                <td class="text-end">{{ numberFormat($net_profit) }}</td>
            </tr>
        </tfoot>
    </table>
@endsection