@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>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 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="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>Manager 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-striped 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 text-center">{{ date('F', strtotime($m_range)) }}</th>
                                    @endforeach

                                    <th class="font-weight-bold text-center">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="33.33%">Target</td>
                                                    <td class="font-weight-bold" width="33.33%">Incentive</td>
                                                    <td class="font-weight-bold" width="33.33%">Achieve</td>
                                                </tr>
                                            </table>
                                        </td>
                                    @endforeach


                                    <!-- for total -->
                                    <td >
                                        <table class="table tb_2" style="border: none">
                                            <tr>
                                                <td class="font-weight-bold" width="30%">Target</td>
                                                <td class="font-weight-bold" width="30%">Incentive</td>
                                                <td class="font-weight-bold" width="30%">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 ($manager_teams as  $manager_team)

                                <tr>
                                    <td></td>
                                    <td class="text-center font-weight-bold" style="text-transform: uppercase">{{ $manager_team->name }}</td>
                                    @foreach($month_range as $m_range)
                                    <td></td>
                                    @endforeach
                                    <td></td>

                                </tr>

                                    @foreach($manager_team->manager_team_user as $key => $team_user)
                                        <tr>
                                            <td>{{ $key+1 }}</td>
                                            <td><a href="{{ route('manager_target_report') }}?member_id={{ $team_user->user_id }}&month=all" target="_blank">{{ $team_user->user_data->name }}</a></td>

                                                                                        @foreach($month_range as $m_range)
                                                @php
                                                    $monthly_data = manager_monthly_target_update($team_user->user_id, $m_range);
                                                    $monthly_achieve = manager_monthly_achieve($team_user->user_id, $m_range);
                                                @endphp
                                                <td>
                                                    <table class="table tb_2" style="border: none">
                                                        <tr >
                                                            <td width="33.33%">{{ number_format($monthly_data['target_amount']) }}</td>
                                                            <td width="33.33%">{{ number_format($monthly_data['incentive_amount']) }}</td>
                                                            <td width="33.33%"> <a href="{{ route('manager_target_report') }}?member_id={{ $team_user->user_id }}&month={{ $m_range }}&type=achieve" target="_blank">{{ number_format($monthly_achieve) }}</a></td>
                                                        </tr>
                                                    </table>
                                                </td>
                                                                                        @endforeach

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

                                                    <tr >
                                                        <td width="30%">{{ number_format($sub_target_amount) }}</td>
                                                        <td width="30%">{{ number_format($sub_incentive_amount) }}</td>
                                                        <td width="30%"> {{ number_format($sub_achieve_amount) }}</td>
                                                        <td width="10%"> {{ $sub_target_amount != 0 && $sub_achieve_amount != 0 ?  number_format($sub_achieve_amount/($sub_target_amount/100), 2) : 0 }}</td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>

                                        @foreach($team_user->child as $key_2 => $cld)
                                            <tr>
                                                <td>{{ $key+1 }}</td>
                                                <td><a style="color:red" href="{{ route('manager_target_report') }}?member_id={{ $cld->user_id }}&month=all" target="_blank">{{ $cld->user_data->name }}</a></td>

                                                                                                @foreach($month_range as $m_range)
                                                    @php
                                                        $monthly_data = manager_monthly_target_update($cld->user_id, $m_range);
                                                        $monthly_achieve = manager_monthly_achieve($cld->user_id, $m_range);
                                                    @endphp
                                                    <td>
                                                        <table class="table tb_2" style="border: none">
                                                            <tr >
                                                                <td width="33.33%">{{ number_format($monthly_data['target_amount']) }}</td>
                                                                <td width="33.33%">{{ number_format($monthly_data['incentive_amount']) }}</td>
                                                                <td width="33.33%"> <a href="{{ route('manager_target_report') }}?member_id={{ $cld->user_id }}&month={{ $m_range }}&type=achieve" target="_blank">{{ number_format($monthly_achieve) }}</a></td>
                                                            </tr>
                                                        </table>
                                                    </td>
                                                                                            @endforeach

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

                                                        <tr >
                                                            <td width="30%">{{ number_format($sub_target_amount) }}</td>
                                                            <td width="30%">{{ number_format($sub_incentive_amount) }}</td>
                                                            <td width="30%"> {{ number_format($sub_achieve_amount) }}</td>
                                                            <td width="10%"> {{ $sub_target_amount != 0 && $sub_achieve_amount != 0 ?  number_format($sub_achieve_amount/($sub_target_amount/100), 2) : 0 }}</td>
                                                        </tr>
                                                    </table>
                                                </td>
                                            </tr>
                                        @endforeach

                                    @endforeach

                                    <tr>
                                        <td></td>
                                        <td class="text-right font-weight-bold" style="text-transform: uppercase">TOTAL</td>
                                                                                @foreach($month_range as $m_range)
                                            @php
                                                $monthly_total_data = manager_monthly_total_target($manager_team->id,$m_range);
                                                $monthly_total_achieve = manager_monthly_total_achieve($manager_team->id, $m_range);
                                            @endphp
                                            <td>
                                                <table class="table tb_2" style="border: none">
                                                    <tr>
                                                        <td class="font-weight-bold" width="33.33%">{{ number_format($monthly_total_data['target_total_amount']) }}</td>
                                                        <td class="font-weight-bold" width="33.33%">{{ number_format($monthly_total_data['incentive_total_amount']) }}</td>
                                                        <td class="font-weight-bold" width="33.33%"> {{ number_format($monthly_total_achieve) }}</td>
                                                    </tr>
                                                </table>
                                            </td>
                                                                                    @endforeach
                                        <!-- total -->
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr>
                                                    <td class="font-weight-bold" width="30%">{{ number_format($sub_target_total_amount) }}</td>
                                                    <td class="font-weight-bold" width="30%">{{ number_format($sub_incentive_total_amount) }}</td>
                                                    <td class="font-weight-bold" width="30%">{{ number_format($sub_achieve_total_amount) }}</td>
                                                    <td class="font-weight-bold" width="10%">{{ $sub_target_total_amount != 0 && $sub_achieve_total_amount != 0 ?  number_format($sub_achieve_total_amount/($sub_target_total_amount/100), 2) : 0 }}</td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>

                                @endforeach

                                <tr style="background: #ff9595">
                                    <td></td>
                                    <td class="text-right font-weight-bold">GRAND TOTAL</td>
                                                                        @foreach($month_range as $m_range)
                                        @php
                                            $monthly_grand_total_data = manager_monthly_grand_total_target($m_range);
                                            $monthly_grand_total_achieve = manager_monthly_grand_total_achieve($m_range);
                                        @endphp
                                        <td>
                                            <table class="table tb_2" style="border: none">
                                                <tr style="background: #ff9595">
                                                    <td class="font-weight-bold" width="33.33%">{{ number_format($monthly_grand_total_data['target_grand_total_amount']) }}</td>
                                                    <td class="font-weight-bold" width="33.33%">{{ number_format($monthly_grand_total_data['incentive_grand_total_amount']) }}</td>
                                                    <td class="font-weight-bold" width="33.33%"> {{ number_format($monthly_grand_total_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="30%">{{ number_format($sub_target_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="30%">{{ number_format($sub_incentive_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="30%"> {{ number_format($sub_achieve_grand_total_amount) }}</td>
                                                <td class="font-weight-bold" width="10%"> {{ $sub_target_grand_total_amount != 0 && $sub_achieve_grand_total_amount != 0 ?  number_format($sub_achieve_grand_total_amount/($sub_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