@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;
        }

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

        td.dt-nowrap { white-space: nowrap }



        .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;}
    </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-sr-kpi-evaluation-report-excel?{{$queryString}}" class="btn add_button btn-line"><i class="fa fa-download"></i> <span>Export Excel</span></a>
                    <h2>Monthly SR KPI Evaluation <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 no-wrap display pb-30" style="width:100%;" id="monthlyReportTable" >
                                <thead>

                                <tr>
                                    <th>Employee ID</th>
                                    <th>Employee Name</th>
                                    <th>Employee Status</th>
                                    <th>Reporting To</th>
                                    <th>Segment</th>
                                    <th>Distribution</th>
                                    <th>Region</th>
                                    <th>Area</th>
                                    <th>Territory</th>
                                    <th>Assigned Shops</th>
                                    <th>UNIQ. Visited Shops</th>
                                    <th>Productive Shops</th>
                                    <th>UNIQ. Productivity</th>
                                    <th>SCH. Visits</th>
                                    <th>SCH. Productivity</th>
                                    <th>TTL. Visits</th>
                                    <th>TTL. Orders</th>
                                    <th>Visit Productivity</th>
                                    <th>Gross Booked Value</th>
                                    <th>Booked Units</th>
                                    <th>Booked CTNs/BNDLs</th>
                                    <th>NET Booked Value</th>
                                    <th>Gross Executed Value</th>
                                    <th>Executed Units</th>
                                    <th>Executed CTNs/BNDLs</th>
                                    <th>NET Executed Value</th>
                                    <th>Execution %</th>
                                    <th>Gross Spot Sale Value</th>
                                    <th>Spot Sale Units</th>
                                    <th>Spot Sale CTNs/BNDLs</th>
                                    <th>NET Spot Sale Value</th>
                                    <th>Gross Counter Sale Value</th>
                                    <th>Counter Sale Units</th>
                                    <th>Counter Sale CTNs/BNDLs</th>
                                    <th>NET Counter Sale Value</th>
                                    <th>TTL. Gross Sales Value</th>
                                    <th>TTL. Sales Units</th>
                                    <th>TTL. Sales CTNs/BNDLs</th>
                                    <th>TTL. NET Sales Value</th>
                                    @if($request->type == 'monthWise')
                                        <th>TTL. Target Units</th>
                                        <th>TTL. Target Units Value</th>
                                        <th>Achievement %</th>
                                        <th>Daily Run Rate</th>
                                        <th>Required Run Rate</th>
                                    @endif
                                    <th>AVG Bill Value</th>
                                    <th>AVG SKUs/Bill</th>
                                    <th>AVG Drop Size</th>
                                </tr>
                                </thead>
                                <tbody>
                                @if (collect($data['data'])->count()>0)
                                    @php $count = 0; @endphp
                                    @foreach (collect($data['data']) as $v)
                                        @if($v->sale_distributor_id > 0)
                                        <tr>
                                            <td>{{ $v->employee_id}}</td>
                                            <td>{{ $v->employee_name}}</td>
                                            <td>{{ $v->employee_status}}</td>
                                            <td>{{$v->reporting_to}}</td>
                                            <td>{{$v->segment}}</td>
                                            <td>{{$v->distributor_name}}</td>
                                            <td>{{($v->region)}}</td>
                                            <td>{{($v->area)}}</td>
                                            <td>{{($v->territory)}}</td>
                                            <td>{{number_format($v->assigned_shops)}}</td>
                                            <td>{{number_format($v->uniq_visited_outlets)}}</td>
                                            <td>{{number_format($v->productive_shops)}}</td>
                                            <td>{{number_format($v->assigned_shops > 0 && $v->productive_shops > 0 ? ($v->productive_shops/$v->assigned_shops)*100:0,2)}}</td>
                                            <td>{{number_format($v->scheduled_shops)}}</td>
                                            <td>{{number_format($v->schd_prod_shops > 0 && $v->scheduled_shops > 0 ? ($v->schd_prod_shops/$v->scheduled_shops)*100:0,2)}}</td>
                                            <td>{{number_format($v->visited_outlets)}}</td>
                                            <td>{{number_format($v->orders)}}</td>
                                            <td>{{number_format($v->orders > 0 && $v->visited_outlets > 0 ? ($v->orders/$v->visited_outlets)*100:0,2)}}</td>
                                            <td>{{number_format($v->booked_gross_value,2)}}</td>
                                            <td>{{number_format($v->booked_unit_sale)}}</td>
                                            <td>{{number_format($v->booked_ctn_sale,2)}}</td>
                                            <td>{{number_format($v->booked_sale_value,2)}}</td>
                                            <td>{{number_format($v->executed_gross_value,2)}}</td>
                                            <td>{{number_format($v->executed_unit_sale)}}</td>
                                            <td>{{number_format($v->executed_ctn_sale,2)}}</td>
                                            <td>{{number_format($v->executed_sale_value,2)}}</td>
                                            <td>{{number_format($v->executed_unit_sale > 0 && $v->booked_unit_sale > 0 ? ($v->executed_unit_sale/$v->booked_unit_sale)*100:0,2)}}</td>
                                            <td>{{number_format($v->spot_gross_value,2)}}</td>
                                            <td>{{number_format($v->spot_unit_sale)}}</td>
                                            <td>{{number_format($v->spot_ctn_sale,2)}}</td>
                                            <td>{{number_format($v->spot_sale_value,2)}}</td>
                                            <td>{{number_format($v->counter_gross_value,2)}}</td>
                                            <td>{{number_format($v->counter_unit_sale)}}</td>
                                            <td>{{number_format($v->counter_ctn_sale,2)}}</td>
                                            <td>{{number_format($v->counter_sale_value,2)}}</td>
                                            <td>{{number_format($v->net_gross_value,2)}}</td>
                                            <td>{{number_format($v->net_unit_sale)}}</td>
                                            <td>{{number_format($v->net_ctn_sale,2)}}</td>
                                            <td>{{number_format($v->net_sale_value,2)}}</td>
                                            @if($request->type == 'monthWise')
                                                @php
                                                    $tgt    =   TargetKPIsCalculation(date('Y-m-01', strtotime($request->date)),$v->ttl_target,$v->net_unit_sale); //required_run_rate
                                                @endphp
                                                <td>{{number_format($v->ttl_target)}}</td>
                                                <td>{{number_format($v->ttl_target_value,2)}}</td>
                                                @if($v->ttl_target == 0)
                                                    <td>NA</td>
                                                @else
                                                    <td>{{number_format($v->net_unit_sale > 0 && $v->ttl_target > 0 ?  ($v->net_unit_sale/$v->ttl_target)*100:0,2)}}%</td>
                                                @endif
                                                <td>{{$tgt->daily_run_rate}}</td>
                                                <td>{{$tgt->required_run_rate}}</td>
                                            @endif
                                            <td>{{number_format($v->avg_bill_value,2)}}</td>
                                            <td>{{number_format($v->avg_sku_per_order,2)}}</td>
                                            <td>{{number_format($v->avg_drop_size,2)}}</td>
                                        </tr>
                                        @endif
                                    @endforeach
                                @endif
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script>
        // $(function () {

        //     var table = $('#monthlyReportTable').DataTable({
        //         processing: true,
        //         serverSide: true,
        //         scrollX: true,
        //         ajax: "{{ route('testingResult') }}",
        //         columns: [
        //             {data: 'employee_id', name: 'employee_id'},
        //             {data: 'booker_lats', name: 'booker_lats'},
        //             {data: 'booker_longs', name: 'booker_longs'}
        //         ]
        //     });

        // });
        $('#monthlyReportTable').dataTable({
            "scrollX": true
        });
    </script>
@endsection