@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>

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

  <h1 class="h3 mb-2 text-gray-800">{{__('lng.Subscription')}}</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.SubscriptionTable')}}</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>{{__('lng.Authority')}}</th>
                            <th>{{__('lng.Contact')}}</th>
                            <th>{{__('lng.Reg.No.')}}</th>
                            <th>{{__('lng.Place')}}</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.Amount')}}</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>
                            <th>{{__('lng.Action')}}</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $si=0; @endphp
                            @foreach($HouseSubscriptions as $HouseSubscription)
                            <tr>
                                @php
                                // Joining Date
                                $DTs="";
                                $TotMonth=0;
                                $Amount=0;
                                $OpeningBalance=0;
                                $Payable=0;
                                $Payed=0;
                                $AdBal=0;
                                // if($HouseSubscription) {
                                    $DTs =  date("Y-m-d",strtotime($HouseSubscription->date));
    
                                    $TodayDate=date("Y-m-d");
                                    if(strtotime($DTs)<strtotime($TodayDate)){
                                        $NOW=Carbon\Carbon::now();
                                        $NOWDate = date('m',strtotime($NOW));
                                        $month1 = Carbon\Carbon::parse($HouseSubscription->date);
                                        $month2 = Carbon\Carbon::parse($NOW);
                                        $TotMonth = $month1->diffInMonths($month2);
                                    }
                                    // $TotMonth = $diff-$NOWDate;
    
                                    $Amount = $HouseSubscription->subscriptionpackage->amount;
                                    if($HouseSubscription->DRorCR == 'Dr'){
                                        $OpeningBalance = $HouseSubscription->openingbalance;
                                    }
                                    elseif($HouseSubscription->DRorCR == 'Cr') {
                                        $OpeningBalance = -1 * $HouseSubscription->openingbalance;
                                    }
                                // }
    
                                // Payable Caliculation
                                if (is_numeric($TotMonth)) {
                                    if($OpeningBalance > 0){
                                    $Payable = ($TotMonth*$Amount)+$OpeningBalance;
                                    }
                                    else{
                                        $Payable = $TotMonth*$Amount;
                                    }
                                }
    
                                // Payed Caliculation
                                foreach($HouseSubscription->house->subscriptions as $Subscriptionpay) {
                                    if($Subscriptionpay->isCancelled!=1) {
                                        $Payed+=$Subscriptionpay->amount;
    
                                    }
                                }
    
                                // Advance Or Balance Caliculation
                                if($OpeningBalance < 0){
                                $AdBal=($Payable-$Payed)+$OpeningBalance;
                                }
                                else {
                                    $AdBal=$Payable-$Payed;
                                }
                                @endphp
                                <td>{{++$si}}</td>
    
                                @foreach($HouseSubscription->house->members as $Member)
                                    @if($Member->member_relation_id == App\Extra\General\DBFixedValues::AUTHORITY)
                                        <input type="hidden" value="{{$Member->name}}" id="AuthorityName{{$HouseSubscription->house->id}}"/>
                                        @if ($Member->photo)
                                        <div id="SelectIMG{{$HouseSubscription->house->id}}" style="display:none;"><img width="100%" src="{{asset('storage/Member/Photo/'.$Member->photo)}}"/></div>
                                        @else
                                        <div id="SelectIMG{{$HouseSubscription->house->id}}" style="display:none;"><img width="100%" src="{{asset('assets/images/user_logo.jpg')}}"/></div>
                                        @endif
                                        <td>{{$HouseSubscription->house->name}} - {{$Member->name}}</td>
                                        <td>{{$Member->contact}}</td>
                                    @endif
                                @endforeach
    
                                <td>{{$HouseSubscription->house->registernumber}}</td>
                                <td>{{$HouseSubscription->house->place}}</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($HouseSubscription->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>
                                <td>
                                    <div class="d-flex flex-row align-items-center">
    
                                        <span class="mr-3">
                                            <a onclick="AddSubscription('{{$HouseSubscription->house->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('HouseSubscriptionAmount',$HouseSubscription->house->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>
                            </tr>
                            @endforeach
    
                        </tbody>
                    </table>
                    <p class="mb-2">{{$HouseSubscriptions->Count()}} {{__('lng.Items')}}</p>
                </div>
            </div>
            <div class="card-footer" id="card-footer">
                <div class="table-responsive">
                    {{$HouseSubscriptions->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="subscription-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('Subscription.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="house_id" id="HouseID">
                        <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(ID) {
        $('#SubscriptionModal').modal('show');
        var Authority = document.getElementById('AuthorityName'+ID).value;
        var Profile = document.getElementById('SelectIMG'+ID).innerHTML;

        document.getElementById('HouseID').value = ID;
        document.getElementById('txtAuthority').innerHTML = Authority;
        document.getElementById('ProfileIMG').innerHTML = Profile;
    }
    
    function Search(Value) {
        // alert(Value); 
            $.ajax({
                url: '{{ route('SearchHouseSubscriptionTransation') }}',
                method: "get",
                data: {_token: '{{ csrf_token() }}',Value:Value},
                success: function (response){  
                // alert(response);
                    document.getElementById('result-tbl').innerHTML=response; 
                }
            }); 
        }
    
    function MonthCalculation(Value) {
        // alert(Value); 
        var HouseID=document.getElementById('HouseID').value;
        // document.getElementById('txtNarration').value=Value;
            $.ajax({
                url: '{{ route('SubscriptionMonthCalculation') }}',
                method: "get",
                data: {_token: '{{ csrf_token() }}',Value:Value,HouseID:HouseID},
                success: function (response){  
                // alert(response);
                document.getElementById('txtNarration').value=response;
                }
            }); 
        }


</script>

@endsection