<table class="table datatable-basic table-hover">
    <thead>
        <tr>
            <th>No</th>
            <th>No Container</th>
            <th>Coload</th>
            <th>Delivery by Coload</th>
            <th>Sales Marketing</th>
            <th>Tgl Masuk Gudang China</th>
            <th>Marking</th>
            <th>Resi Coload</th>
            <th>Resi Evatrack</th>
            <th>Cbm Evatrack</th>
            <th>Qty</th>
            <th>Berat Barang</th>
            <th>Deskripsi</th>
            <th>Kategori</th>
            <th>Invoice Date</th>
            <th>No. Invoice</th>
            <th>Cbm</th>
            <th>Unit Price</th>
            <th>Total</th>
            <th>Biaya COD</th>
            <th>Charge berat</th>
            <th>Tax Refund Document</th>
            <th>Tax Refund Biaya Kirim</th>
            <th>Insurance</th>
            <th>RDN</th>
            <th>Biaya Other</th>
            <th>Total Invoice Evatrack</th>
            <th>Total Bayar</th>
            <th>Tanggal Lunas</th>
        </tr>
    </thead>
    <tbody>
        @if(!$filteredInvoices->isEmpty())
            @php
                ($i = 1)
            @endphp
            @foreach($filteredInvoices as $invoice)
                @php
                    $tgl_msk = [];
                    $marking = [];
                    $resi_coload = [];
                    $resi_evatrack = [];
                    $cbm_evatrack = [];
                    $qty = [];
                    $deliverycoload = null;
                    $berat_barang = [];
                    $deskripsi = [];
                    $kategori = [];
                    $cbm = [];
                    $harga = [];
                    $total = [];
                    $cod_china = [];
                    $charge_berat = [];
                    $refund_dokumen = [];
                    $refund_biaya_kirim = [];
                    $tgl_msk = [];
                    $deskripsi = [];
                    foreach ($invoice->invoice_detail as $detail) {
                        if ($detail->receipt_detail) {
                            if ($detail->receipt_detail->receipt) {
                                $tgl_msk[] = $detail->no_resi . ' - ' . date('d/m/Y', strtotime(@$detail->receipt_detail->receipt->created_at));
                                $deskripsi[] = $detail->receipt_detail->detail_barang->first()->deskripsi;
                                if ($detail->receipt_detail->receipt->deliverbycoload) {
                                    $deliverycoload = @$detail->receipt_detail->receipt->delivcoloadtype == 1?'Air':'Sea';
                                }
                            } else {
                                $tgl_msk[] = $detail->no_resi . ' - ' ;
                                $deskripsi[] = ' - ';
                            }
                        } else {
                            $tgl_msk[] = $detail->no_resi . ' - ' ;
                            $deskripsi[] = ' - ';
                        }
                        $marking[] = $detail->receipt_detail->receipt->shipping_mark ?? '-';
                        $resi_coload[] = $detail->receipt_detail->receipt->no_resi_coload ?? '-';
                        $resi_evatrack[] = $detail->no_resi ?? '-';
                        $cbm_evatrack[] = $detail->receipt_detail->total_volume ?? 0;
                        $qty[] = $detail->jml_ctn;
                        $berat_barang[] = $detail->berat;
                        $kategori[] = $detail->tipe_barang;
                        $cbm[] = number_format($detail->volume, 2, ',', '.');
                        $harga[] = "Rp. " . ribuan($detail->harga);
                        $total[] = "Rp. " . ribuan($detail->total);
                        $cod_china[] = "Rp. " . ribuan($detail->biaya_cod_cina ?? 0);
                        $charge_berat[] = $detail->charge_berat_laut ?? 0;
                        $refund_dokumen[] = "Rp. " . ribuan($detail->tax_refund_biaya_cbm ?? 0);
                        $refund_biaya_kirim[] = "Rp. " . ribuan($detail->tax_refund_kirim ?? 0);
                    }
                    $tgl_msk = implode(", ", $tgl_msk);
                    $marking = implode(", ", $marking);
                    $resi_coload = implode(", ", $resi_coload);
                    $resi_evatrack = implode(", ", $resi_evatrack);
                    $cbm_evatrack = array_sum($cbm_evatrack);
                    $qty = implode(", ", $qty);
                    $berat_barang = implode(", ", $berat_barang);
                    $deskripsi = implode(", ", $deskripsi);
                    $kategori = implode(", ", $kategori);
                    $cbm = implode(" , ", $cbm);
                    $harga = implode(", ", $harga);
                    $total = implode(", ", $total);
                    $cod_china = implode(", ", $cod_china);
                    $charge_berat = implode(", ", $charge_berat);
                    $refund_dokumen = implode(", ", $refund_dokumen);
                    $refund_biaya_kirim = implode(", ", $refund_biaya_kirim);
                @endphp
                <tr>
                    <td>{{ $i }}</td>
                    <td>{{ @$invoice->no_container }}</td>
                    <td>{{ @$invoice->customer->coload->nama }}</td>
                    <td>{{ $deliverycoload }}</td>
                    <td>{{ @$invoice->customer->sales->nama }}</td>
                    <td>{{ $tgl_msk }}</td>
                    <td>{{ $marking }}</td>
                    <td>{{ $resi_coload }}</td>
                    <td>{{ $resi_evatrack }}</td>
                    <td>{{ number_format($cbm_evatrack, 3, ',', '.') }}</td>
                    <td>{{ $qty }}</td>
                    <td>{{ $berat_barang }}</td>
                    <td>{{ $deskripsi }}</td>
                    <td>{{ $kategori }}</td>
                    <td>{{ date('d/m/Y H:i', strtotime($invoice->created_at)) }}</td>
                    <td>{{ $invoice->no_invoice }}</td>
                    <td>{{ $cbm }}</td>
                    <td>{{ $harga }}</td>
                    <td>{{ $total }}</td>
                    <td>{{ $cod_china }}</td>
                    <td>{{ $charge_berat }}</td>
                    <td>{{ $refund_dokumen }}</td>
                    <td>{{ $refund_biaya_kirim }}</td>
                    <td>Rp. {{ribuan($invoice->harga_asuransi)}}</td>
                    <td>Rp. {{ribuan($invoice->rdn)}}</td>
                    <td>Rp. {{ribuan($invoice->biaya_other)}}</td>
                    <td>Rp. {{ribuan($invoice->total_tagihan)}}</td>
                    <td>Rp. {{ribuan($invoice->total_bayar)}}</td>
                    <td>{{ date('d/m/Y', strtotime($invoice->tgl_lunas)) }}</td>
                </tr>
                @php
                    ($i++)
                @endphp
            @endforeach
        @endif
    </tbody>
</table>