@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
								$sumMemberInterest = 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) 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
										$sumMemberInterest += $monthsInterest;
									@endphp
								@endforeach  {{-- balance info loop close --}}

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

		e.preventDefault();
		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.reload();

					}, 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");
		});

	});
});

</script>

@endsection