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

FDR ENCASHMENT LIST

@foreach($accountClose as $index => $accClose) @php $account = DB::table('acc_fdr_account')->where('id',$accClose->accId_fk)->first(); $netInterest = DB::table('acc_fdr_interest')->where('fdrAccId_fk',$account->id)->sum('netInterestAmount'); $bankName = DB::table('gnr_bank')->where('id',$account->bankId_fk)->value('name'); $bankBranchName = DB::table('gnr_bank_branch')->where('id',$account->bankBranchId_fk)->value('name'); @endphp @endforeach
SL# Date Account No Account Name Bank Bank Branch Location Principal Amount (TK) Net Interest Amount (TK) Total Amount (TK) Action
{{$index+1}} {{date('d-m-Y',strtotime($accClose->closingDate))}} {{$account->accNo}} {{$account->accName}} {{$bankName}} {{$bankBranchName}} {{number_format($account->principalAmount,2,'.',',')}} {{number_format($netInterest,2,'.',',')}} {{number_format($account->principalAmount + $netInterest,2,'.',',')}}    
{{-- View Modal --}} {{-- End View Modal --}} {{-- Edit Modal --}} {{-- End Edit Modal --}} {{-- Delete Modal --}} {{-- End Delete Modal --}} @include('dataTableScript') @endsection