@extends('layouts.pdf')

@section('title')
    {{ $extra['module_name']  }}
@endsection
@php
$is_official = userAllowedUnofficial();
$current_date = \Carbon\Carbon::now()->format('Y-m-d');
function branch($id)
    {
        $branch = App\Models\Branch::find($id);
        return $branch->name;
    }
function block($id)
{
    $block = App\Models\Block::find($id);
    return $block->name;
}
@endphp
@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
        {
            position: sticky !important
            z-index: 1 !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])
        <table class="table table-bordered">
            <thead>                    
                <tr>
                    <th width="10"><b>{{__('lang.serial_no')}}</b></th>
                    <th width="17"><b>{{__('lang.registration_no')}}</b></th>
                    <th width="10" scope="col"><b>{{__('lang.product')}}</b></th>
                    <th width="15" scope="col"><b>{{__('lang.customer_name')}}</b></th>
                    <th width="15" scope="col"><b>{{__('lang.customer_contact')}}</b></th>
                    <th width="15" scope="col"><b>{{__('lang.booking_date')}}</b></th>        
                    <th width="15" scope="col"><b>{{__('lang.last_payment_date')}}</b></th>        
                    {{-- <th width="10" scope="col"><b>Block</b></th> --}}
                    {{-- <th width="10" scope="col"><b>Property Type</b></th> --}}
                    {{-- <th width="10" scope="col"><b>Total Receivable</b></th>
                    <th width="10" scope="col"><b>Paid Amount {{$transaction->systemSettingCurrency()}}</b></th>
                    <th width="10" scope="col"><b>Balance</b></th>
                    <th width="10" scope="col"><b>Total collection percentage</b></th>
                    <th width="10" scope="col"><b>Till Month balance</b></th> --}}
                    @if($terms != null)
                        @foreach($terms as $term_key => $term)
                    
                            <th width="20" scope="col"><b>{{$term}}</b></th>
                        @endforeach
                    @endif
                </tr>
            </thead>
            <tbody>
                @if($data == null)
                    <tr></tr>
                @else
                    @foreach($data as $schedule)
                    @php
                        $g_total_receivable+=$schedule->total_receivable;
                        $g_total_paid_amount+=$schedule->paid_amount;
                        $g_total_balance+=$schedule->balance;
                        
                        if($schedule->total_receivable == 0)
                        {
                            $total_collection_percentage = 0;    
                        }
                        else {
                            $total_collection_percentage = $schedule->paid_amount / $schedule->total_receivable * 100 ;
                        }
                    @endphp
                        <tr>
                            <td>{{$loop->iteration}}</td>
                            <td>{{$schedule->registration_no}}</td>
                            <td>{{$schedule->product}}</td>
                            <td>{{$schedule->customer}}</td>
                            <td>{{$schedule->phone}}</td> 
                            {{-- <td>{{$schedule->block}}</td> --}}
                            {{-- <td>{{$schedule->type}}</td> --}}
                            <td>{{$schedule->sale_date}}</td> 
                            <td>{{$schedule->last_payment_date}}</td> 
                            {{-- <td>{{$transaction->convert_money_format($schedule->total_receivable)}}</td>
                            <td>{{$transaction->convert_money_format($schedule->paid_amount)}}</td>
                            <td>{{$transaction->convert_money_format($schedule->balance)}}</td>   
                            <td>{{$transaction->convert_money_format($total_collection_percentage)}} %</td>   
                            <td>{{$transaction->convert_money_format($schedule->till_month_balance)}}</td>    --}}
                                @foreach($terms as $term_wise_key => $term_wise_data)
                                    @if($schedule_data[$term_wise_data][$schedule->sell_id] != null)
                                        @php
                                            $total_amount[$term_wise_key] += $schedule_data[$term_wise_data][$schedule->sell_id];
                                        @endphp
                                        <td>{{$transaction->convert_money_format($schedule_data[$term_wise_data][$schedule->sell_id])}}</td>
                            
                                    @else
                                        <td>0</td>
                                    @endif
                            @endforeach
                        </tr>
                    @endforeach
                @endif
            </tbody>
            <tfoot>
                <tr>
                    <th colspan="7">{{__('lang.total')}}:</th>
                    {{-- <th>{{ $transaction->convert_money_format($g_total_receivable)}}</th>
                    <th>{{ $transaction->convert_money_format($g_total_paid_amount)}}</th>
                    <th>{{ $transaction->convert_money_format($g_total_balance)}}</th>
                    <th></th>
                    <th>{{ $transaction->convert_money_format($g_total_till_month_balance)}}</th> --}}
                    @if($terms != null)
                        @foreach($terms as $term_wise_key => $term_wise_data)
                        <th>{{$transaction->convert_money_format($total_amount[$term_wise_data])}}</th>
                        @endforeach
                    @endif
                </tr>
            </tfoot>
        </table>
    </div>
    <div style="page-break-after: always"></div>
    <div size="A4" @if($action=='Show') style="margin: 30px 50px auto;" @endif >
       
        <table class="">
            <tbody>
                @if ($search['from'] != null && $search['to'] == null)
                    <tr>
                        <td scope="row">{{__('lang.from')}} :</td>
                        <td>{{ date('Y-m-d', strtotime(str_replace('-', '/', $search['from']))) }}</td>
                    </tr>
                @endif
                @if ($search['to'] != null && $search['from'] == null)
                    <tr>
                        <td scope="row">{{__('lang.to')}} :</td>
                        <td>{{ date('Y-m-d', strtotime(str_replace('-', '/', $search['to']))) }}</td>
                    </tr>
                @endif
                @if ($search['from'] == null && $search['to'] == null)
                    <tr>
                        <td>Search Till :</td>
                        <td>{{ $current_date }}</td>
                    </tr>
                @endif
                @if ($search['from'] != null && $search['to'] != null)
                    <tr>
                        <td>{{__('lang.from')}} :</td>
                        <td>{{ date('Y-m-d', strtotime(str_replace('-', '/', $search['from']))) . ' to ' . date('Y-m-d', strtotime(str_replace('/', '-', $search['to']))) }}
                        </td>
                    </tr>
                @endif
                <tr>
                    <td scope="row">{{__('lang.project')}} :</td>
                    <td>{{ branch($search['project']) ?? 'All' }}</td>
                </tr>
                <tr>
                    <td scope="row">{{__('lang.block')}} :</td>
                    @if($search['block'] != 0)
                        <td>{{ block($search['block']) ?? 'All' }}</td>
                    @else
                        <td> {{__('lang.all')}}</td>
                    @endif
                </tr>
                <tr>
                    <td scope="row">{{__('lang.mode_of_payment')}}:</td>
                    @if($search['mode_of_Payment'] != 0)
                        <td>{{ $search['mode_of_Payment'] }}</td>
                    @else
                        <td> {{__('lang.all')}}</td>
                    @endif
                </tr>
                <tr>
                    <td scope="row">{{__('lang.registration_no')}}:</td>
                    <td>{{ $search['registeration'] ?? 'N/A' }}</td>
                </tr>
            </tbody>
        </table>
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>{{__('lang.registration_no')}}</th>
                    <th>{{__('lang.unit')}}</th>
                    <th>{{__('lang.customer')}}</th>
                    <th>{{__('lang.contact_no')}}</th>
                    <th>{{__('lang.booking_date')}}</th>
                    <th>{{__('lang.last_payment_date')}}</th>
                    <th>{{__('lang.total_dues')}}</th>
                    @if($is_official)
                        <th>{{__('lang.unofficial_received')}}</th>
                        <th>{{__('lang.official_received')}}</th>
                    @endif
                    <th>{{__('lang.total_received')}}</th>
                    <th>{{__('lang.total_cost')}}</th>
                    <th>{{__('lang.booked_by')}}</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($data as $schedule)
                    <tr>
                        <td>{{$schedule->registration_no}}</td>
                        <td>{{$schedule->product}}</td>
                        <td>{{$schedule->customer}}</td>
                        <td>{{$schedule->phone}}</td>
                        <td>{{$schedule->sale_date}}</td>
                        <td>{{$schedule->last_payment_date}}</td>
                        <td>{{$transaction->convert_money_format($schedule->till_month_balance[$schedule->sell_id])}}</td>
                        @if($is_official)
                            <td>{{$transaction->convert_money_format($schedule->Official_payment_receive)}}</td>
                            <td>{{$transaction->convert_money_format($schedule->Un_official_payment_receive)}}</td>
                        @endif
                        <td>{{$transaction->convert_money_format($schedule->Combine_payment_receive)}}</td>
                        <td>{{$transaction->convert_money_format($schedule->cost)}}</td>
                        <td>{{$schedule->created_by}}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
        
    </div>

@stop