{{-- PAGE LAYOUNT SECTION ADD --}}
@extends('layouts.adminapp')

{{-- ADD PAGE TITLE --}}
@section('title') {{__('lng.AnnualHouseSubscriptionPayment')}}  @endsection

{{-- ADD CONTENT IN LAYOUT PAGE --}}
@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>

{{-- Annual House Subscription Payment --}}

<!-- Page Header -->
<div class="page-header">
    <div>
        <h2 class="main-content-title tx-24 mg-b-5">{{__('lng.AnnualHouseSubscriptionPayment')}}</h2>
    </div>
</div>
<!-- End Page Header --> 
<x-app-flash/>


    <!-- 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 class="text-center" colspan="2">{{__('lng.Action')}}</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.Year')}}</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($AnnualHouseSubscriptions as $AnnualHouseSubscription)
                            <tr>
                                @php
                                // Joining Date
                                $DTs="";
                                $TotYears=0;
                                $Amount=0;
                                $OpeningBalance=0;
                                $Payable=0;
                                $Payed=0;
                                $AdBal=0;
                                // if($AnnualHouseSubscription) {
                                    $DTs =  date("Y-m-d",strtotime($AnnualHouseSubscription->date));
    
                                    $TodayDate = date("Y-m-d");
                                    if (strtotime($DTs) < strtotime($TodayDate)) {
                                        $NOW = Carbon\Carbon::now();
                                        $year1 = Carbon\Carbon::parse($AnnualHouseSubscription->date);
                                        $year2 = Carbon\Carbon::parse($NOW);
                                        
                                        // Calculate the difference in years
                                        $TotYears = $year1->diffInYears($year2);
                                    }
    
                                    $Amount = $AnnualHouseSubscription->subscriptionpackage->amount;
                                    if($AnnualHouseSubscription->DRorCR == 'Dr'){
                                        $OpeningBalance = $AnnualHouseSubscription->openingbalance;
                                    }
                                    elseif($AnnualHouseSubscription->DRorCR == 'Cr') {
                                        $OpeningBalance = -1 * $AnnualHouseSubscription->openingbalance;
                                    }
                                // }
    
                                // Payable Caliculation
                                if (is_numeric($TotYears)) {
                                    if($OpeningBalance > 0){
                                    $Payable = ($TotYears*$Amount)+$OpeningBalance;
                                    }
                                    else{
                                        $Payable = $TotYears*$Amount;
                                    }
                                }
    
                                // Payed Caliculation
                                foreach($AnnualHouseSubscription->AnnualHouseSubscriptionPayment 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>
                                <td>
    
                                    <span class="mr-3">
                                        <button onclick="AddSubscription('{{$AnnualHouseSubscription->house->id}}','{{$AnnualHouseSubscription->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>
                                        </button>
                                    </span>
                                </td>
                                <td>
                                    <span class="mr-3">
                                        <a href="{{route('AnnualHouseSubscriptionPayment.show',$AnnualHouseSubscription->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>
                                </td>
    
                                @foreach($AnnualHouseSubscription->house->members as $Member)
                                    @if($Member->member_relation_id == App\Extra\General\DBFixedValues::AUTHORITY)
                                        <input type="hidden" value="{{$Member->name}}" id="AuthorityName{{$AnnualHouseSubscription->house->id}}"/>
                                        @if ($Member->photo)
                                        <div id="SelectIMG{{$AnnualHouseSubscription->house->id}}" style="display:none;"><img width="100%" src="{{asset('storage/Member/Photo/'.$Member->photo)}}"/></div>
                                        @else
                                        <div id="SelectIMG{{$AnnualHouseSubscription->house->id}}" style="display:none;"><img width="100%" src="{{asset('assets/images/user_logo.jpg')}}"/></div>
                                        @endif
                                        <td>{{$AnnualHouseSubscription->house->name}} - {{$Member->name}}</td>
                                        <td>{{$Member->contact}}</td>
                                    @endif
                                @endforeach
    
                                <td>{{$AnnualHouseSubscription->house->registernumber}}</td>
                                <td>{{$AnnualHouseSubscription->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($AnnualHouseSubscription->subscriptionpackage->amount ?? '0')</td>
                                <td>{{$TotYears}}</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">{{$AnnualHouseSubscriptions->Count()}} {{__('lng.Items')}}</p>
                </div>
            </div>
            <div class="card-footer" id="card-footer">
                <div class="table-responsive">
                    {{$AnnualHouseSubscriptions->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>
            </div>
            <form method="POST" action="{{route('AnnualHouseSubscriptionPayment.store')}}" enctype='multipart/form-data'> 
            @csrf
            <div class="modal-body">
                <h5 class="modal-title mb-3 text-dark">{{__('lng.AnnualSubscriptionPayment')}}</h5>
                <div class="row">
                    <div class="col-sm-6 form-group">
                        <input type="hidden" name="house_id" id="HouseID">
                        <input type="hidden" name="annual_house_subscription_id" id="AnnualSubscriptionID">
                        <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 select2" 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-dark 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(HID,SID) {
        $('#SubscriptionModal').modal('show');
        var Authority = document.getElementById('AuthorityName'+HID).value;
        var Profile = document.getElementById('SelectIMG'+HID).innerHTML;

        document.getElementById('HouseID').value = HID;
        document.getElementById('AnnualSubscriptionID').value = SID;
        document.getElementById('txtAuthority').innerHTML = Authority;
        document.getElementById('ProfileIMG').innerHTML = Profile;
    }
    
    function Search(Value) {
        // alert(Value); 
            $.ajax({
                url: '{{ route('SearchAnnualHouseSubscriptionPayment') }}',
                method: "get",
                data: {_token: '{{ csrf_token() }}',Value:Value},
                success: function (response){  
                // alert(response);
                    document.getElementById('result-tbl').innerHTML=response; 
                }
            }); 
        }
    
    // function MonthCalculation(Value) {
    //     var HouseID=document.getElementById('HouseID').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