Data Pembayaran

@php $i = 1; @endphp @php use App\Models\DataGadai; use App\Models\Payment; @endphp @foreach ($payments as $payment) @php $dataGadai = DataGadai::with(['customer' => function ($query) { $query->select('customer_id', 'nama_customer','nomor_member'); }])->where('nomor_transaksi', $payment->nomor_transaksi )->first(); $formating = substr_replace($dataGadai->customer->nomor_member, '-', 4, 0); $nomor_member = substr_replace($formating, '-',9,0); setlocale(LC_ALL, 'id_ID') @endphp @endforeach

No	Customer	Nomor Member	Tanggal Bayar	Nomor Transaksi	Nominal	Nota Hilang	Tipe pembayaran	Metode pembayaran
{{ $i++ }}	{{$dataGadai->customer->nama_customer}}	{{$nomor_member}}	{{ \Carbon\Carbon::parse($payment->tgl_bayar)->format('d-m-Y')}}	{{ $payment->nomor_transaksi }}	{{ 'Rp. '. number_format($payment->nominal, 0, ',', '.')}}	{{ 'Rp. '. number_format($payment->nota_hilang, 0, ',', '.') }}	{{ $payment->tipe_pembayaran }}	{{ $payment->metode_pembayaran }}