@extends('layouts.admin')
@section('content')
<style type="text/css">
    .address-details p {
        margin-bottom: 0;
        font-size: 15px;
    }
</style>

<div class="container-fluid">
    <div class="row">

        <div class="col-md-12">
            <div class="card">
                <div class="card-body">
                    <form class="d-print-none" method="GET" action="{{ url()->current() }}">
                        <div class="row mb-3">

                            <div class="col-md-4">
                                <div class="form-group ">
                                    <label  class="col-form-label pt-0">Team</label>
                                    <select name="team_id" class="select2 form-control mb-3 custom-select">
                                        <option selected value="">Select One</option>
                                        @foreach ($teams as $team)
                                            <option {{ old('team_id') == $team->id ? 'selected' : '' }} value="{{ $team->id }}" >{{ $team->name }}</option>
                                        @endforeach
                                    </select>

                                </div>
                            </div>

                            <div class="col-md-3 mt-4">
                                <button class="btn btn-primary">Search</button>
                                <a href="{{ url()->current() }}" class="btn btn-danger">Clear</a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>

        <div class="col-md-12">
            <div class="card">
                <div class="card-header d-print-none">
                    <div class="row">
                        <div class="col-md-6">
                            <h5>Monthly Profit Ratio</h5>
                        </div>
                        <div class="col-md-6 text-right d-print-none">
                            <a href="javascript:window.print()" class="btn btn-info btn-sm"><i class="fa fa-print"></i></a>
                        </div>
                    </div>

                </div>
                <div class="card-body">
                    <!-- <form class="d-print-none" method="GET" action="{{ url()->current() }}">
                        <div class="row mb-3">

                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="startDate" class="col-form-label pt-0">Date From</label>
                                    <input class="form-control" readonly type="text" name="start_date" id="startDate" placeholder="Search Date"  value="{{ old('start_date')}}" autocomplete="off">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group ">
                                    <label for="endDate" class="col-form-label pt-0">Date To</label>
                                    <input class="form-control" readonly type="text" name="end_date" id="endDate" placeholder="End Date"  value="{{ old('end_date')}}" autocomplete="off">
                                </div>
                            </div>
                            <div class="col-md-3 mt-4">
                            <button class="btn btn-primary">Search</button>
                                <a href="{{url('account/monthly_profit_ratio')}}" class="btn btn-danger">Clear</a>
                            </div>
                        </div>
                    </form> -->
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="text-center mt-2">
                                <address class="font-10 address-details">
                                    <h3>{{get_option('app_name')}}</h3>
                                    <p>{{get_option('email')}}</p>
                                    <p><b>Monthly Profit Ratio</b></p>

                                </address>
                            </div>
                        </div>
                        <hr>
                        <div class="col-md-12">
                            <div class="table-responsive">
                                <table id="datatable-buttons-alllist" class="table table-striped table-bordered w-100">
                                    <thead>
                                        <tr>
                                            <th>Ratio</th>
                                            <th>Total Amount</th>
                                            <th>Total Profit</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        
                                                                                
                                        
                                        
                                        @foreach($deposits as $key=>$deposit)
                                        
                                                                                  
                                            <tr>
                                                <td colspan="3"><b>{{@model('User')::find($key)->name}}({{@model('User')::find($key)->user_id}})</b></td>
                                            </tr>
                                            @php
                                            $datass = collect($deposit)->groupBy('class_name')->map(function ($row) {
                                                return $row;
                                            });
                                            @endphp
                                            @foreach($datass as $row33)
                                            <tr>
                                                <td>
                                                    @php $c_name = collect($row33)->first()->class_name @endphp
                                                    {{\DB::table('classes')->where('value',$c_name)->first()->name}} - {{$retio_data->$c_name}}%
                                                </td>