@extends('layouts.dashboard')
@section('content')
    <div class="dashboard-payouts">
        <div class="container-fluid">
            <div class="row no-gutters dashboard-content-wrap mx-2">
                <div class="col-12">
                    <div class="dashboard-maincontent">
                        <div class="dashboard-transactions d-flex flex-column mx-4 p-5 my-5">

                            <h2 class="mb-5">Investments</h2>
                            <div class="dashboard-transactions-table-wrap mb-5 table-responsive">
                                <table class="table table-borderless">
                                    <thead>
                                      <tr>
                                        <th scope="col">Cycle</th>
                                        <th scope="col">Amount Due</th>
                                        <th scope="col">Amount Paid</th>
                                        <th scope="col">Amount Unpaid</th>
                                      </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($farmInvested as $farm)
                                        <tr>
                                            <td>
                                                <div class="table-content">
                                                    {{$farm->name}}
                                                </div>
                                            </td>

                                            <td>
                                                <div class="table-content">
                                                    <span class="text">NGN {{number_format($farm->totalAmountSponsoredWithROIBy(auth()->id()))}}</span>
                                                </div>
                                            </td>

                                            <td>
                                                <div class="table-content">
                                                    @php $paidAmount = \App\Models\Tracker::where(['user_id' => auth()->id(),'farm_id' => $farm->id])->sum('amount') @endphp
                                                    <span class="text">NGN {{number_format($paidAmount)}}</span>
                                                </div>
                                            </td>

                                            <td>
                                                <div class="table-content">
                                                    <span class="text">NGN {{number_format($farm->totalAmountSponsoredWithROIBy(auth()->id()) - $paidAmount)}}</span>
                                                </div>
                                            </td>
                                        </tr>

                                    @endforeach
                                    </tbody>
                                </table>
                                <br><br>
                                <h2 class="mt-5">Payout Tracker Details</h2>

                                <table class="table table-borderless">
                                    <thead>
                                    <tr>
                                        <th scope="col">Cycle</th>
                                        <th scope="col">Amount Paid</th>
                                        <th scope="col">Date Paid</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach(auth()->user()->trackers as $track)
                                        <tr>
                                            <td>
                                                <div class="table-content">
                                                    {{$track->farm->name}}
                                                </div>
                                            </td>

                                            <td>
                                                <div class="table-content">
                                                    <span class="text">{{$track->formattedAmount}}</span>
                                                </div>
                                            </td>

                                            <td>
                                                <div class="table-content">
                                                    <span class="text">{{$track->created_at->format('d-m-Y')}}</span>
                                                </div>
                                            </td>
                                        </tr>

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

                    </div>
                </div>

            </div>
        </div>
    </div>
@endsection