@extends('layouts/microfin_layout')
@section('title', '| Member Details')
@section('content')
	<style type="text/css">
        #interestRateList > tbody > tr > td:last-child a {
        	padding: 0 3px;
        }
        #regularLoanEmploymentData thead tr th,
        #regularLoanEmploymentData tbody tr td,
        #regularLoanEmploymentData thead tr th,
        #regularLoanEmploymentData tbody tr th {
        	font-size: 11px;
		    text-align: left;
		    padding: 3px;
        }
        #regularLoanEmploymentData tbody tr th {
        	border: 1px solid #FFF;
		    background: #696969 !important;
		    border-bottom: 0 !important;
		    color: #FFF;
		    text-align: left;
        }
        .intCell {
        	text-align:right;
        	padding-right:5px;
        }

		.center {
			margin: auto;
			width: 175px;
			height: 200px;
			border: 3px solid #898a8c;
			padding: 4px;
		}
	</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">
					<div class="panel-options">
						<a href="{{ url('mfn/viewRegularLoan/') }}" class="btn btn-info pull-right addViewBtn">
							<i class="glyphicon glyphicon-plus-sign addIcon"></i>
							Regular Loan Lists
						</a>
					</div>
				</div>
				<div class="panel-body panelBodyView">
					<div class="row">
						<div class="col-md-1"></div>
						<div class="col-md-10">
							<table class="table table-striped table-bordered member-info">
								<thead>
									<tr>
										<th colspan="6">
											<strong>Pictures</strong>
										</th>
									</tr>
								</thead>
							</table>
						</div>
						<div class="col-md-1"></div>
					</div>
					<div class="row">
						<div class="col-md-1"></div>
						<div class="col-md-5">
							{{-- <div class="well">

							</div> --}}
							<table class="table table-striped table-bordered member-info" >
								<tbody>
									<tr>
										<td style="font-size: 14px;">Member Picture :</td>
										<td style="padding-right:150px !important;">
											@if ($damageData['memberProfilePicture'] != '')
												<img id="guarantorImagePreview" src="{{ asset($damageData['memberProfilePicture']) }}"  class="img-responsive img-rounded full-width center">
											@else
												<img id="guarantorImagePreview" src="{{ asset('images/image-4.jpg') }}"  class="img-responsive img-rounded full-width center">
											@endif
										</td>
									</tr>
								</tbody>
							</table>
						</div>

						<div class="col-md-5">
							{{-- <div class="well">

							</div> --}}
							<table class="table table-striped table-bordered member-info" >
								<tbody>
									<tr>
										<td style="font-size: 14px;">Guarantor Picture : </td>
										<td style="padding-right:175px !important;">
											@if ($damageData['memberGuarantorPicture'] != '')
												<img id="guarantorImagePreview" src="{{ asset($damageData['memberGuarantorPicture']) }}"  class="img-responsive img-rounded full-width center">
											@else
												<img id="guarantorImagePreview" src="{{ asset('images/image-4.jpg') }}"  class="img-responsive img-rounded full-width center">
											@endif
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div class="col-md-1"></div>
					</div>

					<div class="row">
						<div class="col-md-1"></div>
						<div class="col-md-10">
							<table class="table table-striped table-bordered member-info">
								<thead>
									<tr>
										<th colspan="6">
											<strong>Signature</strong>
										</th>
									</tr>
								</thead>
							</table>
						</div>
						<div class="col-md-1"></div>
					</div>

					<div class="row">
						<div class="col-md-1"></div>
						<div class="col-md-5">
							{{-- <div class="well">

							</div> --}}
							<table class="table table-striped table-bordered member-info" >
								<tbody>
									<tr>
										<td style="font-size: 14px;">Member NID Signature :</td>
										<td style="padding-right:150px !important;">
											@if ($damageData['memberNidPicture'] != '')
												<img id="guarantorImagePreview" src="{{ asset($damageData['memberNidPicture']) }}"  class="img-responsive img-rounded full-width center">
											@else
												<img id="guarantorImagePreview" src="{{ asset('images/image-4.jpg') }}"  class="img-responsive img-rounded full-width center">
											@endif
										</td>
									</tr>
								</tbody>
							</table>
						</div>

						<div class="col-md-5">
							{{-- <div class="well">

							</div> --}}
							<table class="table table-striped table-bordered member-info" >
								<tbody>
									<tr>
										<td style="font-size: 14px;">Guarantor NID Signature : </td>
										<td style="padding-right:175px !important;">
											@if ($damageData['memberGuarantorNidPicture'] != '')
												<img id="guarantorImagePreview" src="{{ asset($damageData['memberGuarantorNidPicture']) }}"  class="img-responsive img-rounded full-width center">
											@else
												<img id="guarantorImagePreview" src="{{ asset('images/image-4.jpg') }}"  class="img-responsive img-rounded full-width center">
											@endif
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div class="col-md-1"></div>
					</div>

					<div class="row">
						<div class="col-md-10 col-md-offset-1">
							<table class="table table-striped table-bordered member-info">
								<thead>
									<tr>
										<th colspan="6">
											<strong>Loan Information</strong>
										</th>
									</tr>
								</thead>
								<tbody>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['loanId'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loanCode'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['product'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['productIdFk'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['memberName'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['memberInfoOB']->name . '&nbsp;' .'(' . $damageData['regularLoanDetail']['memberInfoOB']->code .')' }}</td>
										<td>{{ $damageData['loanDetailsTCN']['loanCycle'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loanCycle'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['fatherSpouseName'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['memberInfoOB']->spouseFatherSonName }}</td>
										<td>{{ $damageData['loanDetailsTCN']['paymentMode'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['paymentTypeIdFk'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['age'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['memberInfoOB']->age . '&nbsp;' . 'Years' }}</td>
										<td>{{ $damageData['loanDetailsTCN']['mobileNo'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['memberInfoOB']->mobileNo }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['samity'] }}</td>
										<td>{!! $damageData['regularLoanDetail']['samityName'] . '&nbsp;' .'(' . $damageData['regularLoanDetail']['samityCode'] . ')' . '<br/>' . $damageData['regularLoanDetail']['samityDay']  !!}</td>
										<td>{{ $damageData['loanDetailsTCN']['transferDate'] }}</td>
										<td></td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['disbursementDate'] }}</td>
										<td>{{ $damageData['MicroFinance']->getMicroFinanceDateFormat($damageData['regularLoanDetail']['disbursementDate']) }}</td>
										<td>{{ $damageData['loanDetailsTCN']['dueAmount'] }}</td>
										<td>{{--{{ $damageData['openingBalanceDetails']->dueAmountOB }}--}}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['firstRepayDate'] }}</td>
										<td>{{ $damageData['MicroFinance']->getMicroFinanceDateFormat($damageData['regularLoanDetail']['firstRepayDate']) }}</td>
										<td>{{ $damageData['loanDetailsTCN']['advanceAmount'] }}</td>
										<td>-</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['interestRate'] }}</td>
										<td>{{ sprintf("%.2f", $damageData['regularLoanDetail']['interestRate']) . '&nbsp;' . '%' . '&nbsp;' . $damageData['regularLoanDetail']['interestRateIndex'] . '&nbsp;' . '(' . $damageData['regularLoanDetail']['interestCalculationMethod'] . ')' }}</td>
										<td>{{ $damageData['loanDetailsTCN']['recoveryAmount'] }}</td>
										<td>-</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['extraInstallmentAmount'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['extraInstallmentAmount'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['openingLoanOutstanding'] }}</td>
										<td>{{--{{ sprintf("%.2f", $damageData['regularLoanDetail']['totalRepayAmount'] - $damageData['openingBalanceDetails']->paidLoanAmountOB) }}--}}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['currentStatus'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['isLoanCompleted']==0?'Active':'Closed' }}</td>
										<td>{{ $damageData['loanDetailsTCN']['rebate'] }}</td>
										<td>-</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['repaymentFrequency'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['repaymentFrequencyIdFk'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['loanOutstanding'] }}</td>
										@php
											// if ($damageData['regularLoanDetail']['totalCollectionAmount'] <= $damageData['regularLoanDetail']['totalRepayAmount']) {
											// 	$totalOutstanding = $damageData['regularLoanDetail']['totalRepayAmount'] - $damageData['regularLoanDetail']['totalCollectionAmount'];
											// }

											// changed on 10-01-2021
											// $totalOutstanding = 0;
											// if ($damageData['totalCollectionForLoan'] <= $damageData['regularLoanDetail']['totalRepayAmount']) {
											// 	$totalOutstanding = $damageData['regularLoanDetail']['totalRepayAmount'] - $damageData['totalCollectionForLoan'];
											// }

											// changed on 28-02-2021
											$totalOutstanding = $damageData['regularLoanDetail']['loanAmount'] - $damageData['totalCollectionPrincipalAmount'];
										@endphp
										<td>{{ sprintf("%.2f", $totalOutstanding) }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['interestMode'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['interestMode'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['loanAmount'] }}</td>
										<td>{{ sprintf("%.2f", $damageData['regularLoanDetail']['loanAmount']) }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['loan_purpose_level_1'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loan_purpose_level_1'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['loan_purpose_level_2'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loan_purpose_level_2'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['loan_purpose_level_3'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loan_purpose_level_3'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['loan_purpose_level_4'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loan_purpose_level_4'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['interestAmount'] }}</td>
										<td>{{ sprintf("%.2f", $damageData['regularLoanDetail']['interestAmount']) }}</td>
										<td>{{ $damageData['loanDetailsTCN']['guarantorNameFirst'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['firstGuarantorName'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['totalRepayAmount'] }}</td>
										<td>{{ sprintf("%.2f", $damageData['regularLoanDetail']['totalRepayAmount']) }}</td>
										<td>{{ $damageData['loanDetailsTCN']['guarantorRelationshipFirst'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['firstGuarantorRelation'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['installmentNum'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['repaymentNo'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['guarantorAddressFirst'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['firstGuarantorAddress'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['loanPeriodInMonth'] }}</td>
										{{-- <td>{{ $damageData['regularLoanDetail']['loanRepayPeriodIdFk'] }}</td> --}}
										<td></td>
										<td>{{ $damageData['loanDetailsTCN']['guarantorNameSecond'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['secondGuarantorName'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['loanApplicationNo'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['loanApplicationNo'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['guarantorRelationshipSecond'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['secondGuarantorRelation'] }}</td>
									</tr>
									@php
										// dd($damageData['regularLoanDetail']);
									@endphp
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['insuranceGuarantorAmount'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['insuranceAmount'] }}</td>
										<td>{{ $damageData['loanDetailsTCN']['guarantorAddressSecond'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['secondGuarantorAddress'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['loanClosingDate'] }}</td>
										<td>@if($damageData['regularLoanDetail']['loanCompletedDate'] != '0000-00-00') {{  date('d-m-Y', strtotime($damageData['regularLoanDetail']['loanCompletedDate'])) }} @endif</td>
										<td>{{ $damageData['loanDetailsTCN']['transferOutDate'] }}</td>
										<td>-</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['installmentAmount'] }}</td>
										<td>{!! sprintf("%.2f", $damageData['regularLoanDetail']['installmentAmount']) . ' Taka' . '<br/>' . sprintf("%.2f", $damageData['regularLoanDetail']['actualInstallmentAmount']) . ' (actual)' . ' + ' . sprintf("%.2f", $damageData['regularLoanDetail']['extraInstallmentAmount']) . ' (extra)' . ' * ' . ($damageData['regularLoanDetail']['repaymentNo']-1) . ' (no. of installment)' . '<br/>' . ' + ' . sprintf("%.2f", ($damageData['regularLoanDetail']['totalRepayAmount'] - (sprintf("%.2f", $damageData['regularLoanDetail']['installmentAmount']) * ($damageData['regularLoanDetail']['repaymentNo']-1)))) . ' (last installment amount)' !!}</td>
										<td>{{ $damageData['loanDetailsTCN']['folioNumber'] }}</td>
										<td>{{ $damageData['regularLoanDetail']['folioNum'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['additionalFee'] }}</td>
										<td>{{ sprintf("%.2f", $damageData['regularLoanDetail']['additionalFee']) }}</td>
										<td>{{ $damageData['loanDetailsTCN']['loanFormFee'] }}</td>
										<td>{{ sprintf("%.2f", $damageData['regularLoanDetail']['loanFormFee']) }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['payment'] }}</td>
										<td colspan="3">{{ $damageData['regularLoanDetail']['paymentTypeIdFk'] }}</td>
									</tr>
									<tr>
										<td>{{ $damageData['loanDetailsTCN']['employment'] }}</td>
										<td colspan="3">
											<table width="100%">
												<tbody>
													<tr>
														<td>Self: {{ $damageData['regularLoanDetail']['isSelfEmployment'] }}</td>
													</tr>
													<tr>
														<td>
															<table width="100%" id="regularLoanEmploymentData">
																<thead>
																	<tr>
																		<th width="25%"></th>
																		<th>Family</th>
																		<th>Wages Based</th>
																		<th>Wage (Per Month)</th>
																	</tr>
																</thead>
																<tbody>
																	<tr>
																		<th>Full Time Male</th>
																		<td>0</td>
																		<td>0</td>
																		<td>0</td>
																	</tr>
																	<tr>
																		<th>Full Time Female</th>
																		<td>0</td>
																		<td>0</td>
																		<td>0</td>
																	</tr>
																	<tr>
																		<th>Part Time Male</th>
																		<td>0</td>
																		<td>0</td>
																		<td>0</td>
																	</tr>
																	<tr>
																		<th>Part Time Female</th>
																		<td>0</td>
																		<td>0</td>
																		<td>0</td>
																	</tr>
																</tbody>
															</table>
														</td>
													</tr>
												</tbody>
											</table>
										</td>
									</tr>
								</tbody>
							</table>
							<div style="height:20px"></div>
							<table class="table table-striped table-bordered view" id="interestRateList">
								<thead>
									<tr>
										<th colspan="10" style="text-align:left">
											<strong>Loan Schedule</strong>
										</th>
									</tr>
									<tr>
										<th rowspan="2">#</th>
										<th rowspan="2">Date</th>
										<th rowspan="2">Samity Day</th>
										<th colspan="3">Amount</th>
										<th width="100" rowspan="2">Principal Amount (P)</th>
										<th width="100" rowspan="2">Interest Amount (I)</th>
										<th width="100" rowspan="2">Transaction Amount</th>
										<th rowspan="2">Status</th>
				                    </tr>
				                    <tr>
				                    	<th width="120">AcItual Amount</th>
				                    	<th width="120">Extra Amount</th>
				                    	<th width="120">Installment Amount</th>
				                    </tr>
								</thead>
								<tbody>
									@php
										$i=0;
									@endphp

									@foreach($damageData['loanSchedules'] as $loanSchedule)
										<tr>
											<td>{{ $loanSchedule->installmentSl }}</td>
											<td>{{ $damageData['MicroFinance']->getMicroFinanceDateFormat($loanSchedule->scheduleDate) }}</td>
											<td>{{ date('l', strtotime($loanSchedule->scheduleDate)) }}</td>
											<td class="intCell">{{ sprintf("%.2f", $loanSchedule->actualInstallmentAmount) }}</td>
											<td class="intCell">{{ sprintf("%.2f", $loanSchedule->extraInstallmentAmount) }}</td>
											<td class="intCell">{{ sprintf("%.2f", $loanSchedule->installmentAmount) }}</td>
											<td class="intCell">{{ sprintf("%.2f", $loanSchedule->principalAmount) }}</td>
											<td class="intCell">{{ sprintf("%.2f", $loanSchedule->interestAmount) }}</td>
											<td></td>
											<td>
												@if($loanSchedule->isCompleted==1)
													<i class="fa fa-check" aria-hidden="true"></i>
												@elseif($loanSchedule->isPartiallyPaid==1)
													P
												@elseif($i<=1)
													@php
														$i=1;
													@endphp

													{{-- <a style="color:#000;" href="{{ url('regularLoanReschedule/'.$damageData['regularLoanDetails']->id.'/'.$loanSchedule->installmentSl) }}">
														<i style="font-size:15px;" class="fa fa-plus-circle" aria-hidden="true"></i>
														Reschedule
													</a> --}}

													<a style="color:#000;" href="{{ url('rescheduleRegularLoan/'.$damageData['regularLoanDetails']->id.'/'.$loanSchedule->scheduleDate) }}">
														<i style="font-size:15px;" class="fa fa-plus-circle" aria-hidden="true"></i>
														Reschedule
													</a>

													@php
														$i+=1;
													@endphp
												@endif
											</td>
										</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
@endsection