@extends('layouts.adminapp')

@section('content')

<div class="card mb-4" style="text-align: center;">
           
    <div id="printableArea" style="height: 100%;" >
        <style>
            body
            {
                font-size:15px;
                font-family: 'Roboto', sans-serif;
            }
            .table1 {
              border-collapse: collapse;
            }
            
            .table1, .th1, .td1 {
              border: 1px solid black;
            }
        
            h1,h2,h3,h4,h5,h6,p {
                margin: 5;
            }
        
            .result-table {
                width: 100%;
                margin-top: 10px;
            }
        
            .result-table th {
                height: 50px;
                border-bottom: 1px solid #ddd;
                border-left: 1px solid #ddd;
            }
        
             .result-table td {
                border-bottom: 1px solid #ddd;
                border-left: 1px solid #ddd;
                padding: 5px;
            }
            
            .btn-part {
                
            }
        
            .btn-print{
               padding:18px 30px;
               border-color:black;
               background-color:inherit;
               border-radius:40px;
               margin-top: 10px;
           }
           .btn-print:hover{
               padding:18px 30px;
               color:white;
               background-color:black;
               border-radius:40px;
               cursor: pointer;
           }
            
            
           @page {
        }
        </style>
        <script>
        function printDiv(divName) {
         var printContents = document.getElementById(divName).innerHTML;
         var originalContents = document.body.innerHTML;
        
         document.body.innerHTML = printContents;
        
         window.print();
        
         document.body.innerHTML = originalContents;
         
        }
        </script> 
        <div style="padding:5px;" >
   
            <!-------------------  HEAD  -------------------------------------->
            <div style="border:double; padding: 10px; width: 100%; float: left;">
                
                @include('PrintHeader.header')

                <div style="padding:20px 0; text-align:center;"><h4>{{__('lng.SubscriptionStandardReport')}}</h4></div>
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>{{__('lng.SiNo')}}</th>
                            <th>{{__('lng.Authority')}}</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>
                        </tr>
                    </thead>
                    <tbody>@php $si=0; @endphp
                        @foreach($ArHouse as $key=>$House)
                        @php 
                        // Joining Date
                        $DTs="";
                        $TotMonth=0;
                        $Amount=0;
                        $OpeningBalance=0;
                        $Payable=0;
                        $Payed=0;
                        $AdBal=0;
                        if($House->house_subscription) {
                            $DTs =  date("Y-m-d",strtotime($House->house_subscription->date));
                        
                            $TodayDate=date("Y-m-d");
                            if(strtotime($DTs)<strtotime($TodayDate)){
                            $NOW=Carbon\Carbon::now();
                            $NOWDate = date('m',strtotime($NOW));
                            $month1 = Carbon\Carbon::parse($House->house_subscription->date); 
                            $month2 = Carbon\Carbon::parse($NOW); 
                            $TotMonth = $month1->diffInMonths($month2);
                            }
                        
                            $Amount = $House->house_subscription->subscriptionpackage->amount;
                            // $OpeningBalance = $House->house_subscription->openingbalance;
                            if($House->house_subscription->DRorCR == 'Dr'){
                                $OpeningBalance = $House->house_subscription->openingbalance;
                            }
                            elseif($House->house_subscription->DRorCR == 'Cr') {
                                $OpeningBalance = -1 * $House->house_subscription->openingbalance;
                            }
                        }
                        
                        // Payable Caliculation
                        if (is_numeric($TotMonth)) {
                            if($OpeningBalance > 0){
                            $Payable = ($TotMonth*$Amount)+$OpeningBalance;
                            }
                            else{
                                $Payable = $TotMonth*$Amount;
                            }
                        }
                        
                        // Payed Caliculation
                        foreach($House->subscriptions 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
                        <tr>
                            <td>{{++$si}}</td>
                            @foreach($House->members as $Member)
                                @if($Member->member_relation_id == App\Extra\General\DBFixedValues::AUTHORITY)
                                    <td>{{$House->name}} - {{$Member->name}}</td>
                                @endif
                            @endforeach
                            <td>{{$House['registernumber']}}</td>
                            <td>{{$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>
                            @if ($House->house_subscription->subscriptionpackage ?? '')
                                <td>@currency($House->house_subscription->subscriptionpackage->amount ?? '')</td>
                            @else 
                                <td>0</td>
                            @endif
                            <td>{{$TotMonth}}</td>
                            <td>{{$Payable}}</td>
                            <td>{{$Payed}} </td>
                            
                            <td>
                                @if($AdBal<0) 
                                    <span style="color:green;">{{$AdBal*-1}}</span>
                                @elseif($AdBal>0)
                                    <span style="color:red;">{{$AdBal}}</span>
                                @else
                                    <span style="color:blue;">{{$AdBal}}</span>
                                @endif
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="btn-part">
        <button type="button" onclick="history.back()" class="btn  btn-primary m-3 btn-icon-split" >
            <span class="icon text-white-50">
                <i class="mdi mdi-arrow-left"></i>
            </span>
            <span class="text">{{__('lng.Back')}}</span>
        </button>
        <button type="button" onclick="printDiv('printableArea')" class="btn  btn-info m-3 btn-icon-split" >
            <span class="icon text-white-50">
                <i class="mdi mdi-printer"></i>
            </span>
            <span class="text">{{__('lng.PrintForm')}}</span>
        </button>
    </div>
</div>
@endsection