@extends('layouts/microfin_layout')
@section('title', '| Auto Savings Interest Calculation')
@section('content')

<style type="text/css">

table tbody tr td {
	font-size: 11px;
}
.table thead tr th{
	border-bottom: 1px solid #FFF !important;
}
table > tbody > tr > td:last-child a {
	padding: 0 5px;
}
.week-day td {
	background-color: #696969;
	color: #fff;
	font-size: 1.1em;
}
.week-day{
	border: 1px solid #fff;
}
.fa-chevron-circle-right{
	color: green;
	font-size: 1.3em;
}
.interest-div{
	display: none;
}
.amount{
	position: relative;
}
.amount:hover{
	cursor: pointer;
}
.amount:hover .interest-div{
	display: inline-block;
	padding: 5px;
	background-color: green;
	border: 1px solid #222;
	color: #fff;
	text-align: left;
	z-index: 1;
	position: absolute;
	left: 50%;
	top: 20px;
	width: 90px;
}
.total-amount {
	padding-right: 5px !important;
	text-align: right !important;
}
.withdraw{
	text-align: center !important;
	background-color: #696969;
	color: #fff;
}

.btn-container{
	margin-top: 15px;
}
.btn-container .btn{
	width: auto;
}
.btn-danger{
	background-color: #2c2e2f !important;
}

</style>

<div class="row">
	<div class="col-md-12">
		<div class="panel panel-default" style="background-color:#708090;">
			<div class="panel-heading" style="padding-bottom:0px">
				<h3 style="font-family: Antiqua;letter-spacing: 2px;"><font color="white">Samity: {{ $samityName }}</font></h3>
			</div>
			<div class="panel-body panelBodyView">

				<table class="table table-striped table-bordered" id="HrEmployee" style="color:black;">
					<thead>
						<tr>
							<th rowspan="2">SL#</th>
							<th rowspan="2">Member Code</th>
							<th rowspan="2">Member Name</th>
							<th rowspan="2">F/S Name</th>
							<th rowspan="2">Savings Code</th>
							<th colspan="12" rowspan="1">
								@if ($route == 'viewAutoInterestSavingsDetails')
									<span>Monthly Balance</span>
								@elseif ($route == 'viewAutoInterestSavingsInterest')
									<span>Monthly Interest</span>
								@endif
							</th>
							<th rowspan="2" style="@if ($route != 'viewAutoInterestSavingsInterest') display: none; @endif">Total</th>
						</tr>
						<tr>
							@foreach ($monthsArr as $key => $value)
								<th rowspan="1">{{ date('Y-m', strtotime($value)) }}</th>
							@endforeach
						</tr>
					</thead>
					<tbody>
						@php
						$sl = 1;
						$totalInterest = 0;
						$sumMonthlybalance = 0;
						$sumMonthsInterest = 0;
						@endphp
						 @foreach ($members as $key => $member) {{-- member loop --}}
							@php

								$savAccIds = $closingBalance->where('memberId', $member->id)->unique('savingsAccId')->pluck('savingsAccId')->toArray();
								// dd($savAccIds);
							@endphp
							@foreach ($savAccIds as  $savAccId)
								@php
									$sumAccountInterest = 0;
								@endphp
								<tr>
									<td class="slNo">{{ $sl++ }}</td>
									<td style="padding: 3px 5px;">{{ $member->code }}</td>
									<td style="text-align: left; padding: 3px 5px;">{{ $member->name }}</td>
									<td style="text-align: left; padding: 3px 5px;">{{ $member->spouseFatherSonName }}</td>
									<td>{{ $savingsProduct->shortName }}</td>
									@foreach ($closingBalance->where('memberId', $member->id)->where('savingsAccId', $savAccId) as $key => $value)  {{-- balance info loop --}}

										@php  // apply withdraw condition
											if ($value['withdraw'] == 0) {
												$monthsInterest = $value['monthsInterest'];
												$averageBalance = $value['averageBalance'];
											} else {
												$monthsInterest = 0;
												$averageBalance = 0;
											}
										@endphp

										{{-- savings average balance view  --}}
										@if ($route == 'viewAutoInterestSavingsDetails')

											@if ($value['withdraw'] == 0)
												<td class="amount">{{ number_format($averageBalance, 2) }}
													<span class="interest-div">Interest: {{ number_format($monthsInterest, 2) }}</span>
												</td>
											@else
												<td class="amount withdraw"><span> - </span>
													<span class="interest-div">Due to Savings Withdraw</span>
												</td>
											@endif

										{{-- savings interest view  --}}
										@elseif($route == 'viewAutoInterestSavingsInterest')

											@if ($value['withdraw'] == 0)
												<td class="amount">{{ number_format($monthsInterest, 2) }}</td>
											@else
												<td class="amount withdraw"><span> - </span>
													<span class="interest-div">Due to Savings Withdraw</span>
												</td>
											@endif
										@endif
										@php
											// members total interest
											$sumAccountInterest += $monthsInterest;
										@endphp
									@endforeach  {{-- balance info loop close --}}

									<td class="amount" style="@if ($route != 'viewAutoInterestSavingsInterest') display: none; @endif">
										{{ number_format($sumAccountInterest, 2) }}
									</td>
								</tr>
								@php
									// all members total interest
									$totalInterest += $sumAccountInterest;
								@endphp
							@endforeach


						@endforeach  {{-- member loop close --}}
					</tbody>

					<thead>  {{-- total informations row --}}
						<tr>
							<th colspan="5" class="text-center">Total</th>

							@foreach ($monthsArr as $key => $month)  {{-- months loop --}}
								@php
								$sumMonthlyBalance = 0;
								$sumMonthlyInterest = 0;
								@endphp
								@foreach ($closingBalance->where('month', $month) as $key => $value)  {{-- balance info loop --}}
									@php  // apply withdraw condition
										if ($value['withdraw'] == 0) {
											$averageBalance = $value['averageBalance'];
											$monthsInterest = $value['monthsInterest'];
										} else {
											$averageBalance = 0;
											$monthsInterest = 0;
										}

										// total Monthly balance and interest
										$sumMonthlyBalance += $averageBalance;
										$sumMonthlyInterest += $monthsInterest;
									@endphp
								@endforeach  {{-- balance info loop close --}}

							 	{{-- checking route --}}
								@if ($route == 'viewAutoInterestSavingsDetails')
									<th class="total-amount">{{ number_format($sumMonthlyBalance, 2) }}</th>
								@elseif ($route == 'viewAutoInterestSavingsInterest')
									<th class="total-amount">{{ number_format($sumMonthlyInterest, 2) }}</th>
								@endif
							@endforeach  {{-- months loop close --}}

							{{-- samity total interest --}}
							<th rowspan="2" style="text-align: right; padding-right: 5px; @if ($route != 'viewAutoInterestSavingsInterest') display: none; @endif">
								{{ number_format($totalInterest, 2) }}
							</th>
						</tr>
					</thead>
				</table>
			</div>
			{{-- buttons --}}
			<div class="text-right btn-container">

				@if ($route == 'viewAutoInterestSavingsDetails')

					<a href="{{ url('viewAutoInterestSavingsInterest/'.$samityId.'/'.$savingsProductId) }}" class="btn btn-danger previewButton">Preview</a>
					<a href="{{ url('viewMfnSavingsSamityList') }}" class="btn btn-danger backButton">Back</a>

				@elseif ($route == 'viewAutoInterestSavingsInterest')

					{!! Form::open(array('url' => '', 'role' => 'form', 'id' => 'saveInterestForm', 'method'=>'post')) !!}
					{{-- {{ Form::hidden('interestData', implode(' ', $dataForTable)) }} --}}
					<span @if ($isSaved) style="display: none;" @endif>
						{!! Form::submit('Save', ['id' => 'saveInterest', 'class' => 'btn btn-danger saveButton', ]); !!}
					</span>
					<a href="{{ url('viewAutoInterestSavingsDetails/'.$samityId.'/'.$savingsProductId) }}" class="btn btn-danger backButton">Back</a>
					<a href="{{ url('viewMfnSavingsSamityList') }}" class="btn btn-danger backButton">Back to Samity</a>

					{!! Form::close() !!}
				@endif

			</div>
		</div>
	</div>
</div>

<script type="text/javascript">

$(document).ready(function() {

	$('.saveButton').on('click', function(e) {

		@if ($isSaveAllowed == 0)
			alert('Interest can be saved only on last day of current fiscal year.');
			return false;
		@else
			e.preventDefault();
			$(this).prop("disabled", true);
			var samityId = {{ $samityId }};
			var savingsProductId = {{ $savingsProductId }};

			$.ajax({
			   url: '{{ url('saveAutoSavingsInterest/') }}',
			   type: 'POST',
			   data: {samityId: samityId, savingsProductId: savingsProductId},
			   dataType: 'json',
			})
			.done(function(data) {
				// alert('hello');

				if (data.responseTitle=='Success!') {
					toastr.success(data.responseText, data.responseTitle, opts);
						setTimeout(function(){
							// alert('hello');
							window.location.href = '{{ url('viewMfnSavingsSamityList/') }}';

						}, 2000);
				}
				else if(data.responseTitle=='Warning!'){
					toastr.warning(data.responseText, data.responseTitle, opts);
					setTimeout(function(){
						// alert('hello');
						window.location.reload();

					}, 2000);
				}
				$('#myModal').modal('hide');
			})
			.fail(function() {
			   alert("error");
			});
		@endif

	});
});

</script>

@endsection