@extends('layouts.admin')

@section('content')
    @push('css')

    @endpush
    <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 Target And Achieve Sheet ( {{ date('M-Y', strtotime($last_month)) }} - {{ date('M-Y', strtotime($current_month)) }} )</h5>
                            </div>

                        </div>

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

                            <div class="row mb-3">

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

                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label for="name" class="col-form-label pt-0">Start Month</label>
                                        <input class="form-control" readonly type="text" value="{{ old('start_month') ? date('F-Y', strtotime(old('start_month'))) : '' }}" name="start_month" id="star_month"  >
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label for="name" class="col-form-label pt-0">End Month</label>
                                        <input class="form-control" readonly type="text" value="{{ old('end_month') ? date('F-Y', strtotime(old('end_month'))): '' }}" name="end_month" id="end_month" >
                                    </div>
                                </div>

                                <div class="col-md-3" style="margin-top: 25px;">
                                    <button class="btn btn-primary" type="submit">Search</button>
                                    <a  href="{{ url()->current() }}" class="btn btn-danger">Clear</a>
                                    <a href="javascript:window.print()" class="btn btn-info "><i class="fa fa-print"></i></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>{{$setting->app_name}}</h3>
                                        <p style="margin: 0">{{$setting->email}}</p>
                                        <p>
                                            <b>Agent Target And Achieve Sheet ( {{ date('M-Y', strtotime($last_month)) }} - {{ date('M-Y', strtotime($current_month)) }} )</b>
                                        </p>
                                    </address>
                                </div>

                            </div>
                        </div>
                        <br>

                        <style>
                            .tb_2{
                                margin-bottom: 0;
                            }
                            .tb_2 td{
                                border: none;
                            }
                            .table-striped tbody tr:nth-of-type(odd){
                                background: white;
                            }
                        </style>


                        <div class="table-responsive ">
                            <table class="table table-bordered w-100">
                                <thead>
                                <tr>
                                    <th class="font-weight-bold">No.</th>
                                    <th class="font-weight-bold"> Name</th>

                                    @foreach($month_range as $m_range)
                                        <th class="font-weight-bold">{{ date('F', strtotime($m_range)) }}</th>
                                    @endforeach

                                    <th class="font-weight-bold">Total</th>
                                </tr>
                                </thead>
                                <tbody>
                                <tr>
                                    <td></td>
                                    <td></td>

                                    @foreach($month_range as $m_range)
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr>
                                                    <td class="font-weight-bold" width="25%">Personal Target</td>
                                                    <td class="font-weight-bold" width="25%">Team Target</td>
                                                    <td class="font-weight-bold" width="25%">Personal Achieve</td>
                                                    <td class="font-weight-bold" width="25%">Team Achieve</td>
                                                </tr>
                                            </table>
                                        </td>
                                @endforeach


                                <!-- for total -->
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td class="font-weight-bold" width="22.5%">Personal Target</td>
                                                <td class="font-weight-bold" width="22.5%">Team Target</td>
                                                <td class="font-weight-bold" width="22.5%">Personal Achieve</td>
                                                <td class="font-weight-bold" width="22.5%">Team Achieve</td>
                                                <td class="font-weight-bold" width="10%">%</td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>

                                <tr style="background: #a6cbe1">
                                    <td></td>
                                    <td>IPOBiz</td>
                                    @foreach($month_range as $m_range)
                                        <td></td>
                                    @endforeach
                                    <td></td>

                                </tr>


                                    @foreach($users as $key => $user)
                                        <tr>
                                            <td>{{ $key+1 }}</td>
                                            <td><a href="{{ route('agent_target_report') }}?agent_id={{ $user->id }}&month=all&type=personal" target="_blank">{{ $user->name }}</a></td>

                                                                                        @foreach($month_range as $m_range)
                                                @php
                                                    $personal_target = agent_monthly_personal_target($user->id, $m_range);
                                                    $team_target = agent_monthly_team_target($user->id, $m_range);
                                                    $personal_achieve = agent_monthly_personal_achieve($user->id, $m_range);
                                                    $team_achieve = agent_monthly_team_achieve($user->id, $m_range);
                                                    $monthly_achieve = manager_monthly_achieve($user->id, $m_range);
                                                @endphp
                                                <td>
                                                    <table class="table tb_2" style="border: none">
                                                        <tr>
                                                            <td width="25%">{{ number_format($personal_target) }}</td>
                                                            <td width="25%">{{ number_format($team_target) }}</td>
                                                            <td width="25%"><a href="{{ route('agent_target_report') }}?agent_id={{ $user->id }}&month={{ $m_range }}&type=personal" target="_blank">{{ number_format($personal_achieve) }}</a></td>
                                                            <td width="25%"><a href="{{ route('agent_target_report') }}?agent_id={{ $user->id }}&month={{ $m_range }}&type=team" target="_blank">{{ number_format($team_achieve) }}</a></td>
                                                        </tr>
                                                    </table>
                                                </td>
                                                                                    @endforeach

                                        <!--total -->
                                            <td>
                                                <table class="table tb_2" style="border: none">

                                                    <tr>
                                                        <td width="22.5%">{{ number_format($sub_personal_target_amount) }}</td>
                                                        <td width="22.5%">{{ number_format($sub_team_target_amount) }}</td>
                                                        <td width="22.5%"> {{ number_format($sub_personal_achieve_amount) }}</td>
                                                        <td width="22.5%"> {{ number_format($sub_team_achieve_amount) }}</td>
                                                        <td width="10%"> {{ $sub_personal_target_amount != 0 && $sub_personal_achieve_amount != 0 ?  number_format($sub_personal_achieve_amount/($sub_personal_target_amount/100), 2) : 0 }}</td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>

                                    @endforeach


                                <tr style="background: #ff9595">
                                    <td></td>
                                    <td class="font-weight-bold text-right">GRAND TOTAL</td>
                                                                        @foreach($month_range as $m_range)
                                        @php
                                            $monthly_grand_total_target = agent_monthly_grand_total_target($m_range, $users);
                                            $monthly_total_personal_achieve = agent_monthly_grand_total_personal_achieve($m_range, $users);
                                            $monthly_total_team_achieve = agent_monthly_grand_total_team_achieve($m_range, $users);
                                        @endphp
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr style="background: #ff9595">
                                                    <td class="font-weight-bold" width="25%">{{ number_format($monthly_grand_total_target['grand_total_personal_sell']) }}</td>
                                                    <td class="font-weight-bold" width="25%">{{ number_format($monthly_grand_total_target['grand_total_team_sell']) }}</td>
                                                    <td class="font-weight-bold" width="25%"> {{ number_format($monthly_total_personal_achieve) }}</td>
                                                    <td class="font-weight-bold" width="25%"> {{ number_format($monthly_total_team_achieve) }}</td>
                                                </tr>
                                            </table>
                                        </td>
                                                                    @endforeach
                                <!-- total -->
                                    <td>
                                        <table class="table tb_2" style="border: none">
                                            <tr style="background: #ff9595">
                                                <td class="font-weight-bold" width="22.5%">{{ number_format($sub_personal_target_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="22.5%">{{ number_format($sub_team_target_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="22.5%"> {{ number_format($sub_personal_achieve_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="22.5%"> {{ number_format($sub_team_achieve_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="10%"> {{ $sub_personal_target_grand_total_amount != 0 && $sub_personal_achieve_grand_total_amount != 0 ?  number_format($sub_personal_achieve_grand_total_amount/($sub_personal_target_grand_total_amount/100), 2) : 0 }}</td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>

                                </tbody>
                            </table>
                        </div>

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

        </div><!--end row-->

    </div> <!-- container-fluid -->
    @push('alljs')
        <script src="{{asset('assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>

        <script type="text/javascript">
            $('#star_month').datepicker({
                format: "MM-yyyy",
                viewMode: "months",
                minViewMode: "months",
                autoclose:!0,
            });
            $('#end_month').datepicker({
                format: "MM-yyyy",
                viewMode: "months",
                minViewMode: "months",
                autoclose:!0,
            });
        </script>
    @endpush
@endsection