Petakan nama barang dari CSV ke data Produk & Supplier di database untuk laporan RAT yang akurat.
{{ number_format($totalCsvProducts) }} Barang
{{ number_format($mappedCount) }} Barang
{{ number_format($unmappedCount) }} Barang
{{ $csvFile->getClientOriginalName() }}
File Ter-import Saat Ini
Ukuran: {{ number_format($fileStats['size'] / 1024, 2) }} KB | Diperbarui: {{ date('d M Y H:i:s', $fileStats['updated_at']) }}
| Nama Barang di CSV (Raw) | Produk Database (Real) | Supplier & SKU | Aksi |
|---|---|---|---|
|
{{ $item['raw_name'] }}
@if(!empty($item['prices']['beli']))
Beli: Rp {{ implode(', Rp ', array_map(fn($p) => number_format($p, 0, ',', '.'), $item['prices']['beli'])) }}
@endif
@if(!empty($item['prices']['jual']))
Jual: Rp {{ implode(', Rp ', array_map(fn($p) => number_format($p, 0, ',', '.'), $item['prices']['jual'])) }}
@endif
|
@if($item['mapping'] && $item['mapping']->product)
{{ $item['mapping']->product->name }}
@else
{{-- Product Search Autocomplete selector --}}
|
@if($item['mapping'] && $item['mapping']->product)
{{ $item['category_name'] }}
{{ $item['supplier_name'] }} SKU: {{ $item['mapping']->product->sku ?? '-' }} @else Belum terhubung @endif |
@if($item['mapping'] && $item['mapping']->product) @else Menunggu input @endif |
Pastikan CSV sudah di-upload dan filter pencarian tidak salah.
| Tanggal | Nama CSV | Produk Database | Supplier | Qty | Harga Beli | Total Beli | Harga Jual | Total Jual | Keuntungan |
|---|---|---|---|---|---|---|---|---|---|
| {{ $row['tanggal'] }} | {{ $row['raw_name'] }} | @if($row['product']) {{ $row['product']->name }} @else ⚠️ Belum Dipetakan @endif | @if($row['product']) {{ $row['product']->supplier?->businessName ?? 'TOKO (Koperasi)' }} @else - @endif | {{ number_format($row['quantity']) }} {{ $row['satuan'] }} | Rp {{ number_format($row['harga_beli_satuan']) }} | Rp {{ number_format($row['total_harga_beli']) }} | Rp {{ number_format($row['harga_jual_satuan']) }} | Rp {{ number_format($row['total_harga_jual']) }} | Rp {{ number_format($row['total_keuntungan']) }} |
Pastikan CSV sudah di-upload dengan benar.