@extends('layouts/acc_layout') @section('title', '| Loan Register') @section('content')

PAYMENT LIST

@foreach($payments as $index => $payment) @php $account = DB::table('acc_loan_register_account')->where('id',$payment->accId_fk)->first(); $loanProduct = DB::table('gnr_loan_product')->where('id',$account->loanProductId_fk)->value('name'); $bankName = DB::table('gnr_bank')->where('id',$account->bankId_fk)->value('name'); @endphp @if($account->phase>0 && $account->cycle>0) @else @endif @endforeach
SL# Date Loan Product Principal Amount (Tk) Interest Amount (Tk) Installment No Bank/Donor Account No Phase Cycle Action
{{$index+1}} {{date('d-m-Y',strtotime($payment->paymentDate))}} {{$loanProduct}} {{number_format($payment->principalAmount,2,'.',',')}} {{number_format($payment->interestAmount,2,'.',',')}} {{$payment->installmentNo}} {{$bankName}} {{$account->accNo}}{{$account->phase}} {{$account->cycle}}   @php $lastPayment = DB::table('acc_loan_register_payments')->where('accId_fk',$account->id)->max('paymentNo'); @endphp  
{{-- View Modal --}} {{-- End View Modal --}} {{-- Edit Modal --}} {{-- End Edit Modal --}} {{-- Delete Modal --}} {{-- End Delete Modal --}} @include('dataTableScript') @endsection