@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">
                        <div class="row">
                            <div class="col-md-6">
                                <h5>Manager 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" 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-2" style="margin-top: 25px;">
                                    <button class="btn btn-primary" type="submit">Search</button>
                                    <a  href="{{ url()->current() }}" class="btn btn-danger">Clear</a>
                                </div>
                            </div>
                        </form>
                        <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 --}}{{--id="datatable-buttons-alllist"--}}{{-- class="table table-striped table-bordered w-100">
                                <thead>
                                <tr>
                                    <th>No.</th>
                                    <th> Name</th>
                                    <th>{{ date('F', strtotime(\Carbon\Carbon::now()->addMonth(-1))) }}</th>
                                    <th>{{ date('F', strtotime(\Carbon\Carbon::now())) }}</th>
                                    <th>Total</th>
                                </tr>
                                </thead>
                                <tbody>
                                <tr>
                                    <td ></td>
                                    <td ></td>
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td width="33.33%">Target</td>
                                                <td width="33.33%">Incentive</td>
                                                <td width="33.33%">Achieve</td>
                                            </tr>
                                        </table>
                                    </td>
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td width="33.33%">Target</td>
                                                <td width="33.33%">Incentive</td>
                                                <td width="33.33%">Achieve</td>
                                            </tr>
                                        </table>
                                    </td>
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td width="33.33%">Target</td>
                                                <td width="33.33%">Incentive</td>
                                                <td width="33.33%">Achieve</td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                @foreach ($manager_teams as  $manager_team)



                                    <tr style="background: #a6cbe1">
                                        <td></td>
                                        <td>{{ $manager_team->name }}</td>
                                        <td></td>
                                        <td></td>
                                        <td></td>

                                    </tr>
                                    @foreach($manager_team->manager_team_user as $key => $team_user)
                                    <tr>
                                        <td>{{ $key+1 }}</td>
                                        <td>{{ $team_user->user_data->name }}</td>

                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr>
                                                    <td width="33.33%">{{ manager_monthly_target($team_user->user_id, 'current') }}</td>
                                                    <td width="33.33%">50.0</td>
                                                    <td width="33.33%">120</td>
                                                </tr>
                                            </table>
                                        </td>
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr>
                                                    <td width="33.33%">{{ manager_monthly_target($team_user->user_id, 'last') }}</td>
                                                    <td width="33.33%">50.0</td>
                                                    <td width="33.33%">120</td>
                                                </tr>
                                            </table>
                                        </td>
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr>
                                                    <td width="33.33%">{{ manager_monthly_target($team_user->user_id, 'current')+manager_monthly_target($team_user->user_id, 'last') }}</td>
                                                    <td width="33.33%">50.0</td>
                                                    <td width="33.33%"> 120</td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                    @endforeach

                                    <tr style="background: orange">
                                        <td></td>
                                        <td>CORPORATE ZONE TOTAL</td>
                                        <td>100</td>
                                        <td>100</td>
                                        <td>100</td>
                                    </tr>

                                @endforeach

                                </tbody>
                            </table>
                        </div>--}}


                        <div class="table-responsive">
                            <table class="table table-striped table-bordered w-100">
                                <thead>
                                <tr>
                                    <th>No.</th>
                                    <th> Name</th>
                                    <th>{{ date('F', strtotime($last_month)) }}</th>
                                    <th>{{ date('F', strtotime($current_month)) }}</th>
                                    <th>Total</th>
                                </tr>
                                </thead>
                                <tbody>
                                <tr>
                                    <td ></td>
                                    <td ></td>
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td width="33.33%">Target</td>
                                                <td width="33.33%">Incentive</td>
                                                <td width="33.33%">Achieve</td>
                                            </tr>
                                        </table>
                                    </td>
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td width="33.33%">Target</td>
                                                <td width="33.33%">Incentive</td>
                                                <td width="33.33%">Achieve</td>
                                            </tr>
                                        </table>
                                    </td>
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td width="30%">Target</td>
                                                <td width="30%">Incentive</td>
                                                <td width="30%">Achieve</td>
                                                <td width="10%">%</td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                @php
                                    //target
                                      $current_month_grand_total_target  = 0;
                                      $last_month_grand_total_target  = 0;
                                      //incentive
                                      $current_month_grand_total_incentive  = 0;
                                      $last_month_grand_total_incentive  = 0;
                                      //achieve
                                      $current_month_grand_total_achieve  = 0;
                                      $last_month_grand_total_achieve  = 0;

                                      $grand_total_target = 0;
                                      $grand_total_incentive = 0;
                                      $grand_total_achieve = 0;
                                @endphp
                                <tr style="background: #a6cbe1">
                                    <td></td>
                                    <td>IPOBiz</td>
                                    <td></td>
                                    <td></td>
                                    <td></td>

                                </tr>
                                @foreach ($manager_teams as  $manager_team)

                                    @php
                                        $current_month_total_target  = 0;
                                        $last_month_total_target  = 0;
                                        $current_month_total_incentive  = 0;
                                        $last_month_total_incentive  = 0;
                                        $current_month_total_achieve = 0;
                                        $last_month_total_achieve = 0;
                                        $total_target = 0;
                                        $total_incentive = 0;
                                        $total_achieve = 0;
                                    @endphp
                                    @foreach($manager_team->manager_team_user as $key => $team_user)
                                        <tr>
                                            <td>{{ $key+1 }}</td>
                                            <td>{{ $team_user->user_data->name }}</td>

                                            @php
                                                $current_month_target = manager_monthly_target($team_user->user_id, 'current', $current_month);
                                                $last_month_target = manager_monthly_target($team_user->user_id, 'last', $last_month);
                                                $current_month_achieve = manager_monthly_achieve($team_user->user_id, $current_month);
                                                $last_month_achieve = manager_monthly_achieve($team_user->user_id, $last_month);
                                            @endphp


                                            <td>
                                                <table class="table tb_2" style="border: none">
                                                    <tr>
                                                        <td width="33.33%">{{ number_format($last_month_target['target_amount']) }}</td>
                                                        <td width="33.33%">{{ number_format($last_month_target['incentive_amount']) }}</td>
                                                        <td width="33.33%">{{ number_format($last_month_achieve) }}</td>
                                                    </tr>
                                                </table>
                                            </td>

                                            <td>
                                                <table class="table tb_2" style="border: none">
                                                    <tr>
                                                        <td width="33.33%">{{ number_format($current_month_target['target_amount']) }}</td>
                                                        <td width="33.33%">{{ number_format($current_month_target['incentive_amount']) }}</td>
                                                        <td width="33.33%">{{ number_format($current_month_achieve) }}</td>
                                                    </tr>
                                                </table>
                                            </td>
                                            <td>
                                                <table class="table tb_2" style="border: none">
                                                    @php
                                                        $sub_total_target =  $current_month_target['target_amount']+$last_month_target['target_amount'];
                                                        $sub_total_incentive =  $current_month_target['incentive_amount']+$last_month_target['incentive_amount'];
                                                        $sub_total_achieve = $current_month_achieve+$last_month_achieve;
                                                    @endphp
                                                    <tr>
                                                        <td width="30%">{{ number_format($sub_total_target) }}</td>
                                                        <td width="30%">{{ number_format($sub_total_incentive) }}</td>
                                                        <td width="30%"> {{ number_format($sub_total_achieve) }}</td>
                                                        <td width="10%"> {{ $sub_total_target != 0 && $sub_total_achieve != 0 ?  number_format($sub_total_achieve/($sub_total_target/100), 2) : 0 }}</td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>
                                        @php
                                            //target
                                              $current_month_total_target  += $current_month_target['target_amount'];
                                              $last_month_total_target  += $last_month_target['target_amount'];
                                              //incentive
                                              $current_month_total_incentive  += $current_month_target['incentive_amount'];
                                              $last_month_total_incentive  += $last_month_target['incentive_amount'];
                                              //achieve
                                              $current_month_total_achieve  += $current_month_achieve;
                                              $last_month_total_achieve  += $last_month_achieve;
                                              //total_target
                                              $total_target += $sub_total_target;
                                              //total_incentive
                                              $total_incentive += $sub_total_incentive;
                                              //total_achieve
                                              $total_achieve += $sub_total_achieve;
                                        @endphp
                                    @endforeach

                                    <tr style="background: orange">
                                        <td></td>
                                        <td style="text-transform: uppercase">{{ $manager_team->name }} TOTAL</td>
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr style="background: orange">
                                                    <td width="33.33%">{{ number_format($last_month_total_target) }}</td>
                                                    <td width="33.33%">{{ number_format($last_month_total_incentive) }}</td>
                                                    <td width="33.33%"> {{ number_format($last_month_total_achieve) }}</td>
                                                </tr>
                                            </table>
                                        </td>
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr style="background: orange">
                                                    <td width="33.33%">{{ number_format($current_month_total_target) }}</td>
                                                    <td width="33.33%">{{ number_format($current_month_total_incentive) }}</td>
                                                    <td width="33.33%"> {{ number_format($current_month_total_achieve) }}</td>
                                                </tr>
                                            </table>
                                        </td>
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr style="background: orange">
                                                    <td width="30%">{{ number_format($total_target) }}</td>
                                                    <td width="30%">{{ number_format($total_incentive) }}</td>
                                                    <td width="30%"> {{ number_format($total_achieve) }}</td>
                                                    <td width="10%">{{ $total_target != 0 && $total_achieve != 0 ?  number_format($total_achieve/($total_target/100), 2) : 0 }}</td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>

                                    @php
                                        //target
                                        $current_month_grand_total_target  += $current_month_total_target;
                                        $last_month_grand_total_target  += $last_month_total_target;
                                        //incentive
                                        $current_month_grand_total_incentive += $current_month_total_incentive;
                                        $last_month_grand_total_incentive  += $last_month_total_incentive;
                                        //achieve
                                        $current_month_grand_total_achieve += $current_month_total_achieve;
                                        $last_month_grand_total_achieve  += $last_month_total_achieve;

                                        $grand_total_target +=$total_target;
                                        $grand_total_incentive +=$total_incentive;
                                        $grand_total_achieve += $total_achieve;
                                    @endphp

                                @endforeach

                                <tr style="background: #ff9595">
                                    <td></td>
                                    <td>GRAND TOTAL</td>
                                    <td>
                                        <table class="table tb_2" style="border: none">
                                            <tr style="background: #ff9595">
                                                <td width="33.33%">{{ number_format($last_month_grand_total_target) }}</td>
                                                <td width="33.33%">{{ number_format($last_month_grand_total_incentive) }}</td>
                                                <td width="33.33%"> {{ number_format($last_month_grand_total_achieve) }}</td>
                                            </tr>
                                        </table>
                                    </td>
                                    <td>
                                        <table class="table tb_2" style="border: none">
                                            <tr style="background: #ff9595">
                                                <td width="33.33%">{{ number_format($current_month_grand_total_target) }}</td>
                                                <td width="33.33%">{{ number_format($current_month_grand_total_incentive) }}</td>
                                                <td width="33.33%"> {{ number_format($current_month_grand_total_achieve) }}</td>
                                            </tr>
                                        </table>
                                    </td>
                                    <td>
                                        <table class="table tb_2" style="border: none">
                                            <tr style="background: #ff9595">
                                                <td width="30%">{{ number_format($grand_total_target) }}</td>
                                                <td width="30%">{{ number_format($grand_total_incentive) }}</td>
                                                <td width="30%"> {{ number_format($grand_total_achieve) }}</td>
                                                <td width="10%"> {{ $grand_total_target != 0 && $grand_total_achieve != 0 ?  number_format($grand_total_achieve/($grand_total_target/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"
            });
            $('#end_month').datepicker({
                format: "MM-yyyy",
                viewMode: "months",
                minViewMode: "months"
            });
        </script>
    @endpush
@endsection