{{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $name) @endforeach {{-- --}} {{-- --}} @foreach ($fyMonths as $i => $name) @endforeach {{-- --}} {{-- --}} @foreach ($fyMonths as $i => $name) {{-- --}} @endforeach {{-- --}} {{-- --}} {{-- --}} @foreach ($fyMonths as $i => $name) @endforeach @foreach ($monthsArr as $key=> $month) @endforeach @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @forEach ($monthsArr as $key=> $month) {{-- --}} @endforEach {{-- --}} @forEach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) {{-- --}} @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) {{-- --}} @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) {{-- --}} @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) {{-- --}} @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach {{-- --}} @foreach ($monthsArr as $key=> $month) @endforeach

Particulars		{{ $prevLastFy }}	Opening	Target			Achievement {{ $fiscalyear }}													Variance		Closing
			Fiscal Year	Yearly Total	Current Year	Current Month	Jul, {{ $partOfyear[0] }}	Aug, {{ $partOfyear[0] }}	Sep, {{ $partOfyear[0] }}	Oct, {{ $partOfyear[0] }}	Nov, {{ $partOfyear[0] }}	Dec, {{ $partOfyear[0] }}	Jan, {{ $partOfyear[1] }}	Feb, {{ $partOfyear[1] }}	Mar, {{ $partOfyear[1] }}	Apr, {{ $partOfyear[1] }}	May, {{ $partOfyear[1] }}	Jun, {{ $partOfyear[1] }}	Total	Current Year	Current Month	Fiscal Year
		{{ $lastFy }}	Jul {{$partOfyear[0]}} to Jun {{$partOfyear[1]}}	Jul {{$partOfyear[0]}} to {{date('M',strtotime('last month'))}} {{$partOfyear[1]}}	{{date('M',strtotime('last month'))}} {{$partOfyear[1]}}	Jul {{$partOfyear[0]}} to {{date('M',strtotime('last month'))}} {{$partOfyear[1]}}														{{date('M',strtotime('last month'))}} {{$partOfyear[1]}}	{{ $fiscalyear }}
Branch	No. of Branch	{{ $branchCount_lastFy > 0 ? $branchCount_lastFy : '-' }}	{{ $branchCount > 0 ? $branchCount : '-' }}	{{$currentYearBranchCount}}	{{$currentMonthBranchCount}}	{{$branchCount > 0 ? $branchCount : '-'}}	{{$branchCount > 0 ? $branchCount : '-'}}	{{ isset($branchGenuinedata['genuinedata'][$key]) ? $branchGenuinedata['genuinedata'][$key] : 0}}	{{ $branchGenuinedata['total']}}	{{$branchCount - $branchGenuinedata['total']}}	{{$branchCount - $branchGenuinedata['genuinedata'][date('n')-1]}}	{{$branchCount_lastFy + $branchGenuinedata['total']}}	{{$currentYearBranchCount-$branchCount}}	{{$currentMonthBranchCount}}
Staff	Management Staff	{{ $staffEntry['Management Staffs']['prevLastFy'] }}	{{ $staffEntry['Management Staffs']['lastFy'] }}	{{$staffEntry['Management Staffs']['june']}}	{{$staffEntry['Management Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{$staffEntry['Management Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{ isset($staffGenuineData['management'][$name]) ? $staffGenuineData['management'][$name] : 0 }}	{{end($staffGenuineData['management'])}}	{{end($staffGenuineData['management']) - $staffEntry['Management Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{$staffVarianceMonthly['management']}}	{{$staffClosing['management']}}
	Credit Staff	{{ $staffEntry['Credit Staffs']['prevLastFy'] }}	{{ $staffEntry['Credit Staffs']['lastFy'] }}		{{$staffEntry['Credit Staffs']['june']}}	{{$staffEntry['Credit Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{$staffEntry['Credit Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{ $staffEntry['Credit Staffs'][$name] }}	{{ isset($staffGenuineData['credit'][$name]) ? $staffGenuineData['credit'][$name] : 0 }}	{{end($staffGenuineData['credit'])}}	{{end($staffGenuineData['credit']) - $staffEntry['Credit Staffs'][ strtolower(date('F', strtotime('last month')))] }}	{{$staffVarianceMonthly['credit']}}	{{$staffClosing['credit']}}
	Total Staff				{{ $staffEntry['Management Staffs']['lastFy'] + $staffEntry['Credit Staffs']['lastFy']}}	{{$staffEntry['Management Staffs']['june'] + $staffEntry['Credit Staffs']['june']}}	{{$staffEntry['Management Staffs'][ strtolower(date('F', strtotime('last month')))] + $staffEntry['Credit Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{$staffEntry['Management Staffs'][ strtolower(date('F', strtotime('last month')))] + $staffEntry['Credit Staffs'][ strtolower(date('F', strtotime('last month')))]}}	{{ isset($staffGenuineData['total'][$name]) ? $staffGenuineData['total'][$name] : 0 }}	{{end($staffGenuineData['total'])}}	{{($staffEntry['Management Staffs'][ strtolower(date('F', strtotime('last month')))] + $staffEntry['Credit Staffs'][ strtolower(date('F', strtotime('last month')))])-end($staffGenuineData['total'])}}	{{$staffVarianceMonthly['management'] + $staffVarianceMonthly['credit'] }}	{{$staffClosing['management'] + $staffClosing['credit']}}
Samity	Add	{{ $samityData['total_lastFy_closing'] }}	{{$samityData['total_lastFy_add'] + $samityData['totalFyAdd']}}	{{ $samityData['currentYearAdd'] }}	{{$samityData['currentMonthAdd']}}	{{ isset($samityGenuineData['addInfo'][$key]) ? $samityGenuineData['addInfo'][$key] : 0 }}	{{ $samityGenuineData['totalAddInfo'] }}	{{$samityVariance['yearAddVariance']}}	{{$samityVariance['monthlyAddVariance']}}	{{$samityGenuineData['totalClosingInfo']}}
	Cancellation		{{ $samityData['total_lastFy_cancellation'] + $samityData['totalFyCancel'] }}	{{ $samityData['currentYearCancellation'] }}	{{$samityData['currentMonthCancellation']}}	{{ isset($samityGenuineData['cancellationInfo'][$key]) ? $samityGenuineData['cancellationInfo'][$key] : 0 }}	{{ $samityGenuineData['totalCancellationInfo'] }}	{{$samityVariance['yearCancellationVariance']}}	{{$samityVariance['monthlyCancellationVariance']}}
	Net Samity		{{ $samityData['total_lastFy_net'] + $samityData['totalFyNet'] }}	{{ $samityData['currentYearNet'] }}	{{$samityData['currentMonthNet']}}	{{ $samityData['totalNet'][$i] }}	{{ isset($samityGenuineData['netInfo'][$key]) ? $samityGenuineData['netInfo'][$key] : 0 }}	{{ $samityGenuineData['totalnetInfo'] }}	{{$samityVariance['yearNetVariance']}}		{{$samityVariance['monthlyNetVariance']}}
	Closing Samity		{{ (($samityData['total_prevLastFy_closing'] + $samityData['total_lastFy_add'])-$samityData['total_lastFy_cancellation'])+$samityData['totalFyNet'] }}	{{$samityData['total_lastFy_closing'] +$samityData['currentYearNet'] }}	{{$samityData['total_lastFy_closing'] +$samityData['currentYearNet'] }}	{{isset($samityGenuineData['closingInfo'][$key]) ? $samityGenuineData['closingInfo'][$key] : 0}}	{{$samityGenuineData['totalClosingInfo']}}	{{$samityVariance['yearClosingVariance']}}	{{$samityVariance['monthlyClosingVariance']}}
Member	Add	{{ $memberData['total_lastFy_closing'] }}	{{$memberData['total_lastFy_add'] + $memberData['totalFyAdd']}}	{{ $memberData['currentYearAdd'] }}	{{$memberData['currentMonthAdd']}}	{{ isset($memberGenuineData['addInfo'][$key]) ? $memberGenuineData['addInfo'][$key] : 0 }}	{{$memberGenuineData['totalAddInfo']}}	{{$memberVariance['yearAddVariance']}}	{{$memberVariance['monthlyAddVariance']}}	{{$memberGenuineData['totalClosingInfo']}}
	Cancellation		{{ $memberData['total_lastFy_cancellation'] + $memberData['totalFyCancel'] }}	{{$memberData['currentYearCancellation']}}	{{$memberData['currentMonthCancellation']}}	{{ isset($memberGenuineData['cancellationInfo'][$key]) ? $memberGenuineData['cancellationInfo'][$key] : 0 }}	{{$memberGenuineData['totalCancellationInfo']}}	{{$memberVariance['yearCancellationVariance']}}	{{$memberVariance['monthlyCancellationVariance']}}
	Net Member		{{ $memberData['total_lastFy_net'] + $memberData['totalFyNet'] }}	{{$memberData['currentYearNet']}}	{{$memberData['currentMonthNet']}}	{{ isset($memberGenuineData['netInfo'][$key]) ? $memberGenuineData['netInfo'][$key] : 0 }}	{{$memberGenuineData['totalnetInfo']}}	{{$memberVariance['yearNetVariance']}}	{{$memberVariance['monthlyNetVariance']}}
	Closing Member		{{ $memberData['total_lastFy_closing'] }}	{{ (($memberData['total_prevLastFy_closing'] + $memberData['total_lastFy_add'])-$memberData['total_lastFy_cancellation'])+$memberData['totalFyNet'] }}	{{ $memberData['total_lastFy_closing'] + $memberData['currentYearNet'] }}	{{ $memberData['total_lastFy_closing'] + $memberData['currentYearNet'] }}	{{isset($memberGenuineData['closingInfo'][$key]) ? $memberGenuineData['closingInfo'][$key] : 0}}	{{$memberGenuineData['totalClosingInfo']}}	{{$memberVariance['yearClosingVariance']}}		{{$memberVariance['monthlyClosingVariance']}}
Member Savings	Collection	{{round($savingsData['total_lastFy_closing']) }}	{{round($savingsData['total_lastFy_add'] + $savingsData['totalFyAdd'])}}	{{ round($savingsData['currentYearAdd']) }}	{{round($savingsData['currentMonthAdd'])}}	{{ $savingsData['totalAdd'][$i] }}	{{ isset($savingsGenuineData['collectionInfo'][$key]) ? round($savingsGenuineData['collectionInfo'][$key]) : 0 }}	{{ round($savingsGenuineData['totalCollectionInfo']) }}	{{round($savingsVariance['yearCollectionVariance'])}}	{{round($savingsVariance['monthlyCollectionVariance'])}}	{{ round($savingsGenuineData['totalClosingInfo']) }}
	Refund		{{ $savingsData['total_lastFy_cancellation'] }}	{{ round($savingsData['total_lastFy_cancellation'] + $savingsData['totalFyCancel']) }}	{{ round($savingsData['currentYearCancellation']) }}	{{round($savingsData['currentMonthCancellation'])}}	{{ isset($savingsGenuineData['refundInfo'][$key]) ? round($savingsGenuineData['refundInfo'][$key]) : 0 }}	{{ round($savingsGenuineData['totalrefundInfo']) }}	{{round($savingsVariance['yearrefundVariance'])}}	{{round($savingsVariance['monthlyrefundVariance'])}}
	Net Savings		{{ $savingsData['total_lastFy_net'] }}	{{ round($savingsData['total_lastFy_net'] + $savingsData['totalFyNet']) }}	{{ round($savingsData['currentYearNet']) }}	{{round($savingsData['currentMonthNet'])}}	{{ isset($savingsGenuineData['netInfo'][$key]) ? round($savingsGenuineData['netInfo'][$key]) : 0 }}	{{ round($savingsGenuineData['totalnetInfo']) }}	{{round($savingsVariance['yearNetVariance'])}}	{{round($savingsVariance['monthlyNetVariance'])}}
	Closing Savings		{{ $savingsData['total_lastFy_closing'] }}	{{ (($savingsData['total_prevLastFy_closing'] + $savingsData['total_lastFy_add'])-$savingsData['total_lastFy_cancellation'])+$savingsData['totalFyNet'] }}	{{$savingsData['total_lastFy_closing'] +$savingsData['currentYearNet'] }}	{{$savingsData['total_lastFy_closing'] +$savingsData['currentYearNet'] }}	{{isset($savingsGenuineData['closingInfo'][$key]) ? $savingsGenuineData['closingInfo'][$key] : 0}}	{{$savingsGenuineData['totalClosingInfo']}}	{{$savingsVariance['yearClosingVariance']}}	{{$savingsVariance['monthlyClosingVariance']}}
Borrower	Add	{{ $borrowerData['total_lastFy_closing'] }}	{{$borrowerData['total_lastFy_add'] + $borrowerData['totalFyAdd']}}	{{ $borrowerData['currentYearAdd'] }}	{{$borrowerData['currentMonthAdd']}}	{{ isset($borrowerGenuineData['addInfo'][$key]) ? $borrowerGenuineData['addInfo'][$key] : 0 }}	{{ $borrowerGenuineData['totalAddInfo'] }}	{{$borrowerVariance['yearAddVariance']}}	{{$borrowerVariance['monthlyAddVariance']}}	{{$borrowerGenuineData['totalClosingInfo']}}
	Cancellation		{{ $borrowerData['total_lastFy_cancellation'] }}	{{ $borrowerData['total_lastFy_cancellation'] + $borrowerData['totalFyCancel'] }}	{{$borrowerData['currentYearCancellation']}}	{{$borrowerData['currentMonthCancellation']}}	{{ isset($borrowerGenuineData['cancellationInfo'][$key]) ? $borrowerGenuineData['cancellationInfo'][$key] : 0 }}	{{ $borrowerGenuineData['totalCancellationInfo'] }}	{{$borrowerVariance['yearCancellationVariance']}}		{{$borrowerVariance['monthlyCancellationVariance']}}
	Net Borrower		{{ $borrowerData['total_lastFy_net'] }}	{{ $borrowerData['total_lastFy_net'] + $borrowerData['totalFyNet'] }}	{{$borrowerData['currentYearNet']}}	{{$borrowerData['currentMonthNet']}}	{{ isset($borrowerGenuineData['netInfo'][$key]) ? $borrowerGenuineData['netInfo'][$key] : 0 }}	{{ $borrowerGenuineData['totalnetInfo'] }}	{{$borrowerVariance['yearNetVariance']}}		{{$borrowerVariance['monthlyNetVariance']}}
	Closing Borrower		{{ $borrowerData['total_lastFy_closing'] }}	{{ (($borrowerData['total_prevLastFy_closing'] + $borrowerData['total_lastFy_add'])-$borrowerData['total_lastFy_cancellation'])+$borrowerData['totalFyNet'] }}	{{ $borrowerData['total_lastFy_closing'] + $borrowerData['currentYearNet'] }}	{{ $borrowerData['total_lastFy_closing'] + $borrowerData['currentYearNet'] }}	{{isset($borrowerGenuineData['closingInfo'][$key]) ? $borrowerGenuineData['closingInfo'][$key] : 0}}	{{$borrowerGenuineData['totalClosingInfo']}}	{{$borrowerVariance['yearClosingVariance']}}		{{$borrowerVariance['monthlyClosingVariance']}}
Loan Outstanding	Disbursement	{{ $loanData['total_lastFy_closing'] }}	{{$loanData['total_lastFy_add'] + $loanData['totalFyAdd']}}	{{ $loanData['currentYearAdd'] }}	{{$loanData['currentMonthAdd']}}	{{ $loanData['totalAdd'][$i] }}	{{ isset($loanGenuineData['disbursementInfo'][$key]) ? round($loanGenuineData['disbursementInfo'][$key]) : 0 }}	{{$loanGenuineData['totalDisbursementInfo']}}	{{$loanVariance['yearDisbursementVariance']}}	{{$loanVariance['monthlyDisbursementVariance']}}	{{$loanGenuineData['totalClosingInfo']}}
	Collection		{{ $loanData['total_lastFy_cancellation'] }}	{{ $loanData['total_lastFy_cancellation'] + $loanData['totalFyCancel'] }}	{{ $loanData['currentYearCancellation'] }}	{{$loanData['currentMonthCancellation']}}	{{ $loanData['totalCancellation'][$i] }}	{{ isset($loanGenuineData['collectionInfo'][$key]) ? round($loanGenuineData['collectionInfo'][$key]) : 0 }}	{{$loanGenuineData['totalCollectionInfo']}}	{{$loanVariance['yearCollectionVariance']}}		{{$loanVariance['monthlyCollectionVariance']}}
	Net Outstanding		{{ $loanData['total_lastFy_net'] }}	{{ $loanData['total_lastFy_net'] + $loanData['totalFyNet'] }}	{{ $loanData['currentYearNet'] }}	{{$loanData['currentMonthNet']}}	{{ isset($loanGenuineData['netInfo'][$key]) ? round($loanGenuineData['netInfo'][$key]) : 0 }}	{{$loanGenuineData['totalnetInfo']}}	{{$loanVariance['yearNetVariance']}}	{{$loanVariance['monthlyNetVariance']}}
	Closing Outstanding		{{ $loanData['total_lastFy_closing'] }}	{{ round((($loanData['total_prevLastFy_closing'] + $loanData['total_lastFy_add'])-$loanData['total_lastFy_cancellation'])+$loanData['totalFyNet']) }}	{{ round($loanData['total_lastFy_closing'] + $loanData['currentYearNet']) }}	{{ round($loanData['total_lastFy_closing'] + $loanData['currentYearNet']) }}	{{isset($loanGenuineData['closingInfo'][$key]) ? round($loanGenuineData['closingInfo'][$key]) : 0}}	{{round($loanGenuineData['totalClosingInfo'])}}	{{round($loanVariance['yearClosingVariance'])}}	{{round($loanVariance['monthlyClosingVariance'])}}
Due	No. of Due Loanee	{{ $dueData['openingData']['lastFyDueLoanee'] }}	{{$dueData['openingData']['lastFyDueLoanee'] + $dueData['totalLoaneefy']}}	{{$dueData['currentYearLoanee']}}	{{$dueData['currentMonthLoanee']}}	{{ $dueData['loanee'][$i] }}	{{ isset($dueGenuineData['dueLoanee'][$key]) ? $dueGenuineData['dueLoanee'][$key] : 0 }}	{{$dueGenuineData['totalDueLoanee']}}	{{$dueVariance['yearLoaneeVariance']}}	{{$dueVariance['monthlyLoaneeVariance']}}	{{$dueGenuineData['totalDueLoanee']}}
	Due Collection	{{ $dueData['openingData']['prevLastFyDueCollection'] }}	{{ round($dueData['openingData']['lastFyDueCollection']) }}	{{ round($dueData['openingData']['lastFyDueCollection'] + $dueData['totalCollectionFy']) }}	{{round($dueData['currentYearCollection'])}}	{{round($dueData['currentMonthCollection'])}}	{{ isset($dueGenuineData['dueCollection'][$key]) ? round($dueGenuineData['dueCollection'][$key]) : 0 }}	{{round($dueGenuineData['totalDueCollection'])}}	{{round($dueVariance['yearCollectionVariance'])}}	{{round($dueVariance['monthlyCollectionVariance'])}}	{{round($dueGenuineData['totalDueCollection'])}}
	Due Outstanding	{{ $dueData['openingData']['prevLastFyDueOutstanding'] }}	{{ round($dueData['openingData']['lastFyDueOutstanding']) }}	{{ round($dueData['openingData']['lastFyDueOutstanding'] - $dueData['totalCollectionFy'])}}	{{round($dueData['currentYearOutstanding'])}}	{{round($dueData['currentMonthOutstanding'])}}	{{ isset($dueGenuineData['dueOutstanding'][$key]) ? number_format(round($dueGenuineData['dueOutstanding'][$key])) : "–" }} * {{ isset($dueGenuineData['dueAchievement'][$key]) ? number_format(round($dueGenuineData['dueAchievement'][$key])) : "–" }}	{{round($dueGenuineData['totalDueOutstanding'])}}	{{round($dueVariance['yearOutstandingVariance'])}}	{{round($dueVariance['monthlyOutstandingVariance'])}}	{{round($dueGenuineData['totalDueOutstanding'])}}