@php $shownShippingCost = []; $processedTransactions = []; @endphp @foreach ($results as $index => $data) @php $ktp = ''; if ($data->tanda_pengenal) { $tp = json_decode($data->tanda_pengenal); $ktp = (string) $tp->nomor; } $isFirstItem = !in_array($data->code, $shownShippingCost); if ($isFirstItem) { $shownShippingCost[] = $data->code; } // Biaya kirim hanya untuk item pertama & kirim ke alamat if ($data->tipe_pengiriman == 'kirim ke alamat' && $isFirstItem) { $biayaKirim = $data->biaya_pengiriman ?? 0; } else { $biayaKirim = 0; } // Hitung asuransi hanya untuk kirim ke alamat if ($data->tipe_pengiriman == 'kirim ke alamat') { $isFirstAsuransi = !in_array($data->code, $processedTransactions); if ($isFirstAsuransi) { $processedTransactions[] = $data->code; $asuransi = ($data->harga_rupiah * 0.002) + 5000; } else { $asuransi = $data->harga_rupiah * 0.002; } } else { $asuransi = 0; } $totalTransaksi = (int) round($data->harga_rupiah + $biayaKirim + $data->asuransi); @endphp @endforeach

Kode Transaksi	Tanggal Transaksi	Jenis Pengiriman	Tanggal Kirim	Tanggal diterima Toko	Tanggal Pengambilan	Nama	Handphone	KTP	NPWP	Alamat Kirim	Brand	Pecahan	Qty	Total Harga LM	Harga Jual	Harga Beli	Emas Digital	Payment Digital Gold	Payment Wallet	Transfer Payment	Label	Biaya Layanan	Biaya Kirim	Asuransi	Total Transaksi	Total Nilai Akhir	Status	Tanggal Kirim	Nomor Sertifikat	Nomor Pengiriman
{{ $data->code }}	{{ date('d-m-Y', strtotime($data->transaction_date)) }}	{{ $data->tipe_pengiriman }}	{{ $data->shipping_date }}	@if ($data->arrived_store_date == null) {{ $data->diterima_toko }} @else {{ $data->arrived_store_date }} @endif	@if ($data->tipe_pengiriman == 'kirim ke alamat' && $data->status == 'completed') {{$data->updated_at}} @else {{ $data->tanggal_terima_cust }} @endif	{{ $data->customer }}	'{{ $data->handphone }}	'{{ $ktp }}	'{{ $data->npwp }}	{{ $data->alamat_pengiriman }}	{{ $data->brand }}	{{ $data->pecahan }}	{{ $data->qty }}	{{ $data->harga_rupiah }}	{{ $data->harga_jual }}	{{ $data->harga_beli }}	{{ $data->payment_gold_balance }}	{{ $data->payment_gold_conversion }}	{{ $data->payment_wallet_nominal }}	@if (empty($data->payment_gold_balance) && empty($data->payment_wallet_nominal)) {{ $data->transfer_payment + $data->biaya_pengiriman + $data->asuransi }} @else {{ $data->transfer_payment }} @endif	{{ $data->label }}	{{ $data->biaya_layanan }}	@if ($data->tipe_pengiriman == 'kirim ke alamat' && $isFirstItem) {{ $data->biaya_pengiriman }} @else 0 @endif	@if ($data->tipe_pengiriman == 'kirim ke alamat' && $isFirstItem) {{ $data->asuransi }} @else 0 @endif	{{ $totalTransaksi }}	{{ $data->total_transfer_payment }}	{{ $data->status }}	{{ date('d-m-Y', strtotime($data->shipping_date)) }}	{{ $data->certificate }}	@if ($data->tipe_pengiriman == 'kirim ke alamat') {{$data->no_resi}} @else {{$data->code}} @endif