@extends('layouts/microfin_layout')
@section('title', '|Periodic Collection Component Wise Report')
@section('content')
@include('successMsg')
@php
$branchId = Auth::user()->branchId; 
$loanProductCategorySelected = isset($_GET['searchLoanProduct']) ? $_GET['searchLoanProduct'] : null;
@endphp
<div id="reportWidth">
<div class="row">
<div class="col-md-12">
  	<div class="" style="">
		<div class="">            
	    	<div class="panel panel-default" style="background-color:#708090;">
		  		<div class="panel-heading" style="padding-bottom:0px">
					<div class="panel-options">
			    		<a href="" class="btn btn-info pull-right addViewBtn" id="print" media="print"><i class="fa fa-print" aria-hidden="true"></i> Print</a>
					</div>
					<div class="row" id="filtering-group">
			    		<div class="form-horizontal form-groups" style="padding-right: 0px;">
				  			{!! Form::open(['url' =>'mfnPeriodicCollectionComponentReport','method' =>'get']) !!}
				  			<div class="col-md-1">
								<div class="form-group" style="font-size: 13px; color:black;">
					    			<div style="text-align: center;" class="col-sm-12">
						  				{!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
					    			</div> 
								    <div class="col-sm-12">
									  	<select name="searchBranch" class="form-control input-sm" id="searchBranch">
										  	@if($branchId==1)
										  		<option value="">Select Branch</option>
										  	@endif
											@foreach($searchBranchs as $searchBranch)
										    	<option value="{{$searchBranch->id}}"@if($searchBranch->id==$branchSelected){{"selected=selected"}}@endif>{{str_pad($searchBranch->branchCode,3,"00",STR_PAD_LEFT)}}-{{$searchBranch->name}}</option>
											@endforeach 
									  	</select>
									   	<p id='branchee' style="max-height:2px; color:red;"></p>
								    </div>
								</div>
				  			</div>
				  			<div class="col-md-2">
								<div class="form-group" style="font-size: 13px; color:black;">
					    			<div style="text-align: center;" class="col-sm-12">
						  				{!! Form::label('', 'Funding Org:', ['class' => 'control-label pull-left']) !!}
					    			</div> 
					    			<div class="col-sm-12">
						  				<select name="searchFundingOrg" class="form-control input-sm" id="searchFundingOrg">
											<option value="">All</option>
											@foreach($searchFundingOrgs as $searchFundingOrg)
											    <option value="{{$searchFundingOrg->id}}"@if($searchFundingOrg->id==$fundingOrgSelected){{"selected=selected"}}@endif>{{$searchFundingOrg->name}}</option>
											@endforeach 
						  				</select>
					    			</div>
								</div>
				  			</div>
						  	<div class="col-md-2">
								<div class="form-group" style="font-size: 13px; color:black;">
							    	<div style="text-align: center;" class="col-sm-12">
								  		{!! Form::label('', 'Product Ctg:', ['class' => 'control-label pull-left']) !!}
							    	</div> 
							    	<div class="col-sm-12">
								  		<select name="searchProductCtg" class="form-control input-sm" id="searchProductCtg">
											<option value="">All</option>
											@foreach($searchProductCtgs as $searchProductCtg)
											    <option value="{{$searchProductCtg->id}}" @if($searchProductCtg->id==$productCtgSelecteds){{"selected=selected"}}@endif>{{$searchProductCtg->shortName}}</option>
											@endforeach 
								  		</select>  
							    	</div>
								</div>
						  	</div>
						  	<div class="col-md-1">
								<div class="form-group" style="font-size: 13px; color:black;">
							    	<div style="text-align: center;" class="col-sm-12">
								  		{!! Form::label('', 'Product:', ['class' => 'control-label pull-left']) !!}
							    	</div> 
								    <div class="col-sm-12">
									  	<select name="searchProduct" class="form-control input-sm" id="searchProduct">
											<option value="">All</option>
											@foreach($searchProducts as $searchProduct)
											    <option value="{{$searchProduct->id}}" @if($searchProduct->id==$productSelected){{"selected=selected"}}@endif>{{$searchProduct->shortName}}</option>
											@endforeach 
									  	</select> 
								    </div>
								</div>
						  	</div>
						  	<div class="col-md-1">
								<div class="form-group" style="font-size: 13px; color:black;">
							    	<div style="text-align: center;" class="col-sm-12">
								  		{!! Form::label('startDate', 'Start Date:', ['class' => 'control-label pull-left']) !!}
							    	</div> 
								    <div class="col-sm-12">
									  	{!! Form::text('startDate',$startDateFromarte, ['class' => 'form-control', 'id' => 'startDate','readonly']) !!}
									 	<p id='startDatee' class="error" style="max-height:2px; color:red;"></p>
								    </div>
								</div>
						  	</div>
						  	<div class="col-md-1">
								<div class="form-group" style="font-size: 13px; color:black;">
							    	<div style="text-align: center;" class="col-sm-12">
								  		{!! Form::label('endDate', 'End Date:', ['class' => 'control-label pull-left','required']) !!}
							    	</div> 
								    <div class="col-sm-12">
									 	{!! Form::text('endDate',$endDateFromarte, ['class' => 'form-control', 'id' => 'endDate','readonly','required']) !!}
									 	<p id='endDatee' class="error" style="max-height:2px; color:red;"></p> 
								    </div>
								</div>
						  	</div>
						  	<div class="col-md-2">
								<div class="form-group" style="font-size: 13px; color:black;">
							    	<div style="text-align: center;" class="col-sm-12">
								  		{!! Form::label('', 'Loan Optaion:', ['class' => 'control-label pull-left']) !!}
							    	</div> 
								    <div class="col-sm-6">
									  	{!! Form::select('searchLoanProduct',['1'=>'Loan Product','2'=>'Loan Product Category'],$loanProductCategorySelected,['id'=>'searchLoanProduct','class'=>'form-control input-sm']) !!}
								    </div>
								</div>
						  	</div>
						  	<div class="col-md-1">
								<div class="form-group" style="font-size: 13px; color:black">
							    	<div class="col-sm-12" style="padding-top: 25px;">
								  		{!! Form::submit('Search',['id'=>'search','class'=>'btn btn-primary btn-xs','style'=>'font-size:15px;']) !!}
							    	</div>
								</div>
								{!! Form::close() !!}
						  	</div> 
			    		</div>  
					</div> {{--End Filtering Group --}}

						<h2 align="center" style="font-family: Antiqua;letter-spacing: 2px; color: white;margin-top: 0px;">Periodic Collection Component Wise Report</h2>
		  		</div>
	    		<div class="panel-body panelBodyView"></div>
  			</div> 
			<div id="printingContent">
			    <div style="display: none;text-align: center;" id="hiddenTitle">
			    	@php
			    		$companyId = DB::table('gnr_company')->select('name','address')->first();
			    	@endphp
				  	<h3 style="text-align: center;padding: 0px;margin: 0px;">{{$companyId->name}}</h3>

				  	<p style="text-align: center;padding: 0px;margin: 0px;font-size: 10px;">{{$companyId->address}}</p>

				  	<h4 style="text-align: center;padding: 0px;margin: 0px;">Periodic Collection Component Wise</h4>
			    </div>
			    <div id="hiddenInfo" style="display:none;">   
				  	<p style="padding: 0px;margin: 0px;font-size: 11px;">Branch Name :
						@php
						    $selectedBranchName =DB::table('gnr_branch')->where('id',$branchSelected)->value('name');
						    if($branchSelected==null){
							   echo "All";
						    }
						    else{
							 echo $selectedBranchName;
						    }
						@endphp 
				  	</p>
				  	<p style="padding: 0px;margin: 0px;font-size: 11px;">Branch Address :
						@php
						    $selectedBranchAddress =DB::table('gnr_branch')->where('id',$branchSelected)->value('address');
						    if($branchSelected==null){
							   	echo "All";
						    }
						    else{
							 	echo $selectedBranchAddress;
						    }
						@endphp  
				  	</p>
					<p style="padding: 0px;margin: 0px;font-size: 11px;">Component:
						@php
						    $componentProductCategory = DB::table('mfn_loans_product_category')->where('id',$productCtgSelecteds)->value('shortName');
						    
						    $componentProduct =DB::table('mfn_loans_product')->where('id',$productSelected)->value('shortName');
						    if($productSelected==null){
							  	if($productCtgSelecteds==null){
								 	echo "All";
							  	}
							  	else{
							     	echo $componentProductCategory;
							  	}
						    }
		                    else{
							  	if($productSelected==null){
								 	echo "All";
							  	}
							  	else{
							     	echo $componentProduct;
							  	}
						    }
						@endphp  
					</p> 
				  	<p style="padding: 0px;margin: 0px;font-size: 11px;">Reporting Date:
						@php
						    $reportingDate = $startDateFromarte .' To '. $endDateFromarte;
						    if($startDate!=null && $endDate!=null){
							   echo $reportingDate;
						    }
						@endphp 
						<span style='float:right;'>
						    Print Date: {{date("d-m-Y h:m a")}}
						</span> 
				  	</p>    
			    </div> 
	        <br>
			  @if($productId==1) 
				<div id="tableDiv" style="overflow:visible !important;">
				    <table id="periodicCollectionComponentWiseReport" class="table table-striped table-bordered" style="color:black;font-size:11px;margin-bottom:50px;border-collapse: collapse;  border= "1px solid black;" cellpadding="0" cellspacing="0">
						<thead valign="center">
							<tr>
							    <th colspan="2">Field Worker</th>
							    <th colspan="2">Samity</th>
							    <th rowspan="3" width="100px">Component</th>                        
							    <th colspan="{{count($savingsProducts)}}">Savings Collection</th>
							    <th colspan="{{count($savingsProducts)}}">Interest On Savings</th>
							    <th colspan="{{count($savingsProducts)}}">Savings Refund</th>
							    <th rowspan="3">Additional <br/>Fee<br/> Collection</th>
							    <th rowspan="3">Disbursement <br/> Amount</th>
							    <th rowspan="3">Regular <br/>Recoverable</th>
							    <th colspan="7">Loan Collection</th>
							    <th rowspan="3">Ins.<br/> Claim</th>
							</tr>
							<tr>
							    <th rowspan="2" width="60px">ID</th>
							    <th rowspan="2" width="70px">Name</th>
							    <th rowspan="2" width="60px">ID</th>
							    <th rowspan="2" width="70px">Name</th>
							    @foreach ($savingsProducts as $savingsProduct)
								   <th rowspan="2">{{$savingsProduct->shortName}}</th>                               
							    @endforeach

							    @foreach ($savingsProducts as $savingsProduct)
								   <th rowspan="2">{{$savingsProduct->shortName}}</th>                               
							    @endforeach

							    @foreach ($savingsProducts as $savingsProduct)
								   <th rowspan="2">{{$savingsProduct->shortName}}</th>                               
							    @endforeach
							    <th rowspan="2">Regular</th>
							    <th rowspan="2" width="60px;">Due</th>
							    <th rowspan="2">Advance</th>
							    <th rowspan="2">Rebate</th>
							    <th rowspan="1" colspan="3">
                                Total Collection</th>
							</tr>
							<tr>
							    <th rowspan="1">Loan Received <br/>(Principle)</th>
							    <th rowspan="1">Loan Received<br/>(Service Charge)</th>
							    <th rowspan="1">Total</th> 
							</tr>   
						</thead>

				    @if($serchingProductId !=null)    
					  	<tbody>
							@php
							    //fieldOfficer 
							    $curentFieldOficerId = isset($fieldOfficerIds[0]) ? $fieldOfficerIds[0] : 0;
							    //Total 
								$savingsDepositeTotal = array();
								$interestSavingTotal = array();
								$savingsRefundTotal = array();
								$additionalFeeCollectionTotal = 0;
								$disbusmentTotal = 0;
								$regularRecevableTotal = 0;
								$regularTotal = 0;
								$dueTotal = 0;
								$advancetotal = 0;
								$rebateTotal = 0;
								$loanReceivePrincipleTotal = 0;
								$loanReceiveServiceTotal   = 0;
								$totalTotal = 0;
								$insClimeTotal = 0;
								$fieldOfficerKey=0;
						    @endphp
							@foreach ($fieldOfficerIds as $fieldOfficerId)

							    @php
									$employeeId = DB::table('hr_emp_general_info')->where('id',$fieldOfficerId)->select('emp_id','emp_name_english')->first();

									$samityInfos = DB::table('mfn_samity')->where('branchId',$branchSelected)->where('fieldOfficerId',$fieldOfficerId)->whereIn('id',$allSamityUniqueArray)->select('name','id','code')->get();

									$sumLoanProduct = 0;

									foreach ($samityInfos as $samityId) {

										$fromCollectionNew = $fromCollection->where('samityIdFk',$samityId->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsDepositeNew = $fromSavingsDeposite->where('samityIdFk',$samityId->id)->pluck('primaryProductIdFk')->toArray();

						    			$fromLoanNew = $fromLoan->where('samityIdFk',$samityId->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsWithdrowNew = $fromSavingsWithdrow->where('samityIdFk',$samityId->id)->pluck('primaryProductIdFk')->toArray();

        								$loanProductFormSamity = array_unique(array_merge($fromCollectionNew,$fromSavingsDepositeNew,$fromLoanNew,$fromSavingsWithdrowNew));

        								$loanPro =$loanProductsName->whereIn('id',$loanProductFormSamity)->pluck('id')->toArray();

        								$keyProduct=0;
        								$sumLoanProduct  = $sumLoanProduct + count($loanPro);
									}

									$countRow = $sumLoanProduct;
									//Sub Total 
									$savingsDepositeSubTotal =array();
									$interestSavingSubTotal =array();
									$savingsRefundSubTotal =array();
									$additionalFeeCollectionSubTotal = 0;
									$disbusmentSubTotal = 0;
									$regularRecevableSubTotal = 0;
									$regularSubTotal = 0;
									$dueSubTotal = 0;
									$advanceSubtotal = 0;
									$rebateSubTotal = 0;
									$loanReceivePrincipleSubTotal = 0;
									$loanReceiveServiceSubTotal   = 0;
									$totalSubTotal = 0;
									$insClimeSubTotal = 0;
									$samityKey =0;
							    @endphp
						    	@foreach ($samityInfos as $samityInfo)
									@php
						    			$fromCollectionNew = $fromCollection->where('samityIdFk',$samityInfo->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsDepositeNew = $fromSavingsDeposite->where('samityIdFk',$samityInfo->id)->pluck('primaryProductIdFk')->toArray();

						    			$fromLoanNew = $fromLoan->where('samityIdFk',$samityInfo->id)->pluck('productIdFk')->toArray();
						    			$fromSavingsWithdrowNew = $fromSavingsWithdrow->where('samityIdFk',$samityInfo->id)->pluck('primaryProductIdFk')->toArray();

        								$loanProductsUniqueArray = array_unique(array_merge($fromCollectionNew,$fromSavingsDepositeNew,$fromLoanNew,$fromSavingsWithdrowNew));

        								$loanProducts =$loanProductsName->whereIn('id',$loanProductsUniqueArray)->pluck('id')->toArray();

        								$keyProduct = 0;

						    		@endphp
							  		@foreach ($loanProducts as $loanProduct)
										@php
											if ($curentFieldOficerId!= $fieldOfficerId) {
												$curentFieldOficerId = $fieldOfficerId;
												$officerChanged = 1;
											}
											else{
												$officerChanged = 0;
											}
											$productName= DB::table('mfn_loans_product')->where('id',$loanProduct)->value('shortName');
										@endphp
								@if($sumLoanProduct>0)
									<tr>
									 	@if(($fieldOfficerKey==0  && $samityKey==0 && $keyProduct==0) || ($officerChanged==1)) 
										  	<td rowspan="{{$countRow}}">{{$employeeId->emp_id}}</td>
										  	<td rowspan="{{$countRow}}">{{$employeeId->emp_name_english}}</td>
									 	@endif
									    <td> {{$samityInfo->code}} </td>
									    <td> {{$samityInfo->name}} </td>
									    <td> {{$productName}} </td>
									    @foreach ($savingsProducts as $key=>$savingsProduct)
										  	@php
												$savingDeposite = DB::table('mfn_savings_deposit')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('primaryProductIdFk',$loanProduct)->where('productIdFk',$savingsProduct->id)->where('depositDate','>=',$startDate)->where('depositDate','<=',$endDate)->sum('amount');

												if(isset($savingsDepositeSubTotal[$key])){
													$savingsDepositeSubTotal[$key]=$savingsDepositeSubTotal[$key]+$savingDeposite;
												}else{
													$savingsDepositeSubTotal[$key]= $savingDeposite;
												}

										 	@endphp
										  	<td class="amount">{{number_format($savingDeposite,2)}}</td>
									    @endforeach
									    @foreach($savingsProducts as $interestSavingKey=>$savingsProduct)
										  	@php
												$memberId = DB::table('mfn_member_information')->where('samityId',$samityInfo->id)->where('primaryProductId',$loanProduct)->value('id');

												$InterestSaving = DB::table('mfn_savings_interest')->where('memberIdFk',$memberId)->where('date','>=',$startDate)->where('date','<=',$endDate)->sum('interestAmount');

												if(isset($interestSavingSubTotal[$interestSavingKey])){
													$interestSavingSubTotal[$interestSavingKey]=$interestSavingSubTotal[$interestSavingKey]+$InterestSaving;
												}else{
													$interestSavingSubTotal[$interestSavingKey]= $InterestSaving;
												}

										  	@endphp    

										  	<td class="amount">{{number_format($InterestSaving,2)}}</td>
									    @endforeach

									    @foreach($savingsProducts as $savingRefundKey=>$savingsProduct)
										  	@php
												$savingWithdraw = DB::table('mfn_savings_withdraw')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('primaryProductIdFk',$loanProduct)->where('productIdFk',$savingsProduct->id)->where('withdrawDate','>=',$startDate)->where('withdrawDate','<=',$endDate)->sum('amount');

												if(isset($savingsRefundSubTotal[$savingRefundKey])){
													$savingsRefundSubTotal[$savingRefundKey]=$savingsRefundSubTotal[$savingRefundKey]+$savingWithdraw;
												}else{
													$savingsRefundSubTotal[$savingRefundKey]= $savingWithdraw;
												}
										  	@endphp    

										  	<td class="amount">{{number_format($savingWithdraw,2)}}</td> 
									    @endforeach
									    @php
									    	$disbusmentAmount = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('disbursementDate','>=',$startDate)->where('disbursementDate','<=',$endDate)->sum('loanAmount');
									    	
										  	$aditionalFree = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('disbursementDate','>=',$startDate)->where('disbursementDate','<=',$endDate)->sum('additionalFee');

										  	$loanId = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)
                                            ->where('productIdFk',$loanProduct)->value('id');

										  	$receivableAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('installmentAmount');

										  	$regularReceiveInstamentAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('isCompleted',0)->where('isPartiallyPaid',0)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('installmentAmount');

										  	$regularReceivePaidAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('isPartiallyPaid',1)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('installmentAmount');

										  	$regularReceivePaidAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('isPartiallyPaid',1)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('partiallyPaidAmount');

										  	$regularDueAmount = $regularReceivePaidAmount - $regularReceivePaidAmount;

										  	$regularReceiveCollection = DB::table('mfn_loan_collection')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('loanIdFk',$loanId)->where('collectionDate','>=',$startDate)->where('collectionDate','<=',$endDate)->sum('amount');

										  	$advance = $regularReceiveCollection - $receivableAmount ;
										  	if($advance<0){
												$advance = 0;
										  	}
										  	$dueAmount = $regularReceiveInstamentAmount + $regularDueAmount;
										  	if($dueAmount<0){
												$dueAmount = 0;
										  	}
										  	$receivePrincipleAmount = DB::table('mfn_loan_collection')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('loanIdFk',$loanId)->where('collectionDate','>=',$startDate)->where('collectionDate','<=',$endDate)->sum('principalAmount');

										  	$receiveServiceChargeAmount = DB::table('mfn_loan_collection')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('loanIdFk',$loanId)->where('collectionDate','>=',$startDate)->where('collectionDate','<=',$endDate)->sum('interestAmount');

										  	$totalAmount = $receivePrincipleAmount + $receiveServiceChargeAmount;

										  	$insurenceClime = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('disbursementDate','>=',$startDate)->where('disbursementDate','<=',$endDate)->sum('insuranceAmount');
										  	$loanRebates = DB::table('mfn_loan_rebates')->where('samityIdFk',$samityInfo->id)->where('primaryProductIdFk',$loanProduct)->where('date','>=',$startDate)->where('date','<=',$endDate)->sum('amount');
										  	

										  // Sub Total

										  	$additionalFeeCollectionSubTotal = $additionalFeeCollectionSubTotal + $aditionalFree;
										  	$disbusmentSubTotal = $disbusmentSubTotal + $disbusmentAmount;
										  	$regularRecevableSubTotal = $regularRecevableSubTotal + $receivableAmount;
										  	$regularSubTotal = $regularSubTotal + $regularReceiveCollection;
										  	$dueSubTotal = $dueSubTotal + $dueAmount;
										  	$advanceSubtotal = $advanceSubtotal + $advance;
										  	$rebateSubTotal = $rebateSubTotal + $loanRebates;
										  	$loanReceivePrincipleSubTotal = $loanReceivePrincipleSubTotal + $receivePrincipleAmount;
										  	$loanReceiveServiceSubTotal = $loanReceiveServiceSubTotal + $receiveServiceChargeAmount ;
											$totalSubTotal = $totalSubTotal + $totalAmount;
										    $insClimeSubTotal = $insClimeSubTotal + $insurenceClime;

									    @endphp

									    <td class="amount">{{number_format($aditionalFree,2)}}</td>
									    <td class="amount">{{number_format($disbusmentAmount,2)}}</td>
									    <td class="amount">{{number_format($receivableAmount,2)}}</td>
									    <td class="amount">{{number_format($regularReceiveCollection,2)}}</td>
									    <td class="amount">{{number_format($dueAmount,2)}}</td>
									    <td class="amount">{{number_format($advance,2)}}</td> 
									    <td class="amount">{{number_format($loanRebates,2)}}</td>
									    <td class="amount">{{number_format($receivePrincipleAmount,2)}}</td>
									    <td class="amount">{{number_format($receiveServiceChargeAmount,2)}}</td>  
									    <td class="amount">{{number_format($totalAmount,2)}}</td>
									    <td class="amount">{{number_format($insurenceClime,2)}}</td>
									</tr>
							
								@endif
									@php
							  			$keyProduct++;
							  		@endphp
							@endforeach
							  	@php
							  		$samityKey++;
							  	@endphp
						@endforeach
							@if(count($samityInfos) && $sumLoanProduct>0)
								<tr class="totalRow" style="background-color:#808080 !important;font-size: 12px;">
									<td colspan="5">Sub Total</td>
									@foreach ($savingsProducts as $key=>$savingsProduct)
										<td class="amount"> {{number_format($savingsDepositeSubTotal[$key],2)}}</td>
										@php
											if(isset($savingsDepositeTotal[$key])) {
									 			$savingsDepositeTotal[$key]=$savingsDepositeTotal[$key]+$savingsDepositeSubTotal[$key];
											}else{
										 		$savingsDepositeTotal[$key]=$savingsDepositeSubTotal[$key];
											}
										@endphp
									@endforeach
									@foreach ($savingsProducts as $interestSavingKey=>$savingsProduct)
											
										<td class="amount">{{number_format($interestSavingSubTotal[$interestSavingKey],2)}}</td>
										@php
											if(isset($interestSavingTotal[$interestSavingKey])) {
									 			$interestSavingTotal[$interestSavingKey]=$interestSavingTotal[$interestSavingKey]+$interestSavingSubTotal[$interestSavingKey];
											}else{
										 		$interestSavingTotal[$interestSavingKey]=$interestSavingSubTotal[$interestSavingKey];
											}
										@endphp
									@endforeach 
									@foreach ($savingsProducts as $savingRefundKey=>$savingsProduct)
										<td class="amount">{{number_format($savingsRefundSubTotal[$savingRefundKey],2)}}</td>
										@php
											if(isset($savingsRefundTotal[$savingRefundKey])) {
									 			$savingsRefundTotal[$savingRefundKey]=$savingsRefundTotal[$savingRefundKey]+$savingsRefundSubTotal[$savingRefundKey];
											}else{
										 		$savingsRefundTotal[$savingRefundKey]=$savingsRefundSubTotal[$savingRefundKey];
											}
										@endphp
									@endforeach
									<td class="amount">{{number_format($additionalFeeCollectionSubTotal,2)}}</td>
									<td class="amount">{{number_format($disbusmentSubTotal,2)}}</td>
									<td class="amount">{{number_format($regularRecevableSubTotal,2)}}</td>
									<td class="amount">{{number_format($regularSubTotal,2)}}</td>
									<td class="amount">{{number_format($dueSubTotal,2)}}</td>
									<td class="amount">{{number_format($advanceSubtotal,2)}}</td>
									<td class="amount">{{number_format($rebateSubTotal,2)}}</td>
									<td class="amount">{{number_format($loanReceivePrincipleSubTotal,2)}}</td>
									<td class="amount">{{number_format($loanReceiveServiceSubTotal,2)}}</td>
									<td class="amount">{{number_format($totalSubTotal,2)}}</td>
									<td class="amount">{{number_format($insClimeSubTotal,2)}}</td>
								</tr>
							@endif
		 					@php
						    //Total
						    $additionalFeeCollectionTotal = $additionalFeeCollectionTotal + $additionalFeeCollectionSubTotal;
						    $disbusmentTotal +=$disbusmentSubTotal;
						    $regularRecevableTotal += $regularRecevableSubTotal ;
						    $regularTotal +=$regularSubTotal;
						    $dueTotal +=$dueSubTotal;
						    $advancetotal +=$advanceSubtotal ;
						    $rebateTotal +=$rebateSubTotal;
						    $loanReceivePrincipleTotal +=$loanReceivePrincipleSubTotal ;
						    $loanReceiveServiceTotal   +=$loanReceiveServiceSubTotal;
						    $insClimeTotal +=$insClimeSubTotal;
						    $totalTotal +=$totalSubTotal;
						    if(count($samityInfos)>0){
						    	$fieldOfficerKey++;
						    }
						@endphp

						@endforeach 
						    <tr class="totalRow" style="background-color: #8d9096 !important;font-size: 12px;"> 
							    <td colspan="5" style="text-align:center; padding:10px;font-weight:bold; font-size:15px;">Total</td>
							    @foreach ($savingsProducts as $key=>$savingsProduct)
									@if(isset($savingsDepositeTotal[$key]))
									  	<td style="font-weight: bold;" class="amount">
									  		{{number_format($savingsDepositeTotal[$key],2)}}
									  	</td>
									@else 
										<td style="font-weight: bold;" class="amount">{{number_format(0,2)}}</td>
									@endif
							  	@endforeach    
							  	@foreach ($savingsProducts as $interestSavingKey=>$savingsProduct)
									@if(isset($interestSavingTotal[$interestSavingKey]))
										<td style="font-weight: bold;" class="amount">
											{{number_format($interestSavingTotal[$interestSavingKey],2)}}
										</td>
									@else
										<td style="font-weight: bold;" class="amount">{{number_format(0,2)}}</td>
									@endif	
							  	@endforeach    
							  	@foreach ($savingsProducts as $savingRefundKey=>$savingsProduct)
									@if(isset($savingsRefundTotal[$savingRefundKey]))
										<td style="font-weight: bold;" class="amount">
											{{number_format($savingsRefundTotal[$savingRefundKey],2)}}
										</td>
									@else
										<td style="font-weight: bold;" class="amount">{{number_format(0,2)}}</td>
									@endif	
							  	@endforeach
							  	<td style="font-weight: bold;" class="amount">{{number_format($additionalFeeCollectionTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($disbusmentTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($regularRecevableTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($regularTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($dueTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($advancetotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($rebateTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($loanReceivePrincipleTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($loanReceiveServiceTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($totalTotal,2)}}</td>
							  	<td style="font-weight: bold;" class="amount">{{number_format($insClimeTotal,2)}}</td>
						    </tr>
						</tbody>
					@endif
				</table>
			</div>                  
		@endif

					    @if($productId==2) 
						  <div id="tableDiv" style="overflow:visible !important;">
							<table id="periodicCollectionComponentWiseReport" class="table table-striped table-bordered" style="color:black;font-size:11px;margin-bottom:50px;border-collapse: collapse;" border= "1px solid black;" cellpadding="0" cellspacing="0">
							    <thead valign="center">
									<tr>
										<th colspan="2">Field Worker</th>
										<th colspan="2">Samity</th>
										<th rowspan="3" width="100px;">Component</th>
										<th colspan="{{count($savingsProducts)}}">Savings Collection</th>
										<th colspan="{{count($savingsProducts)}}">Interest On Savings</th>
										<th colspan="{{count($savingsProducts)}}">Savings Refund</th>
										<th rowspan="3">Additional <br/> Fee <br/> Collection</th>
										<th rowspan="3">Disbursement <br/> Amount</th>
										<th rowspan="3">Regular<br/> Recoverable</th>
										<th colspan="7">Loan Collection</th>
										<th rowspan="3">Ins.<br/> Claim</th>
									</tr>
									<tr>
										<th rowspan="2" width="60px">ID</th>
										<th rowspan="2" width="70px">Name</th>
										<th rowspan="2" width="60px">ID</th>
										<th rowspan="2" width="70px">Name</th>
										@foreach ($savingsProducts as $savingsProduct)
										    <th rowspan="2">{{$savingsProduct->shortName}}</th>
										@endforeach
										@foreach ($savingsProducts as $savingsProduct)
										    <th rowspan="2">{{$savingsProduct->shortName}}</th>
										@endforeach
										@foreach ($savingsProducts as $savingsProduct)
										    <th rowspan="2">{{$savingsProduct->shortName}}</th>
										@endforeach
										<th rowspan="2">Regular</th>
										<th rowspan="2" width="60px;">Due</th>
										<th rowspan="2">Advance</th>
										<th rowspan="2">Rebate</th>
										<th rowspan="1" colspan="3">Total Collection</th>
									</tr>
									<tr>
										<th rowspan="1">Loan Received<br/>(Principle)</th>
										<th rowspan="1">Loan Received <br/>(Service Charge)</th>
										<th rowspan="1">Total</th> 
									</tr>   
							    </thead>
							    <tbody>
								  	@php
									    $curentFieldOficerId = isset($fieldOfficerIds[0]) ? $fieldOfficerIds[0] : 0;
									//Total 
									    $savingsDepositeTotal = array();
									    $interestSavingTotal = array();
									    $savingsRefundTotal = array();
									    $additionalFeeCollectionTotal = 0;
									    $disbusmentTotal = 0;
									    $regularRecevableTotal = 0;
									    $regularTotal = 0;
									    $dueTotal = 0;
									    $advancetotal = 0;
									    $rebateTotal = 0;
									    $loanReceivePrincipleTotal = 0;
									    $loanReceiveServiceTotal   = 0;
									    $totalTotal = 0;
									    $insClimeTotal = 0;
									    $fieldOfficerKey=0;
								 	@endphp
								@if($serchingProductId !=null)   
								  	@foreach ($fieldOfficerIds as $fieldOfficerId)

							    @php
									$employeeId = DB::table('hr_emp_general_info')->where('id',$fieldOfficerId)->select('emp_id','emp_name_english')->first();

									$samityInfos = DB::table('mfn_samity')->where('branchId',$branchSelected)->where('fieldOfficerId',$fieldOfficerId)->whereIn('id',$allSamityUniqueArray)->select('name','id','code')->get();

									$sumLoanProduct = 0;

									foreach ($samityInfos as $samityId) {
										$fromCollectionNew = $fromCollection->where('samityIdFk',$samityId->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsDepositeNew = $fromSavingsDeposite->where('samityIdFk',$samityId->id)->pluck('primaryProductIdFk')->toArray();

						    			$fromLoanNew = $fromLoan->where('samityIdFk',$samityId->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsWithdrowNew = $fromSavingsWithdrow->where('samityIdFk',$samityId->id)->pluck('primaryProductIdFk')->toArray();

        								$loanProductFormSamity = array_unique(array_merge($fromCollectionNew,$fromSavingsDepositeNew,$fromLoanNew,$fromSavingsWithdrowNew));

        								$loanPro = $loanProductsName->whereIn('id',$loanProductFormSamity)->pluck('id')->toArray();

        								$keyProduct=0;

        								$sumLoanProduct  = $sumLoanProduct + count($loanPro);
									}
									$countRow = $sumLoanProduct;
									//Sub Total 
									$savingsDepositeSubTotal =array();
									$interestSavingSubTotal =array();
									$savingsRefundSubTotal =array();
									$additionalFeeCollectionSubTotal = 0;
									$disbusmentSubTotal = 0;
									$regularRecevableSubTotal = 0;
									$regularSubTotal = 0;
									$dueSubTotal = 0;
									$advanceSubtotal = 0;
									$rebateSubTotal = 0;
									$loanReceivePrincipleSubTotal = 0;
									$loanReceiveServiceSubTotal   = 0;
									$totalSubTotal = 0;
									$insClimeSubTotal = 0;
									$samityKey =0;
							    @endphp

						    	@foreach ($samityInfos as $samityInfo)
									@php
						    			$fromCollectionNew = $fromCollection->where('samityIdFk',$samityInfo->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsDepositeNew = $fromSavingsDeposite->where('samityIdFk',$samityInfo->id)->pluck('primaryProductIdFk')->toArray();

						    			$fromLoanNew = $fromLoan->where('samityIdFk',$samityInfo->id)->pluck('productIdFk')->toArray();

						    			$fromSavingsWithdrowNew = $fromSavingsWithdrow->where('samityIdFk',$samityInfo->id)->pluck('primaryProductIdFk')->toArray();

        								$loanProductsUniqueArray = array_unique(array_merge($fromCollectionNew,$fromSavingsDepositeNew,$fromLoanNew,$fromSavingsWithdrowNew));

        								$loanProducts =$loanProductsName->whereIn('id',$loanProductsUniqueArray)->pluck('id')->toArray();

        								$keyProduct=0;
						    		@endphp
							  		@foreach ($loanProducts as $loanProduct)
										@php
											if ($curentFieldOficerId!= $fieldOfficerId) {
												$curentFieldOficerId = $fieldOfficerId;
												$officerChanged = 1;
											}
											else{
												$officerChanged = 0;
											}
											$productName= DB::table('mfn_loans_product')->where('id',$loanProduct)->value('productCategoryId');

											$productCategory = DB::table('mfn_loans_product_category')->where('id',$productName)->value('shortName');
										@endphp
									@if($sumLoanProduct>0)	
									<tr>
									 	@if(($fieldOfficerKey==0  && $samityKey==0 && $keyProduct==0) || ($officerChanged==1)) 
										  	<td rowspan="{{$countRow}}">{{$employeeId->emp_id}}</td>
										  	<td rowspan="{{$countRow}}">{{$employeeId->emp_name_english}}</td>
									 	@endif
									    <td>{{$samityInfo->code}}</td>
									    <td>{{$samityInfo->name}}</td>
									    <td>{{$productCategory}}</td>

									    @foreach ($savingsProducts as $key=>$savingsProduct)
										  	@php
												$savingDeposite = DB::table('mfn_savings_deposit')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('primaryProductIdFk',$loanProduct)->where('productIdFk',$savingsProduct->id)->where('depositDate','>=',$startDate)->where('depositDate','<=',$endDate)->sum('amount');

												if(isset($savingsDepositeSubTotal[$key])){
													$savingsDepositeSubTotal[$key]=$savingsDepositeSubTotal[$key]+$savingDeposite;
												}else{
													$savingsDepositeSubTotal[$key]= $savingDeposite;
												}
										 	@endphp
										  	<td class="amount">{{number_format($savingDeposite,2)}}</td>
									    @endforeach
									    @foreach($savingsProducts as $interestSavingKey=>$savingsProduct)
										  	@php
												$memberId = DB::table('mfn_member_information')->where('samityId',$samityInfo->id)->where('primaryProductId',$loanProduct)->value('id');

												$InterestSaving = DB::table('mfn_savings_interest')->where('memberIdFk',$memberId)->where('date','>=',$startDate)->where('date','<=',$endDate)->sum('interestAmount');

												if(isset($interestSavingSubTotal[$interestSavingKey])){
													$interestSavingSubTotal[$interestSavingKey]=$interestSavingSubTotal[$interestSavingKey]+$InterestSaving;
												}else{
													$interestSavingSubTotal[$interestSavingKey]= $InterestSaving;
												}
										  	@endphp    

										  	<td class="amount">{{number_format($InterestSaving,2)}}</td>
									    @endforeach

									    @foreach($savingsProducts as $savingRefundKey=>$savingsProduct)
										  	@php
												$savingWithdraw = DB::table('mfn_savings_withdraw')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('primaryProductIdFk',$loanProduct)->where('productIdFk',$savingsProduct->id)->where('withdrawDate','>=',$startDate)->where('withdrawDate','<=',$endDate)->sum('amount');

												if(isset($savingsRefundSubTotal[$savingRefundKey])){
													$savingsRefundSubTotal[$savingRefundKey]=$savingsRefundSubTotal[$savingRefundKey]+$savingWithdraw;
												}else{
													$savingsRefundSubTotal[$savingRefundKey]= $savingWithdraw;
												}
										  	@endphp  
										  	<td class="amount">{{number_format($savingWithdraw,2)}}</td> 
									    @endforeach
									    @php
									    	$disbusmentAmount = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('disbursementDate','>=',$startDate)->where('disbursementDate','<=',$endDate)->sum('totalRepayAmount');

										  	$aditionalFree = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('disbursementDate','>=',$startDate)->where('disbursementDate','<=',$endDate)->sum('additionalFee');

										  	$loanId = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->value('id');

										  	$receivableAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('installmentAmount');

										  	$regularReceiveInstamentAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('isCompleted',0)->where('isPartiallyPaid',0)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('installmentAmount');

										  	$regularReceivePaidAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('isPartiallyPaid',1)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('installmentAmount');

										  	$regularReceivePaidAmount = DB::table('mfn_loan_schedule')->where('loanIdFk',$loanId)->where('isPartiallyPaid',1)->where('scheduleDate','>=',$startDate)->where('scheduleDate','<=',$endDate)->sum('partiallyPaidAmount');

										  	$regularDueAmount = $regularReceivePaidAmount - $regularReceivePaidAmount;

										  	$regularReceiveCollection = DB::table('mfn_loan_collection')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('loanIdFk',$loanId)->where('collectionDate','>=',$startDate)->where('collectionDate','<=',$endDate)->sum('amount');

										  	$advance = $regularReceiveCollection - $receivableAmount ;
										  	if($advance<0){
												$advance = 0;
										  	}
										  	$dueAmount = $regularReceiveInstamentAmount + $regularDueAmount;
										  	if($dueAmount<0){
												$dueAmount = 0;
										  	}
										  	$receivePrincipleAmount = DB::table('mfn_loan_collection')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('loanIdFk',$loanId)->where('collectionDate','>=',$startDate)->where('collectionDate','<=',$endDate)->sum('principalAmount');

										  	$receiveServiceChargeAmount = DB::table('mfn_loan_collection')->where('softDel',0)->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('loanIdFk',$loanId)->where('collectionDate','>=',$startDate)->where('collectionDate','<=',$endDate)->sum('interestAmount');

										  	$totalAmount = $receivePrincipleAmount + $receiveServiceChargeAmount;

										  	$insurenceClime = DB::table('mfn_loan')->where('samityIdFk',$samityInfo->id)->where('productIdFk',$loanProduct)->where('disbursementDate','>=',$startDate)->where('disbursementDate','<=',$endDate)->sum('insuranceAmount');

										  	$loanRebates = DB::table('mfn_loan_rebates')->where('samityIdFk',$samityInfo->id)->where('primaryProductIdFk',$loanProduct)->where('date','>=',$startDate)->where('date','<=',$endDate)->sum('amount');

										  // Sub Total
										  	$additionalFeeCollectionSubTotal = $additionalFeeCollectionSubTotal + $aditionalFree;
										  	$disbusmentSubTotal = $disbusmentSubTotal + $disbusmentAmount;
										  	$regularRecevableSubTotal = $regularRecevableSubTotal + $receivableAmount;
										  	$regularSubTotal = $regularSubTotal + $regularReceiveCollection;
										  	$dueSubTotal = $dueSubTotal + $dueAmount;
										  	$advanceSubtotal = $advanceSubtotal + $advance;
										  	$rebateSubTotal = $rebateSubTotal + $loanRebates;
										  	$loanReceivePrincipleSubTotal = $loanReceivePrincipleSubTotal + $receivePrincipleAmount;
										  	$loanReceiveServiceSubTotal   = $loanReceiveServiceSubTotal + $receiveServiceChargeAmount ;
											$totalSubTotal = $totalSubTotal + $totalAmount;
										    $insClimeSubTotal = $insClimeSubTotal + $insurenceClime;
									    @endphp
									    <td class="amount">{{number_format($aditionalFree,2)}}</td>
									    <td class="amount">{{number_format($disbusmentAmount,2)}}</td>
									    <td class="amount">{{number_format($receivableAmount,2)}}</td>
									    <td class="amount">{{number_format($regularReceiveCollection,2)}}</td>
									    <td class="amount">{{number_format($dueAmount,2)}}</td>
									    <td class="amount">{{number_format($advance,2)}}</td> 
									    <td class="amount">{{number_format($loanRebates,2)}}</td>
									    <td class="amount">{{number_format($receivePrincipleAmount,2)}}</td>
									    <td class="amount">{{number_format($receiveServiceChargeAmount,2)}}</td>  
									    <td class="amount">{{number_format($totalAmount,2)}}</td>
									    <td class="amount">{{number_format($insurenceClime,2)}}</td>
									</tr> 
								@endif
									@php
							  			$keyProduct++;
							  		@endphp
							@endforeach
							  	@php
							  		$samityKey++;
							  	@endphp
						@endforeach
							@if(count($samityInfos) && $sumLoanProduct>0)
								<tr class="totalRow" style="background-color:#808080 !important;font-size: 12px;">
									<td colspan="5">Sub Total</td>
									@foreach ($savingsProducts as $key=>$savingsProduct)
										<td class="amount"> {{number_format($savingsDepositeSubTotal[$key],2)}}</td> 
										@php
											if(isset($savingsDepositeTotal[$key])){
											 	$savingsDepositeTotal[$key]=$savingsDepositeTotal[$key]+$savingsDepositeSubTotal[$key];
											}else{
												$savingsDepositeTotal[$key]=$savingsDepositeSubTotal[$key];
											}
										@endphp
									@endforeach
									@foreach ($savingsProducts as $interestSavingKey=>$savingsProduct)
										<td class="amount"> {{number_format($interestSavingSubTotal[$interestSavingKey],2)}}</td>
										@php
											if(isset($interestSavingTotal[$interestSavingKey])){
									 			$interestSavingTotal[$interestSavingKey]=$interestSavingTotal[$interestSavingKey]+$interestSavingSubTotal[$interestSavingKey];
											}else{
										 		$interestSavingTotal[$interestSavingKey]=$interestSavingSubTotal[$interestSavingKey];
											}
										@endphp
									@endforeach 
									@foreach ($savingsProducts as $savingRefundKey=>$savingsProduct)
										<td class="amount">{{number_format($savingsRefundSubTotal[$savingRefundKey],2)}}</td>
										@php
											if(isset($savingsRefundTotal[$savingRefundKey])){
									 			$savingsRefundTotal[$savingRefundKey]=$savingsRefundTotal[$savingRefundKey]+$savingsRefundSubTotal[$savingRefundKey];
											}else{
										 		$savingsRefundTotal[$savingRefundKey]=$savingsRefundSubTotal[$savingRefundKey];
											}
										@endphp
									@endforeach
									<td class="amount">{{number_format($additionalFeeCollectionSubTotal,2)}}</td>
									<td class="amount">{{number_format($disbusmentSubTotal,2)}}</td>
									<td class="amount">{{number_format($regularRecevableSubTotal,2)}}</td>
									<td class="amount">{{number_format($regularSubTotal,2)}}</td>
									<td class="amount">{{number_format($dueSubTotal,2)}}</td>
									<td class="amount">{{number_format($advanceSubtotal,2)}}</td>
									<td class="amount">{{number_format($rebateSubTotal,2)}}</td>
									<td class="amount">{{number_format($loanReceivePrincipleSubTotal,2)}}</td>
									<td class="amount">{{number_format($loanReceiveServiceSubTotal,2)}}</td>
									<td class="amount">{{number_format($totalSubTotal,2)}}</td>
									<td class="amount">{{number_format($insClimeSubTotal,2)}}</td>
								</tr>
							@endif
			 				@php
							    //Total
							    $additionalFeeCollectionTotal = $additionalFeeCollectionTotal + $additionalFeeCollectionSubTotal;
							    $disbusmentTotal +=$disbusmentSubTotal;
							    $regularRecevableTotal += $regularRecevableSubTotal ;
							    $regularTotal +=$regularSubTotal;
							    $dueTotal +=$dueSubTotal;
							    $advancetotal +=$advanceSubtotal ;
							    $rebateTotal +=$rebateSubTotal;
							    $loanReceivePrincipleTotal +=$loanReceivePrincipleSubTotal ;
							    $loanReceiveServiceTotal   +=$loanReceiveServiceSubTotal;
							    $insClimeTotal +=$insClimeSubTotal;
							    $totalTotal +=$totalSubTotal;
							    if(count($samityInfos)>0){
							    	$fieldOfficerKey++;
							    }
							@endphp
						@endforeach 
							
						<tr class="totalRow" style="background-color: #8d9096 !important;font-size: 12px;"> 
							<td colspan="5" style="text-align:center; padding:10px;font-weight:bold; font-size:15px;">Total</td>
							@foreach ($savingsProducts as $key=>$savingsProduct)
								@if(isset($savingsDepositeTotal[$key]))
									<td style="font-weight: bold;" class="amount">{{number_format($savingsDepositeTotal[$key],2)}}</td>
								@else
									<td style="font-weight: bold;" class="amount">{{number_format(0,2)}}</td>
								@endif	 
							@endforeach    
							@foreach ($savingsProducts as $interestSavingKey=>$savingsProduct)
								@if(isset($interestSavingTotal[$interestSavingKey]))
									<td style="font-weight: bold;" class="amount">{{number_format($interestSavingTotal[$interestSavingKey],2)}}</td>
								@else
									<td style="font-weight: bold;" class="amount">{{number_format(0,2)}}</td>
								@endif	
							@endforeach    
							@foreach ($savingsProducts as $savingRefundKey=>$savingsProduct)
								@if(isset($savingsRefundTotal[$savingRefundKey]))
									<td style="font-weight: bold;" class="amount">{{number_format($savingsRefundTotal[$savingRefundKey],2)}}</td>
								@else
									<td style="font-weight: bold;" class="amount">{{number_format(0,2)}}</td>
								@endif	
							@endforeach
							<td style="font-weight: bold;" class="amount">{{number_format($additionalFeeCollectionTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($disbusmentTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($regularRecevableTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($regularTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($dueTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($advancetotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($rebateTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($loanReceivePrincipleTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($loanReceiveServiceTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($totalTotal,2)}}</td>
							<td style="font-weight: bold;" class="amount">{{number_format($insClimeTotal,2)}}</td>
						</tr>  	
						@endif	
					</tbody>
				</table>
			</div>   
		@endif
	</div>
<div>
</div>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript">
    $(document).ready(function() { 
	  	$("#searchBranch").change(function(){
			var searchBranch = $(this).val();
			var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/guk_bk/resources/views/microfin/reports/periodicCollectionComponentWiseReport/periodicCollectionComponentWiseReport.bladeBK23052018.php:960
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/microfin/reports/periodicCollectionComponentWiseReport/periodicCollectionComponentWiseReport.bladeBK23052018.php</b> on line <b>960</b><br />