@extends('layouts/microfin_layout') @section('title', '| Regular Loan Details') @section('content')
Pictures
Member Picture :
{{--
--}} {{--
Member Picture : @if ($damageData['memberProfilePicture'] != '') @else @endif
--}} @if ($damageData['memberProfilePicture'] != '') Profile Image @else @endif
Guarantor Picture :
{{--
--}} {{--
Guarantor Picture : @if ($damageData['memberGuarantorPicture'] != '') @else @endif
--}} @if ($damageData['memberGuarantorPicture'] != '') Guarantor Image @else @endif
 
Member NID Signature :
{{--
--}} {{--
Member NID Picture : @if ($damageData['memberProfilePicture'] != '') @else @endif
--}} @if ($damageData['memberNidPicture'] != '') Member NID Image @else @endif
Guarantor NID Signature :
{{--
--}} {{--
Guarantor NID Picture : @if ($damageData['memberGuarantorPicture'] != '') @else @endif
--}} @if ($damageData['memberGuarantorNidPicture'] != '') Guarantor NID Image @else @endif
@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 @php // dd($damageData['regularLoanDetail']); @endphp
Loan Information
{{ $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'] }}{{ 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'] }}
{{ $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
{{-- @php $i=0; $totalCollectionForLoan = $damageData['totalCollectionForLoan']; @endphp @foreach($damageData['loanSchedules'] as $loanSchedule) @php $isCompleted = 0; $isPartiallyPaid = 0; $totalCollectionForLoan =$totalCollectionForLoan -$loanSchedule['installmentAmount']; if($totalCollectionForLoan > $loanSchedule['installmentAmount']){ $isCompleted = 1; }else{ if($totalCollectionForLoan > 0){ $isPartiallyPaid = 1; } } @endphp @endforeach --}} {{--shut down this code and open above tbody--}} @php $i=0; @endphp @foreach($damageData['loanSchedules'] as $loanSchedule) @endforeach {{--shut down this code and open above tbody--}}
Loan Schedule
# Date Samity Day Amount Principal Amount (P) Interest Amount (I) Transaction Amount Status
AcItual Amount Extra Amount Installment Amount
{{$loanSchedule['installmentSl']}} {{$damageData['MicroFinance']->getMicroFinanceDateFormat($loanSchedule['scheduleDate'])}} {{date('l', strtotime($loanSchedule['scheduleDate']))}} {{sprintf("%.2f", $loanSchedule['actualInstallmentAmount'])}} {{sprintf("%.2f", $loanSchedule['extraInstallmentAmount'])}} {{sprintf("%.2f", $loanSchedule['installmentAmount'])}} {{sprintf("%.2f", $loanSchedule['principalAmount'])}} {{sprintf("%.2f", $loanSchedule['interestAmount'])}} @if($isCompleted==1) @elseif($isPartiallyPaid==1) P @elseif($i<=1) @php $i=1; $installmentSl = $loanSchedule['installmentSl']; @endphp Reschedule @php $i+=1; @endphp @endif
{{ $loanSchedule->installmentSl }} {{ $damageData['MicroFinance']->getMicroFinanceDateFormat($loanSchedule->scheduleDate) }} {{ date('l', strtotime($loanSchedule->scheduleDate)) }} {{ sprintf("%.2f", $loanSchedule->actualInstallmentAmount) }} {{ sprintf("%.2f", $loanSchedule->extraInstallmentAmount) }} {{ sprintf("%.2f", $loanSchedule->installmentAmount) }} {{ sprintf("%.2f", $loanSchedule->principalAmount) }} {{ sprintf("%.2f", $loanSchedule->interestAmount) }} @if($loanSchedule->isCompleted==1) @elseif($loanSchedule->isPartiallyPaid==1) P @elseif($i<=1) @php $i=1; @endphp Reschedule @php $i+=1; @endphp @endif
@endsection