@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-header d-print-none">
                        <div class="row">
                            <div class="col-md-6">
                                <h5>Agent sales report</h5>
                            </div>
                        </div>

                    </div>
                    <div class="card-body">
                        <div class="row">

                            <div class="col-md-12 d-print-none" >

                                <form method="GET" action="{{ url()->current() }}">
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="form-group ">
                                                <label  class="col-form-label pt-0">Search Member</label>
                                                <select name="user_id" class="select2 form-control mb-3 custom-selec">
                                                    <option disabled="" selected value="">Select One</option>
                                                    @foreach ($members as $mm)
                                                        <option {{ old('user_id') == $mm->id ? 'selected' : '' }} value="{{ $mm->id }}" >{{ $mm->name }}-{{$mm->user_id}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>

                                        <div class="col-md-4">
                                            <div class="form-group ">
                                                <label  class="col-form-label pt-0">Status</label>
                                                <select name="commission_status" class="select2 form-control mb-3 custom-selec">
                                                    <option  value="">Select One</option>
                                                    <option {{ old('commission_status') == '1' ? 'selected' : '' }} value="1" >Active</option>
                                                    <option {{ old('commission_status') == '2' ? 'selected' : '' }} value="2" >Inactive</option>
                                                </select>

                                            </div>
                                        </div>

                                        <div class="col-md-4" style="margin-top: 23px">
                                            <div class="form-group">
                                                <button class="btn btn-primary">Search</button>
                                                <a href="{{ url()->current() }}" class="btn btn-danger">Clear</a>

                                            </div>
                                        </div>
                                    </div>
                                </form>
                            </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> Name</th>
                                            <th>{{now()->subMonth(2)->format('M')}}, {{now()->subMonth(1)->format('M')}}, {{now()->format('M')}} Sell</th>
                                            <th>{{now()->subMonth(1)->format('M')}} Sell</th>
                                            <th>{{now()->format('M')}} Sell</th>
                                            <th>{{now()->subMonth(2)->format('M')}}, {{now()->subMonth(1)->format('M')}}, {{now()->format('M')}} Team Sell</th>
                                            <th>{{now()->subMonth(1)->format('M')}} Team Sell</th>
                                            <th>{{now()->format('M')}} Team Sell</th>
                                            <th>Current Commission</th>
                                            <th>Target</th>
                                            <th>Percentage</th>
                                            <th>Applicable Personal Sell</th>
                                            <th>Applicable Team Sell</th>
                                            <th>Expiry Start Date</th>
                                            <th>Expiry End Date</th>
                                            <th>Action</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                            @foreach($users as $member)
                                                <tr>
                                                    <td>{{ $member->name }} ({{$member->user_id }})</td>
                                                    @php 
                                                    $month_sell = member_last_3month_sell($member->id);
                                                    $p_target_amount = p_target($member->id);
                                                     @endphp
                                                    <td><a target="_blank" href="{{ route('account.agent_sales_report_type',['last_3_month_sales', $member->id]) }}">{{ $month_sell }}</a></td>
                                                    <td><a href="{{ route('account.agent_sales_report_type',['last_month_sales', $member->id]) }}" target="_blank">{{ agent_last_month_sell($member->id) }}</a></td>
                                                    <td><a href="{{ route('account.agent_sales_report_type',['this_month_sales', $member->id]) }}" target="_blank">{{ agent_this_month_sell($member->id) }}</a></td>
                                                    <td><a href="{{ route('account.agent_sales_report_type',['last_3_month_team_sales', $member->id]) }}" target="_blank">{{ agent_last_3month_team_sell($member->id) }}</a></td>
                                                    <td><a href="{{ route('account.agent_sales_report_type',['last_month_team_sales', $member->id]) }}" target="_blank">{{ agent_last_month_team_sell($member->id) }}</a></td>
                                                    <td><a href="{{ route('account.agent_sales_report_type',['this_month_team_sales', $member->id]) }}" target="_blank">{{ agent_this_month_team_sell($member->id) }}</a></td>
                                                    <td>{{ round(current_commission($member->id)) }}</td>
                                                    <td>P:{{ $p_target_amount }} T:{{ t_target($member->id) }}</td>
                                                    <td>
                                                        @if($month_sell>0 && $p_target_amount>0)
                                                        @php
                                                        $per_amount = $p_target_amount/100;
                                                        @endphp
                                                        {{round($month_sell/$per_amount)}}%
                                                        @else
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        <form action="{{ route('account.update_applicable_personal_sell_status', $member->id) }}" method="post">
                                                            @csrf
                                                            <input style="font-size: 13px;padding: 0px 6px;" onclick="return confirm('Are you sure')" class="btn btn-{{ $member->applicable_personal_sell == 1 ? 'primary' : 'danger' }} btn-sm" type="submit" value="{{$member->applicable_personal_sell ==1 ? 'Yes' : 'No' }}" />
                                                        </form>
                                                    </td>
                                                    <td class="text-center">
                                                        <form action="{{ route('account.update_applicable_team_sell_status', $member->id) }}" method="post">
                                                            @csrf
                                                            <input style="font-size: 13px;padding: 0px 6px;" onclick="return confirm('Are you sure')" class="btn btn-{{ $member->applicable_team_sell == 1 ? 'primary' : 'danger' }} btn-sm" type="submit" value="{{$member->applicable_team_sell ==1 ? 'Yes' : 'No' }}" />
                                                        </form>
                                                    </td>
                                                    <td>{{ $member->commission_expiry_start_date != '' ? date('d-m-Y', strtotime($member->commission_expiry_start_date)) : '' }}</td>
                                                    <td>{{ $member->commission_expiry_end_date != '' ? date('d-m-Y', strtotime($member->commission_expiry_end_date)) : '' }}</td>
                                                    <td>
                                                        <form action="{{ route('account.update_commission_status', $member->id) }}" method="post">
                                                            @csrf
                                                            <input style="font-size: 13px" onclick="return confirm('Are you sure')" class="btn btn-{{ $member->commission_status == 0 ? 'danger' : 'primary' }} btn-sm" type="submit" value="{{$member->commission_status == 0 ? 'Inactive' : 'Active' }}" />
                                                            @if( $member->commission_status == 0)
                                                            <a title="Active with Expiry Date" data-url="{{ route('account.active_with_expiry_date', $member->id) }}" data-title="Active with Expiry Date" class="open_modal_page btn btn-success btn-sm"><i class="fa fa-calendar-alt"></i></a>
                                                            @endif
                                                        </form>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                    <div style="float: right">
                                        {{ $users->appends(request()->query())->links() }}
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div> <!-- end col -->
        </div><!--end row-->

    </div> <!-- container-fluid -->

    @push('alljs')

    @endpush
@endsection