| {{ $damageData['loanDetailsTCN']['loanId'] }} |
{{ $damageData['regularLoanDetail']['loanCode'] }} |
{{ $damageData['loanDetailsTCN']['product'] }} |
{{ $damageData['regularLoanDetail']['productIdFk'] }} |
| {{ $damageData['loanDetailsTCN']['memberName'] }} |
{{ $damageData['regularLoanDetail']['memberInfoOB']->name . ' ' .'(' . $damageData['regularLoanDetail']['memberInfoOB']->code .')' }} |
{{ $damageData['loanDetailsTCN']['loanCycle'] }} |
{{ $damageData['regularLoanDetail']['loanCycle'] }} |
| {{ $damageData['loanDetailsTCN']['fatherSpouseName'] }} |
{{ $damageData['regularLoanDetail']['memberInfoOB']->spouseFatherSonName }} |
{{ $damageData['loanDetailsTCN']['paymentMode'] }} |
{{ $damageData['regularLoanDetail']['paymentTypeIdFk'] }} |
| {{ $damageData['loanDetailsTCN']['age'] }} |
{{ $damageData['regularLoanDetail']['memberInfoOB']->age . ' ' . 'Years' }} |
{{ $damageData['loanDetailsTCN']['mobileNo'] }} |
{{ $damageData['regularLoanDetail']['memberInfoOB']->mobileNo }} |
| {{ $damageData['loanDetailsTCN']['samity'] }} |
{!! $damageData['regularLoanDetail']['samityName'] . ' ' .'(' . $damageData['regularLoanDetail']['samityCode'] . ')' . ' ' . $damageData['regularLoanDetail']['samityDay'] !!} |
{{ $damageData['loanDetailsTCN']['transferDate'] }} |
|
| {{ $damageData['loanDetailsTCN']['disbursementDate'] }} |
{{ $damageData['MicroFinance']->getMicroFinanceDateFormat($damageData['regularLoanDetail']['disbursementDate']) }} |
{{ $damageData['loanDetailsTCN']['dueAmount'] }} |
{{--{{ $damageData['openingBalanceDetails']->dueAmountOB }}--}} |
| {{ $damageData['loanDetailsTCN']['firstRepayDate'] }} |
{{ $damageData['MicroFinance']->getMicroFinanceDateFormat($damageData['regularLoanDetail']['firstRepayDate']) }} |
{{ $damageData['loanDetailsTCN']['advanceAmount'] }} |
- |
| {{ $damageData['loanDetailsTCN']['interestRate'] }} |
{{ sprintf("%.2f", $damageData['regularLoanDetail']['interestRate']) . ' ' . '%' . ' ' . $damageData['regularLoanDetail']['interestRateIndex'] . ' ' . '(' . $damageData['regularLoanDetail']['interestCalculationMethod'] . ')' }} |
{{ $damageData['loanDetailsTCN']['recoveryAmount'] }} |
- |
| {{ $damageData['loanDetailsTCN']['extraInstallmentAmount'] }} |
{{ $damageData['regularLoanDetail']['extraInstallmentAmount'] }} |
{{ $damageData['loanDetailsTCN']['openingLoanOutstanding'] }} |
{{--{{ sprintf("%.2f", $damageData['regularLoanDetail']['totalRepayAmount'] - $damageData['openingBalanceDetails']->paidLoanAmountOB) }}--}} |
| {{ $damageData['loanDetailsTCN']['currentStatus'] }} |
{{ $damageData['regularLoanDetail']['isLoanCompleted']==0?'Active':'Closed' }} |
{{ $damageData['loanDetailsTCN']['rebate'] }} |
- |
| {{ $damageData['loanDetailsTCN']['repaymentFrequency'] }} |
{{ $damageData['regularLoanDetail']['repaymentFrequencyIdFk'] }} |
{{ $damageData['loanDetailsTCN']['loanOutstanding'] }} |
@php
if ($damageData['regularLoanDetail']['totalCollectionAmount'] <= $damageData['regularLoanDetail']['totalRepayAmount']) {
$totalOutstanding = $damageData['regularLoanDetail']['totalRepayAmount'] - $damageData['regularLoanDetail']['totalCollectionAmount'];
$totalOutstanding += DB::table('mfn_loan_waivers')
->where('loanIdFk', $damageData['regularLoanId'])
->sum('principalAmount');
$totalOutstanding += DB::table('mfn_loan_rebates')
->where('loanIdFk', $damageData['regularLoanId'])
->sum('amount');
$totalOutstanding += DB::table('mfn_loan_write_off')
->where('softDel', '=', 0)
->where('loanIdFk', $damageData['regularLoanId'])
->sum('amount');
}
@endphp
{{ sprintf("%.2f", $totalOutstanding) }} |
| {{ $damageData['loanDetailsTCN']['interestMode'] }} |
{{ $damageData['regularLoanDetail']['interestMode'] }} |
{{ $damageData['loanDetailsTCN']['loanPurpose'] }} |
{{ $damageData['regularLoanDetail']['loanPurpose'] }} |
| {{ $damageData['loanDetailsTCN']['loanAmount'] }} |
{{ sprintf("%.2f", $damageData['regularLoanDetail']['loanAmount']) }} |
{{ $damageData['loanDetailsTCN']['loanSubPurpose'] }} |
{{ $damageData['regularLoanDetail']['loanSubPurposeIdFk'] }} |
| {{ $damageData['loanDetailsTCN']['interestAmount'] }} |
{{ sprintf("%.2f", $damageData['regularLoanDetail']['interestAmount']) }} |
{{ $damageData['loanDetailsTCN']['guarantorNameFirst'] }} |
{{ $damageData['regularLoanDetail']['firstGuarantorName'] }} |
| {{ $damageData['loanDetailsTCN']['totalRepayAmount'] }} |
{{ sprintf("%.2f", $damageData['regularLoanDetail']['totalRepayAmount']) }} |
{{ $damageData['loanDetailsTCN']['guarantorRelationshipFirst'] }} |
{{ $damageData['regularLoanDetail']['firstGuarantorRelation'] }} |
| {{ $damageData['loanDetailsTCN']['installmentNum'] }} |
{{ $damageData['regularLoanDetail']['repaymentNo'] }} |
{{ $damageData['loanDetailsTCN']['guarantorAddressFirst'] }} |
{{ $damageData['regularLoanDetail']['firstGuarantorAddress'] }} |
| {{ $damageData['loanDetailsTCN']['loanPeriodInMonth'] }} |
{{ $damageData['regularLoanDetail']['loanRepayPeriodIdFk'] }} |
{{ $damageData['loanDetailsTCN']['guarantorNameSecond'] }} |
{{ $damageData['regularLoanDetail']['secondGuarantorName'] }} |
| {{ $damageData['loanDetailsTCN']['loanApplicationNo'] }} |
{{ $damageData['regularLoanDetail']['loanApplicationNo'] }} |
{{ $damageData['loanDetailsTCN']['guarantorRelationshipSecond'] }} |
{{ $damageData['regularLoanDetail']['secondGuarantorRelation'] }} |
@php
// dd($damageData['regularLoanDetail']);
@endphp
| {{ $damageData['loanDetailsTCN']['insuranceGuarantorAmount'] }} |
{{ $damageData['regularLoanDetail']['insuranceAmount'] }} |
{{ $damageData['loanDetailsTCN']['guarantorAddressSecond'] }} |
{{ $damageData['regularLoanDetail']['secondGuarantorAddress'] }} |
| {{ $damageData['loanDetailsTCN']['loanClosingDate'] }} |
- |
{{ $damageData['loanDetailsTCN']['transferOutDate'] }} |
- |
| {{ $damageData['loanDetailsTCN']['installmentAmount'] }} |
{!! sprintf("%.2f", $damageData['regularLoanDetail']['installmentAmount']) . ' Taka' . ' ' . sprintf("%.2f", $damageData['regularLoanDetail']['actualInstallmentAmount']) . ' (actual)' . ' + ' . sprintf("%.2f", $damageData['regularLoanDetail']['extraInstallmentAmount']) . ' (extra)' . ' * ' . ($damageData['regularLoanDetail']['repaymentNo']-1) . ' (no. of installment)' . ' ' . ' + ' . sprintf("%.2f", ($damageData['regularLoanDetail']['totalRepayAmount'] - (sprintf("%.2f", $damageData['regularLoanDetail']['installmentAmount']) * ($damageData['regularLoanDetail']['repaymentNo']-1)))) . ' (last installment amount)' !!} |
{{ $damageData['loanDetailsTCN']['folioNumber'] }} |
{{ $damageData['regularLoanDetail']['folioNum'] }} |
| {{ $damageData['loanDetailsTCN']['additionalFee'] }} |
{{ sprintf("%.2f", $damageData['regularLoanDetail']['additionalFee']) }} |
{{ $damageData['loanDetailsTCN']['loanFormFee'] }} |
{{ sprintf("%.2f", $damageData['regularLoanDetail']['loanFormFee']) }} |
| {{ $damageData['loanDetailsTCN']['payment'] }} |
{{ $damageData['regularLoanDetail']['paymentTypeIdFk'] }} |
| {{ $damageData['loanDetailsTCN']['employment'] }} |
| Self: {{ $damageData['regularLoanDetail']['isSelfEmployment'] }} |
|
Family |
Wages Based |
Wage (Per Month) |
| Full Time Male |
0 |
0 |
0 |
| Full Time Female |
0 |
0 |
0 |
| Part Time Male |
0 |
0 |
0 |
| Part Time Female |
0 |
0 |
0 |
|
|