<table>
    <thead>
        <tr>
            <th>No.</th>
            <th>Tanggal</th>
            <th>No. Resi Eva</th>
            <th>No. Resi Coload</th>
            <th>Destination</th>
            <th>Alamat Gudang</th>
            <th>Marking</th>
            <th>Nama Barang</th>
            <th>Kategori Barang</th>
            <th>Harga Per User</th>
            <th>Jumlah Karton</th>
            <th>Total Berat</th>
            <th>Total Cbm</th>
            <th>No. Resi Lokal</th>
            <th>Storage Number</th>
            <th>WH Number</th>
            <th>Brand</th>
            <th>Qty Barang</th>
            <th>Value Barang</th>
            <th>Status Resi</th>
            <th>Tipe Ekspedisi</th>
            <th>Link Foto</th>
        </tr>
    </thead>
    <tbody>
    @if(!$receipts->isEmpty())
        @php
        $no=1;
        @endphp

        @foreach ($receipts as $receipt)
            <tr>
                <td>{{ $no }}</td>
                <td>{{$receipt->created_at}}</td>
                <td>{{ $receipt->no_resi }}</td>
                <td>{{ $receipt->no_resi_coload }}</td>
                <td>{{ $receipt->shipping_to }}</td>
                <td>{{ $receipt->alamat_gudang }}</td>
                <td>{{$receipt->shipping_mark}}</td>
                <td>
                    {{-- @if ($receipt->receipt_detail->count() > 0)
                        @foreach ($receipt->receipt_detail as $rdetail)
                            @if (!$loop->first)
                                //
                            @endif
                            @if ($rdetail->detail_barang->count() > 0)
                                @foreach ($rdetail->detail_barang as $barang)
                                    {{$barang->deskripsi}}
                                @endforeach
                            @else
                            -
                            @endif
                        @endforeach
                    @else
                    -
                    @endif --}}
                    {{ $receipt->deskbarangs }}
                </td>
                <td>
                    @if ($receipt->receipt_detail->count() > 0)
                        @foreach ($receipt->receipt_detail as $rdetail)
                            @if (!$loop->first)
                                , 
                            @endif
                            @if ($rdetail->detail_barang->count() > 0)
                                @foreach ($rdetail->detail_barang as $barang)
                                    {{$barang->ekspedisi?@$barang->ekspedisi->tipe_barang:'-'}}
                                @endforeach
                            @else
                            -
                            @endif
                        @endforeach
                    @else
                    -
                    @endif
                </td>
                <td>
                    @if ($receipt->receipt_detail->count() > 0)
                        @foreach ($receipt->receipt_detail as $rdetail)
                            @if ($rdetail->detail_barang->count() > 0)
                            @foreach ($rdetail->detail_barang as $barang)
                                @if (!$loop->first)
                                    ; 
                                @endif
                                    @php
                                        $hargas = '';
                                        $hargamasters = cekhargauserwhcina(@$receipt->customer_id, $barang->tipe_ekspedisi);
                                    @endphp
                                    @if (count($hargamasters) > 0)
                                        @foreach ($hargamasters as $key => $harga_user)
                                        @php
                                            if ($key != 0) {
                                                $hargas .=', ' ;
                                            }
                                                $hargas .= @$harga_user->ekspedisi->tipe_barang.' (Range '.@$harga_user->ekspedisidetail->start_cbm.'-'.@$harga_user->ekspedisidetail->end_cbm.' Cbm)'." - Rp.".ribuan($harga_user->harga);
                                            @endphp
                                        @endforeach
                                    @endif

                                    {{$hargas}}
                                @endforeach
                            @else
                            -
                            @endif
                        @endforeach
                    @else
                    -
                    @endif
                    
                </td>
                <td>{{$receipt->carton_count}}</td>
                {{-- <td>{{$receipt->getcartonstat(2)->sum('carton_numbers.berat')}}</td> --}}
                {{-- <td>{{number_format($receipt->getcartonstat(2)->sum('carton_numbers.volume'), 3, '.', '')}}</td> --}}
                @php
                    $totalberat = 0;
                    $totalvolume = 0;
                @endphp
                @foreach ($receipt->receipt_detail as $detail)
                    @php        
                        $totalberat += $detail->total_berat;
                        $totalvolume += $detail->total_volume;
                    @endphp
                @endforeach    
                <td>{{$totalberat}}</td>
                <td>{{$totalvolume}}</td>
                <td>{{$receipt->no_local_cina}}</td>
                <td>{{$receipt->storage_number}}</td>
                <td>{{$receipt->wh_number?$receipt->wh_number:'-'}}</td>
                <td>{{$receipt->brand}}</td>
                @php
                    $grandtotal_jml = $grandtotal_usd = $grandtotal_rmb = 0;
                    foreach($receipt->receipt_detail as $detail){

                        foreach($detail->detail_barang as $detbar){ 

                            $grandtotal_jml += $detbar->jumlah;
                            if($detbar->currency_code == 'USD'){
                                $grandtotal_usd +=  $detbar->harga;
                            } else {
                                $grandtotal_rmb +=  $detbar->harga;
                            }

                        }
                    }
                @endphp
                <td>{{$grandtotal_jml}}</td>
                <td>{{$grandtotal_usd.' USD, '}}<br>{{$grandtotal_rmb.' RMB'}}</td>
                <td>{{ config('custom.status_resi.'.$receipt->status) }}</td>
                <td>
                    {{-- @if ($receipt->receipt_detail)
                        @if ($receipt->receipt_detail->first()->detail_barang)
                            {{@$receipt->receipt_detail->first()->detail_barang->first()->ekspedisi->tipe_ekspedisi}}    
                        @endif
                    @endif --}}
                    {{$receipt->tipebarangs}}
                </td>
                <td>
                    {{-- @if ($receipt->file == null)
                        -
                    @else
                        {{url('').'/'.$receipt->file}}
                    @endif --}}
                    @foreach ($receipt->receiptmainfiles as $file)
                        @if (!$loop->first)
                            , 
                        @endif
                        {{asset($file->file)}}
                    @endforeach
                </td>
            </tr>

            @php
            $no++;
            @endphp
        @endforeach
    @endif
    </tbody>
</table>