@extends('layouts.pdf')

@section('title')
    {{ $extra['module_name'] }}
@endsection
@section('content')

        <style type="text/css" media="all">
        div[size="A4"] {
            font-family: Verdana, Geneva, sans-serif !important;
            line-height: 18px
        }

        h5,
        h6,
        p {
            font-family: Verdana, Geneva, sans-serif;
        }

        table td,
        table th,
        h6,
        p {
            font-size: 11px !important;
        }

        h5 {
            font-size: 12px !important;
            font-weight: 600;
        }

        .table td {
            border-top: 0px;
        }

        table th,
        table td {
            padding: 5px !important;
        }

        .table-sm td {
            padding: 0px !important;
        }

        body {
            font-size: 1rem;
        }

        table {
            font-size: 1rem;
            position: relative !important;
        }

        .table th {
            background: #000 !important;
        }

        .table th {
            position: sticky !important z-index: 1 !important;
        }

        .g-total {
            font-size: 12px !important;
        }

        .gray {
            background: rgb(207, 204, 204) !important;
        }

        .font-bold {
            font-weight: bold;
        }

        .text-center {
            text-align: center;
        }

        .width-85{
            width: 85px !important;
        }

        .width-30{
            width: 30px !important;
        }
        .width-90{
            width: 90px !important;
        }
        .width-120{
            width: 120px !important;
        }
    </style>

    {{-- <p>Printing Date & Time: {{ $extra['current_date_time']  }}</p> --}}
    <script type="text/php">
        if (isset($pdf)) {
            $x = 400;
            $y = 10;
            $text = "Page {PAGE_NUM} of {PAGE_COUNT}";
            $font = null;
            $size = 8;
            $color = array(0,0,0);
            $word_space = 0.0;  //  default
            $char_space = 0.0;  //  default
            $angle = 0.0;   //  default
            $pdf->page_text($x, $y, $text, $font, $size, $color, $word_space, $char_space, $angle);
        }
    </script>

    <div size="A4" @if ($action == 'Show') style="margin: 30px 50px auto;" @endif>
        @include('admin.partials.header', ['extra' => $extra])

       
        @php
            $dues_total= $total_cost = $total_received  = $total_dues_bf_this = $total_dues_till_month = $total_dues = 0;
            //dd($search_by['from'],$extra);

            
            
        @endphp

   
            <table class="table table-bordered">
                <thead>
                    
                    <tr>
                        <th scope="col" class="text-center width-85">{{__('lang.team')}}</th>
                        <th scope="col" class="text-center width-30">{{__('lang.receivable')}} <br>{{ $month_name }} </th>

                        <th scope="col" class="text-center width-85">{{__('lang.amount_received_against')}} <br> {{ $month_name }} {{__('lang.dues')}}</th>

                        <th scope="col" class="text-center width-30">{{__('lang.amount_rcvd_percentage')}}</th>
                        <th scope="col" class="text-center width-30">{{ $month_name }} <br> {{__('lang.remaining')}}</th>
                        <th scope="col" class="text-center width-85">{{__('lang.overdues')}}</th>
                        <th scope="col" class="text-center width-90">{{__('lang.amount_received_against')}} <br> {{ $month_name }} {{__('lang.overdues')}}</th>
                        <th scope="col" class="text-center width-30">{{__('lang.amount_rcvd_percentage')}}</th>
                        <th scope="col" class="text-center width-30">{{__('lang.overdues_remaining')}}</th>
                        <th scope="col" class="text-center width-30">{{__('lang.total_recoverable')}} {{$transaction->systemSettingCurrency()}}</th>
                        <th scope="col" class="text-center width-30">{{__('lang.total_amount_rcvd')}}</th>
                        <th scope="col" class="text-center width-30">{{__('lang.total_amount_rcvd_percentage')}}</th>

                       
                       
                        

                    </tr>
                </thead>
                <tbody>
                    @php
                        $total_receivable = $total_received = $total_overdue = $total_overdue_received = $over_rec = 0;
                    @endphp
                    @foreach($employee as $key => $emp) 
                        <tr>
                            <td>{{ $emp->name }}</td>
                            <td>
                                {{ (isset($sells[$emp->id]['receivable'][0]['receivable_amount'])) ? number_format($sells[$emp->id]['receivable'][0]['receivable_amount'],2): 0 }}
                            </td>
                            <td>
                                {{ (isset($sells[$emp->id]['received'][0]['amount_received'])) ? number_format($sells[$emp->id]['received'][0]['amount_received'],2): 0 }}
                            </td>

                            @php
                                $receivable = (isset($sells[$emp->id]['receivable'][0]['receivable_amount'])) ? $sells[$emp->id]['receivable'][0]['receivable_amount'] : 0;

                                $received = (isset($sells[$emp->id]['received'][0]['amount_received'])) ? $sells[$emp->id]['received'][0]['amount_received'] : 0;

                                if($receivable > 0){

                                    $rec_per = ($received/$receivable)*100; 
                                }else{
                                    $rec_per = 0;
                                }
                            @endphp
                            <td>{{ number_format($rec_per,2) }}%</td>
                            <td>
                                {{ number_format($receivable-$received, 2) }}
                            </td>

                            @php
                                $overdue = (isset($sells[$emp->id]['overdues'][0]['overdues'])) ? $sells[$emp->id]['overdues'][0]['overdues'] : 0;

                                $overdue_received = (isset($sells[$emp->id]['overdues_received'][0]['amount_received'])) ? $sells[$emp->id]['overdues_received'][0]['amount_received'] : 0;
                            @endphp
                            <td>
                                {{ number_format($overdue+$overdue_received,2) }}
                            </td>
                            <td>
                                {{ number_format($overdue_received,2) }}
                            </td>

                            @php
                                $over_rec = $overdue+$overdue_received;
                                if($over_rec > 0){

                                    $over_per = ($overdue_received/$over_rec)*100; 
                                }else{
                                    $over_per = 0;
                                }
                            @endphp

                            <td>{{ number_format($over_per,2) }}%</td>
                            <td>
                                {{ number_format(($overdue+$overdue_received)-$overdue_received, 2) }}
                            </td>
                            <td>
                                {{ number_format($receivable+$overdue+$overdue_received,2) }}
                            </td>
                            <td>
                                {{ number_format($received+$overdue_received,2) }}
                            </td>

                            @php
                                if(($receivable+$overdue) > 0){

                                    $per_total =(($received+$overdue_received)/($receivable+$overdue+$overdue_received))*100;
                                }else{
                                    $per_total = 0;
                                }
                            @endphp
                            <td>{{ number_format($per_total,2) }}%</td>
                        </tr>


                        @php
                            $total_receivable += $receivable;

                            $total_received += $received;


                            $total_overdue += ($overdue+$overdue_received);

                            $total_overdue_received += $overdue_received;



                        @endphp
                    @endforeach
                </tbody>
                <tfoot>
                    <tr>
                        <th class="text-right">{{__('lang.total')}}</th>
                        <th>{{ number_format($total_receivable,2) }}</th>
                        <th>{{ number_format($total_received,2) }}</th>
                        <th>
                            @if($total_receivable > 0)
                                {{ number_format((($total_received/$total_receivable)*100),2) }}
                            @else
                                {{ number_format(0,2) }}
                            @endif
                            %
                        </th>
                        <th>{{ number_format(($total_receivable-$total_received),2) }}</th>
                        <th>{{ number_format($total_overdue,2) }}</th>
                        <th>{{ number_format($total_overdue_received,2) }}</th>
                        <th>
                            @if($total_overdue > 0)
                                {{ number_format((($total_overdue_received/$total_overdue)*100),2) }}
                            @else
                                {{ number_format(0,2) }}
                            @endif
                            %
                        </th>
                        <th>{{ number_format(($total_overdue-$total_overdue_received),2) }}</th>
                        <th>
                            {{ number_format(($total_receivable+$total_overdue),2) }}
                        </th>
                        <th>
                            {{ number_format($total_received+$total_overdue_received,2) }}
                        </th>
                        <th>

                            @php
                                $grand_total_receivable = $total_receivable+$total_overdue;
                                $grand_total_received = $total_received+$total_overdue_received;
                            @endphp

                            @if($grand_total_receivable > 0)
                                {{ number_format((($grand_total_received/$grand_total_receivable)*100),2) }}
                            @else
                                {{ number_format(0,2) }}
                            @endif
                            %
                        </th>
                    </tr>
                </tfoot>
            </table>
        
    </div>

@stop