@extends('backend.master')
@section('content')



    <div class="app-content my-3 my-md-5">


        <div class="side-app">


            <div class="page-header">
                <h4 class="page-title">ALL BUYERS</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="#">Home</a></li>
                    <li class="breadcrumb-item active" aria-current="page">Dashboard 01</li>
                </ol>
            </div>


            <div class="row">

                <div class="col-md-12 col-lg-12">
                    <div class="card">
                        <div class="card-header">
                            <div class="card-title">Data Tables</div>
                        </div>
                        <div class="card-body">

                            <div class="table-responsive">
                                <table id="example" class="table table-striped table-bordered" style="width:100%">
                                    <thead>
                                    <tr>
                                        <th class="wd-15p">File Number</th>
                                        <th class="wd-15p">Owner Name</th>
                                        <th class="wd-15p">Remaining Amount</th>
                                        <th class="wd-15p">Paid Amount</th>
                                        <th class="wd-15p">Total Installments Recieved</th>
                                        <th class="wd-15p">Installment Date/time</th>
                                        <th class="wd-15p">Entry Date/Time</th>


                                    </tr>
                                    </thead>
                                    <tbody>
                                         @php $total=0;$installment=0;  @endphp
                                    @foreach($buyers as $buyer)
                                   

                                        @foreach($buyer->plots as $plot)
                                        
                                                <tr>
                                                    <td>{{$plot->plot_file_no}}</td>
                                                    <td>{{$buyer->full_name}}</td>
                                                    @php
                                                        $paid=$buyer->advance_amount+$plot->buyerInstallments->sum('amount_payed');
                                                    $remaining=($plot->booking_price-$buyer->advance_amount)-$plot->buyerInstallments->sum('amount_payed');
                                                    @endphp
                                                    <td>{{$remaining}}</td>
                                                    <td>{{$paid}}</td>
                                                    <td>{{$plot->buyerInstallments->count()}}</td>
                                                    <td>{{$buyer->created_at->format('d')}} of every month</td>
                                                    <td>{{$buyer->created_at}}</td>
                                                    

                                                </tr>
                                                 @php 
                                                 $total+=$plot->buyerInstallments->sum('amount_payed');
                                                 $installment+=$plot->buyerInstallments->count();
                                                 
                                                 @endphp

                                        @endforeach

                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                            
                        </div>
                          <div class="d-flex  justify-content-center">
                                        <h4><b>Total Installments Amount </b>: {{$total}}  </h4> &nbsp&nbsp&nbsp <h4><b> No of Installments  </b>: {{$installment}}</h4>
                                    </div>
                        <!-- table-wrapper -->
                    </div>
                    <!-- section-wrapper -->

                </div>
            </div>
        </div>
    </div>
@stop