@if($requestBranch == '') @endif @if($requestSamity == '') @endif @if($requestStatus == 'disbursed' || $requestStatus == '') @endif @if($requestStatus == 'disbursed' || $requestStatus == '') @endif @if($requestStatus == 'disbursed' || $requestStatus == '') @endif @if($requestBranch == '') @endif @if($requestSamity == '') @endif @php $no = 0; $totalProposed = 0; $totalApproved = 0; $totalDisbursed = 0; //dd($LoanApplicationInfos); @endphp @foreach ($LoanApplicationInfos as $LoanApplicationInfo) @php $frequencies = DB::table('mfn_repayment_frequency') ->where('id', $LoanApplicationInfo->repaymentFrequencyIdFk) ->where('softDel', 0) ->value('nounOfName'); $totalProposed += $LoanApplicationInfo->proposalLoanAmount; $totalApproved += $LoanApplicationInfo->approvedLoanAmount; $totalDisbursed += $LoanApplicationInfo->disbursedLoanAmount; if($requestStatus == 'disbursed' || $requestStatus == ''){ $approvedBy = DB::table('users') ->where('users.id', $LoanApplicationInfo->approvedByUserId) ->join('hr_emp_general_info', 'users.emp_id_fk', '=', 'hr_emp_general_info.id') ->selectRaw(DB::raw("CONCAT(substring_index(hr_emp_general_info.emp_id, '-', 1), ' - ', hr_emp_general_info.emp_name_english) AS employeeIdWithName")) ->value('employeeIdWithName'); } @endphp @if($requestBranch == '' ) @endif @if($requestStatus == 'disbursed' || $requestStatus == '') @endif @if($requestStatus == 'disbursed' || $requestStatus == '') @endif @if($requestStatus == 'disbursed' || $requestStatus == '') @endif @endforeach @if($requestBranch == '' && $requestStatus == '') @elseif($requestBranch == '' && $requestStatus == 'disbursed') @elseif($requestBranch != '' && $requestStatus == 'disbursed') @elseif($requestBranch != '' && $requestStatus != 'disbursed') @elseif($requestBranch == '' && $requestStatus != 'disbursed') @endif

SL	Branch		Samity		Member		Loan Code	Loan Product	Loan Period	Loan Purpose	Proposed Loan Amount	Approved Loan Amount	Disbursed Loan Amount	Entered By	Approved By	Application Date	Approval Status
	Code	Name	Code	Name	Code	Name
{{ ++$no }}	{{ $LoanApplicationInfo->branchCodeWith0 }}	{{ $LoanApplicationInfo->branchName }}	{{ $LoanApplicationInfo->samitycode }}	{{ $LoanApplicationInfo->samityName }}	{{ $LoanApplicationInfo->memberCode }}	{{ $LoanApplicationInfo->memberName }}	{{ $LoanApplicationInfo->loanCode }}	{{ $LoanApplicationInfo->loanProductName }}	{{ $LoanApplicationInfo->numberOfInstallment. ' ' .$frequencies}}	{{ $LoanApplicationInfo->loanPurpose }}	{{ number_format($LoanApplicationInfo->proposalLoanAmount) }}	{{ number_format($LoanApplicationInfo->approvedLoanAmount) }}	{{ number_format($LoanApplicationInfo->disbursedLoanAmount) }}	{{ $LoanApplicationInfo->entryBy }}	{{$approvedBy}}	{{ date('d-m-Y', strtotime($LoanApplicationInfo->applicationDate)) }}	{{ ucfirst($LoanApplicationInfo->status) }}
Total:											{{ number_format($totalProposed ) }}	{{ number_format($totalApproved) }}	{{ number_format($totalDisbursed) }}
Total:											{{ number_format($totalProposed ) }}	{{ number_format($totalApproved) }}	{{ number_format($totalDisbursed) }}
Total:									{{ number_format($totalProposed ) }}	{{ number_format($totalApproved) }}	{{ number_format($totalDisbursed) }}
Total:									{{ number_format($totalProposed ) }}	{{ number_format($totalApproved) }}
Total:										{{ number_format($totalProposed ) }}	{{ number_format($totalApproved) }}