@php

use App\Models\{Property,PropertyOwner,Customer,PropertyPlot,User,Order};

$propertyids = Property::where('propertyownerid', Auth::user()->propertyownerid)->pluck('id');

$customerids = Order::whereIn('propertyid', $propertyids)->pluck('userid')->toArray();

$customers = User::whereIn('uid', $customerids)->get();


$orders=Order::whereIn('propertyid', $propertyids)->get();


@endphp
<div class="row">

    <div class="col-xl-12">
        <div class="row">
            <div class="col-sm-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex align-items-center mb-3">
                            <div class="avatar-xs mr-3">
                                <span class="avatar-title rounded-circle bg-soft-primary text-primary font-size-18">
                                    <i class="bx bx-copy-alt"></i>
                                </span>
                            </div>
                            <h5 class="font-size-14 mb-0">Projects</h5>
                        </div>
                        <div class="row mt-12">
                            <div class="col-sm-12">
                                <div class="text-muted" style="text-align: center;">
                                    <div class="d-flex">
                                        <span class="text-truncate">Total Projects</span>
                                    </div>

                                    <h4>{{Property::where('propertyownerid',Auth::user()->propertyownerid)->count()}}
                                    </h4>

                                </div>
                            </div>


                        </div>
                    </div>
                </div>
            </div>

            <div class="col-sm-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex align-items-center mb-3">
                            <div class="avatar-xs mr-3">
                                <span class="avatar-title rounded-circle bg-soft-primary text-primary font-size-18">
                                    <i class="bx bx-archive-in"></i>
                                </span>
                            </div>
                            <h5 class="font-size-14 mb-0">Plots</h5>
                        </div>
                        <div class="row mt-12">
                            <div class="col-sm-12">
                                <div class="text-muted" style="text-align: center;">
                                    <div class="d-flex">
                                        <span class="text-truncate">Total Plots</span>
                                    </div>


                                    @php

                                    $project_ids=Property::where('propertyownerid',Auth::user()->propertyownerid)->pluck('id');


                                    $propertyplots=PropertyPlot::whereIn('propertyid',$project_ids)->count();;


                                    @endphp
                                    <h4>{{$propertyplots}}
                                    </h4>

                                </div>
                            </div>


                        </div>
                    </div>
                </div>
            </div>


            <div class="col-sm-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex align-items-center mb-3">
                            <div class="avatar-xs mr-3">
                                <span class="avatar-title rounded-circle bg-soft-primary text-primary font-size-18">
                                    <i class="bx bx-archive-in"></i>
                                </span>
                            </div>
                            <h5 class="font-size-14 mb-0">Customers</h5>
                        </div>
                        <div class="row mt-12">
                            <div class="col-sm-12">
                                <div class="text-muted" style="text-align: center;">
                                    <div class="d-flex">
                                        <span class="text-truncate">Total Customers</span>
                                    </div>

                                    <h4>
                                        {{count($customers)}} </h4>

                                </div>
                            </div>


                        </div>
                    </div>
                </div>
            </div>

        </div>
        <!-- end row -->
    </div>
</div>

<div class="row">

    <div class="col-xl-12">
        <div class="row">

            <div class="col-sm-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex align-items-center mb-3">
                            <div class="avatar-xs mr-3">
                                <span class="avatar-title rounded-circle bg-soft-primary text-primary font-size-18">
                                    <i class="bx bx-archive-in"></i>
                                </span>
                            </div>
                            <h5 class="font-size-14 mb-0">Amount Ordered</h5>
                        </div>
                        <div class="row mt-4">
                            <div class="col-sm-6">
                                <div class="text-muted">
                                    <div class="d-flex">
                                        <span class="text-truncate">This Year</span>
                                    </div>
                                    <h4 style="color:#e67e22;">TZS
                                        {{number_format(Order::whereIn('propertyid',
                                        $propertyids)->whereYear('created_at',date('Y'))->sum('amount'),0,'.',',')}}
                                    </h4>

                                </div>
                            </div>
                            <div class="col-sm-6">
                                <div class="text-muted">
                                    <div class="d-flex">
                                        <span class="text-truncate">This Month</span>
                                    </div>
                                    <h4 style="color:#e67e22;">TZS
                                        {{number_format(Order::whereIn('propertyid',
                                        $propertyids)->whereYear('created_at',date('Y'))->whereMonth('created_at',date('M'))->sum('amount'),0,'.',',')}}
                                    </h4>

                                </div>
                            </div>

                        </div>
                    </div>
                </div>
            </div>



            <div class="col-sm-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex align-items-center mb-3">
                            <div class="avatar-xs mr-3">
                                <span class="avatar-title rounded-circle bg-soft-primary text-primary font-size-18">
                                    <i class="bx bx-copy-alt"></i>
                                </span>
                            </div>
                            <h5 class="font-size-14 mb-0">Completed Orders</h5>
                        </div>
                        <div class="row mt-4">
                            <div class="col-sm-6">
                                <div class="text-muted">
                                    <div class="d-flex">
                                        <span class="text-truncate">This Year</span>
                                    </div>
                                    <h4 style="color:#e67e22;">
                                        {{Order::whereIn('propertyid',$propertyids)->whereYear('created_at',date('Y'))->where('status',2)->count()}}
                                    </h4>

                                </div>
                            </div>
                            <div class="col-sm-6">
                                <div class="text-muted">
                                    <div class="d-flex">
                                        <span class="text-truncate">This Month</span>
                                    </div>
                                    <h4 style="color:#e67e22;">
                                        {{Order::whereIn('propertyid',$propertyids)->whereYear('created_at',date('Y'))->whereMonth('created_at',date('M'))->where('status',2)->count()}}
                                    </h4>

                                </div>
                            </div>

                        </div>
                    </div>
                </div>
            </div>




            <div class="col-sm-4">
                <div class="card">
                    <div class="card-body">
                        <div class="d-flex align-items-center mb-3">
                            <div class="avatar-xs mr-3">
                                <span class="avatar-title rounded-circle bg-soft-primary text-primary font-size-18">
                                    <i class="bx bx-archive-in"></i>
                                </span>
                            </div>
                            <h5 class="font-size-14 mb-0">Completed Order Amount</h5>
                        </div>
                        <div class="row mt-4">
                            <div class="col-sm-6">
                                <div class="text-muted">
                                    <div class="d-flex">
                                        <span class="text-truncate">This Year</span>
                                    </div>
                                    <h4 style="color:#e67e22;">TZS
                                        {{number_format(Order::whereIn('propertyid',
                                        $propertyids)->whereYear('created_at',date('Y'))->where('status',2)->sum('amount'),0,'.',',')}}
                                    </h4>

                                </div>
                            </div>
                            <div class="col-sm-6">
                                <div class="text-muted">
                                    <div class="d-flex">
                                        <span class="text-truncate">This Month</span>
                                    </div>
                                    <h4 style="color:#e67e22;">TZS
                                        {{number_format(Order::whereIn('propertyid',
                                        $propertyids)->whereYear('created_at',date('Y'))->whereMonth('created_at',date('M'))->where('status',2)->sum('amount'),0,'.',',')}}
                                    </h4>

                                </div>
                            </div>

                        </div>
                    </div>
                </div>
            </div>




        </div>
        <!-- end row -->
    </div>
</div>




<!-- start page title -->
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-flex align-items-center justify-content-between">
            <h4 class="mb-0 font-size-18">Projects</h4>
        </div>
    </div>
</div>
<!-- end page title -->

<div class="row">
    <div class="col-xl-12">
        <div class="card">
            <div class="card-body">

                <p class="text-muted">
                    <b>{{Property::where('propertyownerid',Auth::user()->propertyownerid)->count()}}</b> Results
                    Found
                </p>

                <div class="table-responsive">

                    <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap"
                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">

                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Name</th>
                                <th>Status Description</th>

                                <th>Created On</th>
                                <th>Action</th>

                            </tr>
                        </thead>
                        <tbody>
                            @foreach(Property::where('propertyownerid',Auth::user()->propertyownerid)->get() as $index
                            => $p)
                            <tr>
                                <th scope="row"> <a href="/property/show/@encrypt($p->id)"> {{++$index}}</a></th>
                                <td><a href="/property/show/@encrypt($p->id)">{{$p->name}} </a></td>
                                <td>{{$p->status_description}}</td>

                                <td>{{$p->created_at}}</td>
                                <td><a href="/property/show/@encrypt($p->id)"
                                        class="text-coffee  p-1 btn btn-primary">View More</a></td>


                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>

            </div>
        </div>
    </div>
</div>