@extends('layouts.main')
@section('content')

@php

    $invest = DB::table('invest')->paginate(10);


@endphp

    <div class="col-lg-12">
        <div class="card">
            <div class="card-body">
                <h4 class="card-title">List of All Investment</h4>
                <br>
                <div class="table-responsive">
                    <table class="table color-table primary-table">
                        <thead>
                            <tr>
                                <th scope="col">Date Invested</th>
                                <th scope="col">Username</th>
                                <th scope="col">Amount</th>
                                <th scope="col">Daily Income</th>
                                <th scope="col">Total Earned</th>
                                <th scope="col">Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if ($invest->count() > 0)
                            @foreach ($invest as $inv)
                            <tr>
                                <td>
                                    {{ \Carbon\Carbon::parse($inv->created_at)->diffForHumans() }}
                           
                                </td>

                                <td style="text-transform: lowercase">
                                    <a href="/admin/users/detail/103">
                                        <u>
                                            @php
                                                $usr = DB::table('users')->where('id', $inv->user_id)->first();
                                            @endphp
                                            {{ $usr->username ?? "Empty"}}
                                        </u>
                                    </a>
                                </td>
                                <td>
                                    KSH {{ $inv->capital }}
                                </td>
                                <td>
                                    KSH {{ $inv->returns }}
                                </td>
                                <td>
                                    <b> KSH {{ $inv->returns * $inv->days_paid }}</b>
                                </td>
                                <td>
                                  
                                        @if ($inv->status == 1)
                                        <span class="badge  badge-success">
                                            Active
                                        </span>
                                        @else
                                        <span class="badge  badge-warning">
                                            Inactive
                                        </span>
                                        @endif


                                   
                                </td>
                            </tr>
                            @endforeach

                            @else
    
                            <tr>
                                <td colspan="full">
                                    <p>No Data found</p>
                                </td>
                            </tr>
    
                            @endif
                        </tbody>
                    </table>
                </div>
                <div class="card-footer py-4">
                    <div class="row">
                        {!! $invest->withQueryString()->links('pagination::bootstrap-5') !!}
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection