@extends('layouts.master')
@section('styles')
    <style>
        .topstats {
            margin-top: 10px;
            font-size: 13px;
            margin-bottom: -5px;
        }

        .topstats .gary-box {
            line-height: 1;
            background-color: #f9f9f9;
            border-bottom: solid 1px #d1d1d1;
            padding: 10px;
        }

        .no-wrap{
            white-space: nowrap !important;
        }
        .topstats .gary-box span {
            font-family: 'Rationale', sans-serif;
            color: #0038ba;
            font-size: 20px;
            float: right;
            margin-top: -4px;
        }



        .dis-slab-card{font-size: 13px; margin:0;}
        .dis-input{font-size: 13px; border: solid 1px #E8E8E8; width: 240px; height: 25px; padding-left:8px}
        .dis-input:focus{border: solid 1px #0038BA}
        .topsec{background-color: #F7F7F7; font-size: 14px; line-height: 25px; padding: 5px 0px; margin:0; border-bottom:solid 1px #0038BA; cursor: pointer}
        .topsec i{float:right; font-size:18px; line-height:25px; color:#a4a4a4}
        .bottomsec{background-color:#ededed;padding: 10px 15px;}
        .dis-slab-card .btn-primary{font-size: 13px; padding: 5px 12px; line-height:1; box-shadow: none;}
        .dis-slab-card .red-bg{border-color: #F12300; box-shadow: none;}
        .dis-slab-card .add-slab-btn{font-size: 14px; padding:5px 12px; height: 28px; letter-spacing: 1px; margin-left:10px;}
        .criteria-sh{padding-top: 10px; padding-bottom: 10px; border:solid 1px #F1F1F1; background-color: #F9F9F9 }
        .criteria-sh strong{padding-right: 10px;}
        table.dataTable thead{ display: none !important}
    </style>
@endsection
@section('content')
    <div class="row mt-2 mb-3">
        <div class="col-lg-6 col-md-6 col-sm-6">
            <h2 class="_head01">Report <span> Management</span></h2>
        </div>

        <div class="col-lg-6 col-md-6 col-sm-6">
            <ol class="breadcrumb">
                <li><a href="#"><span>Report</span></a></li>
                <li><span>List</span></li>
            </ol>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div class="card">

                <div class="header">
                    <a href="/generate-monthly-target-achievement-report-excel?{{$queryString}}" class="btn add_button btn-line"><i class="fa fa-download"></i> <span>Export Excel</span></a>
                    <h2>Monthly Target Achievement <span> Report</span></h2>
                </div>
                <div class="body body_table">
                    <div class="col-md-12 p-0">
                        <div class="table-wrap">
                            <table class="table table-hover display" style="width:100%;" id="monthlyReportTable" style="">
                                <thead>
                                <tr>
                                    <th rowspan="2" style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">SKU</th>
                                    <th rowspan="2" style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Product</th>
                                    <th rowspan="2" style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Brand</th>
{{--                                    <th rowspan="2" style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Unit Type</th>--}}
                                    @foreach($data['employees'] as $employee)
                                        <th colspan="6" style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;text-align: center">{{$employee->employee_first_name}} {{$employee->employee_last_name}}</th>
                                    @endforeach
                                    <th colspan="6" style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;text-align: center">Total Sales</th>
                                </tr>
                                <tr>
                                    @foreach($data['employees'] as $employee)
                                        <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Target</th>
                                        <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Target Value</th>
                                        <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Net Sales</th>
                                        <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Gross Value</th>
                                        <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Net Revenue</th>
                                        <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Ach%</th>
                                    @endforeach
                                    <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;"> Target</th>
                                    <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;"> Target Value</th>
                                    <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Net Sales</th>
                                    <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Gross Value</th>
                                    <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Net Revenue</th>
                                    <th style="border: solid 1px #fff !important; vertical-align: top; white-space: nowrap !important;">Ach%</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($data['items'] as $item)
                                    @php
                                        $t_net_sale      =    0;
                                        $t_gross_value   =    0;
                                        $t_net_revenue   =    0;
                                        $t_net_target    =    0;
                                        $t_net_target_v  =    0;
                                       // $unit            =    array_values(array_filter($data['data'], fn ($x) => $x->item_id == $item->item_id));
                                    @endphp
                                    <tr>
                                        <td>{{$item->item_sku}}</td>
                                        <td>{{$item->item_name}}</td>
                                        <td>{{$item->brand_name}}</td>
{{--                                        <td>{{@$unit[0]->unit_name}}</td>--}}
                                        @foreach($data['employees'] as $employee)
                                            @php
                                                $res             =    array_values(array_filter($data['data'], fn ($x) => $x->item_id == $item->item_id  && $x->employee_id == $employee->employee_id));
                                                $net_sale        =    (float)@$res[0]->net_sale;
                                                $gross_value     =    (float)@$res[0]->gross_value;
                                                $net_revenue     =    (float)@$res[0]->net_revenue;
                                                $tar             =    array_values(array_filter($data['targets'], fn ($x) => $x->item_id == $item->item_id  && $x->employee_id == $employee->employee_id));
                                                $net_target      =    (float)@$tar[0]->target;
                                                $net_target_v    =    (float)@$tar[0]->target_value;
                                                $achv            =    $net_sale==0 || $net_target==0 ? 0:($net_sale/$net_target)*100;

                                                $t_net_sale      +=    $net_sale;
                                                $t_gross_value   +=    $gross_value;
                                                $t_net_revenue   +=    $net_revenue;
                                                $t_net_target    +=     $net_target;
                                                $t_net_target_v  +=     $net_target_v;
                                                $t_achv          =     $t_net_sale==0 || $t_net_target==0 ? 0:($t_net_sale/$t_net_target)*100;
                                            @endphp
                                            <td>{{number_format($net_target,2)}}</td>
                                            <td>{{number_format($net_target_v,2)}}</td>
                                            <td>{{number_format($net_sale,2)}}</td>
                                            <td>{{number_format($gross_value,2)}}</td>
                                            <td>{{number_format($net_revenue,2)}}</td>
                                            <td>{{number_format($achv,2)}}%</td>
                                        @endforeach
                                        <td>{{number_format($t_net_target,2)}}</td>
                                        <td>{{number_format($t_net_target_v,2)}}</td>
                                        <td>{{number_format($t_net_sale,2)}}</td>
                                        <td>{{number_format($t_gross_value,2)}}</td>
                                        <td>{{number_format($t_net_revenue,2)}}</td>
                                        <td>{{number_format($t_achv,2)}}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script>
        {{--var data         = JSON.parse('{!! json_encode($data) !!}');--}}
        $("#table-th thead th").addClass("no-wrap");
        $('#monthlyReportTable').dataTable({
            "scrollX": true
        });
    </script>
@endsection