Import Data Angsuran

Import data tagihan dan angsuran dari BMT Itqan (CSV).

Format wajib: NAMA_DEBITUR, PLAFOND_RP, TOTAL, TENOR, ANGSURAN_KE, TANGGAL_CAIR, NO_REKENING

@if (session()->has('message'))

Berhasil!

@endif @if (session()->has('error'))

Gagal Import!

@endif

@if($file)

File siap diproses

@else

Klik atau seret file CSV ke sini

Format: CSV (Comma delimited)

@endif

Membaca file...

Tips Import:

Pastikan header CSV sesuai format wajib dan tidak ada kolom penting yang kosong.

@if(count($previewData) > 0)

Total Baris

Match Member

@else

Upload file untuk melihat preview

@endif

@if(count($previewData) > 0)

@foreach($previewData as $row)

Tgl Cair: {{ $row['raw']['TANGGAL_CAIR'] }}

@if($row['status'] == 'MATCH') MATCH @else NOT FOUND @endif

Member: {{ $row['member']->name ?? 'Tidak ditemukan' }}

Plafond: {{ number_format((float) $row['raw']['PLAFOND_RP'], 0, ',', '.') }}

Total Angsuran: {{ number_format((float) $row['raw']['TOTAL'], 0, ',', '.') }}

Angsuran ke-{{ $row['raw']['ANGSURAN_KE'] }} dari {{ $row['raw']['TENOR'] }}

@endforeach

Detail Data

@foreach($previewData as $row) @endforeach

Nama (CSV)	Member Match?	Plafond	Total Angsuran	Ke	Tenor	Tgl Cair
{{ $row['raw']['NAMA_DEBITUR'] }}	@if($row['status'] == 'MATCH') {{ $row['member']->name }} @else Not Found @endif	{{ number_format((float) $row['raw']['PLAFOND_RP'], 0, ',', '.') }}	{{ number_format((float) $row['raw']['TOTAL'], 0, ',', '.') }}	{{ $row['raw']['ANGSURAN_KE'] }}	{{ $row['raw']['TENOR'] }}	{{ $row['raw']['TANGGAL_CAIR'] }}

@endif