@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;}
  </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="/export-kpi-evaluation-report?{{$queryString}}" class="btn add_button btn-line"><i class="fa fa-download"></i> <span>Export Excel</span></a>
                <h2>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 display pb-30" style="width:100%;" id="monthlyReportTable">
                            <thead>
                            <tr>
                                <th rowspan="2">Region</th>
                                <th rowspan="2">Area/Zone</th>
                                <th rowspan="2">Territory</th>
                                <th rowspan="2">City</th>
                                <th rowspan="2">Distributor</th>
                                <th rowspan="2">SR Name</th>
                                <th rowspan="2">Joining Date</th>
                                <th colspan="7">Sales (In Unit)</th>
                                <th colspan="7">Sales (In Gross Value)</th>
                                <th colspan="4">Sale Calls</th>
                                <th colspan="5">Other KPIs</th>
                            </tr>
                            <tr style="height:14.4pt" height="19">
                                <th>Booking</th>
                                <th>Execution</th>
                                <th>Exec%</th>
                                <th>Spot Sales</th>
                                <th>Counter Sales</th>
                                <th>Target</th>
                                <th>Achievement %</th>
                                <th>Booking</th>
                                <th>Execution</th>
                                <th>Exec%</th>
                                <th>Spot Sales</th>
                                <th>Counter Sales</th>
                                <th>Target</th>
                                <th>Achievement %</th>
                                <th>Plan</th>
                                <th>Actual</th>
                                <th>Pro</th>
                                <th>Prod-Plan %</th>
                                <th>Drop Size (Units)</th>
                                <th>Avg Bill Value</th>
                                <th>Avg SKUs per Bill</th>
                                <th>Avg Time/ Shop</th>
                                <th>Avg Market hours/ Day</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach($data as $item)
                            <tr>
                                <td>{{ $item->region}}</td>
                                <td>{{ $item->area}}</td>
                                <td>{{ $item->territory}}</td>
                                <td>{{ $item->city}}</td>
                                <td>{{ $item->distributor_name}}</td>
                                <td>{{ $item->employee_name}}</td>
                                <td>{{ date('Y-m-d', strtotime($item->joining_date))}}</td>
                                <td>{{ number_format($item->booked_unit,2)}}</td>
                                <td>{{ number_format($item->exec_unit,2)}}</td>
                                <td>{{ number_format($item->exec_unit == 0 || $item->booked_unit == 0 ? 0 : ($item->exec_unit / $item->booked_unit)*100,2)}}%</td>
                                <td>{{ number_format($item->spot_unit,2)}}</td>
                                <td>{{ number_format($item->counter_unit,2)}}</td>
                                <td>{{ number_format($item->target,2)}}</td>
                                <td>{{ number_format($item->exec_unit == 0 || $item->target == 0 ? 0 : ($item->exec_unit / $item->target)*100,2)}}%</td>
                                <td>{{ number_format($item->booked_val,2)}}</td>
                                <td>{{ number_format($item->exec_val,2)}}</td>
                                <td>{{ number_format($item->exec_val == 0 || $item->booked_val == 0 ? 0 : ($item->exec_val / $item->booked_val)*100,2)}}%</td>
                                <td>{{ number_format($item->spot_val,2)}}</td>
                                <td>{{ number_format($item->counter_val,2)}}</td>
                                <td>{{ number_format($item->target_value,2)}}</td>
                                <td>{{ number_format($item->exec_val == 0 || $item->target_value == 0 ? 0 : ($item->exec_val / $item->target_value)*100,2)}}%</td>
                                <td>{{ number_format($item->planed_shops)}}</td>
                                <td>{{ number_format($item->visited_shops)}}</td>
                                <td>{{ number_format($item->productive_shops)}}</td>
                                <td>{{ number_format($item->planed_shops == 0 || $item->productive_shops == 0 ? 0 : ($item->planed_shops / $item->productive_shops)*100,2)}}%</td>
                                <td>{{ number_format($item->avg_drop_size,2)}}</td>
                                <td>{{ number_format($item->avg_bill_value,2)}}</td>
                                <td>{{ number_format($item->avg_sku_bill,2)}}</td>
                                <td>{{ $item->time_per_shop}}</td>
                                <td>{{ $item->avg_market_hours}}</td>
                            </tr>
                            @endforeach   
                            </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