@extends('mainlayout.layout')
@php
use App\Models\Order;
use App\Models\Transactions;
@endphp

@section('title')
{{env('APP_NAME')}} | {{$owner->name}}
@endsection


@php

use App\Models\{Property,PropertyOwner,Customer,PropertyPlotPricing,LandUse,PropertyPlot};

$propertyids= Property::where('propertyownerid', $owner->id)->pluck('id')

@endphp


@push('css')
<link href="{{ asset('/web/assets/libs/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}" rel="stylesheet"
    type="text/css">
<link rel="stylesheet" href="{{ asset('/web/assets/libs/@chenfengyuan/datepicker/datepicker.min.css')}}">

<link rel="stylesheet" href="/font-awesome/css/font-awesome.min.css">

@endpush


@section('content')

<!-- 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">
                <span style="color:green">PROJECT OWNER
                </span>
            </h4>
        </div>
    </div>
</div>
<!-- end page title -->

<div class="row">


    <div class="col-lg-12">
        <div class="card">
            <div class="card-body">

                <div class="row">

                    <div class="col-4 col-sm-4 col-xs-4 col-md-4">
                        <a href="/propertyowner/edit/@encrypt($owner->id)" style="width:100%" class="mb-0 text-coffee">
                            <i class="fa fa-pencil" aria-hidden="true"></i>Edit Owner
                        </a>

                    </div>

                    <div class="col-4 col-sm-4 col-xs-4 col-md-4">
                        <a href="/propertyowner/editbankdetails/@encrypt($owner->id)" style="width:100%"
                            class="mb-0 text-coffee">
                            <i class="fa fa-pencil" aria-hidden="true"></i>Bank Details
                        </a>

                    </div>
                </div>



                <div class="row mt-2">


                    <div class="col-lg-12 align-items-left mt-2">
                        <div class="text-lg-left mt-4 mt-lg-0">
                            <div class="row mb-4">
                                <div class=" col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Owner's Name</p>
                                        <h5 class="mb-0"><a
                                                href="/propertyowner/show/@encrypt($owner->id)">{{$owner->name}}</a>
                                        </h5>
                                    </div>
                                </div>
                                <div class=" col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Mobile number</p>
                                        <h5 class="mb-0">{{$owner->mobilenumber}}</h5>
                                    </div>
                                </div>
                                <div class="col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Email</p>
                                        <h5 class="mb-0">{{$owner->email}}
                                        </h5>
                                    </div>
                                </div>

                                <div class=" col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Address</p>
                                        <h5 class="mb-0">{{$owner->address}}</h5>
                                    </div>
                                </div>

                                <div class="col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Registered On</p>
                                        <h5 class="mb-0">{{$owner->created_at}}</h5>
                                    </div>
                                </div>



                            </div>

                            @if(!empty($owner->bank))
                            <div class="row mb-4">
                                <div class=" col-sm-12 col-xs-12 col-md-3">
                                    <div>
                                        <p class="text-muted mb-2">Bank</p>
                                        <h5 class="mb-0">{{App\Models\BankList::find($owner->bank)->name}}
                                        </h5>
                                    </div>
                                </div>

                                <div class=" col-sm-12 col-xs-12 col-md-3">
                                    <div>
                                        <p class="text-muted mb-2">Account Name</p>
                                        <h5 class="mb-0">{{$owner->accountname}}
                                        </h5>
                                    </div>
                                </div>

                                <div class=" col-sm-12 col-xs-12 col-md-3">
                                    <div>
                                        <p class="text-muted mb-2">Account Number</p>
                                        <h5 class="mb-0">{{$owner->accountnumber}}
                                        </h5>
                                    </div>
                                </div>

                                <!--  <div class=" col-sm-12 col-xs-12 col-md-3">
                                    <div>
                                        <p class="text-muted mb-2">Swift Code</p>
                                        <h5 class="mb-0">{{$owner->swiftcode}}
                                        </h5>
                                    </div>
                                </div> -->
                            </div>

                            @endif

                            <div class="row mb-4">
                                <div class=" col-sm-12 col-xs-12 col-md-3">
                                    <div>
                                        <p class="text-muted mb-2">Owner Description</p>
                                        <h5 class="mb-0">{{$owner->description}}
                                        </h5>
                                    </div>
                                </div>

                            </div>





                        </div>
                    </div>

                </div>


            </div>
        </div>

    </div>

</div>

<!---- client information ---->



<div class="row">


    <div class="col-lg-12">
        <div class="card">
            <div class="card-body">



                <div class="row mt-2">


                    <div class="col-lg-12 align-items-left mt-2">
                        <div class="text-lg-left mt-4 mt-lg-0">
                            <div class="row mb-4">
                                <div class="col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Projects</p>
                                        <h5 class="mb-0">{{$owner->projects->count()}}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Plots</p>
                                        <h5 class="mb-0">
                                            {{$plotscount}}

                                        </h5>
                                    </div>
                                </div>
                                <div class=" col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Sold Plots</p>
                                        <h5 class="mb-0">
                                            {{Order::wherein('propertyid',$propertyids)->where('status',2)->count()}}
                                        </h5>
                                    </div>
                                </div>
                                <div class=" col-sm-2 col-xs-2 col-md-2">
                                    <div>
                                        <p class="text-muted mb-2">Revenue </p>
                                        <h5 class="mb-0">

                                            TZS
                                            {{number_format(Order::wherein('propertyid',$propertyids)->where('status',2)->sum('amount'),0,'.',',')}}
                                        </h5>
                                    </div>
                                </div>






                            </div>



                        </div>
                    </div>

                </div>


            </div>
        </div>

    </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',$owner->id)->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',$owner->id)->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>








<!-- 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">Payment Transaction
            </h4>



        </div>
    </div>
</div>
<!-- end page title -->


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

                <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>Reference</th>

                                <th>Transaction ID</th>
                                <th>Receipt</th>
                                <th>Project</th>
                                <th>Plot ID</th>


                                <th>Date</th>
                                <th>Source</th>
                                <th>Amount</th>

                                <th>Status</th>




                            </tr>
                        </thead>
                        <tbody>
                            @php

                            $transactions=Transactions::wherein('propertyid',$propertyids)->get();
                            $total_amount=0;
                            @endphp
                            @foreach($transactions as $index => $transaction)
                            <tr>
                                <td>{{++$index}}</td>
                                <td><a
                                        href="/property/plotshow/@encrypt($transaction->plotid)">{{$transaction->reference}}</a>
                                </td>

                                <td>{{$transaction->transactionId}}</td>
                                <td>{{$transaction->receipt}}</td>

                                <td><a
                                        href="/property/show/@encrypt($transaction->propertyid)">{{Property::find($transaction->propertyid)->name}}</a>
                                </td>
                                <td><a
                                        href="/property/plotshow/@encrypt($transaction->plotid)">{{PropertyPlot::find($transaction->plotid)->plotnumber}}</a>
                                </td>

                                <td>{{$transaction->created_at}}</td>
                                <td>{{$transaction->sourceInstitution}}</td>
                                <td>TZS {{number_format($transaction->amount_paid, 0, '.', ',')}}</td>

                                <td>
                                    <span @if(Order::where('referenceid',$transaction->reference)->first()->status==2)
                                        style="color:#e67e22" @endif>
                                        {{Order::where('referenceid',$transaction->reference)->first()->status_description}}
                                    </span>
                                </td>

                            </tr>
                            @php

                            $total_amount=$total_amount+$transaction->amount_paid;
                            @endphp

                            @endforeach

                        </tbody>

                        <tfoot>
                            <tr style="background-color:#34495e;padding:0.5em 0.25em; color:#ffffff;">
                                <td colspan="8">
                                    TOTAL
                                </td>
                                <td colspan="2"><b>TZS {{number_format($total_amount,0,'.',',')}}</b></td>

                            </tr>

                        </tfoot>
                    </table>
                </div>



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







@endsection


@push('scripts')

<script src="{{ asset('/web/assets/libs/@chenfengyuan/datepicker/datepicker.min.js')}}"></script>

<script src="{{ asset('/web/assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>

@endpush