@if(isset($flag) && $flag == 'mailInvoice')
<style>
    
    table, th, td {
  border: 1px solid black;
  padding :5px;
}

    </style>
    @else
    <style>
        table {
          border: 1px solid #ccc;

        }
        tr td {
        border-bottom: 1pt solid #ccc;
        }
        tr th {
        border-bottom: 1pt solid #ccc ;
        }

    </style>
    @endif

    <h2>Invoice statement for {{$client->full_name}}</h2>
<div class="" style="padding-top:20px;">
    <table class="table" cellpadding="0" cellspacing="0">
        <tr>
        <th  style="color:black;text-align:left;">Date</th>
        <th style="color:black;text-align:left;">Number</th>
        <th style="color:black;text-align:left;">Type</th>
        <th style="color:black;text-align:left;">Provider</th>
        <th style="color:black;text-align:left;">Amount</th>
        <th style="color:black;text-align:left;">Paid</th>
        <th style="color:black;text-align:left;">Balance</th>
        </tr>
        @php
            $total = 0;
            $amount_paid = 0;
            $balance = 0;
        @endphp
        @foreach($invoices as $result)
        @php
            $amount_paid = $amount_paid + (isset($result->amount_paid) ? $result->amount_paid :  0);
            $total = $total + (isset($result->total)  ? $result->total : 0);
            $balance = $balance + (isset($result->account_balance)  ? $result->account_balance : 0);
        @endphp

        @php
            $pracInv = App\Models\Practitioner::select( 'id', 'first_name', 'last_name' )->where( 'id', $result->practitioner_id )->first();
            $fullName = ucwords( $pracInv->first_name.' '.$pracInv->last_name );
        @endphp
            <tr>
                <td >{{Carbon\Carbon::parse($result->date)->format("d/m/y") ?? "-"}}</td>
                <td >{{$result->invoice_number ?? "-"}}</td>
                <td >
                   @if(isset($result->one_invoiceappt) && isset($result->one_invoiceappt->appointment_type_notess) )
                        {{$result->one_invoiceappt->appointment_type_notess->appointment_type}} 
                    @elseif(isset($result->latest_invoice_product) && isset($result->latest_invoice_product['product_iteams']))
                        {{$result->latest_invoice_product['product_iteams']['product_name']}}
                    @else
                        {{'-'}}
                    @endif
                </td>
                <td >{{$fullName ?? "-"}}</td>
                <td >$ {{$result->total ?? "-"}}</td>
                <td>$ {{$result->amount_paid ?? "-"}}</td>
                <td>$ {{$result->account_balance ?? "-"}}</td>
            </tr>
            
        @endforeach
            <tr>
            <td style="border:none;"></td>
            <td style="border:none;"></td>
            <td style="border:none;"></td>
            <td style="border:none;"></td>
            <td>$ {{number_format($total,2)}}</td>
            <td>$ {{number_format($amount_paid,2) }}</td>
            <td>$ {{number_format($balance,2) }}</td>
        </tr>

    </table>
</div>