@foreach ($transactions as $transaction) @foreach ($transaction->detail as $key => $transaction_detail) @php $ktp = ''; if($transaction->customer->tanda_pengenal) { $tp = json_decode($transaction->customer->tanda_pengenal); $ktp = (string) $tp->nomor; } @endphp @if ($key == 0) @else @endif @endforeach @endforeach

Invoice	Cust. Code.	Customer Name	KTP	Customer Email	Customer Phone	Customer Address	Invoice Date	Resell Tier	Created By	Create Timestamp	QC Timestamp	Disburse by	Disburse Timestamp	Status	HUB	Store Code	Store	Item Location	Certificate	PLU	Type	Item	Item Type	Carat	Weight	Estimation Weight 24K	Price Per Gram	Price Item	Payment Method	Bank	Nominal	Tanggal Pencairan	Berat QC	Tanggal QC	User QC	Note QC	Actual Carat	Comment QC	No DO	NEW PLU	Tanggal pengiriman DO	Year	Physique Year
{{ $transaction->invoice }}	{{ $transaction->customer->id }}	{{ $transaction->customer_name }}	'{{ $ktp }}	{{ $transaction->customer_email }}	'{{ $transaction->customer_handphone }}	{{ $transaction->customer ? trim(preg_replace('/\s+/', ' ', $transaction->customer->address)) : '-' }}	{{ date('Y-m-d', strtotime($transaction->invoice_date)) . '-' }}	-	{{ $transaction->createdByAE ? $transaction->createdByAE->name . ' (' . $transaction->createdByAE->username . ')' : '-' }}	{{ $transaction->created_ae_at }}	{{ $transaction->approved_qa_at }}	{{ $transaction->approvedDisbursedBy ? $transaction->approvedDisbursedBy->name . ' (' . $transaction->approvedDisbursedBy->username . ')' : '-' }}	{{ $transaction->approved_at }}	{{ \App\Models\Butik\Butik_store_resell_invoice_model::STATUS[$transaction->status]['text'] }}	{{ App\Models\Store_hub_member_model::where('store_id', $transaction->store_id)->first() ? App\Models\Store_hub_member_model::where('store_id', $transaction->store_id)->first()->store_hub->name : '-' }}	{{ $transaction->store->cmk_code ? : $transaction->store->code }}	{{ ucwords(strtolower($transaction->store->brand->name) . ' ' . $transaction->store->name) }}	@if ($transaction->store_resellbox_id) Stock Resell Toko @else @if ($transaction->resellbox_unload()->whereNotNull('received_at')->whereNotNull('received_by')->first()) Diterima di SK @else Dalam Perjalanan @endif @endif	{{ $transaction_detail->plu }}	{{ $transaction_detail->plu_code }}	{{ $transaction_detail->item_brand->brand_name }}	{{ $transaction_detail->item_type->type }}	@if ($transaction_detail->item_brand->brand_name == 'LM Antam Certieye') ANTM - Certieye ({{ $transaction_detail->weight + 0 }} GR) @elseif($transaction_detail->item_brand->brand_name == 'LM Antam Retro') LM - Antam Retro ({{ $transaction_detail->weight + 0 }} GR) @elseif($transaction_detail->item_brand->brand_name == 'LM UBS') LM - UBS ({{ $transaction_detail->weight + 0 }} GR) @elseif($transaction_detail->item_brand->brand_name == 'LM Lotus Archi') LM - Lotus Archi ({{ $transaction_detail->weight + 0 }} GR) @elseif($transaction_detail->item_brand->brand_name == 'LM Other') Others - LM ({{ $transaction_detail->weight + 0 }} GR) @elseif($transaction_detail->item_brand->brand_name == 'Jewelry Plain Gold CMK') {{ $transaction_detail->item_type->type }} @endif	{{ $transaction_detail->item_carat->carat }}	{{ $transaction_detail->weight }}	{{ ($transaction_detail->item_carat->carat / 24) * $transaction_detail->weight }}	{{ $transaction_detail->price / $transaction_detail->weight }}	{{ $transaction_detail->price }}	{{ $transaction->payment_method }}	{{ $transaction->customer_bank }}	@if (in_array($transaction->customer_bank, [ 'Bank Central Asia', 'Bank Danamon', 'Bank Mandiri', 'Bank BRI', 'Bank BNI', 'Bank CIMB', 'Bank Permata' ])) 3000 @elseif(in_array($transaction->customer_bank, [ 'BSI', 'Bank Maybank', 'Bank OCBC', 'Bank BLU BCA Digital', 'BCA Syariah', 'Bank BJB', 'PT. BANK SEABANK INDONESIA', 'Bank Panin', 'Bank BTN', 'Bank BTPN', 'Bank DKI', 'Bank Muamalat', 'Bank Mega', 'Bank Mega Syariah', 'PT. BANK DBS INDONESIA', 'PT. BANK KEB HANA INDONESIA', 'PT. BANK SINARMAS', 'Allo Bank', 'Bank JAGO', 'BPD JATIM' ])) 4500 @else 0 @endif		@if ($transaction->iris_log) @if ($transaction->iris_log()->where('type', 'release')->first()) {{ $transaction->iris_log()->where('type', 'release')->first()->created_at }} @endif @endif	{{ $transaction_detail->actual_weight }}	{{ $transaction_detail->qc_at }}	@if ($transaction_detail->qc_by) {{ $transaction_detail->qc_by->name }} @else @endif	{{ $transaction_detail->refinery_item_type }}	@if ($transaction_detail->actual_item_carat) {{ $transaction_detail->actual_item_carat->carat_text }} @else @endif	{{ $transaction_detail->unload_comment ? json_encode($transaction_detail->unload_comment) : '' }}	@if ($transaction->resellbox_unload) {{ $transaction->resellbox_unload->delivery_code }} @endif	@if ($transaction->plu_news_data()->where('plu',$transaction_detail->plu)->first()) {{ ($transaction->plu_news_data()->where('plu',$transaction_detail->plu)->first()->plu_new)}} @else @endif	@if ($transaction->resellbox_unload) {{ $transaction->resellbox_unload->created_at }} @endif	{{ $transaction_detail->year ?? '' }}	{{ $transaction_detail->tahun_fisik ?? '' }}