@extends('layouts.app')

@section('title', 'Loan')

@section('content')	
<!--start page wrapper -->
<div class="page-wrapper">
	<div class="page-content">
		<!--breadcrumb-->
		<div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
			<div class="ps-3">
				<nav aria-label="breadcrumb">
					<ol class="breadcrumb mb-0 p-0">
						<li class="breadcrumb-item"><a href="{{ route('home') }}"><i class="fas fa-home"></i></a>
						</li>
						<li class="breadcrumb-item active" aria-current="page">Add Guarantor</li>
                        
					</ol>
                    <br>
                    <div>
                        <a href="{{ route('guarantor.list') }}">
                        <i class="fas fa-arrow-circle-left">  </i>My Guarantors</a>

                    </div>
				</nav>
			</div>
			<div class="ms-auto">

			</div>
		</div>
		<!--end breadcrumb-->
		<hr />
		
		
		@if($errors->any())
		<script>
			Swal.fire('Error', 'Please fix the validation errors', 'error');
		</script>        
    	@elseif(session('success'))
		<div class="alert alert-success" role="alert">
			{{ session('success') }}
		</div>
		@endif

		<div class="row">
			<div class="col-xl-12 mx-auto">
				<div class="card border-top border-0 border-4 border-primary">
					<div class="card-body">
						<div class="p-4 border rounded">
							
							<form action="{{ route('guarantor.store', $loan->id) }}" method="post" enctype="multipart/form-data">
									
								@csrf									
								   Add guarantors to Loan ID:  {{$loan->loan_no}}, with Loan Amount Ksh. {{number_format($loan->applied_amount)}} <br>
								   Amount to be guaranteed is Ksh. {{number_format($loan->guarantee_balance)}}
								   <br> 
								   <div id="guarantee-amount-info"></div>
								   <div id="additional-guarantors">
									<div class="row mb-3">
										<div class="col-md-6">
											<label for="member-select">Select Guarantor<sup><i class='fas fa-asterisk' style='font-size:7px;color:red'></i></sup></label>
											<select class="form-control @error('user_id') is-invalid @enderror" id="user_id" name="guarantors[0][user_id]" required>
												<option selected disabled value="">Choose Member...</option>
												@foreach($users as $user)
													@php
													$shares = DB::table('shares')
																->join('accounts', 'shares.account_id', '=', 'accounts.id')
																->join('account_types', 'accounts.account_type_id', '=', 'account_types.id')
																->where('accounts.user_id', $user->id)
																->where('account_types.type', 'BOSA')
																->select('shares.*')
																->get();
												
												$pendingLoans = DB::table('loans')
																->join('guarantors', 'loans.id', '=', 'guarantors.loan_id')
																->where('guarantors.user_id', $user->id)
																->where('loans.loan_status', 'pending')
																->where('guarantors.guarantee_status', 'pending')
																->select('loans.*')
																->get();
												

												$hasApprovedRequest = DB::table('guarantors')
																->where('id', $user->id)
																->where('guarantee_status', 'approved')
																->whereIn('loan_id', $pendingLoans->pluck('id'))
																->exists();
											@endphp

												@if($shares->count() > 0 && $pendingLoans->count() >= 0 && !$hasApprovedRequest)
												<option value="{{ $user->id }}">{{ $user->fname }} {{ $user->lname }}</option>
												@endif
												@endforeach
											</select>
											@error('user_id')
												<span class="invalid-feedback" role="alert">
													<strong>{{ $message }}</strong>
												</span>
											@enderror
										</div>
										<div class="col-md-5">
											<label for="guarantee_amount" class="form-label">Amount Guarantee<sup><i class='fas fa-asterisk' style='font-size:7px;color:red'></i></sup></label>
                                                    
											<input type="number" class="form-control @error('guarantee_amount') is-invalid @enderror" id="guarantee_amount" 
											value="{{ old('guarantee_amount') }}" name="guarantors[0][guarantee_amount]" step="0.01" min="1" max="{{ $availableBalance }}" required>
											@error('guarantee_amount')
											<span class="invalid-feedback" role="alert">
												<strong>{{ $message }}</strong>
											</span>
										@enderror
										</div>
										<div class="col-md-1">
											<br>
										
											<label for="cancel"></label>
											<button type="button" class="btn btn-danger remove-member-btn"><i class="fa fa-times"></i></button>
										</div>
									</div>
								</div>
								<div id="guarantors"></div>

								<button type="button" class="btn btn-success" id="add-guarantor"><i class="fas fa-plus"></i>Add Guarantor</button>
								
									<br>							
																
									<div class="col-12" style="margin-top: 30px">
										<button class="btn btn-primary success" type="submit">Submit</button>
										<a href="{{ route('guarantor.create', ['loan_id' => $loan->id]) }}" class="btn btn-secondary">{{ __('Cancel') }}</a>
										
									</div>
								</form>	
								
						</div>
					</div>
				</div>
			</div>
		</div>
		<!--end row-->
	</div>
</div>
<!--end page wrapper -->
@endsection
@pushOnce('scripts')
<!-- JavaScript code to add member -->
<script>
    var i = 2;

    $('#add-guarantor').click(function() {
        var html = '<div class="form-group">';
        html += '<label for="guarantor_' + i + '">Guarantor ' + i + '</label>';
        html += '<div class="row">';
        html += '<div class="col-md-6">';
        html += '<select name="guarantors[' + (i-1) + '][user_id]" class="form-control guarantor-select" onchange="updateSelectedUsers(this)">';
        html += '<option value="">Select Member</option>';
        @foreach ($users as $user)
            @php
                $shares = DB::table('shares')
                            ->join('accounts', 'shares.account_id', '=', 'accounts.id')
                            ->join('account_types', 'accounts.account_type_id', '=', 'account_types.id')
                            ->where('accounts.user_id', $user->id)
                            ->where('account_types.type', 'BOSA')
                            ->select('shares.*')
                            ->get();

                $pendingLoans = DB::table('loans')
                                ->join('guarantors', 'loans.id', '=', 'guarantors.loan_id')
                                ->where('guarantors.user_id', $user->id)
                                ->where('loans.loan_status', 'pending')
                                ->where('guarantors.guarantee_status', 'pending')
                                ->select('loans.*')
                                ->get();

                $hasApprovedRequest = DB::table('guarantors')
                                        ->where('id', $user->id)
                                        ->where('guarantee_status', 'approved')
                                        ->whereIn('loan_id', $pendingLoans->pluck('id'))
                                        ->exists();
            @endphp

            @if ($shares->count() > 0 && $pendingLoans->count() >= 0 && !$hasApprovedRequest)
                html += '<option value="{{ $user->id }}">{{ $user->fname }} {{ $user->lname }}</option>';
            @endif
        @endforeach
        html += '</select>';
        html += '</div>';
        html += '<div class="col-md-5">';
        html += '<input type="number" name="guarantors[' + (i-1) + '][guarantee_amount]" class="form-control" placeholder="Guarantee Amount" step="0.01" min="1" max="{{ $availableBalance }}">';
        html += '</div>';
        html += '<div class="col-md-1">';
        html += '<button type="button" class="btn btn-danger remove-member-btn"><i class="fa fa-times"></i></button>';
        html += '</div>';
        html += '</div>';
        html += '</div>';

        $('#guarantors').append(html);
        i++;
    });

    $(document).on('click', '.remove-member-btn', function() {
        $(this).closest('.form-group').remove();
        updateSelectedUsers();
    });

    function updateSelectedUsers() {
        var selectedUsers = [];

        $('.guarantor-select').each(function() {
            var selectedUser = $(this).val();
            selectedUsers.push(selectedUser);
        });

        $('.guarantor-select option').show();

        $('.guarantor-select').each(function() {
            var selectedUser = $(this).val();
            $('.guarantor-select option[value="' + selectedUser + '"]:not(:selected)').hide();
        });
    }

    @if ($errors->any())
        Swal.fire('Error', '{{ $errors->first() }}', 'error');
    @endif
</script>




@endpushOnce