@extends('layouts.adminapp')

@section('content')

<style>
.subcription-profile {
  border-radius: 75px;
  overflow: hidden;
  width: 150px;
  height: 150px;
  border: 2px solid #fff;
  z-index: 999;
  position: absolute;
  top: -25px;
  left: 0;
  right: 0;
  margin: 0 auto;
}
</style>

{{-- Member Subscription Payment --}}
<x-app-flash/>

  <h1 class="h3 mb-2 text-gray-800">{{__('lng.MemberSubscriptionPayment')}}</h1>

    <!-- DataTales Example -->
    <div class="card shadow mb-4">
        <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
            <h6 class="m-0 font-weight-bold text-primary">{{__('lng.MemberSubscriptionPaymentTable')}}</h6>
            <div class="input-group w-25 input-search">
              <input type="text" oninput="Search(this.value)"  value="{{$SerachValue}}" class="form-control bg-light  small" placeholder="{{__('lng.SearchFor')}}" aria-label="Search" aria-describedby="basic-addon2">
              <div class="input-group-append">
                <button class="btn btn-primary" type="button">
                    <i class="fas fa-search fa-sm"></i>
                </button>
              </div>
            </div>
        </div>
        <div  id="result-tbl">
            @if ($SearchResult)
                @php echo $SearchResult @endphp
            @else
            <div class="card-body">
                <div class="table-responsive" >
                    <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                        <thead>
                            <tr>
                                <th>{{__('lng.SiNo')}}</th>
                                <th class="text-center" >{{__('lng.Action')}}</th>
                                <th>{{__('lng.Member')}}</th>
                                <th>{{__('lng.Contact')}}</th>
                                <th>{{__('lng.HouseName')}}</th>
                                <th>{{__('lng.Reg.No.')}}</th>
                                <th>{{__('lng.SubscriptionDateOfJoin')}}</th>
                                <th>{{__('lng.OpeningBalance')}}<br><span style="color:red;">{{__('lng.Pending')}}</span>/<span style="color:blue;">{{__('lng.Advance')}}</span></th>
                                <th>{{__('lng.MonthlyAmount')}}</th>
                                <th>{{__('lng.Month')}}</th>
                                <th>{{__('lng.Payable')}}</th>
                                <th>{{__('lng.Payed')}}</th>
                                <th><span style="color:red;">{{__('lng.Balance')}}</span>/<span style="color:green;">{{__('lng.Advance')}}</span></th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $si=0; @endphp
                            @foreach($MemberSubscriptions as $MemberSubscription)
                            <tr>
                                @php
                                // Joining Date
                                $DTs="";
                                $TotMonth=0;
                                $Amount=0;
                                $OpeningBalance=0;
                                $Payable=0;
                                $Payed=0;
                                $AdBal=0;
                                $DTs =  date("Y-m-d",strtotime($MemberSubscription->date));
                                $TodayDate=date("Y-m-d");
                                if(strtotime($DTs)<strtotime($TodayDate)){
                                    $NOW=Carbon\Carbon::now();
                                    $NOWDate = date('m',strtotime($NOW));
                                    $month1 = Carbon\Carbon::parse($MemberSubscription->date);
                                    $month2 = Carbon\Carbon::parse($NOW);
                                    $TotMonth = $month1->diffInMonths($month2);
                                }
    
                                $Amount = $MemberSubscription->subscriptionpackage->amount;
                                
                                if($MemberSubscription->DRorCR == 'Dr'){
                                    $OpeningBalance = $MemberSubscription->openingbalance;
                                }
                                elseif($MemberSubscription->DRorCR == 'Cr') {
                                    $OpeningBalance = -1 * $MemberSubscription->openingbalance;
                                }

                                // Payable Caliculation
                                if (is_numeric($TotMonth)) {
                                    if($OpeningBalance > 0){
                                    $Payable = ($TotMonth*$Amount)+$OpeningBalance;
                                    }
                                    else{
                                        $Payable = $TotMonth*$Amount;
                                    }
                                }
                                
    
                                // Payed Caliculation
                                foreach($MemberSubscription->MemberSubscriptionPayment->where('isCancelled',0) as $Subscription) {
                                    if($Subscription->isCancelled!=1) {
                                        $Payed+=$Subscription->amount;
    
                                    }
                                }
                                
                                // Advance Or Balance Caliculation
                                if($OpeningBalance < 0){
                                $AdBal=($Payable-$Payed)+$OpeningBalance;
                                }
                                else {
                                    $AdBal=$Payable-$Payed;
                                }
                                @endphp
                            
                                <input type="hidden" value="{{$MemberSubscription->member->name}}" id="AuthorityName{{$MemberSubscription->id}}"/>
                                @if ($MemberSubscription->member->photo)
                                <div id="SelectIMG{{$MemberSubscription->id}}" style="display:none;"><img width="100%" src="{{asset('storage/Member/Photo/'.$MemberSubscription->member->photo)}}"/></div>
                                @else
                                <div id="SelectIMG{{$MemberSubscription->id}}" style="display:none;"><img width="100%" src="{{asset('assets/images/user_logo.jpg')}}"/></div>
                                @endif

                                <td>{{++$si}}</td>
                                <td>
                                    <div class="d-flex flex-row align-items-center">
    
                                        <span class="mr-3">
                                            <a onclick="AddSubscription('{{$MemberSubscription->member_id}}','{{$MemberSubscription->id}}')" class="btn btn-success btn-circle btn-sm" data-bs-toggle="tooltip" data-bs-placement="bottom" title="{{__('lng.PayAmount')}}">
                                                <i class="fas fa-money-bill-alt"></i>
                                            </a>
                                        </span>
                                        <span class="mr-3">
                                            <a href="{{route('MemberSubscriptionHistory',$MemberSubscription->id)}}" class="btn btn-info btn-circle btn-sm" data-bs-toggle="tooltip" data-bs-placement="bottom" title="{{__('lng.PayHistory')}}">
                                                <i class="far fa-eye"></i>
                                            </a>
                                        </span>
                                    </div>
                                </td>

                                <td>{{$MemberSubscription->member->name}}</td>
                                <td>{{$MemberSubscription->member->contact}}</td>
                                <td>{{$MemberSubscription->member->house->name}}</td>
                                <td>{{$MemberSubscription->member->house->registernumber}}</td>
                                <td>{{$DTs}}</td>
                                <td>
                                    @if($OpeningBalance<0)
                                        <span style="color:blue;">@currency($OpeningBalance*-1)</span>
                                    @elseif($OpeningBalance>0)
                                        <span style="color:red;">@currency($OpeningBalance)</span>
                                    @else
                                        <span>@currency($OpeningBalance)</span>
                                    @endif
                                </td>
                                <td>@currency($MemberSubscription->subscriptionpackage->amount ?? '0')</td>
                                <td>{{$TotMonth}}</td>
                                <td>{{$Payable}}</td>
                                <td>{{$Payed}} </td>
                                
                                <td>
                                    @if($AdBal<0)
                                        <span style="color:green;">@currency($AdBal*-1)</span>
                                    @elseif($AdBal>0)
                                        <span style="color:red;">@currency($AdBal)</span>
                                    @else
                                        <span style="color:blue;">@currency($AdBal)</span>
                                    @endif
                                </td>
                            </tr>
                            @endforeach
    
                        </tbody>
                    </table>
                    <p class="mb-2">{{$MemberSubscriptions->Count()}} {{__('lng.Items')}}</p>
                </div>
            </div>
            <div class="card-footer" id="card-footer">
                <div class="table-responsive">
                    {{$MemberSubscriptions->links()}}
                </div>
            </div>
            @endif
        </div>
    </div>


{{--  Modal  --}}
<div class="modal fade bd-example-modal-lg" id="SubscriptionModal" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header bg-success py-5">
                <div class="row" style="width: 100%;">
                    <div id="ProfileIMG" class="subcription-profile"></div>
                    <div class="MemberSubscriptionPayment-authority">
                        <h5 class="modal-title text-white pl-4" id="txtAuthority"></h5>
                    </div>
                </div>
                {{-- <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
                </button>--}}
            </div>
            <form method="POST" action="{{route('MemberSubscriptionPayment.store')}}" enctype='multipart/form-data'> 
            @csrf
            <div class="modal-body">
                <h5 class="modal-title mb-3 text-dark">{{__('lng.SubscriptionPayment')}}</h5>
                <div class="row">
                    <div class="col-sm-6 form-group">
                        <input type="hidden" name="member_id" id="MemberID">
                        <input type="hidden" name="member_subscription_id" id="MemberSubscriptionID">
                        <label for="dtDate">{{__('lng.Date')}}</label>
                        <input type="date" value="{{date('Y-m-d')}}" class="form-control @error('date') is-invalid @enderror" name="date" id="dtDate" required/>
                        @error('date')<div class="invalid-feedback">{{ $message }}</div>@enderror
                    </div>
                    @if ($Voucher->vouchernumber == PBConst::VOUCHER_NUMBER_AUTOMATIC)
                        <div class="col-sm-6 form-group">
                            <label for="numAmount">{{__('lng.VoucherNo')}}</label>
                            <input type="number" class="form-control" value="{{$VoucherNo}}" name="vouchernumber" id="numAmount" readonly/>
                        </div>
                    @else
                        <div class="col-sm-6 form-group">
                            <label for="numAmount">{{__('lng.VoucherNo')}}</label>
                            <input type="number" class="form-control" name="vouchernumber" id="numAmount" required/>
                        </div>
                    @endif
                    <div class="col-sm-6 form-group">
                        <label for="cbHead">{{__('lng.Head')}}</label>
                        <select class="form-control" id="cbHead" name="head" >
                            @php
                                echo App\Http\Controllers\DonationController::DonationHeadListForCombo(0);
                            @endphp
                        </select>
                    </div>
                    <div class="col-sm-6 form-group">
                        <label for="numAmount">{{__('lng.Amount')}}</label>
                        <input type="number" class="form-control" oninput="MonthCalculation(this.value)" name="amount" id="numAmount"/>
                    </div>
                    <div class="col-sm-12 form-group">
                        <label for="txtName">{{__('lng.Narration')}}</label>
                        <input type="text" class="form-control" name="narration" id="txtNarration"/>
                    </div>

                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary btn-icon-split mr-2" data-dismiss="modal">
                    <span class="icon text-white-50">
                        <i class="fas fa-times"></i>
                    </span>
                    <span class="text">{{__('lng.Close')}}</span>
                </button>
                <button type="submit" class="btn btn-success btn-icon-split">
                    <span class="icon text-white-50">
                        <i class="fas fa-check"></i>
                    </span>
                    <span class="text">{{__('lng.Save')}}</span>
                </button>
            </div>
            </form>
        </div>
    </div>
</div>





<script>
    function AddSubscription(MemID,SubID) {
        $('#SubscriptionModal').modal('show');
        var Authority = document.getElementById('AuthorityName'+SubID).value;
        var Profile = document.getElementById('SelectIMG'+SubID).innerHTML;

        document.getElementById('MemberID').value = MemID;
        document.getElementById('MemberSubscriptionID').value = SubID;
        document.getElementById('txtAuthority').innerHTML = Authority;
        document.getElementById('ProfileIMG').innerHTML = Profile;
    }
    
    function Search(Value) {
        // alert(Value); 
            $.ajax({
                url: '{{ route('SearchMemberSubscriptionPayment') }}',
                method: "get",
                data: {_token: '{{ csrf_token() }}',Value:Value},
                success: function (response){  
                // alert(response);
                    document.getElementById('result-tbl').innerHTML=response; 
                }
            }); 
        }

</script>

@endsection