{{-- --}} {{-- Total Due Previous --}} {{-- Total Due Current --}} {{-- Due Increase --}} {{-- --}} @php $previousMember = 0; $admissionMember = 0; $dropMember = 0; $currentMember = 0; $uniqueMember = 0; $samityNum = 0; $totalPrevSavings = 0; $totalDuringSavings = 0; $totalCurrentSavings = 0; $balancesavings = 0; $prevTotalOutstandings = 0; $currentTotalDisbursed = 0; $currentTotalCollection = 0; $closingTotalOutStandings = 0; $prevTotalCurrentDueNum = 0; $prevTotalCurrentDue = 0; $prevExpiredDueNum = 0; $prevExpiredDue = 0; $prevGrandDueNum = 0; $prevGrandDue = 0; $closTotalCurrentDueNum = 0; $closTotalCurrentDue = 0; $closExpiredDueNum = 0; $closExpiredDue = 0; $closGrandDueNum = 0; $closGrandDue = 0; $grandDueIncCurrent = 0; $grandDueIncExpired = 0; $totalDueCurrentPercentage = 0; $totalExpiredCurrentPercentage = 0; $total_otr = 0; $totalPar = 0; $totalLoanSavingsRatio = 0; $totalBorrowerCoverage = 0; $total_recovred_value = 0; $total_recoverable_value = 0; @endphp @foreach ($getOfficerWiseSamities as $key => $item) @php $fieldOfficersInfos = DB::table('hr_emp_general_info') ->where('id', $key) ->select('id', 'emp_id', 'emp_name_english') ->first(); $previousMember += $item['memberBalance']['previous']; $admissionMember += $item['memberBalance']['admission']; $dropMember += $item['memberBalance']['drop']; $currentMember += $item['memberBalance']['current']; $uniqueMember += $item['borrower_coverage']['unique_member']; $samityNum += $item['samityNum']; $totalPrevSavings += $item['savingsBalance']['openingSavingsBal']; $totalDuringSavings += $item['savingsBalance']['deposit']; $totalCurrentSavings += $item['savingsBalance']['withdraw']; $balancesavings += $item['savingsBalance']['cl_balance']; $prevTotalOutstandings += $item['loanOutstanding']['openingBalnace']; $currentTotalDisbursed += $item['loanOutstanding']['disburse']; $currentTotalCollection += $item['loanOutstanding']['collection']; $closingTotalOutStandings += $item['loanOutstanding']['closingBalance']; $prevTotalCurrentDueNum += $item['totalDuePreviousCurrentDue']['no']; $prevTotalCurrentDue += $item['totalDuePreviousCurrentDue']['amount']; $prevExpiredDueNum += $item['totalDuePreviousExpiredDue']['no']; $prevExpiredDue += $item['totalDuePreviousExpiredDue']['amount']; $prevGrandDueNum += $item['totalDuePrevious']['no']; $prevGrandDue += $item['totalDuePrevious']['amount']; $closTotalCurrentDueNum += $item['totalDueCurrentCurrentDue']['no']; $closTotalCurrentDue += $item['totalDueCurrentCurrentDue']['amount']; $closExpiredDueNum += $item['totalDueCurrentExpiredDue']['no']; $closExpiredDue += $item['totalDueCurrentExpiredDue']['amount']; $closGrandDueNum += $item['totalDueCurrent']['no']; $closGrandDue += $item['totalDueCurrent']['amount']; $grandDueIncCurrent += $item['dueIncrease']['current']; $grandDueIncExpired += $item['dueIncrease']['expired']; $totalDueCurrentPercentage += $item['dueIncrease']['current']; $totalExpiredCurrentPercentage += $item['dueIncrease']['expired']; $total_otr += $item['otr']['current_otr']; $totalPar += $item['par']['current_par']; $totalLoanSavingsRatio += $item['loanSavingsRatio']['value']; $totalBorrowerCoverage += $item['borrower_coverage']['value']; $total_recovred_value += $item['otr']['recovred_value']; $total_recoverable_value += $item['otr']['recoverable_value']; @endphp {{-- member balance --}} {{-- savings balance --}} {{-- loan outstanings --}} {{-- total due previous --}} {{-- total due Current --}} {{-- due increases --}} {{-- OTR AND PAR --}} {{-- --}} @endforeach @php //calculate total otr if ($total_recoverable_value == 0) { // data collection (recover and recoberable) not found if day end process not done and its return zero with advance adjust otr type search $total_otr = 0; }else{ $total_otr = round(round($total_recovred_value)/round($total_recoverable_value) * 100,2); } //calculate total par $totalPar = round($totalPar / count($getOfficerWiseSamities), 2); $avgLoanSavingsRatio = round($totalLoanSavingsRatio / count($getOfficerWiseSamities), 2); $avgBorrowerCoverage = round(($uniqueMember / $currentMember * 100), 2); $avgDueCurrentPercentage = round($totalDueCurrentPercentage / count($getOfficerWiseSamities), 2); $avgExpiredCurrentPercentage = round( $totalExpiredCurrentPercentage / count($getOfficerWiseSamities), 2 ); @endphp {{-- --}}

Sl No	Field Officer Name & Code	Samity	Balance											Total Due Previous						Total Due Current						Due Increase(%)		During Recovered	During Recoverable	OTR	PAR	Loan Savings Ratio	Borrower Coverage
			Member Balance			Savings Balance				Loan Outstanding				Current Due		Expired Due		Total Due		Current Due		Expired Due		Total Due		Current	Expired
			Prev	Add DropOut	Current	Opening	Deposit	Withdraw	Cl.Balance	Opening Balance	Disburse	Collection	Cl.Balance	No	Amount	No	Amount	No	Amount	No	Amount	No	Amount	No	Amount
			1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	*	*	26	27	28	29
{{ $loop->iteration }}	{{ $fieldOfficersInfos->emp_name_english }} {{ strtok($fieldOfficersInfos->emp_id, '-') }}	{{ $item['samityNum'] }}	{{ $item['memberBalance']['previous'] }}	{{ $item['memberBalance']['admission'] . '-' . $item['memberBalance']['drop'] }}	{{ $item['memberBalance']['current'] }}	{{ number_format($item['savingsBalance']['openingSavingsBal'], 2) }}	{{ number_format($item['savingsBalance']['deposit'], 2) }}	{{ number_format($item['savingsBalance']['withdraw'], 2) }}	{{ number_format($item['savingsBalance']['cl_balance'], 2) }}	{{ number_format($item['loanOutstanding']['openingBalnace'], 2) }}	{{ number_format($item['loanOutstanding']['disburse'], 2) }}	{{ number_format($item['loanOutstanding']['collection'], 2) }}	{{ number_format($item['loanOutstanding']['closingBalance'], 2) }}	{{ $item['totalDuePreviousCurrentDue']['no'] }}	{{ number_format($item['totalDuePreviousCurrentDue']['amount'], 2) }}	{{ $item['totalDuePreviousExpiredDue']['no'] }}	{{ number_format($item['totalDuePreviousExpiredDue']['amount'], 2) }}	{{ $item['totalDuePrevious']['no'] }}	{{ number_format($item['totalDuePrevious']['amount'], 2) }}	{{ $item['totalDueCurrentCurrentDue']['no'] }}	{{ number_format($item['totalDueCurrentCurrentDue']['amount'], 2) }}	{{ $item['totalDueCurrentExpiredDue']['no'] }}	{{ number_format($item['totalDueCurrentExpiredDue']['amount'], 2) }}	{{ $item['totalDueCurrent']['no'] }}	{{ number_format($item['totalDueCurrent']['amount'], 2) }}	{{ number_format($item['dueIncrease']['current'], 2) }}%	{{ number_format($item['dueIncrease']['expired'], 2) }}%	{{ number_format($item['otr']['recovred_value'], 2) }}	{{ number_format($item['otr']['recoverable_value'], 2) }}	{{ number_format($item['otr']['current_otr'], 2) }}%	{{ number_format($item['par']['current_par'], 2) }}%	{{ number_format($item['loanSavingsRatio']['value'], 2) }}%	{{ number_format($item['borrower_coverage']['value'], 2) }}%
Total:		{{ $samityNum }}	{{ $previousMember }}	{{ $admissionMember . '-' . $dropMember }}	{{ $currentMember }}	{{ number_format($totalPrevSavings, 2) }}	{{ number_format($totalDuringSavings, 2) }}	{{ number_format($totalCurrentSavings, 2) }}	{{ number_format($balancesavings, 2) }}	{{ number_format($prevTotalOutstandings, 2) }}	{{ number_format($currentTotalDisbursed, 2) }}	{{ number_format($currentTotalCollection, 2) }}	{{ number_format($closingTotalOutStandings, 2) }}	{{ $prevTotalCurrentDueNum }}	{{ number_format($prevTotalCurrentDue, 2) }}	{{ $prevExpiredDueNum }}	{{ number_format($prevExpiredDue, 2) }}	{{ $prevGrandDueNum }}	{{ number_format($prevGrandDue, 2) }}	{{ $closTotalCurrentDueNum }}	{{ number_format($closTotalCurrentDue, 2) }}	{{ $closExpiredDueNum }}	{{ number_format($closExpiredDue, 2) }}	{{ $closGrandDueNum }}	{{ number_format($closGrandDue, 2) }}	{{ number_format($avgDueCurrentPercentage, 2) }}%	{{ number_format($avgExpiredCurrentPercentage, 2) }}%	{{$total_recovred_value}}	{{$total_recoverable_value}}	{{ number_format($total_otr, 2) }}%	{{ number_format($totalPar, 2) }}%	{{ number_format($avgLoanSavingsRatio, 2) }}%	{{ number_format($avgBorrowerCoverage, 2) }}%