@extends('layouts.pdf')
@section('title')
{{__('lang.sale_aging_report')}}
@endsection
@section('content')
        <style type="text/css" media="all">
        div[size="A4"]{
            font-family: Verdana,Geneva,sans-serif !important;
            line-height:18px;
            @php
                echo $type =='show' ? 'margin: 30px 50px auto;' : '' ;
            @endphp
        }
        h5,h6,p{
            font-family: Verdana,Geneva,sans-serif;
        }
        table td, table th,h6,p{
            font-size: 12px !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;
        }
        .btn:focus {
            outline: none !important;
        }
        .btn:not(.btn-link):not(.btn-circle) {
            box-shadow: 0 2px 5px rgba(0, 0, 0, 0.16), 0 2px 10px rgba(0, 0, 0, 0.12);
            -webkit-border-radius: 2px;
            -moz-border-radius: 2px;
            -ms-border-radius: 2px;
            border-radius: 2px;
            border: none;
            font-size: 14px;
            outline: none;
        }
        .btn:not(.btn-link):not(.btn-circle):hover {
            outline: none;
        }
        .btn:not(.btn-link):not(.btn-circle) i {
            font-size: 20px;
            position: relative;
            top: 3px;
        }
        .btn:not(.btn-link):not(.btn-circle) span {
            position: relative;
            top: -2px;
            margin-left: 3px;
        }
        .btn-warning,
        .btn-warning:hover,
        .btn-warning:active,
        .btn-warning:focus {
            background-color: #ff9600 !important;
        }
        .btn-danger,
        .btn-danger:hover,
        .btn-danger:active,
        .btn-danger:focus {
            background-color: #fb483a !important;
        }
        .btn-info,
        .btn-info:hover,
        .btn-info:active,
        .btn-info:focus {
            background-color: #00b0e4 !important;
        }
        .btn-success,
        .btn-success:hover,
        .btn-success:active,
        .btn-success:focus {
            background-color: #2b982b !important;
        }
        .btn-primary,
        .btn-primary:hover,
        .btn-primary:active,
        .btn-primary:focus {
            background-color: #1f91f3 !important;
        }
        .table td, .table th {
          padding: .75rem !important;
        vertical-align: top !important;
        border-top: 1px solid #dee2e6 !important;        
    }

  
    @import url("https://fonts.googleapis.com/css2?family=Fraunces:ital,wght@0,700;1,200&display=swap");

    table {
    /* white-space: nowrap; */
    margin: 0;
    border: none;
    border-collapse: separate;
    border-spacing: 0;
    table-layout: fixed;
    }
    table td,
    table th {
    padding: 0.5rem 1rem;
    }
    table thead th {
    white-space: nowrap;
    padding: 2px;
    position: sticky;
    top: 0;
    z-index: 1;
    width: 2vw;
    }
    table td {
    width: 45px !important;
    padding: 2px 2px;
    text-align: center;
    }

    table tbody th {
    font-weight: 100;
    position: relative;
    }
    table thead th:nth-child(2) {
    position: sticky;
    left: 0;
    z-index: 2;
    }
    table tbody th {
    position: sticky;
    left: 0;
    z-index: 1;
    }
    caption {
    text-align: left;
    padding: 0.25rem;
    position: sticky;
    left: 0;
    }

    [role="region"][aria-labelledby][tabindex] {
    width: 100%;
    max-height: 98vh;
    overflow: auto;
    }
    [role="region"][aria-labelledby][tabindex]:focus {
    box-shadow: 0 0 0.5em rgba(0, 0, 0, 0.5);
    outline: 0;
    }

    
 
    </style>
    <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>
<section class="container" style="max-width: 100%;">
    @include('admin.partials.header', ['extra' => $extra])  
       
        <table class="table table-bordered table-hover" style="width: 26%;margin-top: -65px;">
            <thead>
                @php
                    $total_unit = 0;
                @endphp
                <tr>
                    <th colspan="2">{{__('lang.product_summary')}}</th>
                </tr>
                @foreach($product_count as $count)
                    @php
                        if($count->status == "SOLD"){
                            $colour = "#dc3545";
                        }elseif($count->status == "AVAILABLE"){
                            $colour = "#28a745";
                        }elseif($count->status == "HOLD"){
                            $colour = "#ffc107";
                        }
                    @endphp
                    <tr style="background-color: {{ $colour }}; color: white; font-weight:bold">

                        <td class="text-left" style="background-color: darkgray !important">{{ $count->status }}</td>
                        <td class="text-left" style="background-color: darkgray !important">{{ $count->total_inventory }}</td>

                        @php
                            $total_unit += $count->total_inventory;
                        @endphp
                    </tr>
                @endforeach
                <tr>
                    <th class="text-left">{{__('lang.total')}}</th>
                    <th  class="text-left">{{ $total_unit }}</th>
                </tr>
            </thead>
        </table> 
        <div role="region" aria-labelledby="caption" tabindex="0"> 
        <table class="table table-bordered table-hover" style="font-size: 12px;table-layout: auto;width: 600%;max-width: 1000% !important;">
            <thead>
            <tr>
               
                <th>{{__('lang.serial_no')}} </th>
                <th>{{__('lang.unit_no')}} </th>
                <th>{{__('lang.customer')}}</th>
                <th>{{__('lang.booking_date')}}</th>
                @foreach($td_head as $key => $td)
                    <th>{{ $td }}</th>
                @endforeach
            </tr>
            
            </thead>
            <tbody>
                @php

                    
                    if(isset($schedule1[0])){
                        $my_schedule = $schedule1;
                    }else{
                        $my_schedule = $schedules;
                    }

                    $payable_count= [];
                    $count= 1;

                @endphp

                    
                    @foreach($my_schedule as $key_sch => $schedule)
                   
                    
                          
                    <tr>
                        <td>{{ $count }}</td> 
                        <th style="background-color: darkgray !important">{{ $sells[$key_sch]->product_name }}</th> 
                        <td >{{ $sells[$key_sch]->customer_name }}</td>
                        <td>{{ $transaction->date_format($sells[$key_sch]->booking_date) }}</td>
                
                        

                        @if(isset($schedule))
                            @foreach($td_head as $key => $td)
                                @php
                                    $check_array = [];
                                    
                                @endphp
                                @foreach($schedule as $key_sch_sub => $value)

                                    @php
                                        $month_year = $value->month.'-'.$value->year;
                                        
                                    @endphp

                                    @if($td == $month_year)
                                        @php
                                            array_push($check_array,$month_year);
                                            
                                        @endphp

                                        @if(isset($schedule1[$key_sch][$key_sch_sub]))

                                            @if($value->schedule_id != $schedules[$key_sch][$key_sch_sub]->schedule_id)

                                                <td scope="col" >{{ number_format($value->payable_amount) }}</td>

                                                @php
                                                    $payable_count[$month_year] += $schedule[$key_sch_sub]->payable_amount;
                                                @endphp

                                            @else

                                                <td scope="col">0</td>

                                            @endif

                                        @else

                                            <td scope="col" >{{ number_format($value->payable_amount) }}</td>
                                            @php
                                                $payable_count[$month_year] += $schedule[$key_sch_sub]->payable_amount;
                                            @endphp

                                        @endif
                                        
                                        
                                    @else 
                                        @php
                                            continue;
                                        @endphp

                                    @endif

                                @endforeach

                                @if (count($check_array) === 0)
                                    <td scope="col">0</td>
                                @endif

                            @endforeach
                        @else
                            <td scope="col">0</td>
                        @endif
                        

                    </tr>
                    @php
                        ++$count;
                    @endphp
                @endforeach
            </tbody>
            <tfoot>
                <tr>
                    <th colspan="4">{{__('lang.total')}}</th>

                    @foreach($td_head as $key => $td)
                        <th scope="col" >{{ number_format($payable_count[$td]) }}</th>
                    @endforeach
                </tr>
            </tfoot>
            
        </table> 
    </div>
</section>
@stop