@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;
            @php
            echo $type =='show' ? 'margin: 30px 50px auto;' : '' ;
            @endphp
        }

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

        body,
        table {
            font-size: 1rem;
        }

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

        table td {
            border-top: 0px;
        }

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

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

        table th {
            background: #000 !important;
        }

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

        .g-total {
            font-size: 12px !important;
        }
        .gray{
            background: rgb(207, 204, 204) !important;
        }
        .font-bold{
            font-weight: bold;
        }
        .font-12{
            font-size: 12px !important;
        }

        .page-break {
            page-break-before: always;
        }
    </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>

    <div size="A4">
        @include('admin.partials.header', ['extra' => $extra])

        <table class="table  table-bordered" style="border-top: 0px !important">
            <thead>
                <tr class= "fixed_tr">
                    <th class = "text-center">{{__('lang.sno')}}</th>
                    <th>{{__('lang.project')}}</th>
                    <th>{{__('lang.registration_no')}}</th>
                    <th >{{__('lang.unit_no')}}</th>
                    <th>{{__('lang.size')}}</th>
                    <th class = "text-right">{{__('lang.rps')}}</th>
                    <th>{{__('lang.sale_date')}}</th>
                    <th class = "text-right">{{__('lang.property_value')}}</th>
                    <th class = "text-right">{{__('lang.extra_charges')}}</th>
                    <th class = "text-right">{{__('lang.discount')}}</th>
                    <th class = "text-right">{{__('lang.sale_amount')}}</th>
                    <th class = "text-right">{{__('lang.total_collection')}}</th>
                    <th class = "text-right">{{__('lang.due_amount')}}</th>
                    <th class = "text-right">{{__('lang.till_month_due')}}</th>
                    <th class = "text-right">{{__('lang.last_payment_date')}}</th>
                    <th class = "text-center">{{__('lang.status')}}</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $total_product_value          = 0;
                    $total_additional_charges     = 0;
                    $total_discount               = 0;
                    $total_schedule_amount        = 0;
                    $total_collected_amount       = 0;
                    $total_due_amount             = 0;
                    $total_till_month_due_amount  = 0;
                @endphp

                @foreach ($sells_data as $product_type =>  $sells )
                    
                    @php
                        $group_total_product_value          = 0;
                        $group_total_additional_charges     = 0;
                        $group_total_discount               = 0;
                        $group_total_schedule_amount        = 0;
                        $group_total_collected_amount       = 0;
                        $group_total_due_amount             = 0;
                        $group_total_till_month_due_amount  = 0;
                    @endphp

                    <tr>
                        <th colspan="100%">
                            {{ $product_type }}
                        </th>
                    </tr>
                    @foreach ($sells as $sell)
                        @php
                            $schedule               = $sell->ScheduleReceivableWithoutDiscount;
                            $till_month_schedule    = $sell->all_till_month_due;
                            $product                = $sell->product;

                            $product_value          = $product->rate_per_size * $product->flat_size;
                            $additional_charges     = $sell->additional_charges;
                            $discount               = $sell->discount_amount;
                            $schedule_amount        = $schedule->sum('payable_amount');
                            $collected_amount       = $received_amounts[$sell->id];
                            $due_amount             = $schedule_amount - $collected_amount;
                            $till_month_due_amount  = $till_month_schedule->sum('payable_amount') - $till_month_schedule->sum('payment_received_amount');
                            $last_payment_date      = $sell->lastActualReceivedByDate()->date_of_collection_new;
                            $status                 = $sell->status;

                            $branch_route           = route('project-manage.edit',['id'          => $sell->branch_id]);
                            $schedule_route         = route('schedule_manage'    ,['sell_id'   => $sell->id]);
                            $product_route          = route('product.edit'       ,['id'          => $product->id]);

                            // Badge Start
                            $badge_class = '';
                            if ($sell->is_transfered) {
                                $status      = __('lang.transfer');
                                $badge_class = 'badge-danger';
                            }
                            else{
                                if($status == 'ACTIVE') {
                                    $badge_class = 'badge-success';
                                }
                                elseif($status == 'CANCELLED') {
                                    $badge_class = 'badge-danger';
                                }
                                elseif($status == 'BUY BACK') {
                                    $badge_class = 'badge-info';
                                }
                                elseif($status == 'FULL PAID') {
                                    $badge_class = 'badge-dark';
                                }
                                else{
                                    $badge_class = 'badge-warning';
                                }
                            }

                            $group_total_product_value          += $product_value;
                            $group_total_additional_charges     += $additional_charges;
                            $group_total_discount               += $discount;
                            $group_total_schedule_amount        += $schedule_amount;
                            $group_total_collected_amount       += $collected_amount;
                            $group_total_due_amount             += $due_amount;
                            $group_total_till_month_due_amount  += $till_month_due_amount;

                            $total_product_value                += $product_value;
                            $total_additional_charges           += $additional_charges;
                            $total_discount                     += $discount;
                            $total_schedule_amount              += $schedule_amount;
                            $total_collected_amount             += $collected_amount;
                            $total_due_amount                   += $due_amount;
                            $total_till_month_due_amount        += $till_month_due_amount;


                        @endphp
                        <tr>
                            <td>{{$loop->iteration}}</td>
                            <td><a href="{{$branch_route}}"   target="_blank">{{$sell->branch->name}}</a></td>
                            <td><a href="{{$schedule_route}}" target="_blank">{{$sell->registration_no}}</a></td>
                            <td><a href="{{$product_route}}"  target="_blank">{{$product->product_unique_id}}</a></td>
                            <td>{{$product->flat_size}} {{$product->size_in}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($product->rate_per_size)}}</td>
                            <td>{{$sell->sale_date_v2}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($product_value)}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($additional_charges)}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($discount)}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($schedule_amount)}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($collected_amount)}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($due_amount)}}</td>
                            <td class = "text-right">{{$transaction->convert_money_format($till_month_due_amount)}}</td>
                            <td class = "text-right">{{$transaction->date_format($last_payment_date)}}</td>
                            <td class="text-center">
                                <span style="font-size: 12px!important; text-align:center" class="badge {{ $badge_class }}">
                                    {{ $status }}
                                </span>
                            </td>
                        </tr>
                    @endforeach

                    <tr>
                        <th colspan="7" class = "text-right">{{ $product_type }} {{__('lang.total')}}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_product_value) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_additional_charges) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_discount) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_schedule_amount) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_collected_amount) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_due_amount) }}</th>
                        <th class = "text-right">{{ $transaction->convert_money_format($group_total_till_month_due_amount) }}</th>
                        <th colspan="2"></th>                    
                    </tr>

                    <tr><td colspan="100%"></td></tr>
                @endforeach

                <tr><td colspan="100%"></td></tr>

                <tr>
                    <th colspan="100%" class="text-right g-total">
                        {{__('lang.total_schedule_amount')}} | {{ $transaction->convert_money_format($total_schedule_amount) }}
                    </th>
                </tr>

                <tr><td colspan="100%"></td></tr>

                <tr>
                    <th colspan="100% " class="text-right g-total">
                        {{__('lang.total_collected')}} | {{ $transaction->convert_money_format($total_collected_amount) }}
                    </th>
                </tr>

                <tr><td colspan="100%"></td></tr>

                <tr>
                    <th colspan="100%" class="text-right g-total">
                        {{__('lang.total_balance')}} | {{ $transaction->convert_money_format($total_due_amount) }}
                    </th>
                </tr>

                <tr><td colspan="100%"></td></tr>

                <tr>
                    <th colspan="100%" class="text-right g-total" style="">
                        {{__('lang.total_due_till_month')}} | {{ $transaction->convert_money_format($total_till_month_due_amount) }}
                    </th>
                </tr>

            </tbody>
        </table>    
    </div>

    <div class="page-break"></div>
    <div class="row justify-content-center m-b-20">
        <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12">
            <div class="header">
                <h3>Collected And Balance Amount</h3>
            </div>
            <div>
                <img src="https://quickchart.io/chart?c={{ urlencode(json_encode([
                    'type' => 'pie',
                    'data' => [
                        'labels' => ['Total Collected Amount', 'Total Balance Amount'],
                        'datasets' => [[
                            'data' => [$total_collected_amount, $total_due_amount],
                            'backgroundColor' => ['#6695c7', '#135193'],
                        ]]
                    ],
                    'options' => [
                        'plugins' => [
                            'datalabels' => [
                                'color' => '#000000',
                                'font' => [
                                    'size' => 10
                                ]
                            ],
                            'legend' => [
                                'labels' => [
                                    'color' => '#000000',
                                ]
                            ]
                        ]
                    ]
                ])) }}&width=200&height=200" alt="Chart Image" style="max-width: 100%; height: auto;">
            </div>
        </div>
    </div>
@stop